APPS.HZ_IMP_LOAD_STAGE3 dependencies on HZ_IMP_WORK_UNITS

Line 105: -- error limit reached , decrease stage in HZ_IMP_WORK_UNITS table

101: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_real_error_count =' || l_real_error_count);
102:
103: IF l_real_error_count >= l_dml_record.ERROR_LIMIT THEN
104:
105: -- error limit reached , decrease stage in HZ_IMP_WORK_UNITS table
106: UPDATE HZ_IMP_WORK_UNITS
107: SET STATUS = 'C', STAGE = STAGE-1
108: WHERE BATCH_ID = l_dml_record.BATCH_ID
109: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;

Line 106: UPDATE HZ_IMP_WORK_UNITS

102:
103: IF l_real_error_count >= l_dml_record.ERROR_LIMIT THEN
104:
105: -- error limit reached , decrease stage in HZ_IMP_WORK_UNITS table
106: UPDATE HZ_IMP_WORK_UNITS
107: SET STATUS = 'C', STAGE = STAGE-1
108: WHERE BATCH_ID = l_dml_record.BATCH_ID
109: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;
110:

Line 151: FROM HZ_IMP_WORK_UNITS

147:
148: /* Bug 4594407
149: -- get high worker mark for current worker
150: SELECT HWM_STAGE INTO l_hwm_stage
151: FROM HZ_IMP_WORK_UNITS
152: WHERE BATCH_ID = l_dml_record.BATCH_ID
153: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;
154: */
155:

Line 384: UPDATE HZ_IMP_WORK_UNITS

380: END IF;
381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: load_code_assignments completed ');
382:
383:
384: UPDATE HZ_IMP_WORK_UNITS
385: SET STATUS = 'C'
386: WHERE BATCH_ID = P_BATCH_ID
387: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;
388:

Line 399: delete hz_imp_work_units where batch_id = P_BATCH_ID;

395: HZ_IMP_LOAD_WRAPPER.cleanup_staging(l_dml_record.BATCH_ID, l_dml_record.BATCH_MODE_FLAG);
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: Staging table cleaned up ');
397:
398: -- Delete Work Unit
399: delete hz_imp_work_units where batch_id = P_BATCH_ID;
400: FND_FILE.PUT_LINE(FND_FILE.LOG, 'debug: work united deleted');
401:
402: -- Change status ton Summary table to 'COMPLELTE'
403: update hz_imp_batch_summary