APPS.OKC_XPRT_UTIL_PVT dependencies on DUAL

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

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

Line 2588: FROM dual;

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

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

8331: -- Check mode and set value for p_sequence_id for 'RUN' - runtime mode only
8332: -- as the value of p_sequence_id is passed in the 'BV' mode
8333: --
8334: IF (p_mode = 'RUN') THEN
8335: SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO p_sequence_id from DUAL;
8336: END IF;
8337:
8338:
8339: --

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

9505: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9506: END IF;
9507:
9508:
9509: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;
9510: l_sequence_id := p_sequence_id;
9511:
9512: get_expert_results(
9513: p_api_version => 1.0,

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

9586: raise FND_API.G_EXC_UNEXPECTED_ERROR;
9587: END IF;
9588:
9589:
9590: --SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;
9591: l_sequence_id := p_sequence_id;
9592:
9593: get_expert_results(
9594: p_api_version => 1.0,