APPS.WF_PURGE dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 25: -- Delete from wf_item_activity_statuses and wf_item_activity_statuses_h

21: end Move_To_History;
22:
23: --
24: -- procedure Item_Activity_Statuses
25: -- Delete from wf_item_activity_statuses and wf_item_activity_statuses_h
26: -- where end_date before argument.
27: -- IN:
28: -- itemtype - Item type to delete, or null for all itemtypes
29: -- itemkey - Item key to delete, or null for all itemkeys

Line 331: from WF_ITEM_ACTIVITY_STATUSES_H WIASH,

327: where SIG_OBJ_TYPE = 'WF_NTF'
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

Line 410: delete from WF_ITEM_ACTIVITY_STATUSES_H

406:
407: begin
408: --delete all status history.
409: FORALL j IN l_itemkeyTAB.FIRST..l_itemkeyTAB.LAST
410: delete from WF_ITEM_ACTIVITY_STATUSES_H
411: where ITEM_TYPE = l_itemtypeTAB(j)
412: and ITEM_KEY = l_itemkeyTAB(j);
413:
414: --delete all statuses.

Line 1040: from WF_ITEM_ACTIVITY_STATUSES_H WIAS

1036: from WF_ITEM_ACTIVITY_STATUSES WIAS
1037: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1038: and not exists
1039: (select NULL
1040: from WF_ITEM_ACTIVITY_STATUSES_H WIAS
1041: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1042: and (
1043: exists(
1044: select null

Line 1070: from WF_ITEM_ACTIVITY_STATUSES_H WIAS

1066: from WF_ITEM_ACTIVITY_STATUSES WIAS
1067: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1068: and not exists
1069: (select NULL
1070: from WF_ITEM_ACTIVITY_STATUSES_H WIAS
1071: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1072: and (
1073: exists(
1074: select null

Line 1123: FROM wf_item_activity_statuses_h wiash

1119: FROM wf_item_activity_statuses wias
1120: WHERE wias.notification_id = wn.group_id)
1121: AND NOT EXISTS
1122: (SELECT NULL
1123: FROM wf_item_activity_statuses_h wiash
1124: WHERE wiash.notification_id = wn.group_id)
1125: AND wn.end_date is null
1126: AND wn.begin_date <= enddate
1127: AND rownum < Wf_Purge.Commit_Frequency;