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_ROLES

Line 419: AND dip.partition_name = 'WF_LOCAL_ROLES';

415: dip.freelist_groups
416: FROM dba_ind_partitions dip
417: WHERE dip.index_owner = indexOwner
418: AND dip.index_name = indexName
419: AND dip.partition_name = 'WF_LOCAL_ROLES';
420:
421: CURSOR indexColumns (indexOwner varchar2, indexName varchar2,
422: tableName varchar2) IS
423: SELECT column_name, column_position

Line 726: (p_stage_table <> 'WF_LOCAL_ROLES_TL_STAGE')) then

722: '] applying business rules for missing column.');
723: end if;
724:
725: if ((l_stageTableDesc(stageIND).COL_NAME = 'LANGUAGE') and
726: (p_stage_table <> 'WF_LOCAL_ROLES_TL_STAGE')) then
727: if (p_orig_system IN ('PER_ROLE', 'ENG_LIST', 'FND_RESP', 'GBX') OR
728: NOT l_colExists) then
729: p_selectList := (p_selectList||''''||g_BaseLanguage||''''||', ');
730: else

Line 960: UPDATE WF_LOCAL_ROLES

956: --We inline update the role and direct user/role then raise the event so
957: --the rest of the work can be deferred.
958: if (l_partitionID = 1) then
959:
960: UPDATE WF_LOCAL_ROLES
961: SET NAME = g_name
962: -- <6817561>
963: , LAST_UPDATE_DATE = decode(l_overWrite, 'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
964: LAST_UPDATED_BY = decode(l_overWrite, 'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

Line 972: UPDATE WF_LOCAL_ROLES

968: --
969: WHERE NAME = g_oldName
970: AND PARTITION_ID = l_partitionID;
971: else
972: UPDATE WF_LOCAL_ROLES
973: SET NAME = g_name
974: -- <6817561>
975: , LAST_UPDATE_DATE = decode(l_overWrite, 'Y', nvl(g_lastUpdateDate, LAST_UPDATE_DATE), LAST_UPDATE_DATE),
976: LAST_UPDATED_BY = decode(l_overWrite, 'Y', nvl(g_lastUpdatedBy, LAST_UPDATED_BY), LAST_UPDATED_BY),

Line 1092: DELETE from WF_LOCAL_ROLES PARTITION (FND_USR) WR

1088: --Attempt to delete any other employee that might be still associated
1089: --to this user. Then we will proceed to update/create the user. Finally
1090: --we will reassign any user/roles from the previous 'PER' role to the
1091: --new 'PER' role.
1092: DELETE from WF_LOCAL_ROLES PARTITION (FND_USR) WR
1093: WHERE WR.ORIG_SYSTEM = 'PER'
1094: AND WR.NAME = g_name
1095: AND WR.ORIG_SYSTEM_ID <> g_employeeID
1096: Returning WR.ORIG_SYSTEM_ID , last_update_date, last_update_login, last_updated_by

Line 1104: From WF_LOCAL_ROLES PARTITION (PER_ROLE) WR

1100: begin
1101: Select WR.EMAIL_ADDRESS, WR.DISPLAY_NAME, WR.DESCRIPTION,
1102: WR.STATUS
1103: into g_emailAddress, g_displayName, g_description, g_status
1104: From WF_LOCAL_ROLES PARTITION (PER_ROLE) WR
1105: Where WR.ORIG_SYSTEM = 'PER_ROLE'
1106: And WR.ORIG_SYSTEM_ID = g_employeeID;
1107: exception
1108: when NO_DATA_FOUND then

Line 1190: Delete from WF_LOCAL_ROLES PARTITION (FND_USR) WR

1186: -- We will attempt to delete an FND_USR row, if there is one to
1187: -- delete then we will need to re-associate any user_roles as well.
1188:
1189: if (g_employeeID is NOT NULL) then
1190: Delete from WF_LOCAL_ROLES PARTITION (FND_USR) WR
1191: Where WR.ORIG_SYSTEM = p_orig_system
1192: And WR.ORIG_SYSTEM_ID = p_orig_system_id
1193: returning last_update_date, last_update_login, last_updated_by
1194: into l_oldLastUpdDate, l_oldLastUpdLogin, l_oldLastUpdBy -- <6817561>

Line 1200: -- If we were able to delete an fnd_user from wf_local_roles then

1196:
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,

Line 1214: update wf_local_roles

1210:
1211: -- <6817561> case when we need to keep the std WHO columns old values
1212: if (not g_overWrite) then
1213:
1214: update wf_local_roles
1215: set last_update_date = l_oldLastUpdDate,
1216: last_updated_by = l_oldLastUpdBy,
1217: last_update_login = l_oldLastUpdLogin
1218: where name = g_name

Line 1286: Delete from WF_LOCAL_ROLES PARTITION (FND_USR) WR

1282: elsif ((p_orig_system = 'FND_USR') and (g_employeeID is NULL)) then
1283: -- FND_USR is either propagating a user who is not associated with
1284: -- an employee or is dis-associating one. We will check to see if a
1285: --dis-association has just occured, the PER record will still exist.
1286: Delete from WF_LOCAL_ROLES PARTITION (FND_USR) WR
1287: Where WR.ORIG_SYSTEM = 'PER'
1288: And WR.NAME = g_name
1289: Returning WR.ORIG_SYSTEM_ID, last_update_date, last_update_login, last_updated_by
1290: into g_employeeID, l_oldLastUpdDate, l_oldLastUpdLogin, l_oldLastUpdBy; -- <6817561>

Line 1573: FROM WF_LOCAL_ROLES PARTITION (FND_USR) WR

1569:
1570: CURSOR perRoles (c_orig_system in VARCHAR2, c_orig_system_id in NUMBER) is
1571: SELECT WR.NAME, WR.NOTIFICATION_PREFERENCE, WR.LANGUAGE, WR.TERRITORY,
1572: WR.FAX, WR.START_DATE, WR.EXPIRATION_DATE
1573: FROM WF_LOCAL_ROLES PARTITION (FND_USR) WR
1574: WHERE ORIG_SYSTEM = c_orig_system
1575: AND ORIG_SYSTEM_ID = c_orig_system_id;
1576:
1577: begin

Line 1605: UPDATE WF_LOCAL_ROLES

1601: l_overWrite_UserRoles := 'Y';
1602: end if;
1603:
1604: --We will use the partition id where we can to improve performance.
1605: UPDATE WF_LOCAL_ROLES
1606: SET NAME = g_name
1607: WHERE NAME = g_oldName
1608: AND PARTITION_ID = l_partitionID
1609: AND ORIG_SYSTEM = p_orig_system

Line 2102: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_TL_STAGE',

2098: 'Begin syncRolesTL('||p_orig_system||', '|| p_partitionid||
2099: ', '||p_partitionName||', '||p_roleTLView||')');
2100:
2101: --Truncate the temp table.
2102: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_TL_STAGE',
2103: Owner=>wf_schema);
2104:
2105: --Drop indexes from the temp table.
2106: for c in dbaIndexes('WF_LOCAL_ROLES_TL_STAGE', wf_schema) loop

Line 2106: for c in dbaIndexes('WF_LOCAL_ROLES_TL_STAGE', wf_schema) loop

2102: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_TL_STAGE',
2103: Owner=>wf_schema);
2104:
2105: --Drop indexes from the temp table.
2106: for c in dbaIndexes('WF_LOCAL_ROLES_TL_STAGE', wf_schema) loop
2107: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2108: 'Dropping index '||c.INDEX_NAME);
2109: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2110: Owner=>wf_schema,

Line 2124: --WF_LOCAL_ROLES_TL_STAGE.

2120: execute IMMEDIATE 'alter session set hash_area_size=204857600';
2121:
2122: begin
2123: --Select the data from WF__ROLES_TL and insert into
2124: --WF_LOCAL_ROLES_TL_STAGE.
2125:
2126: if (BuildQuery (p_orig_system=>syncRolesTL.p_orig_system,
2127: p_stage_table=>'WF_LOCAL_ROLES_TL_STAGE',
2128: p_seed_view=>syncRolesTL.p_roletlview,

Line 2127: p_stage_table=>'WF_LOCAL_ROLES_TL_STAGE',

2123: --Select the data from WF__ROLES_TL and insert into
2124: --WF_LOCAL_ROLES_TL_STAGE.
2125:
2126: if (BuildQuery (p_orig_system=>syncRolesTL.p_orig_system,
2127: p_stage_table=>'WF_LOCAL_ROLES_TL_STAGE',
2128: p_seed_view=>syncRolesTL.p_roletlview,
2129: p_columnList=>l_columnList,
2130: p_selectList=>l_selectList)) then
2131: -- l_selectList is controlled by us

Line 2136: ') */ into '||wf_schema||'.WF_LOCAL_ROLES_TL_STAGE T ('||

2132: -- g_parallel must not be varchar
2133: -- p_roletlview came from wf_directory_partitions
2134: -- BINDVAR_SCAN_IGNORE[4]
2135: l_sql := ( 'insert /*+ append parallel(T, '||to_char(g_parallel)||
2136: ') */ into '||wf_schema||'.WF_LOCAL_ROLES_TL_STAGE T ('||
2137: l_columnList||') select /*+ parallel(R, '||
2138: to_char(g_parallel)||') */ '||l_selectList||
2139: ' from '||p_roletlview );
2140:

Line 2165: TABNAME=>'WF_LOCAL_ROLES_TL_STAGE',

2161:
2162: if (l_importSuccess) then
2163: --Gather Table Statistics
2164: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2165: TABNAME=>'WF_LOCAL_ROLES_TL_STAGE',
2166: PERCENT=>10);
2167:
2168: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2169: 'Creating indexes on stage table.');

Line 2171: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES_TL',

2167:
2168: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2169: 'Creating indexes on stage table.');
2170:
2171: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES_TL',
2172: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');
2173:
2174: --Get in line to lock the table for partition exchange.
2175: --BINDVAR_SCAN_IGNORE[1]

Line 2172: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');

2168: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2169: 'Creating indexes on stage table.');
2170:
2171: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES_TL',
2172: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');
2173:
2174: --Get in line to lock the table for partition exchange.
2175: --BINDVAR_SCAN_IGNORE[1]
2176: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES_TL '||

Line 2176: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES_TL '||

2172: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');
2173:
2174: --Get in line to lock the table for partition exchange.
2175: --BINDVAR_SCAN_IGNORE[1]
2176: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES_TL '||
2177: 'in exclusive mode';
2178:
2179: --Partition exchange the temp table into the wf_local_roles table.
2180: -- wf_schema came from wf_resources

Line 2179: --Partition exchange the temp table into the wf_local_roles table.

2175: --BINDVAR_SCAN_IGNORE[1]
2176: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES_TL '||
2177: 'in exclusive mode';
2178:
2179: --Partition exchange the temp table into the wf_local_roles table.
2180: -- wf_schema came from wf_resources
2181: -- p_partitionName cames from wf_directory_partions
2182: -- BINDVAR_SCAN_IGNORE[8]
2183: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES_TL ' ||

Line 2183: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES_TL ' ||

2179: --Partition exchange the temp table into the wf_local_roles table.
2180: -- wf_schema came from wf_resources
2181: -- p_partitionName cames from wf_directory_partions
2182: -- BINDVAR_SCAN_IGNORE[8]
2183: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES_TL ' ||
2184: 'EXCHANGE PARTITION ' || p_partitionName ||
2185: ' WITH TABLE ' ||wf_schema||
2186: '.WF_LOCAL_ROLES_TL_STAGE INCLUDING '||
2187: 'INDEXES WITHOUT VALIDATION';

Line 2186: '.WF_LOCAL_ROLES_TL_STAGE INCLUDING '||

2182: -- BINDVAR_SCAN_IGNORE[8]
2183: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES_TL ' ||
2184: 'EXCHANGE PARTITION ' || p_partitionName ||
2185: ' WITH TABLE ' ||wf_schema||
2186: '.WF_LOCAL_ROLES_TL_STAGE INCLUDING '||
2187: 'INDEXES WITHOUT VALIDATION';
2188:
2189: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2190: 'Exchanging partition with: '||l_sql);

Line 2238: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_STAGE',

2234: syncRoles('PER_ROLE');
2235: end if;
2236:
2237: --Truncate the temp table.
2238: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_STAGE',
2239: Owner=>wf_schema);
2240:
2241: --Drop indexes from the temp table.
2242: for c in dbaIndexes('WF_LOCAL_ROLES_STAGE', wf_schema) loop

Line 2242: for c in dbaIndexes('WF_LOCAL_ROLES_STAGE', wf_schema) loop

2238: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_STAGE',
2239: Owner=>wf_schema);
2240:
2241: --Drop indexes from the temp table.
2242: for c in dbaIndexes('WF_LOCAL_ROLES_STAGE', wf_schema) loop
2243: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2244: 'Dropping index '||c.INDEX_NAME);
2245: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2246: Owner=>wf_schema,

Line 2277: --WF_LOCAL_ROLES_STAGE.

2273: execute IMMEDIATE 'alter session set hash_area_size=204857600';
2274:
2275: begin
2276: --Select the data from WF__ROLES and insert into
2277: --WF_LOCAL_ROLES_STAGE.
2278: if (BuildQuery (p_orig_system=>l_partitionName,
2279: p_stage_table=>'WF_LOCAL_ROLES_STAGE',
2280: p_seed_view=>nvl(l_roleView,
2281: 'WF_'||l_partitionName||'_ROLES'),

Line 2279: p_stage_table=>'WF_LOCAL_ROLES_STAGE',

2275: begin
2276: --Select the data from WF__ROLES and insert into
2277: --WF_LOCAL_ROLES_STAGE.
2278: if (BuildQuery (p_orig_system=>l_partitionName,
2279: p_stage_table=>'WF_LOCAL_ROLES_STAGE',
2280: p_seed_view=>nvl(l_roleView,
2281: 'WF_'||l_partitionName||'_ROLES'),
2282: p_columnList=>l_columnList,
2283: p_selectList=>l_selectList)) then

Line 2290: ') */ into '||wf_schema||'.WF_LOCAL_ROLES_STAGE T '||

2286: -- l_selectList is controlled by us
2287: -- l_partitionName came from wf_directory_partitions
2288: -- BINDVAR_SCAN_IGNORE[5]
2289: l_sql := ( 'insert /*+ append parallel(T, '||to_char(g_parallel)||
2290: ') */ into '||wf_schema||'.WF_LOCAL_ROLES_STAGE T '||
2291: '('||l_columnList||') select /*+ parallel(R, '||
2292: to_char(g_parallel)||') */ '||l_selectList ||' from '||
2293: nvl(l_roleView, 'WF_'||l_partitionName||'_ROLES R ' ));
2294:

Line 2316: TABNAME=>'WF_LOCAL_ROLES_STAGE',

2312:
2313: if (l_importSuccess) then
2314: --Gather Table Statistics
2315: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2316: TABNAME=>'WF_LOCAL_ROLES_STAGE',
2317: PERCENT=>10);
2318:
2319: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2320: 'Creating indexes on stage table.');

Line 2322: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES',

2318:
2319: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2320: 'Creating indexes on stage table.');
2321:
2322: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES',
2323: p_targetTable=>'WF_LOCAL_ROLES_STAGE');
2324:
2325: --Get in line to lock the table for partition exchange.
2326: --BINDVAR_SCAN_IGNORE[1]

Line 2323: p_targetTable=>'WF_LOCAL_ROLES_STAGE');

2319: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2320: 'Creating indexes on stage table.');
2321:
2322: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES',
2323: p_targetTable=>'WF_LOCAL_ROLES_STAGE');
2324:
2325: --Get in line to lock the table for partition exchange.
2326: --BINDVAR_SCAN_IGNORE[1]
2327: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES '||

Line 2327: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES '||

2323: p_targetTable=>'WF_LOCAL_ROLES_STAGE');
2324:
2325: --Get in line to lock the table for partition exchange.
2326: --BINDVAR_SCAN_IGNORE[1]
2327: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES '||
2328: 'in exclusive mode';
2329: --Partition exchange the temp table into the wf_local_roles table.
2330: -- wf_schema came from wf_resources
2331: -- l_partitionName came from wf_directory_partitions

Line 2329: --Partition exchange the temp table into the wf_local_roles table.

2325: --Get in line to lock the table for partition exchange.
2326: --BINDVAR_SCAN_IGNORE[1]
2327: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES '||
2328: 'in exclusive mode';
2329: --Partition exchange the temp table into the wf_local_roles table.
2330: -- wf_schema came from wf_resources
2331: -- l_partitionName came from wf_directory_partitions
2332: -- BINDVAR_SCAN_IGNORE[4]
2333: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES ' ||

Line 2333: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES ' ||

2329: --Partition exchange the temp table into the wf_local_roles table.
2330: -- wf_schema came from wf_resources
2331: -- l_partitionName came from wf_directory_partitions
2332: -- BINDVAR_SCAN_IGNORE[4]
2333: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES ' ||
2334: 'EXCHANGE PARTITION ' || l_partitionName ||
2335: ' WITH TABLE ' ||wf_schema|| '.WF_LOCAL_ROLES_STAGE INCLUDING '||
2336: 'INDEXES WITHOUT VALIDATION';
2337: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

Line 2335: ' WITH TABLE ' ||wf_schema|| '.WF_LOCAL_ROLES_STAGE INCLUDING '||

2331: -- l_partitionName came from wf_directory_partitions
2332: -- BINDVAR_SCAN_IGNORE[4]
2333: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES ' ||
2334: 'EXCHANGE PARTITION ' || l_partitionName ||
2335: ' WITH TABLE ' ||wf_schema|| '.WF_LOCAL_ROLES_STAGE INCLUDING '||
2336: 'INDEXES WITHOUT VALIDATION';
2337: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2338: 'Exchanging partition with: '||l_sql);
2339: execute IMMEDIATE l_sql;