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.WF_EVENTS_PKG dependencies on WF_EVENTS

Line 1: package body WF_EVENTS_PKG as

1: package body WF_EVENTS_PKG as
2: /* $Header: WFEVEVTB.pls 120.11 2008/02/15 09:35:21 sstomar ship $ */
3: m_table_name varchar2(255) := 'WF_EVENTS';
4: m_package_version varchar2(30) := '1.0';
5:

Line 3: m_table_name varchar2(255) := 'WF_EVENTS';

1: package body WF_EVENTS_PKG as
2: /* $Header: WFEVEVTB.pls 120.11 2008/02/15 09:35:21 sstomar ship $ */
3: m_table_name varchar2(255) := 'WF_EVENTS';
4: m_package_version varchar2(30) := '1.0';
5:
6: m_null varchar2(10) := '*NULL*';
7:

Line 27: cursor C is select rowid from wf_events where guid = X_GUID;

23: X_LICENSED_FLAG in varchar2,
24: X_JAVA_GENERATE_FUNC in varchar2,
25: X_IREP_ANNOTATION in varchar2
26: ) is
27: cursor C is select rowid from wf_events where guid = X_GUID;
28: l_licensed_flag varchar2(1);
29: begin
30: l_licensed_flag := is_product_licensed (X_OWNER_TAG);
31: insert into wf_events (

Line 31: insert into wf_events (

27: cursor C is select rowid from wf_events where guid = X_GUID;
28: l_licensed_flag varchar2(1);
29: begin
30: l_licensed_flag := is_product_licensed (X_OWNER_TAG);
31: insert into wf_events (
32: guid,
33: name,
34: type,
35: status,

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 87: wf_core.context('Wf_Events_Pkg', 'Insert_Row', x_guid, x_name, x_type);

83: end if;
84: close c;
85: exception
86: when others then
87: wf_core.context('Wf_Events_Pkg', 'Insert_Row', x_guid, x_name, x_type);
88: raise;
89: end INSERT_ROW;
90: ----------------------------------------------------------------------------
91: procedure UPDATE_ROW (

Line 113: FROM wf_events

109: l_raise_event_flag varchar2(1) := 'N';
110:
111: CURSOR c_getguid(p_name in varchar2) IS
112: SELECT guid
113: FROM wf_events
114: WHERE name = p_name;
115:
116: l_guid raw(16);
117:

Line 130: update wf_events set

126:
127: l_licensed_flag := is_product_licensed (X_OWNER_TAG);
128:
129: if g_Mode = 'FORCE' then
130: update wf_events set
131: name = X_NAME,
132: type = X_TYPE,
133: status = X_STATUS,
134: generate_function = X_GENERATE_FUNCTION,

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 164: wf_core.context('WF_EVENTS_PKG','UPDATE_ROW',

160: l_update_allowed := is_update_allowed(X_CUSTOMIZATION_LEVEL, l_custom_level);
161:
162: if l_update_allowed = 'N' then
163: -- Set up the Error Stack
164: wf_core.context('WF_EVENTS_PKG','UPDATE_ROW',
165: x_name,
166: l_custom_level,
167: X_CUSTOMIZATION_LEVEL);
168: return;

Line 174: update wf_events set

170:
171: if X_CUSTOMIZATION_LEVEL = 'C' then
172: if g_Mode = 'UPGRADE' then
173: -- The Loader can update as the Custom Level is C
174: update wf_events set
175: name = X_NAME,
176: type = X_TYPE,
177: status = X_STATUS,
178: generate_function = X_GENERATE_FUNCTION,

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 206: update wf_events set

202: -- Limit events can have only a status change..
203: -- When the loader is loading the events the
204: -- users changes must be preserved. Update all
205: -- fields EXCEPT the status field.
206: update wf_events set
207: name = X_NAME,
208: type = X_TYPE,
209: generate_function = X_GENERATE_FUNCTION,
210: owner_name = X_OWNER_NAME,

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 231: update wf_events set

227: -- Caller of the Update is the UI
228: -- Limit events can have only a status change..
229: -- When the user is updating the event using the UI
230: -- Updates are allowed ONLY to the status field.
231: update wf_events set
232: status = X_STATUS
233: where guid = l_guid;
234:
235: l_raise_event_flag := 'Y';

Line 241: update wf_events set

237: elsif X_CUSTOMIZATION_LEVEL = 'U' then
238: -- Here are the updates allowed for extensible and User defined events
239: -- only when the caller is the UI
240: if g_Mode = 'CUSTOM' then
241: update wf_events set
242: name = X_NAME,
243: type = X_TYPE,
244: status = X_STATUS,
245: generate_function = X_GENERATE_FUNCTION,

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 286: wf_core.context('Wf_Events_Pkg', 'Update_Row', l_guid, x_name, x_type);

282: exception
283: when no_data_found then
284: raise;
285: when others then
286: wf_core.context('Wf_Events_Pkg', 'Update_Row', l_guid, x_name, x_type);
287: raise;
288: end UPDATE_ROW;
289: ----------------------------------------------------------------------------
290: procedure DELETE_ROW (

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 304: delete from wf_events where guid = X_GUID;

300: raise no_data_found;
301: end if;
302:
303:
304: delete from wf_events where guid = X_GUID;
305:
306: if (sql%notfound) then
307: raise no_data_found;
308: end if;

Line 314: wf_core.context('Wf_Events_Pkg', 'Delete_Row', x_guid);

310: -- Invalidate cache
311: wf_bes_cache.SetMetaDataUploaded();
312: exception
313: when others then
314: wf_core.context('Wf_Events_Pkg', 'Delete_Row', x_guid);
315: raise;
316: end DELETE_ROW;
317: ----------------------------------------------------------------------------
318: procedure LOAD_ROW (

Line 336: WF_EVENTS_PKG.UPDATE_ROW (

332: ) is
333: row_id varchar2(64);
334: begin
335: begin
336: WF_EVENTS_PKG.UPDATE_ROW (
337: X_GUID => X_GUID,
338: X_NAME => X_NAME,
339: X_TYPE => X_TYPE,
340: X_STATUS => X_STATUS,

Line 357: WF_EVENTS_PKG.INSERT_ROW(

353: wf_bes_cache.SetMetaDataUploaded();
354: exception
355: when no_data_found then
356: begin
357: WF_EVENTS_PKG.INSERT_ROW(
358: X_ROWID => row_id,
359: X_GUID => X_GUID,
360: X_NAME => X_NAME,
361: X_TYPE => X_TYPE,

Line 382: wf_core.context('Wf_Events_Pkg', 'Load_Row', x_guid, x_name, x_type);

378: end;
379:
380: exception
381: when others then
382: wf_core.context('Wf_Events_Pkg', 'Load_Row', x_guid, x_name, x_type);
383: raise;
384: end LOAD_ROW;
385: ----------------------------------------------------------------------------
386: procedure ADD_LANGUAGE

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 394: from wf_events b

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);
396:
397: update wf_events_tl t set (display_name, description)
398: = (select b.display_name, b.description

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;

Line 436: wf_core.context('Wf_Events_Pkg', 'Add_language');

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;
438: end ADD_LANGUAGE;
439: ----------------------------------------------------------------------------
440: function GENERATE (

Line 469: from wf_events_vl

465: LICENSED_FLAG,JAVA_GENERATE_FUNC, IREP_ANNOTATION
466: into L_NAME, L_TYPE, L_STATUS, L_GENERATE_FUNCTION, L_OWNER_NAME,
467: L_OWNER_TAG, L_DISPLAY_NAME, L_DESCRIPTION, l_customization_level,
468: l_licensed_flag,l_javagenerate, l_irep_annotation
469: from wf_events_vl
470: where guid = x_guid;
471:
472: l_doc := xmldom.newDOMDocument;
473: l_root := xmldom.makeNode(l_doc);

Line 533: wf_core.context('Wf_Events_Pkg', 'Generate', x_guid);

529:
530: return buf;
531: exception
532: when others then
533: wf_core.context('Wf_Events_Pkg', 'Generate', x_guid);
534: raise;
535: end GENERATE;
536: ----------------------------------------------------------------------------
537: procedure RECEIVE (

Line 627: if WF_EVENTS_PKG.g_Mode <> 'UPGRADE' then

623: end loop;
624:
625: if (L_OWNER_NAME is null)
626: or (L_OWNER_TAG is null) then
627: if WF_EVENTS_PKG.g_Mode <> 'UPGRADE' then
628: Wf_Core.Token('REASON','Event Owner Name and Owner Tag cannot be null');
629: Wf_Core.Raise('WFSQL_INTERNAL');
630: else
631: wf_core.context('Wf_Events_Pkg', 'Receive',

Line 631: wf_core.context('Wf_Events_Pkg', 'Receive',

627: if WF_EVENTS_PKG.g_Mode <> 'UPGRADE' then
628: Wf_Core.Token('REASON','Event Owner Name and Owner Tag cannot be null');
629: Wf_Core.Raise('WFSQL_INTERNAL');
630: else
631: wf_core.context('Wf_Events_Pkg', 'Receive',
632: 'WARNING! WARNING! Event OWNER_NAME/OWNER_TAG cannot be null for Event ' || l_name);
633: end if;
634: end if;
635:

Line 641: wf_core.context('Wf_Events_Pkg', 'Receive', x_message);

637: L_OWNER_NAME, L_OWNER_TAG, L_DISPLAY_NAME, l_DESCRIPTION,
638: l_CUSTOMIZATION_LEVEL, l_LICENSED_FLAG ,l_javagenerate, l_irep_annotation);
639: exception
640: when others then
641: wf_core.context('Wf_Events_Pkg', 'Receive', x_message);
642: raise;
643: end RECEIVE;
644:
645:

Line 651: WF_EVENTS

647: X_CUSTOMIZATION_LEVEL out nocopy varchar2)
648: is
649: cursor c_getCustomLevel is
650: select CUSTOMIZATION_LEVEL from
651: WF_EVENTS
652: where guid = X_GUID;
653:
654: l_custom_level varchar2(1);
655: l_found varchar2(1) := 'N';

Line 773: WF_EVENTS_APPS_PKG.setMode;

769: else
770: g_Mode := 'CUSTOM';
771: end if;
772: */
773: WF_EVENTS_APPS_PKG.setMode;
774: end setMode;
775:
776: ----------------------------------------------------------------------------
777: -- This is called by the OA Framework code before calling the table handlers

Line 793: WF_EVENTS_APPS_PKG.FWKsetMode;

789: else
790: g_Mode := 'CUSTOM';
791: end if;
792: */
793: WF_EVENTS_APPS_PKG.FWKsetMode;
794: end FWKsetMode;
795: ----------------------------------------------------------------------------
796: -- This is called by the Loader before calling any table handlers
797:

Line 805: end WF_EVENTS_PKG;

801: g_Mode := x_mode;
802: end LoadersetMode;
803: ----------------------------------------------------------------------------
804:
805: end WF_EVENTS_PKG;