112: DELETE HZ_IMP_ADDRESSUSES_INT WHERE batch_id = p_batch_id;
113: COMMIT;
114:
115: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_INT(-) ');
116: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_INT(+) ');
117:
118: DELETE HZ_IMP_CONTACTPTS_INT WHERE batch_id = p_batch_id;
119: COMMIT;
120:
114:
115: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSUSES_INT(-) ');
116: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_INT(+) ');
117:
118: DELETE HZ_IMP_CONTACTPTS_INT WHERE batch_id = p_batch_id;
119: COMMIT;
120:
121: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_INT(-) ');
122: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_RELSHIPS_INT(+) ');
117:
118: DELETE HZ_IMP_CONTACTPTS_INT WHERE batch_id = p_batch_id;
119: COMMIT;
120:
121: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_CONTACTPTS_INT(-) ');
122: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_RELSHIPS_INT(+) ');
123:
124: DELETE HZ_IMP_RELSHIPS_INT WHERE batch_id = p_batch_id;
125: COMMIT;