Tuesday 2 April 2013

Master-Detail Relation in Oracle Form

Isolated: Masters can be deleted when Child is existing.
Non- Isolated: Masters cannot be deleted when Child is existing.
Cascading: Child Record Automatically Deleted when Masters is deleted.

On-Check-Delete-Master:
Fires when Form Builder attempts to delete a record in a block that is a master block in a master-detail relation.

On-Clear-Details:
Fires when Form Builder 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 Form Builder 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.

Properties
Triggers
Trigger Level
Procedure
Isolated
On Populate details      
On Clear Details           
Block                    Form
Check Package Failure
Clear all master Detail
Query Master Detail                  

Non- Isolated
On Populate details         On Check Delete master    On Clear Details                       

Block                 Block                            Form   
Check Package Failure
Clear all master Detail
Query Master Detail                  

Cascading
On Populate details         Pre Delete
On Clear Details                       

Block                 Block                            Form   
Check Package Failure
Clear all master Detail
Query Master Detail                  




No comments:

Post a Comment