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_VL

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