APPS.XDP_PURGE dependencies on XNP_SYNC_REGISTRATION

Line 181: SELECT COUNT(*) INTO l_no_records FROM XNP_SYNC_REGISTRATION

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:

Line 183: RECORDS_PURGED_MSGS(l_no_records,'XNP_SYNC_REGISTRATION 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:
186: IF l_order_exist THEN
187: SELECT wf_item_type,wf_item_key INTO l_wi_type,l_wi_key

Line 811: SELECT COUNT(*) INTO l_temp FROM XNP_SYNC_REGISTRATION

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;

Line 813: RECORDS_PURGED_MSGS(l_temp,'XNP_SYNC_REGISTRATION WHERE 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;
816:
817: IF p_run_mode = 'PURGE' THEN

Line 845: DELETE FROM XNP_SYNC_REGISTRATION

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;