APPS.DPP_EXECUTIONPROCESS_PVT dependencies on OZF_PROCESS_SETUP_ALL

Line 88: FROM OZF_PROCESS_SETUP_ALL OPSA, DPP_EXECUTION_PROCESSES DEP

84: L_SETUP_FLAG BOOLEAN := FALSE;
85:
86: CURSOR get_auto_flag_csr(p_supp_trd_prf_id NUMBER, p_process_code VARCHAR2, p_txn_hdr_id VARCHAR2) IS
87: SELECT NVL(AUTOMATIC_FLAG,'N') AUTOMATIC_FLAG
88: FROM OZF_PROCESS_SETUP_ALL OPSA, DPP_EXECUTION_PROCESSES DEP
89: WHERE NVL(SUPP_TRADE_PROFILE_ID,0) = NVL(P_SUPP_TRD_PRF_ID,0)
90: AND OPSA.PROCESS_CODE = P_PROCESS_CODE
91: AND OPSA.PROCESS_CODE = DEP.PROCESS_CODE
92: AND OPSA.ORG_ID = P_IN_ORG_ID

Line 363: FROM OZF_PROCESS_SETUP_ALL OPSA, DPP_EXECUTION_PROCESSES DEP

359: AND ROWNUM=1;
360:
361: CURSOR get_auto_flag_csr(p_supp_trd_prf_id NUMBER, p_process_code VARCHAR2, p_txn_hdr_id VARCHAR2) IS
362: SELECT NVL(AUTOMATIC_FLAG,'N') AUTOMATIC_FLAG
363: FROM OZF_PROCESS_SETUP_ALL OPSA, DPP_EXECUTION_PROCESSES DEP
364: WHERE NVL(SUPP_TRADE_PROFILE_ID,0) = NVL(P_SUPP_TRD_PRF_ID,0)
365: AND OPSA.PROCESS_CODE = P_PROCESS_CODE
366: AND OPSA.PROCESS_CODE = DEP.PROCESS_CODE
367: AND OPSA.ORG_ID = P_IN_ORG_ID

Line 724: FROM OZF_PROCESS_SETUP_ALL

720:
721: CURSOR GET_PROCESS_SETUP_CNT_CSR (P_SUPP_TRADE_PROFILE_ID NUMBER, P_ORG_ID NUMBER)
722: IS
723: SELECT COUNT(1)
724: FROM OZF_PROCESS_SETUP_ALL
725: WHERE NVL(SUPP_TRADE_PROFILE_ID,0) = NVL(P_SUPP_TRADE_PROFILE_ID,0)
726: AND ENABLED_FLAG = 'Y'
727: AND ORG_ID = P_ORG_ID;
728:

Line 743: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);

739: END IF;
740:
741: EXCEPTION
742: WHEN OTHERS THEN
743: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);
744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);
745: FND_FILE.NEW_LINE(FND_FILE.LOG);
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747:

Line 744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);

740:
741: EXCEPTION
742: WHEN OTHERS THEN
743: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);
744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while fetching from OZF_PROCESS_SETUP_ALL: ' || SQLERRM);
745: FND_FILE.NEW_LINE(FND_FILE.LOG);
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747:
748: END IS_PROCESS_SETUP;

Line 1116: OZF_PROCESS_SETUP_ALL opsa

1112: CURSOR get_process_codes_csr (p_supp_trd_prf_id NUMBER)
1113: IS
1114: SELECT dppl.lookup_code
1115: FROM dpp_lookups dppl,
1116: OZF_PROCESS_SETUP_ALL opsa
1117: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'
1118: AND dppl.tag is not null
1119: AND nvl(opsa.supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)
1120: AND opsa.enabled_flag = 'Y'