DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_TERMS_DEVIATIONS_S1

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 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,