APPS.FND_IREP_LOADER_PRIVATE dependencies on FND_CHILD_ANNOTATIONS

Line 404: Delete from FND_CHILD_ANNOTATIONS

400: Delete from FND_LOOKUP_ASSIGNMENTS
401: where obj_name = 'FND_IREP_CLASSES'
402: and INSTANCE_PK1_VALUE = to_char(key_id);
403:
404: Delete from FND_CHILD_ANNOTATIONS
405: where parent_id = key_id
406: and parent_flag = 'C';
407:
408: Delete from FND_IREP_USES_TABLES

Line 422: Delete from FND_CHILD_ANNOTATIONS

418: (select function_id
419: from FND_FORM_FUNCTIONS
420: where irep_class_id = key_id);
421:
422: Delete from FND_CHILD_ANNOTATIONS
423: where parent_flag = 'F'
424: and parent_id in
425: (select function_id
426: from FND_FORM_FUNCTIONS

Line 509: Delete from FND_CHILD_ANNOTATIONS

505: Delete from FND_LOOKUP_ASSIGNMENTS
506: where obj_name = 'FND_OBJECTS'
507: and INSTANCE_PK1_VALUE = to_char(key_id);
508:
509: Delete from FND_CHILD_ANNOTATIONS
510: where parent_id = key_id
511: and parent_flag = 'O';
512:
513: Delete from FND_OBJECT_TYPE_MEMBERS

Line 780: Insert into FND_CHILD_ANNOTATIONS

776: from FND_IREP_CLASSES
777: where class_name = P_OBJECT_NAME;
778: end if;
779:
780: Insert into FND_CHILD_ANNOTATIONS
781: (PARENT_ID, PARENT_FLAG, CHILD_FLAG, ANNOTATION_VALUE)
782: select key_id, P_DEST_TABLE, UPPER(P_CHILD_FLAG), P_VALUE
783: from dual;
784: end;

Line 1274: Insert into FND_CHILD_ANNOTATIONS

1270: if PARENT_IS_OBSOLETE(P_DEST_TABLE, P_OBJECT_NAME) then
1271: return;
1272: end if;
1273:
1274: Insert into FND_CHILD_ANNOTATIONS
1275: (PARENT_ID, PARENT_ID2, PARENT_FLAG, CHILD_FLAG, ANNOTATION_VALUE)
1276: select f.function_id, P_OVERLOAD_SEQ, 'F', UPPER(P_CHILD_FLAG), P_VALUE
1277: from FND_IREP_CLASSES C,
1278: FND_FORM_FUNCTIONS F