APPS.WF_PURGE dependencies on WF_LOCAL_ROLES

Line 1475: from WF_LOCAL_ROLES local

1471: --
1472: cursor role_cursor is
1473: select local.NAME, local.ORIG_SYSTEM, local.ORIG_SYSTEM_ID,
1474: local.USER_FLAG
1475: from WF_LOCAL_ROLES local
1476: where PARTITION_ID = 0
1477: and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')
1478: and EXPIRATION_DATE <= end_date
1479: and not exists

Line 1477: and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')

1473: select local.NAME, local.ORIG_SYSTEM, local.ORIG_SYSTEM_ID,
1474: local.USER_FLAG
1475: from WF_LOCAL_ROLES local
1476: where PARTITION_ID = 0
1477: and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')
1478: and EXPIRATION_DATE <= end_date
1479: and not exists
1480: (select NULL
1481: from WF_ROLE_HIERARCHIES

Line 1495: from WF_LOCAL_ROLES local

1491: cursor orig_system_cursor (p_OrigSystem varchar2,
1492: p_endDate date) is
1493: select local.NAME, local.ORIG_SYSTEM, local.ORIG_SYSTEM_ID,
1494: local.USER_FLAG
1495: from WF_LOCAL_ROLES local
1496: where PARTITION_ID = 0
1497: and ORIG_SYSTEM = p_origSystem
1498: and (p_endDate is NULL or EXPIRATION_DATE <= p_endDate)
1499: and not exists

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 1563: delete from WF_LOCAL_ROLES local

1559:
1560: end if;
1561:
1562: --Remove the role
1563: delete from WF_LOCAL_ROLES local
1564: where local.NAME = rcurs2.name
1565: and local.ORIG_SYSTEM = rcurs2.orig_system
1566: and local.ORIG_SYSTEM_ID = rcurs2.orig_system_id;
1567: end loop;

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 1598: delete from WF_LOCAL_ROLES local

1594:
1595: end if;
1596:
1597: --Remove the role
1598: delete from WF_LOCAL_ROLES local
1599: where local.NAME = rcurs.name
1600: and local.ORIG_SYSTEM = rcurs.orig_system
1601: and local.ORIG_SYSTEM_ID = rcurs.orig_system_id;
1602: end loop;