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_EVENT

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 82: wf_event.raise('oracle.apps.wf.event.event.create',x_guid);

78: if (c%notfound) then
79: close c;
80: raise no_data_found;
81: else
82: wf_event.raise('oracle.apps.wf.event.event.create',x_guid);
83: end if;
84: close c;
85: exception
86: when others then

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 154: wf_event.raise('oracle.apps.wf.event.event.update',l_guid);

150: if (sql%notfound) then
151: raise no_data_found;
152: else
153: -- Only raise if all if no no_data_found
154: wf_event.raise('oracle.apps.wf.event.event.update',l_guid);
155: end if;
156:
157: else
158: -- User logged in is not seed. Its either the UI or the Loader

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 276: wf_event.raise('oracle.apps.wf.event.event.update',l_guid);

272: end if;
273:
274: -- Only raise if update has succeeded.
275: if (l_raise_event_flag = 'Y') then
276: wf_event.raise('oracle.apps.wf.event.event.update',l_guid);
277: end if;
278:
279: end if;
280:

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 294: wf_event.raise('oracle.apps.wf.event.event.delete',x_guid);

290: procedure DELETE_ROW (
291: X_GUID in raw
292: ) is
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:

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 474: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);

470: where guid = x_guid;
471:
472: l_doc := xmldom.newDOMDocument;
473: l_root := xmldom.makeNode(l_doc);
474: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
475: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',

Line 475: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);

471:
472: l_doc := xmldom.newDOMDocument;
473: l_root := xmldom.makeNode(l_doc);
474: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
475: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));

Line 476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,

472: l_doc := xmldom.newDOMDocument;
473: l_root := xmldom.makeNode(l_doc);
474: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
475: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');

Line 478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',

474: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
475: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');
481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);

Line 480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');

476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');
481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);
483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);

Line 481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',

477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');
481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);
483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);
485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',

Line 483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',

479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');
481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);
483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);
485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
486: l_status);
487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',

Line 485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',

481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);
483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);
485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
486: l_status);
487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',
488: l_generate_function);
489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',

Line 487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',

483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);
485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
486: l_status);
487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',
488: l_generate_function);
489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
490: l_owner_name);
491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',

Line 489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',

485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
486: l_status);
487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',
488: l_generate_function);
489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
490: l_owner_name);
491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
492: l_owner_tag);
493: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',

Line 491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',

487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',
488: l_generate_function);
489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
490: l_owner_name);
491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
492: l_owner_tag);
493: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
494: NVL(l_customization_level, 'L'));
495: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',

Line 493: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',

489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
490: l_owner_name);
491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
492: l_owner_tag);
493: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
494: NVL(l_customization_level, 'L'));
495: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
496: NVL(l_licensed_flag, 'Y'));
497:

Line 495: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',

491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
492: l_owner_tag);
493: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
494: NVL(l_customization_level, 'L'));
495: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
496: NVL(l_licensed_flag, 'Y'));
497:
498: --Bug 3328673
499: --New tag for loader nullable field

Line 500: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_GENERATE_FUNC',

496: NVL(l_licensed_flag, 'Y'));
497:
498: --Bug 3328673
499: --New tag for loader nullable field
500: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_GENERATE_FUNC',
501: l_javagenerate);
502:
503: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
504: l_display_name);

Line 503: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',

499: --New tag for loader nullable field
500: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_GENERATE_FUNC',
501: l_javagenerate);
502:
503: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
504: l_display_name);
505: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
506: l_description);
507:

Line 505: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',

501: l_javagenerate);
502:
503: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
504: l_display_name);
505: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
506: l_description);
507:
508: if (l_irep_annotation is null) then
509: -- create an annotation template

Line 525: -- l_node := wf_event_xml.newCDATATag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);

521: -- event was reviewed for annotation and decided not to be annotated
522: l_irep_annotation := null;
523: end if;
524:
525: -- l_node := wf_event_xml.newCDATATag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);
526: l_node := wf_event_xml.newtag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);
527:
528: xmldom.writeToBuffer(l_root, buf);
529:

Line 526: l_node := wf_event_xml.newtag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);

522: l_irep_annotation := null;
523: end if;
524:
525: -- l_node := wf_event_xml.newCDATATag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);
526: l_node := wf_event_xml.newtag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);
527:
528: xmldom.writeToBuffer(l_root, buf);
529:
530: return buf;

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 565: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW

561: l_irep_annotation varchar2(2000);
562: begin
563:
564: l_message := x_message;
565: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
566: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
567: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
568:
569: l_node_list := wf_event_xml.findTable(l_message, m_table_name);

Line 566: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL

562: begin
563:
564: l_message := x_message;
565: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
566: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
567: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
568:
569: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
570: l_length := xmldom.getLength(l_node_list);

Line 567: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID

563:
564: l_message := x_message;
565: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
566: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
567: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
568:
569: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
570: l_length := xmldom.getLength(l_node_list);
571:

Line 569: l_node_list := wf_event_xml.findTable(l_message, m_table_name);

565: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
566: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
567: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
568:
569: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
570: l_length := xmldom.getLength(l_node_list);
571:
572: -- loop through elements that we received.
573: for i in 0..l_length-1 loop

Line 605: elsif(l_node_name = wf_event_xml.versionTagName) then

601: elsif(l_node_name = 'CUSTOMIZATION_LEVEL') then
602: l_CUSTOMIZATION_LEVEL := l_value;
603: elsif(l_node_name = 'LICENSED_FLAG') then
604: l_LICENSED_FLAG := l_value;
605: elsif(l_node_name = wf_event_xml.versionTagName) then
606: l_version := l_value;
607: elsif(l_node_name = 'JAVA_GENERATE_FUNC') then
608: l_javagenerate := l_value;
609: elsif(l_node_name = 'IREP_ANNOTATION') then

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;