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;
210:
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;
210:
211: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTROLES_SG (-)');
212: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CREDITRTNGS_SG (+)');
207:
208: DELETE HZ_IMP_CONTACTROLES_SG WHERE batch_id = p_batch_id;
209: COMMIT;
210:
211: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTROLES_SG (-)');
212: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CREDITRTNGS_SG (+)');
213:
214: DELETE HZ_IMP_CREDITRTNGS_SG WHERE batch_id = p_batch_id;
215: COMMIT;