Delete Record Behavior (Default: Non-Isolated)

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 DetailsBlock 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 DetailsBlock Level:On-Check-Delete-MasterOn-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.