177: WHERE ORDER_ID = p_order_id;
178: RECORDS_PURGED_MSGS(l_no_records,'XNP_TIMER_REGISTRY WHERE ORDER_ID = '||p_order_id,
179: 'XDP_FOUND_REC',0);
180:
181: SELECT COUNT(*) INTO l_no_records FROM XNP_SYNC_REGISTRATION
182: WHERE ORDER_ID = p_order_id;
183: RECORDS_PURGED_MSGS(l_no_records,'XNP_SYNC_REGISTRATION WHERE ORDER_ID = '||p_order_id,
184: 'XDP_FOUND_REC',0);
185:
179: 'XDP_FOUND_REC',0);
180:
181: SELECT COUNT(*) INTO l_no_records FROM XNP_SYNC_REGISTRATION
182: WHERE ORDER_ID = p_order_id;
183: RECORDS_PURGED_MSGS(l_no_records,'XNP_SYNC_REGISTRATION WHERE ORDER_ID = '||p_order_id,
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
807: SELECT COUNT(*) INTO l_temp FROM XNP_TIMER_REGISTRY
808: WHERE order_id = p_order_id;
809: RECORDS_PURGED_MSGS(l_temp,'XNP_TIMER_REGISTRY WHERE ORDER_ID = '
810: ||p_order_id ,l_rec_name,0);
811: SELECT COUNT(*) INTO l_temp FROM XNP_SYNC_REGISTRATION
812: WHERE order_id = p_order_id;
813: RECORDS_PURGED_MSGS(l_temp,'XNP_SYNC_REGISTRATION WHERE ORDER_ID = '
814: ||p_order_id ,l_rec_name,0);
815: END IF;
809: RECORDS_PURGED_MSGS(l_temp,'XNP_TIMER_REGISTRY WHERE ORDER_ID = '
810: ||p_order_id ,l_rec_name,0);
811: SELECT COUNT(*) INTO l_temp FROM XNP_SYNC_REGISTRATION
812: WHERE order_id = p_order_id;
813: RECORDS_PURGED_MSGS(l_temp,'XNP_SYNC_REGISTRATION WHERE ORDER_ID = '
814: ||p_order_id ,l_rec_name,0);
815: END IF;
816:
817: IF p_run_mode = 'PURGE' THEN
841: WHERE order_id = p_order_id;
842:
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;