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_MAINTENANCE dependencies on WF_LOCAL_ROLES

Line 221: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;

217: where WI.ITEM_TYPE = WIAV.ITEM_TYPE
218: and WI.ITEM_KEY = WIAV.ITEM_KEY
219: and WI.END_DATE IS NULL);
220:
221: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
222:
223: cursor cWorklistAccess is
224: select fg.rowid
225: from FND_GRANTS fg

Line 941: from wf_local_roles partition (FND_USR) wu,

937: select wu.rowid, wu.orig_system old_orig_system,
938: wu.orig_system_id old_orig_system_id,
939: decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER') new_orig_system,
940: nvl(fu.employee_id, fu.user_id)
941: from wf_local_roles partition (FND_USR) wu,
942: fnd_user fu
943: where wu.name = fu.user_name
944: and (p_username is null or wu.name = p_username)
945: and (wu.orig_system <> decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER')

Line 960: wf_local_roles partition (FND_USR) wu

956: select wu.orig_system, wu.orig_system_id,
957: wur.role_orig_system, wur.role_orig_system_id,
958: wur.partition_id, wur.rowid
959: from wf_local_user_roles wur,
960: wf_local_roles partition (FND_USR) wu
961: where (p_username is null or wu.name = p_username )
962: and wu.name = wur.user_name
963: and wur.user_orig_system in ('FND_USR','PER')
964: and (wur.user_orig_system <> wu.orig_system

Line 977: --fnd_usr/per records in wf_local_roles are validated. The dates will be

973:
974:
975: --We will correct the orig_system, orig_system_id information for any
976: --incorrect fnd_usr/per user/role records. This is processed after the
977: --fnd_usr/per records in wf_local_roles are validated. The dates will be
978: --resolved in when c_userRoleAssignments are resolved.
979: -- For bug 6752821: no need to consider rolename as this check is for self-reference
980:
981: cursor c_userSelfReference (p_username varchar2) is

Line 985: wf_local_roles partition (FND_USR) wu,

981: cursor c_userSelfReference (p_username varchar2) is
982: select wura.rowid, wur.rowid, wu.start_date, wu.expiration_date,
983: wu.orig_system, wu.orig_system_id
984: from wf_local_user_roles partition (FND_USR) wur,
985: wf_local_roles partition (FND_USR) wu,
986: wf_user_role_assignments partition (FND_USR) wura
987: --Equi-joins to select the proper relationships between the tables
988: where (p_username is null OR wura.user_name = p_username)
989: and wura.partition_id = wu.partition_id

Line 1060: AND ( not exists (select null from wf_local_roles

1056: select rowid
1057: from wf_local_user_roles
1058: where (p_username IS NULL OR user_name= p_username )
1059: AND (p_rolename IS NULL OR role_name = p_rolename)
1060: AND ( not exists (select null from wf_local_roles
1061: WHERE name= user_name
1062: AND (p_username IS NULL OR name= p_username)
1063: )
1064: or not EXISTS (select null from wf_local_roles

Line 1064: or not EXISTS (select null from wf_local_roles

1060: AND ( not exists (select null from wf_local_roles
1061: WHERE name= user_name
1062: AND (p_username IS NULL OR name= p_username)
1063: )
1064: or not EXISTS (select null from wf_local_roles
1065: WHERE NAME = role_name
1066: AND (p_rolename IS NULL OR name= p_rolename)
1067: )
1068: );

Line 1077: -- Either user name or role name NOT in wf_local_roles

1073: select rowid
1074: from wf_user_role_assignments
1075: where (p_username IS NULL OR user_name = p_username )
1076: and (p_rolename IS NULL OR role_name = p_rolename )
1077: -- Either user name or role name NOT in wf_local_roles
1078: and (user_name not in (select name from wf_local_roles
1079: WHERE (p_username is null or name = p_username)
1080: )
1081: -- Check RoleName

Line 1078: and (user_name not in (select name from wf_local_roles

1074: from wf_user_role_assignments
1075: where (p_username IS NULL OR user_name = p_username )
1076: and (p_rolename IS NULL OR role_name = p_rolename )
1077: -- Either user name or role name NOT in wf_local_roles
1078: and (user_name not in (select name from wf_local_roles
1079: WHERE (p_username is null or name = p_username)
1080: )
1081: -- Check RoleName
1082: or role_name not in (select name from wf_local_roles

Line 1082: or role_name not in (select name from wf_local_roles

1078: and (user_name not in (select name from wf_local_roles
1079: WHERE (p_username is null or name = p_username)
1080: )
1081: -- Check RoleName
1082: or role_name not in (select name from wf_local_roles
1083: WHERE (p_rolename IS NULL OR NAME = p_rolename)
1084: )
1085: );
1086:

Line 1246: --Now we will correct any invalid fnd_usr records in WF_LOCAL_ROLES. This

1242: raise;
1243: end;
1244: end if;
1245:
1246: --Now we will correct any invalid fnd_usr records in WF_LOCAL_ROLES. This
1247: --orig_system can have errors because we routinely have to change the
1248: --orig_system, orig_system_id whenever a user is associated or dis-associated
1249: --with an employee.
1250: begin

Line 1264: UPDATE WF_LOCAL_ROLES

1260:
1261: if (l_rowIDTAB.count > 0) then
1262: begin
1263: forall i in l_rowIDTAB.FIRST..l_rowIDTAB.LAST save exceptions
1264: UPDATE WF_LOCAL_ROLES
1265: SET orig_system = l_userOrigDestTAB(i),
1266: orig_system_id = l_userOrigIDDestTAB(i)
1267: WHERE rowid = l_rowIDTAB(i);
1268: exception

Line 1272: delete from wf_local_roles

1268: exception
1269: when others then
1270: for j in 1..sql%bulk_exceptions.count loop
1271: l_eIndex := sql%bulk_exceptions(j).ERROR_INDEX;
1272: delete from wf_local_roles
1273: where rowid = l_rowIDTAB(l_eIndex);
1274: end loop;
1275: end;
1276: commit;

Line 1571: WF_LOCAL_ROLES WAR,

1567: WURA.RELATIONSHIP_ID
1568: FROM
1569: WF_USER_ROLE_ASSIGNMENTS WURA,
1570: WF_LOCAL_USER_ROLES WUR ,
1571: WF_LOCAL_ROLES WAR,
1572: WF_LOCAL_ROLES WU,
1573: WF_LOCAL_ROLES WR
1574: WHERE WURA.PARTITION_ID = WAR.PARTITION_ID
1575: AND WURA.ASSIGNING_ROLE=WAR.NAME

Line 1572: WF_LOCAL_ROLES WU,

1568: FROM
1569: WF_USER_ROLE_ASSIGNMENTS WURA,
1570: WF_LOCAL_USER_ROLES WUR ,
1571: WF_LOCAL_ROLES WAR,
1572: WF_LOCAL_ROLES WU,
1573: WF_LOCAL_ROLES WR
1574: WHERE WURA.PARTITION_ID = WAR.PARTITION_ID
1575: AND WURA.ASSIGNING_ROLE=WAR.NAME
1576: AND WURA.USER_NAME= WUR.USER_NAME

Line 1573: WF_LOCAL_ROLES WR

1569: WF_USER_ROLE_ASSIGNMENTS WURA,
1570: WF_LOCAL_USER_ROLES WUR ,
1571: WF_LOCAL_ROLES WAR,
1572: WF_LOCAL_ROLES WU,
1573: WF_LOCAL_ROLES WR
1574: WHERE WURA.PARTITION_ID = WAR.PARTITION_ID
1575: AND WURA.ASSIGNING_ROLE=WAR.NAME
1576: AND WURA.USER_NAME= WUR.USER_NAME
1577: AND WURA.ROLE_NAME=WUR.ROLE_NAME

Line 1986: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;

1982: */
1983: function GetUsernameChangeCounts(p_name VARCHAR2) RETURN wfcount_tab pipelined is
1984: --l_wfcount_tab wfcount_tab;
1985: l_wfcount_tab wfcount_type;
1986: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
1987: l_partitionID WF_DIRECTORY_PARTITIONS.PARTITION_ID%TYPE;
1988: l_partitionName WF_DIRECTORY_PARTITIONS.ORIG_SYSTEM%TYPE;
1989: l_pvalue varchar2(10) := FND_PROFILE.value('WF_MAINT_COMPLETED_ITEMS');
1990: begin

Line 2220: -- Determine rows to change in WF_LOCAL_ROLES. Can be any role

2216: pipe ROW (l_wfcount_tab);
2217:
2218: -- Now check what happens with the WFDS tables:
2219: WF_DIRECTORY.assignPartition(l_roleInfoTAB(1).ORIG_SYSTEM, l_partitionID, l_partitionName);
2220: -- Determine rows to change in WF_LOCAL_ROLES. Can be any role
2221: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2222: from WF_LOCAL_ROLES
2223: WHERE NAME = p_name
2224: AND PARTITION_ID = l_partitionID

Line 2222: from WF_LOCAL_ROLES

2218: -- Now check what happens with the WFDS tables:
2219: WF_DIRECTORY.assignPartition(l_roleInfoTAB(1).ORIG_SYSTEM, l_partitionID, l_partitionName);
2220: -- Determine rows to change in WF_LOCAL_ROLES. Can be any role
2221: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2222: from WF_LOCAL_ROLES
2223: WHERE NAME = p_name
2224: AND PARTITION_ID = l_partitionID
2225: AND ORIG_SYSTEM = l_roleInfoTAB(1).ORIG_SYSTEM
2226: AND ORIG_SYSTEM_ID = l_roleInfoTAB(1).ORIG_SYSTEM_ID;

Line 2227: l_wfcount_tab.TABLE_NAME := 'WF_LOCAL_ROLES';

2223: WHERE NAME = p_name
2224: AND PARTITION_ID = l_partitionID
2225: AND ORIG_SYSTEM = l_roleInfoTAB(1).ORIG_SYSTEM
2226: AND ORIG_SYSTEM_ID = l_roleInfoTAB(1).ORIG_SYSTEM_ID;
2227: l_wfcount_tab.TABLE_NAME := 'WF_LOCAL_ROLES';
2228: pipe ROW (l_wfcount_tab);
2229:
2230: -- Determine rows to change in WF_LOCAL_USER_ROLES. Can be any role
2231: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT