APPS.OKL_LRT_PVT dependencies on OKL_LS_RT_FCTR_SETS_TL

Line 12: DELETE FROM okl_ls_rt_fctr_sets_tl t

8: PROCEDURE add_language IS
9:
10: BEGIN
11:
12: DELETE FROM okl_ls_rt_fctr_sets_tl t
13: WHERE NOT EXISTS(SELECT NULL
14: FROM OKL_LS_RT_FTR_SETS_ALL_B b
15: WHERE b.id = t.id);
16:

Line 17: UPDATE okl_ls_rt_fctr_sets_tl t

13: WHERE NOT EXISTS(SELECT NULL
14: FROM OKL_LS_RT_FTR_SETS_ALL_B b
15: WHERE b.id = t.id);
16:
17: UPDATE okl_ls_rt_fctr_sets_tl t
18: SET(description) = (SELECT
19: -- LANGUAGE,
20:
21: -- B.LANGUAGE,

Line 24: FROM okl_ls_rt_fctr_sets_tl b

20:
21: -- B.LANGUAGE,
22:
23: b.description
24: FROM okl_ls_rt_fctr_sets_tl b
25: WHERE b.id = t.id
26: AND b.language = t.source_lang)
27: WHERE (t.id, t.language) IN(SELECT subt.id ,subt.language
28: FROM okl_ls_rt_fctr_sets_tl subb ,okl_ls_rt_fctr_sets_tl subt

Line 28: FROM okl_ls_rt_fctr_sets_tl subb ,okl_ls_rt_fctr_sets_tl subt

24: FROM okl_ls_rt_fctr_sets_tl b
25: WHERE b.id = t.id
26: AND b.language = t.source_lang)
27: WHERE (t.id, t.language) IN(SELECT subt.id ,subt.language
28: FROM okl_ls_rt_fctr_sets_tl subb ,okl_ls_rt_fctr_sets_tl subt
29: WHERE subb.id = subt.id AND subb.language = subt.language AND ( -- SUBB.LANGUAGE <> SUBT.LANGUAGE OR
30: subb.description <> subt.description OR (subb.language IS NOT NULL
31: AND subt.language IS NULL)
32: OR (subb.description IS NULL AND subt.description IS NOT NULL)));

Line 34: INSERT INTO okl_ls_rt_fctr_sets_tl

30: subb.description <> subt.description OR (subb.language IS NOT NULL
31: AND subt.language IS NULL)
32: OR (subb.description IS NULL AND subt.description IS NOT NULL)));
33:
34: INSERT INTO okl_ls_rt_fctr_sets_tl
35: (id
36: ,language
37: ,source_lang
38: ,sfwt_flag

Line 45: FROM okl_ls_rt_fctr_sets_tl b

41: ,l.language_code
42: ,b.source_lang
43: ,b.sfwt_flag
44: ,b.description
45: FROM okl_ls_rt_fctr_sets_tl b
46: ,fnd_languages l
47: WHERE l.installed_flag IN('I', 'B')
48: AND b.language = userenv('LANG')
49: AND NOT EXISTS(SELECT NULL

Line 50: FROM okl_ls_rt_fctr_sets_tl t

46: ,fnd_languages l
47: WHERE l.installed_flag IN('I', 'B')
48: AND b.language = userenv('LANG')
49: AND NOT EXISTS(SELECT NULL
50: FROM okl_ls_rt_fctr_sets_tl t
51: WHERE t.id = b.id AND t.language = l.language_code);
52:
53: END add_language;
54:

Line 1237: INSERT INTO okl_ls_rt_fctr_sets_tl

1233: IF l_lang_rec.language_code = userenv('LANG') THEN
1234: l_miss_flag := 'N';
1235: END IF;
1236:
1237: INSERT INTO okl_ls_rt_fctr_sets_tl
1238: (id
1239: ,language
1240: ,source_lang
1241: ,sfwt_flag

Line 1525: FROM okl_ls_rt_fctr_sets_tl

1521: PRAGMA exception_init(e_resource_busy, - 00054);
1522:
1523: CURSOR lock_csr(p_lrttl_rec IN lrttl_rec_type) IS
1524: SELECT *
1525: FROM okl_ls_rt_fctr_sets_tl
1526: WHERE id = p_lrttl_rec.id
1527: FOR UPDATE NOWAIT;
1528: l_return_status varchar2(1) := g_ret_sts_success;
1529: l_lock_var lock_csr%ROWTYPE;

Line 1761: FROM okl_ls_rt_fctr_sets_tl

1757: WHERE installed_flag IN('I', 'B') AND language_code = userenv('LANG');
1758:
1759: CURSOR c_lang_found IS
1760: SELECT 'Y'
1761: FROM okl_ls_rt_fctr_sets_tl
1762: WHERE id = p_lrttl_rec.id AND language = userenv('LANG');
1763: l_lang_setup varchar2(1) := 'N';
1764: l_lang_found varchar2(1) := 'N';
1765:

Line 1783: INSERT INTO okl_ls_rt_fctr_sets_tl

1779: CLOSE c_lang_found;
1780:
1781: IF l_lang_found = 'N' THEN
1782:
1783: INSERT INTO okl_ls_rt_fctr_sets_tl
1784: (id
1785: ,language
1786: ,source_lang
1787: ,sfwt_flag

Line 1807: UPDATE okl_ls_rt_fctr_sets_tl

1803: ,p_lrttl_rec.last_update_login);
1804:
1805: END IF;
1806:
1807: UPDATE okl_ls_rt_fctr_sets_tl
1808: SET description = p_lrttl_rec.description
1809: ,source_lang = userenv('LANG')
1810: ,created_by = p_lrttl_rec.created_by
1811: ,creation_date = p_lrttl_rec.creation_date

Line 1817: UPDATE okl_ls_rt_fctr_sets_tl

1813: ,last_update_date = p_lrttl_rec.last_update_date
1814: ,last_update_login = p_lrttl_rec.last_update_login
1815: WHERE id = p_lrttl_rec.id;
1816:
1817: UPDATE okl_ls_rt_fctr_sets_tl
1818: SET sfwt_flag = 'Y'
1819: WHERE id = p_lrttl_rec.id AND source_lang <> language;
1820:
1821: UPDATE okl_ls_rt_fctr_sets_tl

Line 1821: UPDATE okl_ls_rt_fctr_sets_tl

1817: UPDATE okl_ls_rt_fctr_sets_tl
1818: SET sfwt_flag = 'Y'
1819: WHERE id = p_lrttl_rec.id AND source_lang <> language;
1820:
1821: UPDATE okl_ls_rt_fctr_sets_tl
1822: SET sfwt_flag = 'N'
1823: WHERE id = p_lrttl_rec.id AND source_lang = language;
1824: x_return_status := g_ret_sts_success;
1825: EXCEPTION

Line 2237: DELETE FROM okl_ls_rt_fctr_sets_tl

2233: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'delete_row (TL)';
2234:
2235: BEGIN
2236:
2237: DELETE FROM okl_ls_rt_fctr_sets_tl
2238: WHERE id = p_lrttl_rec.id;
2239: x_return_status := g_ret_sts_success;
2240: EXCEPTION
2241: WHEN okl_api.g_exception_error THEN