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 Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...