eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ECC_PVT dependencies on OKL_FE_CRIT_CAT_DEF_TL

Line 42: DELETE FROM OKL_FE_CRIT_CAT_DEF_TL t

38: PROCEDURE add_language IS
39:
40: BEGIN
41:
42: DELETE FROM OKL_FE_CRIT_CAT_DEF_TL t
43: WHERE NOT EXISTS(SELECT NULL
44: FROM OKL_FE_CRIT_CAT_DEF_B b
45: WHERE b.crit_cat_def_id = t.crit_cat_def_id);
46:

Line 47: UPDATE OKL_FE_CRIT_CAT_DEF_TL t

43: WHERE NOT EXISTS(SELECT NULL
44: FROM OKL_FE_CRIT_CAT_DEF_B b
45: WHERE b.crit_cat_def_id = t.crit_cat_def_id);
46:
47: UPDATE OKL_FE_CRIT_CAT_DEF_TL t
48: SET(crit_cat_desc) = (SELECT
49: -- LANGUAGE,
50:
51: -- B.LANGUAGE,

Line 54: FROM OKL_FE_CRIT_CAT_DEF_TL b

50:
51: -- B.LANGUAGE,
52:
53: b.crit_cat_desc
54: FROM OKL_FE_CRIT_CAT_DEF_TL b
55: WHERE b.crit_cat_def_id = t.crit_cat_def_id
56: AND b.language = t.source_lang)
57: WHERE (t.crit_cat_def_id, t.language) IN(SELECT subt.crit_cat_def_id ,subt.language
58: FROM OKL_FE_CRIT_CAT_DEF_TL subb ,OKL_FE_CRIT_CAT_DEF_TL subt

Line 58: FROM OKL_FE_CRIT_CAT_DEF_TL subb ,OKL_FE_CRIT_CAT_DEF_TL subt

54: FROM OKL_FE_CRIT_CAT_DEF_TL b
55: WHERE b.crit_cat_def_id = t.crit_cat_def_id
56: AND b.language = t.source_lang)
57: WHERE (t.crit_cat_def_id, t.language) IN(SELECT subt.crit_cat_def_id ,subt.language
58: FROM OKL_FE_CRIT_CAT_DEF_TL subb ,OKL_FE_CRIT_CAT_DEF_TL subt
59: WHERE subb.crit_cat_def_id = subt.crit_cat_def_id AND subb.language = subt.language AND ( -- SUBB.LANGUAGE <> SUBT.LANGUAGE OR
60: subb.crit_cat_desc <> subt.crit_cat_desc OR (subb.language IS NOT NULL
61: AND subt.language IS NULL)
62: OR (subb.crit_cat_desc IS NULL AND subt.crit_cat_desc IS NOT NULL)));

Line 64: INSERT INTO OKL_FE_CRIT_CAT_DEF_TL

60: subb.crit_cat_desc <> subt.crit_cat_desc OR (subb.language IS NOT NULL
61: AND subt.language IS NULL)
62: OR (subb.crit_cat_desc IS NULL AND subt.crit_cat_desc IS NOT NULL)));
63:
64: INSERT INTO OKL_FE_CRIT_CAT_DEF_TL
65: (crit_cat_def_id,
66: language,
67: source_lang,
68: sfwt_flag,

Line 85: FROM OKL_FE_CRIT_CAT_DEF_TL b

81: b.CREATION_DATE,
82: b.LAST_UPDATED_BY,
83: b.LAST_UPDATE_DATE,
84: b.LAST_UPDATE_LOGIN
85: FROM OKL_FE_CRIT_CAT_DEF_TL b
86: ,fnd_languages l
87: WHERE l.installed_flag IN('I', 'B')
88: AND b.language = userenv('LANG')
89: AND NOT EXISTS(SELECT NULL

Line 90: FROM OKL_FE_CRIT_CAT_DEF_TL t

86: ,fnd_languages l
87: WHERE l.installed_flag IN('I', 'B')
88: AND b.language = userenv('LANG')
89: AND NOT EXISTS(SELECT NULL
90: FROM OKL_FE_CRIT_CAT_DEF_TL t
91: WHERE t.crit_cat_def_id = b.crit_cat_def_id AND t.language = l.language_code);
92:
93: END add_language;
94:

Line 705: -- lock_row for:OKL_FE_CRIT_CAT_DEF_TL --

701: ,'_PVT');
702: END lock_row;
703:
704: ----------------------------------------
705: -- lock_row for:OKL_FE_CRIT_CAT_DEF_TL --
706: ----------------------------------------
707:
708: PROCEDURE lock_row(p_init_msg_list IN varchar2
709: ,x_return_status OUT NOCOPY varchar2

Line 719: FROM okl_fe_crit_cat_def_tl

715: PRAGMA exception_init(e_resource_busy, - 00054);
716:
717: CURSOR lock_csr(p_ecctl_rec IN okl_ecctl_rec) IS
718: SELECT *
719: FROM okl_fe_crit_cat_def_tl
720: WHERE crit_cat_def_id = p_ecctl_rec.crit_cat_def_id
721: FOR UPDATE NOWAIT;
722: l_api_version CONSTANT number := 1;
723: l_api_name CONSTANT varchar2(30) := 'TL_lock_row';

Line 1048: -- Procedure get_rec for OKL_FE_CRIT_CAT_DEF_TL

1044: RETURN(get_rec(p_eccb_rec, l_row_notfound));
1045: END get_rec;
1046:
1047: --------------------------------------------------------------------------------
1048: -- Procedure get_rec for OKL_FE_CRIT_CAT_DEF_TL
1049: --------------------------------------------------------------------------------
1050:
1051: FUNCTION get_rec(p_ecctl_rec IN okl_ecctl_rec
1052: ,x_no_data_found OUT NOCOPY boolean) RETURN okl_ecctl_rec IS

Line 1066: FROM okl_fe_crit_cat_def_tl

1062: ,creation_date
1063: ,last_updated_by
1064: ,last_update_date
1065: ,last_update_login
1066: FROM okl_fe_crit_cat_def_tl
1067: WHERE okl_fe_crit_cat_def_tl.crit_cat_def_id = p_id
1068: AND okl_fe_crit_cat_def_tl.language = p_language;
1069: l_ecctl_pk ecctl_pk_csr%ROWTYPE;
1070: l_ecctl_rec okl_ecctl_rec;

Line 1067: WHERE okl_fe_crit_cat_def_tl.crit_cat_def_id = p_id

1063: ,last_updated_by
1064: ,last_update_date
1065: ,last_update_login
1066: FROM okl_fe_crit_cat_def_tl
1067: WHERE okl_fe_crit_cat_def_tl.crit_cat_def_id = p_id
1068: AND okl_fe_crit_cat_def_tl.language = p_language;
1069: l_ecctl_pk ecctl_pk_csr%ROWTYPE;
1070: l_ecctl_rec okl_ecctl_rec;
1071:

Line 1068: AND okl_fe_crit_cat_def_tl.language = p_language;

1064: ,last_update_date
1065: ,last_update_login
1066: FROM okl_fe_crit_cat_def_tl
1067: WHERE okl_fe_crit_cat_def_tl.crit_cat_def_id = p_id
1068: AND okl_fe_crit_cat_def_tl.language = p_language;
1069: l_ecctl_pk ecctl_pk_csr%ROWTYPE;
1070: l_ecctl_rec okl_ecctl_rec;
1071:
1072: BEGIN

Line 1605: INSERT INTO okl_fe_crit_cat_def_tl

1601: ELSE
1602: l_ecctl_rec.sfwt_flag := 'Y';
1603: END IF;
1604:
1605: INSERT INTO okl_fe_crit_cat_def_tl
1606: (crit_cat_def_id
1607: ,language
1608: ,source_lang
1609: ,sfwt_flag

Line 2077: UPDATE okl_fe_crit_cat_def_tl

2073: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2074: RAISE okl_api.g_exception_error;
2075: END IF;
2076:
2077: UPDATE okl_fe_crit_cat_def_tl
2078: SET crit_cat_def_id = l_ecctl_rec.crit_cat_def_id
2079: ,source_lang = l_ecctl_rec.source_lang
2080: ,crit_cat_desc = l_ecctl_rec.crit_cat_desc
2081: ,created_by = l_ecctl_rec.created_by

Line 2088: UPDATE okl_fe_crit_cat_def_tl

2084: ,last_update_date = l_ecctl_rec.last_update_date
2085: ,last_update_login = l_ecctl_rec.last_update_login
2086: WHERE crit_cat_def_id = l_ecctl_rec.crit_cat_def_id;
2087:
2088: UPDATE okl_fe_crit_cat_def_tl
2089: SET sfwt_flag = 'Y'
2090: WHERE crit_cat_def_id = l_ecctl_rec.crit_cat_def_id
2091: AND source_lang <> userenv('LANG');
2092:

Line 2592: DELETE FROM okl_fe_crit_cat_def_tl

2588: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2589: RAISE okl_api.g_exception_error;
2590: END IF;
2591:
2592: DELETE FROM okl_fe_crit_cat_def_tl
2593: WHERE crit_cat_def_id = l_ecctl_rec.crit_cat_def_id;
2594: x_return_status := l_return_status;
2595: okl_api.end_activity(x_msg_count, x_msg_data);
2596: EXCEPTION

Line 2806: FROM OKL_FE_CRIT_CAT_DEF_TL

2802: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
2803:
2804: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
2805: INTO db_luby, db_ludate
2806: FROM OKL_FE_CRIT_CAT_DEF_TL
2807: where crit_cat_def_id = p_eccv_rec.crit_cat_def_id
2808: and USERENV('LANG') =language;
2809:
2810: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 2812: UPDATE OKL_FE_CRIT_CAT_DEF_TL

2808: and USERENV('LANG') =language;
2809:
2810: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2811: db_ludate, '')) then
2812: UPDATE OKL_FE_CRIT_CAT_DEF_TL
2813: SET
2814: CRIT_CAT_DESC = p_eccv_rec.crit_cat_desc,
2815: LAST_UPDATE_DATE = f_ludate,
2816: LAST_UPDATED_BY = f_luby,

Line 2871: UPDATE OKL_FE_CRIT_CAT_DEF_TL

2867: ,last_update_date = f_ludate
2868: ,last_update_login = 0
2869: WHERE crit_cat_def_id = p_eccv_rec.crit_cat_def_id;
2870: --Update _TL
2871: UPDATE OKL_FE_CRIT_CAT_DEF_TL
2872: SET
2873: CRIT_CAT_DESC = p_eccv_rec.crit_cat_desc,
2874: LAST_UPDATE_DATE = f_ludate,
2875: LAST_UPDATED_BY = f_luby,

Line 2883: INSERT INTO OKL_FE_CRIT_CAT_DEF_TL

2879: AND USERENV('LANG') IN (language,source_lang);
2880:
2881: if (sql%notfound) then
2882:
2883: INSERT INTO OKL_FE_CRIT_CAT_DEF_TL
2884: (CRIT_CAT_DEF_ID,
2885: LANGUAGE,
2886: SOURCE_LANG,
2887: SFWT_FLAG,

Line 2910: FROM OKL_FE_CRIT_CAT_DEF_TL TL

2906: FROM FND_LANGUAGES L
2907: WHERE L.INSTALLED_FLAG IN ('I','B')
2908: AND NOT EXISTS
2909: (SELECT NULL
2910: FROM OKL_FE_CRIT_CAT_DEF_TL TL
2911: WHERE TL.CRIT_CAT_DEF_ID = TO_NUMBER(p_eccv_rec.crit_cat_def_id)
2912: AND TL.LANGUAGE = L.LANGUAGE_CODE );
2913: end if;
2914:

Line 2956: INSERT INTO OKL_FE_CRIT_CAT_DEF_TL

2952: ,f_luby
2953: ,f_ludate
2954: ,0);
2955: --Insert Into TL
2956: INSERT INTO OKL_FE_CRIT_CAT_DEF_TL
2957: (CRIT_CAT_DEF_ID,
2958: LANGUAGE,
2959: SOURCE_LANG,
2960: SFWT_FLAG,

Line 2983: FROM OKL_FE_CRIT_CAT_DEF_TL TL

2979: FROM FND_LANGUAGES L
2980: WHERE L.INSTALLED_FLAG IN ('I','B')
2981: AND NOT EXISTS
2982: (SELECT 1
2983: FROM OKL_FE_CRIT_CAT_DEF_TL TL
2984: WHERE TL.CRIT_CAT_DEF_ID = TO_NUMBER(p_eccv_rec.crit_cat_def_id)
2985: AND TL.LANGUAGE = L.LANGUAGE_CODE);
2986:
2987: END LOAD_ROW;