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 1536: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles

1532: --removed from the local partition either by end_date, or remove all with
1533: --a null end-date (providing there are no active notifications or items).
1534: --
1535: -- Purge Roles
1536: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles
1537: -- by name as determined
1538: for rcurs2 in orig_system_cursor(orig_system, end_date) loop
1539: if (rcurs2.user_flag = 'Y') then
1540: delete from WF_LOCAL_USER_ROLES local

Line 1540: delete from WF_LOCAL_USER_ROLES local

1536: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles
1537: -- by name as determined
1538: for rcurs2 in orig_system_cursor(orig_system, end_date) loop
1539: if (rcurs2.user_flag = 'Y') then
1540: delete from WF_LOCAL_USER_ROLES local
1541: where local.USER_NAME = rcurs2.name
1542: and local.USER_ORIG_SYSTEM = rcurs2.orig_system
1543: and local.USER_ORIG_SYSTEM_ID = rcurs2.orig_system_id;
1544:

Line 1550: delete from WF_LOCAL_USER_ROLES local

1546: where local.USER_NAME = rcurs2.name
1547: and local.USER_ORIG_SYSTEM = rcurs2.orig_system
1548: and local.USER_ORIG_SYSTEM_ID = rcurs2.orig_system_id;
1549: else
1550: delete from WF_LOCAL_USER_ROLES local
1551: where local.ROLE_NAME = rcurs2.name
1552: and local.ROLE_ORIG_SYSTEM = rcurs2.orig_system
1553: and local.ROLE_ORIG_SYSTEM_ID = rcurs2.orig_system_id;
1554:

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

1567: end loop;
1568: elsif (end_date is not null) then
1569: --
1570: -- Purge Roles
1571: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles
1572: -- by name as determined
1573: for rcurs in role_cursor loop
1574: if (rcurs.user_flag = 'Y') then
1575: delete from WF_LOCAL_USER_ROLES local

Line 1575: delete from WF_LOCAL_USER_ROLES local

1571: -- Delete rows in wf_local_user_roles by role_name and wf_local_roles
1572: -- by name as determined
1573: for rcurs in role_cursor loop
1574: if (rcurs.user_flag = 'Y') then
1575: delete from WF_LOCAL_USER_ROLES local
1576: where local.USER_NAME = rcurs.name
1577: and local.USER_ORIG_SYSTEM = rcurs.orig_system
1578: and local.USER_ORIG_SYSTEM_ID = rcurs.orig_system_id;
1579:

Line 1585: delete from WF_LOCAL_USER_ROLES local

1581: where local.USER_NAME = rcurs.name
1582: and local.USER_ORIG_SYSTEM = rcurs.orig_system
1583: and local.USER_ORIG_SYSTEM_ID = rcurs.orig_system_id;
1584: else
1585: delete from WF_LOCAL_USER_ROLES local
1586: where local.ROLE_NAME = rcurs.name
1587: and local.ROLE_ORIG_SYSTEM = rcurs.orig_system
1588: and local.ROLE_ORIG_SYSTEM_ID = rcurs.orig_system_id;
1589: