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

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...