APPS.BOM_BOMRWUIT_XMLP_PKG dependencies on BOM_IMPLOSION_TEMP

Line 173: BOM_IMPLOSION_TEMP_S.NEXTVAL

169: END IF;
170: P_QTY_PRECISION := FND_PROFILE.VALUE('REPORT_QUANTITY_PRECISION');
171: TABLE_NAME := 'IMPLOSION_TEMP_S:';
172: SELECT
173: BOM_IMPLOSION_TEMP_S.NEXTVAL
174: INTO L_SEQUENCE_ID
175: FROM
176: DUAL;
177: P_SEQUENCE_ID := L_SEQUENCE_ID;

Line 257: L_STR := 'INSERT INTO BOM_IMPLOSION_TEMP (

253: END IF;
254: END IF;
255: FOR I IN T_ORG_CODE_LIST.FIRST .. T_ORG_CODE_LIST.LAST LOOP
256: LP_ORG_ID := T_ORG_CODE_LIST(I);
257: L_STR := 'INSERT INTO BOM_IMPLOSION_TEMP (
258: SEQUENCE_ID,LOWEST_ITEM_ID,CURRENT_ITEM_ID,PARENT_ITEM_ID,
259: CURRENT_LEVEL,SORT_CODE,CURRENT_ASSEMBLY_TYPE,
260: LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
261: REQUEST_ID,ORGANIZATION_ID) ';

Line 263: INSERT INTO BOM_IMPLOSION_TEMP

259: CURRENT_LEVEL,SORT_CODE,CURRENT_ASSEMBLY_TYPE,
260: LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
261: REQUEST_ID,ORGANIZATION_ID) ';
262: IF P_REPORT_OPTION = 1 THEN
263: INSERT INTO BOM_IMPLOSION_TEMP
264: (SEQUENCE_ID
265: ,LOWEST_ITEM_ID
266: ,CURRENT_ITEM_ID
267: ,PARENT_ITEM_ID