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 63: FROM OKL_FE_STD_RT_TMP_ALL_TL b

59: ,l.language_code
60: ,b.source_lang
61: ,b.sfwt_flag
62: ,b.template_desc
63: FROM OKL_FE_STD_RT_TMP_ALL_TL b
64: ,fnd_languages l
65: WHERE l.installed_flag IN('I', 'B')
66: AND b.language = userenv('LANG')
67: AND NOT EXISTS(SELECT NULL

Line 68: FROM OKL_FE_STD_RT_TMP_ALL_TL t

64: ,fnd_languages l
65: WHERE l.installed_flag IN('I', 'B')
66: AND b.language = userenv('LANG')
67: AND NOT EXISTS(SELECT NULL
68: FROM OKL_FE_STD_RT_TMP_ALL_TL t
69: WHERE t.std_rate_tmpl_id = b.std_rate_tmpl_id AND t.language = l.language_code);
70:
71: END add_language;
72:

Line 879: -- Procedure get_rec forOKL_FE_STD_RT_TMP_ALL_TL

875: ,l_row_notfound));
876: END get_rec;
877:
878: --------------------------------------------------------------------------------
879: -- Procedure get_rec forOKL_FE_STD_RT_TMP_ALL_TL
880: --------------------------------------------------------------------------------
881:
882: FUNCTION get_rec(p_srttl_rec IN okl_srttl_rec
883: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_srttl_rec IS

Line 897: FROM okl_fe_std_rt_tmp_all_tl

893: ,creation_date
894: ,last_updated_by
895: ,last_update_date
896: ,last_update_login
897: FROM okl_fe_std_rt_tmp_all_tl
898: WHERE okl_fe_std_rt_tmp_all_tl.std_rate_tmpl_id = p_id
899: AND okl_fe_std_rt_tmp_all_tl.language = p_language;
900: l_srttl_pk srttl_pk_csr%ROWTYPE;
901: l_srttl_rec okl_srttl_rec;

Line 898: WHERE okl_fe_std_rt_tmp_all_tl.std_rate_tmpl_id = p_id

894: ,last_updated_by
895: ,last_update_date
896: ,last_update_login
897: FROM okl_fe_std_rt_tmp_all_tl
898: WHERE okl_fe_std_rt_tmp_all_tl.std_rate_tmpl_id = p_id
899: AND okl_fe_std_rt_tmp_all_tl.language = p_language;
900: l_srttl_pk srttl_pk_csr%ROWTYPE;
901: l_srttl_rec okl_srttl_rec;
902:

Line 899: AND okl_fe_std_rt_tmp_all_tl.language = p_language;

895: ,last_update_date
896: ,last_update_login
897: FROM okl_fe_std_rt_tmp_all_tl
898: WHERE okl_fe_std_rt_tmp_all_tl.std_rate_tmpl_id = p_id
899: AND okl_fe_std_rt_tmp_all_tl.language = p_language;
900: l_srttl_pk srttl_pk_csr%ROWTYPE;
901: l_srttl_rec okl_srttl_rec;
902:
903: BEGIN

Line 1637: FROM okl_fe_std_rt_tmp_all_tl

1633: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
1634:
1635: CURSOR lock_csr(p_srttl_rec IN okl_srttl_rec) IS
1636: SELECT *
1637: FROM okl_fe_std_rt_tmp_all_tl
1638: WHERE std_rate_tmpl_id = p_srttl_rec.std_rate_tmpl_id
1639: FOR UPDATE NOWAIT;
1640: l_api_version CONSTANT NUMBER := 1;
1641: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2129: INSERT INTO okl_fe_std_rt_tmp_all_tl

2125:
2126: FOR l_lang_rec IN get_languages LOOP
2127: l_srttl_rec.language := l_lang_rec.language_code;
2128:
2129: INSERT INTO okl_fe_std_rt_tmp_all_tl
2130: (std_rate_tmpl_id
2131: ,template_desc
2132: ,language
2133: ,source_lang

Line 2607: UPDATE okl_fe_std_rt_tmp_all_tl

2603: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2604: RAISE okl_api.g_exception_error;
2605: END IF;
2606:
2607: UPDATE okl_fe_std_rt_tmp_all_tl
2608: SET std_rate_tmpl_id = l_def_srttl_rec.std_rate_tmpl_id
2609: ,template_desc = l_def_srttl_rec.template_desc
2610: ,language = l_def_srttl_rec.language
2611: ,source_lang = l_def_srttl_rec.source_lang

Line 2621: UPDATE okl_fe_std_rt_tmp_all_tl

2617: ,last_update_login = l_def_srttl_rec.last_update_login
2618: WHERE std_rate_tmpl_id = l_def_srttl_rec.std_rate_tmpl_id
2619: AND language = l_def_srttl_rec.language;
2620:
2621: UPDATE okl_fe_std_rt_tmp_all_tl
2622: SET sfwt_flag = 'Y'
2623: WHERE std_rate_tmpl_id = l_def_srttl_rec.std_rate_tmpl_id
2624: AND source_lang <> USERENV('LANG');
2625:

Line 3202: DELETE FROM okl_fe_std_rt_tmp_all_tl

3198: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
3199: RAISE okl_api.g_exception_error;
3200: END IF;
3201:
3202: DELETE FROM okl_fe_std_rt_tmp_all_tl
3203: WHERE std_rate_tmpl_id = l_srttl_rec.std_rate_tmpl_id;
3204:
3205: EXCEPTION
3206: WHEN g_exception_halt_validation THEN