178: DELETE HZ_IMP_ADDRESSES_SG WHERE batch_id = p_batch_id;
179: COMMIT;
180:
181: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSES_SG (-)');
182: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_SG (+)');
183:
184: DELETE HZ_IMP_ADDRESSUSES_SG WHERE batch_id = p_batch_id;
185: COMMIT;
186:
180:
181: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSES_SG (-)');
182: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_SG (+)');
183:
184: DELETE HZ_IMP_ADDRESSUSES_SG WHERE batch_id = p_batch_id;
185: COMMIT;
186:
187: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_SG (-)');
188: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_SG (+)');
183:
184: DELETE HZ_IMP_ADDRESSUSES_SG WHERE batch_id = p_batch_id;
185: COMMIT;
186:
187: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_SG (-)');
188: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_SG (+)');
189:
190: DELETE HZ_IMP_CONTACTPTS_SG WHERE batch_id = p_batch_id;
191: COMMIT;