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 246: FROM okl_fe_std_rt_tmp_all_b

242: x_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
243:
244: CURSOR srt_exists_csr IS
245: SELECT 'x'
246: FROM okl_fe_std_rt_tmp_all_b
247: WHERE std_rate_tmpl_id = p_orig_srt_id;
248: l_dummy_var VARCHAR2(1) := '?';
249:
250: BEGIN

Line 773: -- Procedure get_rec for OKL_FE_STD_RT_TMP_ALL_B

769: RETURN x_return_status;
770: END validate_index_id;
771:
772: --------------------------------------------------------------------------------
773: -- Procedure get_rec for OKL_FE_STD_RT_TMP_ALL_B
774: --------------------------------------------------------------------------------
775:
776: FUNCTION get_rec(p_srtb_rec IN okl_srtb_rec
777: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_srtb_rec IS

Line 817: FROM okl_fe_std_rt_tmp_all_b

813: ,creation_date
814: ,last_updated_by
815: ,last_update_date
816: ,last_update_login
817: FROM okl_fe_std_rt_tmp_all_b
818: WHERE okl_fe_std_rt_tmp_all_b.std_rate_tmpl_id = p_id;
819: l_srtb_pk srtb_pk_csr%ROWTYPE;
820: l_srtb_rec okl_srtb_rec;
821:

Line 818: WHERE okl_fe_std_rt_tmp_all_b.std_rate_tmpl_id = p_id;

814: ,last_updated_by
815: ,last_update_date
816: ,last_update_login
817: FROM okl_fe_std_rt_tmp_all_b
818: WHERE okl_fe_std_rt_tmp_all_b.std_rate_tmpl_id = p_id;
819: l_srtb_pk srtb_pk_csr%ROWTYPE;
820: l_srtb_rec okl_srtb_rec;
821:
822: BEGIN

Line 1520: FROM okl_fe_std_rt_tmp_all_b

1516: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
1517:
1518: CURSOR lock_csr(p_srtb_rec IN okl_srtb_rec) IS
1519: SELECT object_version_number
1520: FROM okl_fe_std_rt_tmp_all_b
1521: WHERE std_rate_tmpl_id = p_srtb_rec.std_rate_tmpl_id
1522: AND object_version_number = p_srtb_rec.object_version_number
1523: FOR UPDATE OF object_version_number NOWAIT;
1524:

Line 1527: FROM okl_fe_std_rt_tmp_all_b

1523: FOR UPDATE OF object_version_number NOWAIT;
1524:
1525: CURSOR lchk_csr(p_srtb_rec IN okl_srtb_rec) IS
1526: SELECT object_version_number
1527: FROM okl_fe_std_rt_tmp_all_b
1528: WHERE std_rate_tmpl_id = p_srtb_rec.std_rate_tmpl_id;
1529: l_api_version CONSTANT NUMBER := 1;
1530: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1531: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

Line 1957: INSERT INTO okl_fe_std_rt_tmp_all_b

1953: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1954: RAISE okl_api.g_exception_error;
1955: END IF;
1956:
1957: INSERT INTO okl_fe_std_rt_tmp_all_b
1958: (std_rate_tmpl_id
1959: ,template_name
1960: ,object_version_number
1961: ,org_id

Line 2477: UPDATE okl_fe_std_rt_tmp_all_b

2473: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2474: RAISE okl_api.g_exception_error;
2475: END IF;
2476:
2477: UPDATE okl_fe_std_rt_tmp_all_b
2478: SET std_rate_tmpl_id = l_def_srtb_rec.std_rate_tmpl_id
2479: ,template_name = l_def_srtb_rec.template_name
2480: ,object_version_number = l_def_srtb_rec.object_version_number + 1
2481: ,org_id = l_def_srtb_rec.org_id

Line 3117: DELETE FROM okl_fe_std_rt_tmp_all_b

3113: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3114: RAISE okl_api.g_exception_error;
3115: END IF;
3116:
3117: DELETE FROM okl_fe_std_rt_tmp_all_b
3118: WHERE std_rate_tmpl_id = l_srtb_rec.std_rate_tmpl_id;
3119:
3120: EXCEPTION
3121: WHEN g_exception_halt_validation THEN