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

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

181: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
182: END IF;
183: RETURN total;
184: END IF;
185: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
186: total := total+40;
187: IF g_score_until_thresh AND (total)>=g_thres_score THEN
188: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
189: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 193: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

189: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
190: END IF;
191: RETURN total;
192: END IF;
193: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
194: total := total+32;
195: IF g_score_until_thresh AND (total)>=g_thres_score THEN
196: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
197: 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 202: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,45) THEN

198: END IF;
199: RETURN total;
200: END IF;
201: END IF;
202: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,45) THEN
203: total := total+80;
204: IF g_score_until_thresh AND (total)>=g_thres_score THEN
205: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
206: 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 232: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

228: RETURN l_current_score;
229: END IF;
230: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
231: l_current_score := 0;
232: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
233: l_current_score:=l_current_score+ 40;
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: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN

235: x_matchidx:=J;
236: RETURN l_current_score;
237: END IF;
238: ELSIF -- l_current_score<32 AND
239: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
240: l_current_score:=l_current_score+ 32;
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: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN

242: x_matchidx:=J;
243: RETURN l_current_score;
244: END IF;
245: END IF;
246: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
247: l_current_score:=l_current_score+ 30;
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: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN

249: x_matchidx:=J;
250: RETURN l_current_score;
251: END IF;
252: ELSIF -- l_current_score<24 AND
253: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
254: l_current_score:=l_current_score+ 24;
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).TX11, p_table_TX11,(50000*(J-1)+74)) 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).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
261: l_current_score:=l_current_score+ 30;
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: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN

263: x_matchidx:=J;
264: RETURN l_current_score;
265: END IF;
266: END IF;
267: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
268: l_current_score:=l_current_score+ 20;
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: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN

270: x_matchidx:=J;
271: RETURN l_current_score;
272: END IF;
273: ELSIF -- l_current_score<16 AND
274: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN
275: l_current_score:=l_current_score+ 16;
276: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
277: x_matchidx:=J;
278: RETURN l_current_score;

Line 302: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+92)) THEN

298: RETURN l_current_score;
299: END IF;
300: FOR J IN 1..g_contact_stage_list.COUNT LOOP
301: l_current_score := 0;
302: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+92)) THEN
303: l_current_score:=l_current_score+ 40;
304: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
305: x_matchidx:=J;
306: RETURN l_current_score;

Line 309: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+93)) THEN

305: x_matchidx:=J;
306: RETURN l_current_score;
307: END IF;
308: ELSIF -- l_current_score<32 AND
309: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+93)) THEN
310: l_current_score:=l_current_score+ 32;
311: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
312: x_matchidx:=J;
313: RETURN l_current_score;

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

335: RETURN l_current_score;
336: END IF;
337: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
338: l_current_score := 0;
339: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
340: l_current_score:=l_current_score+ 60;
341: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
342: x_matchidx:=J;
343: RETURN l_current_score;

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

342: x_matchidx:=J;
343: RETURN l_current_score;
344: END IF;
345: END IF;
346: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
347: l_current_score:=l_current_score+ 60;
348: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
349: x_matchidx:=J;
350: RETURN l_current_score;

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

349: x_matchidx:=J;
350: RETURN l_current_score;
351: END IF;
352: ELSIF -- l_current_score<48 AND
353: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
354: l_current_score:=l_current_score+ 48;
355: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
356: x_matchidx:=J;
357: RETURN l_current_score;

Line 360: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX8, p_table_TX8,(50000*(J-1)+117)) THEN

356: x_matchidx:=J;
357: RETURN l_current_score;
358: END IF;
359: END IF;
360: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX8, p_table_TX8,(50000*(J-1)+117)) THEN
361: l_current_score:=l_current_score+ 54;
362: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
363: x_matchidx:=J;
364: RETURN l_current_score;

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

506: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
507: 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);
508: END IF;
509: l_score :=0;
510: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
511: l_score :=40;
512: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
513: 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);
514: END IF;

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

512: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
513: 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);
514: END IF;
515: ELSIF l_current_score<32 AND
516: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
517: l_score :=32;
518: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
519: 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);
520: END IF;

Line 541: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,(50000*(p_idx-1)+45)) THEN

537: 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);
538: END IF;
539: END IF;
540: l_score :=0;
541: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,(50000*(p_idx-1)+45)) THEN
542: l_score :=80;
543: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
544: 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);
545: END IF;

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

585: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
586: 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);
587: END IF;
588: l_score :=0;
589: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
590: l_score :=40;
591: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
592: 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);
593: END IF;

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

591: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
592: 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);
593: END IF;
594: ELSIF l_current_score<32 AND
595: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
596: l_score :=32;
597: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
599: END IF;

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

616: 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);
617: END IF;
618: END IF;
619: l_score :=0;
620: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
621: l_score :=30;
622: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
623: 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);
624: END IF;

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

622: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
623: 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);
624: END IF;
625: ELSIF l_current_score<24 AND
626: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
627: l_score :=24;
628: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
629: 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);
630: END IF;

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

647: 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);
648: END IF;
649: END IF;
650: l_score :=0;
651: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
652: l_score :=30;
653: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
654: 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);
655: END IF;

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

672: 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);
673: END IF;
674: END IF;
675: l_score :=0;
676: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
677: l_score :=20;
678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
679: 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);
680: END IF;

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

678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
679: 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);
680: END IF;
681: ELSIF l_current_score<16 AND
682: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
683: l_score :=16;
684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
685: 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);
686: END IF;

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

721: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
722: 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);
723: END IF;
724: l_score :=0;
725: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+92)) THEN
726: l_score :=40;
727: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
728: 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);
729: END IF;

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

727: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
728: 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);
729: END IF;
730: ELSIF l_current_score<32 AND
731: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+93)) THEN
732: l_score :=32;
733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
734: 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);
735: END IF;

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

772: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
773: 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);
774: END IF;
775: l_score :=0;
776: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
777: l_score :=60;
778: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
779: 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);
780: END IF;

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

797: 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);
798: END IF;
799: END IF;
800: l_score :=0;
801: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
802: l_score :=60;
803: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
804: 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);
805: END IF;

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

803: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
804: 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);
805: END IF;
806: ELSIF l_current_score<48 AND
807: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
808: l_score :=48;
809: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
810: 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);
811: END IF;

Line 832: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+117)) THEN

828: 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);
829: END IF;
830: END IF;
831: l_score :=0;
832: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+117)) THEN
833: l_score :=54;
834: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
835: 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);
836: END IF;

Line 1007: HZ_DQM_SEARCH_UTIL.set_score;

1003: END IF;
1004: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1005: 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);
1006: END IF;
1007: HZ_DQM_SEARCH_UTIL.set_score;
1008: g_mappings.DELETE;
1009: g_party_site_stage_list.DELETE;
1010: g_contact_stage_list.DELETE;
1011: g_contact_pt_stage_list.DELETE;

Line 1014: HZ_DQM_SEARCH_UTIL.new_search;

1010: g_contact_stage_list.DELETE;
1011: g_contact_pt_stage_list.DELETE;
1012: call_order.DELETE;
1013: call_max_score.DELETE;
1014: HZ_DQM_SEARCH_UTIL.new_search;
1015: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1016: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1017:
1018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1016: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1012: call_order.DELETE;
1013: call_max_score.DELETE;
1014: HZ_DQM_SEARCH_UTIL.new_search;
1015: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1016: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1017:
1018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1019: 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);
1020: END IF;

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

1198: END IF;
1199:
1200: -- Setup query string for PARTY_ALL_NAMES
1201: l_prim_temp := null;
1202: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1203: g_party_stage_rec.TX40,'A15',l_prim_temp);
1204:
1205: IF l_denorm_str IS NOT NULL THEN
1206: IF (p_non_denorm_max_score+40)>=p_threshold THEN

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

1204:
1205: IF l_denorm_str IS NOT NULL THEN
1206: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1207: l_denorm_str := NULL;
1208: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1209: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1210: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1211: l_denorm_str := NULL;
1212: END IF;

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

1206: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1207: l_denorm_str := NULL;
1208: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1209: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1210: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1211: l_denorm_str := NULL;
1212: END IF;
1213: ELSE
1214: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1210: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1211: l_denorm_str := NULL;
1212: END IF;
1213: ELSE
1214: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1215: END IF;
1216:
1217: -- Setup query string for DUNS_NUMBER_C
1218: l_prim_temp := null;

Line 1222: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1218: l_prim_temp := null;
1219: IF g_party_stage_rec.TX41 IS NOT NULL THEN
1220: IF ltrim(g_party_stage_rec.TX41,'0') IS NOT NULL THEN
1221: FOR I in lengthb(ltrim(g_party_stage_rec.TX41,'0'))..9 LOOP
1222: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1223: lpad(ltrim(g_party_stage_rec.TX41,'0'),I,chr(48)),'A16',l_prim_temp);
1224: END LOOP;
1225: END IF;
1226: END IF;

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

1227:
1228: IF l_denorm_str IS NOT NULL THEN
1229: IF (p_non_denorm_max_score+80)>=p_threshold THEN
1230: l_denorm_str := NULL;
1231: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1232: ELSIF (p_non_denorm_max_score+p_denorm_max_score+80)>=p_threshold THEN
1233: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1234: l_denorm_str := NULL;
1235: END IF;

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

1229: IF (p_non_denorm_max_score+80)>=p_threshold THEN
1230: l_denorm_str := NULL;
1231: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1232: ELSIF (p_non_denorm_max_score+p_denorm_max_score+80)>=p_threshold THEN
1233: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1234: l_denorm_str := NULL;
1235: END IF;
1236: ELSE
1237: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1233: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1234: l_denorm_str := NULL;
1235: END IF;
1236: ELSE
1237: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1238: END IF;
1239: IF lengthb(l_party_contains_str) > 4000 THEN
1240: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1286:
1287: -- Setup query string for ADDRESS
1288: l_prim_temp := null;
1289: l_prim_temp_den := null;
1290: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1291: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1292: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1293:
1294: -- Setup query string for CITY

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

1288: l_prim_temp := null;
1289: l_prim_temp_den := null;
1290: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1291: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1292: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1293:
1294: -- Setup query string for CITY
1295: l_prim_temp := null;
1296: l_prim_temp_den := null;

Line 1297: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1293:
1294: -- Setup query string for CITY
1295: l_prim_temp := null;
1296: l_prim_temp_den := null;
1297: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1298: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1299: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1300: g_party_site_stage_list(I).TX10,'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( -- CLEANSE

1295: l_prim_temp := null;
1296: l_prim_temp_den := null;
1297: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1298: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1299: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1300: g_party_site_stage_list(I).TX10,'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( -- CLEANSE
1298: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1299: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1300: g_party_site_stage_list(I).TX10,'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 POSTAL_CODE
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).TX10,'A29',l_prim_temp);
1299: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1300: g_party_site_stage_list(I).TX10,'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 POSTAL_CODE
1305: l_prim_temp := null;
1306: l_prim_temp_den := null;

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

1303:
1304: -- Setup query string for POSTAL_CODE
1305: l_prim_temp := null;
1306: l_prim_temp_den := null;
1307: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1308: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1309: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1310: g_party_site_stage_list(I).TX11,'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( -- EXACT SPECIAL NOSPC

1305: l_prim_temp := null;
1306: l_prim_temp_den := null;
1307: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1308: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1309: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1310: g_party_site_stage_list(I).TX11,'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( -- EXACT SPECIAL NOSPC
1308: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1309: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1310: g_party_site_stage_list(I).TX11,'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).TX11,'A30',l_prim_temp);
1309: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1310: g_party_site_stage_list(I).TX11,'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: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1325: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1325: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1326: END LOOP;

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

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: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1325: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1326: END LOOP;
1327: -- Add the search criteria to query string
1328: IF lengthb(l_contains_str) > 4000 THEN

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

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: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1325: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1326: END LOOP;
1327: -- Add the search criteria to query string
1328: IF lengthb(l_contains_str) > 4000 THEN
1329: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1364: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON

1360:
1361: -- Setup query string for CONTACT_NAME
1362: l_prim_temp := null;
1363: l_prim_temp_den := null;
1364: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1365: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1366: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1367:
1368: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1362: l_prim_temp := null;
1363: l_prim_temp_den := null;
1364: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1365: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1366: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1367:
1368: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1369: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1370: END LOOP;

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

1364: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1365: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1366: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1367:
1368: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1369: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1370: END LOOP;
1371: -- Add the search criteria to query string
1372: IF lengthb(l_contains_str) > 4000 THEN

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

1365: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1366: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1367:
1368: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1369: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1370: END LOOP;
1371: -- Add the search criteria to query string
1372: IF lengthb(l_contains_str) > 4000 THEN
1373: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1426:
1427: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1428: l_prim_temp := null;
1429: l_prim_temp_den := null;
1430: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1431: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1432: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1433:
1434: -- Setup query string for EMAIL_ADDRESS

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

1428: l_prim_temp := null;
1429: l_prim_temp_den := null;
1430: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1431: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1432: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1433:
1434: -- Setup query string for EMAIL_ADDRESS
1435: l_prim_temp := null;
1436: l_prim_temp_den := null;

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

1433:
1434: -- Setup query string for EMAIL_ADDRESS
1435: l_prim_temp := null;
1436: l_prim_temp_den := null;
1437: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1438: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1439: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1440:
1441: -- Setup query string for URL

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

1435: l_prim_temp := null;
1436: l_prim_temp_den := null;
1437: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1438: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1439: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1440:
1441: -- Setup query string for URL
1442: l_prim_temp := null;
1443: l_prim_temp_den := null;

Line 1444: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN

1440:
1441: -- Setup query string for URL
1442: l_prim_temp := null;
1443: l_prim_temp_den := null;
1444: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN
1445: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1446: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1447:
1448: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1442: l_prim_temp := null;
1443: l_prim_temp_den := null;
1444: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN
1445: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1446: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1447:
1448: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1449: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1450: IF N>1 THEN

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

1444: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN
1445: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1446: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1447:
1448: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1449: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1450: IF N>1 THEN
1451: distinct_search_cpt_types := N-1;
1452: ELSE

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

1445: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1446: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1447:
1448: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1449: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1450: IF N>1 THEN
1451: distinct_search_cpt_types := N-1;
1452: ELSE
1453: distinct_search_cpt_types := N;

Line 2578: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2574: H_PARTY_ID.DELETE;
2575: H_PARTY_ID_LIST.DELETE;
2576: H_SCORES.DELETE;
2577: g_mappings.DELETE;
2578: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2579: call_order(5) := call_order(1);
2580: call_type(5) := 'AND';
2581: call_max_score(5) := call_max_score(1);
2582: call_type(2) := 'OR';

Line 3407: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3403: ELSE
3404: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3405: END IF;
3406: END LOOP;
3407: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3408: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3409: 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);
3410: END IF;
3411: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3571: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3567: H_PARTY_ID.DELETE;
3568: H_PARTY_ID_LIST.DELETE;
3569: H_SCORES.DELETE;
3570: g_mappings.DELETE;
3571: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3572: call_order(5) := call_order(1);
3573: call_type(5) := 'AND';
3574: call_max_score(5) := call_max_score(1);
3575: call_type(2) := 'OR';

Line 4271: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4267: ELSE
4268: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4269: END IF;
4270: END LOOP;
4271: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4272: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4273: 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);
4274: END IF;
4275: EXCEPTION