DBA Data[Home] [Help]

APPS.FND_IREP_LOADER_PRIVATE dependencies on FND_IREP_FUNCTION_FLAVORS

Line 416: where obj_name = 'FND_IREP_FUNCTION_FLAVORS'

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
420: where irep_class_id = key_id);

Line 436: Delete from FND_IREP_FUNCTION_FLAVORS

432: from FND_FORM_FUNCTIONS
433: where irep_class_id = key_id);
434:
435: -- remove flavors
436: Delete from FND_IREP_FUNCTION_FLAVORS
437: where FUNCTION_ID in
438: (select function_id
439: from FND_FORM_FUNCTIONS
440: where irep_class_id = key_id);

Line 1205: Insert into FND_IREP_FUNCTION_FLAVORS (

1201: end if;
1202: end if;
1203:
1204: -- insert flavor
1205: Insert into FND_IREP_FUNCTION_FLAVORS (
1206: FUNCTION_ID, OVERLOAD_SEQ, SCOPE_TYPE, LIFECYCLE_MODE, DESCRIPTION,
1207: COMPATIBILITY_FLAG, USER_FLAVOR_NAME, SHORT_DESCRIPTION
1208: ) VALUES (
1209: fn_id, P_OVERLOAD_SEQ, nice_scope, nice_lifecy, P_DESCRIPTION,

Line 1241: select 'FND_IREP_FUNCTION_FLAVORS', f.function_id, P_OVERLOAD_SEQ,

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)
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,