251: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_TMP_ERRORS (-)');
252: FND_FILE.put_line(fnd_file.log,' Purged Error Tables ... ');
253:
254: -- Work Units Table
255: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_WORK_UNITS (+)');
256: DELETE HZ_IMP_WORK_UNITS WHERE batch_id = p_batch_id;
257: COMMIT;
258:
259: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_WORK_UNITS (-)');
252: FND_FILE.put_line(fnd_file.log,' Purged Error Tables ... ');
253:
254: -- Work Units Table
255: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_WORK_UNITS (+)');
256: DELETE HZ_IMP_WORK_UNITS WHERE batch_id = p_batch_id;
257: COMMIT;
258:
259: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_WORK_UNITS (-)');
260:
255: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_WORK_UNITS (+)');
256: DELETE HZ_IMP_WORK_UNITS WHERE batch_id = p_batch_id;
257: COMMIT;
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;