DBA Data[Home] [Help]

APPS.OKL_SRT_PVT dependencies on OKL_FE_STD_RT_TMP_ALL_B

Line 32: FROM OKL_FE_STD_RT_TMP_ALL_B b

28: BEGIN
29:
30: DELETE FROM OKL_FE_STD_RT_TMP_ALL_TL t
31: WHERE NOT EXISTS(SELECT NULL
32: FROM OKL_FE_STD_RT_TMP_ALL_B b
33: WHERE b.std_rate_tmpl_id = t.std_rate_tmpl_id);
34:
35: UPDATE OKL_FE_STD_RT_TMP_ALL_TL t
36: SET(template_desc) = (SELECT

Line 256: FROM okl_fe_std_rt_tmp_all_b

252: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
253:
254: CURSOR srt_exists_csr IS
255: SELECT 'x'
256: FROM okl_fe_std_rt_tmp_all_b
257: WHERE std_rate_tmpl_id = p_orig_srt_id;
258: l_dummy_var VARCHAR2(1) := '?';
259:
260: BEGIN

Line 783: -- Procedure get_rec for OKL_FE_STD_RT_TMP_ALL_B

779: RETURN x_return_status;
780: END validate_index_id;
781:
782: --------------------------------------------------------------------------------
783: -- Procedure get_rec for OKL_FE_STD_RT_TMP_ALL_B
784: --------------------------------------------------------------------------------
785:
786: FUNCTION get_rec(p_srtb_rec IN okl_srtb_rec
787: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_srtb_rec IS

Line 827: FROM okl_fe_std_rt_tmp_all_b

823: ,creation_date
824: ,last_updated_by
825: ,last_update_date
826: ,last_update_login
827: FROM okl_fe_std_rt_tmp_all_b
828: WHERE okl_fe_std_rt_tmp_all_b.std_rate_tmpl_id = p_id;
829: l_srtb_pk srtb_pk_csr%ROWTYPE;
830: l_srtb_rec okl_srtb_rec;
831:

Line 828: WHERE okl_fe_std_rt_tmp_all_b.std_rate_tmpl_id = p_id;

824: ,last_updated_by
825: ,last_update_date
826: ,last_update_login
827: FROM okl_fe_std_rt_tmp_all_b
828: WHERE okl_fe_std_rt_tmp_all_b.std_rate_tmpl_id = p_id;
829: l_srtb_pk srtb_pk_csr%ROWTYPE;
830: l_srtb_rec okl_srtb_rec;
831:
832: BEGIN

Line 1530: FROM okl_fe_std_rt_tmp_all_b

1526: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
1527:
1528: CURSOR lock_csr(p_srtb_rec IN okl_srtb_rec) IS
1529: SELECT object_version_number
1530: FROM okl_fe_std_rt_tmp_all_b
1531: WHERE std_rate_tmpl_id = p_srtb_rec.std_rate_tmpl_id
1532: AND object_version_number = p_srtb_rec.object_version_number
1533: FOR UPDATE OF object_version_number NOWAIT;
1534:

Line 1537: FROM okl_fe_std_rt_tmp_all_b

1533: FOR UPDATE OF object_version_number NOWAIT;
1534:
1535: CURSOR lchk_csr(p_srtb_rec IN okl_srtb_rec) IS
1536: SELECT object_version_number
1537: FROM okl_fe_std_rt_tmp_all_b
1538: WHERE std_rate_tmpl_id = p_srtb_rec.std_rate_tmpl_id;
1539: l_api_version CONSTANT NUMBER := 1;
1540: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1541: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

Line 1967: INSERT INTO okl_fe_std_rt_tmp_all_b

1963: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1964: RAISE okl_api.g_exception_error;
1965: END IF;
1966:
1967: INSERT INTO okl_fe_std_rt_tmp_all_b
1968: (std_rate_tmpl_id
1969: ,template_name
1970: ,object_version_number
1971: ,org_id

Line 2487: UPDATE okl_fe_std_rt_tmp_all_b

2483: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2484: RAISE okl_api.g_exception_error;
2485: END IF;
2486:
2487: UPDATE okl_fe_std_rt_tmp_all_b
2488: SET std_rate_tmpl_id = l_def_srtb_rec.std_rate_tmpl_id
2489: ,template_name = l_def_srtb_rec.template_name
2490: ,object_version_number = l_def_srtb_rec.object_version_number + 1
2491: ,org_id = l_def_srtb_rec.org_id

Line 3127: DELETE FROM okl_fe_std_rt_tmp_all_b

3123: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3124: RAISE okl_api.g_exception_error;
3125: END IF;
3126:
3127: DELETE FROM okl_fe_std_rt_tmp_all_b
3128: WHERE std_rate_tmpl_id = l_srtb_rec.std_rate_tmpl_id;
3129:
3130: EXCEPTION
3131: WHEN g_exception_halt_validation THEN