DBA Data[Home] [Help]

APPS.HZ_IMP_PURGE_PKG dependencies on HZ_IMP_PARTIES_SG

Line 170: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_SG (+)');

166:
167:
168: --Staging Tables
169: FND_FILE.put_line(fnd_file.log,' Purging Staging Tables ... ');
170: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_SG (+)');
171:
172: DELETE HZ_IMP_PARTIES_SG WHERE batch_id = p_batch_id;
173: COMMIT;
174:

Line 172: DELETE HZ_IMP_PARTIES_SG WHERE batch_id = p_batch_id;

168: --Staging Tables
169: FND_FILE.put_line(fnd_file.log,' Purging Staging Tables ... ');
170: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_SG (+)');
171:
172: DELETE HZ_IMP_PARTIES_SG WHERE batch_id = p_batch_id;
173: COMMIT;
174:
175: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_SG (-)');
176: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSES_SG (+)');

Line 175: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_SG (-)');

171:
172: DELETE HZ_IMP_PARTIES_SG WHERE batch_id = p_batch_id;
173: COMMIT;
174:
175: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_PARTIES_SG (-)');
176: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_ADDRESSES_SG (+)');
177:
178: DELETE HZ_IMP_ADDRESSES_SG WHERE batch_id = p_batch_id;
179: COMMIT;