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

Line 189: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX32, p_table_TX32,36) THEN

185: 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);
186: END IF;
187: RETURN total;
188: END IF;
189: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX32, p_table_TX32,36) THEN
190: total := total+50;
191: IF g_score_until_thresh AND (total)>=g_thres_score THEN
192: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
193: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 197: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX33, p_table_TX33,37) THEN

193: 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);
194: END IF;
195: RETURN total;
196: END IF;
197: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX33, p_table_TX33,37) THEN
198: total := total+40;
199: IF g_score_until_thresh AND (total)>=g_thres_score THEN
200: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
201: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

202: END IF;
203: RETURN total;
204: END IF;
205: END IF;
206: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN
207: total := total+100;
208: IF g_score_until_thresh AND (total)>=g_thres_score THEN
209: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 215: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN

211: END IF;
212: RETURN total;
213: END IF;
214: END IF;
215: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN
216: total := total+100;
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.TX39, p_table_TX39,43) 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.TX39, p_table_TX39,43) THEN
225: total := total+50;
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 232: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) 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);
229: END IF;
230: RETURN total;
231: END IF;
232: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
233: total := total+40;
234: IF g_score_until_thresh AND (total)>=g_thres_score THEN
235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 241: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,45) THEN

237: END IF;
238: RETURN total;
239: END IF;
240: END IF;
241: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,45) THEN
242: total := total+100;
243: IF g_score_until_thresh AND (total)>=g_thres_score THEN
244: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
245: 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 272: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

268: RETURN l_current_score;
269: END IF;
270: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
271: l_current_score := 0;
272: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
273: l_current_score:=l_current_score+ 40;
274: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
275: x_matchidx:=J;
276: RETURN l_current_score;

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

275: x_matchidx:=J;
276: RETURN l_current_score;
277: END IF;
278: ELSIF -- l_current_score<32 AND
279: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
280: l_current_score:=l_current_score+ 32;
281: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
282: x_matchidx:=J;
283: RETURN l_current_score;

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

282: x_matchidx:=J;
283: RETURN l_current_score;
284: END IF;
285: END IF;
286: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
287: l_current_score:=l_current_score+ 20;
288: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
289: x_matchidx:=J;
290: RETURN l_current_score;

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

289: x_matchidx:=J;
290: RETURN l_current_score;
291: END IF;
292: ELSIF -- l_current_score<16 AND
293: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
294: l_current_score:=l_current_score+ 16;
295: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
296: x_matchidx:=J;
297: RETURN l_current_score;

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

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

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

303: x_matchidx:=J;
304: RETURN l_current_score;
305: END IF;
306: END IF;
307: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
308: l_current_score:=l_current_score+ 10;
309: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
310: x_matchidx:=J;
311: RETURN l_current_score;

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

310: x_matchidx:=J;
311: RETURN l_current_score;
312: END IF;
313: ELSIF -- l_current_score<8 AND
314: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN
315: l_current_score:=l_current_score+ 8;
316: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
317: x_matchidx:=J;
318: RETURN l_current_score;

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

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

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

520: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
521: 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);
522: END IF;
523: l_score :=0;
524: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX32, p_table_TX32,(50000*(p_idx-1)+36)) THEN
525: l_score :=50;
526: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
527: 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);
528: END IF;

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

526: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
527: 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);
528: END IF;
529: ELSIF l_current_score<40 AND
530: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX33, p_table_TX33,(50000*(p_idx-1)+37)) THEN
531: l_score :=40;
532: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
533: 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);
534: END IF;

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

551: 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);
552: END IF;
553: END IF;
554: l_score :=0;
555: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
556: l_score :=100;
557: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
558: 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);
559: END IF;

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

576: 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);
577: END IF;
578: END IF;
579: l_score :=0;
580: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN
581: l_score :=100;
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.TX39, p_table_TX39,(50000*(p_idx-1)+43)) 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.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
606: l_score :=50;
607: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
608: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
609: END IF;

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

607: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
608: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
609: END IF;
610: ELSIF l_current_score<40 AND
611: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
612: l_score :=40;
613: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
614: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
615: END IF;

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

632: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ... Done',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
633: END IF;
634: END IF;
635: l_score :=0;
636: IF HZ_DQM_SEARCH_UTIL.is_match(case(instr(g_party_stage_rec.TX41,'%')) when 0 then g_party_stage_rec.TX41 else ltrim(g_party_stage_rec.TX41,chr(48)) END, case(instr(g_party_stage_rec.TX41,'%')) when 0 then p_table_TX41 else ltrim( p_table_TX41,chr(48)) END,(50000*(p_idx-1)+45)) THEN
637: l_score :=100;
638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
640: END IF;

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

681: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
682: 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);
683: END IF;
684: l_score :=0;
685: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
686: l_score :=40;
687: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
688: 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);
689: END IF;

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

687: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
688: 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);
689: END IF;
690: ELSIF l_current_score<32 AND
691: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
692: l_score :=32;
693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
694: 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);
695: END IF;

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

712: 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);
713: END IF;
714: END IF;
715: l_score :=0;
716: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
717: l_score :=20;
718: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
719: 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);
720: END IF;

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

718: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
719: 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);
720: END IF;
721: ELSIF l_current_score<16 AND
722: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
723: l_score :=16;
724: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
725: 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);
726: END IF;

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

743: 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);
744: END IF;
745: END IF;
746: l_score :=0;
747: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
748: l_score :=30;
749: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
750: 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);
751: END IF;

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

768: 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);
769: END IF;
770: END IF;
771: l_score :=0;
772: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
773: l_score :=10;
774: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
775: 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);
776: END IF;

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

774: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
775: 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);
776: END IF;
777: ELSIF l_current_score<8 AND
778: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
779: l_score :=8;
780: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
781: 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);
782: END IF;

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

799: 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);
800: END IF;
801: END IF;
802: l_score :=0;
803: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
804: l_score :=5;
805: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
806: 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);
807: END IF;

Line 1015: HZ_DQM_SEARCH_UTIL.set_score;

1011: END IF;
1012: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1013: 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);
1014: END IF;
1015: HZ_DQM_SEARCH_UTIL.set_score;
1016: g_mappings.DELETE;
1017: g_party_site_stage_list.DELETE;
1018: g_contact_stage_list.DELETE;
1019: g_contact_pt_stage_list.DELETE;

Line 1022: HZ_DQM_SEARCH_UTIL.new_search;

1018: g_contact_stage_list.DELETE;
1019: g_contact_pt_stage_list.DELETE;
1020: call_order.DELETE;
1021: call_max_score.DELETE;
1022: HZ_DQM_SEARCH_UTIL.new_search;
1023: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1024: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1025:
1026: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1024: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1020: call_order.DELETE;
1021: call_max_score.DELETE;
1022: HZ_DQM_SEARCH_UTIL.new_search;
1023: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1024: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1025:
1026: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1027: 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);
1028: END IF;

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

1206: END IF;
1207:
1208: -- Setup query string for PARTY_ALL_NAMES
1209: l_prim_temp := null;
1210: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1211: g_party_stage_rec.TX40,'A15',l_prim_temp);
1212:
1213: IF l_denorm_str IS NOT NULL THEN
1214: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

1212:
1213: IF l_denorm_str IS NOT NULL THEN
1214: IF (p_non_denorm_max_score+50)>=p_threshold THEN
1215: l_denorm_str := NULL;
1216: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1217: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
1218: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1219: l_denorm_str := NULL;
1220: END IF;

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

1214: IF (p_non_denorm_max_score+50)>=p_threshold THEN
1215: l_denorm_str := NULL;
1216: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1217: ELSIF (p_non_denorm_max_score+p_denorm_max_score+50)>=p_threshold THEN
1218: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1219: l_denorm_str := NULL;
1220: END IF;
1221: ELSE
1222: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1218: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1219: l_denorm_str := NULL;
1220: END IF;
1221: ELSE
1222: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1223: END IF;
1224:
1225: -- Setup query string for ALL_ACCOUNT_NAMES
1226: l_prim_temp := null;

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

1223: END IF;
1224:
1225: -- Setup query string for ALL_ACCOUNT_NAMES
1226: l_prim_temp := null;
1227: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1228: g_party_stage_rec.TX33,'A11',l_prim_temp);
1229:
1230: IF l_denorm_str IS NOT NULL THEN
1231: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

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

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

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

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

1235: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1236: l_denorm_str := NULL;
1237: END IF;
1238: ELSE
1239: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1240: END IF;
1241:
1242: -- Setup query string for PARTY_NUMBER
1243: l_prim_temp := null;

Line 1244: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1240: END IF;
1241:
1242: -- Setup query string for PARTY_NUMBER
1243: l_prim_temp := null;
1244: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1245: g_party_stage_rec.TX34,'A12',l_prim_temp);
1246:
1247: IF l_denorm_str IS NOT NULL THEN
1248: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1246:
1247: IF l_denorm_str IS NOT NULL THEN
1248: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1249: l_denorm_str := NULL;
1250: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1251: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1252: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1253: l_denorm_str := NULL;
1254: END IF;

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

1248: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1249: l_denorm_str := NULL;
1250: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1251: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1252: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1253: l_denorm_str := NULL;
1254: END IF;
1255: ELSE
1256: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1252: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1253: l_denorm_str := NULL;
1254: END IF;
1255: ELSE
1256: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1257: END IF;
1258:
1259: -- Setup query string for ALL_ACCOUNT_NUMBERS
1260: l_prim_temp := null;

Line 1261: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1257: END IF;
1258:
1259: -- Setup query string for ALL_ACCOUNT_NUMBERS
1260: l_prim_temp := null;
1261: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1262: g_party_stage_rec.TX35,'A13',l_prim_temp);
1263:
1264: IF l_denorm_str IS NOT NULL THEN
1265: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1263:
1264: IF l_denorm_str IS NOT NULL THEN
1265: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1266: l_denorm_str := NULL;
1267: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1268: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1269: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1270: l_denorm_str := NULL;
1271: END IF;

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

1265: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1266: l_denorm_str := NULL;
1267: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1268: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1269: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1270: l_denorm_str := NULL;
1271: END IF;
1272: ELSE
1273: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1269: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1270: l_denorm_str := NULL;
1271: END IF;
1272: ELSE
1273: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1274: END IF;
1275:
1276: -- Setup query string for DUNS_NUMBER_C
1277: l_prim_temp := null;

Line 1281: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1277: l_prim_temp := null;
1278: IF g_party_stage_rec.TX41 IS NOT NULL THEN
1279: IF ltrim(g_party_stage_rec.TX41,'0') IS NOT NULL THEN
1280: FOR I in lengthb(ltrim(g_party_stage_rec.TX41,'0'))..9 LOOP
1281: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1282: lpad(ltrim(g_party_stage_rec.TX41,'0'),I,chr(48)),'A16',l_prim_temp);
1283: END LOOP;
1284: END IF;
1285: END IF;

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

1286:
1287: IF l_denorm_str IS NOT NULL THEN
1288: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1289: l_denorm_str := NULL;
1290: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1291: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1292: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1293: l_denorm_str := NULL;
1294: END IF;

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

1288: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1289: l_denorm_str := NULL;
1290: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1291: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1292: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1293: l_denorm_str := NULL;
1294: END IF;
1295: ELSE
1296: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1292: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1293: l_denorm_str := NULL;
1294: END IF;
1295: ELSE
1296: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1297: END IF;
1298: IF lengthb(l_party_contains_str) > 4000 THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1300: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1345:
1346: -- Setup query string for ADDRESS
1347: l_prim_temp := null;
1348: l_prim_temp_den := null;
1349: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1350: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1351: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1352:
1353: -- Setup query string for CITY

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

1347: l_prim_temp := null;
1348: l_prim_temp_den := null;
1349: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1350: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1351: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1352:
1353: -- Setup query string for CITY
1354: l_prim_temp := null;
1355: l_prim_temp_den := null;

Line 1356: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1352:
1353: -- Setup query string for CITY
1354: l_prim_temp := null;
1355: l_prim_temp_den := null;
1356: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1357: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1358: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1359: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1360: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1358: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1354: l_prim_temp := null;
1355: l_prim_temp_den := null;
1356: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1357: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1358: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1359: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1360: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1361: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1362:

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

1356: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1357: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1358: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1359: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1360: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1361: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1362:
1363: -- Setup query string for POSTAL_CODE
1364: l_prim_temp := null;

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

1357: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1358: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1359: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1360: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1361: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1362:
1363: -- Setup query string for POSTAL_CODE
1364: l_prim_temp := null;
1365: l_prim_temp_den := null;

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

1362:
1363: -- Setup query string for POSTAL_CODE
1364: l_prim_temp := null;
1365: l_prim_temp_den := null;
1366: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1367: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1368: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1369: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1370: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1364: l_prim_temp := null;
1365: l_prim_temp_den := null;
1366: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1367: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1368: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1369: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1370: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1371: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1372:

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

1366: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1367: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1368: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1369: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1370: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1371: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1372:
1373: -- Setup query string for STATE
1374: l_prim_temp := null;

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

1367: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1368: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1369: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1370: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1371: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1372:
1373: -- Setup query string for STATE
1374: l_prim_temp := null;
1375: l_prim_temp_den := null;

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

1372:
1373: -- Setup query string for STATE
1374: l_prim_temp := null;
1375: l_prim_temp_den := null;
1376: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1377: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1378: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1379: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1380: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1374: l_prim_temp := null;
1375: l_prim_temp_den := null;
1376: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1377: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1378: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1379: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1380: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1381: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1382:

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

1376: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1377: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1378: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1379: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1380: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1381: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1382:
1383: -- Setup query string for COUNTRY
1384: l_prim_temp := null;

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

1377: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1378: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1379: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1380: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1381: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1382:
1383: -- Setup query string for COUNTRY
1384: l_prim_temp := null;
1385: l_prim_temp_den := null;

Line 1386: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1382:
1383: -- Setup query string for COUNTRY
1384: l_prim_temp := null;
1385: l_prim_temp_den := null;
1386: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1387: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1388: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1389: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1390: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1388: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1384: l_prim_temp := null;
1385: l_prim_temp_den := null;
1386: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1387: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1388: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1389: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1390: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1391: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1392:

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

1386: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1387: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1388: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1389: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1390: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1391: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1392:
1393: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1394: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1387: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1388: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1389: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1390: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1391: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1392:
1393: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1394: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1395: END LOOP;

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

1389: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1390: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1391: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1392:
1393: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1394: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1395: END LOOP;
1396: -- Add the search criteria to query string
1397: IF lengthb(l_contains_str) > 4000 THEN

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

1390: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1391: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1392:
1393: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1394: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1395: END LOOP;
1396: -- Add the search criteria to query string
1397: IF lengthb(l_contains_str) > 4000 THEN
1398: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2582: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2578: H_PARTY_ID.DELETE;
2579: H_PARTY_ID_LIST.DELETE;
2580: H_SCORES.DELETE;
2581: g_mappings.DELETE;
2582: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2583: call_order(5) := call_order(1);
2584: call_type(5) := 'AND';
2585: call_max_score(5) := call_max_score(1);
2586: call_type(2) := 'OR';

Line 3413: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3409: ELSE
3410: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3411: END IF;
3412: END LOOP;
3413: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3414: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3415: 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);
3416: END IF;
3417: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3578: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3574: H_PARTY_ID.DELETE;
3575: H_PARTY_ID_LIST.DELETE;
3576: H_SCORES.DELETE;
3577: g_mappings.DELETE;
3578: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3579: call_order(5) := call_order(1);
3580: call_type(5) := 'AND';
3581: call_max_score(5) := call_max_score(1);
3582: call_type(2) := 'OR';

Line 4280: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4276: ELSE
4277: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4278: END IF;
4279: END LOOP;
4280: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4282: 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);
4283: END IF;
4284: EXCEPTION