APPS.IEU_WP_PROPERTIES_PKG dependencies on IEU_WP_PROPERTIES_TL

Line 62: insert into IEU_WP_PROPERTIES_TL (

58: P_FORM_ITEM_PROPERTY_FLAG,
59: P_NOT_VALID_FLAG
60: );
61:
62: insert into IEU_WP_PROPERTIES_TL (
63: PROPERTY_ID,
64: OBJECT_VERSION_NUMBER,
65: CREATED_BY,
66: CREATION_DATE,

Line 89: (select null from ieu_wp_properties_tl t

85: userenv('LANG')
86: from fnd_languages l
87: where l.installed_flag in ('I', 'B')
88: and not exists
89: (select null from ieu_wp_properties_tl t
90: where t.property_id = p_property_id
91: and t.language = l.language_code);
92:
93: open c;

Line 137: from ieu_wp_properties_tl

133: cursor c1 is select
134: PROPERTY_LABEL,
135: PROPERTY_DESCRIPTION,
136: decode(language, userenv('LANG'), 'Y', 'N') BASELANG
137: from ieu_wp_properties_tl
138: where property_id = p_property_id
139: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
140: for update of property_id nowait;
141:

Line 219: update IEU_WP_PROPERTIES_TL set

215: if (sql%notfound) then
216: raise no_data_found;
217: end if;
218:
219: update IEU_WP_PROPERTIES_TL set
220: property_label = p_property_label,
221: property_description = p_property_description,
222: last_update_date = p_last_update_date,
223: last_updated_by = p_last_updated_by,

Line 241: delete from IEU_WP_PROPERTIES_TL

237: procedure delete_row(
238: p_property_id in number
239: ) is
240: begin
241: delete from IEU_WP_PROPERTIES_TL
242: where property_id = p_property_id;
243:
244: if (sql%notfound) then
245: raise no_data_found;

Line 261: delete from IEU_WP_PROPERTIES_TL t

257:
258: procedure add_language is
259:
260: begin
261: delete from IEU_WP_PROPERTIES_TL t
262: where not exists
263: (select null
264: from ieu_wp_properties_b b
265: where b.property_id = t.property_id);

Line 267: update ieu_wp_properties_tl t

263: (select null
264: from ieu_wp_properties_b b
265: where b.property_id = t.property_id);
266:
267: update ieu_wp_properties_tl t
268: set (property_label, property_description)
269: = (select b.property_label,
270: b.property_description
271: from ieu_wp_properties_tl b

Line 271: from ieu_wp_properties_tl b

267: update ieu_wp_properties_tl t
268: set (property_label, property_description)
269: = (select b.property_label,
270: b.property_description
271: from ieu_wp_properties_tl b
272: where b.property_id = t.property_id
273: and b.language= t.source_lang)
274: where ( t.property_id, t.language )
275: in (select subt.property_id, subt.language

Line 276: from ieu_wp_properties_tl subb, ieu_wp_properties_tl subt

272: where b.property_id = t.property_id
273: and b.language= t.source_lang)
274: where ( t.property_id, t.language )
275: in (select subt.property_id, subt.language
276: from ieu_wp_properties_tl subb, ieu_wp_properties_tl subt
277: where subb.property_id = subt.property_id
278: and subb.language = subt.source_lang
279: and (subb.property_label <> subt.property_label
280: or subb.property_description <> subt.property_description));

Line 282: insert into ieu_wp_properties_tl(

278: and subb.language = subt.source_lang
279: and (subb.property_label <> subt.property_label
280: or subb.property_description <> subt.property_description));
281:
282: insert into ieu_wp_properties_tl(
283: property_ID,
284: OBJECT_VERSION_NUMBER,
285: CREATED_BY,
286: CREATION_DATE,

Line 306: from ieu_wp_properties_tl b, fnd_languages l

302: b.property_label,
303: b.property_description,
304: l.language_code,
305: b.source_lang
306: from ieu_wp_properties_tl b, fnd_languages l
307: where l.installed_flag in ('I', 'B')
308: and b.language= userenv('LANG')
309: and not exists
310: (select null from ieu_wp_properties_tl t

Line 310: (select null from ieu_wp_properties_tl t

306: from ieu_wp_properties_tl b, fnd_languages l
307: where l.installed_flag in ('I', 'B')
308: and b.language= userenv('LANG')
309: and not exists
310: (select null from ieu_wp_properties_tl t
311: where t.property_id = b.property_id
312: and t.language = l.language_code);
313:
314: END ADD_LANGUAGE;

Line 395: update IEU_WP_PROPERTIES_TL

391: p_property_description in varchar2,
392: p_owner in varchar2
393: ) is
394: begin
395: update IEU_WP_PROPERTIES_TL
396: set source_lang = userenv('LANG'),
397: property_label = p_property_label,
398: property_description = p_property_description,
399: last_update_date = sysdate,