Oracle Forms

Master – Detailed Relationships:

Non-Isolated This is the default setting. It presents the deletion of a Master record when an associated Detail record exists in the database.
Isolated It allows deletion of Master record without affecting associated Detail records in the database.
Cascading It allows Master record to be deleted and automatically deletes any associated detail records.

Relation Properties:

Co-Ordination Property: (Default: Non-Isolated)

Deffered Auto Query Result
N N/Y Detail records populate automatically whenever we query the master record
Y N Explicitly execute the function “Execute Query” to populate detail block
Y Y Whenever Control focus on details block records will populate

Delete Record Behavior (Default: Non-Isolated)

Triggers Created Behavior
Cascading Form Level: On_Clear_Details
Block Level:
Pre-Delete
On-Populate-Details
Allows the master record to be deleted and automatically deletes any associated detail records in the detail block's base table at commit time
Isolated Form Level: On Clear Details
Block Level:
On-Populate-Details
Allows the master record to be deleted and does not affect associated detail records in the database
Non-Isolated Form Level: On Clear Details
Block Level:
On-Check-Delete-Master
On-Populate-Details
Prevents the deletion of a master record when associated detail records exist in the database

List Item:

      A list item is a list of text elements that can be displayed as a poplist, Tlist, or combo box.

Poplist The poplist style list item appears initially as a single field (similar to a text item field). When the end user selects the list icon, a list of available choices appears.
Tlist The Tlist style list item appears as a rectangular box which displays a fixed number of values. When the Tlist contains values that cannot be displayed (due to the displayable area of the item), a vertical scroll bar appears, allowing the end user to view and select undisplayed values.
Combo Box The combo box style list item combines the features found in poplists and text items. It displays fixed values and can accept a user-entered value.

Parameters:

      The parameter Object is used for defining and setting input values required by Form during start up. There are two types of parameters.

  • Text Parameter:      Text Parameters are used to pass values between Forms.
  • Data Parameter:      Data Parameters are used to pass values between Forms and other Oracle related products like Oracle Reports, Oracle Graphics.

      Parameters are passed to called forms by means of a parameter list. A parameter list is a named programmatic construct that is simply a list of parameter names (called keys) and their values.You can pass parameter values to forms invoked by the built-in subprograms CALL_FORM, OPEN_FORM, and NEW_FORM. In addition, you can pass parameter values to other Oracle tools with the RUN_PRODUCT procedure.

      A parameter you include in a parameter list can be either a text parameter or a data parameter. The parameter type determines how its value is interpreted.

Text Parameters The value of a text parameter being passed to a called product is a CHAR string that can represent the following:
a user-defined form parameter defined in a form invoked by the CALL_FORM, OPEN_FORM, or NEW_FORM built-in subprograms a command line or user-defined parameter for a product invoked with the RUN_PRODUCT built-in subprogram
Data Parameters The value of a data parameter being passed to a called product is always the name of a record group defined in the current form. (A record group is a data structure that stores records derived from a query or through programmatic assignment.) Data parameters are used to pass data to products invoked with the RUN_PRODUCT built-in subprogram. You cannot pass data parameters to forms.

      PROCEDURE RUN_PRODUCT (product NUMBER, module VARCHAR2, commmode NUMBER, execmode NUMBER, location NUMBER, paramlist_id VARCHAR2, display VARCHAR2);

Commmode:

SYNCHRONOUS specifies that control returns to Form Builder only after the called product has been exited. The end user cannot work in the form while the called product is running.
ASYNCHRONOUS specifies that control returns to the calling application immediately, even if the called application has not completed its display.

                                                                                                                             Previous     Next