226: DELETE HZ_IMP_FINNUMBERS_SG WHERE batch_id = p_batch_id;
227: COMMIT;
228:
229: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_FINNUMBERS_SG (-)');
230: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_FINREPORTS_SG (+)');
231:
232: DELETE HZ_IMP_FINREPORTS_SG WHERE batch_id = p_batch_id;
233: COMMIT;
234:
228:
229: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_FINNUMBERS_SG (-)');
230: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_FINREPORTS_SG (+)');
231:
232: DELETE HZ_IMP_FINREPORTS_SG WHERE batch_id = p_batch_id;
233: COMMIT;
234:
235: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_FINREPORTS_SG (-)');
236: FND_FILE.put_line(fnd_file.log,' Purged Staging Tables ... ');
231:
232: DELETE HZ_IMP_FINREPORTS_SG WHERE batch_id = p_batch_id;
233: COMMIT;
234:
235: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_FINREPORTS_SG (-)');
236: FND_FILE.put_line(fnd_file.log,' Purged Staging Tables ... ');
237:
238: -- Error Tables
239: FND_FILE.put_line(fnd_file.log,' Purging Error Tables ... ');