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

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

192: END IF;
193: IF g_score_until_thresh AND (total)>=g_thres_score THEN
194: RETURN total;
195: END IF;
196: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) THEN
197: total := total+80;
198: IF g_score_until_thresh AND (total)>=g_thres_score THEN
199: RETURN total;
200: END IF;

Line 201: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX59, p_table_TX59,138) THEN

197: total := total+80;
198: IF g_score_until_thresh AND (total)>=g_thres_score THEN
199: RETURN total;
200: END IF;
201: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX59, p_table_TX59,138) THEN
202: total := total+72;
203: IF g_score_until_thresh AND (total)>=g_thres_score THEN
204: RETURN total;
205: END IF;

Line 207: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX41, p_table_TX41,45) THEN

203: IF g_score_until_thresh AND (total)>=g_thres_score THEN
204: RETURN total;
205: END IF;
206: END IF;
207: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX41, p_table_TX41,45) THEN
208: total := total+200;
209: IF g_score_until_thresh AND (total)>=g_thres_score THEN
210: RETURN total;
211: END IF;

Line 213: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN

209: IF g_score_until_thresh AND (total)>=g_thres_score THEN
210: RETURN total;
211: END IF;
212: END IF;
213: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN
214: total := total+200;
215: IF g_score_until_thresh AND (total)>=g_thres_score THEN
216: RETURN total;
217: END IF;

Line 237: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX26, p_table_TX26,(50000*(J-1)+140)) 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).TX26, p_table_TX26,(50000*(J-1)+140)) THEN
238: l_current_score:=l_current_score+ 100;
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: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN

240: x_matchidx:=J;
241: RETURN l_current_score;
242: END IF;
243: END IF;
244: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
245: l_current_score:=l_current_score+ 15;
246: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
247: x_matchidx:=J;
248: RETURN l_current_score;

Line 251: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN

247: x_matchidx:=J;
248: RETURN l_current_score;
249: END IF;
250: END IF;
251: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
252: l_current_score:=l_current_score+ 5;
253: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
254: x_matchidx:=J;
255: RETURN l_current_score;

Line 258: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN

254: x_matchidx:=J;
255: RETURN l_current_score;
256: END IF;
257: END IF;
258: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
259: l_current_score:=l_current_score+ 5;
260: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
261: x_matchidx:=J;
262: RETURN l_current_score;

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

283: RETURN l_current_score;
284: END IF;
285: FOR J IN 1..g_contact_stage_list.COUNT LOOP
286: l_current_score := 0;
287: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+89)) THEN
288: l_current_score:=l_current_score+ 20;
289: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
290: x_matchidx:=J;
291: RETURN l_current_score;

Line 294: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX23, p_table_TX23,(50000*(J-1)+136)) THEN

290: x_matchidx:=J;
291: RETURN l_current_score;
292: END IF;
293: ELSIF -- l_current_score<18 AND
294: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX23, p_table_TX23,(50000*(J-1)+136)) THEN
295: l_current_score:=l_current_score+ 18;
296: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
297: x_matchidx:=J;
298: RETURN l_current_score;

Line 301: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN

297: x_matchidx:=J;
298: RETURN l_current_score;
299: END IF;
300: END IF;
301: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN
302: l_current_score:=l_current_score+ 10;
303: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
304: x_matchidx:=J;
305: RETURN l_current_score;

Line 331: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN

327: RETURN l_current_score;
328: END IF;
329: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
330: l_current_score := 0;
331: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
332: l_current_score:=l_current_score+ 60;
333: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
334: x_matchidx:=J;
335: RETURN l_current_score;

Line 338: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX7, p_table_TX7,(50000*(J-1)+116)) THEN

334: x_matchidx:=J;
335: RETURN l_current_score;
336: END IF;
337: END IF;
338: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX7, p_table_TX7,(50000*(J-1)+116)) THEN
339: l_current_score:=l_current_score+ 20;
340: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
341: x_matchidx:=J;
342: RETURN l_current_score;

Line 345: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+120)) THEN

341: x_matchidx:=J;
342: RETURN l_current_score;
343: END IF;
344: END IF;
345: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+120)) THEN
346: l_current_score:=l_current_score+ 70;
347: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
348: x_matchidx:=J;
349: RETURN l_current_score;

Line 352: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX158, p_table_TX158,(50000*(J-1)+128)) THEN

348: x_matchidx:=J;
349: RETURN l_current_score;
350: END IF;
351: ELSIF -- l_current_score<70 AND
352: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX158, p_table_TX158,(50000*(J-1)+128)) THEN
353: l_current_score:=l_current_score+ 70;
354: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
355: x_matchidx:=J;
356: RETURN l_current_score;

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

550: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
551: 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);
552: END IF;
553: l_score :=0;
554: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN
555: l_score :=80;
556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
557: 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);
558: END IF;

Line 560: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX59, p_table_TX59,(50000*(p_idx-1)+138)) THEN

556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
557: 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);
558: END IF;
559: ELSIF l_current_score<72 AND
560: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX59, p_table_TX59,(50000*(p_idx-1)+138)) THEN
561: l_score :=72;
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.TX41, p_table_TX41,(50000*(p_idx-1)+45)) 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.TX41, p_table_TX41,(50000*(p_idx-1)+45)) THEN
586: l_score :=200;
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 610: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN

606: 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);
607: END IF;
608: END IF;
609: l_score :=0;
610: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
611: l_score :=200;
612: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
613: 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);
614: END IF;

Line 655: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX26, p_table_TX26,(50000*(p_idx-1)+140)) THEN

651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
652: 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);
653: END IF;
654: l_score :=0;
655: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX26, p_table_TX26,(50000*(p_idx-1)+140)) THEN
656: l_score :=100;
657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
658: 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);
659: END IF;

Line 680: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN

676: 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);
677: END IF;
678: END IF;
679: l_score :=0;
680: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
681: l_score :=15;
682: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
683: 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);
684: END IF;

Line 705: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN

701: 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);
702: END IF;
703: END IF;
704: l_score :=0;
705: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
706: l_score :=5;
707: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
708: 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);
709: END IF;

Line 730: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN

726: 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);
727: END IF;
728: END IF;
729: l_score :=0;
730: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
731: l_score :=5;
732: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
733: 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);
734: END IF;

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

770: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
771: 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);
772: END IF;
773: l_score :=0;
774: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN
775: l_score :=20;
776: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
777: 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);
778: END IF;

Line 780: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX23, p_table_TX23,(50000*(p_idx-1)+136)) THEN

776: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
777: 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);
778: END IF;
779: ELSIF l_current_score<18 AND
780: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX23, p_table_TX23,(50000*(p_idx-1)+136)) THEN
781: l_score :=18;
782: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
783: 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);
784: END IF;

Line 805: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+109)) THEN

801: 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);
802: END IF;
803: END IF;
804: l_score :=0;
805: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+109)) THEN
806: l_score :=10;
807: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
808: 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);
809: END IF;

Line 850: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN

846: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
847: 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);
848: END IF;
849: l_score :=0;
850: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
851: l_score :=60;
852: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
853: 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);
854: END IF;

Line 875: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX7, p_table_TX7,(50000*(p_idx-1)+116)) THEN

871: 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);
872: END IF;
873: END IF;
874: l_score :=0;
875: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX7, p_table_TX7,(50000*(p_idx-1)+116)) THEN
876: l_score :=20;
877: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
878: 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);
879: END IF;

Line 900: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+120)) THEN

896: 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);
897: END IF;
898: END IF;
899: l_score :=0;
900: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+120)) THEN
901: l_score :=70;
902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
903: 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);
904: END IF;

Line 906: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX158, p_table_TX158,(50000*(p_idx-1)+128)) THEN

902: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
903: 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);
904: END IF;
905: ELSIF l_current_score<70 AND
906: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX158, p_table_TX158,(50000*(p_idx-1)+128)) THEN
907: l_score :=70;
908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
909: 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);
910: END IF;

Line 1072: HZ_DQM_SEARCH_UTIL.set_score;

1068: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: HZ_DQM_SEARCH_UTIL.set_score;
1073: g_mappings.DELETE;
1074: g_party_site_stage_list.DELETE;
1075: g_contact_stage_list.DELETE;
1076: g_contact_pt_stage_list.DELETE;

Line 1079: HZ_DQM_SEARCH_UTIL.new_search;

1075: g_contact_stage_list.DELETE;
1076: g_contact_pt_stage_list.DELETE;
1077: call_order.DELETE;
1078: call_max_score.DELETE;
1079: HZ_DQM_SEARCH_UTIL.new_search;
1080: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1081: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1082:
1083: -- Transform search criteria

Line 1081: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1077: call_order.DELETE;
1078: call_max_score.DELETE;
1079: HZ_DQM_SEARCH_UTIL.new_search;
1080: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1081: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1082:
1083: -- Transform search criteria
1084: MAP_PARTY_REC(TRUE,p_party_search_rec, l_entered_max_score, g_party_stage_rec);
1085: MAP_PARTY_SITE_REC(TRUE,p_party_site_list, l_ps_entered_max_score, g_party_site_stage_list);

Line 1764: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1760: H_PARTY_ID.DELETE;
1761: H_PARTY_ID_LIST.DELETE;
1762: H_SCORES.DELETE;
1763: g_mappings.DELETE;
1764: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1765: call_order(5) := call_order(1);
1766: call_type(5) := 'AND';
1767: call_max_score(5) := call_max_score(1);
1768: call_type(2) := 'OR';

Line 2259: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2255: INSERT INTO HZ_MATCHED_CPTS_GT (SEARCH_CONTEXT_ID,CONTACT_POINT_ID,PARTY_ID,SCORE) VALUES (
2256: l_search_ctx_id, h_cpt_id(I), h_cpt_party_id(I), h_cpt_score(I));
2257: END IF;
2258:
2259: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2261: hz_utility_v2pub.debug(p_message=>'find_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
2262: END IF;
2263: EXCEPTION

Line 2427: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2423: H_PARTY_ID.DELETE;
2424: H_PARTY_ID_LIST.DELETE;
2425: H_SCORES.DELETE;
2426: g_mappings.DELETE;
2427: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2428: call_order(5) := call_order(1);
2429: call_type(5) := 'AND';
2430: call_max_score(5) := call_max_score(1);
2431: call_type(2) := 'OR';

Line 2914: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2910: INSERT INTO HZ_MATCHED_CPTS_GT (SEARCH_CONTEXT_ID,CONTACT_POINT_ID,PARTY_ID,SCORE) VALUES (
2911: l_search_ctx_id, h_cpt_id(I), h_cpt_party_id(I), h_cpt_score(I));
2912: END IF;
2913:
2914: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2915: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2916: 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);
2917: END IF;
2918: EXCEPTION