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

Line 186: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) 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.TX2, p_table_TX2,6) 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.TX8, p_table_TX8,12) 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.TX8, p_table_TX8,12) THEN
195: total := total+45;
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 202: ELSIF HZ_DQM_SEARCH_UTIL.is_similar_match(g_party_stage_rec.TX4, p_table_TX4, 75,8) 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);
199: END IF;
200: RETURN total;
201: END IF;
202: ELSIF HZ_DQM_SEARCH_UTIL.is_similar_match(g_party_stage_rec.TX4, p_table_TX4, 75,8) THEN
203: total := total+30;
204: IF g_score_until_thresh AND (total)>=g_thres_score THEN
205: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
206: 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 211: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

207: END IF;
208: RETURN total;
209: END IF;
210: END IF;
211: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
212: total := total+100;
213: IF g_score_until_thresh AND (total)>=g_thres_score THEN
214: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
215: 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 237: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

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

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

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

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

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

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

295: RETURN l_current_score;
296: END IF;
297: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
298: l_current_score := 0;
299: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
300: l_current_score:=l_current_score+ 65;
301: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
302: x_matchidx:=J;
303: RETURN l_current_score;

Line 306: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN

302: x_matchidx:=J;
303: RETURN l_current_score;
304: END IF;
305: END IF;
306: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
307: l_current_score:=l_current_score+ 65;
308: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
309: x_matchidx:=J;
310: RETURN l_current_score;

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

309: x_matchidx:=J;
310: RETURN l_current_score;
311: END IF;
312: ELSIF -- l_current_score<46 AND
313: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
314: l_current_score:=l_current_score+ 46;
315: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
316: x_matchidx:=J;
317: RETURN l_current_score;

Line 437: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) 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.TX2, p_table_TX2,(50000*(p_idx-1)+6)) 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.TX8, p_table_TX8,(50000*(p_idx-1)+12)) 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<45 AND
443: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN
444: l_score :=45;
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 449: HZ_DQM_SEARCH_UTIL.is_similar_match(p_stage_rec.TX4, p_table_TX4, 75,(50000*(p_idx-1)+8)) THEN

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;
448: ELSIF l_current_score<30 AND
449: HZ_DQM_SEARCH_UTIL.is_similar_match(p_stage_rec.TX4, p_table_TX4, 75,(50000*(p_idx-1)+8)) THEN
450: l_score :=30;
451: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
452: 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);
453: END IF;

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

470: 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);
471: END IF;
472: END IF;
473: l_score :=0;
474: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
475: l_score :=100;
476: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
477: 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);
478: END IF;

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

514: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
515: 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);
516: END IF;
517: l_score :=0;
518: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
519: l_score :=60;
520: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
521: 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);
522: END IF;

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

520: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
521: 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);
522: END IF;
523: ELSIF l_current_score<42 AND
524: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
525: l_score :=42;
526: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
527: 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);
528: END IF;

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

545: 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);
546: END IF;
547: END IF;
548: l_score :=0;
549: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
550: l_score :=20;
551: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
552: 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);
553: END IF;

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

605: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
606: 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);
607: END IF;
608: l_score :=0;
609: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
610: l_score :=65;
611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
612: 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);
613: END IF;

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

630: 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);
631: END IF;
632: END IF;
633: l_score :=0;
634: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
635: l_score :=65;
636: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
637: 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);
638: END IF;

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

636: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
637: 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);
638: END IF;
639: ELSIF l_current_score<46 AND
640: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
641: l_score :=46;
642: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
643: 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);
644: END IF;

Line 815: HZ_DQM_SEARCH_UTIL.set_score;

811: END IF;
812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
813: 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);
814: END IF;
815: HZ_DQM_SEARCH_UTIL.set_score;
816: g_mappings.DELETE;
817: g_party_site_stage_list.DELETE;
818: g_contact_stage_list.DELETE;
819: g_contact_pt_stage_list.DELETE;

Line 822: HZ_DQM_SEARCH_UTIL.new_search;

818: g_contact_stage_list.DELETE;
819: g_contact_pt_stage_list.DELETE;
820: call_order.DELETE;
821: call_max_score.DELETE;
822: HZ_DQM_SEARCH_UTIL.new_search;
823: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
824: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
825:
826: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 824: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

820: call_order.DELETE;
821: call_max_score.DELETE;
822: HZ_DQM_SEARCH_UTIL.new_search;
823: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
824: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
825:
826: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
827: 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);
828: END IF;

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

1006: END IF;
1007:
1008: -- Setup query string for PARTY_NAME
1009: l_prim_temp := null;
1010: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1011: g_party_stage_rec.TX4,'A8',l_prim_temp);
1012:
1013: IF l_denorm_str IS NOT NULL THEN
1014: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

1012:
1013: IF l_denorm_str IS NOT NULL THEN
1014: IF (p_non_denorm_max_score+50)>=p_threshold THEN
1015: l_denorm_str := NULL;
1016: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1017: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
1018: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1019: l_denorm_str := NULL;
1020: END IF;

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

1014: IF (p_non_denorm_max_score+50)>=p_threshold THEN
1015: l_denorm_str := NULL;
1016: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1017: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
1018: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1019: l_denorm_str := NULL;
1020: END IF;
1021: ELSE
1022: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1018: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1019: l_denorm_str := NULL;
1020: END IF;
1021: ELSE
1022: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1023: END IF;
1024:
1025: -- Setup query string for TAX_REFERENCE
1026: l_prim_temp := null;

Line 1027: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1023: END IF;
1024:
1025: -- Setup query string for TAX_REFERENCE
1026: l_prim_temp := null;
1027: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1028: g_party_stage_rec.TX44,'A18',l_prim_temp);
1029:
1030: IF l_denorm_str IS NOT NULL THEN
1031: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

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

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

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

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

1035: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1036: l_denorm_str := NULL;
1037: END IF;
1038: ELSE
1039: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1040: END IF;
1041: IF lengthb(l_party_contains_str) > 4000 THEN
1042: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1043: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1088:
1089: -- Setup query string for ADDRESS
1090: l_prim_temp := null;
1091: l_prim_temp_den := null;
1092: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1093: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1094: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1095:
1096: -- Setup query string for POSTAL_CODE

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

1090: l_prim_temp := null;
1091: l_prim_temp_den := null;
1092: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1093: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1094: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1095:
1096: -- Setup query string for POSTAL_CODE
1097: l_prim_temp := null;
1098: l_prim_temp_den := null;

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

1095:
1096: -- Setup query string for POSTAL_CODE
1097: l_prim_temp := null;
1098: l_prim_temp_den := null;
1099: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1100: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1101: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1102: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1103: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1097: l_prim_temp := null;
1098: l_prim_temp_den := null;
1099: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1100: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1101: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1102: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1103: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1104: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1105:

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

1099: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1100: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1101: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1102: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1103: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1104: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1105:
1106: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1107: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1100: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1101: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1102: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1103: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1104: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1105:
1106: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1107: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1108: END LOOP;

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

1102: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1103: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1104: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1105:
1106: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1107: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1108: END LOOP;
1109: -- Add the search criteria to query string
1110: IF lengthb(l_contains_str) > 4000 THEN

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

1103: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1104: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1105:
1106: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1107: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1108: END LOOP;
1109: -- Add the search criteria to query string
1110: IF lengthb(l_contains_str) > 4000 THEN
1111: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1159:
1160: -- Setup query string for EMAIL_ADDRESS
1161: l_prim_temp := null;
1162: l_prim_temp_den := null;
1163: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1164: g_contact_pt_stage_list(I).TX6,'A48',l_prim_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);

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

1161: l_prim_temp := null;
1162: l_prim_temp_den := null;
1163: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1164: g_contact_pt_stage_list(I).TX6,'A48',l_prim_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: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1164: g_contact_pt_stage_list(I).TX6,'A48',l_prim_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: g_contact_pt_stage_list(I).TX6,'A48',l_prim_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 2263: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2259: H_PARTY_ID.DELETE;
2260: H_PARTY_ID_LIST.DELETE;
2261: H_SCORES.DELETE;
2262: g_mappings.DELETE;
2263: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2264: call_order(5) := call_order(1);
2265: call_type(5) := 'AND';
2266: call_max_score(5) := call_max_score(1);
2267: call_type(2) := 'OR';

Line 3054: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3050: ELSE
3051: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3052: END IF;
3053: END LOOP;
3054: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3055: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3056: 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);
3057: END IF;
3058: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3213: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3209: H_PARTY_ID.DELETE;
3210: H_PARTY_ID_LIST.DELETE;
3211: H_SCORES.DELETE;
3212: g_mappings.DELETE;
3213: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3214: call_order(5) := call_order(1);
3215: call_type(5) := 'AND';
3216: call_max_score(5) := call_max_score(1);
3217: call_type(2) := 'OR';

Line 3844: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3840: ELSE
3841: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3842: END IF;
3843: END LOOP;
3844: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3845: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3846: 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);
3847: END IF;
3848: EXCEPTION