258:
259: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_WORK_UNITS (-)');
260:
261: -- Bug No 3310475
262: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_OSR_CHANGE (+)');
263: DELETE HZ_IMP_OSR_CHANGE WHERE batch_id = p_batch_id;
264: COMMIT;
265: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_OSR_CHANGE (-)');
266: FND_FILE.put_line(fnd_file.log,' Purge Ends ... ');
259: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_WORK_UNITS (-)');
260:
261: -- Bug No 3310475
262: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_OSR_CHANGE (+)');
263: DELETE HZ_IMP_OSR_CHANGE WHERE batch_id = p_batch_id;
264: COMMIT;
265: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_OSR_CHANGE (-)');
266: FND_FILE.put_line(fnd_file.log,' Purge Ends ... ');
267:
261: -- Bug No 3310475
262: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_OSR_CHANGE (+)');
263: DELETE HZ_IMP_OSR_CHANGE WHERE batch_id = p_batch_id;
264: COMMIT;
265: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_OSR_CHANGE (-)');
266: FND_FILE.put_line(fnd_file.log,' Purge Ends ... ');
267:
268: FND_FILE.put_line(fnd_file.log,' Update hz_imp_batch_summary table (+)');
269: -- Update hz_imp_batch_summary table.