APPS.WF_EVENT_HTML dependencies on WF_EVENT

Line 1: package body WF_EVENT_HTML as

1: package body WF_EVENT_HTML as
2: /* $Header: wfehtmb.pls 120.4 2005/11/08 00:43:44 nravindr ship $ */
3:
4: --
5: -- isDeletable

Line 24: from WF_EVENTS

20: begin
21: if (x_type = 'EVENT_S' or x_type = 'EVENT') then
22: -- If the Event is of a Custom Level of Core or Limit you cannot delete it
23: select count(1) into member_count
24: from WF_EVENTS
25: where GUID = x_guid
26: and CUSTOMIZATION_LEVEL in ('C','L');
27:
28: -- do not bother to check further if the event is of type Core/Limit

Line 35: from WF_EVENT_SUBSCRIPTIONS

31: end if;
32:
33: -- if there is any subscription, it has detail and is not deletable.
34: select count(1) into member_count
35: from WF_EVENT_SUBSCRIPTIONS
36: where EVENT_FILTER_GUID = x_guid;
37:
38: -- do not bother to check further if there are subscriptions.
39: if (member_count > 0) then

Line 47: from WF_EVENT_SUBSCRIPTIONS

43: elsif (x_type = 'SYSTEM_S' or x_type = 'SYSTEM') then
44: -- SYSTEM_S is for checking subscription only.
45: -- if there is any subscrption, it is not deletable.
46: select count(1) into member_count
47: from WF_EVENT_SUBSCRIPTIONS
48: where SYSTEM_GUID = x_guid;
49:
50: -- SYSTEM_S also needs to check the new MASTER requirement
51: -- to see if it is a master of some body else

Line 64: from WF_EVENT_SUBSCRIPTIONS

60: end if;
61:
62: elsif (x_type = 'AGENT') then
63: select count(1) into member_count
64: from WF_EVENT_SUBSCRIPTIONS
65: where SOURCE_AGENT_GUID = x_guid
66: or OUT_AGENT_GUID = x_guid
67: or TO_AGENT_GUID = x_guid;
68:

Line 73: from WF_EVENT_SUBSCRIPTIONS

69: elsif (x_type = 'SUBSCRIPTION') then
70: -- there is no dependency at this moment
71: -- but later on, we may check the runtime table
72: select count(1) into member_count
73: from WF_EVENT_SUBSCRIPTIONS
74: where GUID = x_guid
75: and CUSTOMIZATION_LEVEL in ('C','L');
76:
77: -- do not bother to check further if the event is of type Core/Limit

Line 105: from wf_event_groups

101: -- Need to also check if the Event is part of an Event Group
102: if (x_type = 'EVENT') then
103: -- if it is part of a event group, it is not deletable
104: select count(1) into member_count
105: from wf_event_groups
106: where member_guid = x_guid;
107: end if;
108:
109: if (member_count > 0) then

Line 117: wf_core.context('WF_EVENT_HTML', 'isDeletable', rawtohex(x_guid), x_type);

113: return TRUE;
114:
115: exception
116: when OTHERS then
117: wf_core.context('WF_EVENT_HTML', 'isDeletable', rawtohex(x_guid), x_type);
118: raise;
119: end isDeletable;
120: --
121: -- isAccessible

Line 158: from wf_events;

154:
155: -- EVENTS: check if any events
156: if x_type = 'EVENTS' then
157: select count(*) into l_count
158: from wf_events;
159: end if;
160:
161: -- SUBSCRIPTIONS: check if any event subscriptions for LOCAL
162: if x_type = 'SUBSCRIPTIONS' then

Line 164: from wf_event_subscriptions

160:
161: -- SUBSCRIPTIONS: check if any event subscriptions for LOCAL
162: if x_type = 'SUBSCRIPTIONS' then
163: select count(*) into l_count
164: from wf_event_subscriptions
165: where system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
166: end if;
167:
168: -- If the count is zero, we didn't find what we were looking for

Line 175: wf_core.context('WF_EVENT_HTML', 'isAccessible', x_type);

171: end if;
172:
173: exception
174: when OTHERS then
175: wf_core.context('WF_EVENT_HTML', 'isAccessible', x_type);
176: raise;
177: end isAccessible;
178:
179: -- ListEvents

Line 192: from WF_EVENTS_VL

188: resetcookie in varchar2 default 'F')
189: is
190: cursor evcurs(xn varchar2, xdn varchar2, xt varchar2, xs varchar2) is
191: select GUID, DISPLAY_NAME, NAME, TYPE, STATUS
192: from WF_EVENTS_VL
193: where (xt = '*' or TYPE = xt)
194: and (xdn is null or lower(DISPLAY_NAME) like '%'||lower(xdn)||'%')
195: and (xn is null or lower(NAME) like '%'||lower(xn)||'%')
196: and (xs = '*' or STATUS = xs)

Line 218: wf_events_pkg.setMode;

214: begin
215: -- Check session and current user
216: wfa_sec.GetSession(username);
217: username := upper(username);
218: wf_events_pkg.setMode;
219:
220: -- Check Admin Priviledge
221: admin_role := wf_core.translate('WF_ADMIN_ROLE');
222: if (admin_role = '*' or

Line 231: wf_event_html.isAccessible('EVENTS');

227: wf_core.raise('WF_NOTADMIN');
228: end if;
229:
230: -- Check if Accessible
231: wf_event_html.isAccessible('EVENTS');
232:
233: l_name := h_name;
234: l_display_name := h_display_name;
235: l_type := h_type;

Line 241: cookie := owa_cookie.get('WF_EVENT_COOKIE');

237:
238: -- try to get the values from cookie if nothing is set
239: if (resetcookie='F' and l_name is null and l_display_name is null and
240: l_type = '*' and l_status = '*') then
241: cookie := owa_cookie.get('WF_EVENT_COOKIE');
242:
243: -- ignore if more than one value was set
244: if (cookie.num_vals = 1) then
245: c := instr(cookie.vals(1), ':');

Line 273: owa_cookie.send('WF_EVENT_COOKIE',

269:
270: -- set cookie
271: else
272: owa_util.mime_header('text/html', FALSE);
273: owa_cookie.send('WF_EVENT_COOKIE',
274: l_name||':'||
275: l_display_name||':'||
276: l_type||':'||
277: l_status);

Line 293: dTab(i).hasdetail := not Wf_Event_Html.isDeletable(event.guid, 'EVENT_S');

289: dTab(i).col04:= wf_core.translate(event.status);
290:
291: dTab(i).selectable := FALSE;
292:
293: dTab(i).hasdetail := not Wf_Event_Html.isDeletable(event.guid, 'EVENT_S');
294:
295: -- when there is subscription, it is not deletable
296: if (dTab(i).hasdetail) then
297: dTab(i).deletable := FALSE;

Line 301: dTab(i).deletable := Wf_Event_Html.isDeletable(event.guid, 'EVENT');

297: dTab(i).deletable := FALSE;
298:
299: -- otherwise, we need to check further
300: else
301: dTab(i).deletable := Wf_Event_Html.isDeletable(event.guid, 'EVENT');
302: end if;
303:
304: end loop;
305:

Line 326: owa_util.get_owa_service_path||'wf_event_html.FindEvent',

322: htp.headClose;
323:
324: -- Page header
325: wfa_sec.Header(FALSE,
326: owa_util.get_owa_service_path||'wf_event_html.FindEvent',
327: wf_core.translate('WFE_LIST_EVENTS_TITLE'),
328: TRUE);
329:
330: htp.br; -- add some space between header and table

Line 335: hTab(i).value := 'Wf_Event_Html.DeleteEvent?h_guid=';

331:
332: -- populate the header table
333: i := 1;
334: hTab(i).def_type := 'FUNCTION';
335: hTab(i).value := 'Wf_Event_Html.DeleteEvent?h_guid=';
336: i := i+1;
337: hTab(i).def_type := 'FUNCTION';
338: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&'||
339: 'h_event_guid=';

Line 338: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&'||

334: hTab(i).def_type := 'FUNCTION';
335: hTab(i).value := 'Wf_Event_Html.DeleteEvent?h_guid=';
336: i := i+1;
337: hTab(i).def_type := 'FUNCTION';
338: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&'||
339: 'h_event_guid=';
340: i := i+1;
341: hTab(i).def_type := 'FUNCTION';
342: hTab(i).value := 'Wf_Event_Html.EditEvent?h_guid=';

Line 342: hTab(i).value := 'Wf_Event_Html.EditEvent?h_guid=';

338: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&'||
339: 'h_event_guid=';
340: i := i+1;
341: hTab(i).def_type := 'FUNCTION';
342: hTab(i).value := 'Wf_Event_Html.EditEvent?h_guid=';
343: i := i+1;
344: hTab(i).def_type := 'TITLE';
345: hTab(i).value := wf_core.translate('SUBSCRIPTIONS');
346: hTab(i).attr := 'id="'||wf_core.translate('SUBSCRIPTIONS')||'"';

Line 373: wfa_html.create_reg_button (wfa_html.base_url||'/Wf_Event_Html.EditEvent',

369:
370: htp.tableopen (calign=>'CENTER ', cattributes=>'summary""');
371: htp.tableRowOpen;
372: htp.p('');
373: wfa_html.create_reg_button (wfa_html.base_url||'/Wf_Event_Html.EditEvent',
374: wf_core.translate('WFE_ADD_EVENT'),
375: wfa_html.image_loc,
376: null,
377: wf_core.translate('WFE_ADD_EVENT'));

Line 381: '/Wf_Event_Html.EditEvent?h_type=GROUP',

377: wf_core.translate('WFE_ADD_EVENT'));
378: htp.p('');
379: htp.p('');
380: wfa_html.create_reg_button (wfa_html.base_url||
381: '/Wf_Event_Html.EditEvent?h_type=GROUP',
382: wf_core.translate('WFE_ADD_GROUP'),
383: wfa_html.image_loc,
384: null,
385: wf_core.translate('WFE_ADD_GROUP'));

Line 396: wf_core.context('WF_EVENT_HTML', 'ListEvents');

392:
393: exception
394: when OTHERS then
395: rollback;
396: wf_core.context('WF_EVENT_HTML', 'ListEvents');
397: wfe_html_util.Error;
398: end ListEvents;
399:
400: --

Line 449: wf_events_pkg.setMode;

445: begin
446: -- Check session and current user
447: wfa_sec.GetSession(username);
448: username := upper(username);
449: wf_events_pkg.setMode;
450:
451: -- Check Admin Priviledge
452: admin_role := wf_core.translate('WF_ADMIN_ROLE');
453: if (admin_role = '*' or

Line 462: wf_event_html.isAccessible('SYSTEM');

458: wf_core.raise('WF_NOTADMIN');
459: end if;
460:
461: -- Check if Accessible
462: wf_event_html.isAccessible('SYSTEM');
463:
464: l_mguid := hextoraw(h_master_guid);
465: Wf_Event_Html.Validate_System_Name(display_master, l_mguid);
466:

Line 465: Wf_Event_Html.Validate_System_Name(display_master, l_mguid);

461: -- Check if Accessible
462: wf_event_html.isAccessible('SYSTEM');
463:
464: l_mguid := hextoraw(h_master_guid);
465: Wf_Event_Html.Validate_System_Name(display_master, l_mguid);
466:
467: -- find the local system guid
468: begin
469: select hextoraw(TEXT)

Line 561: from WF_EVENT_SUBSCRIPTIONS

557:
558: dTab(i).selectable := FALSE;
559:
560: select count(1) into acnt
561: from WF_EVENT_SUBSCRIPTIONS
562: where SYSTEM_GUID = asystem.guid;
563:
564: if (acnt = 0) then
565: dTab(i).deletable := Wf_Event_Html.isDeletable(asystem.guid, 'SYSTEM');

Line 565: dTab(i).deletable := Wf_Event_Html.isDeletable(asystem.guid, 'SYSTEM');

561: from WF_EVENT_SUBSCRIPTIONS
562: where SYSTEM_GUID = asystem.guid;
563:
564: if (acnt = 0) then
565: dTab(i).deletable := Wf_Event_Html.isDeletable(asystem.guid, 'SYSTEM');
566: dTab(i).hasdetail := FALSE;
567: else
568: dTab(i).deletable := FALSE; -- has reference from subscriptions
569: dTab(i).hasdetail := TRUE;

Line 592: owa_util.get_owa_service_path||'wf_event_html.FindSystem',

588: htp.headClose;
589:
590: -- Page header
591: wfa_sec.Header(FALSE,
592: owa_util.get_owa_service_path||'wf_event_html.FindSystem',
593: wf_core.translate('WFE_LIST_SYSTEMS_TITLE'),
594: TRUE);
595:
596: htp.br; -- add some space between header and table

Line 601: hTab(i).value := 'Wf_Event_Html.DeleteSystem?h_guid=';

597:
598: -- popluate the header table
599: i := 1;
600: hTab(i).def_type := 'FUNCTION';
601: hTab(i).value := 'Wf_Event_Html.DeleteSystem?h_guid=';
602: i := i+1;
603: hTab(i).def_type := 'FUNCTION';
604: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&h_system_guid=';
605: i := i+1;

Line 604: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&h_system_guid=';

600: hTab(i).def_type := 'FUNCTION';
601: hTab(i).value := 'Wf_Event_Html.DeleteSystem?h_guid=';
602: i := i+1;
603: hTab(i).def_type := 'FUNCTION';
604: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&h_system_guid=';
605: i := i+1;
606: hTab(i).def_type := 'FUNCTION';
607: hTab(i).value := 'Wf_Event_Html.EditSystem?h_guid=';
608: i := i+1;

Line 607: hTab(i).value := 'Wf_Event_Html.EditSystem?h_guid=';

603: hTab(i).def_type := 'FUNCTION';
604: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&h_system_guid=';
605: i := i+1;
606: hTab(i).def_type := 'FUNCTION';
607: hTab(i).value := 'Wf_Event_Html.EditSystem?h_guid=';
608: i := i+1;
609: hTab(i).def_type := 'TITLE';
610: hTab(i).value := wf_core.translate('SUBSCRIPTIONS');
611: hTab(i).attr := 'id="'||wf_core.translate('SUBSCRIPTIONS')||'"';

Line 647: wfa_html.create_reg_button (wfa_html.base_url||'/Wf_Event_Html.EditSystem',

643:
644: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
645: htp.tableRowOpen;
646: htp.p('');
647: wfa_html.create_reg_button (wfa_html.base_url||'/Wf_Event_Html.EditSystem',
648: wf_core.translate('WFE_ADD_SYSTEM'),
649: wfa_html.image_loc,
650: null,
651: wf_core.translate('WFE_ADD_SYSTEM'));

Line 662: wf_core.context('WF_EVENT_HTML', 'ListSystems');

658:
659: exception
660: when OTHERS then
661: rollback;
662: wf_core.context('WF_EVENT_HTML', 'ListSystems');
663: wfe_html_util.Error;
664: end ListSystems;
665:
666: --

Line 723: wf_events_pkg.setMode;

719: begin
720: -- Check session and current user
721: wfa_sec.GetSession(username);
722: username := upper(username);
723: wf_events_pkg.setMode;
724:
725: -- Check Admin Priviledge
726: admin_role := wf_core.translate('WF_ADMIN_ROLE');
727: if (admin_role = '*' or

Line 736: wf_event_html.isAccessible('AGENTS');

732: wf_core.raise('WF_NOTADMIN');
733: end if;
734:
735: -- Check if Accessible
736: wf_event_html.isAccessible('AGENTS');
737:
738: l_sguid := hextoraw(h_system_guid);
739: if (use_guid_only = 'F') then
740: Wf_Event_Html.Validate_System_Name(display_system, l_sguid);

Line 740: Wf_Event_Html.Validate_System_Name(display_system, l_sguid);

736: wf_event_html.isAccessible('AGENTS');
737:
738: l_sguid := hextoraw(h_system_guid);
739: if (use_guid_only = 'F') then
740: Wf_Event_Html.Validate_System_Name(display_system, l_sguid);
741: end if;
742:
743: l_name := h_name;
744: l_protocol := h_protocol;

Line 864: dTab(i).deletable := Wf_Event_Html.isDeletable(agent.guid, 'AGENT');

860: dTab(i).col05:= wf_core.translate(agent.status);
861:
862: dTab(i).selectable := FALSE;
863:
864: dTab(i).deletable := Wf_Event_Html.isDeletable(agent.guid, 'AGENT');
865:
866: dTab(i).hasdetail := FALSE;
867:
868: end loop;

Line 890: owa_util.get_owa_service_path||'wf_event_html.FindAgent',

886: htp.headClose;
887:
888: -- Page header
889: wfa_sec.Header(FALSE,
890: owa_util.get_owa_service_path||'wf_event_html.FindAgent',
891: wf_core.translate('WFE_LIST_AGENTS_TITLE'),
892: TRUE);
893:
894: htp.br; -- add some space between header and table

Line 899: hTab(i).value := 'Wf_Event_Html.DeleteAgent?h_guid=';

895:
896: -- popluate the header table
897: i := 1;
898: hTab(i).def_type := 'FUNCTION';
899: hTab(i).value := 'Wf_Event_Html.DeleteAgent?h_guid=';
900: i := i+1;
901: hTab(i).def_type := 'FUNCTION';
902: hTab(i).value := null; -- never has detail page
903: i := i+1;

Line 905: hTab(i).value := 'Wf_Event_Html.EditAgent?h_guid=';

901: hTab(i).def_type := 'FUNCTION';
902: hTab(i).value := null; -- never has detail page
903: i := i+1;
904: hTab(i).def_type := 'FUNCTION';
905: hTab(i).value := 'Wf_Event_Html.EditAgent?h_guid=';
906: i := i+1;
907: hTab(i).def_type := 'TITLE';
908: hTab(i).value := null; -- no detail title
909: hTab(i).level := 0;

Line 968: wfa_html.create_reg_button (wfa_html.base_url||'/Wf_Event_Html.EditAgent',

964:
965: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
966: htp.tableRowOpen;
967: htp.p('');
968: wfa_html.create_reg_button (wfa_html.base_url||'/Wf_Event_Html.EditAgent',
969: wf_core.translate('WFE_ADD_AGENT'),
970: wfa_html.image_loc,
971: null,
972: wf_core.translate('WFE_ADD_AGENT'));

Line 983: wf_core.context('WF_EVENT_HTML', 'ListAgents');

979:
980: exception
981: when OTHERS then
982: rollback;
983: wf_core.context('WF_EVENT_HTML', 'ListAgents');
984: wfe_html_util.Error;
985: end ListAgents;
986:
987: --

Line 1010: from WF_EVENT_SUBSCRIPTIONS ES, WF_EVENTS E, WF_SYSTEMS SY

1006: ES.STATUS,
1007: ES.OUT_AGENT_GUID, ES.TO_AGENT_GUID,
1008: ES.RULE_FUNCTION, ES.WF_PROCESS_TYPE, ES.WF_PROCESS_NAME,
1009: SY.NAME SYSTEM_NAME, E.NAME EVENT_NAME
1010: from WF_EVENT_SUBSCRIPTIONS ES, WF_EVENTS E, WF_SYSTEMS SY
1011: where (eguid is null or ES.EVENT_FILTER_GUID = eguid)
1012: and (xt = '*' or ES.SOURCE_TYPE = xt)
1013: and (sguid is null or ES.SYSTEM_GUID = sguid)
1014: and (xs = '*' or ES.STATUS = xs)

Line 1054: wf_events_pkg.setMode;

1050: begin
1051: -- Check session and current user
1052: wfa_sec.GetSession(username);
1053: username := upper(username);
1054: wf_events_pkg.setMode;
1055:
1056: -- Check Admin Priviledge
1057: admin_role := wf_core.translate('WF_ADMIN_ROLE');
1058: if (admin_role = '*' or

Line 1067: wf_event_html.isAccessible('SUBSCRIPTIONS');

1063: wf_core.raise('WF_NOTADMIN');
1064: end if;
1065:
1066: -- Check if Accessible
1067: wf_event_html.isAccessible('SUBSCRIPTIONS');
1068:
1069: l_eguid := hextoraw(h_event_guid);
1070: l_sguid := hextoraw(h_system_guid);
1071: if (use_guid_only = 'F') then

Line 1072: Wf_Event_Html.Validate_Event_Name(display_event, l_eguid);

1068:
1069: l_eguid := hextoraw(h_event_guid);
1070: l_sguid := hextoraw(h_system_guid);
1071: if (use_guid_only = 'F') then
1072: Wf_Event_Html.Validate_Event_Name(display_event, l_eguid);
1073: Wf_Event_Html.Validate_System_Name(display_system, l_sguid);
1074: end if;
1075:
1076: l_source_type := h_source_type;

Line 1073: Wf_Event_Html.Validate_System_Name(display_system, l_sguid);

1069: l_eguid := hextoraw(h_event_guid);
1070: l_sguid := hextoraw(h_system_guid);
1071: if (use_guid_only = 'F') then
1072: Wf_Event_Html.Validate_Event_Name(display_event, l_eguid);
1073: Wf_Event_Html.Validate_System_Name(display_system, l_sguid);
1074: end if;
1075:
1076: l_source_type := h_source_type;
1077: l_status := h_status;

Line 1144: from WF_EVENTS

1140: -- from event
1141: begin
1142: select NAME
1143: into l_name
1144: from WF_EVENTS
1145: where GUID = l_eguid;
1146: exception
1147: when OTHERS then
1148: l_name := null;

Line 1355: dTab(i).deletable := Wf_Event_Html.isDeletable(ssr.guid, 'SUBSCRIPTION');

1351: dTab(i).col07 := wf_core.translate(ssr.status);
1352:
1353: dTab(i).selectable := FALSE;
1354: -- dTab(i).deletable := TRUE;
1355: dTab(i).deletable := Wf_Event_Html.isDeletable(ssr.guid, 'SUBSCRIPTION');
1356: dTab(i).hasdetail := FALSE;
1357:
1358: end loop;
1359:

Line 1380: owa_util.get_owa_service_path||'wf_event_html.FindSubscription',

1376: htp.headClose;
1377:
1378: -- Page header
1379: wfa_sec.Header(FALSE,
1380: owa_util.get_owa_service_path||'wf_event_html.FindSubscription',
1381: wf_core.translate('WFE_LIST_SUBSC_TITLE'),
1382: TRUE);
1383:
1384: htp.br; -- add some space between header and table

Line 1389: hTab(i).value := 'Wf_Event_Html.DeleteSubscription?h_guid=';

1385:
1386: -- popluate the header table
1387: i := 1;
1388: hTab(i).def_type := 'FUNCTION';
1389: hTab(i).value := 'Wf_Event_Html.DeleteSubscription?h_guid=';
1390: i := i+1;
1391: hTab(i).def_type := 'FUNCTION';
1392: hTab(i).value := null; -- never has detail page
1393: i := i+1;

Line 1395: hTab(i).value := 'Wf_Event_Html.EditSubscription?h_guid=';

1391: hTab(i).def_type := 'FUNCTION';
1392: hTab(i).value := null; -- never has detail page
1393: i := i+1;
1394: hTab(i).def_type := 'FUNCTION';
1395: hTab(i).value := 'Wf_Event_Html.EditSubscription?h_guid=';
1396: i := i+1;
1397: hTab(i).def_type := 'TITLE';
1398: hTab(i).value := null; -- no detail title
1399: hTab(i).level := 0;

Line 1487: l_url := wfa_html.base_url||'/Wf_Event_Html.EditSubscription';

1483: htp.tableRowOpen;
1484: htp.p('');
1485:
1486: -- construct the url for add subscription
1487: l_url := wfa_html.base_url||'/Wf_Event_Html.EditSubscription';
1488: if (from_system) then
1489: l_url := l_url||'?h_sguid='||rawtohex(l_sguid);
1490: if (from_event) then
1491: l_url := l_url||'&h_eguid='||rawtohex(l_eguid); -- both system & event

Line 1512: wf_core.context('WF_EVENT_HTML', 'ListSubscriptions');

1508:
1509: exception
1510: when OTHERS then
1511: rollback;
1512: wf_core.context('WF_EVENT_HTML', 'ListSubscriptions');
1513: wfe_html_util.Error;
1514: end ListSubscriptions;
1515:
1516: --

Line 1558: from WF_EVENTS_VL E, WF_EVENT_GROUPS EG

1554: -- deletable event cursor
1555: -- all events belong to the group
1556: cursor devcurs is
1557: select E.GUID, E.DISPLAY_NAME, E.NAME, E.STATUS
1558: from WF_EVENTS_VL E, WF_EVENT_GROUPS EG
1559: where EG.GROUP_GUID = h_guid
1560: and E.GUID = EG.MEMBER_GUID;
1561:
1562:

Line 1573: wf_events_pkg.setMode;

1569: begin
1570: -- Check session and current user
1571: wfa_sec.GetSession(username);
1572: username := upper(username);
1573: wf_events_pkg.setMode;
1574:
1575: -- Check Admin Priviledge
1576: admin_role := wf_core.translate('WF_ADMIN_ROLE');
1577: if (admin_role = '*' or

Line 1586: wf_event_html.isAccessible('EVENTS');

1582: wf_core.raise('WF_NOTADMIN');
1583: end if;
1584:
1585: -- Check if Accessible
1586: wf_event_html.isAccessible('EVENTS');
1587:
1588:
1589: -- populate the appropriate values in the form if editing an exist guid
1590: if (h_guid is not null) then

Line 1596: from WF_EVENTS_VL

1592: select NAME, DISPLAY_NAME, DESCRIPTION, TYPE, STATUS,
1593: GENERATE_FUNCTION, OWNER_NAME, OWNER_TAG, NVL(CUSTOMIZATION_LEVEL, 'L')
1594: into l_name, l_dname, l_desc, l_type, l_status,
1595: l_gfunc, l_ownname, l_owntag, l_customization_level
1596: from WF_EVENTS_VL
1597: where GUID = h_guid;
1598:
1599: -- take care of the double quote problem
1600: -- There should be no any kind of quote for name and generate_function.

Line 1640: from WF_EVENT_GROUPS

1636:
1637: -- check if we can change a group type to an event type
1638: -- allow this only when a group does not has any child event.
1639: select count(1) into eventcount
1640: from WF_EVENT_GROUPS
1641: where GROUP_GUID = h_guid;
1642:
1643: if (eventcount > 0) then
1644: edittype := FALSE;

Line 1685: owa_util.get_owa_service_path||'wf_event_html.FindEvent',

1681: htp.headClose;
1682:
1683: -- Page header
1684: wfa_sec.Header(FALSE,
1685: owa_util.get_owa_service_path||'wf_event_html.FindEvent',
1686: wf_core.translate('WFE_EDIT_'||l_type||'_TITLE'),
1687: TRUE);
1688:
1689: -- Form

Line 1691: 'wf_event_html.SubmitEvent',

1687: TRUE);
1688:
1689: -- Form
1690: htp.formOpen(curl=>owa_util.get_owa_service_path||
1691: 'wf_event_html.SubmitEvent',
1692: cmethod=>'Get',
1693: cattributes=>'TARGET="_top" NAME="WF_EVENT_EDIT"');
1694:
1695: -- GUID

Line 1693: cattributes=>'TARGET="_top" NAME="WF_EVENT_EDIT"');

1689: -- Form
1690: htp.formOpen(curl=>owa_util.get_owa_service_path||
1691: 'wf_event_html.SubmitEvent',
1692: cmethod=>'Get',
1693: cattributes=>'TARGET="_top" NAME="WF_EVENT_EDIT"');
1694:
1695: -- GUID
1696: -- do not display it if it is null
1697: if (h_guid is not null) then

Line 1806: if wf_events_pkg.g_Mode = 'FORCE' then

1802: calign=>'Left',cattributes=>'id=""');
1803: htp.tableRowClose;
1804:
1805: -- Customization Level
1806: if wf_events_pkg.g_Mode = 'FORCE' then
1807: template := htf.formSelectOpen('h_custom_level',cattributes=>'id="i_custom_level"')
1808: ||wf_core.newline||
1809: htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_C'),
1810: select_custom_core,'VALUE="C"')

Line 1838: htp.formHidden('url', 'Wf_Event_Html.ListEvents');

1834: -- URL to go back to
1835: if (h_guid is null and l_type = 'GROUP') then
1836: htp.formHidden('url', ''); -- signal the coming back to this screen
1837: else
1838: htp.formHidden('url', 'Wf_Event_Html.ListEvents');
1839: end if;
1840:
1841: htp.tableClose;
1842: htp.formClose;

Line 1847: htp.p(' document.WF_EVENT_EDIT.h_display_name.value="'||l_dname||'"');

1843:
1844: -- add values that may contain double quote back through javascript
1845: if (h_guid is not null) then
1846: htp.p('');
1851: end if;

Line 1848: htp.p(' document.WF_EVENT_EDIT.h_owner_name.value="'||l_ownname||'"');

1844: -- add values that may contain double quote back through javascript
1845: if (h_guid is not null) then
1846: htp.p('');
1851: end if;
1852:

Line 1849: htp.p(' document.WF_EVENT_EDIT.h_owner_tag.value="'||l_owntag||'"');

1845: if (h_guid is not null) then
1846: htp.p('');
1851: end if;
1852:
1853: -- if is group, display events for deletion

Line 1868: dTab(i).hasdetail := not Wf_Event_Html.isDeletable(event.guid, 'EVENT');

1864: dTab(i).deletable := FALSE; -- do not allow deletion
1865:
1866: -- it is deletable when there is no subscription; that is,
1867: -- there is no detail.
1868: dTab(i).hasdetail := not Wf_Event_Html.isDeletable(event.guid, 'EVENT');
1869: end loop;
1870:
1871: htp.p(wf_core.translate('WFE_EVENTS_IN_GROUP'));
1872:

Line 1875: 'Wf_Event_Html.SubmitSelectedGEvents',

1871: htp.p(wf_core.translate('WFE_EVENTS_IN_GROUP'));
1872:
1873: -- Submit Form for Add/Delete
1874: htp.formOpen(curl=>owa_util.get_owa_service_path||
1875: 'Wf_Event_Html.SubmitSelectedGEvents',
1876: cmethod=>'Post',
1877: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
1878: htp.formHidden('h_gguid', rawtohex(h_guid));
1879:

Line 1885: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));

1881: htp.formHidden(cname=>'action', cvalue=>'');
1882:
1883: -- Url to come back to later
1884: htp.formHidden(cname=>'url',
1885: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));
1886:
1887: -- Add dummy fields to start both array-type input fields.
1888: -- These dummy values are needed so that the array parameters to
1889: -- the submit procedure will not be null even if there are no real

Line 1900: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&'||

1896: hTab(i).def_type := 'FUNCTION';
1897: hTab(i).value := null; -- delete is not allowed here
1898: i := i+1;
1899: hTab(i).def_type := 'FUNCTION';
1900: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&'||
1901: 'h_event_guid=';
1902: i := i+1;
1903: hTab(i).def_type := 'FUNCTION';
1904: hTab(i).value := 'Wf_Event_Html.EditEvent?h_guid=';

Line 1904: hTab(i).value := 'Wf_Event_Html.EditEvent?h_guid=';

1900: hTab(i).value := 'Wf_Event_Html.ListSubscriptions?use_guid_only=T&'||
1901: 'h_event_guid=';
1902: i := i+1;
1903: hTab(i).def_type := 'FUNCTION';
1904: hTab(i).value := 'Wf_Event_Html.EditEvent?h_guid=';
1905: i := i+1;
1906: hTab(i).def_type := 'TITLE';
1907: hTab(i).value := wf_core.translate('SUBSCRIPTIONS');
1908: hTab(i).attr := 'id="'||wf_core.translate('SUBSCRIPTIONS')||'"';

Line 1992: wfa_html.create_reg_button ('javascript:document.WF_EVENT_EDIT.submit()',

1988: htp.tableopen (calign=>'RIGHT', cattributes=>'summary=""');
1989: htp.tableRowOpen;
1990:
1991: htp.p('');
1992: wfa_html.create_reg_button ('javascript:document.WF_EVENT_EDIT.submit()',
1993: wf_core.translate('SUBMIT'),
1994: wfa_html.image_loc,
1995: null,
1996: wf_core.translate('SUBMIT'));

Line 2022: wfa_html.create_reg_button ('javascript:document.WF_EVENT_EDIT.submit()',

2018: htp.tableRowOpen;
2019:
2020: htp.p('');
2021:
2022: wfa_html.create_reg_button ('javascript:document.WF_EVENT_EDIT.submit()',
2023: wf_core.translate('SUBMIT'),
2024: wfa_html.image_loc,
2025: null,
2026: wf_core.translate('SUBMIT'));

Line 2048: wf_core.context('WF_EVENT_HTML', 'EditEvent', h_guid);

2044:
2045: exception
2046: when others then
2047: rollback;
2048: wf_core.context('WF_EVENT_HTML', 'EditEvent', h_guid);
2049: wfe_html_util.Error;
2050: end EditEvent;
2051:
2052: --

Line 2073: from WF_EVENTS_VL

2069: -- addable event cursor
2070: -- all events meet the query criteria excluding the group itself
2071: cursor aevcurs is
2072: select GUID, DISPLAY_NAME, NAME, TYPE, STATUS
2073: from WF_EVENTS_VL
2074: where (h_type = '*' or TYPE = h_type)
2075: and (h_display_name is null or lower(DISPLAY_NAME) like
2076: '%'||lower(h_display_name)||'%')
2077: and (h_name is null or lower(NAME) like '%'||lower(h_name)||'%')

Line 2086: from WF_EVENTS_VL E, WF_EVENT_GROUPS EG

2082: -- deletable event cursor
2083: -- all events belong to the group
2084: cursor devcurs is
2085: select E.GUID, E.DISPLAY_NAME, E.NAME, E.STATUS
2086: from WF_EVENTS_VL E, WF_EVENT_GROUPS EG
2087: where EG.GROUP_GUID = h_guid
2088: and E.GUID = EG.MEMBER_GUID;
2089:
2090:

Line 2105: wf_events_pkg.setMode;

2101: begin
2102: -- Check session and current user
2103: wfa_sec.GetSession(username);
2104: username := upper(username);
2105: wf_events_pkg.setMode;
2106:
2107: -- Check Admin Priviledge
2108: admin_role := wf_core.translate('WF_ADMIN_ROLE');
2109: if (admin_role = '*' or

Line 2118: wf_event_html.isAccessible('EVENTS');

2114: wf_core.raise('WF_NOTADMIN');
2115: end if;
2116:
2117: -- Check if Accessible
2118: wf_event_html.isAccessible('EVENTS');
2119:
2120:
2121: -- Render page
2122: htp.htmlOpen;

Line 2148: from WF_EVENTS_VL

2144: -- Group to edit
2145: begin
2146: select NAME, DISPLAY_NAME
2147: into l_name, l_dname
2148: from WF_EVENTS_VL
2149: where GUID = h_guid;
2150:
2151: -- take care of the double quote problem
2152: -- l_dname := replace(l_dname, '"', '\"');

Line 2201: 'Wf_Event_Html.SubmitSelectedGEvents',

2197: end if;
2198:
2199: -- Submit Form for Add/Delete
2200: htp.formOpen(curl=>owa_util.get_owa_service_path||
2201: 'Wf_Event_Html.SubmitSelectedGEvents',
2202: cmethod=>'Get',
2203: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
2204: htp.formHidden('h_gguid', rawtohex(h_guid));
2205:

Line 2211: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));

2207: htp.formHidden(cname=>'action', cvalue=>'');
2208:
2209: -- Url to come back to later
2210: htp.formHidden(cname=>'url',
2211: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));
2212:
2213: -- Add dummy fields to start both array-type input fields.
2214: -- These dummy values are needed so that the array parameters to
2215: -- the submit procedure will not be null even if there are no real

Line 2308: wf_core.context('WF_EVENT_HTML', 'EditGroup', rawtohex(h_guid));

2304: htp.htmlClose;
2305: exception
2306: when others then
2307: rollback;
2308: wf_core.context('WF_EVENT_HTML', 'EditGroup', rawtohex(h_guid));
2309: wfe_html_util.Error;
2310: end EditGroup;
2311:
2312: --

Line 2340: wf_events_pkg.setMode;

2336: begin
2337: -- Check session and current user
2338: wfa_sec.GetSession(username);
2339: username := upper(username);
2340: wf_events_pkg.setMode;
2341:
2342: -- Check Admin Priviledge
2343: admin_role := wf_core.translate('WF_ADMIN_ROLE');
2344: if (admin_role = '*' or

Line 2353: wf_event_html.isAccessible('SYSTEM');

2349: wf_core.raise('WF_NOTADMIN');
2350: end if;
2351:
2352: -- Check if Accessible
2353: wf_event_html.isAccessible('SYSTEM');
2354:
2355: -- Set page title
2356: htp.htmlOpen;
2357: htp.headOpen;

Line 2367: owa_util.get_owa_service_path||'wf_event_html.FindEvent',

2363: htp.headClose;
2364:
2365: -- Page header
2366: wfa_sec.Header(FALSE,
2367: owa_util.get_owa_service_path||'wf_event_html.FindEvent',
2368: wf_core.translate('WFE_EDIT_SYSTEM_TITLE'),
2369: TRUE);
2370:
2371: -- populate the appropriate values in the form if editing an exist guid

Line 2408: 'wf_event_html.SubmitSystem',

2404:
2405: end if;
2406: -- Form
2407: htp.formOpen(curl=>owa_util.get_owa_service_path||
2408: 'wf_event_html.SubmitSystem',
2409: cmethod=>'Get',
2410: cattributes=>'TARGET="_top" NAME="WF_SYSTEM_EDIT"');
2411:
2412: -- GUID

Line 2473: '&p_validation_callback=wf_event_html.wf_system_val'||

2469: -- the proper escape sequence.
2470: l_url := 'javascript:fnd_open_dm_display_window('||''''||
2471: REPLACE('wf_lov.display_lov?p_lov_name='||'h_master_guid'||
2472: '&p_display_name='||'SYSTEM'||
2473: '&p_validation_callback=wf_event_html.wf_system_val'||
2474: '&p_dest_hidden_field=top.opener.parent.document.WF_SYSTEM_EDIT.h_master_guid.value'||
2475: '&p_current_value=top.opener.parent.document.WF_SYSTEM_EDIT.display_master.value'||
2476: '&p_display_key='||'Y'||
2477: '&p_dest_display_field=top.opener.parent.document.WF_SYSTEM_EDIT.display_master.value',

Line 2493: htp.formHidden('url', 'Wf_Event_Html.ListSystems');

2489:
2490: htp.tableRowClose;
2491:
2492: -- URL to go back to
2493: htp.formHidden('url', 'Wf_Event_Html.ListSystems');
2494:
2495: htp.tableClose;
2496: htp.formClose;
2497:

Line 2537: wf_core.context('WF_EVENT_HTML', 'EditSystem', h_guid);

2533:
2534: exception
2535: when others then
2536: rollback;
2537: wf_core.context('WF_EVENT_HTML', 'EditSystem', h_guid);
2538: wfe_html_util.Error;
2539: end EditSystem;
2540:
2541: --

Line 2589: wf_events_pkg.setMode;

2585: begin
2586: -- Check session and current user
2587: wfa_sec.GetSession(username);
2588: username := upper(username);
2589: wf_events_pkg.setMode;
2590:
2591: -- Check Admin Priviledge
2592: admin_role := wf_core.translate('WF_ADMIN_ROLE');
2593: if (admin_role = '*' or

Line 2602: wf_event_html.isAccessible('AGENTS');

2598: wf_core.raise('WF_NOTADMIN');
2599: end if;
2600:
2601: -- Check if Accessible
2602: wf_event_html.isAccessible('AGENTS');
2603:
2604: -- Set page title
2605: htp.htmlOpen;
2606: htp.headOpen;

Line 2616: owa_util.get_owa_service_path||'wf_event_html.FindAgent',

2612: htp.headClose;
2613:
2614: -- Page header
2615: wfa_sec.Header(FALSE,
2616: owa_util.get_owa_service_path||'wf_event_html.FindAgent',
2617: wf_core.translate('WFE_EDIT_AGENT_TITLE'),
2618: TRUE);
2619:
2620: -- populate the appropriate values in the form if editing an exist guid

Line 2664: 'wf_event_html.SubmitAgent',

2660: end if;
2661:
2662: -- Form
2663: htp.formOpen(curl=>owa_util.get_owa_service_path||
2664: 'wf_event_html.SubmitAgent',
2665: cmethod=>'Get',
2666: cattributes=>'TARGET="_top" NAME="WF_AGENT_EDIT"');
2667:
2668: -- GUID

Line 2781: '&p_validation_callback=wf_event_html.wf_system_val'||

2777: -- the proper escape sequence.
2778: l_url := 'javascript:fnd_open_dm_display_window('||''''||
2779: REPLACE('wf_lov.display_lov?p_lov_name='||'h_system_guid'||
2780: '&p_display_name='||'SYSTEM'||
2781: '&p_validation_callback=wf_event_html.wf_system_val'||
2782: '&p_dest_hidden_field=top.opener.parent.document.WF_AGENT_EDIT.h_system_guid.value'||
2783: '&p_current_value=top.opener.parent.document.WF_AGENT_EDIT.display_system.value'||
2784: '&p_display_key='||'Y'||
2785: '&p_dest_display_field=top.opener.parent.document.WF_AGENT_EDIT.display_system.value',

Line 2860: htp.formHidden('url', 'Wf_Event_Html.ListAgents');

2856: htp.tableData(cvalue=>template, calign=>'Left',cattributes=>'id=""');
2857: htp.tableRowClose;
2858:
2859: -- URL to go back to
2860: htp.formHidden('url', 'Wf_Event_Html.ListAgents');
2861:
2862: htp.tableClose;
2863: htp.formClose;
2864:

Line 2904: wf_core.context('WF_EVENT_HTML', 'EditAgent', h_guid);

2900:
2901: exception
2902: when others then
2903: rollback;
2904: wf_core.context('WF_EVENT_HTML', 'EditAgent', h_guid);
2905: wfe_html_util.Error;
2906: end EditAgent;
2907:
2908: --

Line 2986: wf_events_pkg.setMode;

2982: begin
2983: -- Check session and current user
2984: wfa_sec.GetSession(username);
2985: username := upper(username);
2986: wf_events_pkg.setMode;
2987:
2988: -- Check Admin Priviledge
2989: admin_role := wf_core.translate('WF_ADMIN_ROLE');
2990: if (admin_role = '*' or

Line 2999: wf_event_html.isAccessible('SUBSCRIPTIONS');

2995: wf_core.raise('WF_NOTADMIN');
2996: end if;
2997:
2998: -- Check if Accessible
2999: wf_event_html.isAccessible('SUBSCRIPTIONS');
3000:
3001: -- Set page title
3002: htp.headOpen;
3003:

Line 3030: owa_util.get_owa_service_path||'wf_event_html.FindSubscription',

3026: htp.headClose;
3027:
3028: -- Page header
3029: wfa_sec.Header(FALSE,
3030: owa_util.get_owa_service_path||'wf_event_html.FindSubscription',
3031: wf_core.translate('WFE_EDIT_SUBSC_TITLE'),
3032: TRUE);
3033:
3034: -- populate the appropriate values in the form if editing an exist guid

Line 3073: from WF_EVENT_SUBSCRIPTIONS

3069: l_wfpname,
3070: l_param,
3071: l_customization_level,
3072: l_desc
3073: from WF_EVENT_SUBSCRIPTIONS
3074: where GUID = h_guid;
3075:
3076: -- take care of the double quote problem
3077: -- Description is handle entirely differently, no need for substitution.

Line 3162: from WF_EVENTS_VL

3158: if (l_evtguid is not null) then
3159: begin
3160: select NAME
3161: into l_event_name
3162: from WF_EVENTS_VL
3163: where GUID = l_evtguid;
3164:
3165: exception
3166: when NO_DATA_FOUND then

Line 3268: from WF_EVENTS_VL

3264: if (h_eguid is not null) then
3265: begin
3266: select NAME
3267: into l_event_name
3268: from WF_EVENTS_VL
3269: where GUID = h_eguid;
3270:
3271: exception
3272: when NO_DATA_FOUND then

Line 3286: 'wf_event_html.SubmitSubscription',

3282: htp.formClose;
3283:
3284: -- Form
3285: htp.formOpen(curl=>owa_util.get_owa_service_path||
3286: 'wf_event_html.SubmitSubscription',
3287: cmethod=>'Get',
3288: cattributes=>'TARGET="_top" NAME="WF_SUBSC_EDIT"');
3289:
3290: -- GUID

Line 3320: '&p_validation_callback=wf_event_html.wf_system_val'||

3316: -- the proper escape sequence.
3317: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3318: REPLACE('wf_lov.display_lov?p_lov_name='||'h_system_guid'||
3319: '&p_display_name='||'SYSTEM'||
3320: '&p_validation_callback=wf_event_html.wf_system_val'||
3321: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_system_guid.value'||
3322: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_system.value'||
3323: '&p_display_key='||'Y'||
3324: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.display_system.value',

Line 3378: '&p_validation_callback=wf_event_html.wf_event_val'||

3374: -- the proper escape sequence.
3375: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3376: REPLACE('wf_lov.display_lov?p_lov_name='||'h_event_guid'||
3377: '&p_display_name='||'WFE_FIND_EVENT'||
3378: '&p_validation_callback=wf_event_html.wf_event_val'||
3379: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_event_guid.value'||
3380: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_event.value'||
3381: '&p_display_key='||'Y'||
3382: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.display_event.value',

Line 3409: '&p_validation_callback=wf_event_html.wf_agent_val'||

3405: -- the proper escape sequence.
3406: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3407: REPLACE('wf_lov.display_lov?p_lov_name='||'h_source_agent_guid'||
3408: '&p_display_name='||'WFE_FIND_AGENT'||
3409: '&p_validation_callback=wf_event_html.wf_agent_val'||
3410: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_source_agent_guid.value'||
3411: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_source_agent.value'||
3412: '&p_display_key='||'Y'||
3413: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.display_source_agent.value',

Line 3510: '&p_validation_callback=wf_event_html.wf_itemtype_val'||

3506: -- the proper escape sequence.
3507: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3508: REPLACE('wf_lov.display_lov?p_lov_name='||'h_wfptype_dname'||
3509: '&p_display_name='||'ITEMTYPE'||
3510: '&p_validation_callback=wf_event_html.wf_itemtype_val'||
3511: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_wfptype_dname.value'||
3512: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.h_wfptype.value'||
3513: '&p_display_key='||'Y'||
3514: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.h_wfptype.value',

Line 3541: '&p_validation_callback=wf_event_html.wf_processname_val'||

3537: -- the proper escape sequence.
3538: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3539: REPLACE('wf_lov.display_lov?p_lov_name='||'h_wfpname'||
3540: '&p_display_name='||'PROCESS'||
3541: '&p_validation_callback=wf_event_html.wf_processname_val'||
3542: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_wfptn.value'||
3543: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.h_wfpname.value'||
3544: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.h_wfpname.value'||
3545: '&p_display_key='||'Y'||

Line 3574: '&p_validation_callback=wf_event_html.wf_agent_val'||

3570: -- the proper escape sequence.
3571: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3572: REPLACE('wf_lov.display_lov?p_lov_name='||'h_out_agent_guid'||
3573: '&p_display_name='||'AGENT'||
3574: '&p_validation_callback=wf_event_html.wf_agent_val'||
3575: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_out_agent_guid.value'||
3576: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_out_agent.value'||
3577: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.display_out_agent.value'||
3578: '&p_display_key='||'Y'||

Line 3608: '&p_validation_callback=wf_event_html.wf_agent_val'||

3604: -- the proper escape sequence.
3605: l_url := 'javascript:fnd_open_dm_display_window('||''''||
3606: REPLACE('wf_lov.display_lov?p_lov_name='||'h_to_agent_guid'||
3607: '&p_display_name='||'AGENT'||
3608: '&p_validation_callback=wf_event_html.wf_agent_val'||
3609: '&p_dest_hidden_field=top.opener.parent.document.WF_SUBSC_EDIT.h_to_agent_guid.value'||
3610: '&p_current_value=top.opener.parent.document.WF_SUBSC_EDIT.display_to_agent.value'||
3611: '&p_dest_display_field=top.opener.parent.document.WF_SUBSC_EDIT.display_to_agent.value'||
3612: '&p_display_key='||'Y'||

Line 3695: if wf_events_pkg.g_Mode = 'FORCE' then

3691: calign=>'Left',cattributes=>'id=""');
3692: htp.tableRowClose;
3693:
3694: -- Customization Level
3695: if wf_events_pkg.g_Mode = 'FORCE' then
3696: template := htf.formSelectOpen('h_custom_level',cattributes=>'id="i_custom_level"')
3697: ||wf_core.newline||
3698: htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_C'),
3699: select_custom_core,'VALUE="C"')

Line 3758: htp.formHidden('url', 'Wf_Event_Html.ListSubscriptions');

3754: calign=>'Left',cattributes=>'id=""');
3755: htp.tableRowClose;
3756:
3757: -- URL to go back to
3758: htp.formHidden('url', 'Wf_Event_Html.ListSubscriptions');
3759:
3760: htp.tableClose;
3761: htp.formClose;
3762:

Line 3813: wf_core.context('WF_EVENT_HTML', 'EditSubscription');

3809:
3810: exception
3811: when OTHERS then
3812: rollback;
3813: wf_core.context('WF_EVENT_HTML', 'EditSubscription');
3814: wfe_html_util.Error;
3815: end EditSubscription;
3816:
3817: --

Line 3855: wf_events_pkg.setMode;

3851: begin
3852: -- Check session and current user
3853: wfa_sec.GetSession(username);
3854: username := upper(username);
3855: wf_events_pkg.setMode;
3856:
3857: -- Check Admin Priviledge
3858: admin_role := wf_core.translate('WF_ADMIN_ROLE');
3859: if (admin_role = '*' or

Line 3871: Wf_Events_Pkg.Update_Row(

3867: if (h_guid is not null) then
3868: l_guid := hextoraw(h_guid);
3869:
3870: -- update
3871: Wf_Events_Pkg.Update_Row(
3872: X_GUID=>l_guid,
3873: X_NAME=>h_name,
3874: X_TYPE=>h_type,
3875: X_STATUS=>h_status,

Line 3889: Wf_Events_Pkg.Insert_Row(

3885: else
3886: l_guid := sys_guid();
3887:
3888: -- insert
3889: Wf_Events_Pkg.Insert_Row(
3890: X_ROWID=>row_id,
3891: X_GUID=>l_guid,
3892: X_NAME=>h_name,
3893: X_TYPE=>h_type,

Line 3909: Wf_Event_Html.EditEvent(l_guid);

3905:
3906: -- If url is not specified, we know that it is from the edit event screen
3907: -- for group, so return to that screen with the newly created event guid.
3908: if (url is null or url = '') then
3909: Wf_Event_Html.EditEvent(l_guid);
3910:
3911: -- Go to a specific url
3912: else
3913: Wfe_Html_Util.gotoURL(url);

Line 3919: wf_core.context('WF_EVENT_HTML', 'SubmitEvent', rawtohex(l_guid));

3915:
3916: exception
3917: when OTHERS then
3918: rollback;
3919: wf_core.context('WF_EVENT_HTML', 'SubmitEvent', rawtohex(l_guid));
3920: wfe_html_util.Error;
3921: end SubmitEvent;
3922:
3923: --

Line 3946: Wf_Event_Html.FindEvent(h_gguid);

3942: elsif (action = 'FIND') then
3943: -- action is FIND
3944: -- so find event for EditGroup
3945: -- ignore hguid_array
3946: Wf_Event_Html.FindEvent(h_gguid);
3947: return;
3948: elsif (action = 'DELETE') then
3949: l_guid := hextoraw(h_guids(2));
3950: Wf_Event_Html.DeleteSelectedGEvents(h_gguid, h_guids);

Line 3950: Wf_Event_Html.DeleteSelectedGEvents(h_gguid, h_guids);

3946: Wf_Event_Html.FindEvent(h_gguid);
3947: return;
3948: elsif (action = 'DELETE') then
3949: l_guid := hextoraw(h_guids(2));
3950: Wf_Event_Html.DeleteSelectedGEvents(h_gguid, h_guids);
3951: elsif (action = 'ADD') then
3952: Wf_Event_Html.AddSelectedGEvents(h_gguid, h_guids);
3953: end if;
3954:

Line 3952: Wf_Event_Html.AddSelectedGEvents(h_gguid, h_guids);

3948: elsif (action = 'DELETE') then
3949: l_guid := hextoraw(h_guids(2));
3950: Wf_Event_Html.DeleteSelectedGEvents(h_gguid, h_guids);
3951: elsif (action = 'ADD') then
3952: Wf_Event_Html.AddSelectedGEvents(h_gguid, h_guids);
3953: end if;
3954:
3955: Wfe_Html_Util.gotoURL(url);
3956:

Line 3960: wf_core.context('WF_EVENT_HTML', 'SubmitSelectedGEvents',

3956:
3957: exception
3958: when OTHERS then
3959: rollback;
3960: wf_core.context('WF_EVENT_HTML', 'SubmitSelectedGEvents',
3961: rawtohex(h_gguid), url);
3962: wfe_html_util.Error;
3963: end SubmitSelectedGEvents;
3964:

Line 3994: wf_events_pkg.setMode;

3990: begin
3991: -- Check session and current user
3992: wfa_sec.GetSession(username);
3993: username := upper(username);
3994: wf_events_pkg.setMode;
3995:
3996: -- Check Admin Priviledge
3997: admin_role := wf_core.translate('WF_ADMIN_ROLE');
3998: if (admin_role = '*' or

Line 4007: Wf_Event_Html.Validate_System_Name(display_master, l_mguid);

4003: wf_core.raise('WF_NOTADMIN');
4004: end if;
4005:
4006: l_mguid := hextoraw(h_master_guid);
4007: Wf_Event_Html.Validate_System_Name(display_master, l_mguid);
4008:
4009: if (h_guid is not null) then
4010: l_guid := hextoraw(h_guid);
4011:

Line 4042: wf_core.context('WF_EVENT_HTML', 'SubmitSystem', rawtohex(l_guid));

4038:
4039: exception
4040: when OTHERS then
4041: rollback;
4042: wf_core.context('WF_EVENT_HTML', 'SubmitSystem', rawtohex(l_guid));
4043: wfe_html_util.Error;
4044: end SubmitSystem;
4045:
4046: --

Line 4086: wf_events_pkg.setMode;

4082: begin
4083: -- Check session and current user
4084: wfa_sec.GetSession(username);
4085: username := upper(username);
4086: wf_events_pkg.setMode;
4087:
4088: -- Check Admin Priviledge
4089: admin_role := wf_core.translate('WF_ADMIN_ROLE');
4090: if (admin_role = '*' or

Line 4099: Wf_Event_Html.Validate_System_Name(display_system, l_system_guid);

4095: wf_core.raise('WF_NOTADMIN');
4096: end if;
4097:
4098: l_system_guid := hextoraw(h_system_guid);
4099: Wf_Event_Html.Validate_System_Name(display_system, l_system_guid);
4100:
4101: if (h_guid is not null) then
4102: l_guid := hextoraw(h_guid);
4103:

Line 4145: wf_core.context('WF_EVENT_HTML', 'SubmitAgent', rawtohex(l_guid));

4141:
4142: exception
4143: when OTHERS then
4144: rollback;
4145: wf_core.context('WF_EVENT_HTML', 'SubmitAgent', rawtohex(l_guid));
4146: wfe_html_util.Error;
4147: end SubmitAgent;
4148:
4149: --

Line 4211: wf_events_pkg.setMode;

4207: begin
4208: -- Check session and current user
4209: wfa_sec.GetSession(username);
4210: username := upper(username);
4211: wf_events_pkg.setMode;
4212:
4213: -- Check Admin Priviledge
4214: admin_role := wf_core.translate('WF_ADMIN_ROLE');
4215: if (admin_role = '*' or

Line 4225: Wf_Event_Html.Validate_System_Name(display_system, l_sysguid);

4221: end if;
4222:
4223: -- validate LOVs
4224: l_sysguid := hextoraw(h_system_guid);
4225: Wf_Event_Html.Validate_System_Name(display_system, l_sysguid);
4226:
4227: l_evtguid := hextoraw(h_event_guid);
4228: Wf_Event_Html.Validate_Event_Name(display_event, l_evtguid);
4229:

Line 4228: Wf_Event_Html.Validate_Event_Name(display_event, l_evtguid);

4224: l_sysguid := hextoraw(h_system_guid);
4225: Wf_Event_Html.Validate_System_Name(display_system, l_sysguid);
4226:
4227: l_evtguid := hextoraw(h_event_guid);
4228: Wf_Event_Html.Validate_Event_Name(display_event, l_evtguid);
4229:
4230: l_fagnguid := hextoraw(h_source_agent_guid);
4231: Wf_Event_Html.Validate_Agent_Name(display_source_agent, l_fagnguid);
4232:

Line 4231: Wf_Event_Html.Validate_Agent_Name(display_source_agent, l_fagnguid);

4227: l_evtguid := hextoraw(h_event_guid);
4228: Wf_Event_Html.Validate_Event_Name(display_event, l_evtguid);
4229:
4230: l_fagnguid := hextoraw(h_source_agent_guid);
4231: Wf_Event_Html.Validate_Agent_Name(display_source_agent, l_fagnguid);
4232:
4233: l_oagnguid := hextoraw(h_out_agent_guid);
4234: Wf_Event_Html.Validate_Agent_Name(display_out_agent, l_oagnguid);
4235:

Line 4234: Wf_Event_Html.Validate_Agent_Name(display_out_agent, l_oagnguid);

4230: l_fagnguid := hextoraw(h_source_agent_guid);
4231: Wf_Event_Html.Validate_Agent_Name(display_source_agent, l_fagnguid);
4232:
4233: l_oagnguid := hextoraw(h_out_agent_guid);
4234: Wf_Event_Html.Validate_Agent_Name(display_out_agent, l_oagnguid);
4235:
4236: l_tagnguid := hextoraw(h_to_agent_guid);
4237: Wf_Event_Html.Validate_Agent_Name(display_to_agent, l_tagnguid);
4238:

Line 4237: Wf_Event_Html.Validate_Agent_Name(display_to_agent, l_tagnguid);

4233: l_oagnguid := hextoraw(h_out_agent_guid);
4234: Wf_Event_Html.Validate_Agent_Name(display_out_agent, l_oagnguid);
4235:
4236: l_tagnguid := hextoraw(h_to_agent_guid);
4237: Wf_Event_Html.Validate_Agent_Name(display_to_agent, l_tagnguid);
4238:
4239: l_phase := to_number(h_phase);
4240: l_priority := to_number(h_priority);
4241:

Line 4246: Wf_Event_Subscriptions_Pkg.Update_Row (

4242: if (h_guid is not null) then
4243: l_guid := hextoraw(h_guid);
4244:
4245: -- update
4246: Wf_Event_Subscriptions_Pkg.Update_Row (
4247: X_GUID=>l_guid,
4248: X_SYSTEM_GUID=>l_sysguid,
4249: X_SOURCE_TYPE=>h_source_type,
4250: X_SOURCE_AGENT_GUID=>l_fagnguid,

Line 4271: Wf_Event_Subscriptions_Pkg.Insert_Row (

4267: else
4268: l_guid := sys_guid();
4269:
4270: -- insert
4271: Wf_Event_Subscriptions_Pkg.Insert_Row (
4272: X_ROWID=>row_id,
4273: X_GUID=>l_guid,
4274: X_SYSTEM_GUID=>l_sysguid,
4275: X_SOURCE_TYPE=>h_source_type,

Line 4301: wf_core.context('WF_EVENT_HTML', 'SubmitSubscription', rawtohex(l_guid));

4297:
4298: exception
4299: when OTHERS then
4300: rollback;
4301: wf_core.context('WF_EVENT_HTML', 'SubmitSubscription', rawtohex(l_guid));
4302: wfe_html_util.Error;
4303: end SubmitSubscription;
4304:
4305: --

Line 4328: from WF_EVENTS_VL

4324: -- addable event cursor
4325: -- all events meet the query criteria
4326: cursor aevcurs is
4327: select GUID, DISPLAY_NAME, NAME, TYPE, STATUS
4328: from WF_EVENTS_VL
4329: where TYPE = 'EVENT'
4330: and (h_display_name is null or lower(DISPLAY_NAME) like
4331: '%'||lower(h_display_name)||'%')
4332: and (h_name is null or lower(NAME) like '%'||lower(h_name)||'%')

Line 4346: wf_events_pkg.setMode;

4342: begin
4343: -- Check session and current user
4344: wfa_sec.GetSession(username);
4345: username := upper(username);
4346: wf_events_pkg.setMode;
4347:
4348: -- Check Admin Priviledge
4349: admin_role := wf_core.translate('WF_ADMIN_ROLE');
4350: if (admin_role = '*' or

Line 4359: wf_event_html.isAccessible('EVENTS');

4355: wf_core.raise('WF_NOTADMIN');
4356: end if;
4357:
4358: -- Check if Accessible
4359: wf_event_html.isAccessible('EVENTS');
4360:
4361: -- Determine if this is for group addition or not
4362: if (x_gguid is not null) then
4363: l_url := 'Wf_Event_Html.FindEvent';

Line 4363: l_url := 'Wf_Event_Html.FindEvent';

4359: wf_event_html.isAccessible('EVENTS');
4360:
4361: -- Determine if this is for group addition or not
4362: if (x_gguid is not null) then
4363: l_url := 'Wf_Event_Html.FindEvent';
4364:
4365: begin
4366: select NAME into l_name
4367: from WF_EVENTS

Line 4367: from WF_EVENTS

4363: l_url := 'Wf_Event_Html.FindEvent';
4364:
4365: begin
4366: select NAME into l_name
4367: from WF_EVENTS
4368: where GUID = x_gguid;
4369: exception
4370: when NO_DATA_FOUND then
4371: wf_core.raise('WFE_EVENT_NOTEXIST');

Line 4381: l_url := 'Wf_Event_Html.ListEvents';

4377:
4378: title := wf_core.translate('WFE_ADD_TO_GROUP')||': '||l_name;
4379: helptext := 'wf/links/t_d.htm?T_DEFEVGPM';
4380: else
4381: l_url := 'Wf_Event_Html.ListEvents';
4382: title := wf_core.translate('WFE_FIND_EVENT_TITLE');
4383: helptext := 'wf/links/t_f.htm?T_FDEVT';
4384: end if;
4385:

Line 4414: cattributes=>'TARGET="_top" NAME="WF_EVENT_FIND"');

4410:
4411: -- Form
4412: htp.formOpen(curl=>owa_util.get_owa_service_path||l_url,
4413: cmethod=>'Get',
4414: cattributes=>'TARGET="_top" NAME="WF_EVENT_FIND"');
4415:
4416: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary=""');
4417:
4418: -- hidden attribute for FindEvent

Line 4520: wfa_html.create_reg_button ('javascript:document.WF_EVENT_FIND.submit()',

4516: htp.tableRowOpen;
4517:
4518: htp.p('');
4519:
4520: wfa_html.create_reg_button ('javascript:document.WF_EVENT_FIND.submit()',
4521: wf_core.translate('GO'),
4522: wfa_html.image_loc,
4523: null,
4524: wf_core.translate('GO'));

Line 4536: htp.p(' document.WF_EVENT_FIND.h_name.value="'||h_name||'"');

4532: -- run the query to generate the event list.
4533: if (h_guid is not null) then
4534: -- populate the search fields
4535: htp.p('');
4540:

Line 4537: htp.p(' document.WF_EVENT_FIND.h_display_name.value="'

4533: if (h_guid is not null) then
4534: -- populate the search fields
4535: htp.p('');
4540:
4541: -- populate the data table

Line 4557: 'Wf_Event_Html.SubmitSelectedGEvents',

4553: end loop;
4554:
4555: -- Submit Form for Add/Delete
4556: htp.formOpen(curl=>owa_util.get_owa_service_path||
4557: 'Wf_Event_Html.SubmitSelectedGEvents',
4558: cmethod=>'Post',
4559: cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
4560: htp.formHidden('h_gguid', rawtohex(h_guid));
4561:

Line 4567: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));

4563: htp.formHidden(cname=>'action', cvalue=>'');
4564:
4565: -- Url to come back to later
4566: htp.formHidden(cname=>'url',
4567: cvalue=>'Wf_Event_Html.EditEvent?h_guid='||rawtohex(h_guid));
4568:
4569: -- Add dummy fields to start both array-type input fields.
4570: -- These dummy values are needed so that the array parameters to
4571: -- the submit procedure will not be null even if there are no real

Line 4644: wf_core.context('WF_EVENT_HTML', 'FindEvent', rawtohex(x_gguid));

4640:
4641: exception
4642: when others then
4643: rollback;
4644: wf_core.context('WF_EVENT_HTML', 'FindEvent', rawtohex(x_gguid));
4645: wfe_html_util.Error;
4646: end FindEvent;
4647:
4648: --

Line 4693: from WF_EVENT_GROUPS

4689: l_type varchar2(8);
4690:
4691: cursor evtc(xguid in raw) is
4692: select MEMBER_GUID
4693: from WF_EVENT_GROUPS
4694: where GROUP_GUID = xguid;
4695:
4696: begin
4697: if (isDeletable(h_guid, 'EVENT')) then

Line 4700: from WF_EVENTS

4696: begin
4697: if (isDeletable(h_guid, 'EVENT')) then
4698: begin
4699: select TYPE into l_type
4700: from WF_EVENTS
4701: where GUID = h_guid
4702: and TYPE = 'EVENT';
4703: exception
4704: -- if it is a group, delete all the child events

Line 4707: Wf_Event_Groups_Pkg.Delete_Row(

4703: exception
4704: -- if it is a group, delete all the child events
4705: when NO_DATA_FOUND then
4706: for evtr in evtc(h_guid) loop
4707: Wf_Event_Groups_Pkg.Delete_Row(
4708: x_group_guid=>h_guid,
4709: x_member_guid=>evtr.MEMBER_GUID
4710: );
4711: end loop;

Line 4714: Wf_Events_Pkg.Delete_Row(h_guid);

4710: );
4711: end loop;
4712: end;
4713:
4714: Wf_Events_Pkg.Delete_Row(h_guid);
4715: end if;
4716:
4717: -- go back to ListEvents
4718: Wfe_Html_Util.gotoURL(wfa_html.base_url||'/Wf_Event_Html.ListEvents');

Line 4718: Wfe_Html_Util.gotoURL(wfa_html.base_url||'/Wf_Event_Html.ListEvents');

4714: Wf_Events_Pkg.Delete_Row(h_guid);
4715: end if;
4716:
4717: -- go back to ListEvents
4718: Wfe_Html_Util.gotoURL(wfa_html.base_url||'/Wf_Event_Html.ListEvents');
4719:
4720: exception
4721: when others then
4722: rollback;

Line 4723: wf_core.context('WF_EVENT_HTML', 'DeleteEvent', rawtohex(h_guid));

4719:
4720: exception
4721: when others then
4722: rollback;
4723: wf_core.context('WF_EVENT_HTML', 'DeleteEvent', rawtohex(h_guid));
4724: wfe_html_util.Error;
4725: end DeleteEvent;
4726:
4727: --

Line 4745: wfa_html.base_url||'/Wf_Event_Html.ListSystems")');

4741:
4742: -- go back to ListSystems
4743: htp.p('');
4747:
4748: exception
4749: when others then

Line 4751: wf_core.context('WF_EVENT_HTML', 'DeleteSystem', rawtohex(h_guid));

4747:
4748: exception
4749: when others then
4750: rollback;
4751: wf_core.context('WF_EVENT_HTML', 'DeleteSystem', rawtohex(h_guid));
4752: wfe_html_util.Error;
4753: end DeleteSystem;
4754:
4755: --

Line 4773: wfa_html.base_url||'/Wf_Event_Html.ListAgents")');

4769:
4770: -- go back to ListAgents
4771: htp.p('');
4775:
4776: exception
4777: when others then

Line 4779: wf_core.context('WF_EVENT_HTML', 'DeleteAgent', rawtohex(h_guid));

4775:
4776: exception
4777: when others then
4778: rollback;
4779: wf_core.context('WF_EVENT_HTML', 'DeleteAgent', rawtohex(h_guid));
4780: wfe_html_util.Error;
4781: end DeleteAgent;
4782:
4783: -- DeleteSubscription

Line 4794: Wf_Event_Subscriptions_Pkg.Delete_Row(h_guid);

4790: h_guid in raw default null)
4791: is
4792: begin
4793: if (isDeletable(h_guid, 'SUBSCRIPTION')) then
4794: Wf_Event_Subscriptions_Pkg.Delete_Row(h_guid);
4795: end if;
4796:
4797: -- go back to ListSubscriptions
4798: htp.p('');
4802:
4803: exception
4804: when others then

Line 4806: wf_core.context('WF_EVENT_HTML', 'DeleteSubscription', rawtohex(h_guid));

4802:
4803: exception
4804: when others then
4805: rollback;
4806: wf_core.context('WF_EVENT_HTML', 'DeleteSubscription', rawtohex(h_guid));
4807: wfe_html_util.Error;
4808: end DeleteSubscription;
4809:
4810: --

Line 4811: -- wf_event_val

4807: wfe_html_util.Error;
4808: end DeleteSubscription;
4809:
4810: --
4811: -- wf_event_val
4812: -- Create the lov content for our event lov. This function
4813: -- is called by the generic lov function
4814: -- IN
4815: -- RETURNS

Line 4817: procedure wf_event_val (

4813: -- is called by the generic lov function
4814: -- IN
4815: -- RETURNS
4816: --
4817: procedure wf_event_val (
4818: p_mode in varchar2,
4819: p_lov_name in varchar2,
4820: p_start_row in number,
4821: p_max_rows in number,

Line 4829: from WF_EVENTS_VL

4825: is
4826:
4827: cursor evcurs (c_find_criteria in varchar2) is
4828: select GUID, NAME, DISPLAY_NAME
4829: from WF_EVENTS_VL
4830: where (UPPER(display_name) LIKE UPPER(c_find_criteria)||'%'
4831: and (display_name LIKE LOWER(SUBSTR(c_find_criteria, 1, 2))||'%'
4832: or display_name LIKE LOWER(SUBSTR(c_find_criteria, 1, 1))||
4833: UPPER(SUBSTR(c_find_criteria, 2, 1))||'%'

Line 4863: from WF_EVENTS_VL

4859: ** criteria before actually executing the fetch to show the user
4860: ** how many matches are available.
4861: */
4862: select count(*) into l_total_rows
4863: from WF_EVENTS_VL
4864: where (upper(DISPLAY_NAME) like upper(p_display_value)||'%'
4865: and (DISPLAY_NAME like lower(substr(p_display_value, 1, 2))||'%'
4866: or DISPLAY_NAME like lower(substr(p_display_value, 1, 1))||
4867: upper(SUBSTR(p_display_value, 2, 1))||'%'

Line 4901: from WF_EVENTS_VL

4897:
4898: elsif (p_mode = 'GET_DISPLAY_VAL') THEN
4899: select GUID, NAME, DISPLAY_NAME
4900: into l_guid, l_name, l_display_name
4901: from WF_EVENTS_VL
4902: where GUID = p_hidden_value;
4903:
4904: p_display_value := l_name;
4905:

Line 4945: from WF_EVENTS_VL

4941: if (ii = 2) then
4942:
4943: select count(*)
4944: into ii
4945: from WF_EVENTS_VL
4946: where NAME = p_display_value;
4947:
4948: end if;
4949:

Line 4957: wf_core.context('WF_EVENT_HTML', 'Wf_Event_Val');

4953: p_result := l_result;
4954: exception
4955: when OTHERS then
4956: rollback;
4957: wf_core.context('WF_EVENT_HTML', 'Wf_Event_Val');
4958: raise;
4959: end Wf_Event_Val;
4960:
4961: --

Line 4959: end Wf_Event_Val;

4955: when OTHERS then
4956: rollback;
4957: wf_core.context('WF_EVENT_HTML', 'Wf_Event_Val');
4958: raise;
4959: end Wf_Event_Val;
4960:
4961: --
4962: -- wf_system_val
4963: -- Create the lov content for our system lov. This function

Line 5088: wf_core.context('WF_EVENT_HTML', 'Wf_System_Val');

5084: p_result := l_result;
5085: exception
5086: when OTHERS then
5087: rollback;
5088: wf_core.context('WF_EVENT_HTML', 'Wf_System_Val');
5089: raise;
5090: end Wf_System_Val;
5091:
5092: --

Line 5247: wf_core.context('WF_EVENT_HTML', 'Wf_Agent_Val');

5243: p_result := l_result;
5244: exception
5245: when OTHERS then
5246: rollback;
5247: wf_core.context('WF_EVENT_HTML', 'Wf_Agent_Val');
5248: raise;
5249: end Wf_Agent_Val;
5250:
5251: --

Line 5379: wf_core.context('WF_EVENT_HTML', 'Wf_ItemType_Val');

5375: p_result := l_result;
5376: exception
5377: when OTHERS then
5378: rollback;
5379: wf_core.context('WF_EVENT_HTML', 'Wf_ItemType_Val');
5380: raise;
5381: end Wf_ItemType_Val;
5382:
5383: --

Line 5513: wf_core.context('WF_EVENT_HTML', 'Wf_ProcessName_Val');

5509: p_result := l_result;
5510: exception
5511: when OTHERS then
5512: rollback;
5513: wf_core.context('WF_EVENT_HTML', 'Wf_ProcessName_Val');
5514: raise;
5515: end Wf_ProcessName_Val;
5516:
5517: --

Line 5549: from WF_EVENTS

5545: l_upper_name := upper(p_name);
5546:
5547: select min(GUID)
5548: into l_guid
5549: from WF_EVENTS
5550: where GUID = l_upper_name;
5551:
5552: -- If you found a match, set p_guid accordingly.
5553: if (l_guid is not null) then

Line 5563: from WF_EVENTS

5559: else
5560: -- Count how many match the NAME
5561: select count(1)
5562: into l_names_count
5563: from WF_EVENTS
5564: where NAME = p_name;
5565:
5566: -- If you find a match, set p_guid accordingly.
5567: if (l_names_count = 1) then

Line 5570: from WF_EVENTS

5566: -- If you find a match, set p_guid accordingly.
5567: if (l_names_count = 1) then
5568: select GUID
5569: into p_guid
5570: from WF_EVENTS
5571: where NAME = p_name;
5572:
5573: return;
5574:

Line 5579: from WF_EVENTS_VL

5575: -- Count how many match the DISPLAY_NAME
5576: else
5577: select count(1)
5578: into l_dnames_count
5579: from WF_EVENTS_VL
5580: where DISPLAY_NAME = p_name;
5581:
5582: -- If you find a match, set p_guid accordingly.
5583: if (l_dnames_count = 1) then

Line 5586: from WF_EVENTS_VL

5582: -- If you find a match, set p_guid accordingly.
5583: if (l_dnames_count = 1) then
5584: select GUID
5585: into p_guid
5586: from WF_EVENTS_VL
5587: where DISPLAY_NAME = p_name;
5588:
5589: return;
5590:

Line 5613: wf_core.context('Wf_Event_Html', 'Validate_Event_Name', p_name,

5609: end if;
5610:
5611: exception
5612: when OTHERS then
5613: wf_core.context('Wf_Event_Html', 'Validate_Event_Name', p_name,
5614: rawtohex(p_guid));
5615: raise;
5616: end Validate_Event_Name;
5617:

Line 5714: wf_core.context('Wf_Event_Html', 'Validate_System_Name', p_name,

5710: end if;
5711:
5712: exception
5713: when OTHERS then
5714: wf_core.context('Wf_Event_Html', 'Validate_System_Name', p_name,
5715: rawtohex(p_guid));
5716: raise;
5717: end Validate_System_Name;
5718:

Line 5817: wf_core.context('Wf_Event_Html', 'Validate_Agent_Name', p_name,

5813: end if;
5814:
5815: exception
5816: when OTHERS then
5817: wf_core.context('Wf_Event_Html', 'Validate_Agent_Name', p_name,
5818: rawtohex(p_guid));
5819: raise;
5820: end Validate_Agent_Name;
5821:

Line 5840: from WF_EVENTS

5836: row_id varchar2(30);
5837: begin
5838: -- check group guid is indeed a group
5839: select count(1) into cnt
5840: from WF_EVENTS
5841: where GUID = h_gguid
5842: and TYPE = 'GROUP';
5843:
5844: if (cnt = 0) then

Line 5852: Wf_Event_Groups_Pkg.Insert_Row(

5848:
5849: -- add
5850: begin
5851: for i in 2..h_guids.LAST loop
5852: Wf_Event_Groups_Pkg.Insert_Row(
5853: x_rowid=>row_id,
5854: x_group_guid=>h_gguid,
5855: x_member_guid=>hextoraw(h_guids(i))
5856: );

Line 5867: wf_core.context('WF_EVENT_HTML', 'AddSelectedGEvents', rawtohex(h_gguid));

5863: end;
5864:
5865: exception
5866: when OTHERS then
5867: wf_core.context('WF_EVENT_HTML', 'AddSelectedGEvents', rawtohex(h_gguid));
5868: raise;
5869: end AddSelectedGEvents;
5870:
5871: --

Line 5888: Wf_Event_Groups_Pkg.Delete_Row(

5884: begin
5885: -- delete
5886: begin
5887: for i in 2..h_guids.LAST loop
5888: Wf_Event_Groups_Pkg.Delete_Row(
5889: x_group_guid=>h_gguid,
5890: x_member_guid=>hextoraw(h_guids(i))
5891: );
5892: end loop;

Line 5902: wf_core.context('WF_EVENT_HTML','DeleteSelectedGEvents',rawtohex(h_gguid));

5898: end;
5899:
5900: exception
5901: when OTHERS then
5902: wf_core.context('WF_EVENT_HTML','DeleteSelectedGEvents',rawtohex(h_gguid));
5903: raise;
5904: end DeleteSelectedGEvents;
5905: -- EnterEventDetails
5906: -- Enter Event Name, Event Key, Event Data to raise business event

Line 5916: -- Called from EnterEventDetails, calls wf_event.raise

5912: begin
5913: null;
5914: end EnterEventDetails;
5915: -- RaiseEvent
5916: -- Called from EnterEventDetails, calls wf_event.raise
5917: -- IN
5918: -- p_event_name - event name
5919: -- p_event_key - event key
5920: -- p_event_data - event data

Line 5936: wf_events_pkg.setMode;

5932:
5933: -- Check session and current user
5934: wfa_sec.GetSession(username);
5935: username := upper(username);
5936: wf_events_pkg.setMode;
5937:
5938: -- Check Admin Priviledge
5939: admin_role := wf_core.translate('WF_ADMIN_ROLE');
5940: if (admin_role = '*' or

Line 5949: wf_event.raise(p_event_name, p_event_key);

5945: wf_core.raise('WF_NOTADMIN');
5946: end if;
5947:
5948: if p_event_data is null then
5949: wf_event.raise(p_event_name, p_event_key);
5950: else
5951: dbms_lob.createtemporary(l_event_data, FALSE, DBMS_LOB.CALL);
5952: dbms_lob.write(l_event_data, length(p_event_data), 1 , p_event_data);
5953: wf_event.raise(p_event_name, p_event_key, l_event_data);

Line 5953: wf_event.raise(p_event_name, p_event_key, l_event_data);

5949: wf_event.raise(p_event_name, p_event_key);
5950: else
5951: dbms_lob.createtemporary(l_event_data, FALSE, DBMS_LOB.CALL);
5952: dbms_lob.write(l_event_data, length(p_event_data), 1 , p_event_data);
5953: wf_event.raise(p_event_name, p_event_key, l_event_data);
5954: end if;
5955:
5956: owa_util.redirect_url(curl=> wfa_html.base_url||'/wf_event_html.RaiseEventConfirm?p_event_name='||p_event_name||'&p_event_key='||p_event_key);
5957:

Line 5956: owa_util.redirect_url(curl=> wfa_html.base_url||'/wf_event_html.RaiseEventConfirm?p_event_name='||p_event_name||'&p_event_key='||p_event_key);

5952: dbms_lob.write(l_event_data, length(p_event_data), 1 , p_event_data);
5953: wf_event.raise(p_event_name, p_event_key, l_event_data);
5954: end if;
5955:
5956: owa_util.redirect_url(curl=> wfa_html.base_url||'/wf_event_html.RaiseEventConfirm?p_event_name='||p_event_name||'&p_event_key='||p_event_key);
5957:
5958: exception
5959: when OTHERS then
5960: rollback;

Line 5961: wf_core.context('WF_EVENT_HTML', 'RaiseEvent', p_event_name, p_event_key);

5957:
5958: exception
5959: when OTHERS then
5960: rollback;
5961: wf_core.context('WF_EVENT_HTML', 'RaiseEvent', p_event_name, p_event_key);
5962: wfe_html_util.Error;
5963: --raise;
5964: end RaiseEvent;
5965: -- RaiseEventConfirm

Line 5979: wf_events_pkg.setMode;

5975: begin
5976: -- Check session and current user
5977: wfa_sec.GetSession(username);
5978: username := upper(username);
5979: wf_events_pkg.setMode;
5980:
5981: -- Check Admin Priviledge
5982: admin_role := wf_core.translate('WF_ADMIN_ROLE');
5983: if (admin_role = '*' or

Line 6017: '/Wf_Event_Html.entereventdetails'||

6013: htp.tableopen (cattributes =>'align=CENTER border=0 summary=""');
6014: htp.tableRowOpen;
6015: htp.p('');
6016: wfa_html.create_reg_button (wfa_html.base_url||
6017: '/Wf_Event_Html.entereventdetails'||
6018: '?p_event_name=%',
6019: wf_core.translate('WFMON_OK'),
6020: wfa_html.image_loc,
6021: null,

Line 6033: wf_core.context('WF_EVENT_HTML', 'RaiseEventConfirm');

6029: htp.htmlClose;
6030: exception
6031: when OTHERS then
6032: rollback;
6033: wf_core.context('WF_EVENT_HTML', 'RaiseEventConfirm');
6034: wfe_html_util.Error;
6035: --raise;
6036: end RaiseEventConfirm;
6037: -- GetSystemIdentifier

Line 6048: l_begin_dtd varchar2(240) := '';

6044:
6045: l_system_guid raw(16);
6046: l_agent_guid raw(16);
6047:
6048: l_begin_dtd varchar2(240) := '';
6049: l_end_dtd varchar2(240) := '';
6050:
6051: l_dtd varchar2(32000);
6052: l_systems number;

Line 6049: l_end_dtd varchar2(240) := '';

6045: l_system_guid raw(16);
6046: l_agent_guid raw(16);
6047:
6048: l_begin_dtd varchar2(240) := '';
6049: l_end_dtd varchar2(240) := '';
6050:
6051: l_dtd varchar2(32000);
6052: l_systems number;
6053:

Line 6065: wf_events_pkg.setMode;

6061: begin
6062: -- Check session and current user
6063: wfa_sec.GetSession(username);
6064: username := upper(username);
6065: wf_events_pkg.setMode;
6066:
6067: -- Check Admin Priviledge
6068: admin_role := wf_core.translate('WF_ADMIN_ROLE');
6069: if (admin_role = '*' or

Line 6078: wf_event_html.isAccessible('AGENTS');

6074: wf_core.raise('WF_NOTADMIN');
6075: end if;
6076:
6077: -- Check if Accessible
6078: wf_event_html.isAccessible('AGENTS');
6079:
6080: -- Get Local System GUID
6081: l_system_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
6082:

Line 6109: wf_core.context('WF_EVENT_HTML', 'GetSystemIdentifier');

6105:
6106: exception
6107: when OTHERS then
6108: rollback;
6109: wf_core.context('WF_EVENT_HTML', 'GetSystemIdentifier');
6110: wfe_html_util.Error;
6111: --raise;
6112: end GetSystemIdentifier;
6113:

Line 6115: -- Shows all event queues and message count that use WF_EVENT_QH queue

6111: --raise;
6112: end GetSystemIdentifier;
6113:
6114: -- Event Queue Display
6115: -- Shows all event queues and message count that use WF_EVENT_QH queue
6116: -- handler
6117: -- MODIFICATION LOG:
6118: -- 06-JUN-2001 JWSMITH BUG 1819232 - Added alt attr for IMG tag for ADA
6119: --

Line 6150: --and upper(wfa.queue_handler) = 'WF_EVENT_QH'

6146: upper(wfa.queue_handler) QUEUE_HANDLER
6147: from wf_agents wfa ,
6148: all_queues aq
6149: where wfa.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
6150: --and upper(wfa.queue_handler) = 'WF_EVENT_QH'
6151: and aq.name = substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1)
6152: and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1)
6153: order by queue_name;
6154:

Line 6161: wf_events_pkg.setMode;

6157: begin
6158: -- Check current user has admin authority
6159: wfa_sec.GetSession(username);
6160: username := upper(username);
6161: wf_events_pkg.setMode;
6162:
6163: wf_directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
6164:
6165: admin_role := wf_core.translate('WF_ADMIN_ROLE');

Line 6176: wf_event_html.isAccessible('AGENTS');

6172:
6173: end if;
6174:
6175: -- Check if Accessible
6176: wf_event_html.isAccessible('AGENTS');
6177:
6178: -- Set page title
6179: htp.htmlOpen;
6180: htp.headOpen;

Line 6263: -- If it does, then we can allow drill down on wf_event_t

6259: wf_core.translate('QUEUE_COUNT') || '"');
6260:
6261: --
6262: -- Check if queue type matches default event queue WF_ERROR
6263: -- If it does, then we can allow drill down on wf_event_t
6264: --
6265: begin
6266: SELECT queue_name
6267: INTO l_default_queue

Line 6278: '/wf_event_html.FindQueueMessage?p_queue_name='||

6274: '',
6275: l_rc);
6276: IF l_rc = 1 then
6277: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
6278: '/wf_event_html.FindQueueMessage?p_queue_name='||
6279: queues.queue_name||'&p_type=WF_EVENT_T',
6280: ctext=>''),

Line 6279: queues.queue_name||'&p_type=WF_EVENT_T',

6275: l_rc);
6276: IF l_rc = 1 then
6277: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
6278: '/wf_event_html.FindQueueMessage?p_queue_name='||
6279: queues.queue_name||'&p_type=WF_EVENT_T',
6280: ctext=>''),
6283: 'center', cattributes=>'valign="MIDDLE" id=""');

Line 6301: '/wf_event_html.FindECXMSGQueueMessage?p_queue_name='||

6297: l_rc);
6298:
6299: IF l_rc = 1 then
6300: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
6301: '/wf_event_html.FindECXMSGQueueMessage?p_queue_name='||
6302: queues.queue_name||'&p_type=ECX_MSG',
6303: ctext=>''),

Line 6325: '/wf_event_html.FindECX_INENGOBJQueueMessage?p_queue_name='||

6321: l_rc);
6322:
6323: IF l_rc = 1 then
6324: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
6325: '/wf_event_html.FindECX_INENGOBJQueueMessage?p_queue_name='||
6326: queues.queue_name||'&p_type=INENGOBJ',
6327: ctext=>''),

Line 6358: wf_core.context('WF_EVENT_HTML', 'EventQueueDisplay');

6354:
6355: exception
6356: when others then
6357: rollback;
6358: wf_core.context('WF_EVENT_HTML', 'EventQueueDisplay');
6359: wfe_html_util.Error;
6360: --raise;
6361: end EventQueueDisplay;
6362: -- FindQueueMessage

Line 6394: from WF_EVENTS_VL

6390: -- addable event cursor
6391: -- all events meet the query criteria
6392: cursor aevcurs is
6393: select GUID, DISPLAY_NAME, NAME, TYPE, STATUS
6394: from WF_EVENTS_VL
6395: where TYPE = 'EVENT'
6396: order by NAME;
6397:
6398: begin

Line 6402: wf_events_pkg.setMode;

6398: begin
6399: -- Check session and current user
6400: wfa_sec.GetSession(username);
6401: username := upper(username);
6402: wf_events_pkg.setMode;
6403:
6404: -- Check Admin Priviledge
6405: admin_role := wf_core.translate('WF_ADMIN_ROLE');
6406: if (admin_role = '*' or

Line 6415: wf_event_html.isAccessible('AGENTS');

6411: wf_core.raise('WF_NOTADMIN');
6412: end if;
6413:
6414: -- Check if Accessible
6415: wf_event_html.isAccessible('AGENTS');
6416:
6417: l_url := 'Wf_Event_Html.ListQueueMessages';
6418: title := wf_core.translate('WFE_FIND_QUEUE_MESSAGES_TITLE');
6419: helptext := 'wf/links/t_f.htm?T_FDQMSG';

Line 6417: l_url := 'Wf_Event_Html.ListQueueMessages';

6413:
6414: -- Check if Accessible
6415: wf_event_html.isAccessible('AGENTS');
6416:
6417: l_url := 'Wf_Event_Html.ListQueueMessages';
6418: title := wf_core.translate('WFE_FIND_QUEUE_MESSAGES_TITLE');
6419: helptext := 'wf/links/t_f.htm?T_FDQMSG';
6420:
6421: -- Render page

Line 6526: wf_core.context('WF_EVENT_HTML', 'FindQueueMessage');

6522:
6523: exception
6524: when others then
6525: rollback;
6526: wf_core.context('WF_EVENT_HTML', 'FindQueueMessage');
6527: wfe_html_util.Error;
6528: end;
6529: -- FindECXMSGQueueMessage
6530: -- Filter Screen over Queue Messages

Line 6560: wf_events_pkg.setMode;

6556: begin
6557: -- Check session and current user
6558: wfa_sec.GetSession(username);
6559: username := upper(username);
6560: wf_events_pkg.setMode;
6561:
6562: -- Check Admin Priviledge
6563: admin_role := wf_core.translate('WF_ADMIN_ROLE');
6564: if (admin_role = '*' or

Line 6573: wf_event_html.isAccessible('AGENTS');

6569: wf_core.raise('WF_NOTADMIN');
6570: end if;
6571:
6572: -- Check if Accessible
6573: wf_event_html.isAccessible('AGENTS');
6574:
6575: l_url := 'ecx_workflow_html.ListECXMSGQueueMessages';
6576: title := wf_core.translate('WFE_FIND_QUEUE_MESSAGES_TITLE');
6577: helptext := 'wf/links/t_f.htm?T_FDQMSG';

Line 6695: wf_core.context('WF_EVENT_HTML', 'FindECXMSGQueueMessage');

6691:
6692: exception
6693: when others then
6694: rollback;
6695: wf_core.context('WF_EVENT_HTML', 'FindECXMSGQueueMessage');
6696: wfe_html_util.Error;
6697: end;
6698: -- FindECXMSGQueueMessage
6699: -- Filter Screen over Queue Messages

Line 6729: wf_events_pkg.setMode;

6725: begin
6726: -- Check session and current user
6727: wfa_sec.GetSession(username);
6728: username := upper(username);
6729: wf_events_pkg.setMode;
6730:
6731: -- Check Admin Priviledge
6732: admin_role := wf_core.translate('WF_ADMIN_ROLE');
6733: if (admin_role = '*' or

Line 6742: wf_event_html.isAccessible('AGENTS');

6738: wf_core.raise('WF_NOTADMIN');
6739: end if;
6740:
6741: -- Check if Accessible
6742: wf_event_html.isAccessible('AGENTS');
6743:
6744: l_url := 'ecx_workflow_html.ListECX_INENGOBJQueueMessages';
6745: title := wf_core.translate('WFE_FIND_QUEUE_MESSAGES_TITLE');
6746: helptext := 'wf/links/t_f.htm?T_FDQMSG';

Line 6842: wf_core.context('WF_EVENT_HTML', 'FindECX_INENGOBJQueueMessage');

6838:
6839: exception
6840: when others then
6841: rollback;
6842: wf_core.context('WF_EVENT_HTML', 'FindECX_INENGOBJQueueMessage');
6843: wfe_html_util.Error;
6844: end;
6845:
6846:

Line 6897: l_message wf_event_t;

6893: l_fromsystem varchar2(30);
6894: l_eventname varchar2(240);
6895: l_eventkey varchar2(240);
6896: l_string varchar2(240);
6897: l_message wf_event_t;
6898: l_sqlstmt varchar2(240);
6899: l_eventdata clob;
6900: l_state number;
6901: l_qtable varchar2(240);

Line 6912: wf_events_pkg.setMode;

6908: begin
6909: -- Check current user has admin authority
6910: wfa_sec.GetSession(username);
6911: username := upper(username);
6912: wf_events_pkg.setMode;
6913:
6914: wf_directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
6915:
6916: admin_role := wf_core.translate('WF_ADMIN_ROLE');

Line 6927: wf_event_html.isAccessible('AGENTS');

6923:
6924: end if;
6925:
6926: -- Check if Accessible
6927: wf_event_html.isAccessible('AGENTS');
6928:
6929: -- Set page title
6930: htp.htmlOpen;
6931: htp.headOpen;

Line 6936: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindQueueMessage?p_queue_name='||p_queue_name||'&p_type=WF_EVENT_T', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);

6932: htp.p('');
6933: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
6934: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
6935: htp.headClose;
6936: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindQueueMessage?p_queue_name='||p_queue_name||'&p_type=WF_EVENT_T', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
6937: htp.br;
6938:
6939: IF (admin_mode = 'N') THEN
6940: htp.center(htf.bold(l_error_msg));

Line 7196: '/wf_event_html.EventDataContents?p_message_id='||l_msg_id

7192:
7193: l_eventdata := l_message.GetEventData();
7194:
7195: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
7196: '/wf_event_html.EventDataContents?p_message_id='||l_msg_id
7197: ||'&p_queue_table='||l_qtable||'&p_mimetype=text/xml',
7198: ctext=>' 7199: BORDER=0>'),
7200: 'center', cattributes=>'valign="MIDDLE"

Line 7203: '/wf_event_html.EventDataContents?p_message_id='||l_msg_id

7199: BORDER=0>'),
7200: 'center', cattributes=>'valign="MIDDLE"
7201: headers="' || wf_core.translate('XMLEVENTDATA') || '"');
7202: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
7203: '/wf_event_html.EventDataContents?p_message_id='||l_msg_id
7204: ||'&p_queue_table='||l_qtable||'&p_mimetype=text',
7205: ctext=>' 7206: BORDER=0>'),
7207: 'center', cattributes=>'valign="MIDDLE"

Line 7226: Wf_Core.Context('WF_EVENT_HTML', 'ListQueueMessages',

7222:
7223: exception
7224: when others then
7225: rollback;
7226: Wf_Core.Context('WF_EVENT_HTML', 'ListQueueMessages',
7227: p_queue_name);
7228: wfe_html_util.Error;
7229: --raise;
7230: end ListQueueMessages;

Line 7248: l_message wf_event_t;

7244:
7245: TYPE queue_contents_t IS REF CURSOR;
7246: l_qcontents queue_contents_t;
7247: l_sqlstmt varchar2(32000);
7248: l_message wf_event_t;
7249: l_clob clob;
7250: l_splice_size integer := 100;
7251: l_current_position integer := 1;
7252: l_amount_to_read integer :=0;

Line 7270: wf_events_pkg.setMode;

7266: begin
7267: -- Check current user has admin authority
7268: wfa_sec.GetSession(username);
7269: username := upper(username);
7270: wf_events_pkg.setMode;
7271:
7272: -- Check Admin Priviledge
7273: admin_role := wf_core.translate('WF_ADMIN_ROLE');
7274: if (admin_role = '*' or

Line 7423: Wf_Core.Context('WF_EVENT_HTML', 'EventDataContents',

7419: END IF;
7420: exception
7421: when others then
7422: rollback;
7423: Wf_Core.Context('WF_EVENT_HTML', 'EventDataContents',
7424: p_queue_table,p_message_id);
7425: wfe_html_util.Error;
7426: --raise;
7427: end EventDataContents;

Line 7434: l_event_t wf_event_t;

7430: P_ITEMTYPE in varchar2,
7431: P_ITEMKEY in varchar2,
7432: P_MIME_TYPE in varchar2 default 'text/xml') IS
7433:
7434: l_event_t wf_event_t;
7435: l_eventdata clob;
7436: l_splice_size integer := 100;
7437: l_current_position integer := 1;
7438: l_amount_to_read integer :=0;

Line 7451: wf_event_t.Initialize(l_event_t);

7447: l_doclength integer :=0;
7448:
7449: begin
7450:
7451: wf_event_t.Initialize(l_event_t);
7452:
7453: l_event_t := wf_engine.GetItemAttrEvent(
7454: itemtype => P_ItemType,
7455: itemkey => P_ItemKey,

Line 7569: host:port/pls//Wf_Event_Html.EditSubscription?

7565: end getFWKEvtSubscriptionUrl;
7566:
7567:
7568: /**Gets old Event Subscription URL's of the form
7569: host:port/pls//Wf_Event_Html.EditSubscription?
7570: and converts it to a URL of the form RF.jsp so that the
7571: event subscription page is directly accessed
7572: without the using PL/SQL catridge.Returns following error code
7573: 0 - Success

Line 7593: host:port/pls//Wf_Event_Html.EventDataContents?

7589: end updateToFWKEvtSubscriptionUrl;
7590:
7591:
7592: /**Gets old Event Data URL's of the form
7593: host:port/pls//Wf_Event_Html.EventDataContents?
7594: and converts it to a URL of the form RF.jsp so that the
7595: event data page is directly accessed
7596: without the using PL/SQL catridge.Returns following error code
7597: 0 - Success

Line 7624: end WF_EVENT_HTML;

7620: end if;
7621: end updateToFWKEvtDataUrl;
7622:
7623:
7624: end WF_EVENT_HTML;
7625: