APPS.HZ_IMP_LOAD_STAGE2 dependencies on HZ_IMP_BATCH_DETAILS

Line 21: UPDATE hz_imp_batch_details

17: update hz_imp_batch_summary
18: set IMPORT_STATUS = 'COMPL_ERROR_LIMIT'
19: where BATCH_ID = P_BATCH_ID;
20:
21: UPDATE hz_imp_batch_details
22: SET import_status = 'COMPL_ERROR_LIMIT'
23: WHERE batch_id = P_BATCH_ID
24: AND run_number = (SELECT max(run_number)
25: FROM hz_imp_batch_details

Line 25: FROM hz_imp_batch_details

21: UPDATE hz_imp_batch_details
22: SET import_status = 'COMPL_ERROR_LIMIT'
23: WHERE batch_id = P_BATCH_ID
24: AND run_number = (SELECT max(run_number)
25: FROM hz_imp_batch_details
26: WHERE batch_id = P_BATCH_ID);
27:
28: /* comment out as this will be done in main wrapper
29:

Line 52: UPDATE hz_imp_batch_details

48: update hz_imp_batch_summary
49: set IMPORT_STATUS = 'ACTION_REQUIRED'
50: where BATCH_ID = P_BATCH_ID;
51:
52: UPDATE hz_imp_batch_details
53: SET import_status = 'ACTION_REQUIRED'
54: WHERE batch_id = P_BATCH_ID
55: AND run_number = (SELECT max(run_number)
56: FROM hz_imp_batch_details

Line 56: FROM hz_imp_batch_details

52: UPDATE hz_imp_batch_details
53: SET import_status = 'ACTION_REQUIRED'
54: WHERE batch_id = P_BATCH_ID
55: AND run_number = (SELECT max(run_number)
56: FROM hz_imp_batch_details
57: WHERE batch_id = P_BATCH_ID);
58:
59: -- get summary for each entity, update batch summary table
60: -- columns like 'NEW_UNIQUE_ADDRESSES' and 'EXISTING_ADDRESSES'

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

245: -- and current stg < HWM stage, set re-run flag to 'Y'
246: -- IF 'completed with errors' , set re-run flag to 'Y'
247: -- IF re-run parameter is 'new batch'm set re-run flag to 'N'
248: -- IF re-run parameter is 'what-if-resume' THEN
249: -- Look at hz_imp_batch_details table to find out if this batch has been run successfully;
250: -- IF batch run before THEN
251: -- set l_dml_record.RERUN flag to 'Y';
252: -- ELSE
253: -- set l_dml_record.RERUN flag to 'N';

Line 274: from hz_imp_batch_details

270: l_dml_record.RERUN := 'Y';
271: ELSIF P_RERUN = 'R' THEN
272: BEGIN
273: select 'Y' into l_batch_run_before
274: from hz_imp_batch_details
275: where batch_id = P_BATCH_ID
276: AND ( import_status = 'COMPL_ERRORS' OR import_status = 'COMPLETED')
277: AND rownum = 1;
278: EXCEPTION

Line 645: UPDATE hz_imp_batch_details

641: UPDATE hz_imp_batch_summary
642: SET import_status = 'ERROR'
643: WHERE batch_id = P_BATCH_ID;
644:
645: UPDATE hz_imp_batch_details
646: SET import_status = 'ERROR'
647: WHERE batch_id = P_BATCH_ID
648: AND run_number = (SELECT max(run_number)
649: FROM hz_imp_batch_details

Line 649: FROM hz_imp_batch_details

645: UPDATE hz_imp_batch_details
646: SET import_status = 'ERROR'
647: WHERE batch_id = P_BATCH_ID
648: AND run_number = (SELECT max(run_number)
649: FROM hz_imp_batch_details
650: WHERE batch_id = P_BATCH_ID);
651:
652: COMMIT;
653: