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 75: FROM OKL_FE_ADJ_MAT_ALL_TL b

71: ,b.CREATION_DATE
72: ,b.LAST_UPDATED_BY
73: ,b.LAST_UPDATE_DATE
74: ,b.LAST_UPDATE_LOGIN
75: FROM OKL_FE_ADJ_MAT_ALL_TL b
76: ,fnd_languages l
77: WHERE l.installed_flag IN('I', 'B')
78: AND b.language = userenv('LANG')
79: AND NOT EXISTS(SELECT NULL

Line 80: FROM OKL_FE_ADJ_MAT_ALL_TL t

76: ,fnd_languages l
77: WHERE l.installed_flag IN('I', 'B')
78: AND b.language = userenv('LANG')
79: AND NOT EXISTS(SELECT NULL
80: FROM OKL_FE_ADJ_MAT_ALL_TL t
81: WHERE t.adj_mat_id = b.adj_mat_id AND t.language = l.language_code);
82:
83: END add_language;
84:

Line 181: -- Procedure get_rec forOKL_FE_ADJ_MAT_ALL_TL

177: ,l_row_notfound));
178: END get_rec;
179:
180: --------------------------------------------------------------------------------
181: -- Procedure get_rec forOKL_FE_ADJ_MAT_ALL_TL
182: --------------------------------------------------------------------------------
183:
184: FUNCTION get_rec(p_pamtl_rec IN okl_pamtl_rec
185: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_pamtl_rec IS

Line 199: FROM okl_fe_adj_mat_all_tl

195: ,creation_date
196: ,last_updated_by
197: ,last_update_date
198: ,last_update_login
199: FROM okl_fe_adj_mat_all_tl
200: WHERE okl_fe_adj_mat_all_tl.adj_mat_id = p_id
201: AND okl_fe_adj_mat_all_tl.language = p_language;
202: l_pamtl_pk pamtl_pk_csr%ROWTYPE;
203: l_pamtl_rec okl_pamtl_rec;

Line 200: WHERE okl_fe_adj_mat_all_tl.adj_mat_id = p_id

196: ,last_updated_by
197: ,last_update_date
198: ,last_update_login
199: FROM okl_fe_adj_mat_all_tl
200: WHERE okl_fe_adj_mat_all_tl.adj_mat_id = p_id
201: AND okl_fe_adj_mat_all_tl.language = p_language;
202: l_pamtl_pk pamtl_pk_csr%ROWTYPE;
203: l_pamtl_rec okl_pamtl_rec;
204:

Line 201: AND okl_fe_adj_mat_all_tl.language = p_language;

197: ,last_update_date
198: ,last_update_login
199: FROM okl_fe_adj_mat_all_tl
200: WHERE okl_fe_adj_mat_all_tl.adj_mat_id = p_id
201: AND okl_fe_adj_mat_all_tl.language = p_language;
202: l_pamtl_pk pamtl_pk_csr%ROWTYPE;
203: l_pamtl_rec okl_pamtl_rec;
204:
205: BEGIN

Line 709: FROM okl_fe_adj_mat_all_tl

705: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
706:
707: CURSOR lock_csr(p_pamtl_rec IN okl_pamtl_rec) IS
708: SELECT *
709: FROM okl_fe_adj_mat_all_tl
710: WHERE adj_mat_id = p_pamtl_rec.adj_mat_id
711: FOR UPDATE NOWAIT;
712: l_api_version CONSTANT NUMBER := 1;
713: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 1728: INSERT INTO okl_fe_adj_mat_all_tl

1724:
1725: FOR l_lang_rec IN get_languages LOOP
1726: l_pamtl_rec.language := l_lang_rec.language_code;
1727:
1728: INSERT INTO okl_fe_adj_mat_all_tl
1729: (adj_mat_id
1730: ,adj_mat_desc
1731: ,language
1732: ,source_lang

Line 2194: UPDATE okl_fe_adj_mat_all_tl

2190: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2191: RAISE okl_api.g_exception_error;
2192: END IF;
2193:
2194: UPDATE okl_fe_adj_mat_all_tl
2195: SET adj_mat_id = l_def_pamtl_rec.adj_mat_id
2196: ,adj_mat_desc = l_def_pamtl_rec.adj_mat_desc
2197: ,language = l_def_pamtl_rec.language
2198: ,source_lang = l_def_pamtl_rec.source_lang

Line 2208: UPDATE okl_fe_adj_mat_all_tl

2204: ,last_update_login = l_def_pamtl_rec.last_update_login
2205: WHERE adj_mat_id = l_def_pamtl_rec.adj_mat_id
2206: AND language = l_def_pamtl_rec.language;
2207:
2208: UPDATE okl_fe_adj_mat_all_tl
2209: SET sfwt_flag = 'Y'
2210: WHERE adj_mat_id = l_def_pamtl_rec.adj_mat_id
2211: AND source_lang <> USERENV('LANG');
2212:

Line 2764: DELETE FROM okl_fe_adj_mat_all_tl

2760: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2761: RAISE okl_api.g_exception_error;
2762: END IF;
2763:
2764: DELETE FROM okl_fe_adj_mat_all_tl
2765: WHERE adj_mat_id = l_pamtl_rec.adj_mat_id;
2766:
2767: EXCEPTION
2768: WHEN g_exception_halt_validation THEN