DBA Data[Home] [Help]

APPS.HZ_DQM_SEARCH_UTIL dependencies on HZ_DQM_QUALITY_UH_PKG

Line 596: l_quality_weight := hz_dqm_quality_uh_pkg.get_quality_weighting(p_match_rule_id);

592: l_rule_purpose VARCHAR2(1);
593: l_party_rec HZ_PARTIES%ROWTYPE;
594: l_mms NUMBER;
595: BEGIN
596: l_quality_weight := hz_dqm_quality_uh_pkg.get_quality_weighting(p_match_rule_id);
597: IF (l_quality_weight > 0) THEN
598: select rule_purpose into l_rule_purpose
599: from hz_match_rules_vl
600: where match_rule_id = p_match_rule_id;

Line 611: l_quality_score := hz_dqm_quality_uh_pkg.get_quality_score(p_match_rule_id, l_party_rec);

607: LOOP
608: select * into l_party_rec
609: from HZ_PARTIES
610: where party_id = TX.party_id;
611: l_quality_score := hz_dqm_quality_uh_pkg.get_quality_score(p_match_rule_id, l_party_rec);
612: l_score := TX.score;
613: l_final_score := (l_score * ( 100 - l_quality_weight) + l_quality_score * l_quality_weight)/ 100;
614: update hz_matched_parties_gt
615: set score = l_final_score

Line 631: l_quality_score := hz_dqm_quality_uh_pkg.get_quality_score(p_match_rule_id, l_party_rec);

627: select * into l_party_rec
628: from HZ_PARTIES
629: where party_id = TX.party_id;
630: l_score := TX.score;
631: l_quality_score := hz_dqm_quality_uh_pkg.get_quality_score(p_match_rule_id, l_party_rec);
632: l_final_score := (l_score - (l_score * l_quality_weight)/100 + (l_quality_score * l_quality_weight* l_mms)/(100*100));
633: update hz_matched_parties_gt
634: set score = l_final_score
635: where search_context_id = p_srch_ctx_id