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_ITEM_ACTIVITY_STATUSES

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 324: from WF_ITEM_ACTIVITY_STATUSES WIAS,

320: FOR j IN l_itemkeyTAB.FIRST..l_itemkeyTAB.LAST loop
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

Line 337: from WF_ITEM_ACTIVITY_STATUSES_H WIASH,

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

Line 416: delete from WF_ITEM_ACTIVITY_STATUSES_H

412:
413: begin
414: --delete all status history.
415: FORALL j IN l_itemkeyTAB.FIRST..l_itemkeyTAB.LAST
416: delete from WF_ITEM_ACTIVITY_STATUSES_H
417: where ITEM_TYPE = l_itemtypeTAB(j)
418: and ITEM_KEY = l_itemkeyTAB(j);
419:
420: --delete all statuses.

Line 422: delete from WF_ITEM_ACTIVITY_STATUSES

418: and ITEM_KEY = l_itemkeyTAB(j);
419:
420: --delete all statuses.
421: FORALL j IN l_itemkeyTAB.FIRST..l_itemkeyTAB.LAST
422: delete from WF_ITEM_ACTIVITY_STATUSES
423: where ITEM_TYPE = l_itemtypeTAB(j)
424: and ITEM_KEY = l_itemkeyTAB(j);
425:
426: --delete item attributes

Line 1023: from WF_ITEM_ACTIVITY_STATUSES WIAS

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
1024: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1025: and not exists
1026: (select NULL
1027: from WF_ITEM_ACTIVITY_STATUSES_H WIAS

Line 1027: from WF_ITEM_ACTIVITY_STATUSES_H WIAS

1023: from WF_ITEM_ACTIVITY_STATUSES WIAS
1024: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1025: and not exists
1026: (select NULL
1027: from WF_ITEM_ACTIVITY_STATUSES_H WIAS
1028: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1029: and (
1030: exists(
1031: select null

Line 1053: from WF_ITEM_ACTIVITY_STATUSES WIAS

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)
1055: and not exists
1056: (select NULL
1057: from WF_ITEM_ACTIVITY_STATUSES_H WIAS

Line 1057: from WF_ITEM_ACTIVITY_STATUSES_H WIAS

1053: from WF_ITEM_ACTIVITY_STATUSES WIAS
1054: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1055: and not exists
1056: (select NULL
1057: from WF_ITEM_ACTIVITY_STATUSES_H WIAS
1058: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1059: and (
1060: exists(
1061: select null

Line 1106: FROM wf_item_activity_statuses wias

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
1107: WHERE wias.notification_id = wn.group_id)
1108: AND NOT EXISTS
1109: (SELECT NULL
1110: FROM wf_item_activity_statuses_h wiash

Line 1110: FROM wf_item_activity_statuses_h wiash

1106: FROM wf_item_activity_statuses wias
1107: WHERE wias.notification_id = wn.group_id)
1108: AND NOT EXISTS
1109: (SELECT NULL
1110: FROM wf_item_activity_statuses_h wiash
1111: WHERE wiash.notification_id = wn.group_id)
1112: AND wn.end_date is null
1113: AND wn.begin_date <= enddate
1114: AND rownum < Wf_Purge.Commit_Frequency;

Line 1690: from wf_item_activity_statuses wias, wf_items wi

1686: c_item_key varchar2(240);
1687:
1688: cursor c_error1 is
1689: select wi.item_key
1690: from wf_item_activity_statuses wias, wf_items wi
1691: where wi.item_type = 'WFERROR'
1692: and parent_item_type = itemtype
1693: and wi.parent_item_type = wias.item_type
1694: and wi.parent_item_key = wias.item_key

Line 1700: from wf_item_activity_statuses wias, wf_items wi

1696: and wias.activity_status = 'COMPLETE';
1697:
1698: cursor c_error2 is
1699: select wi.item_key
1700: from wf_item_activity_statuses wias, wf_items wi
1701: where wi.item_type = 'WFERROR'
1702: and parent_item_type = itemtype
1703: and parent_item_key = itemkey
1704: and wi.parent_item_type = wias.item_type

Line 1711: from wf_item_activity_statuses wias, wf_items wi

1707: and wias.activity_status = 'COMPLETE';
1708:
1709: cursor c_error3 is
1710: select wi.item_key
1711: from wf_item_activity_statuses wias, wf_items wi
1712: where wi.item_type = 'WFERROR'
1713: and wi.parent_item_type = wias.item_type
1714: and wi.parent_item_key = wias.item_key
1715: and wi.parent_context = wias.process_activity