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

Line 188: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN

184: 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);
185: END IF;
186: RETURN total;
187: END IF;
188: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN
189: total := total+60;
190: IF g_score_until_thresh AND (total)>=g_thres_score THEN
191: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
192: 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 197: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN

193: END IF;
194: RETURN total;
195: END IF;
196: END IF;
197: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN
198: total := total+60;
199: IF g_score_until_thresh AND (total)>=g_thres_score THEN
200: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
201: 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 206: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN

202: END IF;
203: RETURN total;
204: END IF;
205: END IF;
206: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
207: total := total+40;
208: IF g_score_until_thresh AND (total)>=g_thres_score THEN
209: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
210: 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 214: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

210: 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);
211: END IF;
212: RETURN total;
213: END IF;
214: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
215: total := total+32;
216: IF g_score_until_thresh AND (total)>=g_thres_score THEN
217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
218: 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 223: 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

219: END IF;
220: RETURN total;
221: END IF;
222: END IF;
223: 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
224: total := total+60;
225: IF g_score_until_thresh AND (total)>=g_thres_score THEN
226: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
227: 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_stage_rec.TX45, p_table_TX45,50) THEN

228: END IF;
229: RETURN total;
230: END IF;
231: END IF;
232: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN
233: total := total+60;
234: IF g_score_until_thresh AND (total)>=g_thres_score THEN
235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
236: 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 265: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

261: RETURN l_current_score;
262: END IF;
263: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
264: l_current_score := 0;
265: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
266: l_current_score:=l_current_score+ 40;
267: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
268: x_matchidx:=J;
269: RETURN l_current_score;

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

268: x_matchidx:=J;
269: RETURN l_current_score;
270: END IF;
271: ELSIF -- l_current_score<32 AND
272: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
273: l_current_score:=l_current_score+ 32;
274: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
275: x_matchidx:=J;
276: RETURN l_current_score;

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

275: x_matchidx:=J;
276: RETURN l_current_score;
277: END IF;
278: END IF;
279: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
280: l_current_score:=l_current_score+ 30;
281: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
282: x_matchidx:=J;
283: RETURN l_current_score;

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

282: x_matchidx:=J;
283: RETURN l_current_score;
284: END IF;
285: ELSIF -- l_current_score<24 AND
286: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
287: l_current_score:=l_current_score+ 24;
288: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
289: x_matchidx:=J;
290: RETURN l_current_score;

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

289: x_matchidx:=J;
290: RETURN l_current_score;
291: END IF;
292: END IF;
293: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
294: l_current_score:=l_current_score+ 40;
295: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
296: x_matchidx:=J;
297: RETURN l_current_score;

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

296: x_matchidx:=J;
297: RETURN l_current_score;
298: END IF;
299: END IF;
300: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX12, p_table_TX12,(50000*(J-1)+75)) THEN
301: l_current_score:=l_current_score+ 20;
302: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
303: x_matchidx:=J;
304: RETURN l_current_score;

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

303: x_matchidx:=J;
304: RETURN l_current_score;
305: END IF;
306: ELSIF -- l_current_score<16 AND
307: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX13, p_table_TX13,(50000*(J-1)+76)) THEN
308: l_current_score:=l_current_score+ 16;
309: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
310: x_matchidx:=J;
311: RETURN l_current_score;

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

310: x_matchidx:=J;
311: RETURN l_current_score;
312: END IF;
313: END IF;
314: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
315: l_current_score:=l_current_score+ 20;
316: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
317: x_matchidx:=J;
318: RETURN l_current_score;

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

317: x_matchidx:=J;
318: RETURN l_current_score;
319: END IF;
320: ELSIF -- l_current_score<16 AND
321: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN
322: l_current_score:=l_current_score+ 16;
323: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
324: x_matchidx:=J;
325: RETURN l_current_score;

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

324: x_matchidx:=J;
325: RETURN l_current_score;
326: END IF;
327: END IF;
328: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
329: l_current_score:=l_current_score+ 10;
330: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
331: x_matchidx:=J;
332: RETURN l_current_score;

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

372: RETURN l_current_score;
373: END IF;
374: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
375: l_current_score := 0;
376: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
377: l_current_score:=l_current_score+ 60;
378: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
379: x_matchidx:=J;
380: RETURN l_current_score;

Line 383: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX7, p_table_TX7,(50000*(J-1)+116)) THEN

379: x_matchidx:=J;
380: RETURN l_current_score;
381: END IF;
382: END IF;
383: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX7, p_table_TX7,(50000*(J-1)+116)) THEN
384: l_current_score:=l_current_score+ 60;
385: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
386: x_matchidx:=J;
387: RETURN l_current_score;

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

386: x_matchidx:=J;
387: RETURN l_current_score;
388: END IF;
389: ELSIF -- l_current_score<48 AND
390: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX8, p_table_TX8,(50000*(J-1)+117)) THEN
391: l_current_score:=l_current_score+ 48;
392: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
393: x_matchidx:=J;
394: RETURN l_current_score;

Line 597: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN

593: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
594: 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);
595: END IF;
596: l_score :=0;
597: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
598: l_score :=60;
599: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
600: 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);
601: END IF;

Line 622: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN

618: 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);
619: END IF;
620: END IF;
621: l_score :=0;
622: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN
623: l_score :=60;
624: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
625: 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);
626: END IF;

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

643: 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);
644: END IF;
645: END IF;
646: l_score :=0;
647: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
648: l_score :=40;
649: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
650: 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);
651: END IF;

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

649: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
650: 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);
651: END IF;
652: ELSIF l_current_score<32 AND
653: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
654: l_score :=32;
655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
656: 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);
657: END IF;

Line 678: 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

674: 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);
675: END IF;
676: END IF;
677: l_score :=0;
678: 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
679: l_score :=60;
680: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
681: 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);
682: END IF;

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

699: 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);
700: END IF;
701: END IF;
702: l_score :=0;
703: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
704: l_score :=60;
705: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
706: 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);
707: END IF;

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

750: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
751: 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);
752: END IF;
753: l_score :=0;
754: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
755: l_score :=40;
756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
757: 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);
758: END IF;

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

756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
757: 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);
758: END IF;
759: ELSIF l_current_score<32 AND
760: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
761: l_score :=32;
762: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
763: 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);
764: END IF;

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

781: 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);
782: END IF;
783: END IF;
784: l_score :=0;
785: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
786: l_score :=30;
787: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
788: 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);
789: END IF;

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

787: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
788: 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);
789: END IF;
790: ELSIF l_current_score<24 AND
791: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
792: l_score :=24;
793: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
794: 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);
795: END IF;

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

812: 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);
813: END IF;
814: END IF;
815: l_score :=0;
816: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
817: l_score :=40;
818: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
819: 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);
820: END IF;

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

837: 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);
838: END IF;
839: END IF;
840: l_score :=0;
841: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX12, p_table_TX12,(50000*(p_idx-1)+75)) THEN
842: l_score :=20;
843: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
844: 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);
845: END IF;

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

843: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
844: 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);
845: END IF;
846: ELSIF l_current_score<16 AND
847: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX13, p_table_TX13,(50000*(p_idx-1)+76)) THEN
848: l_score :=16;
849: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
850: 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);
851: END IF;

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

868: 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);
869: END IF;
870: END IF;
871: l_score :=0;
872: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
873: l_score :=20;
874: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
875: 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);
876: END IF;

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

874: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
875: 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);
876: END IF;
877: ELSIF l_current_score<16 AND
878: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
879: l_score :=16;
880: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
881: 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);
882: END IF;

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

899: 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);
900: END IF;
901: END IF;
902: l_score :=0;
903: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
904: l_score :=10;
905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
906: 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);
907: END IF;

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

959: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
960: 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);
961: END IF;
962: l_score :=0;
963: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
964: l_score :=60;
965: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
966: 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);
967: END IF;

Line 988: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX7, p_table_TX7,(50000*(p_idx-1)+116)) THEN

984: 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);
985: END IF;
986: END IF;
987: l_score :=0;
988: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX7, p_table_TX7,(50000*(p_idx-1)+116)) THEN
989: l_score :=60;
990: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
991: 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);
992: END IF;

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

990: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
991: 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);
992: END IF;
993: ELSIF l_current_score<48 AND
994: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+117)) THEN
995: l_score :=48;
996: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
997: 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);
998: END IF;

Line 1174: HZ_DQM_SEARCH_UTIL.set_score;

1170: END IF;
1171: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1172: 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);
1173: END IF;
1174: HZ_DQM_SEARCH_UTIL.set_score;
1175: g_mappings.DELETE;
1176: g_party_site_stage_list.DELETE;
1177: g_contact_stage_list.DELETE;
1178: g_contact_pt_stage_list.DELETE;

Line 1181: HZ_DQM_SEARCH_UTIL.new_search;

1177: g_contact_stage_list.DELETE;
1178: g_contact_pt_stage_list.DELETE;
1179: call_order.DELETE;
1180: call_max_score.DELETE;
1181: HZ_DQM_SEARCH_UTIL.new_search;
1182: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1183: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1184:
1185: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1183: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1179: call_order.DELETE;
1180: call_max_score.DELETE;
1181: HZ_DQM_SEARCH_UTIL.new_search;
1182: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1183: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1184:
1185: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1186: 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);
1187: END IF;

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

1365: END IF;
1366:
1367: -- Setup query string for PARTY_ALL_NAMES
1368: l_prim_temp := null;
1369: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1370: g_party_stage_rec.TX40,'A15',l_prim_temp);
1371:
1372: IF l_denorm_str IS NOT NULL THEN
1373: IF (p_non_denorm_max_score+40)>=p_threshold THEN

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

1371:
1372: IF l_denorm_str IS NOT NULL THEN
1373: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1374: l_denorm_str := NULL;
1375: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1376: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1377: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1378: l_denorm_str := NULL;
1379: END IF;

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

1373: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1374: l_denorm_str := NULL;
1375: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1376: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1377: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1378: l_denorm_str := NULL;
1379: END IF;
1380: ELSE
1381: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1377: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1378: l_denorm_str := NULL;
1379: END IF;
1380: ELSE
1381: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1382: END IF;
1383:
1384: -- Setup query string for DUNS_NUMBER_C
1385: l_prim_temp := null;

Line 1389: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1385: l_prim_temp := null;
1386: IF g_party_stage_rec.TX41 IS NOT NULL THEN
1387: IF ltrim(g_party_stage_rec.TX41,'0') IS NOT NULL THEN
1388: FOR I in lengthb(ltrim(g_party_stage_rec.TX41,'0'))..9 LOOP
1389: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1390: lpad(ltrim(g_party_stage_rec.TX41,'0'),I,chr(48)),'A16',l_prim_temp);
1391: END LOOP;
1392: END IF;
1393: END IF;

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

1394:
1395: IF l_denorm_str IS NOT NULL THEN
1396: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1397: l_denorm_str := NULL;
1398: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1399: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1400: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1401: l_denorm_str := NULL;
1402: END IF;

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

1396: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1397: l_denorm_str := NULL;
1398: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1399: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1400: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1401: l_denorm_str := NULL;
1402: END IF;
1403: ELSE
1404: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1400: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1401: l_denorm_str := NULL;
1402: END IF;
1403: ELSE
1404: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1405: END IF;
1406:
1407: -- Setup query string for JGZZ_FISCAL_CODE
1408: l_prim_temp := null;

Line 1409: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1405: END IF;
1406:
1407: -- Setup query string for JGZZ_FISCAL_CODE
1408: l_prim_temp := null;
1409: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1410: g_party_stage_rec.TX45,'A19',l_prim_temp);
1411:
1412: IF l_denorm_str IS NOT NULL THEN
1413: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1411:
1412: IF l_denorm_str IS NOT NULL THEN
1413: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1414: l_denorm_str := NULL;
1415: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1416: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1417: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1418: l_denorm_str := NULL;
1419: END IF;

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

1413: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1414: l_denorm_str := NULL;
1415: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1416: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1417: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1418: l_denorm_str := NULL;
1419: END IF;
1420: ELSE
1421: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1417: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1418: l_denorm_str := NULL;
1419: END IF;
1420: ELSE
1421: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1422: END IF;
1423:
1424: -- Setup query string for PARTY_NUMBER
1425: l_prim_temp := null;

Line 1426: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1422: END IF;
1423:
1424: -- Setup query string for PARTY_NUMBER
1425: l_prim_temp := null;
1426: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1427: g_party_stage_rec.TX34,'A12',l_prim_temp);
1428:
1429: IF l_denorm_str IS NOT NULL THEN
1430: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1428:
1429: IF l_denorm_str IS NOT NULL THEN
1430: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1431: l_denorm_str := NULL;
1432: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1433: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1434: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1435: l_denorm_str := NULL;
1436: END IF;

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

1430: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1431: l_denorm_str := NULL;
1432: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1433: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1434: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1435: l_denorm_str := NULL;
1436: END IF;
1437: ELSE
1438: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1434: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1435: l_denorm_str := NULL;
1436: END IF;
1437: ELSE
1438: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1439: END IF;
1440:
1441: -- Setup query string for ALL_ACCOUNT_NUMBERS
1442: l_prim_temp := null;

Line 1443: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1439: END IF;
1440:
1441: -- Setup query string for ALL_ACCOUNT_NUMBERS
1442: l_prim_temp := null;
1443: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1444: g_party_stage_rec.TX35,'A13',l_prim_temp);
1445:
1446: IF l_denorm_str IS NOT NULL THEN
1447: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1445:
1446: IF l_denorm_str IS NOT NULL THEN
1447: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1448: l_denorm_str := NULL;
1449: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1450: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1451: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1452: l_denorm_str := NULL;
1453: END IF;

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

1447: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1448: l_denorm_str := NULL;
1449: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1450: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1451: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1452: l_denorm_str := NULL;
1453: END IF;
1454: ELSE
1455: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1451: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1452: l_denorm_str := NULL;
1453: END IF;
1454: ELSE
1455: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1456: END IF;
1457: IF lengthb(l_party_contains_str) > 4000 THEN
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1459: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1504:
1505: -- Setup query string for ADDRESS
1506: l_prim_temp := null;
1507: l_prim_temp_den := null;
1508: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1509: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1510: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1511:
1512: -- Setup query string for CITY

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

1506: l_prim_temp := null;
1507: l_prim_temp_den := null;
1508: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1509: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1510: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1511:
1512: -- Setup query string for CITY
1513: l_prim_temp := null;
1514: l_prim_temp_den := null;

Line 1515: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1511:
1512: -- Setup query string for CITY
1513: l_prim_temp := null;
1514: l_prim_temp_den := null;
1515: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1516: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1517: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1518: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1519: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1517: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1513: l_prim_temp := null;
1514: l_prim_temp_den := null;
1515: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1516: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1517: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1518: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1519: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1520: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1521:

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

1515: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1516: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1517: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1518: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1519: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1520: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1521:
1522: -- Setup query string for POSTAL_CODE
1523: l_prim_temp := null;

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

1516: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1517: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1518: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1519: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1520: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1521:
1522: -- Setup query string for POSTAL_CODE
1523: l_prim_temp := null;
1524: l_prim_temp_den := null;

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

1521:
1522: -- Setup query string for POSTAL_CODE
1523: l_prim_temp := null;
1524: l_prim_temp_den := null;
1525: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1526: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1527: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1528: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1529: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1523: l_prim_temp := null;
1524: l_prim_temp_den := null;
1525: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1526: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1527: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1528: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1529: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1530: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1531:

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

1525: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1526: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1527: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1528: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1529: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1530: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1531:
1532: -- Setup query string for PROVINCE
1533: l_prim_temp := null;

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

1526: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1527: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1528: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1529: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1530: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1531:
1532: -- Setup query string for PROVINCE
1533: l_prim_temp := null;
1534: l_prim_temp_den := null;

Line 1535: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1531:
1532: -- Setup query string for PROVINCE
1533: l_prim_temp := null;
1534: l_prim_temp_den := null;
1535: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1536: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1537: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1538: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1539: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1537: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1533: l_prim_temp := null;
1534: l_prim_temp_den := null;
1535: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1536: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1537: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1538: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1539: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1540: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1541:

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

1535: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1536: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1537: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1538: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1539: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1540: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1541:
1542: -- Setup query string for STATE
1543: l_prim_temp := null;

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

1536: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1537: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1538: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1539: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1540: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1541:
1542: -- Setup query string for STATE
1543: l_prim_temp := null;
1544: l_prim_temp_den := null;

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

1541:
1542: -- Setup query string for STATE
1543: l_prim_temp := null;
1544: l_prim_temp_den := null;
1545: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1546: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1547: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1548: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1549: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1543: l_prim_temp := null;
1544: l_prim_temp_den := null;
1545: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1546: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1547: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1548: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1549: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1550: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1551:

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

1545: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1546: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1547: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1548: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1549: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1550: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1551:
1552: -- Setup query string for COUNTRY
1553: l_prim_temp := null;

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

1546: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1547: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1548: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1549: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1550: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1551:
1552: -- Setup query string for COUNTRY
1553: l_prim_temp := null;
1554: l_prim_temp_den := null;

Line 1555: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1551:
1552: -- Setup query string for COUNTRY
1553: l_prim_temp := null;
1554: l_prim_temp_den := null;
1555: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1556: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1557: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1558: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1559: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1557: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1553: l_prim_temp := null;
1554: l_prim_temp_den := null;
1555: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1556: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1557: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1558: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1559: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1560: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1561:

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

1555: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1556: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1557: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1558: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1559: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1560: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1561:
1562: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1563: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1556: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1557: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1558: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1559: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1560: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1561:
1562: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1563: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1564: END LOOP;

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

1558: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1559: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1560: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1561:
1562: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1563: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1564: END LOOP;
1565: -- Add the search criteria to query string
1566: IF lengthb(l_contains_str) > 4000 THEN

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

1559: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1560: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1561:
1562: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1563: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1564: END LOOP;
1565: -- Add the search criteria to query string
1566: IF lengthb(l_contains_str) > 4000 THEN
1567: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1636:
1637: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1638: l_prim_temp := null;
1639: l_prim_temp_den := null;
1640: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1641: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1642: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1643:
1644: -- Setup query string for URL

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

1638: l_prim_temp := null;
1639: l_prim_temp_den := null;
1640: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1641: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1642: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1643:
1644: -- Setup query string for URL
1645: l_prim_temp := null;
1646: l_prim_temp_den := null;

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

1643:
1644: -- Setup query string for URL
1645: l_prim_temp := null;
1646: l_prim_temp_den := null;
1647: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN
1648: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1649: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1650:
1651: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1645: l_prim_temp := null;
1646: l_prim_temp_den := null;
1647: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN
1648: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1649: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1650:
1651: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1652: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1653: IF N>1 THEN

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

1647: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (URL) + WRDOMAIN
1648: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1649: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1650:
1651: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1652: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1653: IF N>1 THEN
1654: distinct_search_cpt_types := N-1;
1655: ELSE

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

1648: g_contact_pt_stage_list(I).TX8,'A49',l_prim_temp);
1649: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1650:
1651: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1652: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1653: IF N>1 THEN
1654: distinct_search_cpt_types := N-1;
1655: ELSE
1656: distinct_search_cpt_types := N;

Line 2821: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2817: H_PARTY_ID.DELETE;
2818: H_PARTY_ID_LIST.DELETE;
2819: H_SCORES.DELETE;
2820: g_mappings.DELETE;
2821: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2822: call_order(5) := call_order(1);
2823: call_type(5) := 'AND';
2824: call_max_score(5) := call_max_score(1);
2825: call_type(2) := 'OR';

Line 3652: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3648: ELSE
3649: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3650: END IF;
3651: END LOOP;
3652: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3653: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3654: 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);
3655: END IF;
3656: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3821: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3817: H_PARTY_ID.DELETE;
3818: H_PARTY_ID_LIST.DELETE;
3819: H_SCORES.DELETE;
3820: g_mappings.DELETE;
3821: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3822: call_order(5) := call_order(1);
3823: call_type(5) := 'AND';
3824: call_max_score(5) := call_max_score(1);
3825: call_type(2) := 'OR';

Line 4523: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4519: ELSE
4520: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4521: END IF;
4522: END LOOP;
4523: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4525: 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);
4526: END IF;
4527: EXCEPTION