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_LOV dependencies on WF_ROLES

Line 1361: type NameList is table of wf_roles.name%type;

1357: l_from varchar2(10);
1358: l_to varchar2(10);
1359: username varchar2(320);
1360:
1361: type NameList is table of wf_roles.name%type;
1362: type DNameList is table of wf_roles.display_name%type;
1363:
1364: names NameList;
1365: dnames DNameList;

Line 1362: type DNameList is table of wf_roles.display_name%type;

1358: l_to varchar2(10);
1359: username varchar2(320);
1360:
1361: type NameList is table of wf_roles.name%type;
1362: type DNameList is table of wf_roles.display_name%type;
1363:
1364: names NameList;
1365: dnames DNameList;
1366:

Line 1377: from WF_ROLES

1373: criteria4 varchar2(12);
1374:
1375: CURSOR c_user_lov (c_find_criteria IN VARCHAR2) IS
1376: select NAME, DISPLAY_NAME
1377: from WF_ROLES
1378: where (DISPLAY_NAME like criteria1
1379: or DISPLAY_NAME like criteria2
1380: or DISPLAY_NAME like criteria3
1381: or DISPLAY_NAME like criteria4)

Line 1386: from WF_ROLES

1382: and upper(DISPLAY_NAME) like upper(c_find_criteria)||'%'
1383: and status <> 'INACTIVE'
1384: union
1385: select NAME, DISPLAY_NAME
1386: from WF_ROLES
1387: where ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
1388: 'HZ_GROUP','CUST_CONT')
1389: and upper(NAME) like upper(c_find_criteria)||'%'
1390: and (NAME like criteria1