APPS.HZ_IMP_LOAD_STAGE3 dependencies on HZ_IMP_BATCH_DETAILS

Line 141: -- Look at hz_imp_batch_details table to find out if this batch has been run successfully;

137: -- and current stg < HWM stage, set re-run flag to 'Y'
138: -- IF 'completed with errors' , set re-run flag to 'Y'
139: -- IF re-run parameter is 'new batch'm set re-run flag to 'N'
140: -- IF re-run parameter is 'what-if-resume' THEN
141: -- Look at hz_imp_batch_details table to find out if this batch has been run successfully;
142: -- IF batch run before THEN
143: -- set l_dml_record.RERUN flag to 'Y';
144: -- ELSE
145: -- set l_dml_record.RERUN flag to 'N';

Line 166: from hz_imp_batch_details

162: l_dml_record.RERUN := 'Y';
163: ELSIF P_RERUN = 'R' THEN
164: BEGIN
165: select 'Y' into l_batch_run_before
166: from hz_imp_batch_details
167: where batch_id = P_BATCH_ID
168: AND ( import_status = 'COMPL_ERRORS' OR import_status = 'COMPLETED')
169: AND rownum = 1;
170: EXCEPTION

Line 427: UPDATE hz_imp_batch_details

423: UPDATE hz_imp_batch_summary
424: SET import_status = 'ERROR'
425: WHERE batch_id = P_BATCH_ID;
426:
427: UPDATE hz_imp_batch_details
428: SET import_status = 'ERROR'
429: WHERE batch_id = P_BATCH_ID
430: AND run_number = (SELECT max(run_number)
431: FROM hz_imp_batch_details

Line 431: FROM hz_imp_batch_details

427: UPDATE hz_imp_batch_details
428: SET import_status = 'ERROR'
429: WHERE batch_id = P_BATCH_ID
430: AND run_number = (SELECT max(run_number)
431: FROM hz_imp_batch_details
432: WHERE batch_id = P_BATCH_ID);
433:
434: COMMIT;
435: