106: DELETE HZ_IMP_ADDRESSES_INT WHERE batch_id = p_batch_id;
107: COMMIT;
108:
109: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSES_INT(-) ');
110: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_INT(+) ');
111:
112: DELETE HZ_IMP_ADDRESSUSES_INT WHERE batch_id = p_batch_id;
113: COMMIT;
114:
108:
109: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSES_INT(-) ');
110: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_INT(+) ');
111:
112: DELETE HZ_IMP_ADDRESSUSES_INT WHERE batch_id = p_batch_id;
113: COMMIT;
114:
115: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_INT(-) ');
116: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_INT(+) ');
111:
112: DELETE HZ_IMP_ADDRESSUSES_INT WHERE batch_id = p_batch_id;
113: COMMIT;
114:
115: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_INT(-) ');
116: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_INT(+) ');
117:
118: DELETE HZ_IMP_CONTACTPTS_INT WHERE batch_id = p_batch_id;
119: COMMIT;