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

Line 188: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) THEN

184: 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);
185: END IF;
186: RETURN total;
187: END IF;
188: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) THEN
189: total := total+50;
190: IF g_score_until_thresh AND (total)>=g_thres_score THEN
191: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
192: 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 196: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX8, p_table_TX8,12) THEN

192: 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);
193: END IF;
194: RETURN total;
195: END IF;
196: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX8, p_table_TX8,12) THEN
197: total := total+45;
198: IF g_score_until_thresh AND (total)>=g_thres_score THEN
199: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
200: 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 204: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX4, p_table_TX4,8) THEN

200: 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);
201: END IF;
202: RETURN total;
203: END IF;
204: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX4, p_table_TX4,8) THEN
205: total := total+35;
206: IF g_score_until_thresh AND (total)>=g_thres_score THEN
207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
208: 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 213: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX41, p_table_TX41,45) THEN

209: END IF;
210: RETURN total;
211: END IF;
212: END IF;
213: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX41, p_table_TX41,45) THEN
214: total := total+100;
215: IF g_score_until_thresh AND (total)>=g_thres_score THEN
216: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
217: 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 222: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

218: END IF;
219: RETURN total;
220: END IF;
221: END IF;
222: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
223: total := total+100;
224: IF g_score_until_thresh AND (total)>=g_thres_score THEN
225: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
226: 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 231: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN

227: END IF;
228: RETURN total;
229: END IF;
230: END IF;
231: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN
232: total := total+20;
233: IF g_score_until_thresh AND (total)>=g_thres_score THEN
234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
235: 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 257: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

253: RETURN l_current_score;
254: END IF;
255: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
256: l_current_score := 0;
257: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
258: l_current_score:=l_current_score+ 60;
259: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
260: x_matchidx:=J;
261: RETURN l_current_score;

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

260: x_matchidx:=J;
261: RETURN l_current_score;
262: END IF;
263: ELSIF -- l_current_score<48 AND
264: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
265: l_current_score:=l_current_score+ 48;
266: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
267: x_matchidx:=J;
268: RETURN l_current_score;

Line 271: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN

267: x_matchidx:=J;
268: RETURN l_current_score;
269: END IF;
270: END IF;
271: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
272: l_current_score:=l_current_score+ 20;
273: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
274: x_matchidx:=J;
275: RETURN l_current_score;

Line 300: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+89)) THEN

296: RETURN l_current_score;
297: END IF;
298: FOR J IN 1..g_contact_stage_list.COUNT LOOP
299: l_current_score := 0;
300: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+89)) THEN
301: l_current_score:=l_current_score+ 30;
302: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
303: x_matchidx:=J;
304: RETURN l_current_score;

Line 307: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+92)) THEN

303: x_matchidx:=J;
304: RETURN l_current_score;
305: END IF;
306: ELSIF -- l_current_score<27 AND
307: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+92)) THEN
308: l_current_score:=l_current_score+ 27;
309: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
310: x_matchidx:=J;
311: RETURN l_current_score;

Line 314: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+93)) THEN

310: x_matchidx:=J;
311: RETURN l_current_score;
312: END IF;
313: ELSIF -- l_current_score<21 AND
314: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+93)) THEN
315: l_current_score:=l_current_score+ 21;
316: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
317: x_matchidx:=J;
318: RETURN l_current_score;

Line 341: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN

337: RETURN l_current_score;
338: END IF;
339: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
340: l_current_score := 0;
341: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
342: l_current_score:=l_current_score+ 65;
343: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
344: x_matchidx:=J;
345: RETURN l_current_score;

Line 498: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN

494: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
495: 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);
496: END IF;
497: l_score :=0;
498: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN
499: l_score :=50;
500: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
501: 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);
502: END IF;

Line 504: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN

500: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
501: 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);
502: END IF;
503: ELSIF l_current_score<45 AND
504: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN
505: l_score :=45;
506: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
507: 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);
508: END IF;

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

506: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
507: 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);
508: END IF;
509: ELSIF l_current_score<35 AND
510: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+8)) THEN
511: l_score :=35;
512: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
513: 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);
514: END IF;

Line 535: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX41, p_table_TX41,(50000*(p_idx-1)+45)) THEN

531: 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);
532: END IF;
533: END IF;
534: l_score :=0;
535: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX41, p_table_TX41,(50000*(p_idx-1)+45)) THEN
536: l_score :=100;
537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
538: 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);
539: END IF;

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

556: 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);
557: END IF;
558: END IF;
559: l_score :=0;
560: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
561: l_score :=100;
562: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
563: 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);
564: END IF;

Line 585: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN

581: 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);
582: END IF;
583: END IF;
584: l_score :=0;
585: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN
586: l_score :=20;
587: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
588: 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);
589: END IF;

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

625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
626: 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);
627: END IF;
628: l_score :=0;
629: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
630: l_score :=60;
631: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
632: 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);
633: END IF;

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

631: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
632: 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);
633: END IF;
634: ELSIF l_current_score<48 AND
635: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
636: l_score :=48;
637: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
638: 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);
639: END IF;

Line 660: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN

656: 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);
657: END IF;
658: END IF;
659: l_score :=0;
660: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
661: l_score :=20;
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
663: 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);
664: END IF;

Line 704: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN

700: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
701: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_CONTACTS_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
702: END IF;
703: l_score :=0;
704: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN
705: l_score :=30;
706: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
707: 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);
708: END IF;

Line 710: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+92)) THEN

706: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
707: 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);
708: END IF;
709: ELSIF l_current_score<27 AND
710: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+92)) THEN
711: l_score :=27;
712: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
713: 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);
714: END IF;

Line 716: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+93)) THEN

712: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
713: 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);
714: END IF;
715: ELSIF l_current_score<21 AND
716: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+93)) THEN
717: l_score :=21;
718: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
719: 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);
720: END IF;

Line 758: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN

754: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
755: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_CONTACT_POINTS_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
756: END IF;
757: l_score :=0;
758: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
759: l_score :=65;
760: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
761: 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);
762: END IF;

Line 933: HZ_DQM_SEARCH_UTIL.set_score;

929: END IF;
930: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
931: 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);
932: END IF;
933: HZ_DQM_SEARCH_UTIL.set_score;
934: g_mappings.DELETE;
935: g_party_site_stage_list.DELETE;
936: g_contact_stage_list.DELETE;
937: g_contact_pt_stage_list.DELETE;

Line 940: HZ_DQM_SEARCH_UTIL.new_search;

936: g_contact_stage_list.DELETE;
937: g_contact_pt_stage_list.DELETE;
938: call_order.DELETE;
939: call_max_score.DELETE;
940: HZ_DQM_SEARCH_UTIL.new_search;
941: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
942: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
943:
944: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 942: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

938: call_order.DELETE;
939: call_max_score.DELETE;
940: HZ_DQM_SEARCH_UTIL.new_search;
941: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
942: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
943:
944: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
945: 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);
946: END IF;

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

1124: END IF;
1125:
1126: -- Setup query string for PARTY_NAME
1127: l_prim_temp := null;
1128: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1129: g_party_stage_rec.TX4,'A8',l_prim_temp);
1130:
1131: IF l_denorm_str IS NOT NULL THEN
1132: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

1130:
1131: IF l_denorm_str IS NOT NULL THEN
1132: IF (p_non_denorm_max_score+50)>=p_threshold THEN
1133: l_denorm_str := NULL;
1134: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1135: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
1136: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1137: l_denorm_str := NULL;
1138: END IF;

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

1132: IF (p_non_denorm_max_score+50)>=p_threshold THEN
1133: l_denorm_str := NULL;
1134: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1135: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
1136: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1137: l_denorm_str := NULL;
1138: END IF;
1139: ELSE
1140: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1136: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1137: l_denorm_str := NULL;
1138: END IF;
1139: ELSE
1140: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1141: END IF;
1142:
1143: -- Setup query string for TAX_REFERENCE
1144: l_prim_temp := null;

Line 1145: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1141: END IF;
1142:
1143: -- Setup query string for TAX_REFERENCE
1144: l_prim_temp := null;
1145: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1146: g_party_stage_rec.TX44,'A18',l_prim_temp);
1147:
1148: IF l_denorm_str IS NOT NULL THEN
1149: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1147:
1148: IF l_denorm_str IS NOT NULL THEN
1149: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1150: l_denorm_str := NULL;
1151: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1152: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1153: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1154: l_denorm_str := NULL;
1155: END IF;

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

1149: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1150: l_denorm_str := NULL;
1151: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1152: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1153: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1154: l_denorm_str := NULL;
1155: END IF;
1156: ELSE
1157: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1153: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1154: l_denorm_str := NULL;
1155: END IF;
1156: ELSE
1157: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1158: END IF;
1159:
1160: -- Setup query string for DUNS_NUMBER_C
1161: l_prim_temp := null;

Line 1165: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1161: l_prim_temp := null;
1162: IF g_party_stage_rec.TX41 IS NOT NULL THEN
1163: IF ltrim(g_party_stage_rec.TX41,'0') IS NOT NULL THEN
1164: FOR I in lengthb(ltrim(g_party_stage_rec.TX41,'0'))..9 LOOP
1165: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1166: lpad(ltrim(g_party_stage_rec.TX41,'0'),I,chr(48)),'A16',l_prim_temp);
1167: END LOOP;
1168: END IF;
1169: END IF;

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

1170:
1171: IF l_denorm_str IS NOT NULL THEN
1172: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1173: l_denorm_str := NULL;
1174: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1175: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1176: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1177: l_denorm_str := NULL;
1178: END IF;

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

1172: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1173: l_denorm_str := NULL;
1174: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1175: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1176: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1177: l_denorm_str := NULL;
1178: END IF;
1179: ELSE
1180: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1176: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1177: l_denorm_str := NULL;
1178: END IF;
1179: ELSE
1180: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1181: END IF;
1182: IF lengthb(l_party_contains_str) > 4000 THEN
1183: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1184: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 1233: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS

1229:
1230: -- Setup query string for ADDRESS
1231: l_prim_temp := null;
1232: l_prim_temp_den := null;
1233: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1234: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1235: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1236:
1237: -- Setup query string for POSTAL_CODE

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

1231: l_prim_temp := null;
1232: l_prim_temp_den := null;
1233: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1234: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1235: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1236:
1237: -- Setup query string for POSTAL_CODE
1238: l_prim_temp := null;
1239: l_prim_temp_den := null;

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

1236:
1237: -- Setup query string for POSTAL_CODE
1238: l_prim_temp := null;
1239: l_prim_temp_den := null;
1240: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1241: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1242: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1243: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1244: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1238: l_prim_temp := null;
1239: l_prim_temp_den := null;
1240: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1241: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1242: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1243: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1244: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1245: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1246:

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

1240: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1241: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1242: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1243: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1244: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1245: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1246:
1247: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1248: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1241: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1242: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1243: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1244: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1245: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1246:
1247: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1248: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1249: END LOOP;

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

1243: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1244: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1245: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1246:
1247: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1248: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1249: END LOOP;
1250: -- Add the search criteria to query string
1251: IF lengthb(l_contains_str) > 4000 THEN

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

1244: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1245: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1246:
1247: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1248: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1249: END LOOP;
1250: -- Add the search criteria to query string
1251: IF lengthb(l_contains_str) > 4000 THEN
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1287: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON

1283:
1284: -- Setup query string for CONTACT_NAME
1285: l_prim_temp := null;
1286: l_prim_temp_den := null;
1287: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1288: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1289: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1290:
1291: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1285: l_prim_temp := null;
1286: l_prim_temp_den := null;
1287: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1288: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1289: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1290:
1291: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1292: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1293: END LOOP;

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

1287: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1288: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1289: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1290:
1291: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1292: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1293: END LOOP;
1294: -- Add the search criteria to query string
1295: IF lengthb(l_contains_str) > 4000 THEN

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

1288: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1289: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1290:
1291: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1292: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1293: END LOOP;
1294: -- Add the search criteria to query string
1295: IF lengthb(l_contains_str) > 4000 THEN
1296: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1332: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX

1328:
1329: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1330: l_prim_temp := null;
1331: l_prim_temp_den := null;
1332: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1333: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1334: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1335:
1336: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1330: l_prim_temp := null;
1331: l_prim_temp_den := null;
1332: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1333: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1334: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1335:
1336: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1337: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1338: END LOOP;

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

1332: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1333: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1334: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1335:
1336: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1337: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1338: END LOOP;
1339: -- Add the search criteria to query string
1340: IF lengthb(l_contains_str) > 4000 THEN

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

1333: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1334: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1335:
1336: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1337: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1338: END LOOP;
1339: -- Add the search criteria to query string
1340: IF lengthb(l_contains_str) > 4000 THEN
1341: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2441: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2437: H_PARTY_ID.DELETE;
2438: H_PARTY_ID_LIST.DELETE;
2439: H_SCORES.DELETE;
2440: g_mappings.DELETE;
2441: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2442: call_order(5) := call_order(1);
2443: call_type(5) := 'AND';
2444: call_max_score(5) := call_max_score(1);
2445: call_type(2) := 'OR';

Line 3232: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3228: ELSE
3229: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3230: END IF;
3231: END LOOP;
3232: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3234: 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);
3235: END IF;
3236: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3393: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3389: H_PARTY_ID.DELETE;
3390: H_PARTY_ID_LIST.DELETE;
3391: H_SCORES.DELETE;
3392: g_mappings.DELETE;
3393: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3394: call_order(5) := call_order(1);
3395: call_type(5) := 'AND';
3396: call_max_score(5) := call_max_score(1);
3397: call_type(2) := 'OR';

Line 4024: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4020: ELSE
4021: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4022: END IF;
4023: END LOOP;
4024: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4026: 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);
4027: END IF;
4028: EXCEPTION