QAFE

Oracle Forms elements conversion cheatsheet

In the table below you’ll find the original Oracle Forms elements and their respective elementsĀ in the output code.

Oracle Form Element QAFE Conversion ADF Conversion
Form Triggers
  • Database Procedures
  • Business Actions, Integration-Tier Methods, Call Statements
  • Events Invoking Business Actions with Proper IN/OUT values
  • WHEN-NEW-FORM-INSTANCE & PRE-FORM called form onload
  • Database Procedures
Window
  • QAFE Window
  • JSF Fragments
Canvas
  • Panel Definitions / Panels
  • panelGroupLayout
Block
  • Database Object Types
  • Block Name used as group-name to connect Items in block
  • Database Object Types
  • Entity Object
  • View Object
Database Blocks CRUD operations
  • Select, Insert, Update, Delete statements based on Block properties
  • Business Actions and Integration-Tier methods
  • Entity Object
  • View Object
Master-Detail Relation
  • Select statement for Detail block based on Relation
  • Business Actions and Integration-Tier methods
  • Association
Single & Multi Record Block
  • QAFE Components / Data-Grids
  • View Object (FetchSize)
  • ADF Components
  • ADF Table
Non- Database Block
  • Database Object Types
  • View Object
Block Triggers
  • Database Procedures
  • Business Actions, Integration-Tier Methods, Call Statements
  • Events Invoking Business Actions with Proper IN/OUT values
  • POST-QUERY trigger Invoking
  • Database Procedures
  • POST-QUERY trigger handling
Items
  • QAFE Component equivalent of Oracle Form Item Type
  • Item generated based on its Properties(Canvas, X Position, Y Position, Width, Height, Enabled, Visible)
  • ADFComponent equivalent of Oracle Form Item Type
  • Item generated based on its Properties(Canvas, X Position, Y Position, Width, Height, Enabled, Visible)
Item Triggers
  • Database Procedures
  • Business Actions, Integration-Tier Methods, Call Statements
  • Events Invoking Business Actions with Proper IN/OUT values
  • Database Procedures
  • VALIDATION-TRIGGER handling
LOV
  • Panel Definition
  • Events
  • View Object
  • ADF inputListOfValues
  • LOVHandlerBean (used when input parameters reside in another block)
Record Groups
  • Select Statements
  • ViewObjects
Graphics
  • Labels
  • Panels
  • ADF outputLabel
  • ADF panelGroupLayout
Parameters
  • Database Object Types
  • Grouped Components
  • Used as IN/OUT for triggers
  • Database Object Types
Global Variables
  • QAFE global variables when using trigger
Program Units
  • Database Procedures
  • Business Actions, Integration-Tier Methods, Call Statements
  • Database Procedures
OLB
  • Used during conversion for Items
  • Used during conversion for Items
PLL
  • Processed as script
  • Processed as script
Parent Form
  • Processed
  • Processed
Visual Attributes
  • Width, height, Graphics Text, etc. are handled.
  • Width, height, Graphics Text, etc. are handled.
Search
  • Optional through wizard
  • Optional through wizard