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.OE_PARAMETERS_DEF_UTIL dependencies on OE_SYS_PARAMETER_DEF_TL

Line 7: -- Description : Inserts record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table

3:
4: -- Start of comments
5: -- API name : Insert_Row
6: -- Type : Public
7: -- Description : Inserts record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table
8: -- Parameters :
9: -- IN : p_sys_param_def_rec IN
10: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required
11: --

Line 44: --- Insertng row to OE_SYS_PARAMETER_DEF_TL table

40: p_sys_param_def_rec.value_set_id,
41: p_sys_param_def_rec.open_orders_check_flag,
42: p_sys_param_def_rec.enabled_flag,
43: p_sys_param_def_rec.seeded_flag);
44: --- Insertng row to OE_SYS_PARAMETER_DEF_TL table
45: INSERT INTO oe_sys_parameter_def_tl (
46: parameter_code,
47: creation_date,
48: created_by,

Line 45: INSERT INTO oe_sys_parameter_def_tl (

41: p_sys_param_def_rec.open_orders_check_flag,
42: p_sys_param_def_rec.enabled_flag,
43: p_sys_param_def_rec.seeded_flag);
44: --- Insertng row to OE_SYS_PARAMETER_DEF_TL table
45: INSERT INTO oe_sys_parameter_def_tl (
46: parameter_code,
47: creation_date,
48: created_by,
49: last_update_date,

Line 71: FROM oe_sys_parameter_def_tl T

67: FROM fnd_languages L
68: WHERE L.installed_flag IN ('I', 'B')
69: AND NOT EXISTS
70: (SELECT NULL
71: FROM oe_sys_parameter_def_tl T
72: where T.parameter_code = p_sys_param_def_rec.parameter_code
73: and T.language = L.language_code);
74: END Insert_Row;
75:

Line 79: -- Description : Delete Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table

75:
76: -- Start of comments
77: -- API name : Delete_Row
78: -- Type : Public
79: -- Description : Delete Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table
80: -- Parameters :
81: -- IN : p_parameter_code IN VARCHAR2 Required
82: --
83: -- End of Comments

Line 91: DELETE FROM oe_sys_parameter_def_tl

87: --
88: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
89: --
90: BEGIN
91: DELETE FROM oe_sys_parameter_def_tl
92: WHERE parameter_code = p_parameter_code;
93: IF (sql%notfound) THEN
94: RAISE no_data_found;
95: END IF;

Line 107: -- Description : Update Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table

103:
104: -- Start of comments
105: -- API name : Update_Row
106: -- Type : Public
107: -- Description : Update Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table
108: -- Parameters :
109: -- IN : p_sys_param_def_rec IN
110: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required
111: --

Line 133: UPDATE oe_sys_parameter_def_tl

129: IF (sql%notfound) THEN
130: RAISE no_data_found;
131: END IF;
132:
133: UPDATE oe_sys_parameter_def_tl
134: SET last_update_date = p_sys_param_def_rec.last_update_date,
135: last_updated_by = p_sys_param_def_rec.last_updated_by,
136: last_update_login = p_sys_param_def_rec.last_update_login,
137: name = p_sys_param_def_rec.name,

Line 150: -- Description : Lock Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table

146:
147: -- Start of comments
148: -- API name : Lock_Row
149: -- Type : Public
150: -- Description : Lock Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table
151: -- Parameters :
152: -- IN : p_sys_param_def_rec IN
153: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required
154: --

Line 172: FROM oe_sys_parameter_def_tl

168: CURSOR param_tl IS
169: SELECT name,
170: description,
171: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') baselang
172: FROM oe_sys_parameter_def_tl
173: WHERE parameter_code = p_parameter_code
174: AND userenv('LANG') IN (language, source_lang)
175: FOR UPDATE OF name NOWAIT;
176:

Line 285: FROM oe_sys_parameter_def_tl

281: l_last_upd_dt DATE;
282: BEGIN
283: SELECT last_updated_by,last_update_date
284: INTO l_last_upd_by, l_last_upd_dt
285: FROM oe_sys_parameter_def_tl
286: WHERE parameter_code = p_parameter_code
287: AND LANGUAGE = userenv('LANG');
288:
289: /*IF upload_test(p_file_upb => p_updated_by

Line 298: UPDATE oe_sys_parameter_def_tl

294: p_file_lud => sysdate,
295: p_db_id=> l_last_upd_by,
296: p_db_lud => l_last_upd_dt,
297: p_custom_mode=>p_custom_mode) then
298: UPDATE oe_sys_parameter_def_tl
299: SET name = p_name,
300: description = p_description,
301: last_update_date = sysdate,
302: last_updated_by = p_updated_by,

Line 406: DELETE FROM oe_sys_parameter_def_tl t

402:
403: PROCEDURE Add_Language
404: IS
405: BEGIN
406: DELETE FROM oe_sys_parameter_def_tl t
407: WHERE NOT EXISTS
408: (SELECT null
409: FROM oe_sys_parameter_def_b b
410: where b.parameter_code = t.parameter_code);

Line 412: UPDATE oe_sys_parameter_def_tl t

408: (SELECT null
409: FROM oe_sys_parameter_def_b b
410: where b.parameter_code = t.parameter_code);
411:
412: UPDATE oe_sys_parameter_def_tl t
413: SET
414: (
415: name,
416: description

Line 421: FROM oe_sys_parameter_def_tl b

417: ) = (
418: SELECT
419: b.name,
420: b.description
421: FROM oe_sys_parameter_def_tl b
422: WHERE b.parameter_code = t.parameter_code
423: AND b.language = t.source_lang
424: )
425: where

Line 433: FROM oe_sys_parameter_def_tl subb,

429: ) IN (
430: SELECT
431: subt.parameter_code,
432: subt.language
433: FROM oe_sys_parameter_def_tl subb,
434: oe_sys_parameter_def_tl subt
435: WHERE subb.parameter_code = subt.parameter_code
436: AND subb.language = subt.source_lang
437: AND(subb.name <> subt.name

Line 434: oe_sys_parameter_def_tl subt

430: SELECT
431: subt.parameter_code,
432: subt.language
433: FROM oe_sys_parameter_def_tl subb,
434: oe_sys_parameter_def_tl subt
435: WHERE subb.parameter_code = subt.parameter_code
436: AND subb.language = subt.source_lang
437: AND(subb.name <> subt.name
438: OR subb.DESCRIPTION <> subt.description

Line 446: INSERT INTO oe_sys_parameter_def_tl

442: AND subt.description IS null)
443: )
444: );
445:
446: INSERT INTO oe_sys_parameter_def_tl
447: (
448: parameter_code,
449: creation_date,
450: created_by,

Line 470: FROM oe_sys_parameter_def_tl b, fnd_languages l

466: l.language_code,
467: b.source_lang,
468: b.name,
469: b.description
470: FROM oe_sys_parameter_def_tl b, fnd_languages l
471: WHERE l.installed_flag IN ('I', 'B')
472: AND b.language = USERENV('LANG')
473: AND NOT EXISTS
474: ( SELECT null

Line 475: FROM oe_sys_parameter_def_tl t

471: WHERE l.installed_flag IN ('I', 'B')
472: AND b.language = USERENV('LANG')
473: AND NOT EXISTS
474: ( SELECT null
475: FROM oe_sys_parameter_def_tl t
476: WHERE t.parameter_code = b.parameter_code
477: AND t.language = l.language_code);
478: END Add_Language;
479: