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

Line 187: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN

183: 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);
184: END IF;
185: RETURN total;
186: END IF;
187: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN
188: total := total+60;
189: IF g_score_until_thresh AND (total)>=g_thres_score THEN
190: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
191: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 196: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN

192: END IF;
193: RETURN total;
194: END IF;
195: END IF;
196: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN
197: total := total+60;
198: IF g_score_until_thresh AND (total)>=g_thres_score THEN
199: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
200: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 205: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN

201: END IF;
202: RETURN total;
203: END IF;
204: END IF;
205: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
206: total := total+40;
207: IF g_score_until_thresh AND (total)>=g_thres_score THEN
208: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
209: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 213: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

209: 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);
210: END IF;
211: RETURN total;
212: END IF;
213: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
214: total := total+32;
215: IF g_score_until_thresh AND (total)>=g_thres_score THEN
216: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

218: END IF;
219: RETURN total;
220: END IF;
221: END IF;
222: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN
223: total := total+60;
224: IF g_score_until_thresh AND (total)>=g_thres_score THEN
225: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
226: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

261: RETURN l_current_score;
262: END IF;
263: FOR J IN 1..g_contact_stage_list.COUNT LOOP
264: l_current_score := 0;
265: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN
266: l_current_score:=l_current_score+ 20;
267: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
268: x_matchidx:=J;
269: RETURN l_current_score;

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

290: RETURN l_current_score;
291: END IF;
292: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
293: l_current_score := 0;
294: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
295: l_current_score:=l_current_score+ 60;
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_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) 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_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
302: l_current_score:=l_current_score+ 60;
303: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
304: x_matchidx:=J;
305: RETURN l_current_score;

Line 308: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN

304: x_matchidx:=J;
305: RETURN l_current_score;
306: END IF;
307: ELSIF -- l_current_score<48 AND
308: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
309: l_current_score:=l_current_score+ 48;
310: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
311: x_matchidx:=J;
312: RETURN l_current_score;

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

440: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
441: 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);
442: END IF;
443: l_score :=0;
444: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
445: l_score :=60;
446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
447: 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);
448: END IF;

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

465: 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);
466: END IF;
467: END IF;
468: l_score :=0;
469: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN
470: l_score :=60;
471: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
472: 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);
473: END IF;

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

490: 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);
491: END IF;
492: END IF;
493: l_score :=0;
494: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
495: l_score :=40;
496: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
497: 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);
498: END IF;

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

496: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
497: 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);
498: END IF;
499: ELSIF l_current_score<32 AND
500: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
501: l_score :=32;
502: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
503: 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);
504: END IF;

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

521: 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);
522: END IF;
523: END IF;
524: l_score :=0;
525: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
526: l_score :=60;
527: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
528: 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);
529: END IF;

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

579: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
580: 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);
581: END IF;
582: l_score :=0;
583: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+109)) THEN
584: l_score :=20;
585: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
586: 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);
587: END IF;

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

623: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
624: 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);
625: END IF;
626: l_score :=0;
627: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
628: l_score :=60;
629: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
630: 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);
631: END IF;

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

648: 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);
649: END IF;
650: END IF;
651: l_score :=0;
652: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
653: l_score :=60;
654: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
655: 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);
656: END IF;

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

654: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
655: 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);
656: END IF;
657: ELSIF l_current_score<48 AND
658: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
659: l_score :=48;
660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
661: 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);
662: END IF;

Line 833: HZ_DQM_SEARCH_UTIL.set_score;

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

Line 840: HZ_DQM_SEARCH_UTIL.new_search;

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

Line 842: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

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

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

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

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

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

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

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

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

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

Line 1045: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1041: END IF;
1042:
1043: -- Setup query string for JGZZ_FISCAL_CODE
1044: l_prim_temp := null;
1045: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1046: g_party_stage_rec.TX45,'A19',l_prim_temp);
1047:
1048: IF l_denorm_str IS NOT NULL THEN
1049: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

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

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

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

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

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

Line 1062: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1058: END IF;
1059:
1060: -- Setup query string for ALL_ACCOUNT_NUMBERS
1061: l_prim_temp := null;
1062: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1063: g_party_stage_rec.TX35,'A13',l_prim_temp);
1064:
1065: IF l_denorm_str IS NOT NULL THEN
1066: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1064:
1065: IF l_denorm_str IS NOT NULL THEN
1066: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1067: l_denorm_str := NULL;
1068: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1069: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1070: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1071: l_denorm_str := NULL;
1072: END IF;

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

1066: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1067: l_denorm_str := NULL;
1068: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1069: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1070: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1071: l_denorm_str := NULL;
1072: END IF;
1073: ELSE
1074: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1070: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1071: l_denorm_str := NULL;
1072: END IF;
1073: ELSE
1074: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1075: END IF;
1076:
1077: -- Setup query string for PARTY_NUMBER
1078: l_prim_temp := null;

Line 1079: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1075: END IF;
1076:
1077: -- Setup query string for PARTY_NUMBER
1078: l_prim_temp := null;
1079: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1080: g_party_stage_rec.TX34,'A12',l_prim_temp);
1081:
1082: IF l_denorm_str IS NOT NULL THEN
1083: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1081:
1082: IF l_denorm_str IS NOT NULL THEN
1083: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1084: l_denorm_str := NULL;
1085: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1086: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1087: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1088: l_denorm_str := NULL;
1089: END IF;

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

1083: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1084: l_denorm_str := NULL;
1085: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1086: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1087: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1088: l_denorm_str := NULL;
1089: END IF;
1090: ELSE
1091: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1087: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1088: l_denorm_str := NULL;
1089: END IF;
1090: ELSE
1091: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1092: END IF;
1093: IF lengthb(l_party_contains_str) > 4000 THEN
1094: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1095: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 1160: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1156:
1157: -- Setup query string for JOB_TITLE
1158: l_prim_temp := null;
1159: l_prim_temp_den := null;
1160: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1161: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1162: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1163: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1164: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1162: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1158: l_prim_temp := null;
1159: l_prim_temp_den := null;
1160: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1161: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1162: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1163: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1164: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1165: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1166:

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

1160: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1161: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1162: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1163: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1164: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1165: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1166:
1167: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1168: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1161: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1162: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1163: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1164: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1165: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1166:
1167: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1168: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1169: END LOOP;

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

1163: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1164: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1165: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1166:
1167: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1168: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1169: END LOOP;
1170: -- Add the search criteria to query string
1171: IF lengthb(l_contains_str) > 4000 THEN

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

1164: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1165: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1166:
1167: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1168: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1169: END LOOP;
1170: -- Add the search criteria to query string
1171: IF lengthb(l_contains_str) > 4000 THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1225:
1226: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1227: l_prim_temp := null;
1228: l_prim_temp_den := null;
1229: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1230: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1231: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1232:
1233: -- Setup query string for EMAIL_ADDRESS

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

1227: l_prim_temp := null;
1228: l_prim_temp_den := null;
1229: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1230: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1231: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1232:
1233: -- Setup query string for EMAIL_ADDRESS
1234: l_prim_temp := null;
1235: l_prim_temp_den := null;

Line 1236: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN

1232:
1233: -- Setup query string for EMAIL_ADDRESS
1234: l_prim_temp := null;
1235: l_prim_temp_den := null;
1236: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1237: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1238: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1239:
1240: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1234: l_prim_temp := null;
1235: l_prim_temp_den := null;
1236: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1237: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1238: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1239:
1240: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1241: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1242: IF N>1 THEN

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

1236: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1237: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1238: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1239:
1240: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1241: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1242: IF N>1 THEN
1243: distinct_search_cpt_types := N-1;
1244: ELSE

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

1237: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1238: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1239:
1240: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1241: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1242: IF N>1 THEN
1243: distinct_search_cpt_types := N-1;
1244: ELSE
1245: distinct_search_cpt_types := N;

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 3190: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3186: ELSE
3187: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3188: END IF;
3189: END LOOP;
3190: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3191: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3192: 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);
3193: END IF;
3194: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3349: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3345: H_PARTY_ID.DELETE;
3346: H_PARTY_ID_LIST.DELETE;
3347: H_SCORES.DELETE;
3348: g_mappings.DELETE;
3349: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3350: call_order(5) := call_order(1);
3351: call_type(5) := 'AND';
3352: call_max_score(5) := call_max_score(1);
3353: call_type(2) := 'OR';

Line 4051: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4047: ELSE
4048: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4049: END IF;
4050: END LOOP;
4051: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4052: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4053: 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);
4054: END IF;
4055: EXCEPTION