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_USER_ROLE_ASSIGNMENTS

Line 2913: update WF_USER_ROLE_ASSIGNMENTS

2909: and ROLE_ORIG_SYSTEM = RemoveUserRole.role_orig_system
2910: and ROLE_ORIG_SYSTEM_ID = RemoveUserRole.role_orig_system_id
2911: and PARTITION_ID = l_partitionID;
2912:
2913: update WF_USER_ROLE_ASSIGNMENTS
2914: set END_DATE = l_expdate,
2915: EFFECTIVE_END_DATE = l_expdate,
2916: LAST_UPDATED_BY = l_lastupdby,
2917: LAST_UPDATE_LOGIN = l_lastupdlog,

Line 2941: update WF_USER_ROLE_ASSIGNMENTS

2937: and ROLE_ORIG_SYSTEM = RemoveUserRole.role_orig_system
2938: and ROLE_ORIG_SYSTEM_ID = RemoveUserRole.role_orig_system_id
2939: and PARTITION_ID = l_partitionID;
2940:
2941: update WF_USER_ROLE_ASSIGNMENTS
2942: set END_DATE = l_expdate,
2943: EFFECTIVE_END_DATE = l_expdate,
2944: LAST_UPDATED_BY = l_lastupdby,
2945: LAST_UPDATE_LOGIN = l_lastupdlog,

Line 4214: --delete from WF_USER_ROLE_ASSIGNMENTS as well

4210: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4211: and UR.ROLE_ORIG_SYSTEM_ID = 0
4212: and UR.PARTITION_ID = 0;
4213:
4214: --delete from WF_USER_ROLE_ASSIGNMENTS as well
4215: delete from WF_USER_ROLE_ASSIGNMENTS URA
4216: where URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4217: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4218: and URA.ROLE_ORIG_SYSTEM_ID = 0

Line 4215: delete from WF_USER_ROLE_ASSIGNMENTS URA

4211: and UR.ROLE_ORIG_SYSTEM_ID = 0
4212: and UR.PARTITION_ID = 0;
4213:
4214: --delete from WF_USER_ROLE_ASSIGNMENTS as well
4215: delete from WF_USER_ROLE_ASSIGNMENTS URA
4216: where URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4217: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4218: and URA.ROLE_ORIG_SYSTEM_ID = 0
4219: and URA.PARTITION_ID = 0;

Line 4251: -- Delete from wf_user_role_Assignments as well

4247: wf_core.token('USERNAME', user);
4248: wf_core.raise('WF_INVALID_USER');
4249: end if;
4250:
4251: -- Delete from wf_user_role_Assignments as well
4252: delete from WF_USER_ROLE_ASSIGNMENTS URA
4253: where URA.USER_NAME = user
4254: and URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4255: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

Line 4252: delete from WF_USER_ROLE_ASSIGNMENTS URA

4248: wf_core.raise('WF_INVALID_USER');
4249: end if;
4250:
4251: -- Delete from wf_user_role_Assignments as well
4252: delete from WF_USER_ROLE_ASSIGNMENTS URA
4253: where URA.USER_NAME = user
4254: and URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4255: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4256: and URA.ROLE_ORIG_SYSTEM_ID = 0

Line 4380: Update WF_USER_ROLE_ASSIGNMENTS

4376: And ROLE_ORIG_SYSTEM = p_old_user_origSystem
4377: And ROLE_ORIG_SYSTEM_ID = p_old_user_origSystemID
4378: And USER_NAME = p_user_name;
4379:
4380: Update WF_USER_ROLE_ASSIGNMENTS
4381: Set USER_ORIG_SYSTEM = p_new_user_origSystem,
4382: USER_ORIG_SYSTEM_ID = p_new_user_origSystemID,
4383: ROLE_ORIG_SYSTEM = p_new_user_origSystem,
4384: ROLE_ORIG_SYSTEM_ID = p_new_user_origSystemID,

Line 4405: Delete from WF_USER_ROLE_ASSIGNMENTS

4401: And ROLE_ORIG_SYSTEM = p_old_user_origSystem
4402: And ROLE_ORIG_SYSTEM_ID = p_old_user_origSystemID
4403: And USER_NAME = p_user_name;
4404:
4405: Delete from WF_USER_ROLE_ASSIGNMENTS
4406: Where USER_ORIG_SYSTEM = p_old_user_origSystem
4407: And USER_ORIG_SYSTEM_ID = p_old_user_origSystemID
4408: And ROLE_ORIG_SYSTEM = p_old_user_origSystem
4409: And ROLE_ORIG_SYSTEM_ID = p_old_user_origSystemID

Line 4427: Update WF_USER_ROLE_ASSIGNMENTS

4423: Where USER_ORIG_SYSTEM = p_old_user_origSystem
4424: And USER_ORIG_SYSTEM_ID = p_old_user_origSystemID
4425: And USER_NAME = p_user_name;
4426:
4427: Update WF_USER_ROLE_ASSIGNMENTS
4428: Set USER_ORIG_SYSTEM = p_new_user_origSystem,
4429: USER_ORIG_SYSTEM_ID = p_new_user_origSystemID,
4430: -- <6817561>
4431: LAST_UPDATE_DATE = decode(l_overWriteUserRoles,'Y', nvl(p_last_update_date, LAST_UPDATE_DATE), LAST_UPDATE_DATE),

Line 4788: UPDATE WF_USER_ROLE_ASSIGNMENTS

4784: SET USER_NAME = l_newName
4785: WHERE USER_NAME = l_oldName;
4786:
4787: --Update the user/role assignments
4788: UPDATE WF_USER_ROLE_ASSIGNMENTS
4789: SET USER_NAME = l_newName
4790: WHERE USER_NAME = l_oldName;*/ --these updates are now made inline
4791:
4792: --Call WF_MAINTENANCE to update all the other fk references.

Line 4953: or exists (select null from wf_user_role_assignments_v

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
4955: )
4956: or exists (select null from wf_role_hierarchies
4957: where (super_name=p_rolename

Line 4980: delete from wf_user_role_assignments

4976: exception
4977: when no_data_found then
4978: -- assignment is truly end dated
4979:
4980: delete from wf_user_role_assignments
4981: where role_name=p_rolename;
4982:
4983: delete from wf_local_user_roles
4984: where role_name=p_rolename

Line 5001: or exists (select null from wf_user_role_assignments_v

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
5003: ));
5004:
5005: --if we have reached here, it implies that the user

Line 5023: delete from wf_user_role_assignments

5019: exception
5020: when no_data_found then
5021: -- assignment is truly end dated
5022:
5023: delete from wf_user_role_assignments
5024: where user_name=p_username;
5025:
5026: delete from wf_local_user_roles
5027: where user_name=p_username

Line 5046: or exists (select null from wf_user_role_assignments_v

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
5047: where role_name=p_rolename
5048: and user_name=p_username
5049: )
5050: or exists (select null from wf_role_hierarchies

Line 5075: delete from wf_user_role_assignments

5071: exception
5072: when no_data_found then
5073: -- assignment is truly end dated
5074:
5075: delete from wf_user_role_assignments
5076: where role_name=p_rolename
5077: and user_name=p_username;
5078:
5079: delete from wf_local_user_roles