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_MATCH_RULE_39 dependencies on HZ_DQM_SEARCH_UTIL

Line 186: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN

182: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
183: END IF;
184: RETURN total;
185: END IF;
186: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
187: total := total+50;
188: IF g_score_until_thresh AND (total)>=g_thres_score THEN
189: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
190: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 194: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

190: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
191: END IF;
192: RETURN total;
193: END IF;
194: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
195: total := total+40;
196: IF g_score_until_thresh AND (total)>=g_thres_score THEN
197: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
198: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 203: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,45) THEN

199: END IF;
200: RETURN total;
201: END IF;
202: END IF;
203: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,45) THEN
204: total := total+70;
205: IF g_score_until_thresh AND (total)>=g_thres_score THEN
206: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 212: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

208: END IF;
209: RETURN total;
210: END IF;
211: END IF;
212: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
213: total := total+70;
214: IF g_score_until_thresh AND (total)>=g_thres_score THEN
215: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 237: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

233: RETURN l_current_score;
234: END IF;
235: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
236: l_current_score := 0;
237: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
238: l_current_score:=l_current_score+ 60;
239: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
240: x_matchidx:=J;
241: RETURN l_current_score;

Line 244: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN

240: x_matchidx:=J;
241: RETURN l_current_score;
242: END IF;
243: ELSIF -- l_current_score<42 AND
244: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
245: l_current_score:=l_current_score+ 42;
246: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
247: x_matchidx:=J;
248: RETURN l_current_score;

Line 384: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN

380: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
381: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_PARTY_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
382: END IF;
383: l_score :=0;
384: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
385: l_score :=50;
386: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
388: END IF;

Line 390: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN

386: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
388: END IF;
389: ELSIF l_current_score<40 AND
390: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
391: l_score :=40;
392: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
393: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
394: END IF;

Line 415: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,(50000*(p_idx-1)+45)) THEN

411: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ... Done',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
412: END IF;
413: END IF;
414: l_score :=0;
415: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,(50000*(p_idx-1)+45)) THEN
416: l_score :=70;
417: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
419: END IF;

Line 440: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN

436: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ... Done',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
437: END IF;
438: END IF;
439: l_score :=0;
440: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
441: l_score :=70;
442: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
444: END IF;

Line 483: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN

479: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
480: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_PARTY_SITES_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
481: END IF;
482: l_score :=0;
483: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
484: l_score :=60;
485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
486: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
487: END IF;

Line 489: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN

485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
486: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
487: END IF;
488: ELSIF l_current_score<42 AND
489: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
490: l_score :=42;
491: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
492: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
493: END IF;

Line 696: HZ_DQM_SEARCH_UTIL.set_score;

692: END IF;
693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(p_message=>'In init_search calling util package set_score',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
695: END IF;
696: HZ_DQM_SEARCH_UTIL.set_score;
697: g_mappings.DELETE;
698: g_party_site_stage_list.DELETE;
699: g_contact_stage_list.DELETE;
700: g_contact_pt_stage_list.DELETE;

Line 703: HZ_DQM_SEARCH_UTIL.new_search;

699: g_contact_stage_list.DELETE;
700: g_contact_pt_stage_list.DELETE;
701: call_order.DELETE;
702: call_max_score.DELETE;
703: HZ_DQM_SEARCH_UTIL.new_search;
704: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
705: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
706:
707: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 705: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

701: call_order.DELETE;
702: call_max_score.DELETE;
703: HZ_DQM_SEARCH_UTIL.new_search;
704: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
705: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
706:
707: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
708: hz_utility_v2pub.debug(p_message=>'In init_search calling the Map procedures',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
709: END IF;

Line 891: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES

887: END IF;
888:
889: -- Setup query string for PARTY_ALL_NAMES
890: l_prim_temp := null;
891: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
892: g_party_stage_rec.TX40,'A15',l_prim_temp);
893:
894: IF l_denorm_str IS NOT NULL THEN
895: IF (p_non_denorm_max_score+50)>=p_threshold THEN

Line 897: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

893:
894: IF l_denorm_str IS NOT NULL THEN
895: IF (p_non_denorm_max_score+50)>=p_threshold THEN
896: l_denorm_str := NULL;
897: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
898: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
899: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
900: l_denorm_str := NULL;
901: END IF;

Line 899: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);

895: IF (p_non_denorm_max_score+50)>=p_threshold THEN
896: l_denorm_str := NULL;
897: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
898: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
899: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
900: l_denorm_str := NULL;
901: END IF;
902: ELSE
903: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

Line 903: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

899: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
900: l_denorm_str := NULL;
901: END IF;
902: ELSE
903: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
904: END IF;
905: IF lengthb(l_party_contains_str) > 4000 THEN
906: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
907: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 956: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC

952:
953: -- Setup query string for POSTAL_CODE
954: l_prim_temp := null;
955: l_prim_temp_den := null;
956: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
957: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
959: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
960: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC

954: l_prim_temp := null;
955: l_prim_temp_den := null;
956: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
957: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
959: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
960: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
961: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
962:

Line 960: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

956: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
957: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
959: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
960: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
961: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
962:
963: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
964: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

Line 961: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);

957: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
959: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
960: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
961: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
962:
963: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
964: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
965: END LOOP;

Line 963: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

959: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
960: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
961: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
962:
963: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
964: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
965: END LOOP;
966: -- Add the search criteria to query string
967: IF lengthb(l_contains_str) > 4000 THEN

Line 964: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

960: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
961: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
962:
963: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
964: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
965: END LOOP;
966: -- Add the search criteria to query string
967: IF lengthb(l_contains_str) > 4000 THEN
968: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2099: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2095: H_PARTY_ID.DELETE;
2096: H_PARTY_ID_LIST.DELETE;
2097: H_SCORES.DELETE;
2098: g_mappings.DELETE;
2099: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2100: call_order(5) := call_order(1);
2101: call_type(5) := 'AND';
2102: call_max_score(5) := call_max_score(1);
2103: call_type(2) := 'OR';

Line 2927: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2923: ELSE
2924: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
2925: END IF;
2926: END LOOP;
2927: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2928: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2929: hz_utility_v2pub.debug(p_message=>'Exiting Procedure find_parties',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2930: END IF;
2931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3083: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3079: H_PARTY_ID.DELETE;
3080: H_PARTY_ID_LIST.DELETE;
3081: H_SCORES.DELETE;
3082: g_mappings.DELETE;
3083: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3084: call_order(5) := call_order(1);
3085: call_type(5) := 'AND';
3086: call_max_score(5) := call_max_score(1);
3087: call_type(2) := 'OR';

Line 3782: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3778: ELSE
3779: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3780: END IF;
3781: END LOOP;
3782: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3783: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3784: hz_utility_v2pub.debug(p_message=>'find_persons(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
3785: END IF;
3786: EXCEPTION