APPS.HZ_IMP_DQM_STAGE dependencies on HZ_INT_DUP_RESULTS

Line 432: delete from HZ_INT_DUP_RESULTS where batch_id = p_batch_id;

428: log(' HZ_DQM_DUP_ID_PKG.final_process_int_tca_dup_id(' || p_batch_id || '); +');
429: HZ_DQM_DUP_ID_PKG.final_process_int_tca_dup_id(p_batch_id);
430: log(' HZ_DQM_DUP_ID_PKG.final_process_int_tca_dup_id(' || p_batch_id || '); -');
431: chk_srch_tab(p_batch_id);
432: delete from HZ_INT_DUP_RESULTS where batch_id = p_batch_id;
433: EXCEPTION WHEN OTHERS THEN
434: log(SQLERRM);
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 759: chk_table('HZ_INT_DUP_RESULTS', p_batch_id);

755: log ('Please check the match rule you passed');
756: END IF;
757: */
758:
759: chk_table('HZ_INT_DUP_RESULTS', p_batch_id);
760: UPDATE HZ_IMP_BATCH_SUMMARY set BATCH_DEDUP_STATUS = 'PROCESSING' where batch_id = p_batch_id;
761: COMMIT;
762: -- HZ_IMP_DQM_STAGE.dqm_pre_imp_cleanup(p_batch_id, x_return_status, x_msg_count, x_msg_data);
763: FOR I in 1..to_number(p_num_of_workers) LOOP

Line 849: chk_table('HZ_INT_DUP_RESULTS', p_batch_id);

845:
846: -- update hz_imp_batch_summary set est_no_matches = $no where batch_id = p_batch_id;
847: UPDATE HZ_IMP_BATCH_SUMMARY set BATCH_DEDUP_STATUS = 'COMPLETED' where batch_id = p_batch_id;
848: COMMIT;
849: chk_table('HZ_INT_DUP_RESULTS', p_batch_id);
850: END IF;
851: END IF;
852: EXCEPTION WHEN OTHERS THEN
853: retcode := 2;