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

Line 188: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX32, p_table_TX32,36) 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.TX32, p_table_TX32,36) 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 196: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX33, p_table_TX33,37) 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);
193: END IF;
194: RETURN total;
195: END IF;
196: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX33, p_table_TX33,37) THEN
197: total := total+48;
198: IF g_score_until_thresh AND (total)>=g_thres_score THEN
199: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
200: 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 205: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN

201: END IF;
202: RETURN total;
203: END IF;
204: END IF;
205: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN
206: total := total+100;
207: IF g_score_until_thresh AND (total)>=g_thres_score THEN
208: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
209: 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: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN

210: END IF;
211: RETURN total;
212: END IF;
213: END IF;
214: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN
215: total := total+100;
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(g_party_stage_rec.TX39, p_table_TX39,43) THEN

219: END IF;
220: RETURN total;
221: END IF;
222: END IF;
223: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) 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 231: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) 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);
228: END IF;
229: RETURN total;
230: END IF;
231: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
232: total := total+48;
233: IF g_score_until_thresh AND (total)>=g_thres_score THEN
234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
235: 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 263: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

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

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

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

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

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

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

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

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

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

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

294: x_matchidx:=J;
295: RETURN l_current_score;
296: END IF;
297: END IF;
298: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
299: l_current_score:=l_current_score+ 20;
300: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
301: x_matchidx:=J;
302: RETURN l_current_score;

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

301: x_matchidx:=J;
302: RETURN l_current_score;
303: END IF;
304: ELSIF -- l_current_score<16 AND
305: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN
306: l_current_score:=l_current_score+ 16;
307: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
308: x_matchidx:=J;
309: RETURN l_current_score;

Line 312: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX17, p_table_TX17,(50000*(J-1)+80)) THEN

308: x_matchidx:=J;
309: RETURN l_current_score;
310: END IF;
311: END IF;
312: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX17, p_table_TX17,(50000*(J-1)+80)) THEN
313: l_current_score:=l_current_score+ 50;
314: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
315: x_matchidx:=J;
316: RETURN l_current_score;

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

315: x_matchidx:=J;
316: RETURN l_current_score;
317: END IF;
318: END IF;
319: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
320: l_current_score:=l_current_score+ 10;
321: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
322: x_matchidx:=J;
323: RETURN l_current_score;

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

343: RETURN l_current_score;
344: END IF;
345: FOR J IN 1..g_contact_stage_list.COUNT LOOP
346: l_current_score := 0;
347: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+92)) THEN
348: l_current_score:=l_current_score+ 50;
349: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
350: x_matchidx:=J;
351: RETURN l_current_score;

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

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

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

379: RETURN l_current_score;
380: END IF;
381: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
382: l_current_score := 0;
383: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
384: l_current_score:=l_current_score+ 80;
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: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN

386: x_matchidx:=J;
387: RETURN l_current_score;
388: END IF;
389: END IF;
390: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
391: l_current_score:=l_current_score+ 80;
392: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
393: x_matchidx:=J;
394: RETURN l_current_score;

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

393: x_matchidx:=J;
394: RETURN l_current_score;
395: END IF;
396: ELSIF -- l_current_score<56 AND
397: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
398: l_current_score:=l_current_score+ 56;
399: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
400: x_matchidx:=J;
401: RETURN l_current_score;

Line 574: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX32, p_table_TX32,(50000*(p_idx-1)+36)) THEN

570: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
571: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_PARTY_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
572: END IF;
573: l_score :=0;
574: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX32, p_table_TX32,(50000*(p_idx-1)+36)) THEN
575: l_score :=60;
576: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
577: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
578: END IF;

Line 580: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX33, p_table_TX33,(50000*(p_idx-1)+37)) THEN

576: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
577: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
578: END IF;
579: ELSIF l_current_score<48 AND
580: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX33, p_table_TX33,(50000*(p_idx-1)+37)) THEN
581: l_score :=48;
582: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
583: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
584: END IF;

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

601: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ... Done',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
602: END IF;
603: END IF;
604: l_score :=0;
605: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
606: l_score :=100;
607: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
608: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
609: END IF;

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

626: 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);
627: END IF;
628: END IF;
629: l_score :=0;
630: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN
631: l_score :=100;
632: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
633: 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);
634: END IF;

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

651: 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);
652: END IF;
653: END IF;
654: l_score :=0;
655: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
656: l_score :=60;
657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
658: 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);
659: END IF;

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

657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
658: 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);
659: END IF;
660: ELSIF l_current_score<48 AND
661: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
662: l_score :=48;
663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
664: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
665: END IF;

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

707: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
708: 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);
709: END IF;
710: l_score :=0;
711: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
712: l_score :=40;
713: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
714: 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);
715: END IF;

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

713: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
714: 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);
715: END IF;
716: ELSIF l_current_score<28 AND
717: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
718: l_score :=28;
719: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
720: 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);
721: END IF;

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

738: 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);
739: END IF;
740: END IF;
741: l_score :=0;
742: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
743: l_score :=30;
744: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
745: 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);
746: END IF;

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

744: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
745: 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);
746: END IF;
747: ELSIF l_current_score<21 AND
748: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
749: l_score :=21;
750: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
751: 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);
752: END IF;

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

769: 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);
770: END IF;
771: END IF;
772: l_score :=0;
773: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
774: l_score :=20;
775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
776: 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);
777: END IF;

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

794: 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);
795: END IF;
796: END IF;
797: l_score :=0;
798: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
799: l_score :=20;
800: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
801: 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);
802: END IF;

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

800: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
801: 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);
802: END IF;
803: ELSIF l_current_score<16 AND
804: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
805: l_score :=16;
806: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
807: 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);
808: END IF;

Line 829: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX17, p_table_TX17,(50000*(p_idx-1)+80)) THEN

825: 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);
826: END IF;
827: END IF;
828: l_score :=0;
829: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX17, p_table_TX17,(50000*(p_idx-1)+80)) THEN
830: l_score :=50;
831: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
832: 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);
833: END IF;

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

850: 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);
851: END IF;
852: END IF;
853: l_score :=0;
854: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
855: l_score :=10;
856: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
857: 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);
858: END IF;

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

893: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
894: 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);
895: END IF;
896: l_score :=0;
897: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+92)) THEN
898: l_score :=50;
899: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
900: 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);
901: END IF;

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

899: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
900: 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);
901: END IF;
902: ELSIF l_current_score<40 AND
903: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+93)) THEN
904: l_score :=40;
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 947: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN

943: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
944: 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);
945: END IF;
946: l_score :=0;
947: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
948: l_score :=80;
949: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
950: 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);
951: END IF;

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

968: 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);
969: END IF;
970: END IF;
971: l_score :=0;
972: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
973: l_score :=80;
974: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
975: 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);
976: END IF;

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

974: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
975: 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);
976: END IF;
977: ELSIF l_current_score<56 AND
978: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
979: l_score :=56;
980: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
981: 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);
982: END IF;

Line 1158: HZ_DQM_SEARCH_UTIL.set_score;

1154: END IF;
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: 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);
1157: END IF;
1158: HZ_DQM_SEARCH_UTIL.set_score;
1159: g_mappings.DELETE;
1160: g_party_site_stage_list.DELETE;
1161: g_contact_stage_list.DELETE;
1162: g_contact_pt_stage_list.DELETE;

Line 1165: HZ_DQM_SEARCH_UTIL.new_search;

1161: g_contact_stage_list.DELETE;
1162: g_contact_pt_stage_list.DELETE;
1163: call_order.DELETE;
1164: call_max_score.DELETE;
1165: HZ_DQM_SEARCH_UTIL.new_search;
1166: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1167: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1168:
1169: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1167: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1163: call_order.DELETE;
1164: call_max_score.DELETE;
1165: HZ_DQM_SEARCH_UTIL.new_search;
1166: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1167: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1168:
1169: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1170: 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);
1171: END IF;

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

1349: END IF;
1350:
1351: -- Setup query string for PARTY_ALL_NAMES
1352: l_prim_temp := null;
1353: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1354: g_party_stage_rec.TX40,'A15',l_prim_temp);
1355:
1356: IF l_denorm_str IS NOT NULL THEN
1357: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1355:
1356: IF l_denorm_str IS NOT NULL THEN
1357: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1358: l_denorm_str := NULL;
1359: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1360: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1361: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1362: l_denorm_str := NULL;
1363: END IF;

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

1357: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1358: l_denorm_str := NULL;
1359: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1360: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1361: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1362: l_denorm_str := NULL;
1363: END IF;
1364: ELSE
1365: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1361: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1362: l_denorm_str := NULL;
1363: END IF;
1364: ELSE
1365: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1366: END IF;
1367:
1368: -- Setup query string for ALL_ACCOUNT_NAMES
1369: l_prim_temp := null;

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

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

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

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

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

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

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

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

Line 1387: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1383: END IF;
1384:
1385: -- Setup query string for PARTY_NUMBER
1386: l_prim_temp := null;
1387: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1388: g_party_stage_rec.TX34,'A12',l_prim_temp);
1389:
1390: IF l_denorm_str IS NOT NULL THEN
1391: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1389:
1390: IF l_denorm_str IS NOT NULL THEN
1391: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1392: l_denorm_str := NULL;
1393: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1394: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1395: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1396: l_denorm_str := NULL;
1397: END IF;

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

1391: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1392: l_denorm_str := NULL;
1393: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1394: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1395: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1396: l_denorm_str := NULL;
1397: END IF;
1398: ELSE
1399: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1395: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1396: l_denorm_str := NULL;
1397: END IF;
1398: ELSE
1399: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1400: END IF;
1401:
1402: -- Setup query string for ALL_ACCOUNT_NUMBERS
1403: l_prim_temp := null;

Line 1404: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1400: END IF;
1401:
1402: -- Setup query string for ALL_ACCOUNT_NUMBERS
1403: l_prim_temp := null;
1404: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1405: g_party_stage_rec.TX35,'A13',l_prim_temp);
1406:
1407: IF l_denorm_str IS NOT NULL THEN
1408: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1406:
1407: IF l_denorm_str IS NOT NULL THEN
1408: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1409: l_denorm_str := NULL;
1410: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1411: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1412: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1413: l_denorm_str := NULL;
1414: END IF;

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

1408: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1409: l_denorm_str := NULL;
1410: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1411: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1412: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1413: l_denorm_str := NULL;
1414: END IF;
1415: ELSE
1416: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1412: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1413: l_denorm_str := NULL;
1414: END IF;
1415: ELSE
1416: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1417: END IF;
1418: IF lengthb(l_party_contains_str) > 4000 THEN
1419: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1420: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1465:
1466: -- Setup query string for ADDRESS
1467: l_prim_temp := null;
1468: l_prim_temp_den := null;
1469: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1470: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1471: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1472:
1473: -- Setup query string for CITY

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

1467: l_prim_temp := null;
1468: l_prim_temp_den := null;
1469: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1470: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1471: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1472:
1473: -- Setup query string for CITY
1474: l_prim_temp := null;
1475: l_prim_temp_den := null;

Line 1476: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1472:
1473: -- Setup query string for CITY
1474: l_prim_temp := null;
1475: l_prim_temp_den := null;
1476: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1477: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1478: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1479: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1480: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1478: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1474: l_prim_temp := null;
1475: l_prim_temp_den := null;
1476: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1477: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1478: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1479: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1480: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1481: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1482:

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

1476: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1477: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1478: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1479: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1480: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1481: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1482:
1483: -- Setup query string for POSTAL_CODE
1484: l_prim_temp := null;

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

1477: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1478: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1479: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1480: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1481: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1482:
1483: -- Setup query string for POSTAL_CODE
1484: l_prim_temp := null;
1485: l_prim_temp_den := null;

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

1482:
1483: -- Setup query string for POSTAL_CODE
1484: l_prim_temp := null;
1485: l_prim_temp_den := null;
1486: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1487: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1488: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1489: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1490: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1484: l_prim_temp := null;
1485: l_prim_temp_den := null;
1486: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1487: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1488: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1489: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1490: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1491: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1492:

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

1486: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1487: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1488: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1489: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1490: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1491: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1492:
1493: -- Setup query string for STATE
1494: l_prim_temp := null;

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

1487: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1488: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1489: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1490: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1491: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1492:
1493: -- Setup query string for STATE
1494: l_prim_temp := null;
1495: l_prim_temp_den := null;

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

1492:
1493: -- Setup query string for STATE
1494: l_prim_temp := null;
1495: l_prim_temp_den := null;
1496: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1497: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1498: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1499: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1500: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1494: l_prim_temp := null;
1495: l_prim_temp_den := null;
1496: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1497: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1498: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1499: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1500: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1501: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1502:

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

1496: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1497: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1498: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1499: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1500: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1501: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1502:
1503: -- Setup query string for PARTY_SITE_NUMBER
1504: l_prim_temp := null;

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

1497: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1498: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1499: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1500: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1501: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1502:
1503: -- Setup query string for PARTY_SITE_NUMBER
1504: l_prim_temp := null;
1505: l_prim_temp_den := null;

Line 1506: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1502:
1503: -- Setup query string for PARTY_SITE_NUMBER
1504: l_prim_temp := null;
1505: l_prim_temp_den := null;
1506: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1507: g_party_site_stage_list(I).TX17,'A33',l_prim_temp);
1508: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1509:
1510: -- Setup query string for COUNTRY

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

1504: l_prim_temp := null;
1505: l_prim_temp_den := null;
1506: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1507: g_party_site_stage_list(I).TX17,'A33',l_prim_temp);
1508: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1509:
1510: -- Setup query string for COUNTRY
1511: l_prim_temp := null;
1512: l_prim_temp_den := null;

Line 1513: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1509:
1510: -- Setup query string for COUNTRY
1511: l_prim_temp := null;
1512: l_prim_temp_den := null;
1513: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1514: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1515: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1516: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1517: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1515: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1511: l_prim_temp := null;
1512: l_prim_temp_den := null;
1513: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1514: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1515: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1516: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1517: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1518: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1519:

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

1513: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1514: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1515: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1516: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1517: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1518: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1519:
1520: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1521: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1514: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1515: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1516: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1517: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1518: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1519:
1520: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1521: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1522: END LOOP;

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

1516: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1517: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1518: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1519:
1520: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1521: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1522: END LOOP;
1523: -- Add the search criteria to query string
1524: IF lengthb(l_contains_str) > 4000 THEN

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

1517: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1518: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1519:
1520: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1521: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1522: END LOOP;
1523: -- Add the search criteria to query string
1524: IF lengthb(l_contains_str) > 4000 THEN
1525: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1556:
1557: -- Setup query string for CONTACT_NAME
1558: l_prim_temp := null;
1559: l_prim_temp_den := null;
1560: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1561: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1562: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1563: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1564: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);

Line 1562: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX

1558: l_prim_temp := null;
1559: l_prim_temp_den := null;
1560: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1561: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1562: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1563: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1564: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1565:
1566: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1560: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1561: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1562: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1563: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1564: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1565:
1566: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1567: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1568: END LOOP;

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

1562: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1563: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1564: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1565:
1566: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1567: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1568: END LOOP;
1569: -- Add the search criteria to query string
1570: IF lengthb(l_contains_str) > 4000 THEN

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

1563: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1564: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1565:
1566: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1567: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1568: END LOOP;
1569: -- Add the search criteria to query string
1570: IF lengthb(l_contains_str) > 4000 THEN
1571: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1624:
1625: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1626: l_prim_temp := null;
1627: l_prim_temp_den := null;
1628: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1629: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1630: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1631:
1632: -- Setup query string for EMAIL_ADDRESS

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

1626: l_prim_temp := null;
1627: l_prim_temp_den := null;
1628: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1629: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1630: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1631:
1632: -- Setup query string for EMAIL_ADDRESS
1633: l_prim_temp := null;
1634: l_prim_temp_den := null;

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

1631:
1632: -- Setup query string for EMAIL_ADDRESS
1633: l_prim_temp := null;
1634: l_prim_temp_den := null;
1635: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1636: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1637: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1638:
1639: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1633: l_prim_temp := null;
1634: l_prim_temp_den := null;
1635: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1636: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1637: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1638:
1639: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1640: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1641: IF N>1 THEN

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

1635: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1636: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1637: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1638:
1639: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1640: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1641: IF N>1 THEN
1642: distinct_search_cpt_types := N-1;
1643: ELSE

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

1636: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1637: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1638:
1639: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1640: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1641: IF N>1 THEN
1642: distinct_search_cpt_types := N-1;
1643: ELSE
1644: distinct_search_cpt_types := N;

Line 2794: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2790: H_PARTY_ID.DELETE;
2791: H_PARTY_ID_LIST.DELETE;
2792: H_SCORES.DELETE;
2793: g_mappings.DELETE;
2794: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2795: call_order(5) := call_order(1);
2796: call_type(5) := 'AND';
2797: call_max_score(5) := call_max_score(1);
2798: call_type(2) := 'OR';

Line 3625: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3621: ELSE
3622: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3623: END IF;
3624: END LOOP;
3625: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3627: 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);
3628: END IF;
3629: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3793: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3789: H_PARTY_ID.DELETE;
3790: H_PARTY_ID_LIST.DELETE;
3791: H_SCORES.DELETE;
3792: g_mappings.DELETE;
3793: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3794: call_order(5) := call_order(1);
3795: call_type(5) := 'AND';
3796: call_max_score(5) := call_max_score(1);
3797: call_type(2) := 'OR';

Line 4495: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4491: ELSE
4492: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4493: END IF;
4494: END LOOP;
4495: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4497: 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);
4498: END IF;
4499: EXCEPTION