APPS.OKC_XPRT_IMPORT_PVT dependencies on DUAL

Line 507: FROM dual;

503: ) child_req_id,
504: SUBSTR(req_data,
505: INSTR(req_data,':',1) + 1
506: ) run_id
507: FROM dual;
508:
509: CURSOR csr_cz_imp_rules_cnt IS
510: SELECT COUNT(*)
511: FROM cz_imp_rules

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

532:
533:
534: BEGIN
535:
536: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
537:
538: fnd_file.put_line(FND_FILE.LOG,'Using OKC Rules Engine'||l_okc_rules_engine);
539:
540: IF Nvl(l_okc_rules_engine,'N') = 'N' THEN

Line 1478: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;

1474: LOOP
1475: FETCH csr_rules INTO l_rule_id;
1476: EXIT WHEN csr_rules%NOTFOUND;
1477:
1478: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
1479:
1480: UPDATE okc_xprt_rule_hdrs_all
1481: SET status_code = 'ACTIVE',
1482: published_flag = 'Y',

Line 1585: FROM dual;

1581: ) child_req_id,
1582: SUBSTR(req_data,
1583: INSTR(req_data,':',1) + 1
1584: ) run_id
1585: FROM dual;
1586:
1587: CURSOR csr_cz_imp_rules_cnt IS
1588: SELECT COUNT(*)
1589: FROM cz_imp_rules

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

1611:
1612:
1613: BEGIN
1614:
1615: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
1616:
1617: fnd_file.put_line(FND_FILE.LOG,'Using OKC Rules Engine'||l_okc_rules_engine);
1618:
1619: IF Nvl(l_okc_rules_engine,'N') = 'N' THEN

Line 2263: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;

2259: LOOP
2260: FETCH csr_rules INTO l_rule_id;
2261: EXIT WHEN csr_rules%NOTFOUND;
2262:
2263: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
2264:
2265: UPDATE okc_xprt_rule_hdrs_all
2266: SET status_code = 'INACTIVE',
2267: published_flag = 'Y',

Line 2620: FROM dual;

2616: ) child_req_id,
2617: SUBSTR(req_data,
2618: INSTR(req_data,':',1) + 1
2619: ) run_id
2620: FROM dual;
2621:
2622: CURSOR csr_cz_imp_rules_cnt IS
2623: SELECT COUNT(*)
2624: FROM cz_imp_rules

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

2631: BEGIN
2632:
2633:
2634:
2635: SELECT fnd_profile.Value('OKC_USE_CONTRACTS_RULES_ENGINE') INTO l_okc_rules_engine FROM dual;
2636:
2637: fnd_file.put_line(FND_FILE.LOG,'Using OKC Rules Engine'||l_okc_rules_engine);
2638:
2639: IF Nvl(l_okc_rules_engine,'N') = 'N' THEN