When you create a master-detail relation, Oracle Forms generates different triggers depending on how the Delete Record Behavior and Coordination properties are set. The following table shows how the Delete Record Behavior property determines which triggers Oracle Forms creates. When you change the setting of the Delete Record Behavior property for an existing relation, Oracle Forms adds or removes triggers as needed. The actual code in these triggers depends on how the Coordination properties are set, and on whether the relation is part of a complex relation chain.
Delete Record Behavior Property |
Resulting Triggers |
---|---|
Non-Isolated (the default) |
On-Check-Delete-Master, On-Clear-Details, On-Populate-Details |
Cascading |
On-Clear-Details, On-Populate-Details, Pre-Delete |
Isolated |
On-Clear-Details, On-Populate-Details |