72: FND_FILE.put_line(fnd_file.log,' Purge Starts ... ');
73:
74: -- DQM Tables
75: FND_FILE.put_line(fnd_file.log,' Purging DQM Tables ... ');
76: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_INT_DEDUP_RESULTS (+) ');
77:
78: DELETE HZ_IMP_INT_DEDUP_RESULTS WHERE batch_id = p_batch_id;
79: COMMIT;
80:
74: -- DQM Tables
75: FND_FILE.put_line(fnd_file.log,' Purging DQM Tables ... ');
76: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_INT_DEDUP_RESULTS (+) ');
77:
78: DELETE HZ_IMP_INT_DEDUP_RESULTS WHERE batch_id = p_batch_id;
79: COMMIT;
80:
81: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_INT_DEDUP_RESULTS (-) ');
82: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_DUP_PARTIES (+) ');
77:
78: DELETE HZ_IMP_INT_DEDUP_RESULTS WHERE batch_id = p_batch_id;
79: COMMIT;
80:
81: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_INT_DEDUP_RESULTS (-) ');
82: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_DUP_PARTIES (+) ');
83:
84: DELETE HZ_IMP_DUP_PARTIES WHERE batch_id = p_batch_id;
85: COMMIT;