APPS.BOM_BOMRWUIT_XMLP_PKG dependencies on BOM_IMPLOSION_TEMP

Line 40: BOM_IMPLOSION_TEMP_S.NEXTVAL

36: END IF;
37: P_QTY_PRECISION := FND_PROFILE.VALUE('REPORT_QUANTITY_PRECISION');
38: TABLE_NAME := 'IMPLOSION_TEMP_S:';
39: SELECT
40: BOM_IMPLOSION_TEMP_S.NEXTVAL
41: INTO L_SEQUENCE_ID
42: FROM
43: DUAL;
44: P_SEQUENCE_ID := L_SEQUENCE_ID;

Line 124: L_STR := 'INSERT INTO BOM_IMPLOSION_TEMP (

120: END IF;
121: END IF;
122: FOR I IN T_ORG_CODE_LIST.FIRST .. T_ORG_CODE_LIST.LAST LOOP
123: LP_ORG_ID := T_ORG_CODE_LIST(I);
124: L_STR := 'INSERT INTO BOM_IMPLOSION_TEMP (
125: SEQUENCE_ID,LOWEST_ITEM_ID,CURRENT_ITEM_ID,PARENT_ITEM_ID,
126: CURRENT_LEVEL,SORT_CODE,CURRENT_ASSEMBLY_TYPE,
127: LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
128: REQUEST_ID,ORGANIZATION_ID) ';

Line 130: INSERT INTO BOM_IMPLOSION_TEMP

126: CURRENT_LEVEL,SORT_CODE,CURRENT_ASSEMBLY_TYPE,
127: LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
128: REQUEST_ID,ORGANIZATION_ID) ';
129: IF P_REPORT_OPTION = 1 THEN
130: INSERT INTO BOM_IMPLOSION_TEMP
131: (SEQUENCE_ID
132: ,LOWEST_ITEM_ID
133: ,CURRENT_ITEM_ID
134: ,PARENT_ITEM_ID