APPS.WF_EVENTS_PKG dependencies on WF_EVENTS_TL

Line 57: insert into wf_events_tl (

53: X_JAVA_GENERATE_FUNC,
54: X_IREP_ANNOTATION
55: );
56:
57: insert into wf_events_tl (
58: guid,
59: language,
60: display_name,
61: description,

Line 72: from wf_events_tl t

68: from wf_languages l
69: where l.installed_flag = 'Y'
70: and not exists
71: (select null
72: from wf_events_tl t
73: where t.guid = X_GUID
74: and t.language = l.code);
75:
76: open c;

Line 143: update wf_events_tl set

139: java_generate_func = X_JAVA_GENERATE_FUNC,
140: irep_annotation = X_IREP_ANNOTATION
141: where guid = l_guid;
142:
143: update wf_events_tl set
144: display_name = X_DISPLAY_NAME,
145: description = X_DESCRIPTION,
146: source_lang = userenv('LANG')
147: where guid = l_guid

Line 187: update wf_events_tl set

183: java_generate_func = X_JAVA_GENERATE_FUNC,
184: irep_annotation = X_IREP_ANNOTATION
185: where guid = l_guid;
186:
187: update wf_events_tl set
188: display_name = X_DISPLAY_NAME,
189: description = X_DESCRIPTION,
190: source_lang = userenv('LANG')
191: where guid = l_guid

Line 218: update wf_events_tl set

214: java_generate_func = X_JAVA_GENERATE_FUNC,
215: irep_annotation = X_IREP_ANNOTATION
216: where guid = l_guid;
217:
218: update wf_events_tl set
219: display_name = X_DISPLAY_NAME,
220: description = X_DESCRIPTION,
221: source_lang = userenv('LANG')
222: where guid = l_guid

Line 254: update wf_events_tl set

250: java_generate_func = X_JAVA_GENERATE_FUNC,
251: irep_annotation = X_IREP_ANNOTATION
252: where guid = l_guid;
253:
254: update wf_events_tl set
255: display_name = X_DISPLAY_NAME,
256: description = X_DESCRIPTION,
257: source_lang = userenv('LANG')
258: where guid = l_guid

Line 297: delete from wf_events_tl where guid = X_GUID;

293: begin
294: wf_event.raise('oracle.apps.wf.event.event.delete',x_guid);
295:
296:
297: delete from wf_events_tl where guid = X_GUID;
298:
299: if (sql%notfound) then
300: raise no_data_found;
301: end if;

Line 391: delete from wf_events_tl t

387: is
388: begin
389: /**
390: Commenting off the costly pl/sql code
391: delete from wf_events_tl t
392: where not exists
393: (select 'baserow'
394: from wf_events b
395: where b.guid = t.guid);

Line 397: update wf_events_tl t set (display_name, description)

393: (select 'baserow'
394: from wf_events b
395: where b.guid = t.guid);
396:
397: update wf_events_tl t set (display_name, description)
398: = (select b.display_name, b.description
399: from wf_events_tl b
400: where b.guid = t.guid
401: and b.language = t.source_lang)

Line 399: from wf_events_tl b

395: where b.guid = t.guid);
396:
397: update wf_events_tl t set (display_name, description)
398: = (select b.display_name, b.description
399: from wf_events_tl b
400: where b.guid = t.guid
401: and b.language = t.source_lang)
402: where (t.guid, t.language) in
403: (select subt.guid,

Line 405: from wf_events_tl subb, wf_events_tl subt

401: and b.language = t.source_lang)
402: where (t.guid, t.language) in
403: (select subt.guid,
404: subt.language
405: from wf_events_tl subb, wf_events_tl subt
406: where subb.guid = subt.guid
407: and subb.language = subt.source_lang
408: and (subb.display_name <> subt.display_name
409: or subb.description <> subt.description

Line 416: insert into wf_events_tl (

412: );
413:
414: **/
415:
416: insert into wf_events_tl (
417: guid,
418: language,
419: display_name,
420: description,

Line 427: from wf_events_tl b, wf_languages l

423: l.code,
424: b.display_name,
425: b.description,
426: b.source_lang
427: from wf_events_tl b, wf_languages l
428: where l.installed_flag = 'Y'
429: and b.language = userenv('LANG')
430: and (b.guid , l.code) NOT IN
431: (select /*+ hash_aj index_ffs(T,WF_EVENTS_TL_U1) */

Line 431: (select /*+ hash_aj index_ffs(T,WF_EVENTS_TL_U1) */

427: from wf_events_tl b, wf_languages l
428: where l.installed_flag = 'Y'
429: and b.language = userenv('LANG')
430: and (b.guid , l.code) NOT IN
431: (select /*+ hash_aj index_ffs(T,WF_EVENTS_TL_U1) */
432: t.guid ,T.LANGUAGE
433: from wf_events_tl T) ;
434: exception
435: when others then

Line 433: from wf_events_tl T) ;

429: and b.language = userenv('LANG')
430: and (b.guid , l.code) NOT IN
431: (select /*+ hash_aj index_ffs(T,WF_EVENTS_TL_U1) */
432: t.guid ,T.LANGUAGE
433: from wf_events_tl T) ;
434: exception
435: when others then
436: wf_core.context('Wf_Events_Pkg', 'Add_language');
437: raise;