DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_5 dependencies on HZ_PARTY_SCORE_DTLS_GT

Line 370: 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);

366: 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);
367: END IF;
368: l_attrib_value := get_attrib_val(p_record_id,'PARTY','PARTY_NAME');
369: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
370: 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);
371: END IF;
372: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
373: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
374: VALUES (

Line 372: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,

368: l_attrib_value := get_attrib_val(p_record_id,'PARTY','PARTY_NAME');
369: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
370: 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);
371: END IF;
372: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,
373: ATTRIBUTE,ENTITY,ENTERED_VALUE, MATCHED_VALUE, ASSIGNED_SCORE)
374: VALUES (
375: p_party_id,p_record_id,p_search_ctx_id,'PARTY_NAME',
376: 'PARTY', p_search_rec.PARTY_NAME,

Line 379: 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);

375: p_party_id,p_record_id,p_search_ctx_id,'PARTY_NAME',
376: 'PARTY', p_search_rec.PARTY_NAME,
377: l_attrib_value,l_score);
378: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
379: 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);
380: END IF;
381: END IF;
382: NULL;
383: END;

Line 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);

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_SITES','ADDRESS');
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 (

Line 421: INSERT INTO HZ_PARTY_SCORE_DTLS_GT (PARTY_ID, RECORD_ID, SEARCH_CONTEXT_ID,

417: l_attrib_value := get_attrib_val(p_record_id,'PARTY_SITES','ADDRESS');
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,'ADDRESS',
425: 'PARTY_SITES', p_search_rec.ADDRESS,

Line 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);

424: p_party_id,p_record_id,p_search_ctx_id,'ADDRESS',
425: 'PARTY_SITES', p_search_rec.ADDRESS,
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: NULL;
432: END;