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_LOCAL_SYNCH dependencies on WF_USER_ROLE_ASSIGNMENTS

Line 457: if (l_tables(i) = 'WF_USER_ROLE_ASSIGNMENTS') then

453:
454: if (l_owners.COUNT > 0) then
455: for i in l_owners.FIRST..l_owners.LAST loop
456: for a in stageIndParts(l_owners(i), l_indexes(i)) loop
457: if (l_tables(i) = 'WF_USER_ROLE_ASSIGNMENTS') then
458: l_newindex := l_owners(i)||'.'||REPLACE(l_indexes(i),
459: 'USER_ROLE_ASSIGNMENTS',
460: 'UR_ASSIGNMENTS_STAGE');
461: else

Line 1016: UPDATE WF_USER_ROLE_ASSIGNMENTS

1012: WHERE USER_NAME = g_oldName;
1013:
1014: --Update the user/role assignments
1015:
1016: UPDATE WF_USER_ROLE_ASSIGNMENTS
1017: SET USER_NAME=g_name,
1018: ROLE_NAME=g_name,
1019: ASSIGNING_ROLE=g_name
1020: -- <6817561>

Line 1032: UPDATE WF_USER_ROLE_ASSIGNMENTS

1028: AND USER_NAME=g_oldName
1029: AND RELATIONSHIP_ID=-1
1030: AND PARTITION_ID=l_partitionId;
1031:
1032: UPDATE WF_USER_ROLE_ASSIGNMENTS
1033: SET USER_NAME = g_Name
1034: -- <6817561>
1035: , LAST_UPDATE_DATE = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
1036: LAST_UPDATED_BY = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

Line 1233: update wf_user_role_assignments

1229: where user_name = g_name
1230: and user_orig_system=g_origSystem
1231: and user_orig_system_id= g_origSystemID;
1232:
1233: update wf_user_role_assignments
1234: set last_update_date = nvl(g_lastUpdateDate,last_update_date),
1235: last_updated_by = nvl(g_lastUpdatedBy, last_updated_by),
1236: last_update_login = nvl(g_lastUpdateLogin, last_update_login)
1237: where user_name = g_name

Line 1436: update wf_user_role_assignments

1432: where user_name = g_name
1433: and user_orig_system=g_origSystem
1434: and user_orig_system_id= g_origSystemID;
1435:
1436: update wf_user_role_assignments
1437: set last_update_date = nvl(g_lastUpdateDate,last_update_date),
1438: last_updated_by = nvl(g_lastUpdatedBy, last_updated_by),
1439: last_update_login = nvl(g_lastUpdateLogin, last_update_login)
1440: where user_name = g_name

Line 1624: UPDATE WF_USER_ROLE_ASSIGNMENTS

1620: AND ROLE_ORIG_SYSTEM = p_orig_system
1621: AND ROLE_ORIG_SYSTEM_ID = p_orig_system_id
1622: AND PARTITION_ID = l_partitionID;
1623:
1624: UPDATE WF_USER_ROLE_ASSIGNMENTS
1625: SET ASSIGNING_ROLE = g_name
1626: -- <6817561>
1627: , LAST_UPDATE_DATE = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
1628: LAST_UPDATED_BY = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

Line 1648: UPDATE WF_USER_ROLE_ASSIGNMENTS

1644: WHERE SUPER_NAME = g_oldName
1645: AND SUPERIOR_PARTITION_ID = l_partitionID;
1646:
1647: --These statements cannot take advantage of the partitions.
1648: UPDATE WF_USER_ROLE_ASSIGNMENTS
1649: SET ROLE_NAME = g_name
1650: WHERE ROLE_NAME = g_oldName;
1651:
1652: WF_MAINTENANCE.PropagateChangedName(OLDNAME=>g_oldName, NEWNAME=>g_name);

Line 1668: UPDATE WF_USER_ROLE_ASSIGNMENTS

1664: AND ROLE_ORIG_SYSTEM = p_orig_system
1665: AND ROLE_ORIG_SYSTEM_ID = p_orig_system_id
1666: AND PARTITION_ID = l_partitionID;
1667:
1668: UPDATE WF_USER_ROLE_ASSIGNMENTS
1669: SET
1670: LAST_UPDATE_DATE = nvl(g_lastUpdateDate, LAST_UPDATE_DATE),
1671: LAST_UPDATED_BY = nvl(g_lastUpdatedBy, LAST_UPDATED_BY),
1672: LAST_UPDATE_LOGIN = nvl(g_lastUpdateLogin, LAST_UPDATE_LOGIN)

Line 2545: Create_Stage_Indexes (p_sourceTable=>'WF_USER_ROLE_ASSIGNMENTS',

2541: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2542: TABNAME=>'WF_UR_ASSIGNMENTS_STAGE',
2543: PERCENT=>10);
2544:
2545: Create_Stage_Indexes (p_sourceTable=>'WF_USER_ROLE_ASSIGNMENTS',
2546: p_targetTable=>'WF_UR_ASSIGNMENTS_STAGE');
2547:
2548: --Get in line to lock the table for partition exchange.
2549: --BINDVAR_SCAN_IGNORE[1]

Line 2567: execute IMMEDIATE 'lock table '||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS '||

2563: commit;
2564:
2565: --Get in line to lock the table for partition exchange.
2566: --BINDVAR_SCAN_IGNORE[1]
2567: execute IMMEDIATE 'lock table '||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS '||
2568: 'in exclusive mode';
2569: --Partition exchange the temp table into the wf_user_role_assignments table.
2570: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS ' ||
2571: 'EXCHANGE PARTITION ' || l_partitionName ||

Line 2569: --Partition exchange the temp table into the wf_user_role_assignments table.

2565: --Get in line to lock the table for partition exchange.
2566: --BINDVAR_SCAN_IGNORE[1]
2567: execute IMMEDIATE 'lock table '||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS '||
2568: 'in exclusive mode';
2569: --Partition exchange the temp table into the wf_user_role_assignments table.
2570: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS ' ||
2571: 'EXCHANGE PARTITION ' || l_partitionName ||
2572: ' WITH TABLE ' ||wf_schema||'.WF_UR_ASSIGNMENTS_STAGE '||
2573: 'INCLUDING INDEXES WITHOUT VALIDATION';

Line 2570: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS ' ||

2566: --BINDVAR_SCAN_IGNORE[1]
2567: execute IMMEDIATE 'lock table '||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS '||
2568: 'in exclusive mode';
2569: --Partition exchange the temp table into the wf_user_role_assignments table.
2570: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS ' ||
2571: 'EXCHANGE PARTITION ' || l_partitionName ||
2572: ' WITH TABLE ' ||wf_schema||'.WF_UR_ASSIGNMENTS_STAGE '||
2573: 'INCLUDING INDEXES WITHOUT VALIDATION';
2574: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,