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

Line 187: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) THEN

183: END IF;
184: IF g_score_until_thresh AND (total)>=g_thres_score THEN
185: RETURN total;
186: END IF;
187: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX2, p_table_TX2,6) THEN
188: total := total+80;
189: IF g_score_until_thresh AND (total)>=g_thres_score THEN
190: RETURN total;
191: END IF;

Line 192: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX59, p_table_TX59,138) THEN

188: total := total+80;
189: IF g_score_until_thresh AND (total)>=g_thres_score THEN
190: RETURN total;
191: END IF;
192: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX59, p_table_TX59,138) THEN
193: total := total+72;
194: IF g_score_until_thresh AND (total)>=g_thres_score THEN
195: RETURN total;
196: END IF;

Line 198: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN

194: IF g_score_until_thresh AND (total)>=g_thres_score THEN
195: RETURN total;
196: END IF;
197: END IF;
198: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN
199: total := total+200;
200: IF g_score_until_thresh AND (total)>=g_thres_score THEN
201: RETURN total;
202: END IF;

Line 222: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX26, p_table_TX26,(50000*(J-1)+140)) THEN

218: RETURN l_current_score;
219: END IF;
220: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
221: l_current_score := 0;
222: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX26, p_table_TX26,(50000*(J-1)+140)) THEN
223: l_current_score:=l_current_score+ 100;
224: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
225: x_matchidx:=J;
226: RETURN l_current_score;

Line 229: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN

225: x_matchidx:=J;
226: RETURN l_current_score;
227: END IF;
228: END IF;
229: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
230: l_current_score:=l_current_score+ 5;
231: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
232: x_matchidx:=J;
233: RETURN l_current_score;

Line 236: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN

232: x_matchidx:=J;
233: RETURN l_current_score;
234: END IF;
235: END IF;
236: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
237: l_current_score:=l_current_score+ 5;
238: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
239: x_matchidx:=J;
240: RETURN l_current_score;

Line 243: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN

239: x_matchidx:=J;
240: RETURN l_current_score;
241: END IF;
242: END IF;
243: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
244: l_current_score:=l_current_score+ 5;
245: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
246: x_matchidx:=J;
247: RETURN l_current_score;

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

287: RETURN l_current_score;
288: END IF;
289: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
290: l_current_score := 0;
291: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
292: l_current_score:=l_current_score+ 60;
293: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
294: x_matchidx:=J;
295: RETURN l_current_score;

Line 298: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX158, p_table_TX158,(50000*(J-1)+128)) THEN

294: x_matchidx:=J;
295: RETURN l_current_score;
296: END IF;
297: END IF;
298: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX158, p_table_TX158,(50000*(J-1)+128)) THEN
299: l_current_score:=l_current_score+ 70;
300: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
301: x_matchidx:=J;
302: RETURN l_current_score;

Line 305: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+120)) THEN

301: x_matchidx:=J;
302: RETURN l_current_score;
303: END IF;
304: ELSIF -- l_current_score<70 AND
305: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+120)) THEN
306: l_current_score:=l_current_score+ 70;
307: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
308: x_matchidx:=J;
309: RETURN l_current_score;

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

450: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
451: 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);
452: END IF;
453: l_score :=0;
454: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN
455: l_score :=80;
456: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
457: 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);
458: END IF;

Line 460: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX59, p_table_TX59,(50000*(p_idx-1)+138)) THEN

456: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
457: 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);
458: END IF;
459: ELSIF l_current_score<72 AND
460: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX59, p_table_TX59,(50000*(p_idx-1)+138)) THEN
461: l_score :=72;
462: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
463: 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);
464: END IF;

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

481: 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);
482: END IF;
483: END IF;
484: l_score :=0;
485: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
486: l_score :=200;
487: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
488: 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);
489: END IF;

Line 530: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX26, p_table_TX26,(50000*(p_idx-1)+140)) THEN

526: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
527: 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);
528: END IF;
529: l_score :=0;
530: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX26, p_table_TX26,(50000*(p_idx-1)+140)) THEN
531: l_score :=100;
532: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
533: 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);
534: END IF;

Line 555: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN

551: 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);
552: END IF;
553: END IF;
554: l_score :=0;
555: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
556: l_score :=5;
557: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
558: 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);
559: END IF;

Line 580: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN

576: 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);
577: END IF;
578: END IF;
579: l_score :=0;
580: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
581: l_score :=5;
582: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
583: 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);
584: END IF;

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

601: 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);
602: END IF;
603: END IF;
604: l_score :=0;
605: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
606: l_score :=5;
607: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
608: 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);
609: END IF;

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

661: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
662: 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);
663: END IF;
664: l_score :=0;
665: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
666: l_score :=60;
667: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
668: 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);
669: END IF;

Line 690: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX158, p_table_TX158,(50000*(p_idx-1)+128)) THEN

686: 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);
687: END IF;
688: END IF;
689: l_score :=0;
690: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX158, p_table_TX158,(50000*(p_idx-1)+128)) THEN
691: l_score :=70;
692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
693: 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);
694: END IF;

Line 696: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+120)) THEN

692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
693: 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);
694: END IF;
695: ELSIF l_current_score<70 AND
696: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+120)) THEN
697: l_score :=70;
698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
699: 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);
700: END IF;

Line 862: HZ_DQM_SEARCH_UTIL.set_score;

858: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: HZ_DQM_SEARCH_UTIL.set_score;
863: g_mappings.DELETE;
864: g_party_site_stage_list.DELETE;
865: g_contact_stage_list.DELETE;
866: g_contact_pt_stage_list.DELETE;

Line 869: HZ_DQM_SEARCH_UTIL.new_search;

865: g_contact_stage_list.DELETE;
866: g_contact_pt_stage_list.DELETE;
867: call_order.DELETE;
868: call_max_score.DELETE;
869: HZ_DQM_SEARCH_UTIL.new_search;
870: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
871: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
872:
873: -- Transform search criteria

Line 871: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

867: call_order.DELETE;
868: call_max_score.DELETE;
869: HZ_DQM_SEARCH_UTIL.new_search;
870: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
871: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
872:
873: -- Transform search criteria
874: MAP_PARTY_REC(TRUE,p_party_search_rec, l_entered_max_score, g_party_stage_rec);
875: MAP_PARTY_SITE_REC(TRUE,p_party_site_list, l_ps_entered_max_score, g_party_site_stage_list);

Line 1423: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1419: H_PARTY_ID.DELETE;
1420: H_PARTY_ID_LIST.DELETE;
1421: H_SCORES.DELETE;
1422: g_mappings.DELETE;
1423: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1424: call_order(5) := call_order(1);
1425: call_type(5) := 'AND';
1426: call_max_score(5) := call_max_score(1);
1427: call_type(2) := 'OR';

Line 1918: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

1914: INSERT INTO HZ_MATCHED_CPTS_GT (SEARCH_CONTEXT_ID,CONTACT_POINT_ID,PARTY_ID,SCORE) VALUES (
1915: l_search_ctx_id, h_cpt_id(I), h_cpt_party_id(I), h_cpt_score(I));
1916: END IF;
1917:
1918: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
1919: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1920: hz_utility_v2pub.debug(p_message=>'find_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
1921: END IF;
1922: EXCEPTION

Line 2083: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2079: H_PARTY_ID.DELETE;
2080: H_PARTY_ID_LIST.DELETE;
2081: H_SCORES.DELETE;
2082: g_mappings.DELETE;
2083: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2084: call_order(5) := call_order(1);
2085: call_type(5) := 'AND';
2086: call_max_score(5) := call_max_score(1);
2087: call_type(2) := 'OR';

Line 2570: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

2566: INSERT INTO HZ_MATCHED_CPTS_GT (SEARCH_CONTEXT_ID,CONTACT_POINT_ID,PARTY_ID,SCORE) VALUES (
2567: l_search_ctx_id, h_cpt_id(I), h_cpt_party_id(I), h_cpt_score(I));
2568: END IF;
2569:
2570: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
2571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2572: 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);
2573: END IF;
2574: EXCEPTION