APPS.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_BATCH_DETAILS

Line 508: update hz_imp_batch_details

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:
508: update hz_imp_batch_details
509: set import_status = l_detail_import_status,
510: import_req_id = hz_utility_v2pub.request_id
511: where batch_id = P_BATCH_ID
512: and run_number = (select max(run_number)

Line 513: from hz_imp_batch_details

509: set import_status = l_detail_import_status,
510: import_req_id = hz_utility_v2pub.request_id
511: where batch_id = P_BATCH_ID
512: and run_number = (select max(run_number)
513: from hz_imp_batch_details
514: where batch_id = P_BATCH_ID);
515:
516: COMMIT;
517:

Line 3328: from hz_imp_batch_details bs, FND_CONCURRENT_REQUESTS r

3324: l_wu_exists VARCHAR2(1);
3325:
3326: CURSOR c_batch_status(p_batch_id number) IS
3327: select bs.import_status, r.phase_code
3328: from hz_imp_batch_details bs, FND_CONCURRENT_REQUESTS r
3329: where bs.batch_id = p_batch_id
3330: and bs.import_req_id = r.request_id(+)
3331: and bs.run_number = (select max(run_number)-1
3332: from hz_imp_batch_details

Line 3332: from hz_imp_batch_details

3328: from hz_imp_batch_details bs, FND_CONCURRENT_REQUESTS r
3329: where bs.batch_id = p_batch_id
3330: and bs.import_req_id = r.request_id(+)
3331: and bs.run_number = (select max(run_number)-1
3332: from hz_imp_batch_details
3333: where batch_id = p_batch_id);
3334:
3335: CURSOR c_wu(p_batch_id number) IS
3336: SELECT 'Y'

Line 4085: UPDATE hz_imp_batch_details

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
4086: SET import_status = 'COMPL_ERROR_LIMIT'
4087: WHERE batch_id = P_BATCH_ID
4088: AND run_number = (SELECT max(run_number)
4089: FROM hz_imp_batch_details

Line 4089: FROM hz_imp_batch_details

4085: UPDATE hz_imp_batch_details
4086: SET import_status = 'COMPL_ERROR_LIMIT'
4087: WHERE batch_id = P_BATCH_ID
4088: AND run_number = (SELECT max(run_number)
4089: FROM hz_imp_batch_details
4090: WHERE batch_id = P_BATCH_ID);
4091: COMMIT;
4092:
4093: retcode := 2;