APPS.OKL_PAM_PVT dependencies on OKL_FE_ADJ_MAT_ALL_B

Line 34: FROM OKL_FE_ADJ_MAT_ALL_B b

30: BEGIN
31:
32: DELETE FROM OKL_FE_ADJ_MAT_ALL_TL t
33: WHERE NOT EXISTS(SELECT NULL
34: FROM OKL_FE_ADJ_MAT_ALL_B b
35: WHERE b.adj_mat_id = t.adj_mat_id);
36:
37: UPDATE OKL_FE_ADJ_MAT_ALL_TL t
38: SET(adj_mat_desc) = (SELECT

Line 87: -- Procedure get_rec for OKL_FE_ADJ_MAT_ALL_B

83: END add_language;
84:
85:
86: --------------------------------------------------------------------------------
87: -- Procedure get_rec for OKL_FE_ADJ_MAT_ALL_B
88: --------------------------------------------------------------------------------
89:
90: FUNCTION get_rec(p_pamb_rec IN okl_pamb_rec
91: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_pamb_rec IS

Line 125: FROM okl_fe_adj_mat_all_b

121: ,creation_date
122: ,last_updated_by
123: ,last_update_date
124: ,last_update_login
125: FROM okl_fe_adj_mat_all_b
126: WHERE okl_fe_adj_mat_all_b.adj_mat_id = p_id;
127: l_pamb_pk pamb_pk_csr%ROWTYPE;
128: l_pamb_rec okl_pamb_rec;
129:

Line 126: WHERE okl_fe_adj_mat_all_b.adj_mat_id = p_id;

122: ,last_updated_by
123: ,last_update_date
124: ,last_update_login
125: FROM okl_fe_adj_mat_all_b
126: WHERE okl_fe_adj_mat_all_b.adj_mat_id = p_id;
127: l_pamb_pk pamb_pk_csr%ROWTYPE;
128: l_pamb_rec okl_pamb_rec;
129:
130: BEGIN

Line 592: FROM okl_fe_adj_mat_all_b

588: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
589:
590: CURSOR lock_csr(p_pamb_rec IN okl_pamb_rec) IS
591: SELECT object_version_number
592: FROM okl_fe_adj_mat_all_b
593: WHERE adj_mat_id = p_pamb_rec.adj_mat_id
594: AND object_version_number = p_pamb_rec.object_version_number
595: FOR UPDATE OF object_version_number NOWAIT;
596:

Line 599: FROM okl_fe_adj_mat_all_b

595: FOR UPDATE OF object_version_number NOWAIT;
596:
597: CURSOR lchk_csr(p_pamb_rec IN okl_pamb_rec) IS
598: SELECT object_version_number
599: FROM okl_fe_adj_mat_all_b
600: WHERE adj_mat_id = p_pamb_rec.adj_mat_id;
601: l_api_version CONSTANT NUMBER := 1;
602: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
603: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

Line 1224: FROM okl_fe_adj_mat_all_b

1220: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1221:
1222: CURSOR adj_matrix_exists_csr IS
1223: SELECT 'x'
1224: FROM okl_fe_adj_mat_all_b
1225: WHERE adj_mat_id = p_orig_adj_mat_id;
1226: l_dummy_var VARCHAR2(1) := '?';
1227:
1228: BEGIN

Line 1568: INSERT INTO okl_fe_adj_mat_all_b

1564: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1565: RAISE okl_api.g_exception_error;
1566: END IF;
1567:
1568: INSERT INTO okl_fe_adj_mat_all_b
1569: (adj_mat_id
1570: ,adj_mat_name
1571: ,object_version_number
1572: ,org_id

Line 2070: UPDATE okl_fe_adj_mat_all_b

2066: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2067: RAISE okl_api.g_exception_error;
2068: END IF;
2069:
2070: UPDATE okl_fe_adj_mat_all_b
2071: SET adj_mat_id = l_def_pamb_rec.adj_mat_id
2072: ,adj_mat_name = l_def_pamb_rec.adj_mat_name
2073: ,object_version_number = l_def_pamb_rec.object_version_number + 1
2074: ,org_id = l_def_pamb_rec.org_id

Line 2679: DELETE FROM okl_fe_adj_mat_all_b

2675: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2676: RAISE okl_api.g_exception_error;
2677: END IF;
2678:
2679: DELETE FROM okl_fe_adj_mat_all_b
2680: WHERE adj_mat_id = l_pamb_rec.adj_mat_id;
2681:
2682: EXCEPTION
2683: WHEN g_exception_halt_validation THEN