APPS.OKL_ETH_PVT dependencies on OKL_FE_EO_TERMS_ALL_TL

Line 30: DELETE FROM OKL_FE_EO_TERMS_ALL_TL t

26: PROCEDURE add_language IS
27:
28: BEGIN
29:
30: DELETE FROM OKL_FE_EO_TERMS_ALL_TL t
31: WHERE NOT EXISTS(SELECT NULL
32: FROM OKL_FE_EO_TERMS_ALL_B b
33: WHERE b.end_of_term_id = t.end_of_term_id);
34:

Line 35: UPDATE OKL_FE_EO_TERMS_ALL_TL t

31: WHERE NOT EXISTS(SELECT NULL
32: FROM OKL_FE_EO_TERMS_ALL_B b
33: WHERE b.end_of_term_id = t.end_of_term_id);
34:
35: UPDATE OKL_FE_EO_TERMS_ALL_TL t
36: SET(end_of_term_desc) = (SELECT
37: -- LANGUAGE,
38:
39: -- B.LANGUAGE,

Line 42: FROM OKL_FE_EO_TERMS_ALL_TL b

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

Line 46: FROM OKL_FE_EO_TERMS_ALL_TL subb ,OKL_FE_EO_TERMS_ALL_TL subt

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

Line 52: INSERT INTO OKL_FE_EO_TERMS_ALL_TL

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

Line 73: FROM OKL_FE_EO_TERMS_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_EO_TERMS_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_EO_TERMS_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_EO_TERMS_ALL_TL t
79: WHERE t.end_of_term_id = b.end_of_term_id AND t.language = l.language_code);
80:
81: END add_language;
82:

Line 768: -- Procedure get_rec forOKL_FE_EO_TERMS_ALL_TL

764: ,l_row_notfound));
765: END get_rec;
766:
767: --------------------------------------------------------------------------------
768: -- Procedure get_rec forOKL_FE_EO_TERMS_ALL_TL
769: --------------------------------------------------------------------------------
770:
771: FUNCTION get_rec(p_ethtl_rec IN okl_ethtl_rec
772: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_ethtl_rec IS

Line 786: FROM okl_fe_eo_terms_all_tl

782: ,creation_date
783: ,last_updated_by
784: ,last_update_date
785: ,last_update_login
786: FROM okl_fe_eo_terms_all_tl
787: WHERE okl_fe_eo_terms_all_tl.end_of_term_id = p_id
788: AND okl_fe_eo_terms_all_tl.language = p_language;
789: l_ethtl_pk postl_pk_csr%ROWTYPE;
790: l_ethtl_rec okl_ethtl_rec;

Line 787: WHERE okl_fe_eo_terms_all_tl.end_of_term_id = p_id

783: ,last_updated_by
784: ,last_update_date
785: ,last_update_login
786: FROM okl_fe_eo_terms_all_tl
787: WHERE okl_fe_eo_terms_all_tl.end_of_term_id = p_id
788: AND okl_fe_eo_terms_all_tl.language = p_language;
789: l_ethtl_pk postl_pk_csr%ROWTYPE;
790: l_ethtl_rec okl_ethtl_rec;
791:

Line 788: AND okl_fe_eo_terms_all_tl.language = p_language;

784: ,last_update_date
785: ,last_update_login
786: FROM okl_fe_eo_terms_all_tl
787: WHERE okl_fe_eo_terms_all_tl.end_of_term_id = p_id
788: AND okl_fe_eo_terms_all_tl.language = p_language;
789: l_ethtl_pk postl_pk_csr%ROWTYPE;
790: l_ethtl_rec okl_ethtl_rec;
791:
792: BEGIN

Line 1433: FROM okl_fe_eo_terms_all_tl

1429: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
1430:
1431: CURSOR lock_csr(p_ethtl_rec IN okl_ethtl_rec) IS
1432: SELECT *
1433: FROM okl_fe_eo_terms_all_tl
1434: WHERE end_of_term_id = p_ethtl_rec.end_of_term_id
1435: FOR UPDATE NOWAIT;
1436: l_api_version CONSTANT NUMBER := 1;
1437: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1917: INSERT INTO okl_fe_eo_terms_all_tl

1913:
1914: FOR l_lang_rec IN get_languages LOOP
1915: l_ethtl_rec.language := l_lang_rec.language_code;
1916:
1917: INSERT INTO okl_fe_eo_terms_all_tl
1918: (end_of_term_id
1919: ,end_of_term_desc
1920: ,language
1921: ,source_lang

Line 2384: UPDATE okl_fe_eo_terms_all_tl

2380: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2381: RAISE okc_api.g_exception_error;
2382: END IF;
2383:
2384: UPDATE okl_fe_eo_terms_all_tl
2385: SET end_of_term_id = l_def_ethtl_rec.end_of_term_id
2386: ,end_of_term_desc = l_def_ethtl_rec.end_of_term_desc
2387: ,language = l_def_ethtl_rec.language
2388: ,source_lang = l_def_ethtl_rec.source_lang

Line 2398: UPDATE okl_fe_eo_terms_all_tl

2394: ,last_update_login = l_def_ethtl_rec.last_update_login
2395: WHERE end_of_term_id = l_def_ethtl_rec.end_of_term_id
2396: AND language = l_def_ethtl_rec.language;
2397:
2398: UPDATE okl_fe_eo_terms_all_tl
2399: SET sfwt_flag = 'Y'
2400: WHERE end_of_term_id = l_def_ethtl_rec.end_of_term_id
2401: AND source_lang <> USERENV('LANG');
2402:

Line 2956: DELETE FROM okl_fe_eo_terms_all_tl

2952: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2953: RAISE okc_api.g_exception_error;
2954: END IF;
2955:
2956: DELETE FROM okl_fe_eo_terms_all_tl
2957: WHERE end_of_term_id = l_ethtl_rec.end_of_term_id;
2958:
2959: EXCEPTION
2960: WHEN g_exception_halt_validation THEN