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_DQM_STAGE dependencies on HZ_IMP_WORK_UNITS

Line 654: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'P', BATCH_DEDUP_STAGE = 1

650: LOOP
651: log(' Processing worker ' || p_worker_num );
652: l_row_id := NULL;
653: IF (p_phase = 'PHASE_1') THEN
654: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'P', BATCH_DEDUP_STAGE = 1
655: WHERE batch_id = p_batch_id and BATCH_DEDUP_STATUS is null and rownum = 1
656: RETURNING rowid, FROM_ORIG_SYSTEM_REF, TO_ORIG_SYSTEM_REF into l_row_id, l_from_osr, l_to_osr;
657: IF (l_row_id IS NULL) THEN
658: EXIT;

Line 674: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'E' where rowid = l_row_id;

670: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
671: retcode := 2;
672: err := x_msg_data;
673: logerror;
674: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'E' where rowid = l_row_id;
675: RAISE FND_API.G_EXC_ERROR;
676: ELSE
677: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'C' where rowid = l_row_id;
678: END IF;

Line 677: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'C' where rowid = l_row_id;

673: logerror;
674: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'E' where rowid = l_row_id;
675: RAISE FND_API.G_EXC_ERROR;
676: ELSE
677: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'C' where rowid = l_row_id;
678: END IF;
679: COMMIT;
680: ELSIF (p_phase = 'PHASE_2') THEN
681: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'P', BATCH_DEDUP_STAGE = 2

Line 681: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'P', BATCH_DEDUP_STAGE = 2

677: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'C' where rowid = l_row_id;
678: END IF;
679: COMMIT;
680: ELSIF (p_phase = 'PHASE_2') THEN
681: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'P', BATCH_DEDUP_STAGE = 2
682: WHERE batch_id = p_batch_id AND BATCH_DEDUP_STAGE = 1 and ROWNUM = 1
683: RETURNING rowid, FROM_ORIG_SYSTEM_REF, TO_ORIG_SYSTEM_REF into l_row_id, l_from_osr, l_to_osr;
684: IF (l_row_id IS NULL) THEN
685: EXIT;

Line 693: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'E' WHERE ROWID = l_row_id;

689: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
690: retcode := 2;
691: err := x_msg_data;
692: logerror;
693: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'E' WHERE ROWID = l_row_id;
694: RAISE FND_API.G_EXC_ERROR;
695: ELSE
696: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'C' WHERE ROWID = l_row_id;
697: END IF;

Line 696: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'C' WHERE ROWID = l_row_id;

692: logerror;
693: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'E' WHERE ROWID = l_row_id;
694: RAISE FND_API.G_EXC_ERROR;
695: ELSE
696: UPDATE hz_imp_work_units SET BATCH_DEDUP_STATUS = 'C' WHERE ROWID = l_row_id;
697: END IF;
698: COMMIT;
699: END IF;
700: END LOOP;