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

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

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 416: delete from WF_ITEM_ACTIVITY_STATUSES

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

Line 1036: from WF_ITEM_ACTIVITY_STATUSES WIAS

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
1037: where WIAS.NOTIFICATION_ID = WN.GROUP_ID)
1038: and not exists
1039: (select NULL
1040: from WF_ITEM_ACTIVITY_STATUSES_H WIAS

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

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)
1068: and not exists
1069: (select NULL
1070: from WF_ITEM_ACTIVITY_STATUSES_H WIAS

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 1119: FROM wf_item_activity_statuses wias

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
1120: WHERE wias.notification_id = wn.group_id)
1121: AND NOT EXISTS
1122: (SELECT NULL
1123: FROM wf_item_activity_statuses_h wiash

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;

Line 1893: from wf_item_activity_statuses wias, wf_items wi

1889:
1890: -- Bug 11728665, added null statement to improve performance of c_errorX cursors.
1891: cursor c_error1 is
1892: select wi.item_key
1893: from wf_item_activity_statuses wias, wf_items wi
1894: where wi.item_type = 'WFERROR'
1895: and parent_item_type = itemtype
1896: and wi.parent_item_type = wias.item_type
1897: and wi.parent_item_key = wias.item_key

Line 1904: from wf_item_activity_statuses wias, wf_items wi

1900: and wias.activity_status = 'COMPLETE';
1901:
1902: cursor c_error2 is
1903: select wi.item_key
1904: from wf_item_activity_statuses wias, wf_items wi
1905: where wi.item_type = 'WFERROR'
1906: and parent_item_type = itemtype
1907: and parent_item_key = itemkey
1908: and wi.parent_item_type = wias.item_type

Line 1916: from wf_item_activity_statuses wias, wf_items wi

1912: and wias.activity_status = 'COMPLETE';
1913:
1914: cursor c_error3 is
1915: select wi.item_key
1916: from wf_item_activity_statuses wias, wf_items wi
1917: where wi.item_type = 'WFERROR'
1918: and wi.parent_item_type = wias.item_type
1919: and wi.parent_item_key = wias.item_key
1920: and wi.parent_context = wias.process_activity