APPS.OKL_RES_PVT dependencies on OKL_FE_RESI_CAT_OBJECTS

Line 22: -- Procedure get_rec for OKL_FE_RESI_CAT_OBJECTS

18: null;
19: END change_version;
20:
21: --------------------------------------------------------------------------------
22: -- Procedure get_rec for OKL_FE_RESI_CAT_OBJECTS
23: --------------------------------------------------------------------------------
24:
25: FUNCTION get_rec(
26: p_res_rec IN okl_res_rec,

Line 43: FROM OKL_FE_RESI_CAT_OBJECTS WHERE OKL_FE_RESI_CAT_OBJECTS.RESI_CAT_OBJECT_ID=p_id;

39: INVENTORY_ITEM_ID,
40: ORGANIZATION_ID,
41: CATEGORY_ID,
42: CATEGORY_SET_ID
43: FROM OKL_FE_RESI_CAT_OBJECTS WHERE OKL_FE_RESI_CAT_OBJECTS.RESI_CAT_OBJECT_ID=p_id;
44: l_res_pk rcv_pk_csr%ROWTYPE;
45: l_res_rec okl_res_rec;
46: BEGIN
47: x_no_data_found:= TRUE;

Line 364: INSERT INTO OKL_FE_RESI_CAT_OBJECTS(

360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
361: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
362: RAISE OKC_API.G_EXCEPTION_ERROR;
363: END IF;
364: INSERT INTO OKL_FE_RESI_CAT_OBJECTS(
365: RESI_CAT_OBJECT_ID,
366: OBJECT_VERSION_NUMBER,
367: RESI_CATEGORY_SET_ID,
368: CREATED_BY,

Line 532: FROM OKL_FE_RESI_CAT_OBJECTS

528: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
529:
530: CURSOR lock_csr (p_def_res_rec IN okl_res_rec) IS
531: SELECT OBJECT_VERSION_NUMBER
532: FROM OKL_FE_RESI_CAT_OBJECTS
533: WHERE RESI_CAT_OBJECT_ID = p_def_res_rec.resi_cat_object_id
534: AND OBJECT_VERSION_NUMBER = p_def_res_rec.object_version_number
535: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
536:

Line 539: FROM OKL_FE_RESI_CAT_OBJECTS

535: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
536:
537: CURSOR lchk_csr (p_def_res_rec IN okl_res_rec) IS
538: SELECT OBJECT_VERSION_NUMBER
539: FROM OKL_FE_RESI_CAT_OBJECTS
540: WHERE RESI_CAT_OBJECT_ID = p_def_res_rec.resi_cat_object_id;
541:
542: l_return_status VARCHAR2(1);
543: l_object_version_number OKL_FE_RESI_CAT_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;

Line 543: l_object_version_number OKL_FE_RESI_CAT_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;

539: FROM OKL_FE_RESI_CAT_OBJECTS
540: WHERE RESI_CAT_OBJECT_ID = p_def_res_rec.resi_cat_object_id;
541:
542: l_return_status VARCHAR2(1);
543: l_object_version_number OKL_FE_RESI_CAT_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
544: lc_object_version_number OKL_FE_RESI_CAT_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
545: l_row_notfound BOOLEAN := FALSE;
546: lc_row_notfound BOOLEAN := FALSE;
547:

Line 544: lc_object_version_number OKL_FE_RESI_CAT_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;

540: WHERE RESI_CAT_OBJECT_ID = p_def_res_rec.resi_cat_object_id;
541:
542: l_return_status VARCHAR2(1);
543: l_object_version_number OKL_FE_RESI_CAT_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
544: lc_object_version_number OKL_FE_RESI_CAT_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
545: l_row_notfound BOOLEAN := FALSE;
546: lc_row_notfound BOOLEAN := FALSE;
547:
548: BEGIN

Line 851: UPDATE OKL_FE_RESI_CAT_OBJECTS

847: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
848: RAISE OKL_API.G_EXCEPTION_ERROR;
849: END IF;
850:
851: UPDATE OKL_FE_RESI_CAT_OBJECTS
852: SET
853: RESI_CAT_OBJECT_ID= l_def_res_rec.RESI_CAT_OBJECT_ID,
854: OBJECT_VERSION_NUMBER=l_def_res_rec.OBJECT_VERSION_NUMBER+1,
855: RESI_CATEGORY_SET_ID= l_def_res_rec.RESI_CATEGORY_SET_ID,

Line 1018: DELETE FROM OKL_FE_RESI_CAT_OBJECTS

1014: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;
1017:
1018: DELETE FROM OKL_FE_RESI_CAT_OBJECTS
1019: WHERE RESI_CAT_OBJECT_ID=l_res_rec.RESI_CAT_OBJECT_ID;
1020:
1021: EXCEPTION
1022: WHEN G_EXCEPTION_HALT_VALIDATION then