DBA Data[Home] [Help]

APPS.BOM_BOMRWUIT_XMLP_PKG dependencies on FND_PROFILE

Line 170: P_QTY_PRECISION := FND_PROFILE.VALUE('REPORT_QUANTITY_PRECISION');

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

Line 241: WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_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;

Line 242: AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) 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