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

Line 185: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX4, p_table_TX4,8) 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.TX4, p_table_TX4,8) THEN
186: total := total+200;
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 194: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN

190: END IF;
191: RETURN total;
192: END IF;
193: END IF;
194: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN
195: total := total+300;
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 203: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN

199: END IF;
200: RETURN total;
201: END IF;
202: END IF;
203: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN
204: total := total+60;
205: IF g_score_until_thresh AND (total)>=g_thres_score THEN
206: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
207: 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).TX4, p_table_TX4,(50000*(J-1)+67)) 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).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
229: l_current_score:=l_current_score+ 80;
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: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN

231: x_matchidx:=J;
232: RETURN l_current_score;
233: END IF;
234: END IF;
235: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
236: l_current_score:=l_current_score+ 80;
237: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
238: x_matchidx:=J;
239: RETURN l_current_score;

Line 281: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+111)) THEN

277: RETURN l_current_score;
278: END IF;
279: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
280: l_current_score := 0;
281: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+111)) THEN
282: l_current_score:=l_current_score+ 70;
283: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
284: x_matchidx:=J;
285: RETURN l_current_score;

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

415: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
416: 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);
417: END IF;
418: l_score :=0;
419: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+8)) THEN
420: l_score :=200;
421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
422: 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);
423: END IF;

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

440: 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);
441: END IF;
442: END IF;
443: l_score :=0;
444: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
445: l_score :=300;
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.TX46, p_table_TX46,(50000*(p_idx-1)+51)) 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.TX46, p_table_TX46,(50000*(p_idx-1)+51)) 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 512: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN

508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
509: 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);
510: END IF;
511: l_score :=0;
512: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
513: l_score :=80;
514: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
515: 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);
516: END IF;

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

533: 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);
534: END IF;
535: END IF;
536: l_score :=0;
537: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
538: l_score :=80;
539: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
540: 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);
541: END IF;

Line 595: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+111)) THEN

591: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
592: 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);
593: END IF;
594: l_score :=0;
595: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+111)) THEN
596: l_score :=70;
597: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
598: 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);
599: END IF;

Line 770: HZ_DQM_SEARCH_UTIL.set_score;

766: END IF;
767: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
768: 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);
769: END IF;
770: HZ_DQM_SEARCH_UTIL.set_score;
771: g_mappings.DELETE;
772: g_party_site_stage_list.DELETE;
773: g_contact_stage_list.DELETE;
774: g_contact_pt_stage_list.DELETE;

Line 777: HZ_DQM_SEARCH_UTIL.new_search;

773: g_contact_stage_list.DELETE;
774: g_contact_pt_stage_list.DELETE;
775: call_order.DELETE;
776: call_max_score.DELETE;
777: HZ_DQM_SEARCH_UTIL.new_search;
778: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
779: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
780:
781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 779: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

775: call_order.DELETE;
776: call_max_score.DELETE;
777: HZ_DQM_SEARCH_UTIL.new_search;
778: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
779: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
780:
781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
782: 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);
783: END IF;

Line 965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

961: END IF;
962:
963: -- Setup query string for SIC_CODE
964: l_prim_temp := null;
965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
966: g_party_stage_rec.TX46,'A20',l_prim_temp);
967:
968: IF l_denorm_str IS NOT NULL THEN
969: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

967:
968: IF l_denorm_str IS NOT NULL THEN
969: IF (p_non_denorm_max_score+60)>=p_threshold THEN
970: l_denorm_str := NULL;
971: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
972: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
973: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
974: l_denorm_str := NULL;
975: END IF;

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

969: IF (p_non_denorm_max_score+60)>=p_threshold THEN
970: l_denorm_str := NULL;
971: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
972: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
973: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
974: l_denorm_str := NULL;
975: END IF;
976: ELSE
977: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

973: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
974: l_denorm_str := NULL;
975: END IF;
976: ELSE
977: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
978: END IF;
979:
980: -- Setup query string for PARTY_NAME
981: l_prim_temp := null;

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

978: END IF;
979:
980: -- Setup query string for PARTY_NAME
981: l_prim_temp := null;
982: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
983: g_party_stage_rec.TX4,'A8',l_prim_temp);
984:
985: IF l_denorm_str IS NOT NULL THEN
986: IF (p_non_denorm_max_score+200)>=p_threshold THEN

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

984:
985: IF l_denorm_str IS NOT NULL THEN
986: IF (p_non_denorm_max_score+200)>=p_threshold THEN
987: l_denorm_str := NULL;
988: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
989: ELSIF (p_non_denorm_max_score+p_denorm_max_score+200)>=p_threshold THEN
990: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
991: l_denorm_str := NULL;
992: END IF;

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

986: IF (p_non_denorm_max_score+200)>=p_threshold THEN
987: l_denorm_str := NULL;
988: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
989: ELSIF (p_non_denorm_max_score+p_denorm_max_score+200)>=p_threshold THEN
990: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
991: l_denorm_str := NULL;
992: END IF;
993: ELSE
994: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

990: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
991: l_denorm_str := NULL;
992: END IF;
993: ELSE
994: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
995: END IF;
996:
997: -- Setup query string for JGZZ_FISCAL_CODE
998: l_prim_temp := null;

Line 999: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

995: END IF;
996:
997: -- Setup query string for JGZZ_FISCAL_CODE
998: l_prim_temp := null;
999: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1000: g_party_stage_rec.TX45,'A19',l_prim_temp);
1001:
1002: IF l_denorm_str IS NOT NULL THEN
1003: IF (p_non_denorm_max_score+300)>=p_threshold THEN

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

1001:
1002: IF l_denorm_str IS NOT NULL THEN
1003: IF (p_non_denorm_max_score+300)>=p_threshold THEN
1004: l_denorm_str := NULL;
1005: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1006: ELSIF (p_non_denorm_max_score+p_denorm_max_score+300)>=p_threshold THEN
1007: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1008: l_denorm_str := NULL;
1009: END IF;

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

1003: IF (p_non_denorm_max_score+300)>=p_threshold THEN
1004: l_denorm_str := NULL;
1005: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1006: ELSIF (p_non_denorm_max_score+p_denorm_max_score+300)>=p_threshold THEN
1007: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1008: l_denorm_str := NULL;
1009: END IF;
1010: ELSE
1011: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1007: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1008: l_denorm_str := NULL;
1009: END IF;
1010: ELSE
1011: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1012: END IF;
1013: IF lengthb(l_party_contains_str) > 4000 THEN
1014: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1015: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1060:
1061: -- Setup query string for ADDRESS
1062: l_prim_temp := null;
1063: l_prim_temp_den := null;
1064: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1065: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1066: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1067:
1068: -- Setup query string for POSTAL_CODE

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

1062: l_prim_temp := null;
1063: l_prim_temp_den := null;
1064: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1065: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1066: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1067:
1068: -- Setup query string for POSTAL_CODE
1069: l_prim_temp := null;
1070: l_prim_temp_den := null;

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

1067:
1068: -- Setup query string for POSTAL_CODE
1069: l_prim_temp := null;
1070: l_prim_temp_den := null;
1071: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1072: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1073: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1074: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1075: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1069: l_prim_temp := null;
1070: l_prim_temp_den := null;
1071: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1072: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1073: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1074: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1075: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1076: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1077:

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

1071: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1072: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1073: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1074: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1075: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1076: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1077:
1078: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1079: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1072: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1073: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1074: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1075: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1076: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1077:
1078: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1079: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1080: END LOOP;

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

1074: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1075: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1076: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1077:
1078: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1079: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1080: END LOOP;
1081: -- Add the search criteria to query string
1082: IF lengthb(l_contains_str) > 4000 THEN

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

1075: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1076: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1077:
1078: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1079: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1080: END LOOP;
1081: -- Add the search criteria to query string
1082: IF lengthb(l_contains_str) > 4000 THEN
1083: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1152:
1153: -- Setup query string for PHONE_NUMBER
1154: l_prim_temp := null;
1155: l_prim_temp_den := null;
1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1157: g_contact_pt_stage_list(I).TX2,'A45',l_prim_temp);
1158: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1159:
1160: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1154: l_prim_temp := null;
1155: l_prim_temp_den := null;
1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1157: g_contact_pt_stage_list(I).TX2,'A45',l_prim_temp);
1158: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1159:
1160: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1161: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1162: IF N>1 THEN

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

1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1157: g_contact_pt_stage_list(I).TX2,'A45',l_prim_temp);
1158: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1159:
1160: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1161: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1162: IF N>1 THEN
1163: distinct_search_cpt_types := N-1;
1164: ELSE

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

1157: g_contact_pt_stage_list(I).TX2,'A45',l_prim_temp);
1158: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1159:
1160: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1161: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1162: IF N>1 THEN
1163: distinct_search_cpt_types := N-1;
1164: ELSE
1165: distinct_search_cpt_types := N;

Line 2267: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2263: H_PARTY_ID.DELETE;
2264: H_PARTY_ID_LIST.DELETE;
2265: H_SCORES.DELETE;
2266: g_mappings.DELETE;
2267: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2268: call_order(5) := call_order(1);
2269: call_type(5) := 'AND';
2270: call_max_score(5) := call_max_score(1);
2271: call_type(2) := 'OR';

Line 3096: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3092: ELSE
3093: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3094: END IF;
3095: END LOOP;
3096: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3098: 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);
3099: END IF;
3100: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3251: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3247: H_PARTY_ID.DELETE;
3248: H_PARTY_ID_LIST.DELETE;
3249: H_SCORES.DELETE;
3250: g_mappings.DELETE;
3251: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3252: call_order(5) := call_order(1);
3253: call_type(5) := 'AND';
3254: call_max_score(5) := call_max_score(1);
3255: call_type(2) := 'OR';

Line 3951: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3947: ELSE
3948: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3949: END IF;
3950: END LOOP;
3951: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3952: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3953: 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);
3954: END IF;
3955: EXCEPTION