APPS.OKL_PAL_PVT dependencies on OKL_FE_ADJ_MAT_VERSIONS

Line 23: -- Procedure get_rec for OKL_FE_ADJ_MAT_VERSIONS

19: NULL;
20: END change_version;
21:
22: --------------------------------------------------------------------------------
23: -- Procedure get_rec for OKL_FE_ADJ_MAT_VERSIONS
24: --------------------------------------------------------------------------------
25:
26: FUNCTION get_rec(p_pal_rec IN okl_pal_rec
27: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_pal_rec IS

Line 58: FROM okl_fe_adj_mat_versions

54: ,creation_date
55: ,last_updated_by
56: ,last_update_date
57: ,last_update_login
58: FROM okl_fe_adj_mat_versions
59: WHERE okl_fe_adj_mat_versions.adj_mat_version_id = p_id;
60: l_pal_pk pal_pk_csr%ROWTYPE;
61: l_pal_rec okl_pal_rec;
62:

Line 59: WHERE okl_fe_adj_mat_versions.adj_mat_version_id = p_id;

55: ,last_updated_by
56: ,last_update_date
57: ,last_update_login
58: FROM okl_fe_adj_mat_versions
59: WHERE okl_fe_adj_mat_versions.adj_mat_version_id = p_id;
60: l_pal_pk pal_pk_csr%ROWTYPE;
61: l_pal_rec okl_pal_rec;
62:
63: BEGIN

Line 595: FROM okl_fe_adj_mat_versions

591: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
592:
593: CURSOR lock_csr(p_def_pal_rec IN okl_pal_rec) IS
594: SELECT object_version_number
595: FROM okl_fe_adj_mat_versions
596: WHERE adj_mat_version_id = p_def_pal_rec.adj_mat_version_id
597: AND object_version_number = p_def_pal_rec.object_version_number
598: FOR UPDATE OF object_version_number NOWAIT;
599:

Line 602: FROM okl_fe_adj_mat_versions

598: FOR UPDATE OF object_version_number NOWAIT;
599:
600: CURSOR lchk_csr(p_def_pal_rec IN okl_pal_rec) IS
601: SELECT object_version_number
602: FROM okl_fe_adj_mat_versions
603: WHERE adj_mat_version_id = p_def_pal_rec.adj_mat_version_id;
604: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
605: l_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;
606: lc_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;

Line 812: INSERT INTO okl_fe_adj_mat_versions

808: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
809: RAISE okl_api.g_exception_error;
810: END IF;
811:
812: INSERT INTO okl_fe_adj_mat_versions
813: (adj_mat_version_id
814: ,object_version_number
815: ,version_number
816: ,adj_mat_id

Line 1226: UPDATE okl_fe_adj_mat_versions

1222: ELSIF (l_return_status = g_ret_sts_error) THEN
1223: RAISE okl_api.g_exception_error;
1224: END IF;
1225:
1226: UPDATE okl_fe_adj_mat_versions
1227: SET adj_mat_version_id = l_def_pal_rec.adj_mat_version_id
1228: ,object_version_number = l_def_pal_rec.object_version_number + 1
1229: ,version_number = l_def_pal_rec.version_number
1230: ,adj_mat_id = l_def_pal_rec.adj_mat_id

Line 1401: DELETE FROM okl_fe_adj_mat_versions

1397: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1398: RAISE okl_api.g_exception_error;
1399: END IF;
1400:
1401: DELETE FROM okl_fe_adj_mat_versions
1402: WHERE adj_mat_version_id = l_pal_rec.adj_mat_version_id;
1403:
1404: EXCEPTION
1405: WHEN g_exception_halt_validation THEN