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

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

181: 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);
182: END IF;
183: RETURN total;
184: END IF;
185: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX34, p_table_TX34,38) THEN
186: total := total+80;
187: IF g_score_until_thresh AND (total)>=g_thres_score THEN
188: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
189: 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 194: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN

190: END IF;
191: RETURN total;
192: END IF;
193: END IF;
194: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
195: total := total+40;
196: IF g_score_until_thresh AND (total)>=g_thres_score THEN
197: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
198: 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 202: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

198: 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);
199: END IF;
200: RETURN total;
201: END IF;
202: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
203: total := total+32;
204: IF g_score_until_thresh AND (total)>=g_thres_score THEN
205: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
206: 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 237: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

233: RETURN l_current_score;
234: END IF;
235: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
236: l_current_score := 0;
237: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
238: l_current_score:=l_current_score+ 50;
239: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
240: x_matchidx:=J;
241: RETURN l_current_score;

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

240: x_matchidx:=J;
241: RETURN l_current_score;
242: END IF;
243: ELSIF -- l_current_score<40 AND
244: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
245: l_current_score:=l_current_score+ 40;
246: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
247: x_matchidx:=J;
248: RETURN l_current_score;

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

247: x_matchidx:=J;
248: RETURN l_current_score;
249: END IF;
250: END IF;
251: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
252: l_current_score:=l_current_score+ 30;
253: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
254: x_matchidx:=J;
255: RETURN l_current_score;

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

254: x_matchidx:=J;
255: RETURN l_current_score;
256: END IF;
257: ELSIF -- l_current_score<24 AND
258: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
259: l_current_score:=l_current_score+ 24;
260: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
261: x_matchidx:=J;
262: RETURN l_current_score;

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

261: x_matchidx:=J;
262: RETURN l_current_score;
263: END IF;
264: END IF;
265: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
266: l_current_score:=l_current_score+ 40;
267: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
268: x_matchidx:=J;
269: RETURN l_current_score;

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

268: x_matchidx:=J;
269: RETURN l_current_score;
270: END IF;
271: END IF;
272: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX12, p_table_TX12,(50000*(J-1)+75)) THEN
273: l_current_score:=l_current_score+ 20;
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).TX13, p_table_TX13,(50000*(J-1)+76)) THEN

275: x_matchidx:=J;
276: RETURN l_current_score;
277: END IF;
278: ELSIF -- l_current_score<16 AND
279: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX13, p_table_TX13,(50000*(J-1)+76)) THEN
280: l_current_score:=l_current_score+ 16;
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).TX14, p_table_TX14,(50000*(J-1)+77)) 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).TX14, p_table_TX14,(50000*(J-1)+77)) 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).TX15, p_table_TX15,(50000*(J-1)+78)) 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).TX15, p_table_TX15,(50000*(J-1)+78)) 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).TX20, p_table_TX20,(50000*(J-1)+83)) 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).TX20, p_table_TX20,(50000*(J-1)+83)) THEN
301: l_current_score:=l_current_score+ 15;
302: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
303: x_matchidx:=J;
304: RETURN l_current_score;

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

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

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

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

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

506: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
507: 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);
508: END IF;
509: l_score :=0;
510: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
511: l_score :=80;
512: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
513: 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);
514: END IF;

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

531: 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);
532: END IF;
533: END IF;
534: l_score :=0;
535: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
536: l_score :=40;
537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
538: 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);
539: END IF;

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

537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
538: 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);
539: END IF;
540: ELSIF l_current_score<32 AND
541: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
542: l_score :=32;
543: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
544: 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);
545: END IF;

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

590: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
591: 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);
592: END IF;
593: l_score :=0;
594: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
595: l_score :=50;
596: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
597: 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);
598: END IF;

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

596: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
597: 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);
598: END IF;
599: ELSIF l_current_score<40 AND
600: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
601: l_score :=40;
602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
603: 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);
604: END IF;

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

621: 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);
622: END IF;
623: END IF;
624: l_score :=0;
625: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
626: l_score :=30;
627: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
628: 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);
629: END IF;

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

627: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
628: 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);
629: END IF;
630: ELSIF l_current_score<24 AND
631: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
632: l_score :=24;
633: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
634: 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);
635: END IF;

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

652: 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);
653: END IF;
654: END IF;
655: l_score :=0;
656: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
657: l_score :=40;
658: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
659: 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);
660: END IF;

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

677: 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);
678: END IF;
679: END IF;
680: l_score :=0;
681: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX12, p_table_TX12,(50000*(p_idx-1)+75)) THEN
682: l_score :=20;
683: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
684: 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);
685: END IF;

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

683: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
684: 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);
685: END IF;
686: ELSIF l_current_score<16 AND
687: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX13, p_table_TX13,(50000*(p_idx-1)+76)) THEN
688: l_score :=16;
689: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
690: 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);
691: END IF;

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

708: 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);
709: END IF;
710: END IF;
711: l_score :=0;
712: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
713: l_score :=20;
714: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
715: 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);
716: END IF;

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

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

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

739: 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);
740: END IF;
741: END IF;
742: l_score :=0;
743: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX20, p_table_TX20,(50000*(p_idx-1)+83)) THEN
744: l_score :=15;
745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
746: 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);
747: END IF;

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

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

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

770: 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);
771: END IF;
772: END IF;
773: l_score :=0;
774: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
775: l_score :=5;
776: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
777: 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);
778: END IF;

Line 986: HZ_DQM_SEARCH_UTIL.set_score;

982: END IF;
983: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
984: 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);
985: END IF;
986: HZ_DQM_SEARCH_UTIL.set_score;
987: g_mappings.DELETE;
988: g_party_site_stage_list.DELETE;
989: g_contact_stage_list.DELETE;
990: g_contact_pt_stage_list.DELETE;

Line 993: HZ_DQM_SEARCH_UTIL.new_search;

989: g_contact_stage_list.DELETE;
990: g_contact_pt_stage_list.DELETE;
991: call_order.DELETE;
992: call_max_score.DELETE;
993: HZ_DQM_SEARCH_UTIL.new_search;
994: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
995: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
996:
997: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 995: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

991: call_order.DELETE;
992: call_max_score.DELETE;
993: HZ_DQM_SEARCH_UTIL.new_search;
994: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
995: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
996:
997: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
998: 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);
999: END IF;

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

1177: END IF;
1178:
1179: -- Setup query string for PARTY_ALL_NAMES
1180: l_prim_temp := null;
1181: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1182: g_party_stage_rec.TX40,'A15',l_prim_temp);
1183:
1184: IF l_denorm_str IS NOT NULL THEN
1185: IF (p_non_denorm_max_score+40)>=p_threshold THEN

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

1183:
1184: IF l_denorm_str IS NOT NULL THEN
1185: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1186: l_denorm_str := NULL;
1187: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1188: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1189: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1190: l_denorm_str := NULL;
1191: END IF;

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

1185: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1186: l_denorm_str := NULL;
1187: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1188: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1189: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1190: l_denorm_str := NULL;
1191: END IF;
1192: ELSE
1193: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1189: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1190: l_denorm_str := NULL;
1191: END IF;
1192: ELSE
1193: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1194: END IF;
1195:
1196: -- Setup query string for PARTY_NUMBER
1197: l_prim_temp := null;

Line 1198: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1194: END IF;
1195:
1196: -- Setup query string for PARTY_NUMBER
1197: l_prim_temp := null;
1198: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1199: g_party_stage_rec.TX34,'A12',l_prim_temp);
1200:
1201: IF l_denorm_str IS NOT NULL THEN
1202: IF (p_non_denorm_max_score+80)>=p_threshold THEN

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

1200:
1201: IF l_denorm_str IS NOT NULL THEN
1202: IF (p_non_denorm_max_score+80)>=p_threshold THEN
1203: l_denorm_str := NULL;
1204: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1205: ELSIF (p_non_denorm_max_score+p_denorm_max_score+80)>=p_threshold THEN
1206: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1207: l_denorm_str := NULL;
1208: END IF;

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

1202: IF (p_non_denorm_max_score+80)>=p_threshold THEN
1203: l_denorm_str := NULL;
1204: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1205: ELSIF (p_non_denorm_max_score+p_denorm_max_score+80)>=p_threshold THEN
1206: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1207: l_denorm_str := NULL;
1208: END IF;
1209: ELSE
1210: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1206: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1207: l_denorm_str := NULL;
1208: END IF;
1209: ELSE
1210: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1211: END IF;
1212: IF lengthb(l_party_contains_str) > 4000 THEN
1213: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1214: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1259:
1260: -- Setup query string for ADDRESS
1261: l_prim_temp := null;
1262: l_prim_temp_den := null;
1263: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1264: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1265: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1266:
1267: -- Setup query string for CITY

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

1261: l_prim_temp := null;
1262: l_prim_temp_den := null;
1263: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1264: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1265: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1266:
1267: -- Setup query string for CITY
1268: l_prim_temp := null;
1269: l_prim_temp_den := null;

Line 1270: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1266:
1267: -- Setup query string for CITY
1268: l_prim_temp := null;
1269: l_prim_temp_den := null;
1270: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1271: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1272: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1273: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1274: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1272: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1268: l_prim_temp := null;
1269: l_prim_temp_den := null;
1270: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1271: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1272: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1273: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1274: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1275: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1276:

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

1270: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1271: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1272: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1273: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1274: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1275: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1276:
1277: -- Setup query string for POSTAL_CODE
1278: l_prim_temp := null;

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

1271: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1272: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1273: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1274: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1275: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1276:
1277: -- Setup query string for POSTAL_CODE
1278: l_prim_temp := null;
1279: l_prim_temp_den := null;

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

1276:
1277: -- Setup query string for POSTAL_CODE
1278: l_prim_temp := null;
1279: l_prim_temp_den := null;
1280: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1281: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1282: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1283: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1284: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1278: l_prim_temp := null;
1279: l_prim_temp_den := null;
1280: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1281: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1282: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1283: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1284: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1285: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1286:

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

1280: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1281: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1282: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1283: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1284: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1285: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1286:
1287: -- Setup query string for PROVINCE
1288: l_prim_temp := null;

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

1281: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1282: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1283: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1284: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1285: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1286:
1287: -- Setup query string for PROVINCE
1288: l_prim_temp := null;
1289: l_prim_temp_den := null;

Line 1290: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1286:
1287: -- Setup query string for PROVINCE
1288: l_prim_temp := null;
1289: l_prim_temp_den := null;
1290: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1291: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1292: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1293: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1294: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1292: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1288: l_prim_temp := null;
1289: l_prim_temp_den := null;
1290: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1291: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1292: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1293: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1294: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1295: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1296:

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

1290: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1291: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1292: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1293: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1294: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1295: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1296:
1297: -- Setup query string for STATE
1298: l_prim_temp := null;

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

1291: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1292: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1293: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1294: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1295: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1296:
1297: -- Setup query string for STATE
1298: l_prim_temp := null;
1299: l_prim_temp_den := null;

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

1296:
1297: -- Setup query string for STATE
1298: l_prim_temp := null;
1299: l_prim_temp_den := null;
1300: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1301: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1302: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1303: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1304: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1298: l_prim_temp := null;
1299: l_prim_temp_den := null;
1300: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1301: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1302: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1303: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1304: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1305: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1306:

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

1300: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1301: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1302: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1303: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1304: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1305: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1306:
1307: -- Setup query string for COUNTY
1308: l_prim_temp := null;

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

1301: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1302: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1303: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1304: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1305: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1306:
1307: -- Setup query string for COUNTY
1308: l_prim_temp := null;
1309: l_prim_temp_den := null;

Line 1310: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1306:
1307: -- Setup query string for COUNTY
1308: l_prim_temp := null;
1309: l_prim_temp_den := null;
1310: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1311: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
1312: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1313: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
1314: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1312: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1308: l_prim_temp := null;
1309: l_prim_temp_den := null;
1310: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1311: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
1312: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1313: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
1314: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1315: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1316:

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

1310: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1311: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
1312: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1313: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
1314: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1315: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1316:
1317: -- Setup query string for COUNTRY
1318: l_prim_temp := null;

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

1311: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
1312: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1313: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
1314: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1315: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1316:
1317: -- Setup query string for COUNTRY
1318: l_prim_temp := null;
1319: l_prim_temp_den := null;

Line 1320: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1316:
1317: -- Setup query string for COUNTRY
1318: l_prim_temp := null;
1319: l_prim_temp_den := null;
1320: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1321: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1322: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1323: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1324: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1322: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1318: l_prim_temp := null;
1319: l_prim_temp_den := null;
1320: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1321: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1322: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1323: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1324: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1325: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1326:

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

1320: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1321: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1322: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1323: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1324: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1325: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1326:
1327: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1328: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1321: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1322: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1323: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1324: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1325: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1326:
1327: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1328: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1329: END LOOP;

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

1323: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1324: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1325: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1326:
1327: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1328: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1329: END LOOP;
1330: -- Add the search criteria to query string
1331: IF lengthb(l_contains_str) > 4000 THEN

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

1324: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1325: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1326:
1327: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1328: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1329: END LOOP;
1330: -- Add the search criteria to query string
1331: IF lengthb(l_contains_str) > 4000 THEN
1332: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2516: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2512: H_PARTY_ID.DELETE;
2513: H_PARTY_ID_LIST.DELETE;
2514: H_SCORES.DELETE;
2515: g_mappings.DELETE;
2516: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2517: call_order(5) := call_order(1);
2518: call_type(5) := 'AND';
2519: call_max_score(5) := call_max_score(1);
2520: call_type(2) := 'OR';

Line 3345: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3341: ELSE
3342: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3343: END IF;
3344: END LOOP;
3345: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3346: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3347: 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);
3348: END IF;
3349: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3510: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3506: H_PARTY_ID.DELETE;
3507: H_PARTY_ID_LIST.DELETE;
3508: H_SCORES.DELETE;
3509: g_mappings.DELETE;
3510: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3511: call_order(5) := call_order(1);
3512: call_type(5) := 'AND';
3513: call_max_score(5) := call_max_score(1);
3514: call_type(2) := 'OR';

Line 4210: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4206: ELSE
4207: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4208: END IF;
4209: END LOOP;
4210: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4211: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4212: 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);
4213: END IF;
4214: EXCEPTION