DBA Data[Home] [Help]

APPS.BOM_BOMRWUIT_XMLP_PKG dependencies on FND_PROFILE

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

33: /*SRW.MESSAGE('999'
34: ,P_MSG_BUF)*/NULL;
35: RAISE ITEM_ID_NULL;
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

Line 108: WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')

104: SELECT
105: ORGANIZATION_ID
106: FROM
107: ORG_ACCESS_VIEW
108: WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')
109: AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP
110: N := N + 1;
111: T_ORG_CODE_LIST(N) := C1.ORGANIZATION_ID;
112: END LOOP;

Line 109: AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP

105: ORGANIZATION_ID
106: FROM
107: ORG_ACCESS_VIEW
108: WHERE RESPONSIBILITY_ID = FND_PROFILE.VALUE('RESP_ID')
109: AND RESP_APPLICATION_ID = FND_PROFILE.VALUE('RESP_APPL_ID') )) LOOP
110: N := N + 1;
111: T_ORG_CODE_LIST(N) := C1.ORGANIZATION_ID;
112: END LOOP;
113: ELSIF P_ALL_ORGS = 2 THEN