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_MAINTENANCE dependencies on WF_LOCAL_USER_ROLES

Line 368: from wf_local_user_roles wur

364: user_end_date, role_end_date, partition_id,
365: effective_start_date, effective_end_date, user_orig_system,
366: user_orig_system_id, role_orig_system, role_orig_system_id,
367: parent_orig_system, parent_orig_system_id, owner_tag
368: from wf_local_user_roles wur
369: where not exists (select null
370: from wf_user_role_assignments wura
371: where wura.user_name = wur.user_name
372: and wura.role_name = wur.role_name);

Line 386: -- in WF_LOCAL_USER_ROLES

382: and (wu.orig_system <> decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER')
383: or wu.orig_system_id <> nvl(fu.employee_id, fu.user_id));
384:
385: -- Records with invalid or duplicate FND_USR/PER references
386: -- in WF_LOCAL_USER_ROLES
387: cursor c_invalOrigSys is
388: select wu.orig_system, wu.orig_system_id,
389: wur.role_orig_system, wur.role_orig_system_id,
390: wur.partition_id, wur.rowid

Line 391: from wf_local_user_roles wur,

387: cursor c_invalOrigSys is
388: select wu.orig_system, wu.orig_system_id,
389: wur.role_orig_system, wur.role_orig_system_id,
390: wur.partition_id, wur.rowid
391: from wf_local_user_roles wur,
392: wf_local_roles partition (FND_USR) wu
393: where wu.name = wur.user_name
394: and wur.user_orig_system in ('FND_USR','PER')
395: and (wur.user_orig_system <> wu.orig_system

Line 408: from wf_local_user_roles partition (FND_USR) wur,

404: --resolved in when c_userRoleAssignments are resolved.
405: cursor c_userSelfReference is
406: select wura.rowid, wur.rowid, wu.start_date, wu.expiration_date,
407: wu.orig_system, wu.orig_system_id
408: from wf_local_user_roles partition (FND_USR) wur,
409: wf_local_roles partition (FND_USR) wu,
410: wf_user_role_assignments partition (FND_USR) wura
411: --Equi-joins to select the proper relationships between the tables
412: where wura.partition_id = wu.partition_id

Line 477: from wf_local_user_roles

473: order by ROLE_NAME, USER_NAME;
474:
475: CURSOR dangling_UR_refs is
476: select rowid
477: from wf_local_user_roles
478: where user_name not in (select name from wf_local_roles)
479: or role_name not in (select name from wf_local_roles);
480:
481: CURSOR dangling_URA_refs is

Line 523: DELETE from WF_LOCAL_USER_ROLES

519: close dangling_UR_refs;
520:
521: if (l_rowIDTAB.COUNT > 0) then
522: forall i in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
523: DELETE from WF_LOCAL_USER_ROLES
524: WHERE rowid = l_rowIDTAB(i);
525: commit;
526: end if;
527:

Line 687: -- WF_LOCAL_USER_ROLES

683: end; --End of duplicate/invalid FND_USR/PER user correction.
684:
685: -- Now we correct the FND_USR/PER orig_system values on the user side
686: -- of user/role assignments as well as user-self-references in
687: -- WF_LOCAL_USER_ROLES
688:
689: begin
690: <>
691: loop

Line 714: UPDATE WF_LOCAL_USER_ROLES

710: --perform the bulk update.. delete duplicates in case of
711: -- dup_val_on_index Exception.
712: begin
713: forall i in l_rowIDTAB.FIRST..l_rowIDTAB.LAST save exceptions
714: UPDATE WF_LOCAL_USER_ROLES
715: SET user_orig_system = l_userOrigSrcTAB(i),
716: user_orig_system_id = l_userOrigIDSrcTAB(i),
717: role_orig_system = l_roleOrigSrcTAB(i),
718: role_orig_system_id = l_roleOrigIDSrcTAB(i)

Line 725: delete from wf_local_user_roles

721: when others then
722: for j in 1..sql%bulk_exceptions.count loop
723: if (sql%bulk_exceptions(j).ERROR_CODE = 1) then
724: l_eIndex := sql%bulk_exceptions(j).ERROR_INDEX;
725: delete from wf_local_user_roles
726: where rowid = l_rowIDTAB(l_eIndex);
727: end if;
728: end loop;
729: end;

Line 743: end; --End of duplicate/invalid FND_USR/PER correction in WF_LOCAL_USER_ROLES.

739: if c_invalOrigSys%ISOPEN then
740: close c_invalOrigSys;
741: end if;
742: raise;
743: end; --End of duplicate/invalid FND_USR/PER correction in WF_LOCAL_USER_ROLES.
744:
745: --Next, we correct the corrupt self-reference records in
746: --wf_user_role_Assignments and wf_local_user_Roles.
747: begin

Line 746: --wf_user_role_Assignments and wf_local_user_Roles.

742: raise;
743: end; --End of duplicate/invalid FND_USR/PER correction in WF_LOCAL_USER_ROLES.
744:
745: --Next, we correct the corrupt self-reference records in
746: --wf_user_role_Assignments and wf_local_user_Roles.
747: begin
748: <>
749: loop
750: --We will commit on each loop cycle to prevent fetch across commits, we will

Line 834: -- update WF_LOCAL_USER_ROLES

830:
831: --Commit work to save rollback
832: commit;
833:
834: -- update WF_LOCAL_USER_ROLES
835: begin
836: if (p_UpdateWho is not null and p_UpdateWho) then
837: forall tabIndex in l_rowIDSrcTAB.FIRST..l_rowIDSrcTAB.LAST save exceptions
838: update wf_local_user_roles partition (FND_USR)

Line 838: update wf_local_user_roles partition (FND_USR)

834: -- update WF_LOCAL_USER_ROLES
835: begin
836: if (p_UpdateWho is not null and p_UpdateWho) then
837: forall tabIndex in l_rowIDSrcTAB.FIRST..l_rowIDSrcTAB.LAST save exceptions
838: update wf_local_user_roles partition (FND_USR)
839: set ROLE_START_DATE = l_StartSrcTAB(tabIndex),
840: ROLE_END_DATE = l_EndSrcTAB(tabIndex),
841: USER_START_DATE = l_StartSrcTAB(tabIndex),
842: USER_END_DATE = l_EndSrcTAB(tabIndex),

Line 855: update wf_local_user_roles partition (FND_USR)

851: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
852: where rowid = l_rowIDSrcTAB(tabIndex);
853: else --donot touch the WHO columns. This is default behavior
854: forall tabIndex in l_rowIDSrcTAB.FIRST..l_rowIDSrcTAB.LAST save exceptions
855: update wf_local_user_roles partition (FND_USR)
856: set ROLE_START_DATE = l_StartSrcTAB(tabIndex),
857: ROLE_END_DATE = l_EndSrcTAB(tabIndex),
858: USER_START_DATE = l_StartSrcTAB(tabIndex),
859: USER_END_DATE = l_EndSrcTAB(tabIndex),

Line 958: WF_LOCAL_USER_ROLES WUR ,

954: TO_DATE(''9999/01/01'', ''YYYY/MM/DD''))) EFFECTIVE_END_DATE,
955: WURA.RELATIONSHIP_ID
956: FROM
957: WF_USER_ROLE_ASSIGNMENTS WURA,
958: WF_LOCAL_USER_ROLES WUR ,
959: WF_LOCAL_ROLES WAR,
960: WF_LOCAL_ROLES WU,
961: WF_LOCAL_ROLES WR
962: WHERE WURA.PARTITION_ID = WAR.PARTITION_ID

Line 1136: UPDATE WF_LOCAL_USER_ROLES wur

1132: --information when duplicate user/role
1133: --combinations are spread across multiple groups
1134: if (p_UpdateWho is not null and p_UpdateWho) then
1135: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
1136: UPDATE WF_LOCAL_USER_ROLES wur
1137: SET ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
1138: ROLE_END_DATE = l_roleEndDestTAB(destTabIndex),
1139: USER_START_DATE = l_userStartDestTAB(destTabIndex),
1140: USER_END_DATE = l_userEndDestTAB(destTabIndex),

Line 1152: UPDATE WF_LOCAL_USER_ROLES wur

1148: LAST_UPDATE_DATE = SYSDATE
1149: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1150: else --Do not touch WHO columns. This is default behavior
1151: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
1152: UPDATE WF_LOCAL_USER_ROLES wur
1153: SET ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
1154: ROLE_END_DATE = l_roleEndDestTAB(destTabIndex),
1155: USER_START_DATE = l_userStartDestTAB(destTabIndex),
1156: USER_END_DATE = l_userEndDestTAB(destTabIndex),

Line 1307: UPDATE WF_LOCAL_USER_ROLES wur

1303:
1304: if (l_roleDestTAB.COUNT) > 0 then
1305: if (p_UpdateWho is not null and p_UpdateWho) then
1306: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
1307: UPDATE WF_LOCAL_USER_ROLES wur
1308: SET ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
1309: ROLE_END_DATE = l_roleEndDestTAB(destTabIndex),
1310: USER_START_DATE = l_userStartDestTAB(destTabIndex),
1311: USER_END_DATE = l_userEndDestTAB(destTabIndex),

Line 1323: UPDATE WF_LOCAL_USER_ROLES wur

1319: LAST_UPDATE_DATE = SYSDATE
1320: WHERE rowid = l_rowIDDestTAB(destTabIndex);
1321: else --Do not touch WHO columns. This is default behavior.
1322: forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
1323: UPDATE WF_LOCAL_USER_ROLES wur
1324: SET ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
1325: ROLE_END_DATE = l_roleEndDestTAB(destTabIndex),
1326: USER_START_DATE = l_userStartDestTAB(destTabIndex),
1327: USER_END_DATE = l_userEndDestTAB(destTabIndex),