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

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

192: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
193: END IF;
194: RETURN total;
195: END IF;
196: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX32, p_table_TX32,36) THEN
197: total := total+60;
198: IF g_score_until_thresh AND (total)>=g_thres_score THEN
199: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
200: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

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

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

210: END IF;
211: RETURN total;
212: END IF;
213: END IF;
214: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN
215: total := total+100;
216: IF g_score_until_thresh AND (total)>=g_thres_score THEN
217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
218: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

219: END IF;
220: RETURN total;
221: END IF;
222: END IF;
223: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
224: total := total+60;
225: IF g_score_until_thresh AND (total)>=g_thres_score THEN
226: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

227: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
228: END IF;
229: RETURN total;
230: END IF;
231: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
232: total := total+48;
233: IF g_score_until_thresh AND (total)>=g_thres_score THEN
234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
235: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 239: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX158, p_table_TX158,123) THEN

235: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
236: END IF;
237: RETURN total;
238: END IF;
239: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX158, p_table_TX158,123) THEN
240: total := total+36;
241: IF g_score_until_thresh AND (total)>=g_thres_score THEN
242: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
243: 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 248: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX42, p_table_TX42,46) THEN

244: END IF;
245: RETURN total;
246: END IF;
247: END IF;
248: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX42, p_table_TX42,46) THEN
249: total := total+30;
250: IF g_score_until_thresh AND (total)>=g_thres_score THEN
251: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
252: 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 256: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX43, p_table_TX43,47) THEN

252: 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);
253: END IF;
254: RETURN total;
255: END IF;
256: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX43, p_table_TX43,47) THEN
257: total := total+24;
258: IF g_score_until_thresh AND (total)>=g_thres_score THEN
259: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
260: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 265: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

261: END IF;
262: RETURN total;
263: END IF;
264: END IF;
265: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
266: total := total+56;
267: IF g_score_until_thresh AND (total)>=g_thres_score THEN
268: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
269: 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 274: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN

270: END IF;
271: RETURN total;
272: END IF;
273: END IF;
274: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN
275: total := total+30;
276: IF g_score_until_thresh AND (total)>=g_thres_score THEN
277: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
278: 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 283: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX47, p_table_TX47,52) THEN

279: END IF;
280: RETURN total;
281: END IF;
282: END IF;
283: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX47, p_table_TX47,52) THEN
284: total := total+10;
285: IF g_score_until_thresh AND (total)>=g_thres_score THEN
286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
287: 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 292: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX48, p_table_TX48,53) THEN

288: END IF;
289: RETURN total;
290: END IF;
291: END IF;
292: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX48, p_table_TX48,53) THEN
293: total := total+10;
294: IF g_score_until_thresh AND (total)>=g_thres_score THEN
295: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
296: 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 301: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX156, p_table_TX156,121) THEN

297: END IF;
298: RETURN total;
299: END IF;
300: END IF;
301: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX156, p_table_TX156,121) THEN
302: total := total+20;
303: IF g_score_until_thresh AND (total)>=g_thres_score THEN
304: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
305: 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 310: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX157, p_table_TX157,122) THEN

306: END IF;
307: RETURN total;
308: END IF;
309: END IF;
310: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX157, p_table_TX157,122) THEN
311: total := total+30;
312: IF g_score_until_thresh AND (total)>=g_thres_score THEN
313: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
314: 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 342: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN

338: RETURN l_current_score;
339: END IF;
340: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
341: l_current_score := 0;
342: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
343: l_current_score:=l_current_score+ 30;
344: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
345: x_matchidx:=J;
346: RETURN l_current_score;

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

345: x_matchidx:=J;
346: RETURN l_current_score;
347: END IF;
348: ELSIF -- l_current_score<24 AND
349: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
350: l_current_score:=l_current_score+ 24;
351: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
352: x_matchidx:=J;
353: RETURN l_current_score;

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

352: x_matchidx:=J;
353: RETURN l_current_score;
354: END IF;
355: END IF;
356: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
357: l_current_score:=l_current_score+ 35;
358: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
359: x_matchidx:=J;
360: RETURN l_current_score;

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

359: x_matchidx:=J;
360: RETURN l_current_score;
361: END IF;
362: END IF;
363: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX13, p_table_TX13,(50000*(J-1)+76)) THEN
364: l_current_score:=l_current_score+ 14;
365: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
366: x_matchidx:=J;
367: RETURN l_current_score;

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

366: x_matchidx:=J;
367: RETURN l_current_score;
368: END IF;
369: END IF;
370: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
371: l_current_score:=l_current_score+ 20;
372: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
373: x_matchidx:=J;
374: RETURN l_current_score;

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

373: x_matchidx:=J;
374: RETURN l_current_score;
375: END IF;
376: ELSIF -- l_current_score<16 AND
377: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN
378: l_current_score:=l_current_score+ 16;
379: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
380: x_matchidx:=J;
381: RETURN l_current_score;

Line 384: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX20, p_table_TX20,(50000*(J-1)+83)) THEN

380: x_matchidx:=J;
381: RETURN l_current_score;
382: END IF;
383: END IF;
384: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX20, p_table_TX20,(50000*(J-1)+83)) THEN
385: l_current_score:=l_current_score+ 20;
386: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
387: x_matchidx:=J;
388: RETURN l_current_score;

Line 391: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX21, p_table_TX21,(50000*(J-1)+84)) THEN

387: x_matchidx:=J;
388: RETURN l_current_score;
389: END IF;
390: ELSIF -- l_current_score<16 AND
391: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX21, p_table_TX21,(50000*(J-1)+84)) THEN
392: l_current_score:=l_current_score+ 16;
393: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
394: x_matchidx:=J;
395: RETURN l_current_score;

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

394: x_matchidx:=J;
395: RETURN l_current_score;
396: END IF;
397: END IF;
398: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
399: l_current_score:=l_current_score+ 30;
400: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
401: x_matchidx:=J;
402: RETURN l_current_score;

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

442: RETURN l_current_score;
443: END IF;
444: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
445: l_current_score := 0;
446: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
447: l_current_score:=l_current_score+ 80;
448: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
449: x_matchidx:=J;
450: RETURN l_current_score;

Line 453: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+112)) THEN

449: x_matchidx:=J;
450: RETURN l_current_score;
451: END IF;
452: END IF;
453: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+112)) THEN
454: l_current_score:=l_current_score+ 30;
455: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
456: x_matchidx:=J;
457: RETURN l_current_score;

Line 460: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+113)) THEN

456: x_matchidx:=J;
457: RETURN l_current_score;
458: END IF;
459: END IF;
460: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+113)) THEN
461: l_current_score:=l_current_score+ 10;
462: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
463: x_matchidx:=J;
464: RETURN l_current_score;

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

790: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
791: 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);
792: END IF;
793: l_score :=0;
794: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX32, p_table_TX32,(50000*(p_idx-1)+36)) THEN
795: l_score :=60;
796: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
797: 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);
798: END IF;

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

815: 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);
816: END IF;
817: END IF;
818: l_score :=0;
819: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
820: l_score :=100;
821: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
822: 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);
823: END IF;

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

840: 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);
841: END IF;
842: END IF;
843: l_score :=0;
844: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN
845: l_score :=100;
846: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
847: 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);
848: END IF;

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

865: 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);
866: END IF;
867: END IF;
868: l_score :=0;
869: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
870: l_score :=60;
871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
872: 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);
873: END IF;

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

871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
872: 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);
873: END IF;
874: ELSIF l_current_score<48 AND
875: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
876: l_score :=48;
877: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
878: 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);
879: END IF;

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

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

Line 906: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX42, p_table_TX42,(50000*(p_idx-1)+46)) THEN

902: 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);
903: END IF;
904: END IF;
905: l_score :=0;
906: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX42, p_table_TX42,(50000*(p_idx-1)+46)) THEN
907: l_score :=30;
908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
909: 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);
910: END IF;

Line 912: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX43, p_table_TX43,(50000*(p_idx-1)+47)) THEN

908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
909: 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);
910: END IF;
911: ELSIF l_current_score<24 AND
912: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX43, p_table_TX43,(50000*(p_idx-1)+47)) THEN
913: l_score :=24;
914: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
915: 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);
916: END IF;

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

933: 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);
934: END IF;
935: END IF;
936: l_score :=0;
937: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
938: l_score :=56;
939: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
940: 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);
941: END IF;

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

958: 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);
959: END IF;
960: END IF;
961: l_score :=0;
962: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN
963: l_score :=30;
964: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
965: 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);
966: END IF;

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

983: 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);
984: END IF;
985: END IF;
986: l_score :=0;
987: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX47, p_table_TX47,(50000*(p_idx-1)+52)) THEN
988: l_score :=10;
989: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
990: 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);
991: END IF;

Line 1012: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX48, p_table_TX48,(50000*(p_idx-1)+53)) THEN

1008: 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);
1009: END IF;
1010: END IF;
1011: l_score :=0;
1012: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX48, p_table_TX48,(50000*(p_idx-1)+53)) THEN
1013: l_score :=10;
1014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1015: 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);
1016: END IF;

Line 1037: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX156, p_table_TX156,(50000*(p_idx-1)+121)) THEN

1033: 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);
1034: END IF;
1035: END IF;
1036: l_score :=0;
1037: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX156, p_table_TX156,(50000*(p_idx-1)+121)) THEN
1038: l_score :=20;
1039: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1040: 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);
1041: END IF;

Line 1062: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX157, p_table_TX157,(50000*(p_idx-1)+122)) THEN

1058: 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);
1059: END IF;
1060: END IF;
1061: l_score :=0;
1062: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX157, p_table_TX157,(50000*(p_idx-1)+122)) THEN
1063: l_score :=30;
1064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1065: 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);
1066: END IF;

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

1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1109: 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);
1110: END IF;
1111: l_score :=0;
1112: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
1113: l_score :=30;
1114: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1115: 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);
1116: END IF;

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

1114: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1115: 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);
1116: END IF;
1117: ELSIF l_current_score<24 AND
1118: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
1119: l_score :=24;
1120: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1121: 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);
1122: END IF;

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

1139: 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);
1140: END IF;
1141: END IF;
1142: l_score :=0;
1143: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
1144: l_score :=35;
1145: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1146: 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);
1147: END IF;

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

1164: 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);
1165: END IF;
1166: END IF;
1167: l_score :=0;
1168: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX13, p_table_TX13,(50000*(p_idx-1)+76)) THEN
1169: l_score :=14;
1170: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1171: 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);
1172: END IF;

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

1189: 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);
1190: END IF;
1191: END IF;
1192: l_score :=0;
1193: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
1194: l_score :=20;
1195: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1196: 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);
1197: END IF;

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

1195: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1196: 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);
1197: END IF;
1198: ELSIF l_current_score<16 AND
1199: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
1200: l_score :=16;
1201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1202: 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);
1203: END IF;

Line 1224: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX20, p_table_TX20,(50000*(p_idx-1)+83)) THEN

1220: 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);
1221: END IF;
1222: END IF;
1223: l_score :=0;
1224: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX20, p_table_TX20,(50000*(p_idx-1)+83)) THEN
1225: l_score :=20;
1226: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1227: 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);
1228: END IF;

Line 1230: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX21, p_table_TX21,(50000*(p_idx-1)+84)) THEN

1226: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1227: 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);
1228: END IF;
1229: ELSIF l_current_score<16 AND
1230: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX21, p_table_TX21,(50000*(p_idx-1)+84)) THEN
1231: l_score :=16;
1232: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1233: 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);
1234: END IF;

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

1251: 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);
1252: END IF;
1253: END IF;
1254: l_score :=0;
1255: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
1256: l_score :=30;
1257: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1258: 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);
1259: END IF;

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

1311: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1312: 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);
1313: END IF;
1314: l_score :=0;
1315: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
1316: l_score :=80;
1317: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1318: 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);
1319: END IF;

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

1336: 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);
1337: END IF;
1338: END IF;
1339: l_score :=0;
1340: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+112)) THEN
1341: l_score :=30;
1342: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1343: 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);
1344: END IF;

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

1361: 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);
1362: END IF;
1363: END IF;
1364: l_score :=0;
1365: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+113)) THEN
1366: l_score :=10;
1367: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1368: 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);
1369: END IF;

Line 1545: HZ_DQM_SEARCH_UTIL.set_score;

1541: END IF;
1542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1543: 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);
1544: END IF;
1545: HZ_DQM_SEARCH_UTIL.set_score;
1546: g_mappings.DELETE;
1547: g_party_site_stage_list.DELETE;
1548: g_contact_stage_list.DELETE;
1549: g_contact_pt_stage_list.DELETE;

Line 1552: HZ_DQM_SEARCH_UTIL.new_search;

1548: g_contact_stage_list.DELETE;
1549: g_contact_pt_stage_list.DELETE;
1550: call_order.DELETE;
1551: call_max_score.DELETE;
1552: HZ_DQM_SEARCH_UTIL.new_search;
1553: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1554: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1555:
1556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1554: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1550: call_order.DELETE;
1551: call_max_score.DELETE;
1552: HZ_DQM_SEARCH_UTIL.new_search;
1553: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1554: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1555:
1556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1557: 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);
1558: END IF;

Line 1740: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1736: END IF;
1737:
1738: -- Setup query string for SIC_CODE_TYPE
1739: l_prim_temp := null;
1740: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1741: g_party_stage_rec.TX47,'A21',l_prim_temp);
1742:
1743: IF l_denorm_str IS NOT NULL THEN
1744: IF (p_non_denorm_max_score+10)>=p_threshold THEN

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

1742:
1743: IF l_denorm_str IS NOT NULL THEN
1744: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1745: l_denorm_str := NULL;
1746: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1747: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1748: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1749: l_denorm_str := NULL;
1750: END IF;

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

1744: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1745: l_denorm_str := NULL;
1746: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1747: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1748: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1749: l_denorm_str := NULL;
1750: END IF;
1751: ELSE
1752: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1748: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1749: l_denorm_str := NULL;
1750: END IF;
1751: ELSE
1752: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1753: END IF;
1754:
1755: -- Setup query string for CATEGORY_CODE
1756: l_prim_temp := null;

Line 1757: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1753: END IF;
1754:
1755: -- Setup query string for CATEGORY_CODE
1756: l_prim_temp := null;
1757: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1758: g_party_stage_rec.TX48,'A22',l_prim_temp);
1759:
1760: IF l_denorm_str IS NOT NULL THEN
1761: IF (p_non_denorm_max_score+10)>=p_threshold THEN

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

1759:
1760: IF l_denorm_str IS NOT NULL THEN
1761: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1762: l_denorm_str := NULL;
1763: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1764: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1765: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1766: l_denorm_str := NULL;
1767: END IF;

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

1761: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1762: l_denorm_str := NULL;
1763: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1764: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1765: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1766: l_denorm_str := NULL;
1767: END IF;
1768: ELSE
1769: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1765: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1766: l_denorm_str := NULL;
1767: END IF;
1768: ELSE
1769: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1770: END IF;
1771:
1772: -- Setup query string for REFERENCE_USE_FLAG
1773: l_prim_temp := null;

Line 1774: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1770: END IF;
1771:
1772: -- Setup query string for REFERENCE_USE_FLAG
1773: l_prim_temp := null;
1774: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1775: g_party_stage_rec.TX156,'A53',l_prim_temp);
1776:
1777: IF l_denorm_str IS NOT NULL THEN
1778: IF (p_non_denorm_max_score+20)>=p_threshold THEN

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

1776:
1777: IF l_denorm_str IS NOT NULL THEN
1778: IF (p_non_denorm_max_score+20)>=p_threshold THEN
1779: l_denorm_str := NULL;
1780: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1781: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
1782: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1783: l_denorm_str := NULL;
1784: END IF;

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

1778: IF (p_non_denorm_max_score+20)>=p_threshold THEN
1779: l_denorm_str := NULL;
1780: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1781: ELSIF (p_non_denorm_max_score+p_denorm_max_score+20)>=p_threshold THEN
1782: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1783: l_denorm_str := NULL;
1784: END IF;
1785: ELSE
1786: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1782: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1783: l_denorm_str := NULL;
1784: END IF;
1785: ELSE
1786: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1787: END IF;
1788:
1789: -- Setup query string for TAX_NAME
1790: l_prim_temp := null;

Line 1791: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1787: END IF;
1788:
1789: -- Setup query string for TAX_NAME
1790: l_prim_temp := null;
1791: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1792: g_party_stage_rec.TX43,'A17',l_prim_temp);
1793:
1794: IF l_denorm_str IS NOT NULL THEN
1795: IF (p_non_denorm_max_score+30)>=p_threshold THEN

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

1793:
1794: IF l_denorm_str IS NOT NULL THEN
1795: IF (p_non_denorm_max_score+30)>=p_threshold THEN
1796: l_denorm_str := NULL;
1797: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1798: ELSIF (p_non_denorm_max_score+p_denorm_max_score+30)>=p_threshold THEN
1799: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1800: l_denorm_str := NULL;
1801: END IF;

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

1795: IF (p_non_denorm_max_score+30)>=p_threshold THEN
1796: l_denorm_str := NULL;
1797: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1798: ELSIF (p_non_denorm_max_score+p_denorm_max_score+30)>=p_threshold THEN
1799: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1800: l_denorm_str := NULL;
1801: END IF;
1802: ELSE
1803: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1799: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1800: l_denorm_str := NULL;
1801: END IF;
1802: ELSE
1803: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1804: END IF;
1805:
1806: -- Setup query string for SIC_CODE
1807: l_prim_temp := null;

Line 1808: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1804: END IF;
1805:
1806: -- Setup query string for SIC_CODE
1807: l_prim_temp := null;
1808: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1809: g_party_stage_rec.TX46,'A20',l_prim_temp);
1810:
1811: IF l_denorm_str IS NOT NULL THEN
1812: IF (p_non_denorm_max_score+30)>=p_threshold THEN

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

1810:
1811: IF l_denorm_str IS NOT NULL THEN
1812: IF (p_non_denorm_max_score+30)>=p_threshold THEN
1813: l_denorm_str := NULL;
1814: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1815: ELSIF (p_non_denorm_max_score+p_denorm_max_score+30)>=p_threshold THEN
1816: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1817: l_denorm_str := NULL;
1818: END IF;

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

1812: IF (p_non_denorm_max_score+30)>=p_threshold THEN
1813: l_denorm_str := NULL;
1814: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1815: ELSIF (p_non_denorm_max_score+p_denorm_max_score+30)>=p_threshold THEN
1816: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1817: l_denorm_str := NULL;
1818: END IF;
1819: ELSE
1820: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1816: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1817: l_denorm_str := NULL;
1818: END IF;
1819: ELSE
1820: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1821: END IF;
1822:
1823: -- Setup query string for CORPORATION_CLASS
1824: l_prim_temp := null;

Line 1825: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1821: END IF;
1822:
1823: -- Setup query string for CORPORATION_CLASS
1824: l_prim_temp := null;
1825: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1826: g_party_stage_rec.TX157,'A54',l_prim_temp);
1827:
1828: IF l_denorm_str IS NOT NULL THEN
1829: IF (p_non_denorm_max_score+30)>=p_threshold THEN

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

1827:
1828: IF l_denorm_str IS NOT NULL THEN
1829: IF (p_non_denorm_max_score+30)>=p_threshold THEN
1830: l_denorm_str := NULL;
1831: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1832: ELSIF (p_non_denorm_max_score+p_denorm_max_score+30)>=p_threshold THEN
1833: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1834: l_denorm_str := NULL;
1835: END IF;

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

1829: IF (p_non_denorm_max_score+30)>=p_threshold THEN
1830: l_denorm_str := NULL;
1831: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1832: ELSIF (p_non_denorm_max_score+p_denorm_max_score+30)>=p_threshold THEN
1833: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1834: l_denorm_str := NULL;
1835: END IF;
1836: ELSE
1837: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1833: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1834: l_denorm_str := NULL;
1835: END IF;
1836: ELSE
1837: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1838: END IF;
1839:
1840: -- Setup query string for PARTY_ALL_NAMES
1841: l_prim_temp := null;

Line 1842: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX

1838: END IF;
1839:
1840: -- Setup query string for PARTY_ALL_NAMES
1841: l_prim_temp := null;
1842: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1843: g_party_stage_rec.TX158,'A15',l_prim_temp);
1844: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1845: g_party_stage_rec.TX40,'A15',l_prim_temp);
1846:

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

1840: -- Setup query string for PARTY_ALL_NAMES
1841: l_prim_temp := null;
1842: HZ_DQM_SEARCH_UTIL.add_transformation( -- SOUNDEX
1843: g_party_stage_rec.TX158,'A15',l_prim_temp);
1844: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1845: g_party_stage_rec.TX40,'A15',l_prim_temp);
1846:
1847: IF l_denorm_str IS NOT NULL THEN
1848: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1846:
1847: IF l_denorm_str IS NOT NULL THEN
1848: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1849: l_denorm_str := NULL;
1850: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1851: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1852: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1853: l_denorm_str := NULL;
1854: END IF;

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

1848: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1849: l_denorm_str := NULL;
1850: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1851: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1852: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1853: l_denorm_str := NULL;
1854: END IF;
1855: ELSE
1856: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1852: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1853: l_denorm_str := NULL;
1854: END IF;
1855: ELSE
1856: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1857: END IF;
1858:
1859: -- Setup query string for ALL_ACCOUNT_NAMES
1860: l_prim_temp := null;

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

1857: END IF;
1858:
1859: -- Setup query string for ALL_ACCOUNT_NAMES
1860: l_prim_temp := null;
1861: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1862: g_party_stage_rec.TX33,'A11',l_prim_temp);
1863:
1864: IF l_denorm_str IS NOT NULL THEN
1865: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1863:
1864: IF l_denorm_str IS NOT NULL THEN
1865: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1866: l_denorm_str := NULL;
1867: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1868: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1869: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1870: l_denorm_str := NULL;
1871: END IF;

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

1865: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1866: l_denorm_str := NULL;
1867: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1868: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1869: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1870: l_denorm_str := NULL;
1871: END IF;
1872: ELSE
1873: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1869: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1870: l_denorm_str := NULL;
1871: END IF;
1872: ELSE
1873: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1874: END IF;
1875:
1876: -- Setup query string for TAX_REFERENCE
1877: l_prim_temp := null;

Line 1878: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1874: END IF;
1875:
1876: -- Setup query string for TAX_REFERENCE
1877: l_prim_temp := null;
1878: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1879: g_party_stage_rec.TX44,'A18',l_prim_temp);
1880:
1881: IF l_denorm_str IS NOT NULL THEN
1882: IF (p_non_denorm_max_score+80)>=p_threshold THEN

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

1880:
1881: IF l_denorm_str IS NOT NULL THEN
1882: IF (p_non_denorm_max_score+80)>=p_threshold THEN
1883: l_denorm_str := NULL;
1884: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1885: ELSIF (p_non_denorm_max_score+p_denorm_max_score+80)>=p_threshold THEN
1886: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1887: l_denorm_str := NULL;
1888: END IF;

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

1882: IF (p_non_denorm_max_score+80)>=p_threshold THEN
1883: l_denorm_str := NULL;
1884: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1885: ELSIF (p_non_denorm_max_score+p_denorm_max_score+80)>=p_threshold THEN
1886: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1887: l_denorm_str := NULL;
1888: END IF;
1889: ELSE
1890: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1886: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1887: l_denorm_str := NULL;
1888: END IF;
1889: ELSE
1890: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1891: END IF;
1892:
1893: -- Setup query string for PARTY_NUMBER
1894: l_prim_temp := null;

Line 1895: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1891: END IF;
1892:
1893: -- Setup query string for PARTY_NUMBER
1894: l_prim_temp := null;
1895: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1896: g_party_stage_rec.TX34,'A12',l_prim_temp);
1897:
1898: IF l_denorm_str IS NOT NULL THEN
1899: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1897:
1898: IF l_denorm_str IS NOT NULL THEN
1899: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1900: l_denorm_str := NULL;
1901: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1902: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1903: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1904: l_denorm_str := NULL;
1905: END IF;

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

1899: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1900: l_denorm_str := NULL;
1901: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1902: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1903: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1904: l_denorm_str := NULL;
1905: END IF;
1906: ELSE
1907: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1903: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1904: l_denorm_str := NULL;
1905: END IF;
1906: ELSE
1907: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1908: END IF;
1909:
1910: -- Setup query string for ALL_ACCOUNT_NUMBERS
1911: l_prim_temp := null;

Line 1912: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1908: END IF;
1909:
1910: -- Setup query string for ALL_ACCOUNT_NUMBERS
1911: l_prim_temp := null;
1912: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1913: g_party_stage_rec.TX35,'A13',l_prim_temp);
1914:
1915: IF l_denorm_str IS NOT NULL THEN
1916: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

1914:
1915: IF l_denorm_str IS NOT NULL THEN
1916: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1917: l_denorm_str := NULL;
1918: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1919: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1920: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1921: l_denorm_str := NULL;
1922: END IF;

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

1916: IF (p_non_denorm_max_score+100)>=p_threshold THEN
1917: l_denorm_str := NULL;
1918: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1919: ELSIF (p_non_denorm_max_score+p_denorm_max_score+100)>=p_threshold THEN
1920: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1921: l_denorm_str := NULL;
1922: END IF;
1923: ELSE
1924: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1920: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1921: l_denorm_str := NULL;
1922: END IF;
1923: ELSE
1924: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1925: END IF;
1926: IF lengthb(l_party_contains_str) > 4000 THEN
1927: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1928: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 1977: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1973:
1974: -- Setup query string for CITY
1975: l_prim_temp := null;
1976: l_prim_temp_den := null;
1977: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1978: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1979: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1980: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1981: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1979: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1975: l_prim_temp := null;
1976: l_prim_temp_den := null;
1977: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1978: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1979: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1980: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1981: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1982: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1983:

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

1977: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1978: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1979: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1980: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1981: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1982: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1983:
1984: -- Setup query string for POSTAL_CODE
1985: l_prim_temp := null;

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

1978: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1979: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1980: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1981: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1982: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1983:
1984: -- Setup query string for POSTAL_CODE
1985: l_prim_temp := null;
1986: l_prim_temp_den := null;

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

1983:
1984: -- Setup query string for POSTAL_CODE
1985: l_prim_temp := null;
1986: l_prim_temp_den := null;
1987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1988: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1989: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1990: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1991: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1985: l_prim_temp := null;
1986: l_prim_temp_den := null;
1987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1988: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1989: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1990: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1991: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1992: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1993:

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

1987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1988: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1989: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1990: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1991: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1992: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1993:
1994: -- Setup query string for PROVINCE
1995: l_prim_temp := null;

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

1988: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1989: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1990: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1991: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1992: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1993:
1994: -- Setup query string for PROVINCE
1995: l_prim_temp := null;
1996: l_prim_temp_den := null;

Line 1997: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1993:
1994: -- Setup query string for PROVINCE
1995: l_prim_temp := null;
1996: l_prim_temp_den := null;
1997: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1998: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1999: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2000: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
2001: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1999: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1995: l_prim_temp := null;
1996: l_prim_temp_den := null;
1997: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1998: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1999: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2000: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
2001: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2002: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2003:

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

1997: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1998: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1999: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2000: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
2001: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2002: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2003:
2004: -- Setup query string for STATE
2005: l_prim_temp := null;

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

1998: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1999: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2000: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
2001: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2002: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2003:
2004: -- Setup query string for STATE
2005: l_prim_temp := null;
2006: l_prim_temp_den := null;

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

2003:
2004: -- Setup query string for STATE
2005: l_prim_temp := null;
2006: l_prim_temp_den := null;
2007: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
2008: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
2009: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
2010: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
2011: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

2005: l_prim_temp := null;
2006: l_prim_temp_den := null;
2007: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
2008: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
2009: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
2010: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
2011: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2012: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2013:

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

2007: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
2008: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
2009: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
2010: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
2011: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2012: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2013:
2014: -- Setup query string for COUNTY
2015: l_prim_temp := null;

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

2008: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
2009: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
2010: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
2011: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2012: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2013:
2014: -- Setup query string for COUNTY
2015: l_prim_temp := null;
2016: l_prim_temp_den := null;

Line 2017: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

2013:
2014: -- Setup query string for COUNTY
2015: l_prim_temp := null;
2016: l_prim_temp_den := null;
2017: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2018: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
2019: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2020: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
2021: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 2019: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

2015: l_prim_temp := null;
2016: l_prim_temp_den := null;
2017: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2018: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
2019: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2020: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
2021: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2022: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2023:

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

2017: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2018: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
2019: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2020: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
2021: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2022: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2023:
2024: -- Setup query string for COUNTRY
2025: l_prim_temp := null;

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

2018: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
2019: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
2020: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
2021: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2022: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2023:
2024: -- Setup query string for COUNTRY
2025: l_prim_temp := null;
2026: l_prim_temp_den := null;

Line 2027: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

2023:
2024: -- Setup query string for COUNTRY
2025: l_prim_temp := null;
2026: l_prim_temp_den := null;
2027: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2028: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
2029: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2030: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2031: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 2029: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

2025: l_prim_temp := null;
2026: l_prim_temp_den := null;
2027: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2028: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
2029: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2030: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2031: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2032: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2033:

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

2027: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2028: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
2029: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2030: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2031: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2032: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2033:
2034: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2035: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

2028: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
2029: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2030: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2031: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2032: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2033:
2034: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2035: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2036: END LOOP;

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

2030: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2031: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2032: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2033:
2034: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2035: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2036: END LOOP;
2037: -- Add the search criteria to query string
2038: IF lengthb(l_contains_str) > 4000 THEN

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

2031: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2032: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2033:
2034: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2035: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2036: END LOOP;
2037: -- Add the search criteria to query string
2038: IF lengthb(l_contains_str) > 4000 THEN
2039: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

2108:
2109: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
2110: l_prim_temp := null;
2111: l_prim_temp_den := null;
2112: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
2113: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
2114: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2115:
2116: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

2110: l_prim_temp := null;
2111: l_prim_temp_den := null;
2112: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
2113: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
2114: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2115:
2116: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2117: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2118: IF N>1 THEN

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

2112: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
2113: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
2114: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2115:
2116: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2117: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2118: IF N>1 THEN
2119: distinct_search_cpt_types := N-1;
2120: ELSE

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

2113: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
2114: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2115:
2116: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2117: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2118: IF N>1 THEN
2119: distinct_search_cpt_types := N-1;
2120: ELSE
2121: distinct_search_cpt_types := N;

Line 3352: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3348: H_PARTY_ID.DELETE;
3349: H_PARTY_ID_LIST.DELETE;
3350: H_SCORES.DELETE;
3351: g_mappings.DELETE;
3352: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3353: call_order(5) := call_order(1);
3354: call_type(5) := 'AND';
3355: call_max_score(5) := call_max_score(1);
3356: call_type(2) := 'OR';

Line 4183: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4179: ELSE
4180: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4181: END IF;
4182: END LOOP;
4183: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4184: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4185: 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);
4186: END IF;
4187: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4359: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

4355: H_PARTY_ID.DELETE;
4356: H_PARTY_ID_LIST.DELETE;
4357: H_SCORES.DELETE;
4358: g_mappings.DELETE;
4359: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
4360: call_order(5) := call_order(1);
4361: call_type(5) := 'AND';
4362: call_max_score(5) := call_max_score(1);
4363: call_type(2) := 'OR';

Line 5061: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

5057: ELSE
5058: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
5059: END IF;
5060: END LOOP;
5061: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
5062: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5063: 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);
5064: END IF;
5065: EXCEPTION