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.OE_PURGE_WF dependencies on WF_ITEM

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 31: FROM wf_item_activity_statuses s

27: OR e.item_type ='OMERROR')
28: AND e.end_date IS NULL
29: AND NOT EXISTS
30: (SELECT 1
31: FROM wf_item_activity_statuses s
32: WHERE s.item_type = e.parent_item_type
33: AND s.item_key = e.parent_item_key
34: AND s.activity_status = 'ERROR'
35: );

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 46: FROM wf_item_activity_statuses s

42: AND e.end_date IS NULL
43: AND e.item_key =c_item_key
44: AND NOT EXISTS
45: (SELECT 1
46: FROM wf_item_activity_statuses s
47: WHERE s.item_type = e.parent_item_type
48: AND s.item_key = e.parent_item_key
49: AND s.activity_status = 'ERROR'
50: );

Line 72: WF_ITEM.Set_Item_Parent(l_errors_tbl(i).ITEM_TYPE,l_errors_tbl(i).ITEM_KEY,NULL,NULL,NULL);

68: BEGIN
69: IF g_debug_level > 0 THEN
70: oe_debug_pub.add( 'Setting the error parent to null and aborting the flow',5);
71: END IF ;
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

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 108: WF_ITEM.Set_Item_Parent(l_errors_tbl(i).ITEM_TYPE,l_errors_tbl(i).ITEM_KEY,NULL,NULL,NULL);

104: BEGIN
105: IF g_debug_level > 0 THEN
106: oe_debug_pub.add( 'Setting the error parent to null and aborting the flow for the specific key',5);
107: END IF ;
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

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 169: FROM WF_ITEM_ACTIVITY_STATUSES WAS,

165: SELECT P.INSTANCE_LABEL,
166: WAS.ITEM_KEY,
167: H.ORDER_NUMBER,
168: H.ORG_ID
169: FROM WF_ITEM_ACTIVITY_STATUSES WAS,
170: WF_PROCESS_ACTIVITIES P,
171: OE_ORDER_HEADERS_ALL H
172: WHERE TO_NUMBER(WAS.ITEM_KEY) = H.HEADER_ID
173: AND WAS.PROCESS_ACTIVITY = P.INSTANCE_ID

Line 190: FROM WF_ITEM_ACTIVITY_STATUSES WAS,

186: SELECT P.INSTANCE_LABEL,
187: WAS.ITEM_KEY,
188: H.ORDER_NUMBER,
189: H.ORG_ID
190: FROM WF_ITEM_ACTIVITY_STATUSES WAS,
191: WF_PROCESS_ACTIVITIES P,
192: OE_ORDER_HEADERS_ALL H
193: WHERE TO_NUMBER(WAS.ITEM_KEY) = H.HEADER_ID
194: AND WAS.PROCESS_ACTIVITY = P.INSTANCE_ID

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 246: WF_ITEM.Set_Item_Parent(l_error_tbl(j).ITEM_TYPE,l_error_tbl(j).ITEM_KEY,NULL,NULL,NULL);

242: BEGIN
243: IF g_debug_level > 0 THEN
244: oe_debug_pub.ADD('Clearing the parent info from the error and aborting the error flow.',1 ) ;
245: END IF;
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

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 319: WF_ITEM.Set_Item_Parent(l_error_tbl(j).ITEM_TYPE,l_error_tbl(j).ITEM_KEY,NULL,NULL,NULL);

315: BEGIN
316: IF g_debug_level > 0 THEN
317: oe_debug_pub.ADD('Removing the parent reference and aborting the error flow',1 ) ;
318: END IF;
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

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