APPS.ENG_WORKFLOW_UTIL dependencies on WF_LOCAL_ROLES

Line 658: from WF_LOCAL_ROLES

654: IS
655: SELECT 'Role Exists'
656: FROM DUAL
657: WHERE EXISTS ( SELECT null
658: from WF_LOCAL_ROLES
659: WHERE NAME = p_role_name
660: AND ORIG_SYSTEM = 'WF_LOCAL_ROLES'
661: AND ORIG_SYSTEM_ID = 0
662: ) ;

Line 660: AND ORIG_SYSTEM = 'WF_LOCAL_ROLES'

656: FROM DUAL
657: WHERE EXISTS ( SELECT null
658: from WF_LOCAL_ROLES
659: WHERE NAME = p_role_name
660: AND ORIG_SYSTEM = 'WF_LOCAL_ROLES'
661: AND ORIG_SYSTEM_ID = 0
662: ) ;
663:
664: l_existence BOOLEAN := FALSE ;

Line 716: -- DELETE FROM wf_local_roles

712: -- Instead of this, Set Adhoc Role Expiration
713: -- using WF API. Then once user run WF Purge progam
714: -- deleting these role and user roles is taken care of.
715:
716: -- DELETE FROM wf_local_roles
717: -- WHERE name = p_role_name ;
718:
719: -- DELETE FROM wf_local_user_roles
720: -- WHERE role_name = p_role_name ;