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;
216:
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;
216:
217: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CREDITRTNGS_SG (-)');
218: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CLASSIFICS_SG (+)');
213:
214: DELETE HZ_IMP_CREDITRTNGS_SG WHERE batch_id = p_batch_id;
215: COMMIT;
216:
217: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CREDITRTNGS_SG (-)');
218: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CLASSIFICS_SG (+)');
219:
220: DELETE HZ_IMP_CLASSIFICS_SG WHERE batch_id = p_batch_id;
221: COMMIT;