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 822: from WF_USER_ROLES UR

818: into dummy
819: from SYS.DUAL
820: where exists
821: (select null
822: from WF_USER_ROLES UR
823: where UR.USER_NAME = IsPerformer.user
824: and UR.USER_ORIG_SYSTEM not in ('HZ_PARTY')
825: and UR.ROLE_NAME = IsPerformer.role
826: and UR.PARTITION_ID not in (9,8,7,6,4)

Line 834: from WF_USER_ROLES UR

830: into dummy
831: from SYS.DUAL
832: where exists
833: (select null
834: from WF_USER_ROLES UR
835: where UR.USER_ORIG_SYSTEM = l_uOrigSys
836: and UR.USER_ORIG_SYSTEM_ID = l_uOrigSysID
837: and UR.USER_NAME = IsPerformer.user
838: and UR.ROLE_NAME = IsPerformer.role

Line 850: from WF_USER_ROLES UR

846: into dummy
847: from SYS.DUAL
848: where exists
849: (select null
850: from WF_USER_ROLES UR
851: where UR.USER_NAME = IsPerformer.user
852: and UR.USER_ORIG_SYSTEM not in ('HZ_PARTY')
853: and UR.ROLE_NAME = IsPerformer.role
854: and UR.ROLE_ORIG_SYSTEM = l_rorigSys

Line 863: from WF_USER_ROLES UR

859: into dummy
860: from SYS.DUAL
861: where exists
862: (select null
863: from WF_USER_ROLES UR
864: where UR.USER_ORIG_SYSTEM = l_uOrigSys
865: and UR.USER_ORIG_SYSTEM_ID = l_rOrigSysID
866: and UR.USER_NAME = IsPerformer.user
867: and UR.ROLE_ORIG_SYSTEM = l_rOrigSys

Line 4950: and ( exists (select null from wf_user_roles

4946: select 1 into l_count
4947: from SYS.DUAL
4948: where exists (select null from wf_local_roles
4949: where name=p_rolename)
4950: and ( exists (select null from wf_user_roles
4951: where role_name=p_rolename
4952: )
4953: or exists (select null from wf_user_role_assignments_v
4954: where role_name=p_rolename

Line 4998: and ( exists (select null from wf_user_roles

4994: select 1 into l_count
4995: from SYS.DUAL
4996: where exists (select null from wf_local_roles
4997: where name=p_username)
4998: and ( exists (select null from wf_user_roles
4999: where user_name=p_username
5000: )
5001: or exists (select null from wf_user_role_assignments_v
5002: where user_name=p_username

Line 5042: and ( exists (select null from wf_user_roles

5038: select 1 into l_count
5039: from SYS.DUAL
5040: where exists (select null from wf_local_roles
5041: where name=p_rolename or name=p_username)
5042: and ( exists (select null from wf_user_roles
5043: where role_name=p_rolename
5044: and user_name=p_username
5045: )
5046: or exists (select null from wf_user_role_assignments_v