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

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

180: 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);
181: END IF;
182: RETURN total;
183: END IF;
184: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX39, p_table_TX39,43) THEN
185: total := total+200;
186: IF g_score_until_thresh AND (total)>=g_thres_score THEN
187: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
188: 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 192: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN

188: 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);
189: END IF;
190: RETURN total;
191: END IF;
192: ELSIF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX40, p_table_TX40,44) THEN
193: total := total+160;
194: IF g_score_until_thresh AND (total)>=g_thres_score THEN
195: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
196: 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 227: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

223: RETURN l_current_score;
224: END IF;
225: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
226: l_current_score := 0;
227: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
228: l_current_score:=l_current_score+ 30;
229: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
230: x_matchidx:=J;
231: RETURN l_current_score;

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

230: x_matchidx:=J;
231: RETURN l_current_score;
232: END IF;
233: ELSIF -- l_current_score<21 AND
234: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
235: l_current_score:=l_current_score+ 21;
236: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
237: x_matchidx:=J;
238: RETURN l_current_score;

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

237: x_matchidx:=J;
238: RETURN l_current_score;
239: END IF;
240: END IF;
241: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
242: l_current_score:=l_current_score+ 15;
243: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
244: x_matchidx:=J;
245: RETURN l_current_score;

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

244: x_matchidx:=J;
245: RETURN l_current_score;
246: END IF;
247: ELSIF -- l_current_score<12 AND
248: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
249: l_current_score:=l_current_score+ 12;
250: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
251: x_matchidx:=J;
252: RETURN l_current_score;

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

251: x_matchidx:=J;
252: RETURN l_current_score;
253: END IF;
254: END IF;
255: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
256: l_current_score:=l_current_score+ 20;
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: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX12, p_table_TX12,(50000*(J-1)+75)) THEN

258: x_matchidx:=J;
259: RETURN l_current_score;
260: END IF;
261: END IF;
262: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX12, p_table_TX12,(50000*(J-1)+75)) THEN
263: l_current_score:=l_current_score+ 10;
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: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX13, p_table_TX13,(50000*(J-1)+76)) THEN

265: x_matchidx:=J;
266: RETURN l_current_score;
267: END IF;
268: ELSIF -- l_current_score<8 AND
269: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX13, p_table_TX13,(50000*(J-1)+76)) THEN
270: l_current_score:=l_current_score+ 8;
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: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN

272: x_matchidx:=J;
273: RETURN l_current_score;
274: END IF;
275: END IF;
276: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
277: l_current_score:=l_current_score+ 10;
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: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN

279: x_matchidx:=J;
280: RETURN l_current_score;
281: END IF;
282: ELSIF -- l_current_score<8 AND
283: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN
284: l_current_score:=l_current_score+ 8;
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).TX20, p_table_TX20,(50000*(J-1)+83)) 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).TX20, p_table_TX20,(50000*(J-1)+83)) THEN
291: l_current_score:=l_current_score+ 10;
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).TX21, p_table_TX21,(50000*(J-1)+84)) THEN

293: x_matchidx:=J;
294: RETURN l_current_score;
295: END IF;
296: ELSIF -- l_current_score<8 AND
297: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX21, p_table_TX21,(50000*(J-1)+84)) THEN
298: l_current_score:=l_current_score+ 8;
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).TX22, p_table_TX22,(50000*(J-1)+85)) 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).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
305: l_current_score:=l_current_score+ 5;
306: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
307: x_matchidx:=J;
308: RETURN l_current_score;

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

327: RETURN l_current_score;
328: END IF;
329: FOR J IN 1..g_contact_stage_list.COUNT LOOP
330: l_current_score := 0;
331: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+109)) THEN
332: l_current_score:=l_current_score+ 20;
333: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
334: x_matchidx:=J;
335: RETURN l_current_score;

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

356: RETURN l_current_score;
357: END IF;
358: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
359: l_current_score := 0;
360: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
361: l_current_score:=l_current_score+ 140;
362: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
363: x_matchidx:=J;
364: RETURN l_current_score;

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

363: x_matchidx:=J;
364: RETURN l_current_score;
365: END IF;
366: END IF;
367: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
368: l_current_score:=l_current_score+ 160;
369: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
370: x_matchidx:=J;
371: RETURN l_current_score;

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

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

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

542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
543: 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);
544: END IF;
545: l_score :=0;
546: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX39, p_table_TX39,(50000*(p_idx-1)+43)) THEN
547: l_score :=200;
548: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
549: 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);
550: END IF;

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

548: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
549: 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);
550: END IF;
551: ELSIF l_current_score<160 AND
552: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX40, p_table_TX40,(50000*(p_idx-1)+44)) THEN
553: l_score :=160;
554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
555: 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);
556: END IF;

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

601: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
602: 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);
603: END IF;
604: l_score :=0;
605: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
606: l_score :=30;
607: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
608: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
609: END IF;

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

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

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

632: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ... Done',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
633: END IF;
634: END IF;
635: l_score :=0;
636: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
637: l_score :=15;
638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
640: END IF;

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

638: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
640: END IF;
641: ELSIF l_current_score<12 AND
642: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
643: l_score :=12;
644: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
645: 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);
646: END IF;

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

663: 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);
664: END IF;
665: END IF;
666: l_score :=0;
667: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
668: l_score :=20;
669: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
670: 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);
671: END IF;

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

688: 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);
689: END IF;
690: END IF;
691: l_score :=0;
692: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX12, p_table_TX12,(50000*(p_idx-1)+75)) THEN
693: l_score :=10;
694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
695: 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);
696: END IF;

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

694: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
695: 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);
696: END IF;
697: ELSIF l_current_score<8 AND
698: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX13, p_table_TX13,(50000*(p_idx-1)+76)) THEN
699: l_score :=8;
700: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
701: 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);
702: END IF;

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

719: 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);
720: END IF;
721: END IF;
722: l_score :=0;
723: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
724: l_score :=10;
725: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
726: 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);
727: END IF;

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

725: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
726: 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);
727: END IF;
728: ELSIF l_current_score<8 AND
729: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
730: l_score :=8;
731: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
732: 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);
733: END IF;

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

750: 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);
751: END IF;
752: END IF;
753: l_score :=0;
754: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX20, p_table_TX20,(50000*(p_idx-1)+83)) THEN
755: l_score :=10;
756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
757: 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);
758: END IF;

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

756: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
757: 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);
758: END IF;
759: ELSIF l_current_score<8 AND
760: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX21, p_table_TX21,(50000*(p_idx-1)+84)) THEN
761: l_score :=8;
762: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
763: 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);
764: END IF;

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

781: 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);
782: END IF;
783: END IF;
784: l_score :=0;
785: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
786: l_score :=5;
787: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
788: 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);
789: END IF;

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

823: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
824: 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);
825: END IF;
826: l_score :=0;
827: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+109)) THEN
828: l_score :=20;
829: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
830: 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);
831: END IF;

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

867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
868: 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);
869: END IF;
870: l_score :=0;
871: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
872: l_score :=140;
873: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
874: 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);
875: END IF;

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

892: 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);
893: END IF;
894: END IF;
895: l_score :=0;
896: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
897: l_score :=160;
898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
899: 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);
900: END IF;

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

898: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
899: 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);
900: END IF;
901: ELSIF l_current_score<128 AND
902: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX6, p_table_TX6,(50000*(p_idx-1)+115)) THEN
903: l_score :=128;
904: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
905: 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);
906: END IF;

Line 1082: HZ_DQM_SEARCH_UTIL.set_score;

1078: END IF;
1079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1080: 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);
1081: END IF;
1082: HZ_DQM_SEARCH_UTIL.set_score;
1083: g_mappings.DELETE;
1084: g_party_site_stage_list.DELETE;
1085: g_contact_stage_list.DELETE;
1086: g_contact_pt_stage_list.DELETE;

Line 1089: HZ_DQM_SEARCH_UTIL.new_search;

1085: g_contact_stage_list.DELETE;
1086: g_contact_pt_stage_list.DELETE;
1087: call_order.DELETE;
1088: call_max_score.DELETE;
1089: HZ_DQM_SEARCH_UTIL.new_search;
1090: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1091: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1092:
1093: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1091: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1087: call_order.DELETE;
1088: call_max_score.DELETE;
1089: HZ_DQM_SEARCH_UTIL.new_search;
1090: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1091: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1092:
1093: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1094: 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);
1095: END IF;

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

1273: END IF;
1274:
1275: -- Setup query string for PARTY_ALL_NAMES
1276: l_prim_temp := null;
1277: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRNAMES
1278: g_party_stage_rec.TX40,'A15',l_prim_temp);
1279:
1280: IF l_denorm_str IS NOT NULL THEN
1281: IF (p_non_denorm_max_score+200)>=p_threshold THEN

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

1279:
1280: IF l_denorm_str IS NOT NULL THEN
1281: IF (p_non_denorm_max_score+200)>=p_threshold THEN
1282: l_denorm_str := NULL;
1283: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1284: ELSIF (p_non_denorm_max_score+p_denorm_max_score+200)>=p_threshold THEN
1285: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1286: l_denorm_str := NULL;
1287: END IF;

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

1281: IF (p_non_denorm_max_score+200)>=p_threshold THEN
1282: l_denorm_str := NULL;
1283: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1284: ELSIF (p_non_denorm_max_score+p_denorm_max_score+200)>=p_threshold THEN
1285: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1286: l_denorm_str := NULL;
1287: END IF;
1288: ELSE
1289: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1285: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1286: l_denorm_str := NULL;
1287: END IF;
1288: ELSE
1289: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1290: END IF;
1291: IF lengthb(l_party_contains_str) > 4000 THEN
1292: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1293: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

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

1338:
1339: -- Setup query string for ADDRESS
1340: l_prim_temp := null;
1341: l_prim_temp_den := null;
1342: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1343: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1344: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1345:
1346: -- Setup query string for CITY

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

1340: l_prim_temp := null;
1341: l_prim_temp_den := null;
1342: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1343: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1344: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1345:
1346: -- Setup query string for CITY
1347: l_prim_temp := null;
1348: l_prim_temp_den := null;

Line 1349: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1345:
1346: -- Setup query string for CITY
1347: l_prim_temp := null;
1348: l_prim_temp_den := null;
1349: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1350: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1351: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1352: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1353: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1351: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1347: l_prim_temp := null;
1348: l_prim_temp_den := null;
1349: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1350: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1351: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1352: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1353: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1354: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1355:

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

1349: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1350: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1351: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1352: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1353: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1354: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1355:
1356: -- Setup query string for POSTAL_CODE
1357: l_prim_temp := null;

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

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

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

1355:
1356: -- Setup query string for POSTAL_CODE
1357: l_prim_temp := null;
1358: l_prim_temp_den := null;
1359: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1360: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1361: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1362: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1363: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1357: l_prim_temp := null;
1358: l_prim_temp_den := null;
1359: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1360: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1361: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1362: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1363: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1364: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1365:

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

1359: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1360: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1361: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1362: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1363: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1364: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1365:
1366: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1367: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1360: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1361: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1362: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1363: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1364: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1365:
1366: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1367: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1368: END LOOP;

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

1362: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1363: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1364: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1365:
1366: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1367: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1368: END LOOP;
1369: -- Add the search criteria to query string
1370: IF lengthb(l_contains_str) > 4000 THEN

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

1363: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1364: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1365:
1366: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1367: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1368: END LOOP;
1369: -- Add the search criteria to query string
1370: IF lengthb(l_contains_str) > 4000 THEN
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 1406: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1402:
1403: -- Setup query string for JOB_TITLE
1404: l_prim_temp := null;
1405: l_prim_temp_den := null;
1406: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1407: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1408: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1409: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1410: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1408: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1404: l_prim_temp := null;
1405: l_prim_temp_den := null;
1406: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1407: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1408: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1409: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1410: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1411: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1412:

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

1406: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1407: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1408: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1409: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1410: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1411: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1412:
1413: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1414: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1407: g_contact_stage_list(I).TX22,'A43',l_prim_temp);
1408: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1409: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1410: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1411: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1412:
1413: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1414: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1415: END LOOP;

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

1409: g_contact_stage_list(I).TX22,'D_CT',l_prim_temp_den);
1410: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1411: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1412:
1413: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1414: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1415: END LOOP;
1416: -- Add the search criteria to query string
1417: IF lengthb(l_contains_str) > 4000 THEN

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

1410: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1411: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1412:
1413: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1414: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1415: END LOOP;
1416: -- Add the search criteria to query string
1417: IF lengthb(l_contains_str) > 4000 THEN
1418: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

1450:
1451: -- Setup query string for EMAIL_ADDRESS
1452: l_prim_temp := null;
1453: l_prim_temp_den := null;
1454: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1455: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1456: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1457:
1458: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

1452: l_prim_temp := null;
1453: l_prim_temp_den := null;
1454: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1455: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1456: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1457:
1458: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1459: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1460: END LOOP;

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

1454: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE (EMAIL) + WRDOMAIN
1455: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1456: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1457:
1458: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1459: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1460: END LOOP;
1461: -- Add the search criteria to query string
1462: IF lengthb(l_contains_str) > 4000 THEN

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

1455: g_contact_pt_stage_list(I).TX6,'A48',l_prim_temp);
1456: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1457:
1458: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1459: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1460: END LOOP;
1461: -- Add the search criteria to query string
1462: IF lengthb(l_contains_str) > 4000 THEN
1463: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2569: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2565: H_PARTY_ID.DELETE;
2566: H_PARTY_ID_LIST.DELETE;
2567: H_SCORES.DELETE;
2568: g_mappings.DELETE;
2569: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2570: call_order(5) := call_order(1);
2571: call_type(5) := 'AND';
2572: call_max_score(5) := call_max_score(1);
2573: call_type(2) := 'OR';

Line 3360: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3356: ELSE
3357: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3358: END IF;
3359: END LOOP;
3360: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3361: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3362: 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);
3363: END IF;
3364: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3527: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3523: H_PARTY_ID.DELETE;
3524: H_PARTY_ID_LIST.DELETE;
3525: H_SCORES.DELETE;
3526: g_mappings.DELETE;
3527: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3528: call_order(5) := call_order(1);
3529: call_type(5) := 'AND';
3530: call_max_score(5) := call_max_score(1);
3531: call_type(2) := 'OR';

Line 4158: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4154: ELSE
4155: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4156: END IF;
4157: END LOOP;
4158: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4160: 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);
4161: END IF;
4162: EXCEPTION