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

Line 375: ** of the wf_roles view and attempts to get the information from there.

371:
372: /*
373: ** First try to get the role information from the new
374: ** wfa_sec.get_role_info function. This function looks at each component
375: ** of the wf_roles view and attempts to get the information from there.
376: ** If it does not find the role then use the old method of looking at the
377: ** view.
378: */
379:

Line 537: from WF_ROLES R

533: to_date(NULL),
534: to_number(NULL),
535: to_number(NULL)
536: into role_info_tbl(1)
537: from WF_ROLES R
538: where R.NAME = GetRoleInfo2.role
539: and R.PARTITION_ID not in (9,8,7,6,4)
540: and rownum = 1;
541: else

Line 573: from WF_ROLES R

569: to_date(NULL),
570: to_number(NULL),
571: to_number(NULL)
572: into role_info_tbl(1)
573: from WF_ROLES R
574: where R.ORIG_SYSTEM = l_origSystem
575: and R.ORIG_SYSTEM_ID = l_origSystemID
576: and R.NAME = GetRoleInfo2.role
577: and rownum = 1;

Line 849: from wf_roles

845: begin
846: if not l_is_composite then
847: select partition_id, orig_system
848: into GetRolePartitionInfo.partition_id, GetRolePartitionInfo.orig_system
849: from wf_roles
850: where name = GetRolePartitionInfo.role
851: and rownum = 1;
852: else
853: select partition_id, orig_system

Line 855: from wf_roles

851: and rownum = 1;
852: else
853: select partition_id, orig_system
854: into GetRolePartitionInfo.partition_id, GetRolePartitionInfo.orig_system
855: from wf_roles
856: where name = GetRolePartitionInfo.role
857: and orig_system =l_orig_system
858: and orig_system_id = l_orig_system_id
859: and rownum = 1;

Line 1065: from WF_ROLES

1061: into dummy
1062: from SYS.DUAL
1063: where exists
1064: (select null
1065: from WF_ROLES
1066: where name = p_rolename
1067: and status = 'ACTIVE');
1068: else
1069: select 1

Line 1074: from WF_ROLES

1070: into dummy
1071: from SYS.DUAL
1072: where exists
1073: (select null
1074: from WF_ROLES
1075: where orig_system = substr(p_rolename, 1, colon-1)
1076: and orig_system_id = substr(p_rolename, colon+1)
1077: and name = p_rolename
1078: and status = 'ACTIVE');

Line 1143: from wf_roles

1139: cursor c_role is
1140: select name,
1141: substrb(display_name,1,360)
1142: p_display_name
1143: from wf_roles
1144: where orig_system = p_orig_system
1145: and orig_system_id = p_orig_system_id
1146: order by status, start_date;
1147: begin

Line 1177: from wf_roles

1173: colon pls_integer;
1174:
1175: cursor c_role (l_name in varchar2) is
1176: select substrb(display_name,1,360)
1177: from wf_roles
1178: where name = l_name
1179: and PARTITION_ID not in (9,8,7,6,4);
1180:
1181: cursor corig_role (l_name in varchar2, l_origSys in varchar2,

Line 1184: from wf_roles

1180:
1181: cursor corig_role (l_name in varchar2, l_origSys in varchar2,
1182: l_origSysID in number) is
1183: select substrb(display_name,1,360)
1184: from wf_roles
1185: where orig_system = l_origSys
1186: and orig_system_id = l_origSysID
1187: and name = l_name;
1188:

Line 1189: l_display_name wf_roles.display_name%TYPE;

1185: where orig_system = l_origSys
1186: and orig_system_id = l_origSysID
1187: and name = l_name;
1188:
1189: l_display_name wf_roles.display_name%TYPE;
1190: invalidNumConv EXCEPTION;
1191: pragma exception_init(invalidNumConv, -6502);
1192: begin
1193: begin

Line 2191: -- Check if role name exists in wf_roles

2187: d1 pls_integer;
2188:
2189: begin
2190: --
2191: -- Check if role name exists in wf_roles
2192: --
2193: if (role_name is not null and role_display_name is not null) then
2194: /* GK: The display name does not have to be unique
2195:

Line 2197: from wf_roles

2193: if (role_name is not null and role_display_name is not null) then
2194: /* GK: The display name does not have to be unique
2195:
2196: select count(1) into d1
2197: from wf_roles
2198: where name = CreateAdHocRole.role_name
2199: or display_name = CreateAdHocRole.role_display_name;
2200: if (d1 > 0) then
2201: wf_core.token('ROLENAME', CreateAdHocRole.role_name);

Line 4683: -- User attributes as in WF_ROLES view

4679: --
4680: -- IN
4681: -- email address
4682: -- OUT
4683: -- User attributes as in WF_ROLES view
4684: --
4685: -- This API queries wf_roles view for information of the user when
4686: -- the e-mail address is given.
4687: procedure GetInfoFromMail(mailid in varchar2,

Line 4685: -- This API queries wf_roles view for information of the user when

4681: -- email address
4682: -- OUT
4683: -- User attributes as in WF_ROLES view
4684: --
4685: -- This API queries wf_roles view for information of the user when
4686: -- the e-mail address is given.
4687: procedure GetInfoFromMail(mailid in varchar2,
4688: role out NOCOPY varchar2,
4689: display_name out NOCOPY varchar2,

Line 4752: from WF_ROLES R

4748: R.ORIG_SYSTEM,
4749: R.ORIG_SYSTEM_ID,
4750: decode (R.STATUS, 'ACTIVE', 1, 2) ACTIVE_ORDER,
4751: decode (R.ORIG_SYSTEM, 'PER', 1, 'FND_USR', 2, 3) ORIG_SYS_ORDER
4752: from WF_ROLES R
4753: where UPPER(R.EMAIL_ADDRESS) = UPPER(l_email)
4754: order by ACTIVE_ORDER asc, ORIG_SYS_ORDER asc, START_DATE asc) WR
4755: where ROWNUM < 2;
4756: exception

Line 4969: where exists (select null from wf_roles

4965: --check whether the role name is truly end dated
4966:
4967: select 1 into l_count
4968: from SYS.DUAL
4969: where exists (select null from wf_roles
4970: where name=p_name
4971: );
4972:
4973: --if we have reached here, it implies that the user or role