APPS.OKC_XPRT_QA_PVT dependencies on DUAL

Line 2547: FROM DUAL;

2543: ) IS
2544:
2545: CURSOR l_seq_csr IS
2546: SELECT OKC_QA_ERRORS_T_S.NEXTVAL
2547: FROM DUAL;
2548:
2549: --Added for Bug 4725397
2550: CURSOR c_get_rule_org_id (p_rule_id NUMBER) IS
2551: SELECT rules.org_id

Line 2680: select fnd_profile.value('OKC_DISABLE_CYCLIC_CHECK') into cyclic_check_flag from dual;

2676: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2677: RAISE FND_API.G_EXC_ERROR;
2678: END IF;
2679:
2680: select fnd_profile.value('OKC_DISABLE_CYCLIC_CHECK') into cyclic_check_flag from dual;
2681:
2682: IF (NVL(cyclic_check_flag,'N')='N') THEN
2683:
2684: check_circular_dependency

Line 3033: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;

3029:
3030: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CPRG_ACT_MSG');
3031: l_conc_pgm_desc := FND_MESSAGE.get;
3032:
3033: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
3034: SELECT Decode(Nvl(l_okc_rules_engine,'N'),'Y','OKC_XPRT_PUBLISH_RULES_OKC','OKC_XPRT_PUBLISH_RULES') INTO l_conc_pgm FROM dual;
3035:
3036:
3037: x_request_id := fnd_request.submit_request

Line 3034: SELECT Decode(Nvl(l_okc_rules_engine,'N'),'Y','OKC_XPRT_PUBLISH_RULES_OKC','OKC_XPRT_PUBLISH_RULES') INTO l_conc_pgm FROM dual;

3030: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CPRG_ACT_MSG');
3031: l_conc_pgm_desc := FND_MESSAGE.get;
3032:
3033: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
3034: SELECT Decode(Nvl(l_okc_rules_engine,'N'),'Y','OKC_XPRT_PUBLISH_RULES_OKC','OKC_XPRT_PUBLISH_RULES') INTO l_conc_pgm FROM dual;
3035:
3036:
3037: x_request_id := fnd_request.submit_request
3038: (application => 'OKC',

Line 3051: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;

3047:
3048: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CPRG_DIS_MSG');
3049: l_conc_pgm_desc := FND_MESSAGE.get;
3050:
3051: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
3052: SELECT Decode(Nvl(l_okc_rules_engine,'N'),'Y','OKC_XPRT_DISABLE_RULES_OKC','OKC_XPRT_DISABLE_RULES') INTO l_conc_pgm FROM dual;
3053:
3054: x_request_id := fnd_request.submit_request
3055: (application => 'OKC',

Line 3052: SELECT Decode(Nvl(l_okc_rules_engine,'N'),'Y','OKC_XPRT_DISABLE_RULES_OKC','OKC_XPRT_DISABLE_RULES') INTO l_conc_pgm FROM dual;

3048: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CPRG_DIS_MSG');
3049: l_conc_pgm_desc := FND_MESSAGE.get;
3050:
3051: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
3052: SELECT Decode(Nvl(l_okc_rules_engine,'N'),'Y','OKC_XPRT_DISABLE_RULES_OKC','OKC_XPRT_DISABLE_RULES') INTO l_conc_pgm FROM dual;
3053:
3054: x_request_id := fnd_request.submit_request
3055: (application => 'OKC',
3056: program => l_conc_pgm,