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