APPS.IEU_UWQM_WORK_SOURCES_PKG dependencies on IEU_UWQM_WORK_SOURCES_TL

Line 69: insert into IEU_UWQM_WORK_SOURCES_TL (

65: p_application_id,
66: p_active_flag
67: );
68:
69: insert into IEU_UWQM_WORK_SOURCES_TL (
70: ws_id,
71: OBJECT_VERSION_NUMBER,
72: CREATED_BY,
73: CREATION_DATE,

Line 96: (select null from ieu_uwqm_work_sources_tl t

92: userenv('LANG')
93: from fnd_languages l
94: where l.installed_flag in ('I', 'B')
95: and not exists
96: (select null from ieu_uwqm_work_sources_tl t
97: where t.ws_id = p_ws_id
98: and t.language = l.language_code);
99:
100: open c;

Line 136: from ieu_uwqm_work_sources_tl

132:
133: cursor c1 is
134: select ws_name, ws_description,
135: decode(language, userenv('LANG'), 'Y', 'N') BASELANG
136: from ieu_uwqm_work_sources_tl
137: where ws_id = p_ws_id
138: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
139: for update of ws_id nowait;
140:

Line 252: update IEU_UWQM_WORK_SOURCES_TL set

248: if (sql%notfound) then
249: raise no_data_found;
250: end if;
251:
252: update IEU_UWQM_WORK_SOURCES_TL set
253: ws_name = p_ws_name,
254: ws_description = p_ws_description,
255: last_update_date = sysdate,
256: last_updated_by = fnd_global.user_id,

Line 273: delete from IEU_UWQM_WORK_SOURCES_TL

269: procedure delete_row(
270: p_ws_id in number
271: ) is
272: begin
273: delete from IEU_UWQM_WORK_SOURCES_TL
274: where ws_id = p_ws_id;
275:
276: if (sql%notfound) then
277: raise no_data_found;

Line 293: delete from IEU_UWQM_WORK_SOURCES_TL t

289:
290: procedure add_language is
291:
292: begin
293: delete from IEU_UWQM_WORK_SOURCES_TL t
294: where not exists
295: (select null
296: from ieu_uwqm_work_sources_b b
297: where b.ws_id = t.ws_id);

Line 299: update ieu_uwqm_work_sources_tl t

295: (select null
296: from ieu_uwqm_work_sources_b b
297: where b.ws_id = t.ws_id);
298:
299: update ieu_uwqm_work_sources_tl t
300: set (ws_name, ws_description)
301: = (select b.ws_name,
302: b.ws_description
303: from ieu_uwqm_work_sources_tl b

Line 303: from ieu_uwqm_work_sources_tl b

299: update ieu_uwqm_work_sources_tl t
300: set (ws_name, ws_description)
301: = (select b.ws_name,
302: b.ws_description
303: from ieu_uwqm_work_sources_tl b
304: where b.ws_id = t.ws_id
305: and b.language= t.source_lang)
306: where ( t.ws_id, t.language )
307: in (select subt.ws_id, subt.language

Line 308: from ieu_uwqm_work_sources_tl subb, ieu_uwqm_work_sources_tl subt

304: where b.ws_id = t.ws_id
305: and b.language= t.source_lang)
306: where ( t.ws_id, t.language )
307: in (select subt.ws_id, subt.language
308: from ieu_uwqm_work_sources_tl subb, ieu_uwqm_work_sources_tl subt
309: where subb.ws_id = subt.ws_id
310: and subb.language = subt.source_lang
311: and (subb.ws_name <> subt.ws_name
312: or subb.ws_description <> subt.ws_description));

Line 314: insert into ieu_uwqm_work_sources_tl(

310: and subb.language = subt.source_lang
311: and (subb.ws_name <> subt.ws_name
312: or subb.ws_description <> subt.ws_description));
313:
314: insert into ieu_uwqm_work_sources_tl(
315: ws_ID,
316: OBJECT_VERSION_NUMBER,
317: CREATED_BY,
318: CREATION_DATE,

Line 338: from ieu_uwqm_work_sources_tl b, fnd_languages l

334: b.ws_name,
335: b.ws_description,
336: l.language_code,
337: b.source_lang
338: from ieu_uwqm_work_sources_tl b, fnd_languages l
339: where l.installed_flag in ('I', 'B')
340: and b.language= userenv('LANG')
341: and not exists
342: (select null from ieu_uwqm_work_sources_tl t

Line 342: (select null from ieu_uwqm_work_sources_tl t

338: from ieu_uwqm_work_sources_tl b, fnd_languages l
339: where l.installed_flag in ('I', 'B')
340: and b.language= userenv('LANG')
341: and not exists
342: (select null from ieu_uwqm_work_sources_tl t
343: where t.ws_id = b.ws_id
344: and t.language = l.language_code);
345:
346: END ADD_LANGUAGE;

Line 420: update IEU_UWQM_WORK_SOURCES_TL

416: p_ws_description in varchar2,
417: p_owner in varchar2
418: ) is
419: begin
420: update IEU_UWQM_WORK_SOURCES_TL
421: set source_lang = userenv('LANG'),
422: ws_name = p_ws_name,
423: ws_description = p_ws_description,
424: last_update_date = sysdate,