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

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)