APPS.OKL_RCS_PVT dependencies on OKL_FE_RESI_CAT_ALL_B

Line 31: FROM OKL_FE_RESI_CAT_ALL_B b

27: BEGIN
28:
29: DELETE FROM OKL_FE_RESI_CAT_ALL_TL t
30: WHERE NOT EXISTS(SELECT NULL
31: FROM OKL_FE_RESI_CAT_ALL_B b
32: WHERE b.RESI_CATEGORY_SET_ID = t.RESI_CATEGORY_SET_ID);
33:
34: UPDATE OKL_FE_RESI_CAT_ALL_TL t
35: SET(RESI_CAT_DESC) = (SELECT

Line 73: -- Procedure get_rec for OKL_FE_RESI_CAT_ALL_B

69:
70: END add_language;
71:
72: --------------------------------------------------------------------------------
73: -- Procedure get_rec for OKL_FE_RESI_CAT_ALL_B
74: --------------------------------------------------------------------------------
75:
76: FUNCTION get_rec(
77: p_rcsb_rec IN okl_rcsb_rec,

Line 94: FROM OKL_FE_RESI_CAT_ALL_B WHERE OKL_FE_RESI_CAT_ALL_B.resi_category_set_id=p_id;

90: CREATION_DATE,
91: LAST_UPDATED_BY,
92: LAST_UPDATE_DATE,
93: LAST_UPDATE_LOGIN
94: FROM OKL_FE_RESI_CAT_ALL_B WHERE OKL_FE_RESI_CAT_ALL_B.resi_category_set_id=p_id;
95: l_rcsb_pk rcsb_pk_csr%ROWTYPE;
96: l_rcsb_rec okl_rcsb_rec;
97: BEGIN
98: x_no_data_found:= TRUE;

Line 807: INSERT INTO OKL_FE_RESI_CAT_ALL_B(

803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;
805:
806:
807: INSERT INTO OKL_FE_RESI_CAT_ALL_B(
808: RESI_CATEGORY_SET_ID,
809: RESI_CAT_NAME,
810: ORIG_RESI_CAT_SET_ID,
811: OBJECT_VERSION_NUMBER,

Line 1263: FROM OKL_FE_RESI_CAT_ALL_B

1259: E_Resource_Busy EXCEPTION;
1260: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1261: CURSOR lock_csr (p_rcsb_rec IN okl_rcsb_rec) IS
1262: SELECT OBJECT_VERSION_NUMBER
1263: FROM OKL_FE_RESI_CAT_ALL_B
1264: WHERE RESI_CATEGORY_SET_ID = p_rcsb_rec.RESI_CATEGORY_SET_ID
1265: AND OBJECT_VERSION_NUMBER = p_rcsb_rec.object_version_number
1266: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1267:

Line 1270: FROM OKL_FE_RESI_CAT_ALL_B

1266: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1267:
1268: CURSOR lchk_csr (p_rcsb_rec IN okl_rcsb_rec) IS
1269: SELECT OBJECT_VERSION_NUMBER
1270: FROM OKL_FE_RESI_CAT_ALL_B
1271: WHERE RESI_CATEGORY_SET_ID = p_rcsb_rec.RESI_CATEGORY_SET_ID;
1272: l_api_version CONSTANT NUMBER := 1;
1273: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1274: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 1275: l_object_version_number OKL_FE_RESI_CAT_ALL_B.OBJECT_VERSION_NUMBER%TYPE;

1271: WHERE RESI_CATEGORY_SET_ID = p_rcsb_rec.RESI_CATEGORY_SET_ID;
1272: l_api_version CONSTANT NUMBER := 1;
1273: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1274: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1275: l_object_version_number OKL_FE_RESI_CAT_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
1276: lc_object_version_number OKL_FE_RESI_CAT_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
1277: l_row_notfound BOOLEAN := FALSE;
1278: lc_row_notfound BOOLEAN := FALSE;
1279: BEGIN

Line 1276: lc_object_version_number OKL_FE_RESI_CAT_ALL_B.OBJECT_VERSION_NUMBER%TYPE;

1272: l_api_version CONSTANT NUMBER := 1;
1273: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1274: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1275: l_object_version_number OKL_FE_RESI_CAT_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
1276: lc_object_version_number OKL_FE_RESI_CAT_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
1277: l_row_notfound BOOLEAN := FALSE;
1278: lc_row_notfound BOOLEAN := FALSE;
1279: BEGIN
1280: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1705: UPDATE OKL_FE_RESI_CAT_ALL_B

1701: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1702: RAISE OKL_API.G_EXCEPTION_ERROR;
1703: END IF;
1704:
1705: UPDATE OKL_FE_RESI_CAT_ALL_B
1706: SET
1707: RESI_CATEGORY_SET_ID= l_def_rcsb_rec.RESI_CATEGORY_SET_ID,
1708: RESI_CAT_NAME =l_def_rcsb_rec.RESI_CAT_NAME,
1709: ORIG_RESI_CAT_SET_ID=l_def_rcsb_rec.ORIG_RESI_CAT_SET_ID,

Line 2227: DELETE FROM OKL_FE_RESI_CAT_ALL_B

2223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2224: RAISE OKL_API.G_EXCEPTION_ERROR;
2225: END IF;
2226:
2227: DELETE FROM OKL_FE_RESI_CAT_ALL_B
2228: WHERE RESI_CATEGORY_SET_ID=l_rcsb_rec.resi_category_set_id;
2229:
2230: EXCEPTION
2231: WHEN G_EXCEPTION_HALT_VALIDATION then