APPS.WF_PURGE dependencies on WF_NOTIFICATIONS

Line 319: WF_NOTIFICATIONS WN

315: begin
316: select WN.NOTIFICATION_ID
317: BULK COLLECT into l_tempListTAB
318: from WF_ITEM_ACTIVITY_STATUSES WIAS,
319: WF_NOTIFICATIONS WN
320: where WIAS.ITEM_TYPE = l_itemtypeTAB(j)
321: and WIAS.ITEM_KEY = l_itemkeyTAB(j)
322: and WIAS.NOTIFICATION_ID = WN.GROUP_ID
323: and ((purgesigs = 1)

Line 332: WF_NOTIFICATIONS WN

328: and SIG_OBJ_ID = WN.NOTIFICATION_ID))
329: union all
330: select WN.NOTIFICATION_ID
331: from WF_ITEM_ACTIVITY_STATUSES_H WIASH,
332: WF_NOTIFICATIONS WN
333: where WIASH.ITEM_TYPE = l_itemtypeTAB(j)
334: and WIASH.ITEM_KEY = l_itemkeyTAB(j)
335: and WIASH.NOTIFICATION_ID = WN.GROUP_ID
336: and ((purgesigs = 1)

Line 389: delete from WF_NOTIFICATIONS WN

385: WHERE wc.notification_id = l_nidListTAB(i);
386:
387: begin
388: FORALL i in l_nidListTAB.FIRST..l_nidListTAB.LAST
389: delete from WF_NOTIFICATIONS WN
390: where WN.NOTIFICATION_ID = l_nidListTAB(i);
391: exception when in_other_status_table then
392: -- happens when nid is also in history table
393: -- we will delete this later in the loop

Line 1032: from WF_NOTIFICATIONS WN

1028: -- Cursor to delete all enddated notifications. If the design info for the item
1029: -- is available check for the persistence, if not just delete
1030: cursor c1 is
1031: select WN.NOTIFICATION_ID
1032: from WF_NOTIFICATIONS WN
1033: where WN.MESSAGE_TYPE = itemtype
1034: and not exists
1035: (select NULL
1036: from WF_ITEM_ACTIVITY_STATUSES WIAS

Line 1063: from WF_NOTIFICATIONS WN

1059: and SIG_OBJ_ID = WN.NOTIFICATION_ID));
1060:
1061: cursor c2 is
1062: select WN.NOTIFICATION_ID
1063: from WF_NOTIFICATIONS WN
1064: where not exists
1065: (select NULL
1066: from WF_ITEM_ACTIVITY_STATUSES WIAS
1067: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)

Line 1115: UPDATE wf_notifications wn

1111:
1112: -- End date all the orphan notifications. This end dates all the notifications
1113: -- generated before the enddate parameter value.
1114: loop
1115: UPDATE wf_notifications wn
1116: SET end_date = nvl(begin_date, to_date('2002/08/01','YYYY/MM/DD')) + 1
1117: WHERE NOT EXISTS
1118: (SELECT NULL
1119: FROM wf_item_activity_statuses wias

Line 1192: delete from WF_NOTIFICATIONS WN

1188: WHERE wc.notification_id = l_nidListTAB(j);
1189:
1190: -- Delete notifications
1191: FORALL j in l_nidListTAB.FIRST..l_nidListTAB.LAST
1192: delete from WF_NOTIFICATIONS WN
1193: where WN.NOTIFICATION_ID = l_nidListTAB(j);
1194:
1195: if (l_nidListTAB.COUNT >= wf_purge.commit_frequency) then
1196: exit inner_ntf_loop;

Line 1510: from WF_NOTIFICATIONS wn

1506: and EXPIRATION_DATE <= end_date
1507: and local.USER_FLAG='Y'
1508: and not exists
1509: (select NULL
1510: from WF_NOTIFICATIONS wn
1511: where wn.RECIPIENT_ROLE = local.NAME
1512: or wn.ORIGINAL_RECIPIENT = local.NAME);
1513:
1514: --Bug 16054955. This cursor is to purge ad-hoc ROLES and related data

Line 1528: from WF_NOTIFICATIONS wn

1524: where SUPER_NAME = local.NAME
1525: or SUB_NAME = local.NAME)
1526: and not exists
1527: (select NULL
1528: from WF_NOTIFICATIONS wn
1529: where wn.RECIPIENT_ROLE = local.NAME
1530: or wn.ORIGINAL_RECIPIENT = local.NAME);
1531:
1532: -- Similar to role_cursor for orig systems different from WF_LOCAL_ROLES

Line 1547: from WF_NOTIFICATIONS wn

1543: where SUPER_NAME = local.NAME
1544: or SUB_NAME = local.NAME)
1545: and not exists
1546: (select NULL
1547: from WF_NOTIFICATIONS wn
1548: where wn.RECIPIENT_ROLE = local.NAME
1549: or wn.ORIGINAL_RECIPIENT = local.NAME);
1550:
1551: -- Similar to user_cursor for orig systems different from WF_LOCAL_USERS

Line 1566: from WF_NOTIFICATIONS wn

1562: where USER_NAME = local.NAME
1563: and RELATIONSHIP_ID <> -1)
1564: and not exists
1565: (select NULL
1566: from WF_NOTIFICATIONS wn
1567: where wn.RECIPIENT_ROLE = local.NAME
1568: or wn.ORIGINAL_RECIPIENT = local.NAME)
1569: and not exists
1570: (select NULL