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

Line 188: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX8, p_table_TX8,12) 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.TX8, p_table_TX8,12) THEN
189: total := total+100;
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 196: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX4, p_table_TX4,8) 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);
193: END IF;
194: RETURN total;
195: END IF;
196: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX4, p_table_TX4,8) THEN
197: total := total+80;
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 204: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX19, p_table_TX19,23) 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);
201: END IF;
202: RETURN total;
203: END IF;
204: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX19, p_table_TX19,23) THEN
205: total := total+70;
206: IF g_score_until_thresh AND (total)>=g_thres_score THEN
207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
208: 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: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN

209: END IF;
210: RETURN total;
211: END IF;
212: END IF;
213: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN
214: total := total+100;
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.TX36, p_table_TX36,40) 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.TX36, p_table_TX36,40) THEN
223: total := total+10;
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 231: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN

227: END IF;
228: RETURN total;
229: END IF;
230: END IF;
231: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN
232: total := total+20;
233: IF g_score_until_thresh AND (total)>=g_thres_score THEN
234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
235: 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 258: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN

254: RETURN l_current_score;
255: END IF;
256: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
257: l_current_score := 0;
258: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
259: l_current_score:=l_current_score+ 25;
260: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
261: x_matchidx:=J;
262: RETURN l_current_score;

Line 265: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN

261: x_matchidx:=J;
262: RETURN l_current_score;
263: END IF;
264: END IF;
265: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
266: l_current_score:=l_current_score+ 10;
267: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
268: x_matchidx:=J;
269: RETURN l_current_score;

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

268: x_matchidx:=J;
269: RETURN l_current_score;
270: END IF;
271: END IF;
272: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
273: l_current_score:=l_current_score+ 5;
274: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
275: x_matchidx:=J;
276: RETURN l_current_score;

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

275: x_matchidx:=J;
276: RETURN l_current_score;
277: END IF;
278: END IF;
279: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
280: l_current_score:=l_current_score+ 5;
281: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
282: x_matchidx:=J;
283: RETURN l_current_score;

Line 489: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN

485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
486: 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);
487: END IF;
488: l_score :=0;
489: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN
490: l_score :=100;
491: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
492: 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);
493: END IF;

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

491: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
492: 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);
493: END IF;
494: ELSIF l_current_score<80 AND
495: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+8)) THEN
496: l_score :=80;
497: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
498: 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);
499: END IF;

Line 501: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX19, p_table_TX19,(50000*(p_idx-1)+23)) THEN

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

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

522: 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);
523: END IF;
524: END IF;
525: l_score :=0;
526: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
527: l_score :=100;
528: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
529: 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);
530: END IF;

Line 551: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX36, p_table_TX36,(50000*(p_idx-1)+40)) THEN

547: 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);
548: END IF;
549: END IF;
550: l_score :=0;
551: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX36, p_table_TX36,(50000*(p_idx-1)+40)) THEN
552: l_score :=10;
553: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
554: 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);
555: END IF;

Line 576: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN

572: 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);
573: END IF;
574: END IF;
575: l_score :=0;
576: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN
577: l_score :=20;
578: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
579: 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);
580: END IF;

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

617: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
618: 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);
619: END IF;
620: l_score :=0;
621: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
622: l_score :=25;
623: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
624: 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);
625: END IF;

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

642: 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);
643: END IF;
644: END IF;
645: l_score :=0;
646: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
647: l_score :=10;
648: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
649: 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);
650: END IF;

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

667: 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);
668: END IF;
669: END IF;
670: l_score :=0;
671: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
672: l_score :=5;
673: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
674: 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);
675: END IF;

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

692: 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);
693: END IF;
694: END IF;
695: l_score :=0;
696: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
697: l_score :=5;
698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
699: 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);
700: END IF;

Line 908: HZ_DQM_SEARCH_UTIL.set_score;

904: END IF;
905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
906: 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);
907: END IF;
908: HZ_DQM_SEARCH_UTIL.set_score;
909: g_mappings.DELETE;
910: g_party_site_stage_list.DELETE;
911: g_contact_stage_list.DELETE;
912: g_contact_pt_stage_list.DELETE;

Line 915: HZ_DQM_SEARCH_UTIL.new_search;

911: g_contact_stage_list.DELETE;
912: g_contact_pt_stage_list.DELETE;
913: call_order.DELETE;
914: call_max_score.DELETE;
915: HZ_DQM_SEARCH_UTIL.new_search;
916: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
917: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
918:
919: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 917: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

913: call_order.DELETE;
914: call_max_score.DELETE;
915: HZ_DQM_SEARCH_UTIL.new_search;
916: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
917: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
918:
919: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
920: 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);
921: END IF;

Line 1103: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1099: END IF;
1100:
1101: -- Setup query string for PARTY_TYPE
1102: l_prim_temp := null;
1103: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1104: g_party_stage_rec.TX36,'A14',l_prim_temp);
1105:
1106: IF l_denorm_str IS NOT NULL THEN
1107: IF (p_non_denorm_max_score+10)>=p_threshold THEN

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

1105:
1106: IF l_denorm_str IS NOT NULL THEN
1107: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1108: l_denorm_str := NULL;
1109: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1110: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1111: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1112: l_denorm_str := NULL;
1113: END IF;

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

1107: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1108: l_denorm_str := NULL;
1109: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1110: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1111: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1112: l_denorm_str := NULL;
1113: END IF;
1114: ELSE
1115: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1111: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1112: l_denorm_str := NULL;
1113: END IF;
1114: ELSE
1115: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1116: END IF;
1117:
1118: -- Setup query string for SIC_CODE
1119: l_prim_temp := null;

Line 1120: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1116: END IF;
1117:
1118: -- Setup query string for SIC_CODE
1119: l_prim_temp := null;
1120: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1121: g_party_stage_rec.TX46,'A20',l_prim_temp);
1122:
1123: IF l_denorm_str IS NOT NULL THEN
1124: IF (p_non_denorm_max_score+20)>=p_threshold THEN

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

1122:
1123: IF l_denorm_str IS NOT NULL THEN
1124: IF (p_non_denorm_max_score+20)>=p_threshold THEN
1125: l_denorm_str := NULL;
1126: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1127: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
1128: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1129: l_denorm_str := NULL;
1130: END IF;

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

1124: IF (p_non_denorm_max_score+20)>=p_threshold THEN
1125: l_denorm_str := NULL;
1126: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1127: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
1128: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1129: l_denorm_str := NULL;
1130: END IF;
1131: ELSE
1132: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1128: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1129: l_denorm_str := NULL;
1130: END IF;
1131: ELSE
1132: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1133: END IF;
1134:
1135: -- Setup query string for PARTY_NAME
1136: l_prim_temp := null;

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

1133: END IF;
1134:
1135: -- Setup query string for PARTY_NAME
1136: l_prim_temp := null;
1137: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1138: g_party_stage_rec.TX4,'A8',l_prim_temp);
1139: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1140: g_party_stage_rec.TX19,'A8',l_prim_temp);
1141:

Line 1139: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX

1135: -- Setup query string for PARTY_NAME
1136: l_prim_temp := null;
1137: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1138: g_party_stage_rec.TX4,'A8',l_prim_temp);
1139: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1140: g_party_stage_rec.TX19,'A8',l_prim_temp);
1141:
1142: IF l_denorm_str IS NOT NULL THEN
1143: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1141:
1142: IF l_denorm_str IS NOT NULL THEN
1143: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1144: l_denorm_str := NULL;
1145: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1146: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1147: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1148: l_denorm_str := NULL;
1149: END IF;

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

1143: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1144: l_denorm_str := NULL;
1145: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1146: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1147: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1148: l_denorm_str := NULL;
1149: END IF;
1150: ELSE
1151: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1147: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1148: l_denorm_str := NULL;
1149: END IF;
1150: ELSE
1151: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1152: END IF;
1153:
1154: -- Setup query string for PARTY_NUMBER
1155: l_prim_temp := null;

Line 1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1152: END IF;
1153:
1154: -- Setup query string for PARTY_NUMBER
1155: l_prim_temp := null;
1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1157: g_party_stage_rec.TX34,'A12',l_prim_temp);
1158:
1159: IF l_denorm_str IS NOT NULL THEN
1160: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1158:
1159: IF l_denorm_str IS NOT NULL THEN
1160: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1161: l_denorm_str := NULL;
1162: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1163: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1164: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1165: l_denorm_str := NULL;
1166: END IF;

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

1160: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1161: l_denorm_str := NULL;
1162: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1163: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1164: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1165: l_denorm_str := NULL;
1166: END IF;
1167: ELSE
1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1164: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1165: l_denorm_str := NULL;
1166: END IF;
1167: ELSE
1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1169: END IF;
1170: IF lengthb(l_party_contains_str) > 4000 THEN
1171: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1172: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1217:
1218: -- Setup query string for ADDRESS
1219: l_prim_temp := null;
1220: l_prim_temp_den := null;
1221: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1222: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1223: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1224:
1225: -- Setup query string for CITY

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

1219: l_prim_temp := null;
1220: l_prim_temp_den := null;
1221: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1222: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1223: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1224:
1225: -- Setup query string for CITY
1226: l_prim_temp := null;
1227: l_prim_temp_den := null;

Line 1228: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1224:
1225: -- Setup query string for CITY
1226: l_prim_temp := null;
1227: l_prim_temp_den := null;
1228: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1229: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1230: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1231: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1232: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1230: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1226: l_prim_temp := null;
1227: l_prim_temp_den := null;
1228: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1229: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1230: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1231: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1232: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1233: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1234:

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

1228: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1229: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1230: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1231: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1232: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1233: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1234:
1235: -- Setup query string for STATE
1236: l_prim_temp := null;

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

1229: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1230: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1231: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1232: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1233: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1234:
1235: -- Setup query string for STATE
1236: l_prim_temp := null;
1237: l_prim_temp_den := null;

Line 1238: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE

1234:
1235: -- Setup query string for STATE
1236: l_prim_temp := null;
1237: l_prim_temp_den := null;
1238: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1239: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1240: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1241: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1242: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1240: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE

1236: l_prim_temp := null;
1237: l_prim_temp_den := null;
1238: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1239: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1240: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1241: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1242: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1243: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1244:

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

1238: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1239: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1240: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1241: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1242: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1243: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1244:
1245: -- Setup query string for COUNTRY
1246: l_prim_temp := null;

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

1239: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1240: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1241: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1242: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1243: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1244:
1245: -- Setup query string for COUNTRY
1246: l_prim_temp := null;
1247: l_prim_temp_den := null;

Line 1248: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1244:
1245: -- Setup query string for COUNTRY
1246: l_prim_temp := null;
1247: l_prim_temp_den := null;
1248: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1249: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1250: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1251: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1252: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1250: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1246: l_prim_temp := null;
1247: l_prim_temp_den := null;
1248: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1249: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1250: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1251: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1252: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1253: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1254:

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

1248: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1249: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1250: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1251: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1252: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1253: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1254:
1255: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1256: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1249: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1250: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1251: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1252: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1253: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1254:
1255: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1256: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1257: END LOOP;

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

1251: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1252: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1253: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1254:
1255: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1256: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1257: END LOOP;
1258: -- Add the search criteria to query string
1259: IF lengthb(l_contains_str) > 4000 THEN

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

1252: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1253: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1254:
1255: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1256: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1257: END LOOP;
1258: -- Add the search criteria to query string
1259: IF lengthb(l_contains_str) > 4000 THEN
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2411: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2407: H_PARTY_ID.DELETE;
2408: H_PARTY_ID_LIST.DELETE;
2409: H_SCORES.DELETE;
2410: g_mappings.DELETE;
2411: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2412: call_order(5) := call_order(1);
2413: call_type(5) := 'AND';
2414: call_max_score(5) := call_max_score(1);
2415: call_type(2) := 'OR';

Line 3202: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3198: ELSE
3199: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3200: END IF;
3201: END LOOP;
3202: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3203: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3204: 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);
3205: END IF;
3206: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3361: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3357: H_PARTY_ID.DELETE;
3358: H_PARTY_ID_LIST.DELETE;
3359: H_SCORES.DELETE;
3360: g_mappings.DELETE;
3361: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3362: call_order(5) := call_order(1);
3363: call_type(5) := 'AND';
3364: call_max_score(5) := call_max_score(1);
3365: call_type(2) := 'OR';

Line 3992: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3988: ELSE
3989: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3990: END IF;
3991: END LOOP;
3992: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3993: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3994: 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);
3995: END IF;
3996: EXCEPTION