457: hz_utility_v2pub.debug(p_message=>'l_score > 0',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
458: END IF;
459: l_attrib_value := get_attrib_val(p_record_id,'PARTY','PARTY_NAME');
460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
461: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
462: END IF;
463: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
464: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
465: VALUES (
459: l_attrib_value := get_attrib_val(p_record_id,'PARTY','PARTY_NAME');
460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
461: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
462: END IF;
463: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
464: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
465: VALUES (
466: p_party_id,p_record_id,p_search_ctx_id,'PARTY_NAME',
467: 'PARTY', p_search_rec.PARTY_NAME,
466: p_party_id,p_record_id,p_search_ctx_id,'PARTY_NAME',
467: 'PARTY', p_search_rec.PARTY_NAME,
468: l_attrib_value,l_score);
469: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
470: 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);
471: END IF;
472: END IF;
473: l_score :=0;
474: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
482: hz_utility_v2pub.debug(p_message=>'l_score > 0',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
483: END IF;
484: l_attrib_value := get_attrib_val(p_record_id,'PARTY','TAX_REFERENCE');
485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
486: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
487: END IF;
488: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
489: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
490: VALUES (
484: l_attrib_value := get_attrib_val(p_record_id,'PARTY','TAX_REFERENCE');
485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
486: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
487: END IF;
488: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
489: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
490: VALUES (
491: p_party_id,p_record_id,p_search_ctx_id,'TAX_REFERENCE',
492: 'PARTY', p_search_rec.TAX_REFERENCE,
491: p_party_id,p_record_id,p_search_ctx_id,'TAX_REFERENCE',
492: 'PARTY', p_search_rec.TAX_REFERENCE,
493: l_attrib_value,l_score);
494: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
495: 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);
496: END IF;
497: END IF;
498: NULL;
499: END;
532: hz_utility_v2pub.debug(p_message=>'l_score > 0',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
533: END IF;
534: l_attrib_value := get_attrib_val(p_record_id,'PARTY_SITES','ADDRESS');
535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
536: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
537: END IF;
538: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
539: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
540: VALUES (
534: l_attrib_value := get_attrib_val(p_record_id,'PARTY_SITES','ADDRESS');
535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
536: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
537: END IF;
538: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
539: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
540: VALUES (
541: p_party_id,p_record_id,p_search_ctx_id,'ADDRESS',
542: 'PARTY_SITES', p_search_rec.ADDRESS,
541: p_party_id,p_record_id,p_search_ctx_id,'ADDRESS',
542: 'PARTY_SITES', p_search_rec.ADDRESS,
543: l_attrib_value,l_score);
544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
545: 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);
546: END IF;
547: END IF;
548: l_score :=0;
549: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX11, p_table_TX11,(50000*(p_idx-1)+74)) THEN
557: hz_utility_v2pub.debug(p_message=>'l_score > 0',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
558: END IF;
559: l_attrib_value := get_attrib_val(p_record_id,'PARTY_SITES','POSTAL_CODE');
560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
561: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
562: END IF;
563: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
564: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
565: VALUES (
559: l_attrib_value := get_attrib_val(p_record_id,'PARTY_SITES','POSTAL_CODE');
560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
561: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
562: END IF;
563: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
564: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
565: VALUES (
566: p_party_id,p_record_id,p_search_ctx_id,'POSTAL_CODE',
567: 'PARTY_SITES', p_search_rec.POSTAL_CODE,
566: p_party_id,p_record_id,p_search_ctx_id,'POSTAL_CODE',
567: 'PARTY_SITES', p_search_rec.POSTAL_CODE,
568: l_attrib_value,l_score);
569: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
570: 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);
571: END IF;
572: END IF;
573: NULL;
574: END;
617: hz_utility_v2pub.debug(p_message=>'l_score > 0',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
618: END IF;
619: l_attrib_value := get_attrib_val(p_record_id,'CONTACT_POINTS','FLEX_FORMAT_PHONE_NUMBER');
620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
622: END IF;
623: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
624: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
625: VALUES (
619: l_attrib_value := get_attrib_val(p_record_id,'CONTACT_POINTS','FLEX_FORMAT_PHONE_NUMBER');
620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
622: END IF;
623: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
624: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
625: VALUES (
626: p_party_id,p_record_id,p_search_ctx_id,'FLEX_FORMAT_PHONE_NUMBER',
627: 'CONTACT_POINTS', p_search_rec.FLEX_FORMAT_PHONE_NUMBER,
626: p_party_id,p_record_id,p_search_ctx_id,'FLEX_FORMAT_PHONE_NUMBER',
627: 'CONTACT_POINTS', p_search_rec.FLEX_FORMAT_PHONE_NUMBER,
628: l_attrib_value,l_score);
629: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
630: 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);
631: END IF;
632: END IF;
633: l_score :=0;
634: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX5, p_table_TX5,(50000*(p_idx-1)+114)) THEN
648: hz_utility_v2pub.debug(p_message=>'l_score > 0',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
649: END IF;
650: l_attrib_value := get_attrib_val(p_record_id,'CONTACT_POINTS','EMAIL_ADDRESS');
651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
652: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
653: END IF;
654: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
655: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
656: VALUES (
650: l_attrib_value := get_attrib_val(p_record_id,'CONTACT_POINTS','EMAIL_ADDRESS');
651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
652: hz_utility_v2pub.debug(p_message=>'Inserting into HZ_PARTY_SCORE_DTLS_GT ...',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
653: END IF;
654: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
655: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
656: VALUES (
657: p_party_id,p_record_id,p_search_ctx_id,'EMAIL_ADDRESS',
658: 'CONTACT_POINTS', p_search_rec.EMAIL_ADDRESS,
657: p_party_id,p_record_id,p_search_ctx_id,'EMAIL_ADDRESS',
658: 'CONTACT_POINTS', p_search_rec.EMAIL_ADDRESS,
659: l_attrib_value,l_score);
660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
661: 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);
662: END IF;
663: END IF;
664: NULL;
665: END;