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 77: -- Procedure get_rec for OKL_FE_ADJ_MAT_ALL_B

73: END add_language;
74:
75:
76: --------------------------------------------------------------------------------
77: -- Procedure get_rec for OKL_FE_ADJ_MAT_ALL_B
78: --------------------------------------------------------------------------------
79:
80: FUNCTION get_rec(p_pamb_rec IN okl_pamb_rec
81: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_pamb_rec IS

Line 115: FROM okl_fe_adj_mat_all_b

111: ,creation_date
112: ,last_updated_by
113: ,last_update_date
114: ,last_update_login
115: FROM okl_fe_adj_mat_all_b
116: WHERE okl_fe_adj_mat_all_b.adj_mat_id = p_id;
117: l_pamb_pk pamb_pk_csr%ROWTYPE;
118: l_pamb_rec okl_pamb_rec;
119:

Line 116: WHERE okl_fe_adj_mat_all_b.adj_mat_id = p_id;

112: ,last_updated_by
113: ,last_update_date
114: ,last_update_login
115: FROM okl_fe_adj_mat_all_b
116: WHERE okl_fe_adj_mat_all_b.adj_mat_id = p_id;
117: l_pamb_pk pamb_pk_csr%ROWTYPE;
118: l_pamb_rec okl_pamb_rec;
119:
120: BEGIN

Line 582: FROM okl_fe_adj_mat_all_b

578: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
579:
580: CURSOR lock_csr(p_pamb_rec IN okl_pamb_rec) IS
581: SELECT object_version_number
582: FROM okl_fe_adj_mat_all_b
583: WHERE adj_mat_id = p_pamb_rec.adj_mat_id
584: AND object_version_number = p_pamb_rec.object_version_number
585: FOR UPDATE OF object_version_number NOWAIT;
586:

Line 589: FROM okl_fe_adj_mat_all_b

585: FOR UPDATE OF object_version_number NOWAIT;
586:
587: CURSOR lchk_csr(p_pamb_rec IN okl_pamb_rec) IS
588: SELECT object_version_number
589: FROM okl_fe_adj_mat_all_b
590: WHERE adj_mat_id = p_pamb_rec.adj_mat_id;
591: l_api_version CONSTANT NUMBER := 1;
592: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
593: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

Line 1214: FROM okl_fe_adj_mat_all_b

1210: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
1211:
1212: CURSOR adj_matrix_exists_csr IS
1213: SELECT 'x'
1214: FROM okl_fe_adj_mat_all_b
1215: WHERE adj_mat_id = p_orig_adj_mat_id;
1216: l_dummy_var VARCHAR2(1) := '?';
1217:
1218: BEGIN

Line 1558: INSERT INTO okl_fe_adj_mat_all_b

1554: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1555: RAISE okl_api.g_exception_error;
1556: END IF;
1557:
1558: INSERT INTO okl_fe_adj_mat_all_b
1559: (adj_mat_id
1560: ,adj_mat_name
1561: ,object_version_number
1562: ,org_id

Line 2060: UPDATE okl_fe_adj_mat_all_b

2056: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2057: RAISE okl_api.g_exception_error;
2058: END IF;
2059:
2060: UPDATE okl_fe_adj_mat_all_b
2061: SET adj_mat_id = l_def_pamb_rec.adj_mat_id
2062: ,adj_mat_name = l_def_pamb_rec.adj_mat_name
2063: ,object_version_number = l_def_pamb_rec.object_version_number + 1
2064: ,org_id = l_def_pamb_rec.org_id

Line 2669: DELETE FROM okl_fe_adj_mat_all_b

2665: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2666: RAISE okl_api.g_exception_error;
2667: END IF;
2668:
2669: DELETE FROM okl_fe_adj_mat_all_b
2670: WHERE adj_mat_id = l_pamb_rec.adj_mat_id;
2671:
2672: EXCEPTION
2673: WHEN g_exception_halt_validation THEN