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_LOCAL_USER_ROLES

Line 991: UPDATE WF_LOCAL_USER_ROLES

987: AND ORIG_SYSTEM = p_orig_system
988: AND ORIG_SYSTEM_ID = p_orig_system_id;
989: end if;
990: --Update the user reference to itself if there is one.
991: UPDATE WF_LOCAL_USER_ROLES
992: SET USER_NAME = g_name,
993: ROLE_NAME = g_name
994: -- <6817561>
995: , LAST_UPDATE_DATE = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),

Line 1007: UPDATE WF_LOCAL_USER_ROLES

1003: AND PARTITION_ID = l_partitionID;
1004:
1005:
1006: --Update the user/roles
1007: UPDATE WF_LOCAL_USER_ROLES
1008: SET USER_NAME = g_Name
1009: -- <6817561>
1010: , LAST_UPDATE_DATE = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
1011: LAST_UPDATED_BY = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

Line 1209: -- We can change any wf_local_user_roles over to PER.

1205: end if;
1206:
1207: if (sql%rowcount > 0) then
1208: -- If we were able to delete an fnd_user from wf_local_roles then
1209: -- We can change any wf_local_user_roles over to PER.
1210:
1211: -- We will now reassign all active user/role relationships.
1212: WF_DIRECTORY.ReassignUserRoles(g_name, p_orig_system,
1213: p_orig_system_id, g_origSystem,

Line 1233: update wf_local_user_roles

1229:
1230: end if; --
1231: elsif (g_overWrite_UserRoles) then -- <6817561> needed to update std WHO columns
1232:
1233: update wf_local_user_roles
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_local_user_roles

1432: end;
1433:
1434: -- <6817561>
1435: if (g_overWrite_UserRoles) then
1436: update wf_local_user_roles
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 1625: UPDATE WF_LOCAL_USER_ROLES

1621: AND PARTITION_ID = l_partitionID
1622: AND ORIG_SYSTEM = p_orig_system
1623: AND ORIG_SYSTEM_ID = p_orig_system_id;
1624:
1625: UPDATE WF_LOCAL_USER_ROLES
1626: SET ROLE_NAME = g_name
1627: -- <6817561>
1628: , LAST_UPDATE_DATE = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
1629: LAST_UPDATED_BY = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

Line 1671: UPDATE WF_LOCAL_USER_ROLES

1667: WF_DIRECTORY.assignPartition(p_orig_system, l_partitionID,
1668: l_partitionName);
1669:
1670: --We will use the partition id where we can to improve performance.
1671: UPDATE WF_LOCAL_USER_ROLES
1672: SET
1673: LAST_UPDATE_DATE = nvl(g_lastUpdateDate, LAST_UPDATE_DATE),
1674: LAST_UPDATED_BY = nvl(g_lastUpdatedBy, LAST_UPDATED_BY),
1675: LAST_UPDATE_LOGIN = nvl(g_lastUpdateLogin, LAST_UPDATE_LOGIN)

Line 1719: -- of wf_local_user_roles

1715: and ORIG_SYSTEM=p_orig_system;
1716:
1717: -- update the self-references in URA and LUR
1718: -- For self reference we just need to make sure to use the same 'who' caolumn values
1719: -- of wf_local_user_roles
1720: --if (g_overWrite or g_overWrite_UserRoles) then
1721: update WF_LOCAL_USER_ROLES
1722: set ROLE_ORIG_SYSTEM_ID = g_employeeID,
1723: USER_ORIG_SYSTEM_ID = g_employeeID,

Line 1721: update WF_LOCAL_USER_ROLES

1717: -- update the self-references in URA and LUR
1718: -- For self reference we just need to make sure to use the same 'who' caolumn values
1719: -- of wf_local_user_roles
1720: --if (g_overWrite or g_overWrite_UserRoles) then
1721: update WF_LOCAL_USER_ROLES
1722: set ROLE_ORIG_SYSTEM_ID = g_employeeID,
1723: USER_ORIG_SYSTEM_ID = g_employeeID,
1724: LAST_UPDATE_DATE = decode(l_overWrite,'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
1725: LAST_UPDATED_BY = decode(l_overWrite,'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

Line 2010: ** propagateUserRole - Synchronizes the WF_LOCAL_USER_ROLES table.

2006: end;
2007:
2008: ------------------------------------------------------------------------------
2009: /*
2010: ** propagateUserRole - Synchronizes the WF_LOCAL_USER_ROLES table.
2011: */
2012: PROCEDURE propagateUserRole(p_user_name in varchar2,
2013: p_role_name in varchar2,
2014: p_user_orig_system in varchar2,

Line 2458: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_USER_ROLES_STAGE',

2454: l_storageClause||' ';
2455: end if;
2456:
2457: --Truncate the temp table.
2458: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_USER_ROLES_STAGE',
2459: Owner=>wf_schema);
2460:
2461: --Drop indexes from the temp table.
2462: for c in dbaIndexes('WF_LOCAL_USER_ROLES_STAGE', wf_schema) loop

Line 2462: for c in dbaIndexes('WF_LOCAL_USER_ROLES_STAGE', wf_schema) loop

2458: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_USER_ROLES_STAGE',
2459: Owner=>wf_schema);
2460:
2461: --Drop indexes from the temp table.
2462: for c in dbaIndexes('WF_LOCAL_USER_ROLES_STAGE', wf_schema) loop
2463: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2464: 'Dropping index '||c.INDEX_NAME);
2465: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2466: Owner=>wf_schema,

Line 2527: 'Loading WF_LOCAL_USER_ROLES_STAGE with: '||l_sql);

2523: to_char(g_parallel)||') */ ' ||l_selectList||' from '||
2524: nvl(l_userRoleView, 'WF_'||l_partitionName||'_UR R ' );
2525:
2526: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2527: 'Loading WF_LOCAL_USER_ROLES_STAGE with: '||l_sql);
2528:
2529: -- BINDVAR_SCAN_IGNORE[2]
2530: execute IMMEDIATE 'alter session force parallel query parallel '||
2531: to_char(g_parallel) ;

Line 2546: l_sql:=l_sql||' into WF_LOCAL_USER_ROLES_STAGE T '||

2542: l_sql := 'insert ';
2543: else
2544: l_sql := 'insert /*+ append parallel(T, '||to_char(g_parallel)||') */';
2545: end if;
2546: l_sql:=l_sql||' into WF_LOCAL_USER_ROLES_STAGE T '||
2547: '( USER_NAME, ROLE_NAME, USER_ORIG_SYSTEM,USER_ORIG_SYSTEM_ID, '||
2548: 'ROLE_ORIG_SYSTEM, ROLE_ORIG_SYSTEM_ID,PARENT_ORIG_SYSTEM, '||
2549: 'PARENT_ORIG_SYSTEM_ID, START_DATE, EXPIRATION_DATE, CREATED_BY, '||
2550: 'CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ';

Line 2589: --WF_LOCAL_USER_ROLES_STAGE and WF_UR_ASSIGNMENTS_STAGE tables based

2585:
2586: end;
2587:
2588: --Under 3542997 we will add the functionality to continue populating the
2589: --WF_LOCAL_USER_ROLES_STAGE and WF_UR_ASSIGNMENTS_STAGE tables based
2590: --on the hierarchy. After 3542997 is complete, orig_systems should be able
2591: --to both participate in hierarchies and continue to bulk synchronize.
2592: --At this time, an orig_system that participates in a hierarchy cannot bulk
2593: --synchronize.

Line 2598: TABNAME=>'WF_LOCAL_USER_ROLES_STAGE',

2594:
2595: if (l_importSuccess) then
2596: --Gather Table Statistics
2597: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2598: TABNAME=>'WF_LOCAL_USER_ROLES_STAGE',
2599: PERCENT=>10);
2600:
2601: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2602: 'Creating indexes on stage table.');

Line 2604: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_USER_ROLES',

2600:
2601: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2602: 'Creating indexes on stage table.');
2603:
2604: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_USER_ROLES',
2605: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');
2606:
2607: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2608: TABNAME=>'WF_UR_ASSIGNMENTS_STAGE',

Line 2605: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');

2601: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2602: 'Creating indexes on stage table.');
2603:
2604: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_USER_ROLES',
2605: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');
2606:
2607: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2608: TABNAME=>'WF_UR_ASSIGNMENTS_STAGE',
2609: PERCENT=>10);

Line 2616: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_USER_ROLES '||

2612: p_targetTable=>'WF_UR_ASSIGNMENTS_STAGE');
2613:
2614: --Get in line to lock the table for partition exchange.
2615: --BINDVAR_SCAN_IGNORE[1]
2616: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_USER_ROLES '||
2617: 'in exclusive mode';
2618: --Partition exchange the temp table into the wf_local_user_roles table.
2619: -- wf_schema came from wf_resources
2620: -- l_partitionName came from wf_directory_partitions

Line 2618: --Partition exchange the temp table into the wf_local_user_roles table.

2614: --Get in line to lock the table for partition exchange.
2615: --BINDVAR_SCAN_IGNORE[1]
2616: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_USER_ROLES '||
2617: 'in exclusive mode';
2618: --Partition exchange the temp table into the wf_local_user_roles table.
2619: -- wf_schema came from wf_resources
2620: -- l_partitionName came from wf_directory_partitions
2621: -- BINDVAR_SCAN_IGNORE[4]
2622: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||

Line 2622: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||

2618: --Partition exchange the temp table into the wf_local_user_roles table.
2619: -- wf_schema came from wf_resources
2620: -- l_partitionName came from wf_directory_partitions
2621: -- BINDVAR_SCAN_IGNORE[4]
2622: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||
2623: 'EXCHANGE PARTITION ' || l_partitionName ||
2624: ' WITH TABLE ' ||wf_schema||
2625: '.WF_LOCAL_USER_ROLES_STAGE INCLUDING INDEXES WITHOUT VALIDATION';
2626: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

Line 2625: '.WF_LOCAL_USER_ROLES_STAGE INCLUDING INDEXES WITHOUT VALIDATION';

2621: -- BINDVAR_SCAN_IGNORE[4]
2622: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||
2623: 'EXCHANGE PARTITION ' || l_partitionName ||
2624: ' WITH TABLE ' ||wf_schema||
2625: '.WF_LOCAL_USER_ROLES_STAGE INCLUDING INDEXES WITHOUT VALIDATION';
2626: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2627: 'Exchanging partition with: '||l_sql);
2628: execute IMMEDIATE l_sql;
2629: commit;