DBA Data[Home] [Help]

APPS.DELETE_FROM_IREP dependencies on FND_CHILD_ANNOTATIONS

Line 61: Delete from FND_CHILD_ANNOTATIONS

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

Line 83: Delete from FND_CHILD_ANNOTATIONS

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

Line 205: Delete from FND_CHILD_ANNOTATIONS

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