DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_2 dependencies on FND_PROFILE

Line 2148: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' AND p_dup_batch_id IS NULL THEN

2144: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2145: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2146: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2147: END IF;
2148: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' AND p_dup_batch_id IS NULL THEN
2149: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'In eval party level resolution options is set to SQL search.',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2151: END IF;
2152: IF (l_party_site_contains_str IS NULL AND

Line 2204: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'

2200: END IF;
2201: IF (l_party_id_idx-1)>l_max_thresh THEN
2202: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2203: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2204: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2205: AND l_contact_pt_contains_str IS NULL THEN
2206: EXIT;
2207: END IF;
2208: CLOSE l_party_cur;

Line 2736: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);

2732:
2733: --End fix for bug 4417124
2734:
2735: IF p_dup_batch_id IS NOT NULL THEN
2736: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2737: ELSE
2738: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2739: END IF;
2740: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

Line 2738: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);

2734:
2735: IF p_dup_batch_id IS NOT NULL THEN
2736: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2737: ELSE
2738: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2739: END IF;
2740: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2741: g_score_until_thresh := true;
2742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2740: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

2736: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2737: ELSE
2738: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2739: END IF;
2740: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2741: g_score_until_thresh := true;
2742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2743: hz_utility_v2pub.debug(p_message=>'g_score_until_thresh is true',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2744: END IF;

Line 3082: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN

3078: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3080: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3081: END IF;
3082: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3083: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3084: hz_utility_v2pub.debug(p_message=>'In eval party level resolution option is set to SQL search.',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3085: END IF;
3086: IF (l_party_site_contains_str IS NULL AND

Line 3135: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'

3131: END IF;
3132: IF (l_party_id_idx-1)>l_max_thresh THEN
3133: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3134: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3135: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3136: AND l_contact_pt_contains_str IS NULL THEN
3137: H_PARTY_ID.DELETE(l_party_id_idx-1);
3138: H_PARTY_ID_LIST.DELETE(l_index);
3139: H_SCORES.DELETE(l_index);

Line 3581: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);

3577: END IF;
3578: l_entered_max_score:= init_search(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list, l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
3579: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3580:
3581: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3582: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3583: g_score_until_thresh := true;
3584: ELSE
3585: g_score_until_thresh := false;

Line 3582: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

3578: l_entered_max_score:= init_search(p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list, l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
3579: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3580:
3581: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3582: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3583: g_score_until_thresh := true;
3584: ELSE
3585: g_score_until_thresh := false;
3586: END IF;

Line 5215: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN

5211: l_use_contact_info varchar2(1);
5212: BEGIN
5213:
5214: l_use_contact_info := 'Y';
5215: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5216: l_use_contact_info := 'N';
5217: END IF;
5218: l_party_id := p_party_id;
5219: FOR PARTY_SITES IN (