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.XDP_PURGE dependencies on XDP_ORDER_HEADERS

Line 137: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_HEADERS

133:
134: RETURN;
135: END IF;
136:
137: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_HEADERS
138: WHERE ORDER_ID = p_order_id;
139:
140: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_HEADERS WHERE ORDER_ID = '||p_order_id,
141: 'XDP_FOUND_REC',0);

Line 140: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_HEADERS WHERE ORDER_ID = '||p_order_id,

136:
137: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_HEADERS
138: WHERE ORDER_ID = p_order_id;
139:
140: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_HEADERS WHERE ORDER_ID = '||p_order_id,
141: 'XDP_FOUND_REC',0);
142:
143: IF l_no_records > 0 THEN
144: l_order_exist := TRUE;

Line 188: FROM XDP_ORDER_HEADERS

184: 'XDP_FOUND_REC',0);
185:
186: IF l_order_exist THEN
187: SELECT wf_item_type,wf_item_key INTO l_wi_type,l_wi_key
188: FROM XDP_ORDER_HEADERS
189: WHERE ORDER_ID = p_order_id;
190:
191: SELECT count(*) INTO l_no_records
192: FROM WF_ITEMS

Line 368: p_order_id IN XDP_ORDER_HEADERS.ORDER_ID%TYPE,

364: -- Name IS_ORDER_DELETABLE
365: --
366:
367: PROCEDURE IS_ORDER_DELETABLE(
368: p_order_id IN XDP_ORDER_HEADERS.ORDER_ID%TYPE,
369: p_date_from IN DATE,
370: p_date_to IN DATE,
371: p_order_deletable OUT NOCOPY VARCHAR2
372: ) IS

Line 385: l_order_state XDP_ORDER_HEADERS.STATUS_CODE%TYPE;

381: FROM XDP_ORDER_RELATIONSHIPS
382: START WITH ORDER_ID = p_order_id
383: CONNECT BY PRIOR RELATED_ORDER_ID = ORDER_ID;
384:
385: l_order_state XDP_ORDER_HEADERS.STATUS_CODE%TYPE;
386: --l_order_state XDP_ORDER_HEADERS.ORDER_ID%TYPE;
387: l_completion_date DATE;
388:
389: BEGIN

Line 386: --l_order_state XDP_ORDER_HEADERS.ORDER_ID%TYPE;

382: START WITH ORDER_ID = p_order_id
383: CONNECT BY PRIOR RELATED_ORDER_ID = ORDER_ID;
384:
385: l_order_state XDP_ORDER_HEADERS.STATUS_CODE%TYPE;
386: --l_order_state XDP_ORDER_HEADERS.ORDER_ID%TYPE;
387: l_completion_date DATE;
388:
389: BEGIN
390: p_order_deletable :='FALSE';

Line 399: FROM XDP_ORDER_HEADERS

395: /* SELECT status_code,
396: completion_date
397: INTO l_order_state,
398: l_completion_date
399: FROM XDP_ORDER_HEADERS
400: WHERE order_id = l_order_relation.related_order_id; */
401:
402: SELECT status_code,
403: NVL(completion_date, CANCEL_PROVISIONING_DATE)

Line 406: FROM XDP_ORDER_HEADERS

402: SELECT status_code,
403: NVL(completion_date, CANCEL_PROVISIONING_DATE)
404: INTO l_order_state,
405: l_completion_date
406: FROM XDP_ORDER_HEADERS
407: WHERE order_id = l_order_relation.related_order_id;
408:
409: IF (l_completion_date < p_date_from) OR
410: (l_completion_date > p_date_to) OR

Line 542: p_order_id IN XDP_ORDER_HEADERS.ORDER_ID%TYPE,

538: --
539:
540: PROCEDURE DELETE_LINE_ITEMS
541: (
542: p_order_id IN XDP_ORDER_HEADERS.ORDER_ID%TYPE,
543: p_run_mode IN VARCHAR2
544: ) IS
545:
546: CURSOR c_line_item IS

Line 628: l_wi_type XDP_ORDER_HEADERS.WF_ITEM_TYPE%TYPE;

624: AND item_key = p_wi_key
625: CONNECT BY PRIOR item_key = parent_item_key
626: AND PRIOR item_type = parent_item_type;
627:
628: l_wi_type XDP_ORDER_HEADERS.WF_ITEM_TYPE%TYPE;
629: l_wi_key XDP_ORDER_HEADERS.WF_ITEM_KEY%TYPE;
630: l_counter NUMBER := 0;
631: l_rec_name VARCHAR2(16) := 'XDP_FOUND_REC';
632: l_wi_name VARCHAR2(16) := 'XDP_FOUND_WI';

Line 629: l_wi_key XDP_ORDER_HEADERS.WF_ITEM_KEY%TYPE;

625: CONNECT BY PRIOR item_key = parent_item_key
626: AND PRIOR item_type = parent_item_type;
627:
628: l_wi_type XDP_ORDER_HEADERS.WF_ITEM_TYPE%TYPE;
629: l_wi_key XDP_ORDER_HEADERS.WF_ITEM_KEY%TYPE;
630: l_counter NUMBER := 0;
631: l_rec_name VARCHAR2(16) := 'XDP_FOUND_REC';
632: l_wi_name VARCHAR2(16) := 'XDP_FOUND_WI';
633:

Line 658: FROM XDP_ORDER_HEADERS

654:
655: SELECT wf_item_type,
656: wf_item_key
657: INTO l_wi_type,l_wi_key
658: FROM XDP_ORDER_HEADERS
659: WHERE ORDER_ID = p_order_id;
660:
661: IF SQL%NOTFOUND THEN
662: RETURN;

Line 764: SELECT 1 INTO l_dummy FROM XDP_ORDER_HEADERS

760: FND_MESSAGE.SET_NAME('XDP','XDP_PURGE_ORD');
761: FND_MESSAGE.SET_TOKEN('ORDER_ID',p_order_id);
762: PURGE_ERRORS(FND_MESSAGE.GET);
763:
764: SELECT 1 INTO l_dummy FROM XDP_ORDER_HEADERS
765: WHERE order_id = p_order_id for update nowait;
766:
767: DELETE_LINE_ITEMS(p_order_id,p_run_mode);
768: DELETE_WF_ITEMS(p_order_id,p_run_mode);

Line 847: DELETE FROM XDP_ORDER_HEADERS

843: DELETE FROM XNP_TIMER_REGISTRY
844: WHERE order_id = p_order_id;
845: DELETE FROM XNP_SYNC_REGISTRATION
846: WHERE order_id = p_order_id ;
847: DELETE FROM XDP_ORDER_HEADERS
848: WHERE order_id = p_order_id ;
849: -- COMMIT;
850: END IF;
851: EXCEPTION

Line 891: SELECT ORDER_ID FROM XDP_ORDER_HEADERS

887: --Date: 09 AUG 2006 Author: DPUTHIYE Bug #:5446335
888: --This SQL should consider CANCEL_PROVISIONING_DATE for cancelled orders as well.
889: --Dependencies: None.
890: /* CURSOR c_order(p_time_from IN DATE,p_time_to IN DATE) IS
891: SELECT ORDER_ID FROM XDP_ORDER_HEADERS
892: WHERE STATUS_CODE IN ('SUCCESS','SUCCESS_WITH_OVERRIDE','ABORTED','CANCELED')
893: AND COMPLETION_DATE < p_time_to
894: AND COMPLETION_DATE > p_time_from; */
895:

Line 897: SELECT ORDER_ID FROM XDP_ORDER_HEADERS

893: AND COMPLETION_DATE < p_time_to
894: AND COMPLETION_DATE > p_time_from; */
895:
896: CURSOR c_order(p_time_from IN DATE,p_time_to IN DATE) IS
897: SELECT ORDER_ID FROM XDP_ORDER_HEADERS
898: WHERE STATUS_CODE IN ('SUCCESS','SUCCESS_WITH_OVERRIDE','ABORTED','CANCELED')
899: AND NVL(COMPLETION_DATE, CANCEL_PROVISIONING_DATE) < p_time_to
900: AND NVL(COMPLETION_DATE, CANCEL_PROVISIONING_DATE) > p_time_from;
901:

Line 904: l_order_id XDP_ORDER_HEADERS.ORDER_ID%TYPE;

900: AND NVL(COMPLETION_DATE, CANCEL_PROVISIONING_DATE) > p_time_from;
901:
902: l_temp NUMBER := 0;
903:
904: l_order_id XDP_ORDER_HEADERS.ORDER_ID%TYPE;
905:
906: l_order_deletable VARCHAR2(6);
907: l_exception_counter NUMBER := 0;
908: l_user_rollback BOOLEAN := FALSE;

Line 925: /* SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_HEADERS

921: IF p_run_mode ='CHECK' THEN
922: --Date: 09 AUG 2006 Author: DPUTHIYE Bug #:5446335
923: --This SQL should consider CANCEL_PROVISIONING_DATE for cancelled orders as well.
924: --Dependencies: None.
925: /* SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_HEADERS
926: WHERE STATUS_CODE IN ('SUCCESS','SUCCESS_WITH_OVERRIDE','ABORTED','CANCELED')
927: AND COMPLETION_DATE < p_time_to
928: AND COMPLETION_DATE > p_time_from; */
929:

Line 930: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_HEADERS

926: WHERE STATUS_CODE IN ('SUCCESS','SUCCESS_WITH_OVERRIDE','ABORTED','CANCELED')
927: AND COMPLETION_DATE < p_time_to
928: AND COMPLETION_DATE > p_time_from; */
929:
930: SELECT COUNT(*) INTO l_temp FROM XDP_ORDER_HEADERS
931: WHERE STATUS_CODE IN ('SUCCESS','SUCCESS_WITH_OVERRIDE','ABORTED','CANCELED')
932: AND NVL(COMPLETION_DATE, CANCEL_PROVISIONING_DATE) < p_time_to
933: AND NVL(COMPLETION_DATE, CANCEL_PROVISIONING_DATE) > p_time_from;
934:

Line 1012: RECORDS_PURGED_MSGS(x_orders_purged,'XDP_ORDER_HEADERS',l_rec_name,-1);

1008: IF (c_order%ISOPEN) THEN
1009: CLOSE c_order;
1010: END IF;
1011: END LOOP OUTER_LOOP;
1012: RECORDS_PURGED_MSGS(x_orders_purged,'XDP_ORDER_HEADERS',l_rec_name,-1);
1013: l_mini_secs := DBMS_UTILITY.get_time - l_mini_secs;
1014: PURGE_ERRORS('Total '||l_mini_secs/100 || ' seconds used to purge orders');
1015: PURGE_ERRORS((G_Total_WK_TIME/100) || ' seconds used to purge workflow items for these orders');
1016: COMMIT;

Line 1077: AND NOT Exists (SELECT ORDER_ID from xdp_order_headers where (order_id=m.order_id))

1073: WHERE
1074: (M.MSG_STATUS IN ('PROCESSED','TIME_OUT'))
1075: AND MSG_CREATION_DATE < p_time_to
1076: AND MSG_CREATION_DATE > p_time_from
1077: AND NOT Exists (SELECT ORDER_ID from xdp_order_headers where (order_id=m.order_id))
1078: FOR UPDATE OF MSG_ID NOWAIT;
1079:
1080: l_xnp_msg XNP_MSGS.MSG_ID%TYPE;
1081:

Line 1106: AND NOT Exists (SELECT ORDER_ID from xdp_order_headers where (order_id=m.order_id));

1102: -- 03/30/2001. Modified. Replaced CREATION_DATE with MSG_CREATION_DATE. rnyberg
1103: MSG_STATUS IN ('PROCESSED','TIME_OUT')
1104: AND MSG_CREATION_DATE < p_time_to
1105: AND MSG_CREATION_DATE > p_time_from
1106: AND NOT Exists (SELECT ORDER_ID from xdp_order_headers where (order_id=m.order_id));
1107: END IF;
1108: RECORDS_PURGED_MSGS(l_no_msgs,'XNP_MSGS',l_rec_name,-1);
1109: RETURN;
1110: END IF;

Line 1676: RECORDS_PURGED_MSGS(l_orders_purged,'XDP_ORDER_HEADERS','ORDER',-1);

1672: XDP_PURGE_ORDERS(l_time_from,l_time_to,p_run_mode,
1673: l_purge_order_with_msg,
1674: l_rollback_segment,l_orders_purged);
1675:
1676: RECORDS_PURGED_MSGS(l_orders_purged,'XDP_ORDER_HEADERS','ORDER',-1);
1677: END IF;
1678:
1679: IF INSTR(p_purge_data_set,'SOA') <> 0 THEN
1680: XDP_PURGE_SOA(l_time_from,l_time_to,p_run_mode,l_rollback_segment);