Monday, October 23, 2017

Master/Detail Triggers in Oracle Forms

Oracle Forms generates master/detail triggers automatically when a master/detail relation is defined between database blocks. The default master/detail triggers enforce coordination between records in a detail block and the master record in a master block.

On-Check-Delete-Master:- Fires when Oracle Forms attempts to delete a record in a block that is a
master block in a Master-Detail relation.
On-Clear-Details:- Fires when Oracle Forms needs to clear records in a block that is a detail block in a Master-Detail relation because those records no longer correspond to the current record in the master block.
On-Populate-Details:- Fires when Oracle Forms needs to fetch records into a block that is the detail
block in a Master/Detail relation so that detail records are synchronized with the current record in the
master block.

No comments:

Post a Comment

currentAppUi built in variable in VBCS

$global.currentAppUi.id :- The id of the App UI $global.currentAppUi.urlId :-The id of the App UI as shown in the URL $global.currentAppUi.d...