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

Line 183: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX4, p_table_TX4,8) THEN

179: 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);
180: END IF;
181: RETURN total;
182: END IF;
183: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX4, p_table_TX4,8) THEN
184: total := total+50;
185: IF g_score_until_thresh AND (total)>=g_thres_score THEN
186: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
187: 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 208: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN

204: RETURN l_current_score;
205: END IF;
206: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
207: l_current_score := 0;
208: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
209: l_current_score:=l_current_score+ 20;
210: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
211: x_matchidx:=J;
212: RETURN l_current_score;

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

211: x_matchidx:=J;
212: RETURN l_current_score;
213: END IF;
214: END IF;
215: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
216: l_current_score:=l_current_score+ 10;
217: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
218: x_matchidx:=J;
219: RETURN l_current_score;

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

258: RETURN l_current_score;
259: END IF;
260: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
261: l_current_score := 0;
262: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+111)) THEN
263: l_current_score:=l_current_score+ 10;
264: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
265: x_matchidx:=J;
266: RETURN l_current_score;

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

265: x_matchidx:=J;
266: RETURN l_current_score;
267: END IF;
268: END IF;
269: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
270: l_current_score:=l_current_score+ 10;
271: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
272: x_matchidx:=J;
273: RETURN l_current_score;

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

373: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
374: 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);
375: END IF;
376: l_score :=0;
377: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+8)) THEN
378: l_score :=50;
379: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
380: 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);
381: END IF;

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

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

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

441: 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);
442: END IF;
443: END IF;
444: l_score :=0;
445: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
446: l_score :=10;
447: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
448: 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);
449: END IF;

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

500: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
501: 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);
502: END IF;
503: l_score :=0;
504: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+111)) THEN
505: l_score :=10;
506: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
507: 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);
508: END IF;

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

525: 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);
526: END IF;
527: END IF;
528: l_score :=0;
529: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
530: l_score :=10;
531: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
532: 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);
533: END IF;

Line 704: HZ_DQM_SEARCH_UTIL.set_score;

700: END IF;
701: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
702: 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);
703: END IF;
704: HZ_DQM_SEARCH_UTIL.set_score;
705: g_mappings.DELETE;
706: g_party_site_stage_list.DELETE;
707: g_contact_stage_list.DELETE;
708: g_contact_pt_stage_list.DELETE;

Line 711: HZ_DQM_SEARCH_UTIL.new_search;

707: g_contact_stage_list.DELETE;
708: g_contact_pt_stage_list.DELETE;
709: call_order.DELETE;
710: call_max_score.DELETE;
711: HZ_DQM_SEARCH_UTIL.new_search;
712: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
713: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
714:
715: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 713: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

709: call_order.DELETE;
710: call_max_score.DELETE;
711: HZ_DQM_SEARCH_UTIL.new_search;
712: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
713: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
714:
715: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
716: 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);
717: END IF;

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

895: END IF;
896:
897: -- Setup query string for PARTY_NAME
898: l_prim_temp := null;
899: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
900: g_party_stage_rec.TX4,'A8',l_prim_temp);
901:
902: IF l_denorm_str IS NOT NULL THEN
903: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

901:
902: IF l_denorm_str IS NOT NULL THEN
903: IF (p_non_denorm_max_score+50)>=p_threshold THEN
904: l_denorm_str := NULL;
905: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
906: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
907: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
908: l_denorm_str := NULL;
909: END IF;

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

903: IF (p_non_denorm_max_score+50)>=p_threshold THEN
904: l_denorm_str := NULL;
905: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
906: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
907: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
908: l_denorm_str := NULL;
909: END IF;
910: ELSE
911: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

907: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
908: l_denorm_str := NULL;
909: END IF;
910: ELSE
911: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
912: END IF;
913: IF lengthb(l_party_contains_str) > 4000 THEN
914: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
915: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

960:
961: -- Setup query string for ADDRESS
962: l_prim_temp := null;
963: l_prim_temp_den := null;
964: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
965: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
966: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
967:
968: -- Setup query string for POSTAL_CODE

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

962: l_prim_temp := null;
963: l_prim_temp_den := null;
964: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
965: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
966: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
967:
968: -- Setup query string for POSTAL_CODE
969: l_prim_temp := null;
970: l_prim_temp_den := null;

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

967:
968: -- Setup query string for POSTAL_CODE
969: l_prim_temp := null;
970: l_prim_temp_den := null;
971: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
972: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
973: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
974: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
975: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

969: l_prim_temp := null;
970: l_prim_temp_den := null;
971: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
972: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
973: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
974: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
975: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
976: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
977:

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

971: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
972: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
973: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
974: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
975: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
976: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
977:
978: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
979: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

972: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
973: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
974: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
975: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
976: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
977:
978: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
979: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
980: END LOOP;

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

974: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
975: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
976: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
977:
978: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
979: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
980: END LOOP;
981: -- Add the search criteria to query string
982: IF lengthb(l_contains_str) > 4000 THEN

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

975: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
976: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
977:
978: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
979: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
980: END LOOP;
981: -- Add the search criteria to query string
982: IF lengthb(l_contains_str) > 4000 THEN
983: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1056: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1052:
1053: -- Setup query string for PHONE_NUMBER
1054: l_prim_temp := null;
1055: l_prim_temp_den := null;
1056: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1057: g_contact_pt_stage_list(I).TX2,'A45',l_prim_temp);
1058: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1059:
1060: -- Setup query string for EMAIL_ADDRESS

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

1054: l_prim_temp := null;
1055: l_prim_temp_den := null;
1056: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1057: g_contact_pt_stage_list(I).TX2,'A45',l_prim_temp);
1058: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1059:
1060: -- Setup query string for EMAIL_ADDRESS
1061: l_prim_temp := null;
1062: l_prim_temp_den := null;

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

1059:
1060: -- Setup query string for EMAIL_ADDRESS
1061: l_prim_temp := null;
1062: l_prim_temp_den := null;
1063: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1064: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1065: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1066:
1067: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1061: l_prim_temp := null;
1062: l_prim_temp_den := null;
1063: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1064: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1065: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1066:
1067: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1068: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1069: IF N>1 THEN

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

1063: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1064: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1065: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1066:
1067: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1068: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1069: IF N>1 THEN
1070: distinct_search_cpt_types := N-1;
1071: ELSE

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

1064: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1065: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1066:
1067: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1068: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1069: IF N>1 THEN
1070: distinct_search_cpt_types := N-1;
1071: ELSE
1072: distinct_search_cpt_types := N;

Line 2159: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2155: H_PARTY_ID.DELETE;
2156: H_PARTY_ID_LIST.DELETE;
2157: H_SCORES.DELETE;
2158: g_mappings.DELETE;
2159: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2160: call_order(5) := call_order(1);
2161: call_type(5) := 'AND';
2162: call_max_score(5) := call_max_score(1);
2163: call_type(2) := 'OR';

Line 2988: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2984: ELSE
2985: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
2986: END IF;
2987: END LOOP;
2988: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2989: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2990: 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);
2991: END IF;
2992: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3142: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3138: H_PARTY_ID.DELETE;
3139: H_PARTY_ID_LIST.DELETE;
3140: H_SCORES.DELETE;
3141: g_mappings.DELETE;
3142: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3143: call_order(5) := call_order(1);
3144: call_type(5) := 'AND';
3145: call_max_score(5) := call_max_score(1);
3146: call_type(2) := 'OR';

Line 3842: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

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