APPS.WF_LOCAL_SYNCH dependencies on WF_USER_ROLE_ASSIGNMENTS

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

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

Line 1020: UPDATE WF_USER_ROLE_ASSIGNMENTS

1016: WHERE USER_NAME = g_oldName;
1017:
1018: --Update the user/role assignments
1019:
1020: UPDATE WF_USER_ROLE_ASSIGNMENTS
1021: SET USER_NAME=g_name,
1022: ROLE_NAME=g_name,
1023: ASSIGNING_ROLE=g_name
1024: -- <6817561>

Line 1036: UPDATE WF_USER_ROLE_ASSIGNMENTS

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

Line 1241: update wf_user_role_assignments

1237: where user_name = g_name
1238: and user_orig_system=g_origSystem
1239: and user_orig_system_id= g_origSystemID;
1240:
1241: update wf_user_role_assignments
1242: set last_update_date = nvl(g_lastUpdateDate,last_update_date),
1243: last_updated_by = nvl(g_lastUpdatedBy, last_updated_by),
1244: last_update_login = nvl(g_lastUpdateLogin, last_update_login)
1245: where user_name = g_name

Line 1444: update wf_user_role_assignments

1440: where user_name = g_name
1441: and user_orig_system=g_origSystem
1442: and user_orig_system_id= g_origSystemID;
1443:
1444: update wf_user_role_assignments
1445: set last_update_date = nvl(g_lastUpdateDate,last_update_date),
1446: last_updated_by = nvl(g_lastUpdatedBy, last_updated_by),
1447: last_update_login = nvl(g_lastUpdateLogin, last_update_login)
1448: where user_name = g_name

Line 1637: UPDATE WF_USER_ROLE_ASSIGNMENTS

1633: AND ROLE_ORIG_SYSTEM = p_orig_system
1634: AND ROLE_ORIG_SYSTEM_ID = p_orig_system_id
1635: AND PARTITION_ID = l_partitionID;
1636:
1637: UPDATE WF_USER_ROLE_ASSIGNMENTS
1638: SET ASSIGNING_ROLE = g_name
1639: -- <6817561>
1640: , LAST_UPDATE_DATE = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
1641: LAST_UPDATED_BY = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

Line 1661: UPDATE WF_USER_ROLE_ASSIGNMENTS

1657: WHERE SUPER_NAME = g_oldName
1658: AND SUPERIOR_PARTITION_ID = l_partitionID;
1659:
1660: --These statements cannot take advantage of the partitions.
1661: UPDATE WF_USER_ROLE_ASSIGNMENTS
1662: SET ROLE_NAME = g_name
1663: WHERE ROLE_NAME = g_oldName;
1664:
1665: WF_MAINTENANCE.PropagateChangedName(OLDNAME=>g_oldName, NEWNAME=>g_name);

Line 1681: UPDATE WF_USER_ROLE_ASSIGNMENTS

1677: AND ROLE_ORIG_SYSTEM = p_orig_system
1678: AND ROLE_ORIG_SYSTEM_ID = p_orig_system_id
1679: AND PARTITION_ID = l_partitionID;
1680:
1681: UPDATE WF_USER_ROLE_ASSIGNMENTS
1682: SET
1683: LAST_UPDATE_DATE = nvl(g_lastUpdateDate, LAST_UPDATE_DATE),
1684: LAST_UPDATED_BY = nvl(g_lastUpdatedBy, LAST_UPDATED_BY),
1685: LAST_UPDATE_LOGIN = nvl(g_lastUpdateLogin, LAST_UPDATE_LOGIN)

Line 1732: update WF_USER_ROLE_ASSIGNMENTS

1728: and USER_ORIG_SYSTEM = p_orig_system
1729: and ROLE_ORIG_SYSTEM_ID = p_orig_system_id
1730: and ROLE_ORIG_SYSTEM = p_orig_system;
1731:
1732: update WF_USER_ROLE_ASSIGNMENTS
1733: set ROLE_ORIG_SYSTEM_ID = g_employeeID,
1734: USER_ORIG_SYSTEM_ID = g_employeeID,
1735: LAST_UPDATE_DATE = decode(l_overWrite,'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
1736: LAST_UPDATED_BY = decode(l_overWrite,'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

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

2607: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2608: TABNAME=>'WF_UR_ASSIGNMENTS_STAGE',
2609: PERCENT=>10);
2610:
2611: Create_Stage_Indexes (p_sourceTable=>'WF_USER_ROLE_ASSIGNMENTS',
2612: p_targetTable=>'WF_UR_ASSIGNMENTS_STAGE');
2613:
2614: --Get in line to lock the table for partition exchange.
2615: --BINDVAR_SCAN_IGNORE[1]

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

2629: commit;
2630:
2631: --Get in line to lock the table for partition exchange.
2632: --BINDVAR_SCAN_IGNORE[1]
2633: execute IMMEDIATE 'lock table '||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS '||
2634: 'in exclusive mode';
2635: --Partition exchange the temp table into the wf_user_role_assignments table.
2636: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS ' ||
2637: 'EXCHANGE PARTITION ' || l_partitionName ||

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

2631: --Get in line to lock the table for partition exchange.
2632: --BINDVAR_SCAN_IGNORE[1]
2633: execute IMMEDIATE 'lock table '||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS '||
2634: 'in exclusive mode';
2635: --Partition exchange the temp table into the wf_user_role_assignments table.
2636: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS ' ||
2637: 'EXCHANGE PARTITION ' || l_partitionName ||
2638: ' WITH TABLE ' ||wf_schema||'.WF_UR_ASSIGNMENTS_STAGE '||
2639: 'INCLUDING INDEXES WITHOUT VALIDATION';

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

2632: --BINDVAR_SCAN_IGNORE[1]
2633: execute IMMEDIATE 'lock table '||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS '||
2634: 'in exclusive mode';
2635: --Partition exchange the temp table into the wf_user_role_assignments table.
2636: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_USER_ROLE_ASSIGNMENTS ' ||
2637: 'EXCHANGE PARTITION ' || l_partitionName ||
2638: ' WITH TABLE ' ||wf_schema||'.WF_UR_ASSIGNMENTS_STAGE '||
2639: 'INCLUDING INDEXES WITHOUT VALIDATION';
2640: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,