Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on BUSINESS_UNIT reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
| PARENT_REFERENCE | Nullify reference, if BUSINESS_UNIT deleted |
Impact on child element types if BUSINESS_UNIT is deleted
| Impact on children | Via child reference property |
| Nullify reference on BUSINESS_UNIT | BUSINESS_UNIT.PARENT_REFERENCE |
| Cascade delete BUSINESS_UNIT_TO_OBJECTIVES | BUSINESS_UNIT_TO_OBJECTIVE.BUSINESS_UNIT_REFERENCE |
| Cascade delete BUSINESS_UNIT_TO_PROBLEMS | BUSINESS_UNIT_TO_PROBLEM.BUSINESS_UNIT_REFERENCE |
| Cascade delete DIAGRAM_ELEMENT_USAGES | DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE |
| Cascade delete DOCUMENT_ATTACHMENTS | DOCUMENT_ATTACHMENT.ELEMENT_REFERENCE |
| Cascade delete EXTENDED_STRUCTURE_ELEMENTS | EXTENDED_STRUCTURE_ELEMENT.PART_OF_REFERENCE |
| Cascade delete EXTENDED_STRUCTURE_ELEMENTS | EXTENDED_STRUCTURE_ELEMENT.USE_OF_REFERENCE |
| Cascade delete FOLDER_MEMBERS | FOLDER_MEMBER.MEMBER_OBJECT |
| Cascade delete SET_MEMBER_ITEMS | SET_MEMBER_ITEM.ELEMENT_REFERENCE |
| Block, if BUSINESS_UNIT_USE_OF_NODES exist | BUSINESS_UNIT_USE_OF_NODE.BUSINESS_UNIT_REFERENCE |
| Block, if DATASTORES exist | DATASTORE.BUSINESS_UNIT_REFERENCE |
| Block, if ENTITY_BUSINESS_UNITS exist | ENTITY_BUSINESS_UNIT.BUSINESS_UNIT_REFERENCE |
| Block, if EXTERNALS exist | EXTERNAL.BUSINESS_UNIT_REFERENCE |
| Block, if FUNCTION_BUSINESS_UNITS exist | FUNCTION_BUSINESS_UNIT.BUSINESS_UNIT_REFERENCE |
| Block, if MODULE_BUSINESS_UNITS exist | MODULE_BUSINESS_UNIT.BUSINESS_UNIT_REFERENCE |
| Block, if PLANNING_ITEMS exist | PLANNING_ITEM.BUSINESS_UNIT_REFERENCE |