APPS.OKL_IRV_PVT dependencies on OKL_FE_ITEM_RESDL_VALUES

Line 20: -- Procedure get_rec for OKL_FE_ITEM_RESDL_VALUES

16: null;
17: END change_version;
18:
19: --------------------------------------------------------------------------------
20: -- Procedure get_rec for OKL_FE_ITEM_RESDL_VALUES
21: --------------------------------------------------------------------------------
22:
23: FUNCTION get_rec(
24: p_irv_rec IN okl_irv_rec,

Line 40: FROM OKL_FE_ITEM_RESDL_VALUES IRV WHERE IRV.item_resdl_value_id=p_id;

36: CREATION_DATE,
37: LAST_UPDATED_BY,
38: LAST_UPDATE_DATE,
39: LAST_UPDATE_LOGIN
40: FROM OKL_FE_ITEM_RESDL_VALUES IRV WHERE IRV.item_resdl_value_id=p_id;
41: l_irv_pk irv_pk_csr%ROWTYPE;
42: l_irv_rec okl_irv_rec;
43: BEGIN
44: x_no_data_found:= TRUE;

Line 427: OKL_FE_ITEM_RESDL_VALUES IRV

423: CURSOR l_irv_csr IS
424: SELECT
425: item_resdl_value_id
426: FROM
427: OKL_FE_ITEM_RESDL_VALUES IRV
428: WHERE
429: IRV.ITEM_RESDL_VERSION_ID = p_irv_rec.item_resdl_version_id
430: AND IRV.TERM_IN_MONTHS = p_irv_rec.term_in_months;
431: BEGIN

Line 544: INSERT INTO OKL_FE_ITEM_RESDL_VALUES(

540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
542: RAISE OKL_API.G_EXCEPTION_ERROR;
543: END IF;
544: INSERT INTO OKL_FE_ITEM_RESDL_VALUES(
545: ITEM_RESDL_VALUE_ID,
546: OBJECT_VERSION_NUMBER,
547: ITEM_RESIDUAL_ID,
548: ITEM_RESDL_VERSION_ID,

Line 713: FROM OKL_FE_ITEM_RESDL_VALUES

709: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
710:
711: CURSOR lock_csr (p_def_irv_rec IN okl_irv_rec) IS
712: SELECT OBJECT_VERSION_NUMBER
713: FROM OKL_FE_ITEM_RESDL_VALUES
714: WHERE ITEM_RESDL_VALUE_ID = p_def_irv_rec.item_resdl_value_id
715: AND OBJECT_VERSION_NUMBER = p_def_irv_rec.object_version_number
716: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
717:

Line 720: FROM OKL_FE_ITEM_RESDL_VALUES

716: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
717:
718: CURSOR lchk_csr (p_def_irv_rec IN okl_irv_rec) IS
719: SELECT OBJECT_VERSION_NUMBER
720: FROM OKL_FE_ITEM_RESDL_VALUES
721: WHERE item_resdl_value_id = p_def_irv_rec.item_resdl_value_id;
722:
723: l_return_status VARCHAR2(1):= OKL_API.G_RET_STS_SUCCESS;
724: l_object_version_number OKL_ITM_CAT_RV_PRCS.OBJECT_VERSION_NUMBER%TYPE;

Line 1024: UPDATE OKL_FE_ITEM_RESDL_VALUES

1020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1021: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1022: RAISE OKL_API.G_EXCEPTION_ERROR;
1023: END IF;
1024: UPDATE OKL_FE_ITEM_RESDL_VALUES
1025: SET
1026: ITEM_RESDL_VALUE_ID= l_def_irv_rec.ITEM_RESDL_VALUE_ID,
1027: OBJECT_VERSION_NUMBER=l_def_irv_rec.OBJECT_VERSION_NUMBER+1,
1028: ITEM_RESIDUAL_ID= l_def_irv_rec.ITEM_RESIDUAL_ID,

Line 1190: DELETE FROM OKL_FE_ITEM_RESDL_VALUES

1186: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1187: RAISE OKL_API.G_EXCEPTION_ERROR;
1188: END IF;
1189:
1190: DELETE FROM OKL_FE_ITEM_RESDL_VALUES
1191: WHERE ITEM_RESDL_VALUE_ID=l_irv_rec.item_resdl_value_id;
1192:
1193:
1194: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);