APPS.WF_DIRECTORY dependencies on WF_USER_ROLES

Line 195: from WF_USER_ROLES UR

191: l_partName VARCHAR2(30);
192:
193: cursor c(c_rolename varchar2) is
194: select UR.USER_NAME
195: from WF_USER_ROLES UR
196: where UR.ROLE_NAME = c_rolename
197: and UR.PARTITION_ID not in (9,8,7,6,4);
198:
199: cursor corig(c_rolename varchar2, c_origSys varchar2,

Line 202: from WF_USER_ROLES UR

198:
199: cursor corig(c_rolename varchar2, c_origSys varchar2,
200: c_origSysID number, c_partID number) is
201: select UR.USER_NAME
202: from WF_USER_ROLES UR
203: where UR.ROLE_ORIG_SYSTEM = c_origSys
204: and UR.ROLE_ORIG_SYSTEM_ID = c_origSysID
205: and UR.ROLE_NAME = c_rolename
206: and UR.PARTITION_ID = c_partID;

Line 274: from WF_USER_ROLES UR

270: l_origSystemID NUMBER;
271:
272: cursor c(c_username varchar2) is
273: select UR.ROLE_NAME
274: from WF_USER_ROLES UR
275: where UR.USER_NAME = c_username
276: and UR.USER_ORIG_SYSTEM not in ('HZ_PARTY','CUST_CONT');
277:
278: cursor corig(c_username varchar2,

Line 282: from WF_USER_ROLES UR

278: cursor corig(c_username varchar2,
279: c_origSystem varchar2,
280: c_origSystemID number) is
281: select UR.ROLE_NAME
282: from WF_USER_ROLES UR
283: where UR.USER_ORIG_SYSTEM = c_origSystem
284: and UR.USER_ORIG_SYSTEM_ID = c_origSystemID
285: and UR.USER_NAME = c_username;
286:

Line 914: from WF_USER_ROLES UR

910: into dummy
911: from SYS.DUAL
912: where exists
913: (select null
914: from WF_USER_ROLES UR
915: where UR.USER_NAME = IsPerformer.user
916: and UR.USER_ORIG_SYSTEM not in ('HZ_PARTY')
917: and UR.ROLE_NAME = IsPerformer.role
918: and UR.PARTITION_ID not in (9,8,7,6,4)

Line 926: from WF_USER_ROLES UR

922: into dummy
923: from SYS.DUAL
924: where exists
925: (select null
926: from WF_USER_ROLES UR
927: where UR.USER_ORIG_SYSTEM = l_uOrigSys
928: and UR.USER_ORIG_SYSTEM_ID = l_uOrigSysID
929: and UR.USER_NAME = IsPerformer.user
930: and UR.ROLE_NAME = IsPerformer.role

Line 942: from WF_USER_ROLES UR

938: into dummy
939: from SYS.DUAL
940: where exists
941: (select null
942: from WF_USER_ROLES UR
943: where UR.USER_NAME = IsPerformer.user
944: and UR.USER_ORIG_SYSTEM not in ('HZ_PARTY')
945: and UR.ROLE_NAME = IsPerformer.role
946: and UR.ROLE_ORIG_SYSTEM = l_rorigSys

Line 955: from WF_USER_ROLES UR

951: into dummy
952: from SYS.DUAL
953: where exists
954: (select null
955: from WF_USER_ROLES UR
956: where UR.USER_ORIG_SYSTEM = l_uOrigSys
957: and UR.USER_ORIG_SYSTEM_ID = l_rOrigSysID
958: and UR.USER_NAME = IsPerformer.user
959: and UR.ROLE_ORIG_SYSTEM = l_rOrigSys

Line 5087: and ( exists (select null from wf_user_roles

5083: select 1 into l_count
5084: from SYS.DUAL
5085: where exists (select null from wf_local_roles
5086: where name=p_rolename)
5087: and ( exists (select null from wf_user_roles
5088: where role_name=p_rolename
5089: )
5090: or exists (select null from wf_user_role_assignments_v
5091: where role_name=p_rolename

Line 5135: and ( exists (select null from wf_user_roles

5131: select 1 into l_count
5132: from SYS.DUAL
5133: where exists (select null from wf_local_roles
5134: where name=p_username)
5135: and ( exists (select null from wf_user_roles
5136: where user_name=p_username
5137: )
5138: or exists (select null from wf_user_role_assignments_v
5139: where user_name=p_username

Line 5179: and ( exists (select null from wf_user_roles

5175: select 1 into l_count
5176: from SYS.DUAL
5177: where exists (select null from wf_local_roles
5178: where name=p_rolename or name=p_username)
5179: and ( exists (select null from wf_user_roles
5180: where role_name=p_rolename
5181: and user_name=p_username
5182: )
5183: or exists (select null from wf_user_role_assignments_v