57: Delete from FND_LOOKUP_ASSIGNMENTS
58: where obj_name = 'FND_IREP_CLASSES'
59: and INSTANCE_PK1_VALUE = to_char(key_id);
60:
61: Delete from FND_CHILD_ANNOTATIONS
62: where parent_id = key_id
63: and parent_flag = 'C';
64:
65: Delete from FND_IREP_USES_TABLES
79: (select function_id
80: from FND_FORM_FUNCTIONS
81: where irep_class_id = key_id);
82:
83: Delete from FND_CHILD_ANNOTATIONS
84: where parent_flag = 'F'
85: and parent_id in
86: (select function_id
87: from FND_FORM_FUNCTIONS
201: Delete from FND_LOOKUP_ASSIGNMENTS
202: where obj_name = 'FND_OBJECTS'
203: and INSTANCE_PK1_VALUE = to_char(key_id);
204:
205: Delete from FND_CHILD_ANNOTATIONS
206: where parent_id = key_id
207: and parent_flag = 'O';
208:
209: Delete from FND_OBJECT_TYPE_MEMBERS