Oracle Developer Suite

Oracle Forms Developer - Introduction
Oracle Application Server 10g Architecture
Running a Forms Developer Application

Forms Modules
Basic and Master-Detail Forms Module
Data Block and Layout

Data Blocks and Frames
Using the Property Palette and Managing Object Properties
Describe Visual Attributes
Controlling the Behavior and Appearance of Data Blocks
Controlling Frame Properties
Creating Control Blocks
Deleting Data Blocks

Input Items
Text Items - Behavior and Appearance
LOVs and Editors
Check Boxes, List Items and Radio Groups

Non Input Items
Describe Display Item, Image Item, Push Button, Calculated Item, Hierarchical Tree Item and Bean Area Item

Canvases and Windows
Overview
Displaying a Forms Module in Multiple Windows
Creating a New Window
Displaying a Forms Module on Multiple Layouts
Canvas types - Content Canvas, New Stacked Canvas, Toolbar Canvas, and Tab Canvas

Triggers
Trigger Categories and Trigger Components: Type, Code, and Scope
Trigger Execution Hierarchy
PL/SQL Editor
Explain Trigger Code
Explain Variables and Built-ins
Commonly used triggers When-Button-Pressed and When-Window-Closed Triggers

Debugging Triggers
Debugging Process and Debug Console
Breakpoints and Debugging Tips
Running a Form in Debug Mode and stepping through Code

Adding Functionality to Items
Coding Item Interaction Triggers
Defining Functionality for Check Boxes
Changing List Items at Run Time
Displaying LOVs from Buttons
Populating Image Items

Run-Time Messages and Alerts

Built-ins and Handling Errors
System Messages
The FORM_TRIGGER_FAILURE Exception
Creating and Controlling Alerts
Handling Server Errors

Query Triggers
SELECT Statements during Query Processing
WHERE and ORDER BY Clauses and the ONETIME_WHERE Property
Query Triggers and Query Array Processing
Triggers for Enter-Query Mode
Overriding Default Query Processing
Getting Query Information at Run Time

Validation
Overview
Validation Using Properties
Validation Using Triggers
Client-Side Validation with PJCs
Knowing the Validation Status
Using Built-ins to Control When Validation Occurs

Navigation
Overview
Internal Navigation
Object Properties to Control Navigation
Navigation Triggers: When-New--Instance, Pre- and Post- Triggers
The Navigation Trap
Navigation Built-ins in Triggers

Transaction Processing
Commit Sequence of Events
Commit Triggers
Testing the Results of Trigger DML
Overriding Default Transaction Processing
Getting and Setting the Commit Status
Implementing Array DML

Flexible Code – How to
Overview
System Variables for Flexible Coding
Built-in Subprograms for Flexible Coding
Referencing Objects by Internal ID
Referencing Items Indirectly

Objects and Code sharing
Object Libraries and SmartClasses
PL/SQL Libraries