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

59: ,l.language_code
60: ,b.source_lang
61: ,b.sfwt_flag
62: ,b.end_of_term_desc
63: FROM OKL_FE_EO_TERMS_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_EO_TERMS_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_EO_TERMS_ALL_TL t
69: WHERE t.end_of_term_id = b.end_of_term_id AND t.language = l.language_code);
70:
71: END add_language;
72:

Line 758: -- Procedure get_rec forOKL_FE_EO_TERMS_ALL_TL

754: ,l_row_notfound));
755: END get_rec;
756:
757: --------------------------------------------------------------------------------
758: -- Procedure get_rec forOKL_FE_EO_TERMS_ALL_TL
759: --------------------------------------------------------------------------------
760:
761: FUNCTION get_rec(p_ethtl_rec IN okl_ethtl_rec
762: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_ethtl_rec IS

Line 776: FROM okl_fe_eo_terms_all_tl

772: ,creation_date
773: ,last_updated_by
774: ,last_update_date
775: ,last_update_login
776: FROM okl_fe_eo_terms_all_tl
777: WHERE okl_fe_eo_terms_all_tl.end_of_term_id = p_id
778: AND okl_fe_eo_terms_all_tl.language = p_language;
779: l_ethtl_pk postl_pk_csr%ROWTYPE;
780: l_ethtl_rec okl_ethtl_rec;

Line 777: WHERE okl_fe_eo_terms_all_tl.end_of_term_id = p_id

773: ,last_updated_by
774: ,last_update_date
775: ,last_update_login
776: FROM okl_fe_eo_terms_all_tl
777: WHERE okl_fe_eo_terms_all_tl.end_of_term_id = p_id
778: AND okl_fe_eo_terms_all_tl.language = p_language;
779: l_ethtl_pk postl_pk_csr%ROWTYPE;
780: l_ethtl_rec okl_ethtl_rec;
781:

Line 778: AND okl_fe_eo_terms_all_tl.language = p_language;

774: ,last_update_date
775: ,last_update_login
776: FROM okl_fe_eo_terms_all_tl
777: WHERE okl_fe_eo_terms_all_tl.end_of_term_id = p_id
778: AND okl_fe_eo_terms_all_tl.language = p_language;
779: l_ethtl_pk postl_pk_csr%ROWTYPE;
780: l_ethtl_rec okl_ethtl_rec;
781:
782: BEGIN

Line 1423: FROM okl_fe_eo_terms_all_tl

1419: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
1420:
1421: CURSOR lock_csr(p_ethtl_rec IN okl_ethtl_rec) IS
1422: SELECT *
1423: FROM okl_fe_eo_terms_all_tl
1424: WHERE end_of_term_id = p_ethtl_rec.end_of_term_id
1425: FOR UPDATE NOWAIT;
1426: l_api_version CONSTANT NUMBER := 1;
1427: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1907: INSERT INTO okl_fe_eo_terms_all_tl

1903:
1904: FOR l_lang_rec IN get_languages LOOP
1905: l_ethtl_rec.language := l_lang_rec.language_code;
1906:
1907: INSERT INTO okl_fe_eo_terms_all_tl
1908: (end_of_term_id
1909: ,end_of_term_desc
1910: ,language
1911: ,source_lang

Line 2374: UPDATE okl_fe_eo_terms_all_tl

2370: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2371: RAISE okc_api.g_exception_error;
2372: END IF;
2373:
2374: UPDATE okl_fe_eo_terms_all_tl
2375: SET end_of_term_id = l_def_ethtl_rec.end_of_term_id
2376: ,end_of_term_desc = l_def_ethtl_rec.end_of_term_desc
2377: ,language = l_def_ethtl_rec.language
2378: ,source_lang = l_def_ethtl_rec.source_lang

Line 2388: UPDATE okl_fe_eo_terms_all_tl

2384: ,last_update_login = l_def_ethtl_rec.last_update_login
2385: WHERE end_of_term_id = l_def_ethtl_rec.end_of_term_id
2386: AND language = l_def_ethtl_rec.language;
2387:
2388: UPDATE okl_fe_eo_terms_all_tl
2389: SET sfwt_flag = 'Y'
2390: WHERE end_of_term_id = l_def_ethtl_rec.end_of_term_id
2391: AND source_lang <> USERENV('LANG');
2392:

Line 2946: DELETE FROM okl_fe_eo_terms_all_tl

2942: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2943: RAISE okc_api.g_exception_error;
2944: END IF;
2945:
2946: DELETE FROM okl_fe_eo_terms_all_tl
2947: WHERE end_of_term_id = l_ethtl_rec.end_of_term_id;
2948:
2949: EXCEPTION
2950: WHEN g_exception_halt_validation THEN