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

Line 184: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN

180: 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);
181: END IF;
182: RETURN total;
183: END IF;
184: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
185: total := total+40;
186: IF g_score_until_thresh AND (total)>=g_thres_score THEN
187: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
188: 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 192: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

188: 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);
189: END IF;
190: RETURN total;
191: END IF;
192: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
193: total := total+32;
194: IF g_score_until_thresh AND (total)>=g_thres_score THEN
195: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
196: 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 235: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN

231: RETURN l_current_score;
232: END IF;
233: FOR J IN 1..g_contact_stage_list.COUNT LOOP
234: l_current_score := 0;
235: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN
236: l_current_score:=l_current_score+ 20;
237: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
238: x_matchidx:=J;
239: RETURN l_current_score;

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

260: RETURN l_current_score;
261: END IF;
262: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
263: l_current_score := 0;
264: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
265: l_current_score:=l_current_score+ 60;
266: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
267: x_matchidx:=J;
268: RETURN l_current_score;

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

267: x_matchidx:=J;
268: RETURN l_current_score;
269: END IF;
270: END IF;
271: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
272: l_current_score:=l_current_score+ 60;
273: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
274: x_matchidx:=J;
275: RETURN l_current_score;

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

274: x_matchidx:=J;
275: RETURN l_current_score;
276: END IF;
277: ELSIF -- l_current_score<48 AND
278: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
279: l_current_score:=l_current_score+ 48;
280: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
281: x_matchidx:=J;
282: RETURN l_current_score;

Line 368: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN

364: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
365: 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);
366: END IF;
367: l_score :=0;
368: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
369: l_score :=40;
370: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
371: 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);
372: END IF;

Line 374: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN

370: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
371: 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);
372: END IF;
373: ELSIF l_current_score<32 AND
374: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
375: l_score :=32;
376: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
377: 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);
378: END IF;

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

428: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
429: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_CONTACTS_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
430: END IF;
431: l_score :=0;
432: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+109)) THEN
433: l_score :=20;
434: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
435: 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);
436: END IF;

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

472: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
473: 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);
474: END IF;
475: l_score :=0;
476: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
477: l_score :=60;
478: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
479: 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);
480: END IF;

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

497: 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);
498: END IF;
499: END IF;
500: l_score :=0;
501: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
502: l_score :=60;
503: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
504: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
505: END IF;

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

503: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
504: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
505: END IF;
506: ELSIF l_current_score<48 AND
507: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
508: l_score :=48;
509: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
510: 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);
511: END IF;

Line 682: HZ_DQM_SEARCH_UTIL.set_score;

678: END IF;
679: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
680: 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);
681: END IF;
682: HZ_DQM_SEARCH_UTIL.set_score;
683: g_mappings.DELETE;
684: g_party_site_stage_list.DELETE;
685: g_contact_stage_list.DELETE;
686: g_contact_pt_stage_list.DELETE;

Line 689: HZ_DQM_SEARCH_UTIL.new_search;

685: g_contact_stage_list.DELETE;
686: g_contact_pt_stage_list.DELETE;
687: call_order.DELETE;
688: call_max_score.DELETE;
689: HZ_DQM_SEARCH_UTIL.new_search;
690: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
691: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
692:
693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 691: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

687: call_order.DELETE;
688: call_max_score.DELETE;
689: HZ_DQM_SEARCH_UTIL.new_search;
690: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
691: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
692:
693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
694: 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);
695: END IF;

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

873: END IF;
874:
875: -- Setup query string for PARTY_ALL_NAMES
876: l_prim_temp := null;
877: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
878: g_party_stage_rec.TX40,'A15',l_prim_temp);
879:
880: IF l_denorm_str IS NOT NULL THEN
881: IF (p_non_denorm_max_score+40)>=p_threshold THEN

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

879:
880: IF l_denorm_str IS NOT NULL THEN
881: IF (p_non_denorm_max_score+40)>=p_threshold THEN
882: l_denorm_str := NULL;
883: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
884: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
885: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
886: l_denorm_str := NULL;
887: END IF;

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

881: IF (p_non_denorm_max_score+40)>=p_threshold THEN
882: l_denorm_str := NULL;
883: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
884: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
885: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
886: l_denorm_str := NULL;
887: END IF;
888: ELSE
889: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

885: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
886: l_denorm_str := NULL;
887: END IF;
888: ELSE
889: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
890: END IF;
891: IF lengthb(l_party_contains_str) > 4000 THEN
892: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
893: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

954:
955: -- Setup query string for JOB_TITLE
956: l_prim_temp := null;
957: l_prim_temp_den := null;
958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
959: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
960: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
961: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
962: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 960: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

956: l_prim_temp := null;
957: l_prim_temp_den := null;
958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
959: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
960: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
961: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
962: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
963: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
964:

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

958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
959: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
960: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
961: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
962: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
963: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
964:
965: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
966: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

959: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
960: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
961: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
962: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
963: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
964:
965: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
966: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
967: END LOOP;

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

961: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
962: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
963: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
964:
965: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
966: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
967: END LOOP;
968: -- Add the search criteria to query string
969: IF lengthb(l_contains_str) > 4000 THEN

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

962: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
963: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
964:
965: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
966: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
967: END LOOP;
968: -- Add the search criteria to query string
969: IF lengthb(l_contains_str) > 4000 THEN
970: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1027: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX

1023:
1024: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1025: l_prim_temp := null;
1026: l_prim_temp_den := null;
1027: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1028: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1029: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1030:
1031: -- Setup query string for EMAIL_ADDRESS

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

1025: l_prim_temp := null;
1026: l_prim_temp_den := null;
1027: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1028: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1029: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1030:
1031: -- Setup query string for EMAIL_ADDRESS
1032: l_prim_temp := null;
1033: l_prim_temp_den := null;

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

1030:
1031: -- Setup query string for EMAIL_ADDRESS
1032: l_prim_temp := null;
1033: l_prim_temp_den := null;
1034: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1035: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1036: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1037:
1038: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1032: l_prim_temp := null;
1033: l_prim_temp_den := null;
1034: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1035: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1036: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1037:
1038: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1039: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1040: IF N>1 THEN

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

1034: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1035: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1036: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1037:
1038: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1039: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1040: IF N>1 THEN
1041: distinct_search_cpt_types := N-1;
1042: ELSE

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

1035: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1036: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1037:
1038: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1039: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1040: IF N>1 THEN
1041: distinct_search_cpt_types := N-1;
1042: ELSE
1043: distinct_search_cpt_types := N;

Line 2133: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2129: H_PARTY_ID.DELETE;
2130: H_PARTY_ID_LIST.DELETE;
2131: H_SCORES.DELETE;
2132: g_mappings.DELETE;
2133: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2134: call_order(5) := call_order(1);
2135: call_type(5) := 'AND';
2136: call_max_score(5) := call_max_score(1);
2137: call_type(2) := 'OR';

Line 2962: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2958: ELSE
2959: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
2960: END IF;
2961: END LOOP;
2962: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2963: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2964: 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);
2965: END IF;
2966: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3118: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3114: H_PARTY_ID.DELETE;
3115: H_PARTY_ID_LIST.DELETE;
3116: H_SCORES.DELETE;
3117: g_mappings.DELETE;
3118: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3119: call_order(5) := call_order(1);
3120: call_type(5) := 'AND';
3121: call_max_score(5) := call_max_score(1);
3122: call_type(2) := 'OR';

Line 3818: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3814: ELSE
3815: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3816: END IF;
3817: END LOOP;
3818: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3820: 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);
3821: END IF;
3822: EXCEPTION