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;
198:
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;
198:
199: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_RELSHIPS_SG (-)');
200: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTS_SG (+)');
195:
196: DELETE HZ_IMP_RELSHIPS_SG WHERE batch_id = p_batch_id;
197: COMMIT;
198:
199: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_RELSHIPS_SG (-)');
200: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTS_SG (+)');
201:
202: DELETE HZ_IMP_CONTACTS_SG WHERE batch_id = p_batch_id;
203: COMMIT;