APPS.OKC_XPRT_UTIL_PVT dependencies on DUAL

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

2096: LOOP
2097: FETCH csr_rules INTO l_rule_id;
2098: EXIT WHEN csr_rules%NOTFOUND;
2099:
2100: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
2101:
2102: UPDATE okc_xprt_rule_hdrs_all
2103: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
2104: published_flag = 'Y',

Line 2590: FROM dual;

2586: l_intent okc_terms_templates_all.intent%TYPE;
2587:
2588: CURSOR csr_config_effective_date IS
2589: SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY')
2590: FROM dual;
2591:
2592: CURSOR csr_template_dtls IS
2593: SELECT org_id,
2594: intent

Line 6914: SELECT 'Y' INTO l_has_responses FROM dual

6910:
6911: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
6912: --checking whther the document have any expert responses
6913: BEGIN
6914: SELECT 'Y' INTO l_has_responses FROM dual
6915: WHERE EXISTS (SELECT 1 FROM okc_xprt_doc_ques_response WHERE doc_id = p_document_id AND doc_type = p_document_type AND response IS NOT NULL);
6916: EXCEPTION
6917: WHEN NO_DATA_FOUND THEN
6918: NULL;

Line 8662: SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO p_sequence_id from DUAL;

8658: -- Check mode and set value for p_sequence_id for 'RUN' - runtime mode only
8659: -- as the value of p_sequence_id is passed in the 'BV' mode
8660: --
8661: IF (p_mode = 'RUN') THEN
8662: SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO p_sequence_id from DUAL;
8663: END IF;
8664:
8665:
8666: --

Line 9390: SELECT 'Y' INTO l_has_responses FROM dual

9386: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
9387:
9388: --checking whther the document have any expert responses
9389: BEGIN
9390: SELECT 'Y' INTO l_has_responses FROM dual
9391: WHERE EXISTS (SELECT 1 FROM okc_xprt_doc_ques_response WHERE doc_id = p_document_id AND doc_type = p_document_type AND response IS NOT NULL);
9392: EXCEPTION
9393: WHEN NO_DATA_FOUND THEN
9394: NULL;

Line 9566: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;

9562: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9563: END IF;
9564:
9565:
9566: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;
9567: l_sequence_id := p_sequence_id;
9568:
9569: get_expert_results(
9570: p_api_version => 1.0,

Line 9626: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;

9622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9623: END IF;
9624:
9625:
9626: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;
9627: l_sequence_id := p_sequence_id;
9628:
9629: get_expert_results(
9630: p_api_version => 1.0,

Line 10105: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;

10101: raise FND_API.G_EXC_UNEXPECTED_ERROR;
10102: END IF;
10103:
10104:
10105: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;
10106: l_sequence_id := p_sequence_id;
10107:
10108: get_expert_results(
10109: p_api_version => 1.0,

Line 10186: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;

10182: raise FND_API.G_EXC_UNEXPECTED_ERROR;
10183: END IF;
10184:
10185:
10186: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;
10187: l_sequence_id := p_sequence_id;
10188:
10189: get_expert_results(
10190: p_api_version => 1.0,