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_LOCAL_USER_ROLES

Line 2471: insert into WF_LOCAL_USER_ROLES

2467: l_lastupdlog:= nvl(CreateUserRole.last_update_login, WFA_SEC.LOGIN_ID);
2468:
2469: -- Insert
2470: begin
2471: insert into WF_LOCAL_USER_ROLES
2472: ( USER_NAME,
2473: ROLE_NAME,
2474: USER_ORIG_SYSTEM,
2475: USER_ORIG_SYSTEM_ID,

Line 2784: update WF_LOCAL_USER_ROLES

2780: l_lastupddt := nvl(setuserroleattr.last_update_date, SYSDATE);
2781: l_lastupdlog:= nvl(setuserroleattr.last_update_login, WFA_SEC.LOGIN_ID);
2782:
2783: if (OverWrite and l_updateWho) then
2784: update WF_LOCAL_USER_ROLES
2785: set EXPIRATION_DATE = SetUserRoleAttr.end_date,
2786: START_DATE = SetUserRoleAttr.start_date,
2787: LAST_UPDATED_BY = l_lastupdby,
2788: LAST_UPDATE_DATE = l_lastupddt,

Line 2807: update WF_LOCAL_USER_ROLES

2803: and PARTITION_ID = l_partitionID
2804: returning rowid into l_affectedRow;
2805:
2806: elsif (OverWrite) then --donot Update WHO Columns
2807: update WF_LOCAL_USER_ROLES
2808: set EXPIRATION_DATE = SetUserRoleAttr.end_date,
2809: START_DATE = SetUserRoleAttr.start_date,
2810: PARENT_ORIG_SYSTEM = l_porigSys,
2811: PARENT_ORIG_SYSTEM_ID = l_porigSysID,

Line 2823: update WF_LOCAL_USER_ROLES

2819: and PARTITION_ID = l_partitionID
2820: returning rowid into l_affectedRow;
2821:
2822: elsif (l_updateWho) then -- Update WHO columns
2823: update WF_LOCAL_USER_ROLES
2824: set EXPIRATION_DATE = nvl(SetUserRoleAttr.end_date, EXPIRATION_DATE),
2825: START_DATE = nvl(SetUserRoleAttr.start_date, START_DATE),
2826: PARENT_ORIG_SYSTEM = nvl(SetUserRoleAttr.parent_orig_system,
2827: l_porigSys),

Line 2852: update WF_LOCAL_USER_ROLES

2848: returning rowid into l_affectedRow;
2849:
2850:
2851: else --Donot Update Who columns
2852: update WF_LOCAL_USER_ROLES
2853: set EXPIRATION_DATE = nvl(SetUserRoleAttr.end_date, EXPIRATION_DATE),
2854: START_DATE = nvl(SetUserRoleAttr.start_date, START_DATE),
2855: PARENT_ORIG_SYSTEM = nvl(SetUserRoleAttr.parent_orig_system,
2856: l_porigSys),

Line 3049: update WF_LOCAL_USER_ROLES

3045: AssignPartition( RemoveUserRole.role_orig_system,l_partitionId,l_partitionName);
3046:
3047: if (user_orig_system is null or user_orig_system_id is null) then
3048: -- Expire user
3049: update WF_LOCAL_USER_ROLES
3050: set EXPIRATION_DATE = l_expdate,
3051: EFFECTIVE_END_DATE = l_expdate,
3052: LAST_UPDATED_BY = l_lastupdby,
3053: LAST_UPDATE_LOGIN = l_lastupdlog,

Line 3075: update WF_LOCAL_USER_ROLES

3071:
3072: else
3073:
3074: -- Expire user with orig system and orig system id
3075: update WF_LOCAL_USER_ROLES
3076: set EXPIRATION_DATE = l_expdate,
3077: EFFECTIVE_END_DATE = l_expdate,
3078: LAST_UPDATED_BY = l_lastupdby,
3079: LAST_UPDATE_LOGIN = l_lastupdlog,

Line 3227: -- from WF_LOCAL_USER_ROLES

3223:
3224: --
3225: -- Commenting out this check and catching a dup user/role exception
3226: -- select count(1) into d1
3227: -- from WF_LOCAL_USER_ROLES
3228: -- where USER_NAME = role_users(userIND)
3229: -- and ROLE_NAME = AddUsersToAdHocRole2.role_name
3230: -- and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
3231: -- and ROLE_ORIG_SYSTEM_ID = 0;

Line 4356: delete from WF_LOCAL_USER_ROLES UR

4352: begin
4353: if (role_users is null) then
4354: -- Delete all users
4355: begin
4356: delete from WF_LOCAL_USER_ROLES UR
4357: where UR.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4358: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4359: and UR.ROLE_ORIG_SYSTEM_ID = 0
4360: and UR.PARTITION_ID = 0;

Line 4388: delete from WF_LOCAL_USER_ROLES UR

4384: user := substr(rest, 1, c1-1);
4385: end if;
4386:
4387: -- Delete
4388: delete from WF_LOCAL_USER_ROLES UR
4389: where UR.USER_NAME = user
4390: and UR.ROLE_NAME = RemoveUsersFromAdHocRole.role_name
4391: and UR.ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
4392: and UR.ROLE_ORIG_SYSTEM_ID = 0

Line 4537: Update WF_LOCAL_USER_ROLES

4533: And ROLE_ORIG_SYSTEM_ID = p_old_user_origSystemID
4534: And USER_NAME = p_user_name;
4535: end;
4536: begin
4537: Update WF_LOCAL_USER_ROLES
4538: Set USER_ORIG_SYSTEM = p_new_user_origSystem,
4539: USER_ORIG_SYSTEM_ID = p_new_user_origSystemID,
4540: ROLE_ORIG_SYSTEM = p_new_user_origSystem,
4541: ROLE_ORIG_SYSTEM_ID = p_new_user_origSystemID,

Line 4555: Delete from WF_LOCAL_USER_ROLES

4551: And USER_NAME = p_user_name;
4552: exception
4553: when DUP_VAL_ON_INDEX then
4554: --This is an old reference that can be deleted
4555: Delete from WF_LOCAL_USER_ROLES
4556: Where USER_ORIG_SYSTEM = p_old_user_origSystem
4557: And USER_ORIG_SYSTEM_ID = p_old_user_origSystemID
4558: And ROLE_ORIG_SYSTEM = p_old_user_origSystem
4559: And ROLE_ORIG_SYSTEM_ID = p_old_user_origSystemID

Line 4565: Update WF_LOCAL_USER_ROLES

4561: end;
4562:
4563: --Now update all other role references (self-reference is already updated so
4564: --it will not be effected by these updates)
4565: Update WF_LOCAL_USER_ROLES
4566: Set USER_ORIG_SYSTEM = p_new_user_origSystem,
4567: USER_ORIG_SYSTEM_ID = p_new_user_origSystemID,
4568: -- <6817561>
4569: LAST_UPDATE_DATE = decode(l_overWriteUserRoles,'Y', nvl(p_last_update_date, LAST_UPDATE_DATE), LAST_UPDATE_DATE),

Line 4920: UPDATE WF_LOCAL_USER_ROLES

4916: l_newName := p_event.getValueForParameter('USER_NAME');
4917: l_oldName := p_event.getValueForParameter('OLD_USER_NAME');
4918:
4919: /* --Update the user/roles
4920: UPDATE WF_LOCAL_USER_ROLES
4921: SET USER_NAME = l_newName
4922: WHERE USER_NAME = l_oldName;
4923:
4924: --Update the user/role assignments

Line 5120: delete from wf_local_user_roles

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
5122: and role_orig_system=p_roleorigSystem
5123: and role_orig_system_id=p_roleorigSystemID
5124: and partition_id = l_partitionID;

Line 5163: delete from wf_local_user_roles

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
5165: and user_orig_system=p_userorigSystem
5166: and user_orig_system_id=p_userorigSystemID;
5167:

Line 5216: delete from wf_local_user_roles

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
5217: where role_name=p_rolename
5218: and user_name=p_username
5219: and role_orig_system=p_roleorigSystem
5220: and role_orig_system_id=p_roleorigSystemID