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;
192:
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;
192:
193: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_SG (-)');
194: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_RELSHIPS_SG (+)');
189:
190: DELETE HZ_IMP_CONTACTPTS_SG WHERE batch_id = p_batch_id;
191: COMMIT;
192:
193: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_SG (-)');
194: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_RELSHIPS_SG (+)');
195:
196: DELETE HZ_IMP_RELSHIPS_SG WHERE batch_id = p_batch_id;
197: COMMIT;