98: UPDATE hz_imp_batch_summary
99: SET import_status = 'ERROR'
100: WHERE batch_id = P_BATCH_ID;
101:
102: UPDATE hz_imp_batch_details
103: SET import_status = 'ERROR'
104: WHERE batch_id = P_BATCH_ID
105: AND run_number = (SELECT max(run_number)
106: FROM hz_imp_batch_details
102: UPDATE hz_imp_batch_details
103: SET import_status = 'ERROR'
104: WHERE batch_id = P_BATCH_ID
105: AND run_number = (SELECT max(run_number)
106: FROM hz_imp_batch_details
107: WHERE batch_id = P_BATCH_ID);
108:
109: COMMIT;
110: