APPS.OKL_ITEM_RESIDUALS_PVT dependencies on OKL_ITM_CAT_RV_PRCS_V

Line 13: OKL_ITM_CAT_RV_PRCS_V ICPV

9: CURSOR get_max_ver(p_item_residual_id NUMBER) IS
10: SELECT
11: MAX(TO_NUMBER(ICPV.VERSION_NUMBER))
12: FROM
13: OKL_ITM_CAT_RV_PRCS_V ICPV
14: WHERE
15: ICPV.ITEM_RESIDUAL_ID = p_item_residual_id;
16: BEGIN
17:

Line 36: OKL_ITM_CAT_RV_PRCS_V ICPV

32: CURSOR get_max_ver(p_item_residual_id NUMBER) IS
33: SELECT
34: MAX(TO_NUMBER(ICPV.VERSION_NUMBER))
35: FROM
36: OKL_ITM_CAT_RV_PRCS_V ICPV
37: WHERE
38: ICPV.STS_CODE = G_STS_ACTIVE
39: AND ICPV.ITEM_RESIDUAL_ID = p_item_residual_id ;
40: BEGIN

Line 78: OKL_ITM_CAT_RV_PRCS_V ICPV

74: SELECT
75: ICPV.START_DATE
76: , ICPV.END_DATE
77: FROM
78: OKL_ITM_CAT_RV_PRCS_V ICPV
79: WHERE
80: ICPV.ITEM_RESIDUAL_ID = p_residual_id
81: AND TO_NUMBER(ICPV.VERSION_NUMBER) = TO_NUMBER(p_version_number)-1 ;
82:

Line 137: , OKL_ITM_CAT_RV_PRCS_V ICPV

133: WHERE rate_card_id IN(SELECT
134: LRFVERV.RATE_SET_ID LRS_ID
135: FROM
136: OKL_FE_ITEM_RESIDUAL IRHV
137: , OKL_ITM_CAT_RV_PRCS_V ICPV
138: , OKL_FE_EO_TERM_OBJECTS EOTL
139: , OKL_FE_EO_TERM_VERS_V EOTVERV
140: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV
141: WHERE

Line 159: , OKL_ITM_CAT_RV_PRCS_V ICPV

155: WHERE rate_card_id IN(SELECT
156: LRFVERV.RATE_SET_ID LRS_ID
157: FROM
158: OKL_FE_ITEM_RESIDUAL IRHV
159: , OKL_ITM_CAT_RV_PRCS_V ICPV
160: , OKL_FE_EO_TERM_OBJECTS EOTL
161: , OKL_FE_EO_TERM_VERS_V EOTVERV
162: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV
163: WHERE

Line 180: , OKL_ITM_CAT_RV_PRCS_V ICPV

176: WHERE rate_card_id IN(SELECT
177: LRFVERV.RATE_SET_ID LRS_ID
178: FROM
179: OKL_FE_ITEM_RESIDUAL IRHV
180: , OKL_ITM_CAT_RV_PRCS_V ICPV
181: , OKL_FE_EO_TERM_OBJECTS EOTL
182: , OKL_FE_EO_TERM_VERS_V EOTVERV
183: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV
184: WHERE

Line 200: , OKL_ITM_CAT_RV_PRCS_V ICPV

196: WHERE rate_card_id IN (SELECT
197: LRFVERV.RATE_SET_ID LRS_ID
198: FROM
199: OKL_FE_ITEM_RESIDUAL IRHV
200: , OKL_ITM_CAT_RV_PRCS_V ICPV
201: , OKL_FE_EO_TERM_OBJECTS EOTL
202: , OKL_FE_EO_TERM_VERS_V EOTVERV
203: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV
204: WHERE

Line 222: , OKL_ITM_CAT_RV_PRCS_V ICPV

218: WHERE rate_card_id IN (SELECT
219: LRFVERV.RATE_SET_ID LRS_ID
220: FROM
221: OKL_FE_ITEM_RESIDUAL IRHV
222: , OKL_ITM_CAT_RV_PRCS_V ICPV
223: , OKL_FE_EO_TERM_OBJECTS EOTL
224: , OKL_FE_EO_TERM_VERS_V EOTVERV
225: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV
226: WHERE

Line 243: , OKL_ITM_CAT_RV_PRCS_V ICPV

239: WHERE rate_card_id IN (SELECT
240: LRFVERV.RATE_SET_ID LRS_ID
241: FROM
242: OKL_FE_ITEM_RESIDUAL IRHV
243: , OKL_ITM_CAT_RV_PRCS_V ICPV
244: , OKL_FE_EO_TERM_OBJECTS EOTL
245: , OKL_FE_EO_TERM_VERS_V EOTVERV
246: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV
247: WHERE

Line 265: OKL_ITM_CAT_RV_PRCS_V ICPV

261: , ICPV.STS_CODE
262: , ICPV.ITEM_RESIDUAL_ID
263: , IRHV.CATEGORY_TYPE_CODE
264: FROM
265: OKL_ITM_CAT_RV_PRCS_V ICPV
266: , OKL_FE_ITEM_RESIDUAL IRHV
267: WHERE
268: IRHV.ITEM_RESIDUAL_ID = ICPV.ITEM_RESIDUAL_ID
269: AND ICPV.ID = p_ver_id;

Line 1000: , OKL_ITM_CAT_RV_PRCS_V ICPV

996: , LRFV.NAME LRS_NAME
997: , LRFVERV.VERSION_NUMBER LRS_VERSION_NUMBER
998: FROM
999: OKL_FE_ITEM_RESIDUAL IRHV
1000: , OKL_ITM_CAT_RV_PRCS_V ICPV
1001: , OKL_FE_EO_TERM_OBJECTS EOTL
1002: , OKL_FE_EO_TERM_VERS_V EOTVERV
1003: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV
1004: , OKL_LS_RT_FCTR_SETS_V LRFV

Line 1029: , OKL_ITM_CAT_RV_PRCS_V ICPV

1025: , LRFV.NAME LRS_NAME
1026: , LRFVERV.VERSION_NUMBER LRS_VERSION_NUMBER
1027: FROM
1028: OKL_FE_ITEM_RESIDUAL IRHV
1029: , OKL_ITM_CAT_RV_PRCS_V ICPV
1030: , OKL_FE_EO_TERM_OBJECTS EOTL
1031: , OKL_FE_EO_TERM_VERS_V EOTVERV
1032: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV
1033: , OKL_LS_RT_FCTR_SETS_V LRFV

Line 1057: , OKL_ITM_CAT_RV_PRCS_V ICPV

1053: , LRFV.NAME LRS_NAME
1054: , LRFVERV.VERSION_NUMBER LRS_VERSION_NUMBER
1055: FROM
1056: OKL_FE_ITEM_RESIDUAL IRHV
1057: , OKL_ITM_CAT_RV_PRCS_V ICPV
1058: , OKL_FE_EO_TERM_OBJECTS EOTL
1059: , OKL_FE_EO_TERM_VERS_V EOTVERV
1060: , OKL_FE_RATE_SET_VERSIONS_V LRFVERV
1061: , OKL_LS_RT_FCTR_SETS_V LRFV

Line 1090: OKL_ITM_CAT_RV_PRCS_V

1086: CURSOR get_version_date (p_version_id NUMBER) IS
1087: SELECT
1088: end_date
1089: FROM
1090: OKL_ITM_CAT_RV_PRCS_V
1091: WHERE
1092: ID = p_version_id;
1093:
1094: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.change_LRS_sts';

Line 1257: OKL_ITM_CAT_RV_PRCS_V ICPV

1253: CURSOR all_versions (residual_id NUMBER) IS
1254: SELECT
1255: ICPV.STS_CODE STATUS_CODE
1256: FROM
1257: OKL_ITM_CAT_RV_PRCS_V ICPV
1258: WHERE
1259: ICPV.ITEM_RESIDUAL_ID = residual_id;
1260: BEGIN
1261:

Line 1333: OKL_ITM_CAT_RV_PRCS_V ICPV

1329: , ICPV.VERSION_NUMBER VERSION_NUMBER
1330: , ICPV.START_DATE EFFECTIVE_FROM_DATE
1331: , ICPV.END_DATE EFFECTIVE_TO_DATE
1332: FROM
1333: OKL_ITM_CAT_RV_PRCS_V ICPV
1334: WHERE
1335: ICPV.ITEM_RESIDUAL_ID = var_residual_id
1336: AND ICPV.VERSION_NUMBER = ver_no;
1337:

Line 1531: p_itm_rsdl_version_id IN OKL_ITM_CAT_RV_PRCS_V.ID%TYPE

1527: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1528: x_return_status OUT NOCOPY VARCHAR2,
1529: x_msg_count OUT NOCOPY NUMBER,
1530: x_msg_data OUT NOCOPY VARCHAR2,
1531: p_itm_rsdl_version_id IN OKL_ITM_CAT_RV_PRCS_V.ID%TYPE
1532: )IS
1533: l_api_name CONSTANT VARCHAR2(65) := 'submit_item_residual';
1534: l_api_version CONSTANT NUMBER := p_api_version;
1535: lx_return_status VARCHAR2(1);

Line 1549: OKL_ITM_CAT_RV_PRCS_V ICPV

1545: CURSOR get_residual_id(p_itm_rsdl_version_id NUMBER) IS
1546: SELECT
1547: ICPV.ITEM_RESIDUAL_ID
1548: FROM
1549: OKL_ITM_CAT_RV_PRCS_V ICPV
1550: WHERE
1551: ICPV.ID = p_itm_rsdl_version_id;
1552:
1553: -- Cusrsor to fetch the Source type(also called Category Type)

Line 2001: OKL_ITM_CAT_RV_PRCS_V

1997: CURSOR get_prev_ver(p_item_residual_id NUMBER, p_ver_no NUMBER) IS
1998: SELECT
1999: ID
2000: FROM
2001: OKL_ITM_CAT_RV_PRCS_V
2002: WHERE
2003: ITEM_RESIDUAL_ID = p_item_residual_id
2004: AND TO_NUMBER(VERSION_NUMBER) = p_ver_no - 1;
2005: