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

Line 1579: from WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES) WLUR

1575: -- of whether the role is expired or not.
1576: cursor expired_rel_cursor is
1577: select wlur.user_name, wlur.user_orig_system, wlur.user_orig_system_id,
1578: wlur.role_name, wlur.role_orig_system, wlur.role_orig_system_id
1579: from WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES) WLUR
1580: where (WLUR.ROLE_ORIG_SYSTEM='WF_LOCAL_ROLES' or WLUR.USER_ORIG_SYSTEM='WF_LOCAL_USERS')
1581: and WLUR.EFFECTIVE_END_DATE <= directory.end_date;
1582:
1583: cursor expired_rel_orig_system_cursor (p_origSystem varchar2,

Line 1587: from WF_LOCAL_USER_ROLES WLUR, WF_LOCAL_ROLES WLR

1583: cursor expired_rel_orig_system_cursor (p_origSystem varchar2,
1584: p_endDate date) is
1585: select wlur.user_name, wlur.user_orig_system, wlur.user_orig_system_id,
1586: wlur.role_name, wlur.role_orig_system, wlur.role_orig_system_id
1587: from WF_LOCAL_USER_ROLES WLUR, WF_LOCAL_ROLES WLR
1588: where WLR.ORIG_SYSTEM=p_origSystem
1589: and ((WLR.NAME=WLUR.USER_NAME and WLR.ORIG_SYSTEM=WLUR.USER_ORIG_SYSTEM)
1590: or
1591: (WLR.NAME=WLUR.ROLE_NAME and WLR.ORIG_SYSTEM=WLUR.ROLE_ORIG_SYSTEM))

Line 1629: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles

1625: --removed from the local partition either by end_date, or remove all with
1626: --a null end-date (providing there are no active notifications or items).
1627: --
1628: -- Purge Roles
1629: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles
1630: -- by name as determined
1631: open role_orig_system_cursor(orig_system, end_date);
1632: loop
1633: fetch role_orig_system_cursor bulk collect into roleTab LIMIT wf_purge.commit_frequency;

Line 1636: delete from WF_LOCAL_USER_ROLES local

1632: loop
1633: fetch role_orig_system_cursor bulk collect into roleTab LIMIT wf_purge.commit_frequency;
1634: exit when roleTab.COUNT=0;
1635: for idx in roleTab.FIRST..roleTab.LAST loop
1636: delete from WF_LOCAL_USER_ROLES local
1637: where local.ROLE_NAME = roleTab(idx).name
1638: and local.ROLE_ORIG_SYSTEM = roleTab(idx).orig_system
1639: and local.ROLE_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1640:

Line 1661: delete from WF_LOCAL_USER_ROLES local

1657: loop
1658: fetch user_orig_system_cursor bulk collect into roleTab LIMIT wf_purge.commit_frequency;
1659: exit when roleTab.COUNT=0;
1660: for idx in roleTab.FIRST..roleTab.LAST loop
1661: delete from WF_LOCAL_USER_ROLES local
1662: where local.USER_NAME = roleTab(idx).name
1663: and local.USER_ORIG_SYSTEM = roleTab(idx).orig_system
1664: and local.USER_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1665:

Line 1688: delete from WF_LOCAL_USER_ROLES local

1684: fetch expired_rel_orig_system_cursor bulk collect into expRoleTab
1685: limit wf_purge.commit_frequency;
1686: exit when expRoleTab.COUNT=0;
1687: for idx in expRoleTab.FIRST..expRoleTab.LAST loop
1688: delete from WF_LOCAL_USER_ROLES local
1689: where local.USER_NAME = expRoleTab(idx).USER_NAME
1690: and local.USER_ORIG_SYSTEM = expRoleTab(idx).USER_ORIG_SYSTEM
1691: and local.USER_ORIG_SYSTEM_ID = expRoleTab(idx).USER_ORIG_SYSTEM_ID
1692: and local.ROLE_NAME = expRoleTab(idx).ROLE_NAME

Line 1712: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles

1708: close expired_rel_orig_system_cursor;
1709: elsif (end_date is not null) then
1710: --
1711: -- Purge Roles
1712: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles
1713: -- by name as determined
1714: open role_cursor;
1715: loop
1716: fetch role_cursor bulk collect into roleTab limit WF_PURGE.COMMIT_FREQUENCY;

Line 1719: delete from WF_LOCAL_USER_ROLES local

1715: loop
1716: fetch role_cursor bulk collect into roleTab limit WF_PURGE.COMMIT_FREQUENCY;
1717: exit when roleTab.COUNT = 0;
1718: for idx in roleTab.FIRST..roleTab.LAST loop
1719: delete from WF_LOCAL_USER_ROLES local
1720: where local.ROLE_NAME = roleTab(idx).name
1721: and local.ROLE_ORIG_SYSTEM = roleTab(idx).orig_system
1722: and local.ROLE_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1723:

Line 1743: delete from WF_LOCAL_USER_ROLES local

1739: loop
1740: fetch user_cursor bulk collect into roleTab limit WF_PURGE.COMMIT_FREQUENCY;
1741: exit when roleTab.COUNT=0;
1742: for idx in roleTab.FIRST..roleTab.LAST loop
1743: delete from WF_LOCAL_USER_ROLES local
1744: where local.USER_NAME = roleTab(idx).name
1745: and local.USER_ORIG_SYSTEM = roleTab(idx).orig_system
1746: and local.USER_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1747:

Line 1769: delete from WF_LOCAL_USER_ROLES local

1765: fetch expired_rel_cursor bulk collect into expRoleTab limit
1766: WF_PURGE.COMMIT_FREQUENCY;
1767: exit when expRoleTab.COUNT=0;
1768: for idx in expRoleTab.FIRST..expRoleTab.LAST loop
1769: delete from WF_LOCAL_USER_ROLES local
1770: where local.USER_NAME = expRoleTab(idx).USER_NAME
1771: and local.USER_ORIG_SYSTEM = expRoleTab(idx).USER_ORIG_SYSTEM
1772: and local.USER_ORIG_SYSTEM_ID = expRoleTab(idx).USER_ORIG_SYSTEM_ID
1773: and local.ROLE_NAME = expRoleTab(idx).ROLE_NAME