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

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

186: 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);
187: END IF;
188: RETURN total;
189: END IF;
190: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN
191: total := total+100;
192: IF g_score_until_thresh AND (total)>=g_thres_score THEN
193: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
194: 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 199: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN

195: END IF;
196: RETURN total;
197: END IF;
198: END IF;
199: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
200: total := total+60;
201: IF g_score_until_thresh AND (total)>=g_thres_score THEN
202: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
203: 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 207: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

203: 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);
204: END IF;
205: RETURN total;
206: END IF;
207: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
208: total := total+48;
209: IF g_score_until_thresh AND (total)>=g_thres_score THEN
210: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
211: 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 215: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX158, p_table_TX158,123) THEN

211: 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);
212: END IF;
213: RETURN total;
214: END IF;
215: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX158, p_table_TX158,123) THEN
216: total := total+36;
217: IF g_score_until_thresh AND (total)>=g_thres_score THEN
218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
219: 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 224: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

220: END IF;
221: RETURN total;
222: END IF;
223: END IF;
224: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
225: total := total+100;
226: IF g_score_until_thresh AND (total)>=g_thres_score THEN
227: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
228: 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 233: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN

229: END IF;
230: RETURN total;
231: END IF;
232: END IF;
233: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN
234: total := total+60;
235: IF g_score_until_thresh AND (total)>=g_thres_score THEN
236: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
237: 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 242: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN

238: END IF;
239: RETURN total;
240: END IF;
241: END IF;
242: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN
243: total := total+25;
244: IF g_score_until_thresh AND (total)>=g_thres_score THEN
245: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
246: 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 251: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX47, p_table_TX47,52) THEN

247: END IF;
248: RETURN total;
249: END IF;
250: END IF;
251: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX47, p_table_TX47,52) THEN
252: total := total+25;
253: IF g_score_until_thresh AND (total)>=g_thres_score THEN
254: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
255: 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 282: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN

278: RETURN l_current_score;
279: END IF;
280: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
281: l_current_score := 0;
282: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
283: l_current_score:=l_current_score+ 40;
284: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
285: x_matchidx:=J;
286: RETURN l_current_score;

Line 289: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

285: x_matchidx:=J;
286: RETURN l_current_score;
287: END IF;
288: ELSIF -- l_current_score<40 AND
289: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
290: l_current_score:=l_current_score+ 40;
291: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
292: x_matchidx:=J;
293: RETURN l_current_score;

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

292: x_matchidx:=J;
293: RETURN l_current_score;
294: END IF;
295: END IF;
296: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
297: l_current_score:=l_current_score+ 10;
298: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
299: x_matchidx:=J;
300: RETURN l_current_score;

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

299: x_matchidx:=J;
300: RETURN l_current_score;
301: END IF;
302: ELSIF -- l_current_score<8 AND
303: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
304: l_current_score:=l_current_score+ 8;
305: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
306: x_matchidx:=J;
307: RETURN l_current_score;

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

306: x_matchidx:=J;
307: RETURN l_current_score;
308: END IF;
309: END IF;
310: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
311: l_current_score:=l_current_score+ 15;
312: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
313: x_matchidx:=J;
314: RETURN l_current_score;

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

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

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

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

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

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

Line 361: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+89)) THEN

357: RETURN l_current_score;
358: END IF;
359: FOR J IN 1..g_contact_stage_list.COUNT LOOP
360: l_current_score := 0;
361: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+89)) THEN
362: l_current_score:=l_current_score+ 60;
363: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
364: x_matchidx:=J;
365: RETURN l_current_score;

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

364: x_matchidx:=J;
365: RETURN l_current_score;
366: END IF;
367: ELSIF -- l_current_score<48 AND
368: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+92)) THEN
369: l_current_score:=l_current_score+ 48;
370: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
371: x_matchidx:=J;
372: RETURN l_current_score;

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

371: x_matchidx:=J;
372: RETURN l_current_score;
373: END IF;
374: ELSIF -- l_current_score<42 AND
375: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+93)) THEN
376: l_current_score:=l_current_score+ 42;
377: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
378: x_matchidx:=J;
379: RETURN l_current_score;

Line 382: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX156, p_table_TX156,(50000*(J-1)+124)) THEN

378: x_matchidx:=J;
379: RETURN l_current_score;
380: END IF;
381: ELSIF -- l_current_score<36 AND
382: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX156, p_table_TX156,(50000*(J-1)+124)) THEN
383: l_current_score:=l_current_score+ 36;
384: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
385: x_matchidx:=J;
386: RETURN l_current_score;

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

407: RETURN l_current_score;
408: END IF;
409: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
410: l_current_score := 0;
411: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
412: l_current_score:=l_current_score+ 72;
413: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
414: x_matchidx:=J;
415: RETURN l_current_score;

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

414: x_matchidx:=J;
415: RETURN l_current_score;
416: END IF;
417: END IF;
418: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
419: l_current_score:=l_current_score+ 80;
420: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
421: x_matchidx:=J;
422: RETURN l_current_score;

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

421: x_matchidx:=J;
422: RETURN l_current_score;
423: END IF;
424: ELSIF -- l_current_score<64 AND
425: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
426: l_current_score:=l_current_score+ 64;
427: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
428: x_matchidx:=J;
429: RETURN l_current_score;

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

655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
656: 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);
657: END IF;
658: l_score :=0;
659: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
660: l_score :=100;
661: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
662: 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);
663: END IF;

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

680: 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);
681: END IF;
682: END IF;
683: l_score :=0;
684: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
685: l_score :=60;
686: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
687: 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);
688: END IF;

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

686: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
687: 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);
688: END IF;
689: ELSIF l_current_score<48 AND
690: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
691: l_score :=48;
692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
693: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
694: END IF;

Line 696: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX158, p_table_TX158,(50000*(p_idx-1)+123)) THEN

692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
693: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
694: END IF;
695: ELSIF l_current_score<36 AND
696: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX158, p_table_TX158,(50000*(p_idx-1)+123)) THEN
697: l_score :=36;
698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
699: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
700: END IF;

Line 721: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN

717: 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);
718: END IF;
719: END IF;
720: l_score :=0;
721: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
722: l_score :=100;
723: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
724: 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);
725: END IF;

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

742: 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);
743: END IF;
744: END IF;
745: l_score :=0;
746: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
747: l_score :=60;
748: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
749: 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);
750: END IF;

Line 771: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN

767: 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);
768: END IF;
769: END IF;
770: l_score :=0;
771: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN
772: l_score :=25;
773: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
774: 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);
775: END IF;

Line 796: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX47, p_table_TX47,(50000*(p_idx-1)+52)) THEN

792: 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);
793: END IF;
794: END IF;
795: l_score :=0;
796: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX47, p_table_TX47,(50000*(p_idx-1)+52)) THEN
797: l_score :=25;
798: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
799: 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);
800: END IF;

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

841: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
842: 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);
843: END IF;
844: l_score :=0;
845: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
846: l_score :=40;
847: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
848: 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);
849: END IF;

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

847: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
848: 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);
849: END IF;
850: ELSIF l_current_score<40 AND
851: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
852: l_score :=40;
853: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
854: 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);
855: END IF;

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

872: 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);
873: END IF;
874: END IF;
875: l_score :=0;
876: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
877: l_score :=10;
878: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
879: 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);
880: END IF;

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

878: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
879: 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);
880: END IF;
881: ELSIF l_current_score<8 AND
882: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
883: l_score :=8;
884: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
885: 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);
886: END IF;

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

903: 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);
904: END IF;
905: END IF;
906: l_score :=0;
907: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
908: l_score :=15;
909: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
910: 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);
911: END IF;

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

928: 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);
929: END IF;
930: END IF;
931: l_score :=0;
932: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
933: l_score :=20;
934: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
935: 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);
936: END IF;

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

934: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
935: 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);
936: END IF;
937: ELSIF l_current_score<16 AND
938: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
939: l_score :=16;
940: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
941: 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);
942: END IF;

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

959: 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);
960: END IF;
961: END IF;
962: l_score :=0;
963: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
964: l_score :=10;
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 1008: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN

1004: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1005: 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);
1006: END IF;
1007: l_score :=0;
1008: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN
1009: l_score :=60;
1010: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1011: 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);
1012: END IF;

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

1010: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1011: 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);
1012: END IF;
1013: ELSIF l_current_score<48 AND
1014: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+92)) THEN
1015: l_score :=48;
1016: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1017: 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);
1018: END IF;

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

1016: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1017: 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);
1018: END IF;
1019: ELSIF l_current_score<42 AND
1020: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+93)) THEN
1021: l_score :=42;
1022: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1023: 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);
1024: END IF;

Line 1026: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX156, p_table_TX156,(50000*(p_idx-1)+124)) THEN

1022: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1023: 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);
1024: END IF;
1025: ELSIF l_current_score<36 AND
1026: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX156, p_table_TX156,(50000*(p_idx-1)+124)) THEN
1027: l_score :=36;
1028: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1029: 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);
1030: END IF;

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

1066: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1067: 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);
1068: END IF;
1069: l_score :=0;
1070: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
1071: l_score :=72;
1072: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1073: 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);
1074: END IF;

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

1091: 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);
1092: END IF;
1093: END IF;
1094: l_score :=0;
1095: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
1096: l_score :=80;
1097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1098: 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);
1099: END IF;

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

1097: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1098: 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);
1099: END IF;
1100: ELSIF l_current_score<64 AND
1101: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
1102: l_score :=64;
1103: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1104: 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);
1105: END IF;

Line 1281: HZ_DQM_SEARCH_UTIL.set_score;

1277: END IF;
1278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1279: 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);
1280: END IF;
1281: HZ_DQM_SEARCH_UTIL.set_score;
1282: g_mappings.DELETE;
1283: g_party_site_stage_list.DELETE;
1284: g_contact_stage_list.DELETE;
1285: g_contact_pt_stage_list.DELETE;

Line 1288: HZ_DQM_SEARCH_UTIL.new_search;

1284: g_contact_stage_list.DELETE;
1285: g_contact_pt_stage_list.DELETE;
1286: call_order.DELETE;
1287: call_max_score.DELETE;
1288: HZ_DQM_SEARCH_UTIL.new_search;
1289: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1290: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1291:
1292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1290: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1286: call_order.DELETE;
1287: call_max_score.DELETE;
1288: HZ_DQM_SEARCH_UTIL.new_search;
1289: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1290: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1291:
1292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1293: 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);
1294: END IF;

Line 1476: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1472: END IF;
1473:
1474: -- Setup query string for SIC_CODE_TYPE
1475: l_prim_temp := null;
1476: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1477: g_party_stage_rec.TX47,'A21',l_prim_temp);
1478:
1479: IF l_denorm_str IS NOT NULL THEN
1480: IF (p_non_denorm_max_score+25)>=p_threshold THEN

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

1478:
1479: IF l_denorm_str IS NOT NULL THEN
1480: IF (p_non_denorm_max_score+25)>=p_threshold THEN
1481: l_denorm_str := NULL;
1482: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1483: ELSIF (p_non_denorm_max_score+p_denorm_max_score+25)>=p_threshold THEN
1484: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1485: l_denorm_str := NULL;
1486: END IF;

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

1480: IF (p_non_denorm_max_score+25)>=p_threshold THEN
1481: l_denorm_str := NULL;
1482: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1483: ELSIF (p_non_denorm_max_score+p_denorm_max_score+25)>=p_threshold THEN
1484: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1485: l_denorm_str := NULL;
1486: END IF;
1487: ELSE
1488: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1484: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1485: l_denorm_str := NULL;
1486: END IF;
1487: ELSE
1488: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1489: END IF;
1490:
1491: -- Setup query string for SIC_CODE
1492: l_prim_temp := null;

Line 1493: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1489: END IF;
1490:
1491: -- Setup query string for SIC_CODE
1492: l_prim_temp := null;
1493: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1494: g_party_stage_rec.TX46,'A20',l_prim_temp);
1495:
1496: IF l_denorm_str IS NOT NULL THEN
1497: IF (p_non_denorm_max_score+25)>=p_threshold THEN

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

1495:
1496: IF l_denorm_str IS NOT NULL THEN
1497: IF (p_non_denorm_max_score+25)>=p_threshold THEN
1498: l_denorm_str := NULL;
1499: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1500: ELSIF (p_non_denorm_max_score+p_denorm_max_score+25)>=p_threshold THEN
1501: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1502: l_denorm_str := NULL;
1503: END IF;

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

1497: IF (p_non_denorm_max_score+25)>=p_threshold THEN
1498: l_denorm_str := NULL;
1499: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1500: ELSIF (p_non_denorm_max_score+p_denorm_max_score+25)>=p_threshold THEN
1501: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1502: l_denorm_str := NULL;
1503: END IF;
1504: ELSE
1505: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1501: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1502: l_denorm_str := NULL;
1503: END IF;
1504: ELSE
1505: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1506: END IF;
1507:
1508: -- Setup query string for PARTY_ALL_NAMES
1509: l_prim_temp := null;

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

1506: END IF;
1507:
1508: -- Setup query string for PARTY_ALL_NAMES
1509: l_prim_temp := null;
1510: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1511: g_party_stage_rec.TX40,'A15',l_prim_temp);
1512: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1513: g_party_stage_rec.TX158,'A15',l_prim_temp);
1514:

Line 1512: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX

1508: -- Setup query string for PARTY_ALL_NAMES
1509: l_prim_temp := null;
1510: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1511: g_party_stage_rec.TX40,'A15',l_prim_temp);
1512: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1513: g_party_stage_rec.TX158,'A15',l_prim_temp);
1514:
1515: IF l_denorm_str IS NOT NULL THEN
1516: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1514:
1515: IF l_denorm_str IS NOT NULL THEN
1516: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1517: l_denorm_str := NULL;
1518: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1519: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1520: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1521: l_denorm_str := NULL;
1522: END IF;

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

1516: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1517: l_denorm_str := NULL;
1518: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1519: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1520: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1521: l_denorm_str := NULL;
1522: END IF;
1523: ELSE
1524: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1520: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1521: l_denorm_str := NULL;
1522: END IF;
1523: ELSE
1524: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1525: END IF;
1526:
1527: -- Setup query string for JGZZ_FISCAL_CODE
1528: l_prim_temp := null;

Line 1529: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1525: END IF;
1526:
1527: -- Setup query string for JGZZ_FISCAL_CODE
1528: l_prim_temp := null;
1529: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1530: g_party_stage_rec.TX45,'A19',l_prim_temp);
1531:
1532: IF l_denorm_str IS NOT NULL THEN
1533: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1531:
1532: IF l_denorm_str IS NOT NULL THEN
1533: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1534: l_denorm_str := NULL;
1535: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1536: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1537: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1538: l_denorm_str := NULL;
1539: END IF;

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

1533: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1534: l_denorm_str := NULL;
1535: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1536: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1537: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1538: l_denorm_str := NULL;
1539: END IF;
1540: ELSE
1541: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1537: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1538: l_denorm_str := NULL;
1539: END IF;
1540: ELSE
1541: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1542: END IF;
1543:
1544: -- Setup query string for PARTY_NUMBER
1545: l_prim_temp := null;

Line 1546: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1542: END IF;
1543:
1544: -- Setup query string for PARTY_NUMBER
1545: l_prim_temp := null;
1546: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1547: g_party_stage_rec.TX34,'A12',l_prim_temp);
1548:
1549: IF l_denorm_str IS NOT NULL THEN
1550: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1548:
1549: IF l_denorm_str IS NOT NULL THEN
1550: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1551: l_denorm_str := NULL;
1552: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1553: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1554: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1555: l_denorm_str := NULL;
1556: END IF;

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

1550: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1551: l_denorm_str := NULL;
1552: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1553: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1554: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1555: l_denorm_str := NULL;
1556: END IF;
1557: ELSE
1558: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1554: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1555: l_denorm_str := NULL;
1556: END IF;
1557: ELSE
1558: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1559: END IF;
1560:
1561: -- Setup query string for TAX_REFERENCE
1562: l_prim_temp := null;

Line 1563: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1559: END IF;
1560:
1561: -- Setup query string for TAX_REFERENCE
1562: l_prim_temp := null;
1563: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1564: g_party_stage_rec.TX44,'A18',l_prim_temp);
1565:
1566: IF l_denorm_str IS NOT NULL THEN
1567: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1565:
1566: IF l_denorm_str IS NOT NULL THEN
1567: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1568: l_denorm_str := NULL;
1569: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1570: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1571: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1572: l_denorm_str := NULL;
1573: END IF;

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

1567: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1568: l_denorm_str := NULL;
1569: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1570: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1571: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1572: l_denorm_str := NULL;
1573: END IF;
1574: ELSE
1575: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1571: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1572: l_denorm_str := NULL;
1573: END IF;
1574: ELSE
1575: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1576: END IF;
1577: IF lengthb(l_party_contains_str) > 4000 THEN
1578: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1579: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1624:
1625: -- Setup query string for ADDRESS
1626: l_prim_temp := null;
1627: l_prim_temp_den := null;
1628: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1629: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1630: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1631:
1632: -- Setup query string for CITY

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( -- CLEANSE SPECIAL + WRADDRESS
1629: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1630: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1631:
1632: -- Setup query string for CITY
1633: l_prim_temp := null;
1634: l_prim_temp_den := null;

Line 1635: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1631:
1632: -- Setup query string for CITY
1633: l_prim_temp := null;
1634: l_prim_temp_den := null;
1635: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1636: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1637: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1638: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1639: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1637: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1633: l_prim_temp := null;
1634: l_prim_temp_den := null;
1635: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1636: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1637: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1638: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1639: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1640: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1641:

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

1635: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1636: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1637: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1638: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1639: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1640: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1641:
1642: -- Setup query string for POSTAL_CODE
1643: l_prim_temp := null;

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

1636: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1637: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1638: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1639: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1640: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1641:
1642: -- Setup query string for POSTAL_CODE
1643: l_prim_temp := null;
1644: l_prim_temp_den := null;

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

1641:
1642: -- Setup query string for POSTAL_CODE
1643: l_prim_temp := null;
1644: l_prim_temp_den := null;
1645: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1646: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1647: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1648: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1649: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1643: l_prim_temp := null;
1644: l_prim_temp_den := null;
1645: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1646: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1647: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1648: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1649: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1650: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1651:

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

1645: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1646: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1647: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1648: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1649: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1650: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1651:
1652: -- Setup query string for STATE
1653: l_prim_temp := null;

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

1646: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1647: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1648: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1649: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1650: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1651:
1652: -- Setup query string for STATE
1653: l_prim_temp := null;
1654: l_prim_temp_den := null;

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

1651:
1652: -- Setup query string for STATE
1653: l_prim_temp := null;
1654: l_prim_temp_den := null;
1655: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1656: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1657: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1658: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1659: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1653: l_prim_temp := null;
1654: l_prim_temp_den := null;
1655: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1656: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1657: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1658: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1659: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1660: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1661:

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

1655: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1656: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1657: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1658: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1659: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1660: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1661:
1662: -- Setup query string for COUNTRY
1663: l_prim_temp := null;

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

1656: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1657: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1658: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1659: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1660: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1661:
1662: -- Setup query string for COUNTRY
1663: l_prim_temp := null;
1664: l_prim_temp_den := null;

Line 1665: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1661:
1662: -- Setup query string for COUNTRY
1663: l_prim_temp := null;
1664: l_prim_temp_den := null;
1665: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1666: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1667: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1668: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1669: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1667: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1663: l_prim_temp := null;
1664: l_prim_temp_den := null;
1665: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1666: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1667: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1668: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1669: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1670: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1671:

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

1665: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1666: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1667: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1668: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1669: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1670: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1671:
1672: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1673: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1666: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1667: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1668: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1669: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1670: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1671:
1672: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1673: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1674: END LOOP;

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

1668: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1669: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1670: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1671:
1672: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1673: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1674: END LOOP;
1675: -- Add the search criteria to query string
1676: IF lengthb(l_contains_str) > 4000 THEN

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

1669: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1670: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1671:
1672: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1673: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1674: END LOOP;
1675: -- Add the search criteria to query string
1676: IF lengthb(l_contains_str) > 4000 THEN
1677: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1708:
1709: -- Setup query string for CONTACT_NAME
1710: l_prim_temp := null;
1711: l_prim_temp_den := null;
1712: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1713: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1714: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1715: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1716: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);

Line 1714: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX

1710: l_prim_temp := null;
1711: l_prim_temp_den := null;
1712: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1713: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1714: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1715: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1716: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1717:
1718: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1712: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRPERSON
1713: g_contact_stage_list(I).TX6,'A39',l_prim_temp);
1714: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1715: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1716: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1717:
1718: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1719: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1720: END LOOP;

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

1714: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1715: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1716: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1717:
1718: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1719: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1720: END LOOP;
1721: -- Add the search criteria to query string
1722: IF lengthb(l_contains_str) > 4000 THEN

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

1715: g_contact_stage_list(I).TX156,'A39',l_prim_temp);
1716: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1717:
1718: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1719: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1720: END LOOP;
1721: -- Add the search criteria to query string
1722: IF lengthb(l_contains_str) > 4000 THEN
1723: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1776:
1777: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1778: l_prim_temp := null;
1779: l_prim_temp_den := null;
1780: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1781: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1782: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1783:
1784: -- Setup query string for EMAIL_ADDRESS

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

1778: l_prim_temp := null;
1779: l_prim_temp_den := null;
1780: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1781: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1782: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1783:
1784: -- Setup query string for EMAIL_ADDRESS
1785: l_prim_temp := null;
1786: l_prim_temp_den := null;

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

1783:
1784: -- Setup query string for EMAIL_ADDRESS
1785: l_prim_temp := null;
1786: l_prim_temp_den := null;
1787: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1788: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1789: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1790:
1791: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1785: l_prim_temp := null;
1786: l_prim_temp_den := null;
1787: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1788: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1789: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1790:
1791: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1792: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1793: IF N>1 THEN

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

1787: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1788: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1789: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1790:
1791: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1792: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1793: IF N>1 THEN
1794: distinct_search_cpt_types := N-1;
1795: ELSE

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

1788: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1789: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1790:
1791: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1792: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1793: IF N>1 THEN
1794: distinct_search_cpt_types := N-1;
1795: ELSE
1796: distinct_search_cpt_types := N;

Line 2973: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2969: H_PARTY_ID.DELETE;
2970: H_PARTY_ID_LIST.DELETE;
2971: H_SCORES.DELETE;
2972: g_mappings.DELETE;
2973: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2974: call_order(5) := call_order(1);
2975: call_type(5) := 'AND';
2976: call_max_score(5) := call_max_score(1);
2977: call_type(2) := 'OR';

Line 3802: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3798: ELSE
3799: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3800: END IF;
3801: END LOOP;
3802: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3803: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3804: 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);
3805: END IF;
3806: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3973: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3969: H_PARTY_ID.DELETE;
3970: H_PARTY_ID_LIST.DELETE;
3971: H_SCORES.DELETE;
3972: g_mappings.DELETE;
3973: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3974: call_order(5) := call_order(1);
3975: call_type(5) := 'AND';
3976: call_max_score(5) := call_max_score(1);
3977: call_type(2) := 'OR';

Line 4673: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4669: ELSE
4670: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4671: END IF;
4672: END LOOP;
4673: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4675: 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);
4676: END IF;
4677: EXCEPTION