APPS.OE_PURGE_WF dependencies on WF_ITEMS

Line 24: FROM wf_items e

20: CURSOR errors
21: IS
22: SELECT e.item_type,
23: e.item_key
24: FROM wf_items e
25: WHERE ((e.item_type = 'WFERROR'
26: AND e.parent_item_type IN ('OEOH','OEOL','OENH','OEBH'))
27: OR e.item_type ='OMERROR')
28: AND e.end_date IS NULL

Line 40: FROM wf_items e

36: CURSOR specific_error(c_item_key VARCHAR2)
37: IS
38: SELECT e.item_type,
39: e.item_key
40: FROM wf_items e
41: WHERE e.item_type='OMERROR'
42: AND e.end_date IS NULL
43: AND e.item_key =c_item_key
44: AND NOT EXISTS

Line 76: UPDATE wf_items

72: WF_ITEM.Set_Item_Parent(l_errors_tbl(i).ITEM_TYPE,l_errors_tbl(i).ITEM_KEY,NULL,NULL,NULL);
73: wf_engine.abortprocess(itemtype =>l_errors_tbl(i).ITEM_TYPE, itemkey=>l_errors_tbl(i).item_key);
74: EXCEPTION
75: WHEN OTHERS THEN
76: UPDATE wf_items
77: SET end_date = sysdate
78: WHERE item_type=l_errors_tbl(i).ITEM_TYPE
79: AND item_key =l_errors_tbl(i).item_key;
80: END;

Line 112: UPDATE wf_items

108: WF_ITEM.Set_Item_Parent(l_errors_tbl(i).ITEM_TYPE,l_errors_tbl(i).ITEM_KEY,NULL,NULL,NULL);
109: wf_engine.abortprocess(itemtype =>l_errors_tbl(i).ITEM_TYPE, itemkey=>l_errors_tbl(i).item_key);
110: EXCEPTION
111: WHEN OTHERS THEN
112: UPDATE wf_items
113: SET end_date = sysdate
114: WHERE item_type=l_errors_tbl(i).ITEM_TYPE
115: AND item_key =l_errors_tbl(i).item_key;
116: END;

Line 210: FROM WF_ITEMS I

206: CURSOR ERRORS (c_header_id NUMBER)
207: IS
208: SELECT I.ITEM_TYPE,
209: I.ITEM_KEY
210: FROM WF_ITEMS I
211: WHERE I.ITEM_TYPE IN ('OMERROR','WFERROR')
212: AND I.PARENT_ITEM_TYPE = 'OEOH'
213: AND I.PARENT_ITEM_KEY = TO_CHAR(c_header_id)
214: AND I.END_DATE IS NULL FOR UPDATE NOWAIT;

Line 250: UPDATE WF_ITEMS

246: WF_ITEM.Set_Item_Parent(l_error_tbl(j).ITEM_TYPE,l_error_tbl(j).ITEM_KEY,NULL,NULL,NULL);
247: WF_ENGINE.ABORTPROCESS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY);
248: EXCEPTION
249: WHEN OTHERS THEN
250: UPDATE WF_ITEMS
251: SET END_DATE = SYSDATE
252: WHERE item_type=l_error_tbl(j).ITEM_TYPE
253: AND item_key =l_error_tbl(j).ITEM_KEY;
254: END;

Line 323: UPDATE WF_ITEMS

319: WF_ITEM.Set_Item_Parent(l_error_tbl(j).ITEM_TYPE,l_error_tbl(j).ITEM_KEY,NULL,NULL,NULL);
320: WF_ENGINE.ABORTPROCESS(ITEMTYPE =>l_error_tbl(j).ITEM_TYPE, ITEMKEY=>l_error_tbl(j).ITEM_KEY);
321: EXCEPTION
322: WHEN OTHERS THEN
323: UPDATE WF_ITEMS
324: SET END_DATE = SYSDATE
325: WHERE item_type=l_error_tbl(j).ITEM_TYPE
326: AND item_key =l_error_tbl(j).ITEM_KEY;
327: END;

Line 401: FROM wf_items

397: CURSOR to_purge
398: IS
399: SELECT item_type,
400: item_key
401: FROM wf_items
402: WHERE item_type=p_item_type
403: AND end_date <= (SYSDATE-g_age);
404: BEGIN
405: IF g_debug_level > 0 THEN

Line 467: FROM wf_items

463: CURSOR purge_all
464: IS
465: SELECT item_type,
466: item_key
467: FROM wf_items
468: WHERE end_date <= (SYSDATE-g_age)
469: AND item_type IN ('OEOH','OEOL','OENH','OEBH','OMERROR','OEAME'); -- AME ER 16084377
470: BEGIN
471: IF g_debug_level > 0 THEN

Line 492: FROM wf_items

488: IF p_item_key IS NOT NULL THEN
489: BEGIN
490: SELECT end_date
491: INTO l_end_date
492: FROM wf_items
493: WHERE item_type=l_item_type
494: AND item_key =p_item_key;
495: EXCEPTION
496: WHEN No_Data_Found THEN

Line 526: FROM wf_items

522:
523: BEGIN
524: SELECT end_date
525: INTO l_end_date
526: FROM wf_items
527: WHERE item_type=l_item_type
528: AND item_key =p_item_key;
529: EXCEPTION
530: WHEN No_Data_Found THEN