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

Query to get the list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name ,      ttl.formula_type_name ,      ttl.description ,      c.base_context_name from   ff_formula_types_b t ,...