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

Line 193: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX8, p_table_TX8,12) THEN

189: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
190: END IF;
191: RETURN total;
192: END IF;
193: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX8, p_table_TX8,12) THEN
194: total := total+50;
195: IF g_score_until_thresh AND (total)>=g_thres_score THEN
196: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
197: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

198: END IF;
199: RETURN total;
200: END IF;
201: END IF;
202: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX32, p_table_TX32,36) THEN
203: total := total+50;
204: IF g_score_until_thresh AND (total)>=g_thres_score THEN
205: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
206: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

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

207: END IF;
208: RETURN total;
209: END IF;
210: END IF;
211: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX35, p_table_TX35,39) THEN
212: total := total+100;
213: IF g_score_until_thresh AND (total)>=g_thres_score THEN
214: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
215: 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 220: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX42, p_table_TX42,46) THEN

216: END IF;
217: RETURN total;
218: END IF;
219: END IF;
220: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX42, p_table_TX42,46) THEN
221: total := total+30;
222: IF g_score_until_thresh AND (total)>=g_thres_score THEN
223: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
224: 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 229: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN

225: END IF;
226: RETURN total;
227: END IF;
228: END IF;
229: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX44, p_table_TX44,49) THEN
230: total := total+80;
231: IF g_score_until_thresh AND (total)>=g_thres_score THEN
232: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
233: 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 238: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN

234: END IF;
235: RETURN total;
236: END IF;
237: END IF;
238: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX45, p_table_TX45,50) THEN
239: total := total+100;
240: IF g_score_until_thresh AND (total)>=g_thres_score THEN
241: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
242: 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 247: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN

243: END IF;
244: RETURN total;
245: END IF;
246: END IF;
247: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX46, p_table_TX46,51) THEN
248: total := total+30;
249: IF g_score_until_thresh AND (total)>=g_thres_score THEN
250: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
251: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 256: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX47, p_table_TX47,52) THEN

252: END IF;
253: RETURN total;
254: END IF;
255: END IF;
256: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX47, p_table_TX47,52) THEN
257: total := total+10;
258: IF g_score_until_thresh AND (total)>=g_thres_score THEN
259: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
260: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 265: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX48, p_table_TX48,53) THEN

261: END IF;
262: RETURN total;
263: END IF;
264: END IF;
265: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX48, p_table_TX48,53) THEN
266: total := total+10;
267: IF g_score_until_thresh AND (total)>=g_thres_score THEN
268: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
269: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 274: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX156, p_table_TX156,121) THEN

270: END IF;
271: RETURN total;
272: END IF;
273: END IF;
274: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX156, p_table_TX156,121) THEN
275: total := total+20;
276: IF g_score_until_thresh AND (total)>=g_thres_score THEN
277: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
278: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 283: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX157, p_table_TX157,122) THEN

279: END IF;
280: RETURN total;
281: END IF;
282: END IF;
283: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_stage_rec.TX157, p_table_TX157,122) THEN
284: total := total+30;
285: IF g_score_until_thresh AND (total)>=g_thres_score THEN
286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
287: hz_utility_v2pub.debug(p_message=>'get_party_score returned total = '||total,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 314: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN

310: RETURN l_current_score;
311: END IF;
312: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
313: l_current_score := 0;
314: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
315: l_current_score:=l_current_score+ 60;
316: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
317: x_matchidx:=J;
318: RETURN l_current_score;

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

317: x_matchidx:=J;
318: RETURN l_current_score;
319: END IF;
320: ELSIF -- l_current_score<48 AND
321: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
322: l_current_score:=l_current_score+ 48;
323: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
324: x_matchidx:=J;
325: RETURN l_current_score;

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

324: x_matchidx:=J;
325: RETURN l_current_score;
326: END IF;
327: END IF;
328: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
329: l_current_score:=l_current_score+ 30;
330: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
331: x_matchidx:=J;
332: RETURN l_current_score;

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

331: x_matchidx:=J;
332: RETURN l_current_score;
333: END IF;
334: END IF;
335: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
336: l_current_score:=l_current_score+ 30;
337: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
338: x_matchidx:=J;
339: RETURN l_current_score;

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

338: x_matchidx:=J;
339: RETURN l_current_score;
340: END IF;
341: END IF;
342: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX12, p_table_TX12,(50000*(J-1)+75)) THEN
343: l_current_score:=l_current_score+ 10;
344: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
345: x_matchidx:=J;
346: RETURN l_current_score;

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

345: x_matchidx:=J;
346: RETURN l_current_score;
347: END IF;
348: END IF;
349: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
350: l_current_score:=l_current_score+ 20;
351: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
352: x_matchidx:=J;
353: RETURN l_current_score;

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

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

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

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

Line 391: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+89)) THEN

387: RETURN l_current_score;
388: END IF;
389: FOR J IN 1..g_contact_stage_list.COUNT LOOP
390: l_current_score := 0;
391: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX2, p_table_TX2,(50000*(J-1)+89)) THEN
392: l_current_score:=l_current_score+ 30;
393: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
394: x_matchidx:=J;
395: RETURN l_current_score;

Line 398: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+92)) THEN

394: x_matchidx:=J;
395: RETURN l_current_score;
396: END IF;
397: ELSIF -- l_current_score<27 AND
398: HZ_DQM_SEARCH_UTIL.is_match(g_contact_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+92)) THEN
399: l_current_score:=l_current_score+ 27;
400: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
401: x_matchidx:=J;
402: RETURN l_current_score;

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

422: RETURN l_current_score;
423: END IF;
424: FOR J IN 1..g_contact_pt_stage_list.COUNT LOOP
425: l_current_score := 0;
426: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX1, p_table_TX1,(50000*(J-1)+110)) THEN
427: l_current_score:=l_current_score+ 70;
428: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
429: x_matchidx:=J;
430: RETURN l_current_score;

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

429: x_matchidx:=J;
430: RETURN l_current_score;
431: END IF;
432: END IF;
433: IF HZ_DQM_SEARCH_UTIL.is_match(g_contact_pt_stage_list(J).TX5, p_table_TX5,(50000*(J-1)+114)) THEN
434: l_current_score:=l_current_score+ 70;
435: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
436: x_matchidx:=J;
437: RETURN l_current_score;

Line 776: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN

772: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
773: 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);
774: END IF;
775: l_score :=0;
776: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX8, p_table_TX8,(50000*(p_idx-1)+12)) THEN
777: l_score :=50;
778: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
779: 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);
780: END IF;

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

797: 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);
798: END IF;
799: END IF;
800: l_score :=0;
801: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX32, p_table_TX32,(50000*(p_idx-1)+36)) THEN
802: l_score :=50;
803: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
804: 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);
805: END IF;

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

822: 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);
823: END IF;
824: END IF;
825: l_score :=0;
826: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX35, p_table_TX35,(50000*(p_idx-1)+39)) THEN
827: l_score :=100;
828: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
829: 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);
830: END IF;

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

847: 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);
848: END IF;
849: END IF;
850: l_score :=0;
851: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX42, p_table_TX42,(50000*(p_idx-1)+46)) THEN
852: l_score :=30;
853: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
854: 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);
855: END IF;

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

872: 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);
873: END IF;
874: END IF;
875: l_score :=0;
876: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
877: l_score :=80;
878: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
879: 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);
880: END IF;

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

897: 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);
898: END IF;
899: END IF;
900: l_score :=0;
901: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX45, p_table_TX45,(50000*(p_idx-1)+50)) THEN
902: l_score :=100;
903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
904: 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);
905: END IF;

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

922: 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);
923: END IF;
924: END IF;
925: l_score :=0;
926: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX46, p_table_TX46,(50000*(p_idx-1)+51)) THEN
927: l_score :=30;
928: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
929: 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);
930: END IF;

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

947: 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);
948: END IF;
949: END IF;
950: l_score :=0;
951: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX47, p_table_TX47,(50000*(p_idx-1)+52)) THEN
952: l_score :=10;
953: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
954: 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);
955: END IF;

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

972: 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);
973: END IF;
974: END IF;
975: l_score :=0;
976: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX48, p_table_TX48,(50000*(p_idx-1)+53)) THEN
977: l_score :=10;
978: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
979: 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);
980: END IF;

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

997: 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);
998: END IF;
999: END IF;
1000: l_score :=0;
1001: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX156, p_table_TX156,(50000*(p_idx-1)+121)) THEN
1002: l_score :=20;
1003: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1004: 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);
1005: END IF;

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

1022: 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);
1023: END IF;
1024: END IF;
1025: l_score :=0;
1026: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX157, p_table_TX157,(50000*(p_idx-1)+122)) THEN
1027: l_score :=30;
1028: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1029: 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);
1030: END IF;

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

1071: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1072: 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);
1073: END IF;
1074: l_score :=0;
1075: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
1076: l_score :=60;
1077: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1078: 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);
1079: END IF;

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

1077: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1078: 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);
1079: END IF;
1080: ELSIF l_current_score<48 AND
1081: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
1082: l_score :=48;
1083: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1084: 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);
1085: END IF;

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

1102: 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);
1103: END IF;
1104: END IF;
1105: l_score :=0;
1106: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
1107: l_score :=30;
1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1109: 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);
1110: END IF;

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

1127: 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);
1128: END IF;
1129: END IF;
1130: l_score :=0;
1131: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
1132: l_score :=30;
1133: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1134: 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);
1135: END IF;

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

1152: 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);
1153: END IF;
1154: END IF;
1155: l_score :=0;
1156: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX12, p_table_TX12,(50000*(p_idx-1)+75)) THEN
1157: l_score :=10;
1158: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1159: 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);
1160: END IF;

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

1177: 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);
1178: END IF;
1179: END IF;
1180: l_score :=0;
1181: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
1182: l_score :=20;
1183: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1184: 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);
1185: END IF;

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

1202: 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);
1203: END IF;
1204: END IF;
1205: l_score :=0;
1206: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX20, p_table_TX20,(50000*(p_idx-1)+83)) THEN
1207: l_score :=20;
1208: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1209: 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);
1210: END IF;

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

1227: 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);
1228: END IF;
1229: END IF;
1230: l_score :=0;
1231: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
1232: l_score :=30;
1233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1234: 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);
1235: END IF;

Line 1274: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN

1270: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1271: 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);
1272: END IF;
1273: l_score :=0;
1274: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+89)) THEN
1275: l_score :=30;
1276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1277: 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);
1278: END IF;

Line 1280: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+92)) THEN

1276: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1277: 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);
1278: END IF;
1279: ELSIF l_current_score<27 AND
1280: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+92)) THEN
1281: l_score :=27;
1282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1283: 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);
1284: END IF;

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

1319: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1320: 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);
1321: END IF;
1322: l_score :=0;
1323: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX1, p_table_TX1,(50000*(p_idx-1)+110)) THEN
1324: l_score :=70;
1325: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1326: 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);
1327: END IF;

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

1344: 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);
1345: END IF;
1346: END IF;
1347: l_score :=0;
1348: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
1349: l_score :=70;
1350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1351: 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);
1352: END IF;

Line 1528: HZ_DQM_SEARCH_UTIL.set_score;

1524: END IF;
1525: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1526: 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);
1527: END IF;
1528: HZ_DQM_SEARCH_UTIL.set_score;
1529: g_mappings.DELETE;
1530: g_party_site_stage_list.DELETE;
1531: g_contact_stage_list.DELETE;
1532: g_contact_pt_stage_list.DELETE;

Line 1535: HZ_DQM_SEARCH_UTIL.new_search;

1531: g_contact_stage_list.DELETE;
1532: g_contact_pt_stage_list.DELETE;
1533: call_order.DELETE;
1534: call_max_score.DELETE;
1535: HZ_DQM_SEARCH_UTIL.new_search;
1536: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1537: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1538:
1539: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1537: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

1533: call_order.DELETE;
1534: call_max_score.DELETE;
1535: HZ_DQM_SEARCH_UTIL.new_search;
1536: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1537: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1538:
1539: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1540: 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);
1541: END IF;

Line 1723: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1719: END IF;
1720:
1721: -- Setup query string for SIC_CODE_TYPE
1722: l_prim_temp := null;
1723: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1724: g_party_stage_rec.TX47,'A21',l_prim_temp);
1725:
1726: IF l_denorm_str IS NOT NULL THEN
1727: IF (p_non_denorm_max_score+10)>=p_threshold THEN

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

1725:
1726: IF l_denorm_str IS NOT NULL THEN
1727: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1728: l_denorm_str := NULL;
1729: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1730: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1731: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1732: l_denorm_str := NULL;
1733: END IF;

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

1727: IF (p_non_denorm_max_score+10)>=p_threshold THEN
1728: l_denorm_str := NULL;
1729: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1730: ELSIF (p_non_denorm_max_score+p_denorm_max_score+10)>=p_threshold THEN
1731: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1732: l_denorm_str := NULL;
1733: END IF;
1734: ELSE
1735: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);

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

1731: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1732: l_denorm_str := NULL;
1733: END IF;
1734: ELSE
1735: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1736: END IF;
1737:
1738: -- Setup query string for CATEGORY_CODE
1739: l_prim_temp := null;

Line 1740: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

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

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

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

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

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

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

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

Line 1757: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

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

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

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

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

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

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

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

Line 1774: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

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

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

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

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

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

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

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

Line 1791: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

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

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

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

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

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

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

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

Line 1808: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

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

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

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

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

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

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

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

Line 1825: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRNAMES

1821: END IF;
1822:
1823: -- Setup query string for ALL_ACCOUNT_NAMES
1824: l_prim_temp := null;
1825: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRNAMES
1826: g_party_stage_rec.TX32,'A11',l_prim_temp);
1827:
1828: IF l_denorm_str IS NOT NULL THEN
1829: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

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

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

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

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

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

Line 1842: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRNAMES

1838: END IF;
1839:
1840: -- Setup query string for PARTY_NAME
1841: l_prim_temp := null;
1842: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRNAMES
1843: g_party_stage_rec.TX8,'A8',l_prim_temp);
1844:
1845: IF l_denorm_str IS NOT NULL THEN
1846: IF (p_non_denorm_max_score+50)>=p_threshold THEN

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

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

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

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

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

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

Line 1859: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1855: END IF;
1856:
1857: -- Setup query string for TAX_REFERENCE
1858: l_prim_temp := null;
1859: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1860: g_party_stage_rec.TX44,'A18',l_prim_temp);
1861:
1862: IF l_denorm_str IS NOT NULL THEN
1863: IF (p_non_denorm_max_score+80)>=p_threshold THEN

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

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

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

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

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

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

Line 1876: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1872: END IF;
1873:
1874: -- Setup query string for ALL_ACCOUNT_NUMBERS
1875: l_prim_temp := null;
1876: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1877: g_party_stage_rec.TX35,'A13',l_prim_temp);
1878:
1879: IF l_denorm_str IS NOT NULL THEN
1880: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

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

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

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

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

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

Line 1893: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL

1889: END IF;
1890:
1891: -- Setup query string for JGZZ_FISCAL_CODE
1892: l_prim_temp := null;
1893: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL
1894: g_party_stage_rec.TX45,'A19',l_prim_temp);
1895:
1896: IF l_denorm_str IS NOT NULL THEN
1897: IF (p_non_denorm_max_score+100)>=p_threshold THEN

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

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

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

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

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

1901: HZ_DQM_SEARCH_UTIL.add_attribute_with_denorm(l_prim_temp, p_match_str, l_denorm_str, l_party_contains_str);
1902: l_denorm_str := NULL;
1903: END IF;
1904: ELSE
1905: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1906: END IF;
1907: IF lengthb(l_party_contains_str) > 4000 THEN
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1909: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

Line 1958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRADDRESS

1954:
1955: -- Setup query string for ADDRESS
1956: l_prim_temp := null;
1957: l_prim_temp_den := null;
1958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRADDRESS
1959: g_party_site_stage_list(I).TX3,'A27',l_prim_temp);
1960: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1961:
1962: -- Setup query string for CITY

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

1956: l_prim_temp := null;
1957: l_prim_temp_den := null;
1958: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRADDRESS
1959: g_party_site_stage_list(I).TX3,'A27',l_prim_temp);
1960: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1961:
1962: -- Setup query string for CITY
1963: l_prim_temp := null;
1964: l_prim_temp_den := null;

Line 1965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1961:
1962: -- Setup query string for CITY
1963: l_prim_temp := null;
1964: l_prim_temp_den := null;
1965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1966: g_party_site_stage_list(I).TX9,'A29',l_prim_temp);
1967: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1968: g_party_site_stage_list(I).TX9,'D_PS',l_prim_temp_den);
1969: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1967: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1963: l_prim_temp := null;
1964: l_prim_temp_den := null;
1965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1966: g_party_site_stage_list(I).TX9,'A29',l_prim_temp);
1967: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1968: g_party_site_stage_list(I).TX9,'D_PS',l_prim_temp_den);
1969: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1970: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1971:

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

1965: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1966: g_party_site_stage_list(I).TX9,'A29',l_prim_temp);
1967: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1968: g_party_site_stage_list(I).TX9,'D_PS',l_prim_temp_den);
1969: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1970: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1971:
1972: -- Setup query string for POSTAL_CODE
1973: l_prim_temp := null;

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

1966: g_party_site_stage_list(I).TX9,'A29',l_prim_temp);
1967: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1968: g_party_site_stage_list(I).TX9,'D_PS',l_prim_temp_den);
1969: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1970: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1971:
1972: -- Setup query string for POSTAL_CODE
1973: l_prim_temp := null;
1974: l_prim_temp_den := null;

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

1971:
1972: -- Setup query string for POSTAL_CODE
1973: l_prim_temp := null;
1974: l_prim_temp_den := null;
1975: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1976: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1977: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1978: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1979: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1973: l_prim_temp := null;
1974: l_prim_temp_den := null;
1975: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1976: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1977: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1978: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1979: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1980: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1981:

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

1975: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1976: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1977: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1978: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1979: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1980: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1981:
1982: -- Setup query string for PROVINCE
1983: l_prim_temp := null;

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

1976: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1977: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1978: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1979: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1980: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1981:
1982: -- Setup query string for PROVINCE
1983: l_prim_temp := null;
1984: l_prim_temp_den := null;

Line 1985: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1981:
1982: -- Setup query string for PROVINCE
1983: l_prim_temp := null;
1984: l_prim_temp_den := null;
1985: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1986: g_party_site_stage_list(I).TX12,'A31',l_prim_temp);
1987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1988: g_party_site_stage_list(I).TX12,'D_PS',l_prim_temp_den);
1989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1983: l_prim_temp := null;
1984: l_prim_temp_den := null;
1985: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1986: g_party_site_stage_list(I).TX12,'A31',l_prim_temp);
1987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1988: g_party_site_stage_list(I).TX12,'D_PS',l_prim_temp_den);
1989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1990: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1991:

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

1985: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1986: g_party_site_stage_list(I).TX12,'A31',l_prim_temp);
1987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1988: g_party_site_stage_list(I).TX12,'D_PS',l_prim_temp_den);
1989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1990: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1991:
1992: -- Setup query string for STATE
1993: l_prim_temp := null;

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

1986: g_party_site_stage_list(I).TX12,'A31',l_prim_temp);
1987: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1988: g_party_site_stage_list(I).TX12,'D_PS',l_prim_temp_den);
1989: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1990: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1991:
1992: -- Setup query string for STATE
1993: l_prim_temp := null;
1994: l_prim_temp_den := null;

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

1991:
1992: -- Setup query string for STATE
1993: l_prim_temp := null;
1994: l_prim_temp_den := null;
1995: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1996: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1997: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1998: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1999: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1993: l_prim_temp := null;
1994: l_prim_temp_den := null;
1995: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1996: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1997: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1998: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1999: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2000: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2001:

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

1995: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1996: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1997: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1998: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1999: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2000: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2001:
2002: -- Setup query string for COUNTY
2003: l_prim_temp := null;

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

1996: g_party_site_stage_list(I).TX14,'A32',l_prim_temp);
1997: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT + WRSTATE
1998: g_party_site_stage_list(I).TX14,'D_PS',l_prim_temp_den);
1999: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2000: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2001:
2002: -- Setup query string for COUNTY
2003: l_prim_temp := null;
2004: l_prim_temp_den := null;

Line 2005: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

2001:
2002: -- Setup query string for COUNTY
2003: l_prim_temp := null;
2004: l_prim_temp_den := null;
2005: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2006: g_party_site_stage_list(I).TX20,'A35',l_prim_temp);
2007: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2008: g_party_site_stage_list(I).TX20,'D_PS',l_prim_temp_den);
2009: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 2007: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

2003: l_prim_temp := null;
2004: l_prim_temp_den := null;
2005: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2006: g_party_site_stage_list(I).TX20,'A35',l_prim_temp);
2007: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2008: g_party_site_stage_list(I).TX20,'D_PS',l_prim_temp_den);
2009: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2010: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2011:

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

2005: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2006: g_party_site_stage_list(I).TX20,'A35',l_prim_temp);
2007: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2008: g_party_site_stage_list(I).TX20,'D_PS',l_prim_temp_den);
2009: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2010: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2011:
2012: -- Setup query string for COUNTRY
2013: l_prim_temp := null;

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

2006: g_party_site_stage_list(I).TX20,'A35',l_prim_temp);
2007: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2008: g_party_site_stage_list(I).TX20,'D_PS',l_prim_temp_den);
2009: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2010: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2011:
2012: -- Setup query string for COUNTRY
2013: l_prim_temp := null;
2014: l_prim_temp_den := null;

Line 2015: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

2011:
2012: -- Setup query string for COUNTRY
2013: l_prim_temp := null;
2014: l_prim_temp_den := null;
2015: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2016: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
2017: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2018: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2019: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 2017: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

2013: l_prim_temp := null;
2014: l_prim_temp_den := null;
2015: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2016: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
2017: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2018: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2019: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2020: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2021:

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

2015: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2016: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
2017: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2018: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2019: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2020: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2021:
2022: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2023: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

2016: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
2017: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
2018: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2019: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2020: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2021:
2022: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2023: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2024: END LOOP;

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

2018: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
2019: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2020: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2021:
2022: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2023: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2024: END LOOP;
2025: -- Add the search criteria to query string
2026: IF lengthb(l_contains_str) > 4000 THEN

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

2019: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
2020: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2021:
2022: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2023: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2024: END LOOP;
2025: -- Add the search criteria to query string
2026: IF lengthb(l_contains_str) > 4000 THEN
2027: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2062: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRPERSON

2058:
2059: -- Setup query string for CONTACT_NAME
2060: l_prim_temp := null;
2061: l_prim_temp_den := null;
2062: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRPERSON
2063: g_contact_stage_list(I).TX5,'A39',l_prim_temp);
2064: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2065:
2066: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

2060: l_prim_temp := null;
2061: l_prim_temp_den := null;
2062: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRPERSON
2063: g_contact_stage_list(I).TX5,'A39',l_prim_temp);
2064: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2065:
2066: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2067: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2068: END LOOP;

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

2062: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL + WRPERSON
2063: g_contact_stage_list(I).TX5,'A39',l_prim_temp);
2064: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2065:
2066: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2067: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2068: END LOOP;
2069: -- Add the search criteria to query string
2070: IF lengthb(l_contains_str) > 4000 THEN

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

2063: g_contact_stage_list(I).TX5,'A39',l_prim_temp);
2064: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2065:
2066: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2067: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2068: END LOOP;
2069: -- Add the search criteria to query string
2070: IF lengthb(l_contains_str) > 4000 THEN
2071: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

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

2124:
2125: -- Setup query string for FLEX_FORMAT_PHONE_NUMBER
2126: l_prim_temp := null;
2127: l_prim_temp_den := null;
2128: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
2129: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
2130: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2131:
2132: -- Setup query string for EMAIL_ADDRESS

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

2126: l_prim_temp := null;
2127: l_prim_temp_den := null;
2128: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL CTX
2129: g_contact_pt_stage_list(I).TX1,'A44',l_prim_temp);
2130: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2131:
2132: -- Setup query string for EMAIL_ADDRESS
2133: l_prim_temp := null;
2134: l_prim_temp_den := null;

Line 2135: HZ_DQM_SEARCH_UTIL.add_transformation( -- FORCE UPPERCASE ONLY

2131:
2132: -- Setup query string for EMAIL_ADDRESS
2133: l_prim_temp := null;
2134: l_prim_temp_den := null;
2135: HZ_DQM_SEARCH_UTIL.add_transformation( -- FORCE UPPERCASE ONLY
2136: g_contact_pt_stage_list(I).TX5,'A48',l_prim_temp);
2137: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2138:
2139: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);

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

2133: l_prim_temp := null;
2134: l_prim_temp_den := null;
2135: HZ_DQM_SEARCH_UTIL.add_transformation( -- FORCE UPPERCASE ONLY
2136: g_contact_pt_stage_list(I).TX5,'A48',l_prim_temp);
2137: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2138:
2139: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2140: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2141: IF N>1 THEN

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

2135: HZ_DQM_SEARCH_UTIL.add_transformation( -- FORCE UPPERCASE ONLY
2136: g_contact_pt_stage_list(I).TX5,'A48',l_prim_temp);
2137: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2138:
2139: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2140: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2141: IF N>1 THEN
2142: distinct_search_cpt_types := N-1;
2143: ELSE

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

2136: g_contact_pt_stage_list(I).TX5,'A48',l_prim_temp);
2137: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
2138:
2139: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
2140: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
2141: IF N>1 THEN
2142: distinct_search_cpt_types := N-1;
2143: ELSE
2144: distinct_search_cpt_types := N;

Line 3361: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3357: H_PARTY_ID.DELETE;
3358: H_PARTY_ID_LIST.DELETE;
3359: H_SCORES.DELETE;
3360: g_mappings.DELETE;
3361: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3362: call_order(5) := call_order(1);
3363: call_type(5) := 'AND';
3364: call_max_score(5) := call_max_score(1);
3365: call_type(2) := 'OR';

Line 4192: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

4188: ELSE
4189: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
4190: END IF;
4191: END LOOP;
4192: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
4193: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4194: 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);
4195: END IF;
4196: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4364: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

4360: H_PARTY_ID.DELETE;
4361: H_PARTY_ID_LIST.DELETE;
4362: H_SCORES.DELETE;
4363: g_mappings.DELETE;
4364: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
4365: call_order(5) := call_order(1);
4366: call_type(5) := 'AND';
4367: call_max_score(5) := call_max_score(1);
4368: call_type(2) := 'OR';

Line 5066: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

5062: ELSE
5063: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
5064: END IF;
5065: END LOOP;
5066: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
5067: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5068: 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);
5069: END IF;
5070: EXCEPTION