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

Line 185: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX8, p_table_TX8,12) THEN

181: 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);
182: END IF;
183: RETURN total;
184: END IF;
185: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX8, p_table_TX8,12) THEN
186: total := total+50;
187: IF g_score_until_thresh AND (total)>=g_thres_score THEN
188: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
189: 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 193: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) THEN

189: 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);
190: END IF;
191: RETURN total;
192: END IF;
193: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) THEN
194: total := total+50;
195: IF g_score_until_thresh AND (total)>=g_thres_score THEN
196: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
197: 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: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

198: END IF;
199: RETURN total;
200: END IF;
201: END IF;
202: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
203: total := total+100;
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 228: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

224: RETURN l_current_score;
225: END IF;
226: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
227: l_current_score := 0;
228: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
229: l_current_score:=l_current_score+ 60;
230: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
231: x_matchidx:=J;
232: RETURN l_current_score;

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

231: x_matchidx:=J;
232: RETURN l_current_score;
233: END IF;
234: ELSIF -- l_current_score<48 AND
235: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
236: l_current_score:=l_current_score+ 48;
237: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
238: x_matchidx:=J;
239: RETURN l_current_score;

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

238: x_matchidx:=J;
239: RETURN l_current_score;
240: END IF;
241: END IF;
242: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
243: l_current_score:=l_current_score+ 20;
244: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
245: x_matchidx:=J;
246: RETURN l_current_score;

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

286: RETURN l_current_score;
287: END IF;
288: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
289: l_current_score := 0;
290: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
291: l_current_score:=l_current_score+ 65;
292: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
293: x_matchidx:=J;
294: RETURN l_current_score;

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

293: x_matchidx:=J;
294: RETURN l_current_score;
295: END IF;
296: END IF;
297: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
298: l_current_score:=l_current_score+ 65;
299: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
300: x_matchidx:=J;
301: RETURN l_current_score;

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

300: x_matchidx:=J;
301: RETURN l_current_score;
302: END IF;
303: ELSIF -- l_current_score<46 AND
304: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
305: l_current_score:=l_current_score+ 46;
306: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
307: x_matchidx:=J;
308: RETURN l_current_score;

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

423: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
424: 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);
425: END IF;
426: l_score :=0;
427: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN
428: l_score :=50;
429: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
430: 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);
431: END IF;

Line 433: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN

429: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
430: 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);
431: END IF;
432: ELSIF l_current_score<50 AND
433: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN
434: l_score :=50;
435: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
436: 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);
437: END IF;

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

454: 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);
455: END IF;
456: END IF;
457: l_score :=0;
458: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
459: l_score :=100;
460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
461: 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);
462: END IF;

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

498: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
499: 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);
500: END IF;
501: l_score :=0;
502: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
503: l_score :=60;
504: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
505: 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);
506: END IF;

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

504: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
505: 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);
506: END IF;
507: ELSIF l_current_score<48 AND
508: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
509: l_score :=48;
510: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
511: 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);
512: END IF;

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

529: 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);
530: END IF;
531: END IF;
532: l_score :=0;
533: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
534: l_score :=20;
535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
536: 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);
537: END IF;

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

589: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
590: 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);
591: END IF;
592: l_score :=0;
593: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
594: l_score :=65;
595: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
596: 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);
597: END IF;

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

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

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

620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
621: 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);
622: END IF;
623: ELSIF l_current_score<46 AND
624: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
625: l_score :=46;
626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
627: 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);
628: END IF;

Line 799: HZ_DQM_SEARCH_UTIL.set_score;

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

Line 806: HZ_DQM_SEARCH_UTIL.new_search;

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

Line 808: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

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

Line 994: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRNAMES

990: END IF;
991:
992: -- Setup query string for PARTY_NAME
993: l_prim_temp := null;
994: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRNAMES
995: g_party_stage_rec.TX8,'A8',l_prim_temp);
996:
997: IF l_denorm_str IS NOT NULL THEN
998: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

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

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

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

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

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

Line 1011: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1007: END IF;
1008:
1009: -- Setup query string for TAX_REFERENCE
1010: l_prim_temp := null;
1011: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1012: g_party_stage_rec.TX44,'A18',l_prim_temp);
1013:
1014: IF l_denorm_str IS NOT NULL THEN
1015: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

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

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

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

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

1019: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1020: l_denorm_str := NULL;
1021: END IF;
1022: ELSE
1023: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1024: END IF;
1025: IF lengthb(l_party_contains_str) > 4000 THEN
1026: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1027: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1072:
1073: -- Setup query string for ADDRESS
1074: l_prim_temp := null;
1075: l_prim_temp_den := null;
1076: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1077: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1078: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1079:
1080: -- Setup query string for POSTAL_CODE

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

1074: l_prim_temp := null;
1075: l_prim_temp_den := null;
1076: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1077: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1078: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1079:
1080: -- Setup query string for POSTAL_CODE
1081: l_prim_temp := null;
1082: l_prim_temp_den := null;

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

1079:
1080: -- Setup query string for POSTAL_CODE
1081: l_prim_temp := null;
1082: l_prim_temp_den := null;
1083: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1084: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1085: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1086: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1087: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1081: l_prim_temp := null;
1082: l_prim_temp_den := null;
1083: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1084: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1085: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1086: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1087: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1088: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1089:

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

1083: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1084: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1085: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1086: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1087: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1088: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1089:
1090: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1091: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1084: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1085: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1086: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1087: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1088: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1089:
1090: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1091: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1092: END LOOP;

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

1086: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1087: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1088: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1089:
1090: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1091: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1092: END LOOP;
1093: -- Add the search criteria to query string
1094: IF lengthb(l_contains_str) > 4000 THEN

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

1087: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1088: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1089:
1090: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1091: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1092: END LOOP;
1093: -- Add the search criteria to query string
1094: IF lengthb(l_contains_str) > 4000 THEN
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1164:
1165: -- Setup query string for EMAIL_ADDRESS
1166: l_prim_temp := null;
1167: l_prim_temp_den := null;
1168: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1169: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1170: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1171:
1172: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1166: l_prim_temp := null;
1167: l_prim_temp_den := null;
1168: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1169: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1170: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1171:
1172: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1173: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1174: IF N>1 THEN

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

1168: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1169: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1170: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1171:
1172: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1173: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1174: IF N>1 THEN
1175: distinct_search_cpt_types := N-1;
1176: ELSE

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

1169: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1170: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1171:
1172: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1173: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1174: IF N>1 THEN
1175: distinct_search_cpt_types := N-1;
1176: ELSE
1177: distinct_search_cpt_types := N;

Line 2276: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2272: H_PARTY_ID.DELETE;
2273: H_PARTY_ID_LIST.DELETE;
2274: H_SCORES.DELETE;
2275: g_mappings.DELETE;
2276: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2277: call_order(5) := call_order(1);
2278: call_type(5) := 'AND';
2279: call_max_score(5) := call_max_score(1);
2280: call_type(2) := 'OR';

Line 3105: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3101: ELSE
3102: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3103: END IF;
3104: END LOOP;
3105: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3106: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3107: 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);
3108: END IF;
3109: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3264: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3260: H_PARTY_ID.DELETE;
3261: H_PARTY_ID_LIST.DELETE;
3262: H_SCORES.DELETE;
3263: g_mappings.DELETE;
3264: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3265: call_order(5) := call_order(1);
3266: call_type(5) := 'AND';
3267: call_max_score(5) := call_max_score(1);
3268: call_type(2) := 'OR';

Line 3964: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3960: ELSE
3961: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3962: END IF;
3963: END LOOP;
3964: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3966: 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);
3967: END IF;
3968: EXCEPTION