DBA Data[Home] [Help]

APPS.HZ_IMP_DQM_STAGE dependencies on HZ_DQM_DUP_ID_PKG

Line 428: log(' HZ_DQM_DUP_ID_PKG.final_process_int_tca_dup_id(' || p_batch_id || '); +');

424: ) IS
425: l_procedure_name VARCHAR2(30) := '.DQM_POST_IMP_CLEANUP' ;
426: BEGIN
427: x_return_status := fnd_api.g_ret_sts_success;
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;

Line 429: HZ_DQM_DUP_ID_PKG.final_process_int_tca_dup_id(p_batch_id);

425: l_procedure_name VARCHAR2(30) := '.DQM_POST_IMP_CLEANUP' ;
426: BEGIN
427: x_return_status := fnd_api.g_ret_sts_success;
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

Line 430: log(' HZ_DQM_DUP_ID_PKG.final_process_int_tca_dup_id(' || p_batch_id || '); -');

426: BEGIN
427: x_return_status := fnd_api.g_ret_sts_success;
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);

Line 688: HZ_DQM_DUP_ID_PKG.interface_dup_id_worker(p_batch_id, p_match_rule_id, l_from_osr, l_to_osr, x_return_status, x_msg_count, x_msg_data);

684: IF (l_row_id IS NULL) THEN
685: EXIT;
686: END IF;
687: COMMIT;
688: HZ_DQM_DUP_ID_PKG.interface_dup_id_worker(p_batch_id, p_match_rule_id, l_from_osr, l_to_osr, x_return_status, x_msg_count, x_msg_data);
689: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
690: retcode := 2;
691: err := x_msg_data;
692: logerror;

Line 843: HZ_DQM_DUP_ID_PKG.interface_sanitize_report(p_batch_id,

839: END LOOP;
840: END IF;
841: log('p_rule_id '||p_match_rule_id);
842: IF l_workers_completed THEN
843: HZ_DQM_DUP_ID_PKG.interface_sanitize_report(p_batch_id,
844: p_match_rule_id, x_return_status, x_msg_count, x_msg_data);
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;