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_99 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 225: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

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

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

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

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

235: x_matchidx:=J;
236: RETURN l_current_score;
237: END IF;
238: END IF;
239: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
240: l_current_score:=l_current_score+ 30;
241: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
242: x_matchidx:=J;
243: RETURN l_current_score;

Line 246: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN

242: x_matchidx:=J;
243: RETURN l_current_score;
244: END IF;
245: ELSIF -- l_current_score<24 AND
246: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
247: l_current_score:=l_current_score+ 24;
248: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
249: x_matchidx:=J;
250: RETURN l_current_score;

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

249: x_matchidx:=J;
250: RETURN l_current_score;
251: END IF;
252: END IF;
253: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
254: l_current_score:=l_current_score+ 40;
255: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
256: x_matchidx:=J;
257: RETURN l_current_score;

Line 260: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX12, p_table_TX12,(50000*(J-1)+75)) THEN

256: x_matchidx:=J;
257: RETURN l_current_score;
258: END IF;
259: END IF;
260: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX12, p_table_TX12,(50000*(J-1)+75)) THEN
261: l_current_score:=l_current_score+ 20;
262: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
263: x_matchidx:=J;
264: RETURN l_current_score;

Line 267: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX13, p_table_TX13,(50000*(J-1)+76)) THEN

263: x_matchidx:=J;
264: RETURN l_current_score;
265: END IF;
266: ELSIF -- l_current_score<16 AND
267: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX13, p_table_TX13,(50000*(J-1)+76)) THEN
268: l_current_score:=l_current_score+ 16;
269: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
270: x_matchidx:=J;
271: RETURN l_current_score;

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

270: x_matchidx:=J;
271: RETURN l_current_score;
272: END IF;
273: END IF;
274: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
275: l_current_score:=l_current_score+ 20;
276: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
277: x_matchidx:=J;
278: RETURN l_current_score;

Line 281: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN

277: x_matchidx:=J;
278: RETURN l_current_score;
279: END IF;
280: ELSIF -- l_current_score<16 AND
281: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN
282: l_current_score:=l_current_score+ 16;
283: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
284: x_matchidx:=J;
285: RETURN l_current_score;

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

284: x_matchidx:=J;
285: RETURN l_current_score;
286: END IF;
287: END IF;
288: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
289: l_current_score:=l_current_score+ 10;
290: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
291: x_matchidx:=J;
292: RETURN l_current_score;

Line 315: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN

311: RETURN l_current_score;
312: END IF;
313: FOR J IN 1..g_contact_stage_list.COUNT LOOP
314: l_current_score := 0;
315: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN
316: l_current_score:=l_current_score+ 20;
317: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
318: x_matchidx:=J;
319: RETURN l_current_score;

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

340: RETURN l_current_score;
341: END IF;
342: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
343: l_current_score := 0;
344: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
345: l_current_score:=l_current_score+ 60;
346: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
347: x_matchidx:=J;
348: RETURN l_current_score;

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

347: x_matchidx:=J;
348: RETURN l_current_score;
349: END IF;
350: END IF;
351: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
352: l_current_score:=l_current_score+ 60;
353: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
354: x_matchidx:=J;
355: RETURN l_current_score;

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

354: x_matchidx:=J;
355: RETURN l_current_score;
356: END IF;
357: ELSIF -- l_current_score<48 AND
358: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
359: l_current_score:=l_current_score+ 48;
360: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
361: x_matchidx:=J;
362: RETURN l_current_score;

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

513: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
514: 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);
515: END IF;
516: l_score :=0;
517: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
518: l_score :=40;
519: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
520: 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);
521: END IF;

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

519: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
520: 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);
521: END IF;
522: ELSIF l_current_score<32 AND
523: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
524: l_score :=32;
525: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
526: 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);
527: END IF;

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

570: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
571: 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);
572: END IF;
573: l_score :=0;
574: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
575: l_score :=40;
576: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
577: 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);
578: END IF;

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

576: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
577: 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);
578: END IF;
579: ELSIF l_current_score<32 AND
580: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
581: l_score :=32;
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.TX9, p_table_TX9,(50000*(p_idx-1)+72)) 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.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
606: l_score :=30;
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 611: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN

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;
610: ELSIF l_current_score<24 AND
611: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
612: l_score :=24;
613: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
614: 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);
615: END IF;

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

632: 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);
633: END IF;
634: END IF;
635: l_score :=0;
636: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
637: l_score :=40;
638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
639: 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);
640: END IF;

Line 661: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX12, p_table_TX12,(50000*(p_idx-1)+75)) THEN

657: 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);
658: END IF;
659: END IF;
660: l_score :=0;
661: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX12, p_table_TX12,(50000*(p_idx-1)+75)) THEN
662: l_score :=20;
663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
664: 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);
665: END IF;

Line 667: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX13, p_table_TX13,(50000*(p_idx-1)+76)) THEN

663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
664: 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);
665: END IF;
666: ELSIF l_current_score<16 AND
667: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX13, p_table_TX13,(50000*(p_idx-1)+76)) THEN
668: l_score :=16;
669: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
670: 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);
671: END IF;

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

688: 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);
689: END IF;
690: END IF;
691: l_score :=0;
692: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
693: l_score :=20;
694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
695: 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);
696: END IF;

Line 698: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN

694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
695: 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);
696: END IF;
697: ELSIF l_current_score<16 AND
698: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
699: l_score :=16;
700: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
701: 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);
702: END IF;

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

719: 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);
720: END IF;
721: END IF;
722: l_score :=0;
723: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
724: l_score :=10;
725: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
726: 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);
727: END IF;

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

761: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
762: 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);
763: END IF;
764: l_score :=0;
765: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+109)) THEN
766: l_score :=20;
767: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
768: 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);
769: END IF;

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

805: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
806: 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);
807: END IF;
808: l_score :=0;
809: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
810: l_score :=60;
811: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
812: 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);
813: END IF;

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

830: 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);
831: END IF;
832: END IF;
833: l_score :=0;
834: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
835: l_score :=60;
836: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
837: 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);
838: END IF;

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

836: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
837: 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);
838: END IF;
839: ELSIF l_current_score<48 AND
840: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
841: l_score :=48;
842: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
843: 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);
844: END IF;

Line 1020: HZ_DQM_SEARCH_UTIL.set_score;

1016: END IF;
1017: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1018: 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);
1019: END IF;
1020: HZ_DQM_SEARCH_UTIL.set_score;
1021: g_mappings.DELETE;
1022: g_party_site_stage_list.DELETE;
1023: g_contact_stage_list.DELETE;
1024: g_contact_pt_stage_list.DELETE;

Line 1027: HZ_DQM_SEARCH_UTIL.new_search;

1023: g_contact_stage_list.DELETE;
1024: g_contact_pt_stage_list.DELETE;
1025: call_order.DELETE;
1026: call_max_score.DELETE;
1027: HZ_DQM_SEARCH_UTIL.new_search;
1028: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1029: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1030:
1031: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1029: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1025: call_order.DELETE;
1026: call_max_score.DELETE;
1027: HZ_DQM_SEARCH_UTIL.new_search;
1028: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1029: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1030:
1031: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1032: 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);
1033: END IF;

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

1211: END IF;
1212:
1213: -- Setup query string for PARTY_ALL_NAMES
1214: l_prim_temp := null;
1215: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1216: g_party_stage_rec.TX40,'A15',l_prim_temp);
1217:
1218: IF l_denorm_str IS NOT NULL THEN
1219: IF (p_non_denorm_max_score+40)>=p_threshold THEN

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

1217:
1218: IF l_denorm_str IS NOT NULL THEN
1219: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1220: l_denorm_str := NULL;
1221: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1222: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1223: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1224: l_denorm_str := NULL;
1225: END IF;

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

1219: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1220: l_denorm_str := NULL;
1221: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1222: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1223: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1224: l_denorm_str := NULL;
1225: END IF;
1226: ELSE
1227: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1223: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1224: l_denorm_str := NULL;
1225: END IF;
1226: ELSE
1227: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1228: END IF;
1229: IF lengthb(l_party_contains_str) > 4000 THEN
1230: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1231: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1276:
1277: -- Setup query string for ADDRESS
1278: l_prim_temp := null;
1279: l_prim_temp_den := null;
1280: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1281: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1282: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1283:
1284: -- Setup query string for CITY

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

1278: l_prim_temp := null;
1279: l_prim_temp_den := null;
1280: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1281: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1282: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1283:
1284: -- Setup query string for CITY
1285: l_prim_temp := null;
1286: l_prim_temp_den := null;

Line 1287: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1283:
1284: -- Setup query string for CITY
1285: l_prim_temp := null;
1286: l_prim_temp_den := null;
1287: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1288: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1289: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1290: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1291: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1289: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1285: l_prim_temp := null;
1286: l_prim_temp_den := null;
1287: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1288: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1289: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1290: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1291: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1292: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1293:

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

1287: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1288: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1289: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1290: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1291: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1292: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1293:
1294: -- Setup query string for POSTAL_CODE
1295: l_prim_temp := null;

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

1288: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1289: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1290: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1291: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1292: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1293:
1294: -- Setup query string for POSTAL_CODE
1295: l_prim_temp := null;
1296: l_prim_temp_den := null;

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

1293:
1294: -- Setup query string for POSTAL_CODE
1295: l_prim_temp := null;
1296: l_prim_temp_den := null;
1297: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1298: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1299: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1300: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1301: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1295: l_prim_temp := null;
1296: l_prim_temp_den := null;
1297: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1298: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1299: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1300: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1301: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1302: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1303:

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

1297: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1298: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1299: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1300: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1301: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1302: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1303:
1304: -- Setup query string for PROVINCE
1305: l_prim_temp := null;

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

1298: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1299: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1300: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1301: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1302: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1303:
1304: -- Setup query string for PROVINCE
1305: l_prim_temp := null;
1306: l_prim_temp_den := null;

Line 1307: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1303:
1304: -- Setup query string for PROVINCE
1305: l_prim_temp := null;
1306: l_prim_temp_den := null;
1307: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1308: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1309: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1310: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1311: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1309: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1305: l_prim_temp := null;
1306: l_prim_temp_den := null;
1307: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1308: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1309: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1310: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1311: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1312: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1313:

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

1307: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1308: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1309: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1310: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1311: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1312: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1313:
1314: -- Setup query string for STATE
1315: l_prim_temp := null;

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

1308: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1309: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1310: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1311: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1312: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1313:
1314: -- Setup query string for STATE
1315: l_prim_temp := null;
1316: l_prim_temp_den := null;

Line 1317: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE

1313:
1314: -- Setup query string for STATE
1315: l_prim_temp := null;
1316: l_prim_temp_den := null;
1317: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1318: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1319: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1320: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1321: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1319: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE

1315: l_prim_temp := null;
1316: l_prim_temp_den := null;
1317: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1318: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1319: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1320: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1321: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1322: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1323:

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

1317: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1318: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1319: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1320: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1321: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1322: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1323:
1324: -- Setup query string for COUNTRY
1325: l_prim_temp := null;

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

1318: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1319: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1320: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1321: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1322: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1323:
1324: -- Setup query string for COUNTRY
1325: l_prim_temp := null;
1326: l_prim_temp_den := null;

Line 1327: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1323:
1324: -- Setup query string for COUNTRY
1325: l_prim_temp := null;
1326: l_prim_temp_den := null;
1327: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1328: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1329: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1330: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1331: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1329: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1325: l_prim_temp := null;
1326: l_prim_temp_den := null;
1327: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1328: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1329: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1330: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1331: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1332: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1333:

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

1327: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1328: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1329: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1330: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1331: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1332: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1333:
1334: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1335: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1328: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1329: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1330: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1331: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1332: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1333:
1334: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1335: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1336: END LOOP;

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

1330: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1331: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1332: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1333:
1334: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1335: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1336: END LOOP;
1337: -- Add the search criteria to query string
1338: IF lengthb(l_contains_str) > 4000 THEN

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

1331: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1332: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1333:
1334: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1335: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1336: END LOOP;
1337: -- Add the search criteria to query string
1338: IF lengthb(l_contains_str) > 4000 THEN
1339: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1374: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1370:
1371: -- Setup query string for JOB_TITLE
1372: l_prim_temp := null;
1373: l_prim_temp_den := null;
1374: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1375: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1376: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1377: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1378: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1376: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1372: l_prim_temp := null;
1373: l_prim_temp_den := null;
1374: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1375: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1376: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1377: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1378: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1379: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1380:

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

1374: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1375: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1376: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1377: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1378: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1379: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1380:
1381: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1382: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1375: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1376: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1377: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1378: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1379: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1380:
1381: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1382: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1383: END LOOP;

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

1377: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1378: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1379: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1380:
1381: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1382: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1383: END LOOP;
1384: -- Add the search criteria to query string
1385: IF lengthb(l_contains_str) > 4000 THEN

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

1378: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1379: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1380:
1381: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1382: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1383: END LOOP;
1384: -- Add the search criteria to query string
1385: IF lengthb(l_contains_str) > 4000 THEN
1386: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1439:
1440: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1441: l_prim_temp := null;
1442: l_prim_temp_den := null;
1443: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1444: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1445: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1446:
1447: -- Setup query string for EMAIL_ADDRESS

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

1441: l_prim_temp := null;
1442: l_prim_temp_den := null;
1443: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1444: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1445: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1446:
1447: -- Setup query string for EMAIL_ADDRESS
1448: l_prim_temp := null;
1449: l_prim_temp_den := null;

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

1446:
1447: -- Setup query string for EMAIL_ADDRESS
1448: l_prim_temp := null;
1449: l_prim_temp_den := null;
1450: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1451: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1452: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1453:
1454: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1448: l_prim_temp := null;
1449: l_prim_temp_den := null;
1450: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1451: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1452: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1453:
1454: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1455: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1456: IF N>1 THEN

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

1450: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1451: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1452: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1453:
1454: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1455: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1456: IF N>1 THEN
1457: distinct_search_cpt_types := N-1;
1458: ELSE

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

1451: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1452: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1453:
1454: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1455: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1456: IF N>1 THEN
1457: distinct_search_cpt_types := N-1;
1458: ELSE
1459: distinct_search_cpt_types := N;

Line 2592: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2588: H_PARTY_ID.DELETE;
2589: H_PARTY_ID_LIST.DELETE;
2590: H_SCORES.DELETE;
2591: g_mappings.DELETE;
2592: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2593: call_order(5) := call_order(1);
2594: call_type(5) := 'AND';
2595: call_max_score(5) := call_max_score(1);
2596: call_type(2) := 'OR';

Line 3421: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3417: ELSE
3418: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3419: END IF;
3420: END LOOP;
3421: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3422: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3423: 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);
3424: END IF;
3425: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3586: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3582: H_PARTY_ID.DELETE;
3583: H_PARTY_ID_LIST.DELETE;
3584: H_SCORES.DELETE;
3585: g_mappings.DELETE;
3586: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3587: call_order(5) := call_order(1);
3588: call_type(5) := 'AND';
3589: call_max_score(5) := call_max_score(1);
3590: call_type(2) := 'OR';

Line 4286: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4282: ELSE
4283: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4284: END IF;
4285: END LOOP;
4286: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4288: 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);
4289: END IF;
4290: EXCEPTION