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 2760: from WF_USER_ROLE_ASSIGNMENTS

2756: -- Bug 8680963 / 9323176
2757: select START_DATE, END_DATE
2758: into l_oldStartDate, l_oldEndDate
2759: from (select START_DATE, END_DATE
2760: from WF_USER_ROLE_ASSIGNMENTS
2761: where USER_NAME = SetUserRoleAttr.user_name
2762: and ROLE_NAME = SetUserRoleAttr.role_name
2763: and USER_ORIG_SYSTEM = l_uorigSys
2764: and USER_ORIG_SYSTEM_ID = l_uorigSysID

Line 3061: update WF_USER_ROLE_ASSIGNMENTS

3057: and ROLE_ORIG_SYSTEM = RemoveUserRole.role_orig_system
3058: and ROLE_ORIG_SYSTEM_ID = RemoveUserRole.role_orig_system_id
3059: and PARTITION_ID = l_partitionID;
3060:
3061: update WF_USER_ROLE_ASSIGNMENTS
3062: set END_DATE = l_expdate,
3063: EFFECTIVE_END_DATE = l_expdate,
3064: LAST_UPDATED_BY = l_lastupdby,
3065: LAST_UPDATE_LOGIN = l_lastupdlog,

Line 3089: update WF_USER_ROLE_ASSIGNMENTS

3085: and ROLE_ORIG_SYSTEM = RemoveUserRole.role_orig_system
3086: and ROLE_ORIG_SYSTEM_ID = RemoveUserRole.role_orig_system_id
3087: and PARTITION_ID = l_partitionID;
3088:
3089: update WF_USER_ROLE_ASSIGNMENTS
3090: set END_DATE = l_expdate,
3091: EFFECTIVE_END_DATE = l_expdate,
3092: LAST_UPDATED_BY = l_lastupdby,
3093: LAST_UPDATE_LOGIN = l_lastupdlog,

Line 4362: --delete from WF_USER_ROLE_ASSIGNMENTS as well

4358: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4359: and UR.ROLE_ORIG_SYSTEM_ID = 0
4360: and UR.PARTITION_ID = 0;
4361:
4362: --delete from WF_USER_ROLE_ASSIGNMENTS as well
4363: delete from WF_USER_ROLE_ASSIGNMENTS URA
4364: where URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4365: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4366: and URA.ROLE_ORIG_SYSTEM_ID = 0

Line 4363: delete from WF_USER_ROLE_ASSIGNMENTS URA

4359: and UR.ROLE_ORIG_SYSTEM_ID = 0
4360: and UR.PARTITION_ID = 0;
4361:
4362: --delete from WF_USER_ROLE_ASSIGNMENTS as well
4363: delete from WF_USER_ROLE_ASSIGNMENTS URA
4364: where URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4365: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4366: and URA.ROLE_ORIG_SYSTEM_ID = 0
4367: and URA.PARTITION_ID = 0;

Line 4399: -- Delete from wf_user_role_Assignments as well

4395: wf_core.token('USERNAME', user);
4396: wf_core.raise('WF_INVALID_USER');
4397: end if;
4398:
4399: -- Delete from wf_user_role_Assignments as well
4400: delete from WF_USER_ROLE_ASSIGNMENTS URA
4401: where URA.USER_NAME = user
4402: and URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4403: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'

Line 4400: delete from WF_USER_ROLE_ASSIGNMENTS URA

4396: wf_core.raise('WF_INVALID_USER');
4397: end if;
4398:
4399: -- Delete from wf_user_role_Assignments as well
4400: delete from WF_USER_ROLE_ASSIGNMENTS URA
4401: where URA.USER_NAME = user
4402: and URA.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4403: and URA.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4404: and URA.ROLE_ORIG_SYSTEM_ID = 0

Line 4511: Update WF_USER_ROLE_ASSIGNMENTS

4507: l_overWriteUserRoles := 'Y';
4508: end if; --
4509: --First Update the user self-reference.
4510: begin
4511: Update WF_USER_ROLE_ASSIGNMENTS
4512: Set USER_ORIG_SYSTEM = p_new_user_origSystem,
4513: USER_ORIG_SYSTEM_ID = p_new_user_origSystemID,
4514: ROLE_ORIG_SYSTEM = p_new_user_origSystem,
4515: ROLE_ORIG_SYSTEM_ID = p_new_user_origSystemID,

Line 4529: Delete from WF_USER_ROLE_ASSIGNMENTS

4525: And USER_NAME = p_user_name;
4526: exception
4527: when DUP_VAL_ON_INDEX then
4528: --This is an old reference that can be deleted
4529: Delete from WF_USER_ROLE_ASSIGNMENTS
4530: Where USER_ORIG_SYSTEM = p_old_user_origSystem
4531: And USER_ORIG_SYSTEM_ID = p_old_user_origSystemID
4532: And ROLE_ORIG_SYSTEM = p_old_user_origSystem
4533: And ROLE_ORIG_SYSTEM_ID = p_old_user_origSystemID

Line 4577: Update WF_USER_ROLE_ASSIGNMENTS

4573: Where USER_ORIG_SYSTEM = p_old_user_origSystem
4574: And USER_ORIG_SYSTEM_ID = p_old_user_origSystemID
4575: And USER_NAME = p_user_name;
4576:
4577: Update WF_USER_ROLE_ASSIGNMENTS
4578: Set USER_ORIG_SYSTEM = p_new_user_origSystem,
4579: USER_ORIG_SYSTEM_ID = p_new_user_origSystemID,
4580: -- <6817561>
4581: LAST_UPDATE_DATE = decode(l_overWriteUserRoles,'Y', nvl(p_last_update_date, LAST_UPDATE_DATE), LAST_UPDATE_DATE),

Line 4925: UPDATE WF_USER_ROLE_ASSIGNMENTS

4921: SET USER_NAME = l_newName
4922: WHERE USER_NAME = l_oldName;
4923:
4924: --Update the user/role assignments
4925: UPDATE WF_USER_ROLE_ASSIGNMENTS
4926: SET USER_NAME = l_newName
4927: WHERE USER_NAME = l_oldName;*/ --these updates are now made inline
4928:
4929: --Call WF_MAINTENANCE to update all the other fk references.

Line 5090: or exists (select null from wf_user_role_assignments_v

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
5092: )
5093: or exists (select null from wf_role_hierarchies
5094: where (super_name=p_rolename

Line 5117: delete from wf_user_role_assignments

5113: exception
5114: when no_data_found then
5115: -- assignment is truly end dated
5116:
5117: delete from wf_user_role_assignments
5118: where role_name=p_rolename;
5119:
5120: delete from wf_local_user_roles
5121: where role_name=p_rolename

Line 5138: or exists (select null from wf_user_role_assignments_v

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
5140: ));
5141:
5142: --if we have reached here, it implies that the user

Line 5160: delete from wf_user_role_assignments

5156: exception
5157: when no_data_found then
5158: -- assignment is truly end dated
5159:
5160: delete from wf_user_role_assignments
5161: where user_name=p_username;
5162:
5163: delete from wf_local_user_roles
5164: where user_name=p_username

Line 5183: or exists (select null from wf_user_role_assignments_v

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
5184: where role_name=p_rolename
5185: and user_name=p_username
5186: )
5187: or exists (select null from wf_role_hierarchies

Line 5212: delete from wf_user_role_assignments

5208: exception
5209: when no_data_found then
5210: -- assignment is truly end dated
5211:
5212: delete from wf_user_role_assignments
5213: where role_name=p_rolename
5214: and user_name=p_username;
5215:
5216: delete from wf_local_user_roles