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_EVENT_HTML dependencies on WF_EVENTS

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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