DBA Data[Home] [Help]

APPS.IEU_WP_UI_COMPONENTS_PKG dependencies on IEU_WP_UI_COMPONENTS_TL

Line 51: insert into IEU_WP_UI_COMPONENTS_TL (

47: p_form_comp_avail_no,
48: p_property_class
49: );
50:
51: insert into IEU_WP_UI_COMPONENTS_TL (
52: UI_COMP_ID,
53: OBJECT_VERSION_NUMBER,
54: CREATED_BY,
55: CREATION_DATE,

Line 78: (select null from ieu_wp_ui_components_tl t

74: userenv('LANG')
75: from fnd_languages l
76: where l.installed_flag in ('I', 'B')
77: and not exists
78: (select null from ieu_wp_ui_components_tl t
79: where t.ui_comp_id = p_ui_comp_id
80: and t.language = l.language_code);
81:
82: open c;

Line 118: from ieu_wp_ui_components_tl

114: cursor c1 is select
115: ui_comp_label,
116: ui_comp_desc,
117: decode(language, userenv('LANG'), 'Y', 'N') BASELANG
118: from ieu_wp_ui_components_tl
119: where ui_comp_id = p_ui_comp_id
120: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
121: for update of ui_comp_id nowait;
122:

Line 188: update IEU_WP_UI_COMPONENTS_TL set

184: if (sql%notfound) then
185: raise no_data_found;
186: end if;
187:
188: update IEU_WP_UI_COMPONENTS_TL set
189: ui_comp_label = p_ui_comp_label,
190: ui_comp_desc = p_ui_comp_desc,
191: last_update_date = p_last_update_date,
192: last_updated_by = p_last_updated_by,

Line 210: delete from IEU_WP_UI_COMPONENTS_TL

206: procedure delete_row(
207: p_ui_comp_id in number
208: ) is
209: begin
210: delete from IEU_WP_UI_COMPONENTS_TL
211: where ui_comp_id = p_ui_comp_id;
212:
213: if (sql%notfound) then
214: raise no_data_found;

Line 230: delete from IEU_WP_UI_COMPONENTS_TL t

226:
227: procedure add_language is
228:
229: begin
230: delete from IEU_WP_UI_COMPONENTS_TL t
231: where not exists
232: (select null
233: from ieu_wp_ui_components_b b
234: where b.ui_comp_id = t.ui_comp_id);

Line 236: update ieu_wp_ui_components_tl t

232: (select null
233: from ieu_wp_ui_components_b b
234: where b.ui_comp_id = t.ui_comp_id);
235:
236: update ieu_wp_ui_components_tl t
237: set (ui_comp_label, ui_comp_desc)
238: = (select b.ui_comp_label,
239: b.ui_comp_desc
240: from ieu_wp_ui_components_tl b

Line 240: from ieu_wp_ui_components_tl b

236: update ieu_wp_ui_components_tl t
237: set (ui_comp_label, ui_comp_desc)
238: = (select b.ui_comp_label,
239: b.ui_comp_desc
240: from ieu_wp_ui_components_tl b
241: where b.ui_comp_id = t.ui_comp_id
242: and b.language= t.source_lang)
243: where ( t.ui_comp_id, t.language )
244: in (select subt.ui_comp_id, subt.language

Line 245: from ieu_wp_ui_components_tl subb, ieu_wp_ui_components_tl subt

241: where b.ui_comp_id = t.ui_comp_id
242: and b.language= t.source_lang)
243: where ( t.ui_comp_id, t.language )
244: in (select subt.ui_comp_id, subt.language
245: from ieu_wp_ui_components_tl subb, ieu_wp_ui_components_tl subt
246: where subb.ui_comp_id = subt.ui_comp_id
247: and subb.language = subt.source_lang
248: and (subb.ui_comp_label <> subt.ui_comp_label
249: or subb.ui_comp_desc <> subt.ui_comp_desc));

Line 251: insert into ieu_wp_ui_components_tl(

247: and subb.language = subt.source_lang
248: and (subb.ui_comp_label <> subt.ui_comp_label
249: or subb.ui_comp_desc <> subt.ui_comp_desc));
250:
251: insert into ieu_wp_ui_components_tl(
252: UI_COMP_ID,
253: OBJECT_VERSION_NUMBER,
254: CREATED_BY,
255: CREATION_DATE,

Line 275: from ieu_wp_ui_components_tl b, fnd_languages l

271: b.ui_comp_label,
272: b.ui_comp_desc,
273: l.language_code,
274: b.source_lang
275: from ieu_wp_ui_components_tl b, fnd_languages l
276: where l.installed_flag in ('I', 'B')
277: and b.language= userenv('LANG')
278: and not exists
279: (select null from ieu_wp_ui_components_tl t

Line 279: (select null from ieu_wp_ui_components_tl t

275: from ieu_wp_ui_components_tl b, fnd_languages l
276: where l.installed_flag in ('I', 'B')
277: and b.language= userenv('LANG')
278: and not exists
279: (select null from ieu_wp_ui_components_tl t
280: where t.ui_comp_id = b.ui_comp_id
281: and t.language = l.language_code);
282:
283: END ADD_LANGUAGE;

Line 352: update IEU_WP_UI_COMPONENTS_TL

348: p_ui_comp_desc in varchar2,
349: p_owner in varchar2
350: ) is
351: begin
352: update IEU_WP_UI_COMPONENTS_TL
353: set source_lang = userenv('LANG'),
354: ui_comp_label = p_ui_comp_label,
355: ui_comp_desc = p_ui_comp_desc,
356: last_update_date = sysdate,