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_PAM_PVT dependencies on OKL_FE_ADJ_MAT_ALL_TL

Line 32: DELETE FROM OKL_FE_ADJ_MAT_ALL_TL t

28: PROCEDURE add_language IS
29:
30: BEGIN
31:
32: DELETE FROM OKL_FE_ADJ_MAT_ALL_TL t
33: WHERE NOT EXISTS(SELECT NULL
34: FROM OKL_FE_ADJ_MAT_ALL_B b
35: WHERE b.adj_mat_id = t.adj_mat_id);
36:

Line 37: UPDATE OKL_FE_ADJ_MAT_ALL_TL t

33: WHERE NOT EXISTS(SELECT NULL
34: FROM OKL_FE_ADJ_MAT_ALL_B b
35: WHERE b.adj_mat_id = t.adj_mat_id);
36:
37: UPDATE OKL_FE_ADJ_MAT_ALL_TL t
38: SET(adj_mat_desc) = (SELECT
39: -- LANGUAGE,
40:
41: -- B.LANGUAGE,

Line 44: FROM OKL_FE_ADJ_MAT_ALL_TL b

40:
41: -- B.LANGUAGE,
42:
43: b.adj_mat_desc
44: FROM OKL_FE_ADJ_MAT_ALL_TL b
45: WHERE b.adj_mat_id = t.adj_mat_id
46: AND b.language = t.source_lang)
47: WHERE (t.adj_mat_id, t.language) IN(SELECT subt.adj_mat_id ,subt.language
48: FROM OKL_FE_ADJ_MAT_ALL_TL subb ,OKL_FE_ADJ_MAT_ALL_TL subt

Line 48: FROM OKL_FE_ADJ_MAT_ALL_TL subb ,OKL_FE_ADJ_MAT_ALL_TL subt

44: FROM OKL_FE_ADJ_MAT_ALL_TL b
45: WHERE b.adj_mat_id = t.adj_mat_id
46: AND b.language = t.source_lang)
47: WHERE (t.adj_mat_id, t.language) IN(SELECT subt.adj_mat_id ,subt.language
48: FROM OKL_FE_ADJ_MAT_ALL_TL subb ,OKL_FE_ADJ_MAT_ALL_TL subt
49: WHERE subb.adj_mat_id = subt.adj_mat_id AND subb.language = subt.language AND ( -- SUBB.LANGUAGE <> SUBT.LANGUAGE OR
50: subb.adj_mat_desc <> subt.adj_mat_desc OR (subb.language IS NOT NULL
51: AND subt.language IS NULL)
52: OR (subb.adj_mat_desc IS NULL AND subt.adj_mat_desc IS NOT NULL)));

Line 54: INSERT INTO OKL_FE_ADJ_MAT_ALL_TL

50: subb.adj_mat_desc <> subt.adj_mat_desc OR (subb.language IS NOT NULL
51: AND subt.language IS NULL)
52: OR (subb.adj_mat_desc IS NULL AND subt.adj_mat_desc IS NOT NULL)));
53:
54: INSERT INTO OKL_FE_ADJ_MAT_ALL_TL
55: (adj_mat_id
56: ,language
57: ,source_lang
58: ,sfwt_flag

Line 65: FROM OKL_FE_ADJ_MAT_ALL_TL b

61: ,l.language_code
62: ,b.source_lang
63: ,b.sfwt_flag
64: ,b.adj_mat_desc
65: FROM OKL_FE_ADJ_MAT_ALL_TL b
66: ,fnd_languages l
67: WHERE l.installed_flag IN('I', 'B')
68: AND b.language = userenv('LANG')
69: AND NOT EXISTS(SELECT NULL

Line 70: FROM OKL_FE_ADJ_MAT_ALL_TL t

66: ,fnd_languages l
67: WHERE l.installed_flag IN('I', 'B')
68: AND b.language = userenv('LANG')
69: AND NOT EXISTS(SELECT NULL
70: FROM OKL_FE_ADJ_MAT_ALL_TL t
71: WHERE t.adj_mat_id = b.adj_mat_id AND t.language = l.language_code);
72:
73: END add_language;
74:

Line 171: -- Procedure get_rec forOKL_FE_ADJ_MAT_ALL_TL

167: ,l_row_notfound));
168: END get_rec;
169:
170: --------------------------------------------------------------------------------
171: -- Procedure get_rec forOKL_FE_ADJ_MAT_ALL_TL
172: --------------------------------------------------------------------------------
173:
174: FUNCTION get_rec(p_pamtl_rec IN okl_pamtl_rec
175: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_pamtl_rec IS

Line 189: FROM okl_fe_adj_mat_all_tl

185: ,creation_date
186: ,last_updated_by
187: ,last_update_date
188: ,last_update_login
189: FROM okl_fe_adj_mat_all_tl
190: WHERE okl_fe_adj_mat_all_tl.adj_mat_id = p_id
191: AND okl_fe_adj_mat_all_tl.language = p_language;
192: l_pamtl_pk pamtl_pk_csr%ROWTYPE;
193: l_pamtl_rec okl_pamtl_rec;

Line 190: WHERE okl_fe_adj_mat_all_tl.adj_mat_id = p_id

186: ,last_updated_by
187: ,last_update_date
188: ,last_update_login
189: FROM okl_fe_adj_mat_all_tl
190: WHERE okl_fe_adj_mat_all_tl.adj_mat_id = p_id
191: AND okl_fe_adj_mat_all_tl.language = p_language;
192: l_pamtl_pk pamtl_pk_csr%ROWTYPE;
193: l_pamtl_rec okl_pamtl_rec;
194:

Line 191: AND okl_fe_adj_mat_all_tl.language = p_language;

187: ,last_update_date
188: ,last_update_login
189: FROM okl_fe_adj_mat_all_tl
190: WHERE okl_fe_adj_mat_all_tl.adj_mat_id = p_id
191: AND okl_fe_adj_mat_all_tl.language = p_language;
192: l_pamtl_pk pamtl_pk_csr%ROWTYPE;
193: l_pamtl_rec okl_pamtl_rec;
194:
195: BEGIN

Line 699: FROM okl_fe_adj_mat_all_tl

695: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
696:
697: CURSOR lock_csr(p_pamtl_rec IN okl_pamtl_rec) IS
698: SELECT *
699: FROM okl_fe_adj_mat_all_tl
700: WHERE adj_mat_id = p_pamtl_rec.adj_mat_id
701: FOR UPDATE NOWAIT;
702: l_api_version CONSTANT NUMBER := 1;
703: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1718: INSERT INTO okl_fe_adj_mat_all_tl

1714:
1715: FOR l_lang_rec IN get_languages LOOP
1716: l_pamtl_rec.language := l_lang_rec.language_code;
1717:
1718: INSERT INTO okl_fe_adj_mat_all_tl
1719: (adj_mat_id
1720: ,adj_mat_desc
1721: ,language
1722: ,source_lang

Line 2184: UPDATE okl_fe_adj_mat_all_tl

2180: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2181: RAISE okl_api.g_exception_error;
2182: END IF;
2183:
2184: UPDATE okl_fe_adj_mat_all_tl
2185: SET adj_mat_id = l_def_pamtl_rec.adj_mat_id
2186: ,adj_mat_desc = l_def_pamtl_rec.adj_mat_desc
2187: ,language = l_def_pamtl_rec.language
2188: ,source_lang = l_def_pamtl_rec.source_lang

Line 2198: UPDATE okl_fe_adj_mat_all_tl

2194: ,last_update_login = l_def_pamtl_rec.last_update_login
2195: WHERE adj_mat_id = l_def_pamtl_rec.adj_mat_id
2196: AND language = l_def_pamtl_rec.language;
2197:
2198: UPDATE okl_fe_adj_mat_all_tl
2199: SET sfwt_flag = 'Y'
2200: WHERE adj_mat_id = l_def_pamtl_rec.adj_mat_id
2201: AND source_lang <> USERENV('LANG');
2202:

Line 2754: DELETE FROM okl_fe_adj_mat_all_tl

2750: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2751: RAISE okl_api.g_exception_error;
2752: END IF;
2753:
2754: DELETE FROM okl_fe_adj_mat_all_tl
2755: WHERE adj_mat_id = l_pamtl_rec.adj_mat_id;
2756:
2757: EXCEPTION
2758: WHEN g_exception_halt_validation THEN