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

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

203: RETURN l_current_score;
204: END IF;
205: FOR J IN 1..g_party_site_stage_list.COUNT LOOP
206: l_current_score := 0;
207: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX3, p_table_TX3,(50000*(J-1)+66)) THEN
208: l_current_score:=l_current_score+ 50;
209: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
210: x_matchidx:=J;
211: RETURN l_current_score;

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

210: x_matchidx:=J;
211: RETURN l_current_score;
212: END IF;
213: ELSIF -- l_current_score<40 AND
214: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX4, p_table_TX4,(50000*(J-1)+67)) THEN
215: l_current_score:=l_current_score+ 40;
216: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
217: x_matchidx:=J;
218: RETURN l_current_score;

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

217: x_matchidx:=J;
218: RETURN l_current_score;
219: END IF;
220: END IF;
221: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX9, p_table_TX9,(50000*(J-1)+72)) THEN
222: l_current_score:=l_current_score+ 20;
223: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
224: x_matchidx:=J;
225: RETURN l_current_score;

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

224: x_matchidx:=J;
225: RETURN l_current_score;
226: END IF;
227: ELSIF -- l_current_score<16 AND
228: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX10, p_table_TX10,(50000*(J-1)+73)) THEN
229: l_current_score:=l_current_score+ 16;
230: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
231: x_matchidx:=J;
232: RETURN l_current_score;

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

231: x_matchidx:=J;
232: RETURN l_current_score;
233: END IF;
234: END IF;
235: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX11, p_table_TX11,(50000*(J-1)+74)) THEN
236: l_current_score:=l_current_score+ 25;
237: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
238: x_matchidx:=J;
239: RETURN l_current_score;

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

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

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

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

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

252: x_matchidx:=J;
253: RETURN l_current_score;
254: END IF;
255: END IF;
256: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX14, p_table_TX14,(50000*(J-1)+77)) THEN
257: l_current_score:=l_current_score+ 15;
258: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
259: x_matchidx:=J;
260: RETURN l_current_score;

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

259: x_matchidx:=J;
260: RETURN l_current_score;
261: END IF;
262: ELSIF -- l_current_score<12 AND
263: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX15, p_table_TX15,(50000*(J-1)+78)) THEN
264: l_current_score:=l_current_score+ 12;
265: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
266: x_matchidx:=J;
267: RETURN l_current_score;

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

266: x_matchidx:=J;
267: RETURN l_current_score;
268: END IF;
269: END IF;
270: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX20, p_table_TX20,(50000*(J-1)+83)) THEN
271: l_current_score:=l_current_score+ 15;
272: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
273: x_matchidx:=J;
274: RETURN l_current_score;

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

273: x_matchidx:=J;
274: RETURN l_current_score;
275: END IF;
276: ELSIF -- l_current_score<12 AND
277: HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX21, p_table_TX21,(50000*(J-1)+84)) THEN
278: l_current_score:=l_current_score+ 12;
279: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
280: x_matchidx:=J;
281: RETURN l_current_score;

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

280: x_matchidx:=J;
281: RETURN l_current_score;
282: END IF;
283: END IF;
284: IF HZ_DQM_SEARCH_UTIL.is_match(g_party_site_stage_list(J).TX22, p_table_TX22,(50000*(J-1)+85)) THEN
285: l_current_score:=l_current_score+ 5;
286: IF g_score_until_thresh AND (l_current_score)>=g_thres_score THEN
287: x_matchidx:=J;
288: RETURN l_current_score;

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

478: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
479: 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);
480: END IF;
481: l_score :=0;
482: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX3, p_table_TX3,(50000*(p_idx-1)+66)) THEN
483: l_score :=50;
484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
485: 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);
486: END IF;

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

484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
485: 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);
486: END IF;
487: ELSIF l_current_score<40 AND
488: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX4, p_table_TX4,(50000*(p_idx-1)+67)) THEN
489: l_score :=40;
490: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
491: 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);
492: END IF;

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

509: 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);
510: END IF;
511: END IF;
512: l_score :=0;
513: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX9, p_table_TX9,(50000*(p_idx-1)+72)) THEN
514: l_score :=20;
515: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
516: 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);
517: END IF;

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

515: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
516: 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);
517: END IF;
518: ELSIF l_current_score<16 AND
519: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX10, p_table_TX10,(50000*(p_idx-1)+73)) THEN
520: l_score :=16;
521: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
522: 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);
523: END IF;

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

540: 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);
541: END IF;
542: END IF;
543: l_score :=0;
544: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
545: l_score :=25;
546: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
547: 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);
548: END IF;

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

565: 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);
566: END IF;
567: END IF;
568: l_score :=0;
569: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX12, p_table_TX12,(50000*(p_idx-1)+75)) THEN
570: l_score :=15;
571: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
572: 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);
573: END IF;

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

571: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
572: 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);
573: END IF;
574: ELSIF l_current_score<12 AND
575: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX13, p_table_TX13,(50000*(p_idx-1)+76)) THEN
576: l_score :=12;
577: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
578: 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);
579: END IF;

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

596: 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);
597: END IF;
598: END IF;
599: l_score :=0;
600: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX14, p_table_TX14,(50000*(p_idx-1)+77)) THEN
601: l_score :=15;
602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
603: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
604: END IF;

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

602: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
603: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
604: END IF;
605: ELSIF l_current_score<12 AND
606: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX15, p_table_TX15,(50000*(p_idx-1)+78)) THEN
607: l_score :=12;
608: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
609: 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);
610: END IF;

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

627: 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);
628: END IF;
629: END IF;
630: l_score :=0;
631: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX20, p_table_TX20,(50000*(p_idx-1)+83)) THEN
632: l_score :=15;
633: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
634: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
635: END IF;

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

633: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
634: hz_utility_v2pub.debug(p_message=>'l_score is - '||l_score,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
635: END IF;
636: ELSIF l_current_score<12 AND
637: HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX21, p_table_TX21,(50000*(p_idx-1)+84)) THEN
638: l_score :=12;
639: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
640: 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);
641: END IF;

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

658: 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);
659: END IF;
660: END IF;
661: l_score :=0;
662: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX22, p_table_TX22,(50000*(p_idx-1)+85)) THEN
663: l_score :=5;
664: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
665: 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);
666: END IF;

Line 874: HZ_DQM_SEARCH_UTIL.set_score;

870: END IF;
871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
872: 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);
873: END IF;
874: HZ_DQM_SEARCH_UTIL.set_score;
875: g_mappings.DELETE;
876: g_party_site_stage_list.DELETE;
877: g_contact_stage_list.DELETE;
878: g_contact_pt_stage_list.DELETE;

Line 881: HZ_DQM_SEARCH_UTIL.new_search;

877: g_contact_stage_list.DELETE;
878: g_contact_pt_stage_list.DELETE;
879: call_order.DELETE;
880: call_max_score.DELETE;
881: HZ_DQM_SEARCH_UTIL.new_search;
882: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
883: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
884:
885: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 883: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

879: call_order.DELETE;
880: call_max_score.DELETE;
881: HZ_DQM_SEARCH_UTIL.new_search;
882: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
883: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
884:
885: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
886: 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);
887: END IF;

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

1113:
1114: -- Setup query string for ADDRESS
1115: l_prim_temp := null;
1116: l_prim_temp_den := null;
1117: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1118: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1119: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1120:
1121: -- Setup query string for CITY

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

1115: l_prim_temp := null;
1116: l_prim_temp_den := null;
1117: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE SPECIAL + WRADDRESS
1118: g_party_site_stage_list(I).TX4,'A27',l_prim_temp);
1119: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1120:
1121: -- Setup query string for CITY
1122: l_prim_temp := null;
1123: l_prim_temp_den := null;

Line 1124: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1120:
1121: -- Setup query string for CITY
1122: l_prim_temp := null;
1123: l_prim_temp_den := null;
1124: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1125: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1126: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1127: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1128: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1126: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1122: l_prim_temp := null;
1123: l_prim_temp_den := null;
1124: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1125: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1126: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1127: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1128: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1129: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1130:

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

1124: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1125: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1126: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1127: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1128: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1129: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1130:
1131: -- Setup query string for POSTAL_CODE
1132: l_prim_temp := null;

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

1125: g_party_site_stage_list(I).TX10,'A29',l_prim_temp);
1126: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1127: g_party_site_stage_list(I).TX10,'D_PS',l_prim_temp_den);
1128: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1129: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1130:
1131: -- Setup query string for POSTAL_CODE
1132: l_prim_temp := null;
1133: l_prim_temp_den := null;

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

1130:
1131: -- Setup query string for POSTAL_CODE
1132: l_prim_temp := null;
1133: l_prim_temp_den := null;
1134: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1135: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1136: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1137: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1138: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1132: l_prim_temp := null;
1133: l_prim_temp_den := null;
1134: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1135: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1136: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1137: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1138: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1139: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1140:

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

1134: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1135: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1136: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1137: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1138: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1139: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1140:
1141: -- Setup query string for PROVINCE
1142: l_prim_temp := null;

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

1135: g_party_site_stage_list(I).TX11,'A30',l_prim_temp);
1136: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT SPECIAL NOSPC
1137: g_party_site_stage_list(I).TX11,'D_PS',l_prim_temp_den);
1138: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1139: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1140:
1141: -- Setup query string for PROVINCE
1142: l_prim_temp := null;
1143: l_prim_temp_den := null;

Line 1144: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1140:
1141: -- Setup query string for PROVINCE
1142: l_prim_temp := null;
1143: l_prim_temp_den := null;
1144: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1145: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1146: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1147: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1148: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1146: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1142: l_prim_temp := null;
1143: l_prim_temp_den := null;
1144: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1145: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1146: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1147: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1148: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1149: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1150:

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

1144: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1145: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1146: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1147: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1148: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1149: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1150:
1151: -- Setup query string for STATE
1152: l_prim_temp := null;

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

1145: g_party_site_stage_list(I).TX13,'A31',l_prim_temp);
1146: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1147: g_party_site_stage_list(I).TX13,'D_PS',l_prim_temp_den);
1148: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1149: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1150:
1151: -- Setup query string for STATE
1152: l_prim_temp := null;
1153: l_prim_temp_den := null;

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

1150:
1151: -- Setup query string for STATE
1152: l_prim_temp := null;
1153: l_prim_temp_den := null;
1154: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1155: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1157: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1158: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

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

1152: l_prim_temp := null;
1153: l_prim_temp_den := null;
1154: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1155: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1157: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1158: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1159: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1160:

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

1154: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1155: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1157: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1158: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1159: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1160:
1161: -- Setup query string for COUNTY
1162: l_prim_temp := null;

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

1155: g_party_site_stage_list(I).TX15,'A32',l_prim_temp);
1156: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE + WRSTATE
1157: g_party_site_stage_list(I).TX15,'D_PS',l_prim_temp_den);
1158: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1159: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1160:
1161: -- Setup query string for COUNTY
1162: l_prim_temp := null;
1163: l_prim_temp_den := null;

Line 1164: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1160:
1161: -- Setup query string for COUNTY
1162: l_prim_temp := null;
1163: l_prim_temp_den := null;
1164: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1165: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
1166: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1167: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1166: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE

1162: l_prim_temp := null;
1163: l_prim_temp_den := null;
1164: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1165: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
1166: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1167: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1169: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1170:

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

1164: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1165: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
1166: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1167: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1169: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1170:
1171: -- Setup query string for COUNTRY
1172: l_prim_temp := null;

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

1165: g_party_site_stage_list(I).TX21,'A35',l_prim_temp);
1166: HZ_DQM_SEARCH_UTIL.add_transformation( -- CLEANSE
1167: g_party_site_stage_list(I).TX21,'D_PS',l_prim_temp_den);
1168: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1169: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1170:
1171: -- Setup query string for COUNTRY
1172: l_prim_temp := null;
1173: l_prim_temp_den := null;

Line 1174: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1170:
1171: -- Setup query string for COUNTRY
1172: l_prim_temp := null;
1173: l_prim_temp_den := null;
1174: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1175: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1176: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1177: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1178: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);

Line 1176: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT

1172: l_prim_temp := null;
1173: l_prim_temp_den := null;
1174: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1175: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1176: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1177: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1178: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1179: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1180:

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

1174: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1175: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1176: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1177: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1178: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1179: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1180:
1181: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1182: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);

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

1175: g_party_site_stage_list(I).TX22,'A36',l_prim_temp);
1176: HZ_DQM_SEARCH_UTIL.add_transformation( -- EXACT
1177: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1178: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1179: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1180:
1181: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1182: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1183: END LOOP;

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

1177: g_party_site_stage_list(I).TX22,'D_PS',l_prim_temp_den);
1178: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1179: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1180:
1181: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1182: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1183: END LOOP;
1184: -- Add the search criteria to query string
1185: IF lengthb(l_contains_str) > 4000 THEN

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

1178: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp_den, ' AND ', l_den_contains_str_temp);
1179: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, ' AND ', l_contains_str_temp);
1180:
1181: HZ_DQM_SEARCH_UTIL.add_search_record(l_contains_str_temp, l_filter_str, l_contains_str);
1182: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1183: END LOOP;
1184: -- Add the search criteria to query string
1185: IF lengthb(l_contains_str) > 4000 THEN
1186: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

Line 2340: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

2336: H_PARTY_ID.DELETE;
2337: H_PARTY_ID_LIST.DELETE;
2338: H_SCORES.DELETE;
2339: g_mappings.DELETE;
2340: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
2341: call_order(5) := call_order(1);
2342: call_type(5) := 'AND';
2343: call_max_score(5) := call_max_score(1);
2344: call_type(2) := 'OR';

Line 3131: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3127: ELSE
3128: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3129: END IF;
3130: END LOOP;
3131: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3132: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3133: 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);
3134: END IF;
3135: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3293: HZ_DQM_SEARCH_UTIL.set_num_eval(0);

3289: H_PARTY_ID.DELETE;
3290: H_PARTY_ID_LIST.DELETE;
3291: H_SCORES.DELETE;
3292: g_mappings.DELETE;
3293: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
3294: call_order(5) := call_order(1);
3295: call_type(5) := 'AND';
3296: call_max_score(5) := call_max_score(1);
3297: call_type(2) := 'OR';

Line 3924: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);

3920: ELSE
3921: l_party_id:=H_PARTY_ID_LIST.NEXT(l_party_id);
3922: END IF;
3923: END LOOP;
3924: HZ_DQM_SEARCH_UTIL.set_num_eval(l_num_eval);
3925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3926: 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);
3927: END IF;
3928: EXCEPTION