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;
204:
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;
204:
205: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTS_SG (-)');
206: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTROLES_SG (+)');
201:
202: DELETE HZ_IMP_CONTACTS_SG WHERE batch_id = p_batch_id;
203: COMMIT;
204:
205: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTS_SG (-)');
206: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTROLES_SG (+)');
207:
208: DELETE HZ_IMP_CONTACTROLES_SG WHERE batch_id = p_batch_id;
209: COMMIT;