APPS.FND_IREP_LOADER_PRIVATE dependencies on FND_LOOKUP_ASSIGNMENTS

Line 400: Delete from FND_LOOKUP_ASSIGNMENTS

396:
397: Delete from FND_IREP_CLASS_PARENT_ASSIGNS
398: where CLASS_NAME = P_OBJECT_NAME;
399:
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

Line 415: Delete from FND_LOOKUP_ASSIGNMENTS

411: Delete from FND_IREP_USES_MAPS
412: where CLASS_ID = key_id;
413:
414: -- remove method subentities
415: Delete from FND_LOOKUP_ASSIGNMENTS
416: where obj_name = 'FND_IREP_FUNCTION_FLAVORS'
417: and INSTANCE_PK1_VALUE in
418: (select function_id
419: from FND_FORM_FUNCTIONS

Line 505: Delete from FND_LOOKUP_ASSIGNMENTS

501: -- remove object subentities
502: Delete from FND_OBJECT_KEY_SETS
503: where object_id = key_id;
504:
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

Line 732: Insert into FND_LOOKUP_ASSIGNMENTS

728: from FND_IREP_CLASSES
729: where class_name = P_OBJECT_NAME;
730: end if;
731:
732: Insert into FND_LOOKUP_ASSIGNMENTS
733: (OBJ_NAME, INSTANCE_PK1_VALUE,
734: LOOKUP_TYPE, LOOKUP_CODE, LOOKUP_ASSIGNMENT_ID,
735: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
736: LAST_UPDATE_LOGIN, DISPLAY_SEQUENCE)

Line 739: P_TYPE, P_CODE, FND_LOOKUP_ASSIGNMENTS_S.nextval,

735: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
736: LAST_UPDATE_LOGIN, DISPLAY_SEQUENCE)
737: select DECODE(P_DEST_TABLE, 'C', 'FND_IREP_CLASSES', 'FND_OBJECTS'),
738: key_id,
739: P_TYPE, P_CODE, FND_LOOKUP_ASSIGNMENTS_S.nextval,
740: f_luby, f_ludate, f_luby, f_ludate,
741: 0, P_SEQUENCE
742: from dual;
743: end;

Line 1236: Insert into FND_LOOKUP_ASSIGNMENTS

1232: begin -- UPLOAD METHOD_CATEGORY
1233: if PARENT_IS_OBSOLETE(P_DEST_TABLE, P_OBJECT_NAME) then
1234: return;
1235: end if;
1236: Insert into FND_LOOKUP_ASSIGNMENTS
1237: (OBJ_NAME, INSTANCE_PK1_VALUE, INSTANCE_PK2_VALUE,
1238: LOOKUP_TYPE, LOOKUP_CODE, LOOKUP_ASSIGNMENT_ID, DISPLAY_SEQUENCE,
1239: CREATED_BY, CREATION_DATE,
1240: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

Line 1242: P_TYPE, P_CODE, FND_LOOKUP_ASSIGNMENTS_S.nextval, P_SEQUENCE,

1238: LOOKUP_TYPE, LOOKUP_CODE, LOOKUP_ASSIGNMENT_ID, DISPLAY_SEQUENCE,
1239: CREATED_BY, CREATION_DATE,
1240: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
1241: select 'FND_IREP_FUNCTION_FLAVORS', f.function_id, P_OVERLOAD_SEQ,
1242: P_TYPE, P_CODE, FND_LOOKUP_ASSIGNMENTS_S.nextval, P_SEQUENCE,
1243: C.LAST_UPDATED_BY, C.LAST_UPDATE_DATE,
1244: C.LAST_UPDATED_BY, C.LAST_UPDATE_DATE, 0
1245: from FND_IREP_CLASSES C,
1246: FND_FORM_FUNCTIONS F