APPS.WF_PURGE dependencies on WF_NOTIFICATIONS

Line 325: WF_NOTIFICATIONS WN

321: begin
322: select WN.NOTIFICATION_ID
323: BULK COLLECT into l_tempListTAB
324: from WF_ITEM_ACTIVITY_STATUSES WIAS,
325: WF_NOTIFICATIONS WN
326: where WIAS.ITEM_TYPE = l_itemtypeTAB(j)
327: and WIAS.ITEM_KEY = l_itemkeyTAB(j)
328: and WIAS.NOTIFICATION_ID = WN.GROUP_ID
329: and ((purgesigs = 1)

Line 338: WF_NOTIFICATIONS WN

334: and SIG_OBJ_ID = WN.NOTIFICATION_ID))
335: union all
336: select WN.NOTIFICATION_ID
337: from WF_ITEM_ACTIVITY_STATUSES_H WIASH,
338: WF_NOTIFICATIONS WN
339: where WIASH.ITEM_TYPE = l_itemtypeTAB(j)
340: and WIASH.ITEM_KEY = l_itemkeyTAB(j)
341: and WIASH.NOTIFICATION_ID = WN.GROUP_ID
342: and ((purgesigs = 1)

Line 395: delete from WF_NOTIFICATIONS WN

391: WHERE wc.notification_id = l_nidListTAB(i);
392:
393: begin
394: FORALL i in l_nidListTAB.FIRST..l_nidListTAB.LAST
395: delete from WF_NOTIFICATIONS WN
396: where WN.NOTIFICATION_ID = l_nidListTAB(i);
397: exception when in_other_status_table then
398: -- happens when nid is also in history table
399: -- we will delete this later in the loop

Line 1019: from WF_NOTIFICATIONS WN

1015: -- Cursor to delete all enddated notifications. If the design info for the item
1016: -- is available check for the persistence, if not just delete
1017: cursor c1 is
1018: select WN.NOTIFICATION_ID
1019: from WF_NOTIFICATIONS WN
1020: where WN.MESSAGE_TYPE = itemtype
1021: and not exists
1022: (select NULL
1023: from WF_ITEM_ACTIVITY_STATUSES WIAS

Line 1050: from WF_NOTIFICATIONS WN

1046: and SIG_OBJ_ID = WN.NOTIFICATION_ID));
1047:
1048: cursor c2 is
1049: select WN.NOTIFICATION_ID
1050: from WF_NOTIFICATIONS WN
1051: where not exists
1052: (select NULL
1053: from WF_ITEM_ACTIVITY_STATUSES WIAS
1054: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)

Line 1102: UPDATE wf_notifications wn

1098:
1099: -- End date all the orphan notifications. This end dates all the notifications
1100: -- generated before the enddate parameter value.
1101: loop
1102: UPDATE wf_notifications wn
1103: SET end_date = nvl(begin_date, to_date('2002/08/01','YYYY/MM/DD')) + 1
1104: WHERE NOT EXISTS
1105: (SELECT NULL
1106: FROM wf_item_activity_statuses wias

Line 1177: delete from WF_NOTIFICATIONS WN

1173: WHERE wc.notification_id = l_nidListTAB(j);
1174:
1175: -- Delete notifications
1176: FORALL j in l_nidListTAB.FIRST..l_nidListTAB.LAST
1177: delete from WF_NOTIFICATIONS WN
1178: where WN.NOTIFICATION_ID = l_nidListTAB(j);
1179:
1180: if (l_nidListTAB.COUNT >= wf_purge.commit_frequency) then
1181: exit inner_ntf_loop;

Line 1486: from WF_NOTIFICATIONS wn

1482: where SUPER_NAME = local.NAME
1483: or SUB_NAME = local.NAME)
1484: and not exists
1485: (select NULL
1486: from WF_NOTIFICATIONS wn
1487: where wn.RECIPIENT_ROLE = local.NAME
1488: or wn.ORIGINAL_RECIPIENT = local.NAME);
1489:
1490:

Line 1511: from WF_NOTIFICATIONS wn

1507: where USER_NAME = local.NAME
1508: and RELATIONSHIP_ID <> -1)
1509: and not exists
1510: (select NULL
1511: from WF_NOTIFICATIONS wn
1512: where wn.RECIPIENT_ROLE = local.NAME
1513: or wn.ORIGINAL_RECIPIENT = local.NAME)
1514: and not exists
1515: (select NULL