APPS.OKL_ICP_PVT dependencies on OKL_ITM_CAT_RV_PRCS

Line 83: FROM okl_itm_cat_rv_prcs_v icpv

79: l_icpv_rec.attribute12,
80: l_icpv_rec.attribute13,
81: l_icpv_rec.attribute14,
82: l_icpv_rec.attribute15
83: FROM okl_itm_cat_rv_prcs_v icpv
84: WHERE icpv.id = p_id;
85: /* smadhava - Pricing Enhancements - Modified - Start */
86: x_return_status := G_RET_STS_SUCCESS;
87: RETURN l_icpv_rec;

Line 864: FROM okl_itm_cat_rv_prcs

860: /*
861: CURSOR c_uk_recs IS
862: SELECT start_date,
863: end_date
864: FROM okl_itm_cat_rv_prcs
865: WHERE cat_id1 = p_icpv_rec.cat_id1
866: AND cat_id2 = p_icpv_rec.cat_id2
867: AND term_in_months = p_icpv_rec.term_in_months
868: AND id <> p_icpv_rec.id

Line 1175: INSERT INTO OKL_ITM_CAT_RV_PRCS(

1171: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_ERROR;
1173: END IF;
1174: /* smadhava - Pricing Enhancements - Modified- Start */
1175: INSERT INTO OKL_ITM_CAT_RV_PRCS(
1176: id,
1177: object_version_number,
1178: cat_id1,
1179: cat_id2,

Line 1363: FROM OKL_ITM_CAT_RV_PRCS

1359: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1360:
1361: CURSOR lock_csr (p_icpv_rec IN icpv_rec_type) IS
1362: SELECT OBJECT_VERSION_NUMBER
1363: FROM OKL_ITM_CAT_RV_PRCS
1364: WHERE ID = p_icpv_rec.id
1365: AND OBJECT_VERSION_NUMBER = p_icpv_rec.object_version_number
1366: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1367:

Line 1370: FROM OKL_ITM_CAT_RV_PRCS

1366: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1367:
1368: CURSOR lchk_csr (p_icpv_rec IN icpv_rec_type) IS
1369: SELECT OBJECT_VERSION_NUMBER
1370: FROM OKL_ITM_CAT_RV_PRCS
1371: WHERE ID = p_icpv_rec.id;
1372:
1373: l_return_status VARCHAR2(1):= OKL_API.G_RET_STS_SUCCESS;
1374: l_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;

Line 1374: l_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;

1370: FROM OKL_ITM_CAT_RV_PRCS
1371: WHERE ID = p_icpv_rec.id;
1372:
1373: l_return_status VARCHAR2(1):= OKL_API.G_RET_STS_SUCCESS;
1374: l_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;
1375: lc_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;
1376: l_row_notfound BOOLEAN := FALSE;
1377: lc_row_notfound BOOLEAN := FALSE;
1378:

Line 1375: lc_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;

1371: WHERE ID = p_icpv_rec.id;
1372:
1373: l_return_status VARCHAR2(1):= OKL_API.G_RET_STS_SUCCESS;
1374: l_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;
1375: lc_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;
1376: l_row_notfound BOOLEAN := FALSE;
1377: lc_row_notfound BOOLEAN := FALSE;
1378:
1379: BEGIN

Line 1519: -- update_row for:OKL_ITM_CAT_RV_PRCS_V --

1515: END lock_row;
1516:
1517:
1518: ------------------------------------------
1519: -- update_row for:OKL_ITM_CAT_RV_PRCS_V --
1520: ------------------------------------------
1521: PROCEDURE update_row(
1522: p_api_version IN NUMBER,
1523: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1718: UPDATE OKL_ITM_CAT_RV_PRCS

1714: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1715: RAISE OKL_API.G_EXCEPTION_ERROR;
1716: END IF;
1717: /* smadhava - Pricing Enhancements - Modified - Start */
1718: UPDATE OKL_ITM_CAT_RV_PRCS
1719: SET OBJECT_VERSION_NUMBER = l_icpv_rec.object_version_number+1,
1720: CAT_ID1 = l_icpv_rec.cat_id1,
1721: CAT_ID2 = l_icpv_rec.cat_id2,
1722: TERM_IN_MONTHS = l_icpv_rec.term_in_months,

Line 1872: DELETE FROM OKL_ITM_CAT_RV_PRCS WHERE id = p_icpv_rec.id;

1868: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'delete_row (REC)';
1869:
1870: BEGIN
1871:
1872: DELETE FROM OKL_ITM_CAT_RV_PRCS WHERE id = p_icpv_rec.id;
1873:
1874: x_return_status := G_RET_STS_SUCCESS;
1875:
1876: EXCEPTION