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

Line 188: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) 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.TX34, p_table_TX34,38) THEN
189: total := total+60;
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 197: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN

193: END IF;
194: RETURN total;
195: END IF;
196: END IF;
197: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN
198: total := total+60;
199: IF g_score_until_thresh AND (total)>=g_thres_score THEN
200: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
201: 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 206: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN

202: END IF;
203: RETURN total;
204: END IF;
205: END IF;
206: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
207: total := total+40;
208: IF g_score_until_thresh AND (total)>=g_thres_score THEN
209: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
210: 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 214: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

210: 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);
211: END IF;
212: RETURN total;
213: END IF;
214: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
215: total := total+32;
216: IF g_score_until_thresh AND (total)>=g_thres_score THEN
217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
218: 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 223: 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

219: END IF;
220: RETURN total;
221: END IF;
222: END IF;
223: 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
224: total := total+60;
225: IF g_score_until_thresh AND (total)>=g_thres_score THEN
226: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
227: 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 232: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN

228: END IF;
229: RETURN total;
230: END IF;
231: END IF;
232: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN
233: total := total+60;
234: IF g_score_until_thresh AND (total)>=g_thres_score THEN
235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
236: 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 295: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX7, p_table_TX7,(50000*(J-1)+116)) THEN

291: RETURN l_current_score;
292: END IF;
293: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
294: l_current_score := 0;
295: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX7, p_table_TX7,(50000*(J-1)+116)) THEN
296: l_current_score:=l_current_score+ 60;
297: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
298: x_matchidx:=J;
299: RETURN l_current_score;

Line 302: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX8, p_table_TX8,(50000*(J-1)+117)) THEN

298: x_matchidx:=J;
299: RETURN l_current_score;
300: END IF;
301: ELSIF -- l_current_score<48 AND
302: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX8, p_table_TX8,(50000*(J-1)+117)) THEN
303: l_current_score:=l_current_score+ 48;
304: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
305: x_matchidx:=J;
306: RETURN l_current_score;

Line 436: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN

432: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
433: 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);
434: END IF;
435: l_score :=0;
436: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
437: l_score :=60;
438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
439: 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);
440: END IF;

Line 461: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN

457: 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);
458: END IF;
459: END IF;
460: l_score :=0;
461: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN
462: l_score :=60;
463: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
464: 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);
465: END IF;

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

482: 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);
483: END IF;
484: END IF;
485: l_score :=0;
486: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
487: l_score :=40;
488: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
489: 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);
490: END IF;

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

488: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
489: 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);
490: END IF;
491: ELSIF l_current_score<32 AND
492: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
493: l_score :=32;
494: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
495: 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);
496: END IF;

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

513: 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);
514: END IF;
515: END IF;
516: l_score :=0;
517: 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
518: l_score :=60;
519: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
520: 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);
521: END IF;

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

538: 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);
539: END IF;
540: END IF;
541: l_score :=0;
542: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
543: l_score :=60;
544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
545: 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);
546: END IF;

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

613: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
614: 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);
615: END IF;
616: l_score :=0;
617: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX7, p_table_TX7,(50000*(p_idx-1)+116)) THEN
618: l_score :=60;
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 623: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+117)) THEN

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;
622: ELSIF l_current_score<48 AND
623: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+117)) THEN
624: l_score :=48;
625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
626: 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);
627: END IF;

Line 798: HZ_DQM_SEARCH_UTIL.set_score;

794: END IF;
795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
796: 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);
797: END IF;
798: HZ_DQM_SEARCH_UTIL.set_score;
799: g_mappings.DELETE;
800: g_party_site_stage_list.DELETE;
801: g_contact_stage_list.DELETE;
802: g_contact_pt_stage_list.DELETE;

Line 805: HZ_DQM_SEARCH_UTIL.new_search;

801: g_contact_stage_list.DELETE;
802: g_contact_pt_stage_list.DELETE;
803: call_order.DELETE;
804: call_max_score.DELETE;
805: HZ_DQM_SEARCH_UTIL.new_search;
806: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
807: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
808:
809: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 807: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

803: call_order.DELETE;
804: call_max_score.DELETE;
805: HZ_DQM_SEARCH_UTIL.new_search;
806: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
807: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
808:
809: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
810: 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);
811: END IF;

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

989: END IF;
990:
991: -- Setup query string for PARTY_ALL_NAMES
992: l_prim_temp := null;
993: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
994: g_party_stage_rec.TX40,'A15',l_prim_temp);
995:
996: IF l_denorm_str IS NOT NULL THEN
997: IF (p_non_denorm_max_score+40)>=p_threshold THEN

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

995:
996: IF l_denorm_str IS NOT NULL THEN
997: IF (p_non_denorm_max_score+40)>=p_threshold THEN
998: l_denorm_str := NULL;
999: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1000: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1001: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1002: l_denorm_str := NULL;
1003: END IF;

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

997: IF (p_non_denorm_max_score+40)>=p_threshold THEN
998: l_denorm_str := NULL;
999: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1000: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1001: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1002: l_denorm_str := NULL;
1003: END IF;
1004: ELSE
1005: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1001: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1002: l_denorm_str := NULL;
1003: END IF;
1004: ELSE
1005: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1006: END IF;
1007:
1008: -- Setup query string for DUNS_NUMBER_C
1009: l_prim_temp := null;

Line 1013: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1009: l_prim_temp := null;
1010: IF g_party_stage_rec.TX41 IS NOT NULL THEN
1011: IF ltrim(g_party_stage_rec.TX41,'0') IS NOT NULL THEN
1012: FOR I in lengthb(ltrim(g_party_stage_rec.TX41,'0'))..9 LOOP
1013: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1014: lpad(ltrim(g_party_stage_rec.TX41,'0'),I,chr(48)),'A16',l_prim_temp);
1015: END LOOP;
1016: END IF;
1017: END IF;

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

1018:
1019: IF l_denorm_str IS NOT NULL THEN
1020: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1021: l_denorm_str := NULL;
1022: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1023: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1024: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1025: l_denorm_str := NULL;
1026: END IF;

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

1020: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1021: l_denorm_str := NULL;
1022: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1023: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1024: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1025: l_denorm_str := NULL;
1026: END IF;
1027: ELSE
1028: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1024: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1025: l_denorm_str := NULL;
1026: END IF;
1027: ELSE
1028: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1029: END IF;
1030:
1031: -- Setup query string for JGZZ_FISCAL_CODE
1032: l_prim_temp := null;

Line 1033: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1029: END IF;
1030:
1031: -- Setup query string for JGZZ_FISCAL_CODE
1032: l_prim_temp := null;
1033: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1034: g_party_stage_rec.TX45,'A19',l_prim_temp);
1035:
1036: IF l_denorm_str IS NOT NULL THEN
1037: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1035:
1036: IF l_denorm_str IS NOT NULL THEN
1037: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1038: l_denorm_str := NULL;
1039: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1040: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1041: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1042: l_denorm_str := NULL;
1043: END IF;

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

1037: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1038: l_denorm_str := NULL;
1039: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1040: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1041: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1042: l_denorm_str := NULL;
1043: END IF;
1044: ELSE
1045: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1041: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1042: l_denorm_str := NULL;
1043: END IF;
1044: ELSE
1045: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1046: END IF;
1047:
1048: -- Setup query string for PARTY_NUMBER
1049: l_prim_temp := null;

Line 1050: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1046: END IF;
1047:
1048: -- Setup query string for PARTY_NUMBER
1049: l_prim_temp := null;
1050: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1051: g_party_stage_rec.TX34,'A12',l_prim_temp);
1052:
1053: IF l_denorm_str IS NOT NULL THEN
1054: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1052:
1053: IF l_denorm_str IS NOT NULL THEN
1054: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1055: l_denorm_str := NULL;
1056: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1057: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1058: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1059: l_denorm_str := NULL;
1060: END IF;

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

1054: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1055: l_denorm_str := NULL;
1056: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1057: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1058: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1059: l_denorm_str := NULL;
1060: END IF;
1061: ELSE
1062: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1058: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1059: l_denorm_str := NULL;
1060: END IF;
1061: ELSE
1062: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1063: END IF;
1064:
1065: -- Setup query string for ALL_ACCOUNT_NUMBERS
1066: l_prim_temp := null;

Line 1067: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1063: END IF;
1064:
1065: -- Setup query string for ALL_ACCOUNT_NUMBERS
1066: l_prim_temp := null;
1067: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1068: g_party_stage_rec.TX35,'A13',l_prim_temp);
1069:
1070: IF l_denorm_str IS NOT NULL THEN
1071: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

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

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

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

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

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

Line 1186: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN

1182:
1183: -- Setup query string for URL
1184: l_prim_temp := null;
1185: l_prim_temp_den := null;
1186: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN
1187: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1188: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1189:
1190: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1184: l_prim_temp := null;
1185: l_prim_temp_den := null;
1186: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN
1187: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1188: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1189:
1190: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1191: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1192: IF N>1 THEN

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

1186: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN
1187: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1188: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1189:
1190: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1191: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1192: IF N>1 THEN
1193: distinct_search_cpt_types := N-1;
1194: ELSE

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

1187: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1188: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1189:
1190: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1191: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1192: IF N>1 THEN
1193: distinct_search_cpt_types := N-1;
1194: ELSE
1195: distinct_search_cpt_types := N;

Line 2315: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2311: H_PARTY_ID.DELETE;
2312: H_PARTY_ID_LIST.DELETE;
2313: H_SCORES.DELETE;
2314: g_mappings.DELETE;
2315: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2316: call_order(5) := call_order(1);
2317: call_type(5) := 'AND';
2318: call_max_score(5) := call_max_score(1);
2319: call_type(2) := 'OR';

Line 3146: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3142: ELSE
3143: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3144: END IF;
3145: END LOOP;
3146: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3147: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3148: 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);
3149: END IF;
3150: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3304: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3300: H_PARTY_ID.DELETE;
3301: H_PARTY_ID_LIST.DELETE;
3302: H_SCORES.DELETE;
3303: g_mappings.DELETE;
3304: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3305: call_order(5) := call_order(1);
3306: call_type(5) := 'AND';
3307: call_max_score(5) := call_max_score(1);
3308: call_type(2) := 'OR';

Line 4006: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4002: ELSE
4003: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4004: END IF;
4005: END LOOP;
4006: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4008: 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);
4009: END IF;
4010: EXCEPTION