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 420: AND dip.partition_name = 'WF_LOCAL_ROLES';

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

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

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

Line 964: UPDATE WF_LOCAL_ROLES

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

Line 976: UPDATE WF_LOCAL_ROLES

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

Line 1096: DELETE from WF_LOCAL_ROLES PARTITION (FND_USR) WR

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

Line 1108: From WF_LOCAL_ROLES PARTITION (PER_ROLE) WR

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

Line 1165: from WF_LOCAL_ROLES PARTITION (PER_ROLE) WR

1161: -- . Save the current role dates for later creation
1162: select decode(l_overWrite, 'Y', nvl(g_expDate, p_expiration_date), WR.EXPIRATION_DATE),
1163: nvl(p_start_date, WR.START_DATE)
1164: into p_aux_exp_date, p_aux_start_date
1165: from WF_LOCAL_ROLES PARTITION (PER_ROLE) WR
1166: where WR.ORIG_SYSTEM_ID = g_employeeID;
1167: WF_DIRECTORY.CreateUser( name=>g_name,
1168: display_name=>g_displayName,
1169: orig_system=>g_origSystem,

Line 1198: Delete from WF_LOCAL_ROLES PARTITION (FND_USR) WR

1194: -- We will attempt to delete an FND_USR row, if there is one to
1195: -- delete then we will need to re-associate any user_roles as well.
1196:
1197: if (g_employeeID is NOT NULL) then
1198: Delete from WF_LOCAL_ROLES PARTITION (FND_USR) WR
1199: Where WR.ORIG_SYSTEM = p_orig_system
1200: And WR.ORIG_SYSTEM_ID = p_orig_system_id
1201: returning last_update_date, last_update_login, last_updated_by
1202: into l_oldLastUpdDate, l_oldLastUpdLogin, l_oldLastUpdBy -- <6817561>

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

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

Line 1222: update wf_local_roles

1218:
1219: -- <6817561> case when we need to keep the std WHO columns old values
1220: if (not g_overWrite) then
1221:
1222: update wf_local_roles
1223: set last_update_date = l_oldLastUpdDate,
1224: last_updated_by = l_oldLastUpdBy,
1225: last_update_login = l_oldLastUpdLogin
1226: where name = g_name

Line 1294: Delete from WF_LOCAL_ROLES PARTITION (FND_USR) WR

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

Line 1582: FROM WF_LOCAL_ROLES PARTITION (FND_USR) WR

1578:
1579: CURSOR perRoles (c_orig_system in VARCHAR2, c_orig_system_id in NUMBER) is
1580: SELECT WR.NAME, WR.NOTIFICATION_PREFERENCE, WR.LANGUAGE, WR.TERRITORY,
1581: WR.FAX, WR.START_DATE, WR.EXPIRATION_DATE
1582: FROM WF_LOCAL_ROLES PARTITION (FND_USR) WR
1583: WHERE ORIG_SYSTEM = c_orig_system
1584: AND ORIG_SYSTEM_ID = c_orig_system_id;
1585:
1586: begin

Line 1618: UPDATE WF_LOCAL_ROLES

1614: l_overWrite_UserRoles := 'Y';
1615: end if;
1616:
1617: --We will use the partition id where we can to improve performance.
1618: UPDATE WF_LOCAL_ROLES
1619: SET NAME = g_name
1620: WHERE NAME = g_oldName
1621: AND PARTITION_ID = l_partitionID
1622: AND ORIG_SYSTEM = p_orig_system

Line 1712: update WF_LOCAL_ROLES

1708: --this portion of the code will naturally not execute.
1709:
1710: -- Bug 8337430. Validate the new employeeID is valid... then
1711: if (g_employeeID is not null) then
1712: update WF_LOCAL_ROLES
1713: set ORIG_SYSTEM_ID=g_employeeID
1714: where ORIG_SYSTEM_ID=p_orig_system_id
1715: and ORIG_SYSTEM=p_orig_system;
1716:

Line 1742: -- LUR and URA's 'who' columns are to be the same as those of wf_local_roles.

1738: where USER_ORIG_SYSTEM_ID = p_orig_system_id
1739: and USER_ORIG_SYSTEM = p_orig_system
1740: and ROLE_ORIG_SYSTEM_ID = p_orig_system_id
1741: and ROLE_ORIG_SYSTEM = p_orig_system;
1742: -- LUR and URA's 'who' columns are to be the same as those of wf_local_roles.
1743:
1744: end if;
1745: for perRole in perRoles(p_orig_system, p_orig_system_id) loop
1746:

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

2148: 'Begin syncRolesTL('||p_orig_system||', '|| p_partitionid||
2149: ', '||p_partitionName||', '||p_roleTLView||')');
2150:
2151: --Truncate the temp table.
2152: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_TL_STAGE',
2153: Owner=>wf_schema);
2154:
2155: --Drop indexes from the temp table.
2156: for c in dbaIndexes('WF_LOCAL_ROLES_TL_STAGE', wf_schema) loop

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

2152: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_TL_STAGE',
2153: Owner=>wf_schema);
2154:
2155: --Drop indexes from the temp table.
2156: for c in dbaIndexes('WF_LOCAL_ROLES_TL_STAGE', wf_schema) loop
2157: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2158: 'Dropping index '||c.INDEX_NAME);
2159: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2160: Owner=>wf_schema,

Line 2174: --WF_LOCAL_ROLES_TL_STAGE.

2170: execute IMMEDIATE 'alter session set hash_area_size=204857600';
2171:
2172: begin
2173: --Select the data from WF__ROLES_TL and insert into
2174: --WF_LOCAL_ROLES_TL_STAGE.
2175:
2176: if (BuildQuery (p_orig_system=>syncRolesTL.p_orig_system,
2177: p_stage_table=>'WF_LOCAL_ROLES_TL_STAGE',
2178: p_seed_view=>syncRolesTL.p_roletlview,

Line 2177: p_stage_table=>'WF_LOCAL_ROLES_TL_STAGE',

2173: --Select the data from WF__ROLES_TL and insert into
2174: --WF_LOCAL_ROLES_TL_STAGE.
2175:
2176: if (BuildQuery (p_orig_system=>syncRolesTL.p_orig_system,
2177: p_stage_table=>'WF_LOCAL_ROLES_TL_STAGE',
2178: p_seed_view=>syncRolesTL.p_roletlview,
2179: p_columnList=>l_columnList,
2180: p_selectList=>l_selectList)) then
2181: -- l_selectList is controlled by us

Line 2190: l_sql := l_sql||' into WF_LOCAL_ROLES_TL_STAGE T ('||

2186: l_sql := 'insert ';
2187: else
2188: l_sql := 'insert /*+ append parallel(T, '||to_char(g_parallel)||') */';
2189: end if;
2190: l_sql := l_sql||' into WF_LOCAL_ROLES_TL_STAGE T ('||
2191: l_columnList||') select /*+ parallel(R, '||
2192: to_char(g_parallel)||') */ '||l_selectList||
2193: ' from '||p_roletlview;
2194:

Line 2219: TABNAME=>'WF_LOCAL_ROLES_TL_STAGE',

2215:
2216: if (l_importSuccess) then
2217: --Gather Table Statistics
2218: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2219: TABNAME=>'WF_LOCAL_ROLES_TL_STAGE',
2220: PERCENT=>10);
2221:
2222: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2223: 'Creating indexes on stage table.');

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

2221:
2222: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2223: 'Creating indexes on stage table.');
2224:
2225: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES_TL',
2226: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');
2227:
2228: --Get in line to lock the table for partition exchange.
2229: --BINDVAR_SCAN_IGNORE[1]

Line 2226: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');

2222: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2223: 'Creating indexes on stage table.');
2224:
2225: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES_TL',
2226: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');
2227:
2228: --Get in line to lock the table for partition exchange.
2229: --BINDVAR_SCAN_IGNORE[1]
2230: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES_TL '||

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

2226: p_targetTable=>'WF_LOCAL_ROLES_TL_STAGE');
2227:
2228: --Get in line to lock the table for partition exchange.
2229: --BINDVAR_SCAN_IGNORE[1]
2230: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES_TL '||
2231: 'in exclusive mode';
2232:
2233: --Partition exchange the temp table into the wf_local_roles table.
2234: -- wf_schema came from wf_resources

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

2229: --BINDVAR_SCAN_IGNORE[1]
2230: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES_TL '||
2231: 'in exclusive mode';
2232:
2233: --Partition exchange the temp table into the wf_local_roles table.
2234: -- wf_schema came from wf_resources
2235: -- p_partitionName cames from wf_directory_partions
2236: -- BINDVAR_SCAN_IGNORE[8]
2237: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES_TL ' ||

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

2233: --Partition exchange the temp table into the wf_local_roles table.
2234: -- wf_schema came from wf_resources
2235: -- p_partitionName cames from wf_directory_partions
2236: -- BINDVAR_SCAN_IGNORE[8]
2237: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES_TL ' ||
2238: 'EXCHANGE PARTITION ' || p_partitionName ||
2239: ' WITH TABLE ' ||wf_schema||
2240: '.WF_LOCAL_ROLES_TL_STAGE INCLUDING '||
2241: 'INDEXES WITHOUT VALIDATION';

Line 2240: '.WF_LOCAL_ROLES_TL_STAGE INCLUDING '||

2236: -- BINDVAR_SCAN_IGNORE[8]
2237: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES_TL ' ||
2238: 'EXCHANGE PARTITION ' || p_partitionName ||
2239: ' WITH TABLE ' ||wf_schema||
2240: '.WF_LOCAL_ROLES_TL_STAGE INCLUDING '||
2241: 'INDEXES WITHOUT VALIDATION';
2242:
2243: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2244: 'Exchanging partition with: '||l_sql);

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

2288: syncRoles('PER_ROLE');
2289: end if;
2290:
2291: --Truncate the temp table.
2292: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_STAGE',
2293: Owner=>wf_schema);
2294:
2295: --Drop indexes from the temp table.
2296: for c in dbaIndexes('WF_LOCAL_ROLES_STAGE', wf_schema) loop

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

2292: WF_DDL.TruncateTable(TableName=>'WF_LOCAL_ROLES_STAGE',
2293: Owner=>wf_schema);
2294:
2295: --Drop indexes from the temp table.
2296: for c in dbaIndexes('WF_LOCAL_ROLES_STAGE', wf_schema) loop
2297: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2298: 'Dropping index '||c.INDEX_NAME);
2299: WF_DDL.DropIndex(IndexName=>c.INDEX_NAME,
2300: Owner=>wf_schema,

Line 2331: --WF_LOCAL_ROLES_STAGE.

2327: execute IMMEDIATE 'alter session set hash_area_size=204857600';
2328:
2329: begin
2330: --Select the data from WF__ROLES and insert into
2331: --WF_LOCAL_ROLES_STAGE.
2332: if (BuildQuery (p_orig_system=>l_partitionName,
2333: p_stage_table=>'WF_LOCAL_ROLES_STAGE',
2334: p_seed_view=>nvl(l_roleView,
2335: 'WF_'||l_partitionName||'_ROLES'),

Line 2333: p_stage_table=>'WF_LOCAL_ROLES_STAGE',

2329: begin
2330: --Select the data from WF__ROLES and insert into
2331: --WF_LOCAL_ROLES_STAGE.
2332: if (BuildQuery (p_orig_system=>l_partitionName,
2333: p_stage_table=>'WF_LOCAL_ROLES_STAGE',
2334: p_seed_view=>nvl(l_roleView,
2335: 'WF_'||l_partitionName||'_ROLES'),
2336: p_columnList=>l_columnList,
2337: p_selectList=>l_selectList)) then

Line 2348: l_sql := l_sql||' into WF_LOCAL_ROLES_STAGE T '||

2344: l_sql := 'insert ';
2345: else
2346: l_sql := 'insert /*+ append parallel(T, '||to_char(g_parallel)||') */';
2347: end if;
2348: l_sql := l_sql||' into WF_LOCAL_ROLES_STAGE T '||
2349: '('||l_columnList||') select /*+ parallel(R, '||
2350: to_char(g_parallel)||') */ '||l_selectList ||' from '||
2351: nvl(l_roleView, 'WF_'||l_partitionName||'_ROLES R ' );
2352:

Line 2374: TABNAME=>'WF_LOCAL_ROLES_STAGE',

2370:
2371: if (l_importSuccess) then
2372: --Gather Table Statistics
2373: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2374: TABNAME=>'WF_LOCAL_ROLES_STAGE',
2375: PERCENT=>10);
2376:
2377: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2378: 'Creating indexes on stage table.');

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

2376:
2377: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2378: 'Creating indexes on stage table.');
2379:
2380: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES',
2381: p_targetTable=>'WF_LOCAL_ROLES_STAGE');
2382:
2383: --Get in line to lock the table for partition exchange.
2384: --BINDVAR_SCAN_IGNORE[1]

Line 2381: p_targetTable=>'WF_LOCAL_ROLES_STAGE');

2377: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2378: 'Creating indexes on stage table.');
2379:
2380: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_ROLES',
2381: p_targetTable=>'WF_LOCAL_ROLES_STAGE');
2382:
2383: --Get in line to lock the table for partition exchange.
2384: --BINDVAR_SCAN_IGNORE[1]
2385: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES '||

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

2381: p_targetTable=>'WF_LOCAL_ROLES_STAGE');
2382:
2383: --Get in line to lock the table for partition exchange.
2384: --BINDVAR_SCAN_IGNORE[1]
2385: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES '||
2386: 'in exclusive mode';
2387: --Partition exchange the temp table into the wf_local_roles table.
2388: -- wf_schema came from wf_resources
2389: -- l_partitionName came from wf_directory_partitions

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

2383: --Get in line to lock the table for partition exchange.
2384: --BINDVAR_SCAN_IGNORE[1]
2385: execute IMMEDIATE 'lock table '||wf_schema||'.WF_LOCAL_ROLES '||
2386: 'in exclusive mode';
2387: --Partition exchange the temp table into the wf_local_roles table.
2388: -- wf_schema came from wf_resources
2389: -- l_partitionName came from wf_directory_partitions
2390: -- BINDVAR_SCAN_IGNORE[4]
2391: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES ' ||

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

2387: --Partition exchange the temp table into the wf_local_roles table.
2388: -- wf_schema came from wf_resources
2389: -- l_partitionName came from wf_directory_partitions
2390: -- BINDVAR_SCAN_IGNORE[4]
2391: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES ' ||
2392: 'EXCHANGE PARTITION ' || l_partitionName ||
2393: ' WITH TABLE ' ||wf_schema|| '.WF_LOCAL_ROLES_STAGE INCLUDING '||
2394: 'INDEXES WITHOUT VALIDATION';
2395: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

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

2389: -- l_partitionName came from wf_directory_partitions
2390: -- BINDVAR_SCAN_IGNORE[4]
2391: l_sql := 'ALTER TABLE ' ||wf_schema||'.WF_LOCAL_ROLES ' ||
2392: 'EXCHANGE PARTITION ' || l_partitionName ||
2393: ' WITH TABLE ' ||wf_schema|| '.WF_LOCAL_ROLES_STAGE INCLUDING '||
2394: 'INDEXES WITHOUT VALIDATION';
2395: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,
2396: 'Exchanging partition with: '||l_sql);
2397: execute IMMEDIATE l_sql;

Line 2994: from wf_local_roles

2990: retcode out NOCOPY varchar2) is
2991:
2992: cursor c_fnd_users is
2993: select name, orig_system, orig_system_id
2994: from wf_local_roles
2995: where orig_system in ('FND_USR', 'PER')
2996: and notification_preference = 'DISABLED'
2997: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
2998:

Line 3001: from wf_local_roles

2997: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
2998:
2999: cursor c_other_users is
3000: select name, orig_system, orig_system_id
3001: from wf_local_roles
3002: where orig_system not in ('FND_USR', 'PER')
3003: and notification_preference = 'DISABLED'
3004: and nvl(EXPIRATION_DATE, sysdate+1) > sysdate;
3005:

Line 3038: -- to reset the notification preference in wf_local_roles table

3034: end loop;
3035:
3036: -- For each DISABLED user/role other than FND or PER, call fnd_preference.get() to get
3037: -- the previous preference value, if exists call wf_local_synch.Propagate_User
3038: -- to reset the notification preference in wf_local_roles table
3039: for user_rec in c_other_users loop
3040:
3041: -- Concatenate username with orig system and orig system id to make it unique
3042: -- in FND_USER_PREFERENCES table