APPS.OKL_SRT_PVT dependencies on OKL_FE_STD_RT_TMP_ALL_TL

Line 30: DELETE FROM OKL_FE_STD_RT_TMP_ALL_TL t

26: PROCEDURE add_language IS
27:
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:

Line 35: UPDATE 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
37: -- LANGUAGE,
38:
39: -- B.LANGUAGE,

Line 42: FROM OKL_FE_STD_RT_TMP_ALL_TL b

38:
39: -- B.LANGUAGE,
40:
41: b.template_desc
42: FROM OKL_FE_STD_RT_TMP_ALL_TL b
43: WHERE b.std_rate_tmpl_id = t.std_rate_tmpl_id
44: AND b.language = t.source_lang)
45: WHERE (t.std_rate_tmpl_id, t.language) IN(SELECT subt.std_rate_tmpl_id ,subt.language
46: FROM OKL_FE_STD_RT_TMP_ALL_TL subb ,OKL_FE_STD_RT_TMP_ALL_TL subt

Line 46: FROM OKL_FE_STD_RT_TMP_ALL_TL subb ,OKL_FE_STD_RT_TMP_ALL_TL subt

42: FROM OKL_FE_STD_RT_TMP_ALL_TL b
43: WHERE b.std_rate_tmpl_id = t.std_rate_tmpl_id
44: AND b.language = t.source_lang)
45: WHERE (t.std_rate_tmpl_id, t.language) IN(SELECT subt.std_rate_tmpl_id ,subt.language
46: FROM OKL_FE_STD_RT_TMP_ALL_TL subb ,OKL_FE_STD_RT_TMP_ALL_TL subt
47: WHERE subb.std_rate_tmpl_id = subt.std_rate_tmpl_id AND subb.language = subt.language AND ( -- SUBB.LANGUAGE <> SUBT.LANGUAGE OR
48: subb.template_desc <> subt.template_desc OR (subb.language IS NOT NULL
49: AND subt.language IS NULL)
50: OR (subb.template_desc IS NULL AND subt.template_desc IS NOT NULL)));

Line 52: INSERT INTO OKL_FE_STD_RT_TMP_ALL_TL

48: subb.template_desc <> subt.template_desc OR (subb.language IS NOT NULL
49: AND subt.language IS NULL)
50: OR (subb.template_desc IS NULL AND subt.template_desc IS NOT NULL)));
51:
52: INSERT INTO OKL_FE_STD_RT_TMP_ALL_TL
53: (std_rate_tmpl_id
54: ,language
55: ,source_lang
56: ,sfwt_flag

Line 73: FROM OKL_FE_STD_RT_TMP_ALL_TL b

69: ,b.CREATION_DATE
70: ,b.LAST_UPDATED_BY
71: ,b.LAST_UPDATE_DATE
72: ,b.LAST_UPDATE_LOGIN
73: FROM OKL_FE_STD_RT_TMP_ALL_TL b
74: ,fnd_languages l
75: WHERE l.installed_flag IN('I', 'B')
76: AND b.language = userenv('LANG')
77: AND NOT EXISTS(SELECT NULL

Line 78: FROM OKL_FE_STD_RT_TMP_ALL_TL t

74: ,fnd_languages l
75: WHERE l.installed_flag IN('I', 'B')
76: AND b.language = userenv('LANG')
77: AND NOT EXISTS(SELECT NULL
78: FROM OKL_FE_STD_RT_TMP_ALL_TL t
79: WHERE t.std_rate_tmpl_id = b.std_rate_tmpl_id AND t.language = l.language_code);
80:
81: END add_language;
82:

Line 889: -- Procedure get_rec forOKL_FE_STD_RT_TMP_ALL_TL

885: ,l_row_notfound));
886: END get_rec;
887:
888: --------------------------------------------------------------------------------
889: -- Procedure get_rec forOKL_FE_STD_RT_TMP_ALL_TL
890: --------------------------------------------------------------------------------
891:
892: FUNCTION get_rec(p_srttl_rec IN okl_srttl_rec
893: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_srttl_rec IS

Line 907: FROM okl_fe_std_rt_tmp_all_tl

903: ,creation_date
904: ,last_updated_by
905: ,last_update_date
906: ,last_update_login
907: FROM okl_fe_std_rt_tmp_all_tl
908: WHERE okl_fe_std_rt_tmp_all_tl.std_rate_tmpl_id = p_id
909: AND okl_fe_std_rt_tmp_all_tl.language = p_language;
910: l_srttl_pk srttl_pk_csr%ROWTYPE;
911: l_srttl_rec okl_srttl_rec;

Line 908: WHERE okl_fe_std_rt_tmp_all_tl.std_rate_tmpl_id = p_id

904: ,last_updated_by
905: ,last_update_date
906: ,last_update_login
907: FROM okl_fe_std_rt_tmp_all_tl
908: WHERE okl_fe_std_rt_tmp_all_tl.std_rate_tmpl_id = p_id
909: AND okl_fe_std_rt_tmp_all_tl.language = p_language;
910: l_srttl_pk srttl_pk_csr%ROWTYPE;
911: l_srttl_rec okl_srttl_rec;
912:

Line 909: AND okl_fe_std_rt_tmp_all_tl.language = p_language;

905: ,last_update_date
906: ,last_update_login
907: FROM okl_fe_std_rt_tmp_all_tl
908: WHERE okl_fe_std_rt_tmp_all_tl.std_rate_tmpl_id = p_id
909: AND okl_fe_std_rt_tmp_all_tl.language = p_language;
910: l_srttl_pk srttl_pk_csr%ROWTYPE;
911: l_srttl_rec okl_srttl_rec;
912:
913: BEGIN

Line 1647: FROM okl_fe_std_rt_tmp_all_tl

1643: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
1644:
1645: CURSOR lock_csr(p_srttl_rec IN okl_srttl_rec) IS
1646: SELECT *
1647: FROM okl_fe_std_rt_tmp_all_tl
1648: WHERE std_rate_tmpl_id = p_srttl_rec.std_rate_tmpl_id
1649: FOR UPDATE NOWAIT;
1650: l_api_version CONSTANT NUMBER := 1;
1651: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2139: INSERT INTO okl_fe_std_rt_tmp_all_tl

2135:
2136: FOR l_lang_rec IN get_languages LOOP
2137: l_srttl_rec.language := l_lang_rec.language_code;
2138:
2139: INSERT INTO okl_fe_std_rt_tmp_all_tl
2140: (std_rate_tmpl_id
2141: ,template_desc
2142: ,language
2143: ,source_lang

Line 2617: UPDATE okl_fe_std_rt_tmp_all_tl

2613: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2614: RAISE okl_api.g_exception_error;
2615: END IF;
2616:
2617: UPDATE okl_fe_std_rt_tmp_all_tl
2618: SET std_rate_tmpl_id = l_def_srttl_rec.std_rate_tmpl_id
2619: ,template_desc = l_def_srttl_rec.template_desc
2620: ,language = l_def_srttl_rec.language
2621: ,source_lang = l_def_srttl_rec.source_lang

Line 2631: UPDATE okl_fe_std_rt_tmp_all_tl

2627: ,last_update_login = l_def_srttl_rec.last_update_login
2628: WHERE std_rate_tmpl_id = l_def_srttl_rec.std_rate_tmpl_id
2629: AND language = l_def_srttl_rec.language;
2630:
2631: UPDATE okl_fe_std_rt_tmp_all_tl
2632: SET sfwt_flag = 'Y'
2633: WHERE std_rate_tmpl_id = l_def_srttl_rec.std_rate_tmpl_id
2634: AND source_lang <> USERENV('LANG');
2635:

Line 3212: DELETE FROM okl_fe_std_rt_tmp_all_tl

3208: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3209: RAISE okl_api.g_exception_error;
3210: END IF;
3211:
3212: DELETE FROM okl_fe_std_rt_tmp_all_tl
3213: WHERE std_rate_tmpl_id = l_srttl_rec.std_rate_tmpl_id;
3214:
3215: EXCEPTION
3216: WHEN g_exception_halt_validation THEN