APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_BATCH_SUMMARY

Line 503: update hz_imp_batch_summary

499: l_detail_import_status := P_STATUS;
500: l_batch_import_status := P_STATUS;
501: END IF;
502:
503: update hz_imp_batch_summary
504: set import_status = l_batch_import_status,
505: import_req_id = hz_utility_v2pub.request_id
506: where batch_id = P_BATCH_ID;
507:

Line 3650: FROM HZ_IMP_BATCH_SUMMARY

3646: AND rownum = 1;
3647:
3648: CURSOR c_batch_error(p_batch_id number) IS
3649: SELECT decode(nvl(total_errors, 0), 0, 'N', 'Y')
3650: FROM HZ_IMP_BATCH_SUMMARY
3651: WHERE batch_id = p_batch_id;
3652:
3653: CURSOR c_sg_data(p_batch_id number) IS
3654: SELECT 'Y'

Line 3698: from hz_imp_batch_summary bs, FND_CONCURRENT_REQUESTS r

3694:
3695: /* Get batch summary status */
3696: select bs.import_status, bs.what_if_flag, r.phase_code, bs.validate_flexfield_flag
3697: into l_batch_status, l_what_if_flag, l_phase_code , l_flex_validation_prof
3698: from hz_imp_batch_summary bs, FND_CONCURRENT_REQUESTS r
3699: where bs.batch_id = P_BATCH_ID
3700: and bs.import_req_id = r.request_id(+);
3701:
3702: req_data := fnd_conc_global.request_data;

Line 4081: update hz_imp_batch_summary

4077:
4078: -- update batch summary table and detail table
4079: -- set status as complete with reaching error limit
4080:
4081: update hz_imp_batch_summary
4082: set IMPORT_STATUS = 'COMPL_ERROR_LIMIT'
4083: where BATCH_ID = P_BATCH_ID;
4084:
4085: UPDATE hz_imp_batch_details

Line 4210: from hz_imp_batch_summary

4206: greater than 0 */
4207: IF P_RERUN_FLAG = 'N' THEN
4208: select nvl(total_records_imported, 0)
4209: into l_total_records_imported
4210: from hz_imp_batch_summary
4211: where batch_id = P_BATCH_ID;
4212:
4213: IF l_total_records_imported <= 0 THEN
4214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Warning: No data is imported by the batch.');

Line 4628: from HZ_IMP_BATCH_SUMMARY where batch_id = P_BATCH_ID;

4624:
4625: -- compute volume flag
4626: begin
4627: select est_no_of_records into est_count
4628: from HZ_IMP_BATCH_SUMMARY where batch_id = P_BATCH_ID;
4629: exception
4630: when others then
4631: est_count := null;
4632: end;