415: 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);
416: END IF;
417: l_attrib_value := get_attrib_val(p_record_id,'PARTY','DUNS_NUMBER_C');
418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
419: 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);
420: END IF;
421: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
422: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
423: VALUES (
417: l_attrib_value := get_attrib_val(p_record_id,'PARTY','DUNS_NUMBER_C');
418: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
419: 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);
420: END IF;
421: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
422: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
423: VALUES (
424: p_party_id,p_record_id,p_search_ctx_id,'DUNS_NUMBER_C',
425: 'PARTY', p_search_rec.DUNS_NUMBER_C,
424: p_party_id,p_record_id,p_search_ctx_id,'DUNS_NUMBER_C',
425: 'PARTY', p_search_rec.DUNS_NUMBER_C,
426: l_attrib_value,l_score);
427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
428: 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);
429: END IF;
430: END IF;
431: l_score :=0;
432: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) THEN
440: 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);
441: END IF;
442: l_attrib_value := get_attrib_val(p_record_id,'PARTY','TAX_REFERENCE');
443: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
444: 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);
445: END IF;
446: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
447: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
448: VALUES (
442: l_attrib_value := get_attrib_val(p_record_id,'PARTY','TAX_REFERENCE');
443: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
444: 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);
445: END IF;
446: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
447: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
448: VALUES (
449: p_party_id,p_record_id,p_search_ctx_id,'TAX_REFERENCE',
450: 'PARTY', p_search_rec.TAX_REFERENCE,
449: p_party_id,p_record_id,p_search_ctx_id,'TAX_REFERENCE',
450: 'PARTY', p_search_rec.TAX_REFERENCE,
451: l_attrib_value,l_score);
452: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
453: 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);
454: END IF;
455: END IF;
456: l_score :=0;
457: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX2, p_table_TX2,(50000*(p_idx-1)+6)) THEN
477: 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);
478: END IF;
479: l_attrib_value := get_attrib_val(p_record_id,'PARTY','PARTY_NAME');
480: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
481: 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);
482: END IF;
483: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
484: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
485: VALUES (
479: l_attrib_value := get_attrib_val(p_record_id,'PARTY','PARTY_NAME');
480: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
481: 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);
482: END IF;
483: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
484: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
485: VALUES (
486: p_party_id,p_record_id,p_search_ctx_id,'PARTY_NAME',
487: 'PARTY', p_search_rec.PARTY_NAME,
486: p_party_id,p_record_id,p_search_ctx_id,'PARTY_NAME',
487: 'PARTY', p_search_rec.PARTY_NAME,
488: l_attrib_value,l_score);
489: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
490: 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);
491: END IF;
492: END IF;
493: NULL;
494: END;
526: 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);
527: END IF;
528: l_attrib_value := get_attrib_val(p_record_id,'PARTY_SITES','ADDRESS');
529: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
530: 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);
531: END IF;
532: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
533: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
534: VALUES (
528: l_attrib_value := get_attrib_val(p_record_id,'PARTY_SITES','ADDRESS');
529: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
530: 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);
531: END IF;
532: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
533: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
534: VALUES (
535: p_party_id,p_record_id,p_search_ctx_id,'ADDRESS',
536: 'PARTY_SITES', p_search_rec.ADDRESS,
535: p_party_id,p_record_id,p_search_ctx_id,'ADDRESS',
536: 'PARTY_SITES', p_search_rec.ADDRESS,
537: l_attrib_value,l_score);
538: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
539: 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);
540: END IF;
541: END IF;
542: NULL;
543: END;