eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_IMP_LOAD_STAGE2 dependencies on HZ_IMP_WORK_UNITS

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

206:
207: IF l_real_error_count >= l_dml_record.ERROR_LIMIT THEN
208:
209: /* bug 3401629 fix
210: -- error limit reached , decrease stage in HZ_IMP_WORK_UNITS table
211: UPDATE HZ_IMP_WORK_UNITS
212: SET STATUS = 'C', STAGE = STAGE-1
213: WHERE BATCH_ID = l_dml_record.BATCH_ID
214: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;

Line 211: UPDATE HZ_IMP_WORK_UNITS

207: IF l_real_error_count >= l_dml_record.ERROR_LIMIT THEN
208:
209: /* bug 3401629 fix
210: -- error limit reached , decrease stage in HZ_IMP_WORK_UNITS table
211: UPDATE HZ_IMP_WORK_UNITS
212: SET STATUS = 'C', STAGE = STAGE-1
213: WHERE BATCH_ID = l_dml_record.BATCH_ID
214: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;
215: */

Line 259: FROM HZ_IMP_WORK_UNITS

255:
256: /* Bug 4594407
257: -- get high worker mark for current worker
258: SELECT HWM_STAGE INTO l_hwm_stage
259: FROM HZ_IMP_WORK_UNITS
260: WHERE BATCH_ID = l_dml_record.BATCH_ID
261: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;
262: */
263:

Line 597: UPDATE HZ_IMP_WORK_UNITS

593:
594: END IF;
595:
596: /* Update status to Complete for the work unit that just finished */
597: UPDATE HZ_IMP_WORK_UNITS
598: SET STATUS = 'C'
599: WHERE BATCH_ID = l_dml_record.BATCH_ID
600: AND FROM_ORIG_SYSTEM_REF = l_dml_record.FROM_OSR;
601: