172: BEGIN
173: /* Select the counts for particular batch from all the interface tables */
174: SELECT COUNT(int.sdh_batch_id)
175: INTO l_suppliers_in_batch
176: FROM ap_suppliers_int INT
177: WHERE int.sdh_batch_id = p_batch_id
178: /*AND int.source_system = p_original_system*/
179: ;
180: SELECT COUNT(int.sdh_batch_id)
523:
524: -- Interface Tables
525: fnd_file.put_line(fnd_file.log, ' Purging Interface Tables ... ');
526:
527: DELETE ap_suppliers_int WHERE sdh_batch_id = p_batch_id;
528: COMMIT;
529:
530: DELETE ap_supplier_sites_int WHERE sdh_batch_id = p_batch_id;
531: COMMIT;