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_40 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 238: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

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

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

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

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

248: x_matchidx:=J;
249: RETURN l_current_score;
250: END IF;
251: END IF;
252: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
253: l_current_score:=l_current_score+ 20;
254: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
255: x_matchidx:=J;
256: RETURN l_current_score;

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

276: RETURN l_current_score;
277: END IF;
278: FOR J IN 1..g_contact_stage_list.COUNT LOOP
279: l_current_score := 0;
280: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+89)) THEN
281: l_current_score:=l_current_score+ 30;
282: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
283: x_matchidx:=J;
284: RETURN l_current_score;

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

283: x_matchidx:=J;
284: RETURN l_current_score;
285: END IF;
286: ELSIF -- l_current_score<27 AND
287: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+92)) THEN
288: l_current_score:=l_current_score+ 27;
289: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
290: x_matchidx:=J;
291: RETURN l_current_score;

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

310: RETURN l_current_score;
311: END IF;
312: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
313: l_current_score := 0;
314: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
315: l_current_score:=l_current_score+ 65;
316: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
317: x_matchidx:=J;
318: RETURN l_current_score;

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

433: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
434: 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);
435: END IF;
436: l_score :=0;
437: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
438: l_score :=50;
439: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
440: 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);
441: END IF;

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

439: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
440: 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);
441: END IF;
442: ELSIF l_current_score<40 AND
443: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
444: l_score :=40;
445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
446: 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);
447: END IF;

Line 468: 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

464: 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);
465: END IF;
466: END IF;
467: l_score :=0;
468: 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
469: l_score :=70;
470: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
471: 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);
472: END IF;

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

489: 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);
490: END IF;
491: END IF;
492: l_score :=0;
493: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
494: l_score :=70;
495: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
496: 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);
497: END IF;

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

533: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
534: 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);
535: END IF;
536: l_score :=0;
537: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
538: l_score :=60;
539: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
540: 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);
541: END IF;

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

539: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
540: 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);
541: END IF;
542: ELSIF l_current_score<48 AND
543: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
544: l_score :=48;
545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
546: 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);
547: END IF;

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

564: 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);
565: END IF;
566: END IF;
567: l_score :=0;
568: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
569: l_score :=20;
570: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
571: 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);
572: END IF;

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

607: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
608: 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);
609: END IF;
610: l_score :=0;
611: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN
612: l_score :=30;
613: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
614: 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);
615: END IF;

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

613: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
614: 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);
615: END IF;
616: ELSIF l_current_score<27 AND
617: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+92)) THEN
618: l_score :=27;
619: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
620: 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);
621: END IF;

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

655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
656: 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);
657: END IF;
658: l_score :=0;
659: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
660: l_score :=65;
661: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
662: 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);
663: END IF;

Line 834: HZ_DQM_SEARCH_UTIL.set_score;

830: END IF;
831: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
832: 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);
833: END IF;
834: HZ_DQM_SEARCH_UTIL.set_score;
835: g_mappings.DELETE;
836: g_party_site_stage_list.DELETE;
837: g_contact_stage_list.DELETE;
838: g_contact_pt_stage_list.DELETE;

Line 841: HZ_DQM_SEARCH_UTIL.new_search;

837: g_contact_stage_list.DELETE;
838: g_contact_pt_stage_list.DELETE;
839: call_order.DELETE;
840: call_max_score.DELETE;
841: HZ_DQM_SEARCH_UTIL.new_search;
842: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
843: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
844:
845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 843: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

839: call_order.DELETE;
840: call_max_score.DELETE;
841: HZ_DQM_SEARCH_UTIL.new_search;
842: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
843: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
844:
845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
846: 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);
847: END IF;

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

1025: END IF;
1026:
1027: -- Setup query string for PARTY_ALL_NAMES
1028: l_prim_temp := null;
1029: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1030: g_party_stage_rec.TX40,'A15',l_prim_temp);
1031:
1032: IF l_denorm_str IS NOT NULL THEN
1033: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

1031:
1032: IF l_denorm_str IS NOT NULL THEN
1033: IF (p_non_denorm_max_score+50)>=p_threshold THEN
1034: l_denorm_str := NULL;
1035: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1036: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
1037: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1038: l_denorm_str := NULL;
1039: END IF;

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

1033: IF (p_non_denorm_max_score+50)>=p_threshold THEN
1034: l_denorm_str := NULL;
1035: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1036: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
1037: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1038: l_denorm_str := NULL;
1039: END IF;
1040: ELSE
1041: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1037: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1038: l_denorm_str := NULL;
1039: END IF;
1040: ELSE
1041: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1042: END IF;
1043:
1044: -- Setup query string for TAX_REFERENCE
1045: l_prim_temp := null;

Line 1046: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1042: END IF;
1043:
1044: -- Setup query string for TAX_REFERENCE
1045: l_prim_temp := null;
1046: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1047: g_party_stage_rec.TX44,'A18',l_prim_temp);
1048:
1049: IF l_denorm_str IS NOT NULL THEN
1050: IF (p_non_denorm_max_score+70)>=p_threshold THEN

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

1048:
1049: IF l_denorm_str IS NOT NULL THEN
1050: IF (p_non_denorm_max_score+70)>=p_threshold THEN
1051: l_denorm_str := NULL;
1052: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1053: ELSIF (p_non_denorm_max_score+p_denorm_max_score+70)>=p_threshold THEN
1054: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1055: l_denorm_str := NULL;
1056: END IF;

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

1050: IF (p_non_denorm_max_score+70)>=p_threshold THEN
1051: l_denorm_str := NULL;
1052: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1053: ELSIF (p_non_denorm_max_score+p_denorm_max_score+70)>=p_threshold THEN
1054: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1055: l_denorm_str := NULL;
1056: END IF;
1057: ELSE
1058: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1054: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1055: l_denorm_str := NULL;
1056: END IF;
1057: ELSE
1058: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1059: END IF;
1060:
1061: -- Setup query string for DUNS_NUMBER_C
1062: l_prim_temp := null;

Line 1066: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1062: l_prim_temp := null;
1063: IF g_party_stage_rec.TX41 IS NOT NULL THEN
1064: IF ltrim(g_party_stage_rec.TX41,'0') IS NOT NULL THEN
1065: FOR I in lengthb(ltrim(g_party_stage_rec.TX41,'0'))..9 LOOP
1066: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1067: lpad(ltrim(g_party_stage_rec.TX41,'0'),I,chr(48)),'A16',l_prim_temp);
1068: END LOOP;
1069: END IF;
1070: END IF;

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

1071:
1072: IF l_denorm_str IS NOT NULL THEN
1073: IF (p_non_denorm_max_score+70)>=p_threshold THEN
1074: l_denorm_str := NULL;
1075: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1076: ELSIF (p_non_denorm_max_score+p_denorm_max_score+70)>=p_threshold THEN
1077: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1078: l_denorm_str := NULL;
1079: END IF;

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

1073: IF (p_non_denorm_max_score+70)>=p_threshold THEN
1074: l_denorm_str := NULL;
1075: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1076: ELSIF (p_non_denorm_max_score+p_denorm_max_score+70)>=p_threshold THEN
1077: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1078: l_denorm_str := NULL;
1079: END IF;
1080: ELSE
1081: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1077: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1078: l_denorm_str := NULL;
1079: END IF;
1080: ELSE
1081: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1082: END IF;
1083: IF lengthb(l_party_contains_str) > 4000 THEN
1084: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1085: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1130:
1131: -- Setup query string for ADDRESS
1132: l_prim_temp := null;
1133: l_prim_temp_den := null;
1134: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1135: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1136: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1137:
1138: -- Setup query string for POSTAL_CODE

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

1132: l_prim_temp := null;
1133: l_prim_temp_den := null;
1134: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1135: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1136: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1137:
1138: -- Setup query string for POSTAL_CODE
1139: l_prim_temp := null;
1140: l_prim_temp_den := null;

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

1137:
1138: -- Setup query string for POSTAL_CODE
1139: l_prim_temp := null;
1140: l_prim_temp_den := null;
1141: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1142: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1143: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1144: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1145: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1139: l_prim_temp := null;
1140: l_prim_temp_den := null;
1141: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1142: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1143: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1144: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1145: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1146: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1147:

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

1141: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1142: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1143: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1144: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1145: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1146: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1147:
1148: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1149: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1142: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1143: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1144: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1145: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1146: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1147:
1148: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1149: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1150: END LOOP;

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

1144: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1145: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1146: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1147:
1148: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1149: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1150: END LOOP;
1151: -- Add the search criteria to query string
1152: IF lengthb(l_contains_str) > 4000 THEN

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

1145: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1146: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1147:
1148: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1149: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1150: END LOOP;
1151: -- Add the search criteria to query string
1152: IF lengthb(l_contains_str) > 4000 THEN
1153: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1188: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRPERSON

1184:
1185: -- Setup query string for CONTACT_NAME
1186: l_prim_temp := null;
1187: l_prim_temp_den := null;
1188: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRPERSON
1189: g_contact_stage_list(I).TX5,'A39',l_prim_temp);
1190: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1191:
1192: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1186: l_prim_temp := null;
1187: l_prim_temp_den := null;
1188: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRPERSON
1189: g_contact_stage_list(I).TX5,'A39',l_prim_temp);
1190: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1191:
1192: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1193: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1194: END LOOP;

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

1188: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRPERSON
1189: g_contact_stage_list(I).TX5,'A39',l_prim_temp);
1190: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1191:
1192: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1193: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1194: END LOOP;
1195: -- Add the search criteria to query string
1196: IF lengthb(l_contains_str) > 4000 THEN

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

1189: g_contact_stage_list(I).TX5,'A39',l_prim_temp);
1190: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1191:
1192: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1193: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1194: END LOOP;
1195: -- Add the search criteria to query string
1196: IF lengthb(l_contains_str) > 4000 THEN
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1250:
1251: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1252: l_prim_temp := null;
1253: l_prim_temp_den := null;
1254: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1255: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1256: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1257:
1258: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1252: l_prim_temp := null;
1253: l_prim_temp_den := null;
1254: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1255: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1256: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1257:
1258: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1259: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1260: IF N>1 THEN

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

1254: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1255: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1256: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1257:
1258: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1259: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1260: IF N>1 THEN
1261: distinct_search_cpt_types := N-1;
1262: ELSE

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

1255: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1256: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1257:
1258: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1259: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1260: IF N>1 THEN
1261: distinct_search_cpt_types := N-1;
1262: ELSE
1263: distinct_search_cpt_types := N;

Line 2382: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2378: H_PARTY_ID.DELETE;
2379: H_PARTY_ID_LIST.DELETE;
2380: H_SCORES.DELETE;
2381: g_mappings.DELETE;
2382: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2383: call_order(5) := call_order(1);
2384: call_type(5) := 'AND';
2385: call_max_score(5) := call_max_score(1);
2386: call_type(2) := 'OR';

Line 3210: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3206: ELSE
3207: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3208: END IF;
3209: END LOOP;
3210: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3211: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3212: 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);
3213: END IF;
3214: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3370: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3366: H_PARTY_ID.DELETE;
3367: H_PARTY_ID_LIST.DELETE;
3368: H_SCORES.DELETE;
3369: g_mappings.DELETE;
3370: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3371: call_order(5) := call_order(1);
3372: call_type(5) := 'AND';
3373: call_max_score(5) := call_max_score(1);
3374: call_type(2) := 'OR';

Line 4069: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4065: ELSE
4066: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4067: END IF;
4068: END LOOP;
4069: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4070: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4071: 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);
4072: END IF;
4073: EXCEPTION