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.IEU_WP_UI_COMP_CATG_PKG dependencies on IEU_WP_UI_COMP_CATG_TL

Line 42: insert into IEU_WP_UI_COMP_CATG_TL (

38: p_last_update_login,
39: p_ui_comp_catg_code
40: );
41:
42: insert into IEU_WP_UI_COMP_CATG_TL (
43: UI_COMP_CATG_ID,
44: OBJECT_VERSION_NUMBER,
45: CREATED_BY,
46: CREATION_DATE,

Line 69: (select null from ieu_wp_ui_comp_catg_tl t

65: userenv('LANG')
66: from fnd_languages l
67: where l.installed_flag in ('I', 'B')
68: and not exists
69: (select null from ieu_wp_ui_comp_catg_tl t
70: where t.ui_comp_catg_id = p_ui_comp_catg_id
71: and t.language = l.language_code);
72:
73: open c;

Line 103: from ieu_wp_ui_comp_catg_tl

99: cursor c1 is select
100: ui_comp_catg_label,
101: ui_comp_catg_desc,
102: decode(language, userenv('LANG'), 'Y', 'N') BASELANG
103: from ieu_wp_ui_comp_catg_tl
104: where ui_comp_catg_id = p_ui_comp_catg_id
105: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
106: for update of ui_comp_catg_id nowait;
107:

Line 164: update IEU_WP_UI_COMP_CATG_TL set

160: if (sql%notfound) then
161: raise no_data_found;
162: end if;
163:
164: update IEU_WP_UI_COMP_CATG_TL set
165: ui_comp_catg_label = p_ui_comp_catg_label,
166: ui_comp_catg_desc = p_ui_comp_catg_desc,
167: last_update_date = p_last_update_date,
168: last_updated_by = p_last_updated_by,

Line 186: delete from IEU_WP_UI_COMP_CATG_TL

182: procedure delete_row(
183: p_ui_comp_catg_id in number
184: ) is
185: begin
186: delete from IEU_WP_UI_COMP_CATG_TL
187: where ui_comp_catg_id = p_ui_comp_catg_id;
188:
189: if (sql%notfound) then
190: raise no_data_found;

Line 206: delete from IEU_WP_UI_COMP_CATG_TL t

202:
203: procedure add_language is
204:
205: begin
206: delete from IEU_WP_UI_COMP_CATG_TL t
207: where not exists
208: (select null
209: from ieu_wp_ui_comp_catg_b b
210: where b.ui_comp_catg_id = t.ui_comp_catg_id);

Line 212: update ieu_wp_ui_comp_catg_tl t

208: (select null
209: from ieu_wp_ui_comp_catg_b b
210: where b.ui_comp_catg_id = t.ui_comp_catg_id);
211:
212: update ieu_wp_ui_comp_catg_tl t
213: set (ui_comp_catg_label, ui_comp_catg_desc)
214: = (select b.ui_comp_catg_label,
215: b.ui_comp_catg_desc
216: from ieu_wp_ui_comp_catg_tl b

Line 216: from ieu_wp_ui_comp_catg_tl b

212: update ieu_wp_ui_comp_catg_tl t
213: set (ui_comp_catg_label, ui_comp_catg_desc)
214: = (select b.ui_comp_catg_label,
215: b.ui_comp_catg_desc
216: from ieu_wp_ui_comp_catg_tl b
217: where b.ui_comp_catg_id = t.ui_comp_catg_id
218: and b.language= t.source_lang)
219: where ( t.ui_comp_catg_id, t.language )
220: in (select subt.ui_comp_catg_id, subt.language

Line 221: from ieu_wp_ui_comp_catg_tl subb, ieu_wp_ui_comp_catg_tl subt

217: where b.ui_comp_catg_id = t.ui_comp_catg_id
218: and b.language= t.source_lang)
219: where ( t.ui_comp_catg_id, t.language )
220: in (select subt.ui_comp_catg_id, subt.language
221: from ieu_wp_ui_comp_catg_tl subb, ieu_wp_ui_comp_catg_tl subt
222: where subb.ui_comp_catg_id = subt.ui_comp_catg_id
223: and subb.language = subt.source_lang
224: and (subb.ui_comp_catg_label <> subt.ui_comp_catg_label
225: or subb.ui_comp_catg_desc <> subt.ui_comp_catg_desc));

Line 227: insert into ieu_wp_ui_comp_catg_tl(

223: and subb.language = subt.source_lang
224: and (subb.ui_comp_catg_label <> subt.ui_comp_catg_label
225: or subb.ui_comp_catg_desc <> subt.ui_comp_catg_desc));
226:
227: insert into ieu_wp_ui_comp_catg_tl(
228: UI_COMP_CATG_ID,
229: OBJECT_VERSION_NUMBER,
230: CREATED_BY,
231: CREATION_DATE,

Line 251: from ieu_wp_ui_comp_catg_tl b, fnd_languages l

247: b.ui_comp_catg_label,
248: b.ui_comp_catg_desc,
249: l.language_code,
250: b.source_lang
251: from ieu_wp_ui_comp_catg_tl b, fnd_languages l
252: where l.installed_flag in ('I', 'B')
253: and b.language= userenv('LANG')
254: and not exists
255: (select null from ieu_wp_ui_comp_catg_tl t

Line 255: (select null from ieu_wp_ui_comp_catg_tl t

251: from ieu_wp_ui_comp_catg_tl b, fnd_languages l
252: where l.installed_flag in ('I', 'B')
253: and b.language= userenv('LANG')
254: and not exists
255: (select null from ieu_wp_ui_comp_catg_tl t
256: where t.ui_comp_catg_id = b.ui_comp_catg_id
257: and t.language = l.language_code);
258:
259: END ADD_LANGUAGE;

Line 319: update IEU_WP_UI_COMP_CATG_TL

315: p_ui_comp_catg_desc in varchar2,
316: p_owner in varchar2
317: ) is
318: begin
319: update IEU_WP_UI_COMP_CATG_TL
320: set source_lang = userenv('LANG'),
321: ui_comp_catg_label = p_ui_comp_catg_label,
322: ui_comp_catg_desc = p_ui_comp_catg_desc,
323: last_update_date = sysdate,