APPS.HZ_IMP_PURGE_PKG dependencies on HZ_IMP_BATCH_SUMMARY

Line 9: l_status HZ_IMP_BATCH_SUMMARY.MAIN_CONC_STATUS%TYPE;

5: p_batch_id IN VARCHAR2
6: ) IS
7: i NUMBER;
8: l_error_message VARCHAR2(2000);
9: l_status HZ_IMP_BATCH_SUMMARY.MAIN_CONC_STATUS%TYPE;
10: BEGIN
11:
12: /* Check for 8i database */
13: BEGIN

Line 54: FROM hz_imp_batch_summary

50:
51: /* Batch is Processing */
52: BEGIN
53: SELECT main_conc_status INTO l_status
54: FROM hz_imp_batch_summary
55: WHERE batch_id = p_batch_id;
56:
57: IF l_status = 'PROCESSING' THEN
58: RAISE FND_API.G_EXC_ERROR;

Line 268: FND_FILE.put_line(fnd_file.log,' Update hz_imp_batch_summary table (+)');

264: COMMIT;
265: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_OSR_CHANGE (-)');
266: FND_FILE.put_line(fnd_file.log,' Purge Ends ... ');
267:
268: FND_FILE.put_line(fnd_file.log,' Update hz_imp_batch_summary table (+)');
269: -- Update hz_imp_batch_summary table.
270: UPDATE HZ_IMP_BATCH_SUMMARY
271: SET BATCH_STATUS = 'PURGED',
272: PURGE_DATE = SYSDATE,

Line 269: -- Update hz_imp_batch_summary table.

265: FND_FILE.put_line(fnd_file.log,' Purge HZ_IMP_OSR_CHANGE (-)');
266: FND_FILE.put_line(fnd_file.log,' Purge Ends ... ');
267:
268: FND_FILE.put_line(fnd_file.log,' Update hz_imp_batch_summary table (+)');
269: -- Update hz_imp_batch_summary table.
270: UPDATE HZ_IMP_BATCH_SUMMARY
271: SET BATCH_STATUS = 'PURGED',
272: PURGE_DATE = SYSDATE,
273: PURGED_BY_USER_ID = HZ_UTILITY_V2PUB.user_id

Line 270: UPDATE HZ_IMP_BATCH_SUMMARY

266: FND_FILE.put_line(fnd_file.log,' Purge Ends ... ');
267:
268: FND_FILE.put_line(fnd_file.log,' Update hz_imp_batch_summary table (+)');
269: -- Update hz_imp_batch_summary table.
270: UPDATE HZ_IMP_BATCH_SUMMARY
271: SET BATCH_STATUS = 'PURGED',
272: PURGE_DATE = SYSDATE,
273: PURGED_BY_USER_ID = HZ_UTILITY_V2PUB.user_id
274: WHERE batch_id = p_batch_id;

Line 277: FND_FILE.put_line(fnd_file.log,' Update hz_imp_batch_summary table (-)');

273: PURGED_BY_USER_ID = HZ_UTILITY_V2PUB.user_id
274: WHERE batch_id = p_batch_id;
275: COMMIT;
276:
277: FND_FILE.put_line(fnd_file.log,' Update hz_imp_batch_summary table (-)');
278: EXCEPTION
279: WHEN OTHERS THEN
280: ROLLBACK WORK;
281: FND_FILE.put_line(fnd_file.log,sqlerrm);