Oracle 11g Fusion Forms Development

Introduction

• Forms Builder Overview
• Invoking Forms Builder
• Customizing the Forms Builder Session
• Property Palettes

Getting Started

• Building a basic Form
• Forms Runtime Overview
• Forms Object structure
• Object Navigator
• Block concepts
• Block data sources
• Data Block Wizard (using a stored procedure)
• Layout/Chart/LOV wizard

Formatting a Form

• Layout Editor
• Formatting Tools
• Visual Attributes
• Working with Frames
• Working with Canvases
• Property Classes

Multiple Block Forms

• Creating forms based on multiple blocks
• Building Block Relationships
• Relationship properties

Windows and Canvases

• Stacked Canvases
• Toolbar Canvases
• Tab Canvases
• Window Properties
• Items
• Check Boxes
• Radio Groups
• Primary Key Display Items
• Foreign Key Display Items
• Synchronized Display Items
• Calculated Items
• Summary Items
• Retrieving Image Items
• Storing Images in the database
• Buttons
• JavaBean area

Reports

• Create Report Objects based on a block
• Report Object Properties
• Run Existing Reports using Run Product Building
• Parameter Lists to Run Reports

 
Data Lists

• List Items
• Simple LOV
• Multiple column LOV
• LOV Properties
• Populating list items with Record Groups
• Creating record groups programmatically

PL/SQL in Forms

• Program Units
• PL/SQL Libraries
• Forms Triggers
• Forms Built Ins
• The Navigation Unit
• Basing a Form on a stored procedure
• Using Debug Alerts

Navigating through Form Applications

• Forms Parameters
• Global Variables
• Call/Open/New/Go Form

Menus

• Basic Menu Modules
• Popup Menus

Control Objects & Interface

• Items
• Property Palette
• Renamed Properties
• New Properties
• Prompt Orientation
• Query All Records Block
• Property
• ToolTips Property
• Calculated Fields
• Formula/Summary Calculations
• Tab Canvasses
• Stacked canvas enhancements
• Frames Visual Attribute Enhancements
• Graphic Object Functionality
• Sound items
• Images

Forms Events & PL/SQL

• Triggers
• System Variables
• Built-in Subprograms
• Dynamic SQL
• Default Keyword
• Composite Data types
• PL/SQL Records
• PL/SQL Tables
• Combining PL/SQL Records and Tables

Development Techniques

• Smart Triggers
• Commit Triggers
• Object Sub-classing
• Object Libraries
• Smart Classes
• Template Forms
• Building Hierarchy Trees
• PL/SQL Editor Enhancements
• Using Dynamic PL/SQL
• Using Pluggable Java Components (PJC’s).
• Client interaction with WebUtil  
• Array DML Processing
• Testing the Results of Trigger DML
• DML Statements Issued during Commit Processing
• Overriding Default Transaction Processing
• Getting and Setting the Commit Status

Writing Flexible Code

• Using System Variables for Flexible Coding
• Using Built-in Subprograms for Flexible Coding
• Copying and Subclassing Objects and Code
• Referencing Objects by Internal ID
• Referencing Items Indirectly

Sharing Objects and Code

• Reusable Objects and Code Strategy
• Property Classes
• Object Groups
• Copying and Subclassing Objects and Code
• Object Libraries
• Working with SmartClasses
• Reusing PL/SQL
• PL/SQL Libraries

Using WebUtil to Interact with the Client

• Benefits of WebUtil
• Integrating WebUtil
• Interacting with the Client

Multiple Form Applications

• Starting Another Form Module
• Defining Multiple Form Functionality
• Sharing Data among Modules