427: 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);
428: END IF;
429: l_attrib_value := get_attrib_val(p_record_id,'PARTY','PARTY_NAME');
430: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
431: 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);
432: END IF;
433: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
434: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
435: VALUES (
429: l_attrib_value := get_attrib_val(p_record_id,'PARTY','PARTY_NAME');
430: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
431: 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);
432: END IF;
433: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
434: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
435: VALUES (
436: p_party_id,p_record_id,p_search_ctx_id,'PARTY_NAME',
437: 'PARTY', p_search_rec.PARTY_NAME,
436: p_party_id,p_record_id,p_search_ctx_id,'PARTY_NAME',
437: 'PARTY', p_search_rec.PARTY_NAME,
438: l_attrib_value,l_score);
439: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
440: 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);
441: END IF;
442: END IF;
443: l_score :=0;
444: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX41, p_table_TX41,(50000*(p_idx-1)+45)) THEN
452: 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);
453: END IF;
454: l_attrib_value := get_attrib_val(p_record_id,'PARTY','DUNS_NUMBER_C');
455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
456: 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);
457: END IF;
458: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
459: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
460: VALUES (
454: l_attrib_value := get_attrib_val(p_record_id,'PARTY','DUNS_NUMBER_C');
455: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
456: 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);
457: END IF;
458: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
459: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
460: VALUES (
461: p_party_id,p_record_id,p_search_ctx_id,'DUNS_NUMBER_C',
462: 'PARTY', p_search_rec.DUNS_NUMBER_C,
461: p_party_id,p_record_id,p_search_ctx_id,'DUNS_NUMBER_C',
462: 'PARTY', p_search_rec.DUNS_NUMBER_C,
463: l_attrib_value,l_score);
464: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
465: 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);
466: END IF;
467: END IF;
468: l_score :=0;
469: IF HZ_DQM_SEARCH_UTIL.is_match(p_stage_rec.TX44, p_table_TX44,(50000*(p_idx-1)+49)) 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','TAX_REFERENCE');
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','TAX_REFERENCE');
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,'TAX_REFERENCE',
487: 'PARTY', p_search_rec.TAX_REFERENCE,
486: p_party_id,p_record_id,p_search_ctx_id,'TAX_REFERENCE',
487: 'PARTY', p_search_rec.TAX_REFERENCE,
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;