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 987: UPDATE WF_LOCAL_USER_ROLES

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

Line 1003: UPDATE WF_LOCAL_USER_ROLES

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

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

1197: end if;
1198:
1199: if (sql%rowcount > 0) then
1200: -- If we were able to delete an fnd_user from wf_local_roles then
1201: -- We can change any wf_local_user_roles over to PER.
1202:
1203: -- We will now reassign all active user/role relationships.
1204: WF_DIRECTORY.ReassignUserRoles(g_name, p_orig_system,
1205: p_orig_system_id, g_origSystem,

Line 1225: update wf_local_user_roles

1221:
1222: end if; --
1223: elsif (g_overWrite_UserRoles) then -- <6817561> needed to update std WHO columns
1224:
1225: update wf_local_user_roles
1226: set last_update_date = nvl(g_lastUpdateDate,last_update_date),
1227: last_updated_by = nvl(g_lastUpdatedBy, last_updated_by),
1228: last_update_login = nvl(g_lastUpdateLogin, last_update_login)
1229: where user_name = g_name

Line 1428: update wf_local_user_roles

1424: end;
1425:
1426: -- <6817561>
1427: if (g_overWrite_UserRoles) then
1428: update wf_local_user_roles
1429: set last_update_date = nvl(g_lastUpdateDate,last_update_date),
1430: last_updated_by = nvl(g_lastUpdatedBy, last_updated_by),
1431: last_update_login = nvl(g_lastUpdateLogin, last_update_login)
1432: where user_name = g_name

Line 1612: UPDATE WF_LOCAL_USER_ROLES

1608: AND PARTITION_ID = l_partitionID
1609: AND ORIG_SYSTEM = p_orig_system
1610: AND ORIG_SYSTEM_ID = p_orig_system_id;
1611:
1612: UPDATE WF_LOCAL_USER_ROLES
1613: SET ROLE_NAME = g_name
1614: -- <6817561>
1615: , LAST_UPDATE_DATE = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
1616: LAST_UPDATED_BY = decode(l_overWrite_UserRoles,'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

Line 1658: UPDATE WF_LOCAL_USER_ROLES

1654: WF_DIRECTORY.assignPartition(p_orig_system, l_partitionID,
1655: l_partitionName);
1656:
1657: --We will use the partition id where we can to improve performance.
1658: UPDATE WF_LOCAL_USER_ROLES
1659: SET
1660: LAST_UPDATE_DATE = nvl(g_lastUpdateDate, LAST_UPDATE_DATE),
1661: LAST_UPDATED_BY = nvl(g_lastUpdatedBy, LAST_UPDATED_BY),
1662: LAST_UPDATE_LOGIN = nvl(g_lastUpdateLogin, LAST_UPDATE_LOGIN)

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

1956: end;
1957:
1958: ------------------------------------------------------------------------------
1959: /*
1960: ** propagateUserRole - Synchronizes the WF_LOCAL_USER_ROLES table.
1961: */
1962: PROCEDURE propagateUserRole(p_user_name in varchar2,
1963: p_role_name in varchar2,
1964: p_user_orig_system in varchar2,

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

2396: l_storageClause||' ';
2397: end if;
2398:
2399: --Truncate the temp table.
2400: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_USER_ROLES_STAGE',
2401: Owner=>wf_schema);
2402:
2403: --Drop indexes from the temp table.
2404: for c in dbaIndexes('WF_LOCAL_USER_ROLES_STAGE', wf_schema) loop

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

2400: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_USER_ROLES_STAGE',
2401: Owner=>wf_schema);
2402:
2403: --Drop indexes from the temp table.
2404: for c in dbaIndexes('WF_LOCAL_USER_ROLES_STAGE', wf_schema) loop
2405: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2406: 'Dropping index '||c.INDEX_NAME);
2407: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2408: Owner=>wf_schema,

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

2461: to_char(g_parallel)||') */ ' ||l_selectList||' from '||
2462: nvl(l_userRoleView, 'WF_'||l_partitionName||'_UR R ' ));
2463:
2464: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2465: 'Loading WF_LOCAL_USER_ROLES_STAGE with: '||l_sql);
2466:
2467: -- BINDVAR_SCAN_IGNORE[2]
2468: execute IMMEDIATE 'alter session force parallel query parallel '||
2469: to_char(g_parallel) ;

Line 2480: ') */ into '||wf_schema||'.WF_LOCAL_USER_ROLES_STAGE T '||

2476: -- g_parallel must be number
2477: -- wf_schema came from wf_resources
2478: -- BINDVAR_SCAN_IGNORE[6]
2479: l_sql := 'insert /*+ append parallel(T, '||to_char(g_parallel)||
2480: ') */ into '||wf_schema||'.WF_LOCAL_USER_ROLES_STAGE T '||
2481: '( USER_NAME, ROLE_NAME, USER_ORIG_SYSTEM,USER_ORIG_SYSTEM_ID, '||
2482: 'ROLE_ORIG_SYSTEM, ROLE_ORIG_SYSTEM_ID,PARENT_ORIG_SYSTEM, '||
2483: 'PARENT_ORIG_SYSTEM_ID, START_DATE, EXPIRATION_DATE, CREATED_BY, '||
2484: 'CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ';

Line 2523: --WF_LOCAL_USER_ROLES_STAGE and WF_UR_ASSIGNMENTS_STAGE tables based

2519:
2520: end;
2521:
2522: --Under 3542997 we will add the functionality to continue populating the
2523: --WF_LOCAL_USER_ROLES_STAGE and WF_UR_ASSIGNMENTS_STAGE tables based
2524: --on the hierarchy. After 3542997 is complete, orig_systems should be able
2525: --to both participate in hierarchies and continue to bulk synchronize.
2526: --At this time, an orig_system that participates in a hierarchy cannot bulk
2527: --synchronize.

Line 2532: TABNAME=>'WF_LOCAL_USER_ROLES_STAGE',

2528:
2529: if (l_importSuccess) then
2530: --Gather Table Statistics
2531: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2532: TABNAME=>'WF_LOCAL_USER_ROLES_STAGE',
2533: PERCENT=>10);
2534:
2535: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2536: 'Creating indexes on stage table.');

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

2534:
2535: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2536: 'Creating indexes on stage table.');
2537:
2538: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_USER_ROLES',
2539: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');
2540:
2541: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2542: TABNAME=>'WF_UR_ASSIGNMENTS_STAGE',

Line 2539: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');

2535: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2536: 'Creating indexes on stage table.');
2537:
2538: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_USER_ROLES',
2539: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');
2540:
2541: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2542: TABNAME=>'WF_UR_ASSIGNMENTS_STAGE',
2543: PERCENT=>10);

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

2546: p_targetTable=>'WF_UR_ASSIGNMENTS_STAGE');
2547:
2548: --Get in line to lock the table for partition exchange.
2549: --BINDVAR_SCAN_IGNORE[1]
2550: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_USER_ROLES '||
2551: 'in exclusive mode';
2552: --Partition exchange the temp table into the wf_local_user_roles table.
2553: -- wf_schema came from wf_resources
2554: -- l_partitionName came from wf_directory_partitions

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

2548: --Get in line to lock the table for partition exchange.
2549: --BINDVAR_SCAN_IGNORE[1]
2550: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_USER_ROLES '||
2551: 'in exclusive mode';
2552: --Partition exchange the temp table into the wf_local_user_roles table.
2553: -- wf_schema came from wf_resources
2554: -- l_partitionName came from wf_directory_partitions
2555: -- BINDVAR_SCAN_IGNORE[4]
2556: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||

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

2552: --Partition exchange the temp table into the wf_local_user_roles table.
2553: -- wf_schema came from wf_resources
2554: -- l_partitionName came from wf_directory_partitions
2555: -- BINDVAR_SCAN_IGNORE[4]
2556: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||
2557: 'EXCHANGE PARTITION ' || l_partitionName ||
2558: ' WITH TABLE ' ||wf_schema||
2559: '.WF_LOCAL_USER_ROLES_STAGE INCLUDING INDEXES WITHOUT VALIDATION';
2560: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

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

2555: -- BINDVAR_SCAN_IGNORE[4]
2556: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_USER_ROLES ' ||
2557: 'EXCHANGE PARTITION ' || l_partitionName ||
2558: ' WITH TABLE ' ||wf_schema||
2559: '.WF_LOCAL_USER_ROLES_STAGE INCLUDING INDEXES WITHOUT VALIDATION';
2560: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2561: 'Exchanging partition with: '||l_sql);
2562: execute IMMEDIATE l_sql;
2563: commit;