166: /*SRW.MESSAGE('999'
167: ,P_MSG_BUF)*/NULL;
168: RAISE ITEM_ID_NULL;
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
237: SELECT
238: ORGANIZATION_ID
239: FROM
240: ORG_ACCESS_VIEW
241: WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')
242: AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP
243: N := N + 1;
244: T_ORG_CODE_LIST(N) := C1.ORGANIZATION_ID;
245: END LOOP;
238: ORGANIZATION_ID
239: FROM
240: ORG_ACCESS_VIEW
241: WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')
242: AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP
243: N := N + 1;
244: T_ORG_CODE_LIST(N) := C1.ORGANIZATION_ID;
245: END LOOP;
246: ELSIF P_ALL_ORGS = 2 THEN