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

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

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

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

192: END IF;
193: RETURN total;
194: END IF;
195: END IF;
196: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) 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.TX39, p_table_TX39,43) 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.TX39, p_table_TX39,43) THEN
206: total := total+40;
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 213: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) 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);
210: END IF;
211: RETURN total;
212: END IF;
213: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
214: total := total+32;
215: IF g_score_until_thresh AND (total)>=g_thres_score THEN
216: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
217: 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 222: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN

218: END IF;
219: RETURN total;
220: END IF;
221: END IF;
222: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN
223: total := total+60;
224: IF g_score_until_thresh AND (total)>=g_thres_score THEN
225: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
226: 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 255: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

251: RETURN l_current_score;
252: END IF;
253: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
254: l_current_score := 0;
255: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
256: l_current_score:=l_current_score+ 40;
257: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
258: x_matchidx:=J;
259: RETURN l_current_score;

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

258: x_matchidx:=J;
259: RETURN l_current_score;
260: END IF;
261: ELSIF -- l_current_score<32 AND
262: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
263: l_current_score:=l_current_score+ 32;
264: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
265: x_matchidx:=J;
266: RETURN l_current_score;

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

265: x_matchidx:=J;
266: RETURN l_current_score;
267: END IF;
268: END IF;
269: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
270: l_current_score:=l_current_score+ 30;
271: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
272: x_matchidx:=J;
273: RETURN l_current_score;

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

272: x_matchidx:=J;
273: RETURN l_current_score;
274: END IF;
275: ELSIF -- l_current_score<24 AND
276: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
277: l_current_score:=l_current_score+ 24;
278: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
279: x_matchidx:=J;
280: RETURN l_current_score;

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

279: x_matchidx:=J;
280: RETURN l_current_score;
281: END IF;
282: END IF;
283: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
284: l_current_score:=l_current_score+ 40;
285: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
286: x_matchidx:=J;
287: RETURN l_current_score;

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

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

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

293: x_matchidx:=J;
294: RETURN l_current_score;
295: END IF;
296: ELSIF -- l_current_score<16 AND
297: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX13, p_table_TX13,(50000*(J-1)+76)) THEN
298: l_current_score:=l_current_score+ 16;
299: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
300: x_matchidx:=J;
301: RETURN l_current_score;

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

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

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

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

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

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

Line 345: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN

341: RETURN l_current_score;
342: END IF;
343: FOR J IN 1..g_contact_stage_list.COUNT LOOP
344: l_current_score := 0;
345: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN
346: l_current_score:=l_current_score+ 20;
347: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
348: x_matchidx:=J;
349: RETURN l_current_score;

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

370: RETURN l_current_score;
371: END IF;
372: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
373: l_current_score := 0;
374: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
375: l_current_score:=l_current_score+ 60;
376: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
377: x_matchidx:=J;
378: RETURN l_current_score;

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

377: x_matchidx:=J;
378: RETURN l_current_score;
379: END IF;
380: END IF;
381: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
382: l_current_score:=l_current_score+ 60;
383: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
384: x_matchidx:=J;
385: RETURN l_current_score;

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

384: x_matchidx:=J;
385: RETURN l_current_score;
386: END IF;
387: ELSIF -- l_current_score<48 AND
388: HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX6, p_table_TX6,(50000*(J-1)+115)) THEN
389: l_current_score:=l_current_score+ 48;
390: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
391: x_matchidx:=J;
392: RETURN l_current_score;

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

589: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
590: 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);
591: END IF;
592: l_score :=0;
593: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX34, p_table_TX34,(50000*(p_idx-1)+38)) THEN
594: l_score :=60;
595: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
596: 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);
597: END IF;

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

614: 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);
615: END IF;
616: END IF;
617: l_score :=0;
618: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN
619: l_score :=60;
620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
621: 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);
622: END IF;

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

639: 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);
640: END IF;
641: END IF;
642: l_score :=0;
643: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
644: l_score :=40;
645: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
646: 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);
647: END IF;

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

645: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
646: 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);
647: END IF;
648: ELSIF l_current_score<32 AND
649: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
650: l_score :=32;
651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
652: 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);
653: END IF;

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

670: 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);
671: END IF;
672: END IF;
673: l_score :=0;
674: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
675: l_score :=60;
676: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
677: 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);
678: END IF;

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

721: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
722: 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);
723: END IF;
724: l_score :=0;
725: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
726: l_score :=40;
727: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
728: 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);
729: END IF;

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

727: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
728: 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);
729: END IF;
730: ELSIF l_current_score<32 AND
731: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
732: l_score :=32;
733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
734: 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);
735: END IF;

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

752: 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);
753: END IF;
754: END IF;
755: l_score :=0;
756: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
757: l_score :=30;
758: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
759: 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);
760: END IF;

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

758: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
759: 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);
760: END IF;
761: ELSIF l_current_score<24 AND
762: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
763: l_score :=24;
764: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
765: 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);
766: END IF;

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

783: 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);
784: END IF;
785: END IF;
786: l_score :=0;
787: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
788: l_score :=40;
789: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
790: 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);
791: END IF;

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

808: 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);
809: END IF;
810: END IF;
811: l_score :=0;
812: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX12, p_table_TX12,(50000*(p_idx-1)+75)) THEN
813: l_score :=20;
814: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
815: 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);
816: END IF;

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

814: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
815: 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);
816: END IF;
817: ELSIF l_current_score<16 AND
818: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX13, p_table_TX13,(50000*(p_idx-1)+76)) THEN
819: l_score :=16;
820: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
821: 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);
822: END IF;

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

839: 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);
840: END IF;
841: END IF;
842: l_score :=0;
843: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
844: l_score :=20;
845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
846: 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);
847: END IF;

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

845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
846: 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);
847: END IF;
848: ELSIF l_current_score<16 AND
849: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
850: l_score :=16;
851: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
852: 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);
853: END IF;

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

870: 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);
871: END IF;
872: END IF;
873: l_score :=0;
874: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
875: l_score :=10;
876: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
877: 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);
878: END IF;

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

912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
913: hz_utility_v2pub.debug(p_message=>'Inside Calling Procedure - INSERT_CONTACTS_SCORE',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
914: END IF;
915: l_score :=0;
916: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+109)) THEN
917: l_score :=20;
918: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
919: 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);
920: END IF;

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

956: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
957: 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);
958: END IF;
959: l_score :=0;
960: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
961: l_score :=60;
962: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
963: 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);
964: END IF;

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

981: 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);
982: END IF;
983: END IF;
984: l_score :=0;
985: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
986: l_score :=60;
987: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
988: 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);
989: END IF;

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

987: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
988: 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);
989: END IF;
990: ELSIF l_current_score<48 AND
991: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
992: l_score :=48;
993: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
994: 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);
995: END IF;

Line 1171: HZ_DQM_SEARCH_UTIL.set_score;

1167: END IF;
1168: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1169: 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);
1170: END IF;
1171: HZ_DQM_SEARCH_UTIL.set_score;
1172: g_mappings.DELETE;
1173: g_party_site_stage_list.DELETE;
1174: g_contact_stage_list.DELETE;
1175: g_contact_pt_stage_list.DELETE;

Line 1178: HZ_DQM_SEARCH_UTIL.new_search;

1174: g_contact_stage_list.DELETE;
1175: g_contact_pt_stage_list.DELETE;
1176: call_order.DELETE;
1177: call_max_score.DELETE;
1178: HZ_DQM_SEARCH_UTIL.new_search;
1179: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1180: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1181:
1182: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1180: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1176: call_order.DELETE;
1177: call_max_score.DELETE;
1178: HZ_DQM_SEARCH_UTIL.new_search;
1179: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1180: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1181:
1182: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1183: 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);
1184: END IF;

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

1362: END IF;
1363:
1364: -- Setup query string for PARTY_ALL_NAMES
1365: l_prim_temp := null;
1366: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1367: g_party_stage_rec.TX40,'A15',l_prim_temp);
1368:
1369: IF l_denorm_str IS NOT NULL THEN
1370: IF (p_non_denorm_max_score+40)>=p_threshold THEN

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

1368:
1369: IF l_denorm_str IS NOT NULL THEN
1370: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1371: l_denorm_str := NULL;
1372: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1373: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1374: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1375: l_denorm_str := NULL;
1376: END IF;

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

1370: IF (p_non_denorm_max_score+40)>=p_threshold THEN
1371: l_denorm_str := NULL;
1372: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1373: ELSIF (p_non_denorm_max_score+p_denorm_max_score+40)>=p_threshold THEN
1374: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1375: l_denorm_str := NULL;
1376: END IF;
1377: ELSE
1378: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1374: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1375: l_denorm_str := NULL;
1376: END IF;
1377: ELSE
1378: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1379: END IF;
1380:
1381: -- Setup query string for ALL_ACCOUNT_NUMBERS
1382: l_prim_temp := null;

Line 1383: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1379: END IF;
1380:
1381: -- Setup query string for ALL_ACCOUNT_NUMBERS
1382: l_prim_temp := null;
1383: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1384: g_party_stage_rec.TX35,'A13',l_prim_temp);
1385:
1386: IF l_denorm_str IS NOT NULL THEN
1387: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1385:
1386: IF l_denorm_str IS NOT NULL THEN
1387: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1388: l_denorm_str := NULL;
1389: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1390: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1391: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1392: l_denorm_str := NULL;
1393: END IF;

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

1387: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1388: l_denorm_str := NULL;
1389: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1390: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1391: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1392: l_denorm_str := NULL;
1393: END IF;
1394: ELSE
1395: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1391: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1392: l_denorm_str := NULL;
1393: END IF;
1394: ELSE
1395: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1396: END IF;
1397:
1398: -- Setup query string for PARTY_NUMBER
1399: l_prim_temp := null;

Line 1400: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1396: END IF;
1397:
1398: -- Setup query string for PARTY_NUMBER
1399: l_prim_temp := null;
1400: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1401: g_party_stage_rec.TX34,'A12',l_prim_temp);
1402:
1403: IF l_denorm_str IS NOT NULL THEN
1404: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1402:
1403: IF l_denorm_str IS NOT NULL THEN
1404: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1405: l_denorm_str := NULL;
1406: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1407: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1408: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1409: l_denorm_str := NULL;
1410: END IF;

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

1404: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1405: l_denorm_str := NULL;
1406: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1407: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1408: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1409: l_denorm_str := NULL;
1410: END IF;
1411: ELSE
1412: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1408: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1409: l_denorm_str := NULL;
1410: END IF;
1411: ELSE
1412: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1413: END IF;
1414:
1415: -- Setup query string for JGZZ_FISCAL_CODE
1416: l_prim_temp := null;

Line 1417: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1413: END IF;
1414:
1415: -- Setup query string for JGZZ_FISCAL_CODE
1416: l_prim_temp := null;
1417: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1418: g_party_stage_rec.TX45,'A19',l_prim_temp);
1419:
1420: IF l_denorm_str IS NOT NULL THEN
1421: IF (p_non_denorm_max_score+60)>=p_threshold THEN

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

1419:
1420: IF l_denorm_str IS NOT NULL THEN
1421: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1422: l_denorm_str := NULL;
1423: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1424: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1425: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1426: l_denorm_str := NULL;
1427: END IF;

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

1421: IF (p_non_denorm_max_score+60)>=p_threshold THEN
1422: l_denorm_str := NULL;
1423: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1424: ELSIF (p_non_denorm_max_score+p_denorm_max_score+60)>=p_threshold THEN
1425: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1426: l_denorm_str := NULL;
1427: END IF;
1428: ELSE
1429: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1425: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1426: l_denorm_str := NULL;
1427: END IF;
1428: ELSE
1429: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1430: END IF;
1431: IF lengthb(l_party_contains_str) > 4000 THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1433: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1478:
1479: -- Setup query string for ADDRESS
1480: l_prim_temp := null;
1481: l_prim_temp_den := null;
1482: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1483: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1484: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1485:
1486: -- Setup query string for CITY

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

1480: l_prim_temp := null;
1481: l_prim_temp_den := null;
1482: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1483: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1484: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1485:
1486: -- Setup query string for CITY
1487: l_prim_temp := null;
1488: l_prim_temp_den := null;

Line 1489: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1485:
1486: -- Setup query string for CITY
1487: l_prim_temp := null;
1488: l_prim_temp_den := null;
1489: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1490: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1491: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1492: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1493: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1491: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1487: l_prim_temp := null;
1488: l_prim_temp_den := null;
1489: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1490: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1491: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1492: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1493: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1494: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1495:

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

1489: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1490: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1491: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1492: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1493: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1494: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1495:
1496: -- Setup query string for POSTAL_CODE
1497: l_prim_temp := null;

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

1490: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1491: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1492: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1493: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1494: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1495:
1496: -- Setup query string for POSTAL_CODE
1497: l_prim_temp := null;
1498: l_prim_temp_den := null;

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

1495:
1496: -- Setup query string for POSTAL_CODE
1497: l_prim_temp := null;
1498: l_prim_temp_den := null;
1499: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1500: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1501: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1502: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1503: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1497: l_prim_temp := null;
1498: l_prim_temp_den := null;
1499: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1500: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1501: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1502: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1503: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1504: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1505:

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

1499: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1500: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1501: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1502: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1503: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1504: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1505:
1506: -- Setup query string for PROVINCE
1507: l_prim_temp := null;

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

1500: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1501: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1502: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1503: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1504: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1505:
1506: -- Setup query string for PROVINCE
1507: l_prim_temp := null;
1508: l_prim_temp_den := null;

Line 1509: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1505:
1506: -- Setup query string for PROVINCE
1507: l_prim_temp := null;
1508: l_prim_temp_den := null;
1509: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1510: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1511: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1512: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1513: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1511: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1507: l_prim_temp := null;
1508: l_prim_temp_den := null;
1509: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1510: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1511: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1512: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1513: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1514: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1515:

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

1509: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1510: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1511: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1512: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1513: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1514: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1515:
1516: -- Setup query string for STATE
1517: l_prim_temp := null;

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

1510: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1511: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1512: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1513: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1514: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1515:
1516: -- Setup query string for STATE
1517: l_prim_temp := null;
1518: l_prim_temp_den := null;

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

1515:
1516: -- Setup query string for STATE
1517: l_prim_temp := null;
1518: l_prim_temp_den := null;
1519: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1520: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1521: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1522: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1523: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE

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

1517: l_prim_temp := null;
1518: l_prim_temp_den := null;
1519: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1520: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1521: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1522: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1523: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1524: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1525: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE

Line 1523: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE

1519: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1520: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1521: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1522: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1523: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1524: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1525: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1526: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1527: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1525: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE

1521: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1522: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1523: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1524: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1525: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1526: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1527: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1528: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1529:

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

1523: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1524: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1525: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1526: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1527: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1528: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1529:
1530: -- Setup query string for COUNTRY
1531: l_prim_temp := null;

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

1524: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1525: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1526: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1527: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1528: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1529:
1530: -- Setup query string for COUNTRY
1531: l_prim_temp := null;
1532: l_prim_temp_den := null;

Line 1533: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1529:
1530: -- Setup query string for COUNTRY
1531: l_prim_temp := null;
1532: l_prim_temp_den := null;
1533: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1534: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1535: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1536: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1537: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1535: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1531: l_prim_temp := null;
1532: l_prim_temp_den := null;
1533: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1534: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1535: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1536: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1537: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1538: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1539:

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

1533: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1534: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1535: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1536: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1537: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1538: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1539:
1540: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1541: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1534: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1535: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1536: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1537: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1538: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1539:
1540: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1541: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1542: END LOOP;

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

1536: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1537: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1538: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1539:
1540: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1541: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1542: END LOOP;
1543: -- Add the search criteria to query string
1544: IF lengthb(l_contains_str) > 4000 THEN

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

1537: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1538: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1539:
1540: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1541: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1542: END LOOP;
1543: -- Add the search criteria to query string
1544: IF lengthb(l_contains_str) > 4000 THEN
1545: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1580: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1576:
1577: -- Setup query string for JOB_TITLE
1578: l_prim_temp := null;
1579: l_prim_temp_den := null;
1580: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1581: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1582: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1583: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1584: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1582: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1578: l_prim_temp := null;
1579: l_prim_temp_den := null;
1580: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1581: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1582: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1583: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1584: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1585: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1586:

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

1580: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1581: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1582: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1583: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1584: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1585: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1586:
1587: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1588: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1581: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1582: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1583: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1584: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1585: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1586:
1587: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1588: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1589: END LOOP;

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

1583: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1584: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1585: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1586:
1587: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1588: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1589: END LOOP;
1590: -- Add the search criteria to query string
1591: IF lengthb(l_contains_str) > 4000 THEN

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

1584: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1585: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1586:
1587: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1588: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1589: END LOOP;
1590: -- Add the search criteria to query string
1591: IF lengthb(l_contains_str) > 4000 THEN
1592: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1645:
1646: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
1647: l_prim_temp := null;
1648: l_prim_temp_den := null;
1649: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1650: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1651: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1652:
1653: -- Setup query string for EMAIL_ADDRESS

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

1647: l_prim_temp := null;
1648: l_prim_temp_den := null;
1649: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
1650: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
1651: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1652:
1653: -- Setup query string for EMAIL_ADDRESS
1654: l_prim_temp := null;
1655: l_prim_temp_den := null;

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

1652:
1653: -- Setup query string for EMAIL_ADDRESS
1654: l_prim_temp := null;
1655: l_prim_temp_den := null;
1656: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1657: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1658: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1659:
1660: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1654: l_prim_temp := null;
1655: l_prim_temp_den := null;
1656: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1657: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1658: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1659:
1660: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1661: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1662: IF N>1 THEN

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

1656: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1657: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1658: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1659:
1660: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1661: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1662: IF N>1 THEN
1663: distinct_search_cpt_types := N-1;
1664: ELSE

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

1657: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1658: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1659:
1660: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1661: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1662: IF N>1 THEN
1663: distinct_search_cpt_types := N-1;
1664: ELSE
1665: distinct_search_cpt_types := N;

Line 2825: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2821: H_PARTY_ID.DELETE;
2822: H_PARTY_ID_LIST.DELETE;
2823: H_SCORES.DELETE;
2824: g_mappings.DELETE;
2825: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2826: call_order(5) := call_order(1);
2827: call_type(5) := 'AND';
2828: call_max_score(5) := call_max_score(1);
2829: call_type(2) := 'OR';

Line 3656: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3652: ELSE
3653: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3654: END IF;
3655: END LOOP;
3656: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3657: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3658: 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);
3659: END IF;
3660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3824: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3820: H_PARTY_ID.DELETE;
3821: H_PARTY_ID_LIST.DELETE;
3822: H_SCORES.DELETE;
3823: g_mappings.DELETE;
3824: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3825: call_order(5) := call_order(1);
3826: call_type(5) := 'AND';
3827: call_max_score(5) := call_max_score(1);
3828: call_type(2) := 'OR';

Line 4526: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4522: ELSE
4523: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4524: END IF;
4525: END LOOP;
4526: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4528: 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);
4529: END IF;
4530: EXCEPTION