Monday, October 23, 2017

Block Processing Triggers in Oracle Forms

Block processing triggers fire in response to events related to record management in a block.

When-Create-Record:- Perform an action whenever Oracle Forms attempts to create a new record in a block. For example, to set complex, calculated, or data-  driven default values that must be specified at run time, rather than design time.
When-Clear-Block:- Perform an action whenever Oracle Forms flushes the current block; that is,
removes all records from the block.
When-Database-Record:- Perform an action whenever Oracle Forms changes a record’s status to Insert or Update, thus indicating that the record should be processed by the next COMMIT_FORM operation.

When-Remove-Record:-  Perform an action whenever a record is cleared or deleted.

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)