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 55: FROM okl_ls_rt_fctr_sets_tl b

51: ,b.CREATION_DATE
52: ,b.LAST_UPDATED_BY
53: ,b.LAST_UPDATE_DATE
54: ,b.LAST_UPDATE_LOGIN
55: FROM okl_ls_rt_fctr_sets_tl b
56: ,fnd_languages l
57: WHERE l.installed_flag IN('I', 'B')
58: AND b.language = userenv('LANG')
59: AND NOT EXISTS(SELECT NULL

Line 60: FROM okl_ls_rt_fctr_sets_tl t

56: ,fnd_languages l
57: WHERE l.installed_flag IN('I', 'B')
58: AND b.language = userenv('LANG')
59: AND NOT EXISTS(SELECT NULL
60: FROM okl_ls_rt_fctr_sets_tl t
61: WHERE t.id = b.id AND t.language = l.language_code);
62:
63: END add_language;
64:

Line 1247: INSERT INTO okl_ls_rt_fctr_sets_tl

1243: IF l_lang_rec.language_code = userenv('LANG') THEN
1244: l_miss_flag := 'N';
1245: END IF;
1246:
1247: INSERT INTO okl_ls_rt_fctr_sets_tl
1248: (id
1249: ,language
1250: ,source_lang
1251: ,sfwt_flag

Line 1535: FROM okl_ls_rt_fctr_sets_tl

1531: PRAGMA exception_init(e_resource_busy, - 00054);
1532:
1533: CURSOR lock_csr(p_lrttl_rec IN lrttl_rec_type) IS
1534: SELECT *
1535: FROM okl_ls_rt_fctr_sets_tl
1536: WHERE id = p_lrttl_rec.id
1537: FOR UPDATE NOWAIT;
1538: l_return_status varchar2(1) := g_ret_sts_success;
1539: l_lock_var lock_csr%ROWTYPE;

Line 1771: FROM okl_ls_rt_fctr_sets_tl

1767: WHERE installed_flag IN('I', 'B') AND language_code = userenv('LANG');
1768:
1769: CURSOR c_lang_found IS
1770: SELECT 'Y'
1771: FROM okl_ls_rt_fctr_sets_tl
1772: WHERE id = p_lrttl_rec.id AND language = userenv('LANG');
1773: l_lang_setup varchar2(1) := 'N';
1774: l_lang_found varchar2(1) := 'N';
1775:

Line 1793: INSERT INTO okl_ls_rt_fctr_sets_tl

1789: CLOSE c_lang_found;
1790:
1791: IF l_lang_found = 'N' THEN
1792:
1793: INSERT INTO okl_ls_rt_fctr_sets_tl
1794: (id
1795: ,language
1796: ,source_lang
1797: ,sfwt_flag

Line 1817: UPDATE okl_ls_rt_fctr_sets_tl

1813: ,p_lrttl_rec.last_update_login);
1814:
1815: END IF;
1816:
1817: UPDATE okl_ls_rt_fctr_sets_tl
1818: SET description = p_lrttl_rec.description
1819: ,source_lang = userenv('LANG')
1820: ,created_by = p_lrttl_rec.created_by
1821: ,creation_date = p_lrttl_rec.creation_date

Line 1827: UPDATE okl_ls_rt_fctr_sets_tl

1823: ,last_update_date = p_lrttl_rec.last_update_date
1824: ,last_update_login = p_lrttl_rec.last_update_login
1825: WHERE id = p_lrttl_rec.id;
1826:
1827: UPDATE okl_ls_rt_fctr_sets_tl
1828: SET sfwt_flag = 'Y'
1829: WHERE id = p_lrttl_rec.id AND source_lang <> language;
1830:
1831: UPDATE okl_ls_rt_fctr_sets_tl

Line 1831: UPDATE okl_ls_rt_fctr_sets_tl

1827: UPDATE okl_ls_rt_fctr_sets_tl
1828: SET sfwt_flag = 'Y'
1829: WHERE id = p_lrttl_rec.id AND source_lang <> language;
1830:
1831: UPDATE okl_ls_rt_fctr_sets_tl
1832: SET sfwt_flag = 'N'
1833: WHERE id = p_lrttl_rec.id AND source_lang = language;
1834: x_return_status := g_ret_sts_success;
1835: EXCEPTION

Line 2247: DELETE FROM okl_ls_rt_fctr_sets_tl

2243: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'delete_row (TL)';
2244:
2245: BEGIN
2246:
2247: DELETE FROM okl_ls_rt_fctr_sets_tl
2248: WHERE id = p_lrttl_rec.id;
2249: x_return_status := g_ret_sts_success;
2250: EXCEPTION
2251: WHEN okl_api.g_exception_error THEN