94: FND_FILE.put_line(fnd_file.log,' Purged DQM Tables ... ');
95:
96: -- Interface Tables
97: FND_FILE.put_line(fnd_file.log,' Purging Interface Tables ... ');
98: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_INT(+) ');
99:
100: DELETE HZ_IMP_PARTIES_INT WHERE batch_id = p_batch_id;
101: COMMIT;
102:
96: -- Interface Tables
97: FND_FILE.put_line(fnd_file.log,' Purging Interface Tables ... ');
98: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_INT(+) ');
99:
100: DELETE HZ_IMP_PARTIES_INT WHERE batch_id = p_batch_id;
101: COMMIT;
102:
103: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_INT(-) ');
104: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSES_INT(+) ');
99:
100: DELETE HZ_IMP_PARTIES_INT WHERE batch_id = p_batch_id;
101: COMMIT;
102:
103: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_INT(-) ');
104: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSES_INT(+) ');
105:
106: DELETE HZ_IMP_ADDRESSES_INT WHERE batch_id = p_batch_id;
107: COMMIT;