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

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

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

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

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

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

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

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

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

Line 236: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX26, p_table_TX26,(50000*(J-1)+140)) THEN

232: RETURN l_current_score;
233: END IF;
234: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
235: l_current_score := 0;
236: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX26, p_table_TX26,(50000*(J-1)+140)) THEN
237: l_current_score:=l_current_score+ 100;
238: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
239: x_matchidx:=J;
240: RETURN l_current_score;

Line 243: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN

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

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

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

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

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

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

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

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

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

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

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

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

325: RETURN l_current_score;
326: END IF;
327: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
328: l_current_score := 0;
329: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX7, p_table_TX7,(50000*(J-1)+116)) THEN
330: l_current_score:=l_current_score+ 20;
331: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
332: x_matchidx:=J;
333: RETURN l_current_score;

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

332: x_matchidx:=J;
333: RETURN l_current_score;
334: END IF;
335: END IF;
336: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX158, p_table_TX158,(50000*(J-1)+128)) THEN
337: l_current_score:=l_current_score+ 70;
338: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
339: x_matchidx:=J;
340: RETURN l_current_score;

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

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

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

530: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
531: 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);
532: END IF;
533: l_score :=0;
534: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN
535: l_score :=80;
536: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
537: 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);
538: END IF;

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

536: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
537: 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);
538: END IF;
539: ELSIF l_current_score<72 AND
540: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX59, p_table_TX59,(50000*(p_idx-1)+138)) THEN
541: l_score :=72;
542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
543: 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);
544: END IF;

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

561: 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);
562: END IF;
563: END IF;
564: l_score :=0;
565: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX41, p_table_TX41,(50000*(p_idx-1)+45)) THEN
566: l_score :=200;
567: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
568: 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);
569: END IF;

Line 590: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN

586: 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);
587: END IF;
588: END IF;
589: l_score :=0;
590: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
591: l_score :=200;
592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
593: 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);
594: END IF;

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

631: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
632: 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);
633: END IF;
634: l_score :=0;
635: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX26, p_table_TX26,(50000*(p_idx-1)+140)) THEN
636: l_score :=100;
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.TX9, p_table_TX9,(50000*(p_idx-1)+72)) 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.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
661: l_score :=15;
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 685: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN

681: 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);
682: END IF;
683: END IF;
684: l_score :=0;
685: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
686: l_score :=5;
687: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
688: 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);
689: END IF;

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

706: 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);
707: END IF;
708: END IF;
709: l_score :=0;
710: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
711: l_score :=5;
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 754: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN

750: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
751: 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);
752: END IF;
753: l_score :=0;
754: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN
755: l_score :=20;
756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
757: 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);
758: END IF;

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

756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
757: 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);
758: END IF;
759: ELSIF l_current_score<18 AND
760: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX23, p_table_TX23,(50000*(p_idx-1)+136)) THEN
761: l_score :=18;
762: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
763: 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);
764: END IF;

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

781: 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);
782: END IF;
783: END IF;
784: l_score :=0;
785: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+109)) THEN
786: l_score :=10;
787: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
788: 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);
789: END IF;

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

825: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
826: 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);
827: END IF;
828: l_score :=0;
829: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX7, p_table_TX7,(50000*(p_idx-1)+116)) THEN
830: l_score :=20;
831: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
832: 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);
833: END IF;

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

850: 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);
851: END IF;
852: END IF;
853: l_score :=0;
854: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX158, p_table_TX158,(50000*(p_idx-1)+128)) THEN
855: l_score :=70;
856: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
857: 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);
858: END IF;

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

856: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
857: 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);
858: END IF;
859: ELSIF l_current_score<70 AND
860: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+120)) THEN
861: l_score :=70;
862: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
863: 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);
864: END IF;

Line 1026: HZ_DQM_SEARCH_UTIL.set_score;

1022: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1023: FND_MSG_PUB.ADD;
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: HZ_DQM_SEARCH_UTIL.set_score;
1027: g_mappings.DELETE;
1028: g_party_site_stage_list.DELETE;
1029: g_contact_stage_list.DELETE;
1030: g_contact_pt_stage_list.DELETE;

Line 1033: HZ_DQM_SEARCH_UTIL.new_search;

1029: g_contact_stage_list.DELETE;
1030: g_contact_pt_stage_list.DELETE;
1031: call_order.DELETE;
1032: call_max_score.DELETE;
1033: HZ_DQM_SEARCH_UTIL.new_search;
1034: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1035: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1036:
1037: -- Transform search criteria

Line 1035: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1031: call_order.DELETE;
1032: call_max_score.DELETE;
1033: HZ_DQM_SEARCH_UTIL.new_search;
1034: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1035: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1036:
1037: -- Transform search criteria
1038: MAP_PARTY_REC(TRUE,p_party_search_rec, l_entered_max_score, g_party_stage_rec);
1039: MAP_PARTY_SITE_REC(TRUE,p_party_site_list, l_ps_entered_max_score, g_party_site_stage_list);

Line 1697: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1693: H_PARTY_ID.DELETE;
1694: H_PARTY_ID_LIST.DELETE;
1695: H_SCORES.DELETE;
1696: g_mappings.DELETE;
1697: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1698: call_order(5) := call_order(1);
1699: call_type(5) := 'AND';
1700: call_max_score(5) := call_max_score(1);
1701: call_type(2) := 'OR';

Line 2192: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2188: INSERT INTO HZ_MATCHED_CPTS_GT (SEARCH_CONTEXT_ID,CONTACT_POINT_ID,PARTY_ID,SCORE) VALUES (
2189: l_search_ctx_id, h_cpt_id(I), h_cpt_party_id(I), h_cpt_score(I));
2190: END IF;
2191:
2192: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2194: 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);
2195: END IF;
2196: EXCEPTION

Line 2359: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2355: H_PARTY_ID.DELETE;
2356: H_PARTY_ID_LIST.DELETE;
2357: H_SCORES.DELETE;
2358: g_mappings.DELETE;
2359: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2360: call_order(5) := call_order(1);
2361: call_type(5) := 'AND';
2362: call_max_score(5) := call_max_score(1);
2363: call_type(2) := 'OR';

Line 2846: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2842: INSERT INTO HZ_MATCHED_CPTS_GT (SEARCH_CONTEXT_ID,CONTACT_POINT_ID,PARTY_ID,SCORE) VALUES (
2843: l_search_ctx_id, h_cpt_id(I), h_cpt_party_id(I), h_cpt_score(I));
2844: END IF;
2845:
2846: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2848: 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);
2849: END IF;
2850: EXCEPTION