eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_41 dependencies on FND_PROFILE

Line 2317: 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

2313: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
2314: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2315: 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);
2316: END IF;
2317: 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
2318: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2319: 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);
2320: END IF;
2321: IF (l_party_site_contains_str IS NULL AND

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

2369: END IF;
2370: IF (l_party_id_idx-1)>l_max_thresh THEN
2371: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
2372: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
2373: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
2374: AND l_contact_pt_contains_str IS NULL THEN
2375: EXIT;
2376: END IF;
2377: CLOSE l_party_cur;

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

2971:
2972: --End fix for bug 4417124
2973:
2974: IF p_dup_batch_id IS NOT NULL THEN
2975: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2976: ELSE
2977: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2978: END IF;
2979: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN

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

2973:
2974: IF p_dup_batch_id IS NOT NULL THEN
2975: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2976: ELSE
2977: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2978: END IF;
2979: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2980: g_score_until_thresh := true;
2981: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2975: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH_BATCH'),10000);
2976: ELSE
2977: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
2978: END IF;
2979: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
2980: g_score_until_thresh := true;
2981: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2982: 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);
2983: END IF;

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

3290: and check_estimate_hits('PARTY',p_party_contains_str)>l_max_thresh THEN
3291: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3292: 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);
3293: END IF;
3294: IF g_party_stage_rec.TX8 IS NOT NULL AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL' THEN
3295: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3296: 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);
3297: END IF;
3298: IF (l_party_site_contains_str IS NULL AND

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

3343: END IF;
3344: IF (l_party_id_idx-1)>l_max_thresh THEN
3345: IF p_index=1 AND call_order(2) = 'PARTY_SITE'
3346: AND call_type(2) = 'AND' AND l_contact_contains_str IS NULL
3347: AND nvl(FND_PROFILE.VALUE('HZ_DQM_PN_THRESH_RESOLUTION'),'NONE')='SQL'
3348: AND l_contact_pt_contains_str IS NULL THEN
3349: H_PARTY_ID.DELETE(l_party_id_idx-1);
3350: H_PARTY_ID_LIST.DELETE(l_index);
3351: H_SCORES.DELETE(l_index);

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

3884: END IF;
3885: 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);
3886: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3887:
3888: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3889: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3890: g_score_until_thresh := true;
3891: ELSE
3892: g_score_until_thresh := false;

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

3885: 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);
3886: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
3887:
3888: l_max_thresh:=nvl(FND_PROFILE.VALUE('HZ_DQM_MAX_EVAL_THRESH'),200);
3889: IF nvl(FND_PROFILE.VALUE('HZ_DQM_SCORE_UNTIL_THRESH'),'N')='Y' THEN
3890: g_score_until_thresh := true;
3891: ELSE
3892: g_score_until_thresh := false;
3893: END IF;

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

5559: l_use_contact_info varchar2(1);
5560: BEGIN
5561:
5562: l_use_contact_info := 'Y';
5563: IF nvl(FND_PROFILE.VALUE('HZ_DQM_REL_PARTY_MATCH'),'N')='Y' THEN
5564: l_use_contact_info := 'N';
5565: END IF;
5566: l_party_id := p_party_id;
5567: FOR PARTY_SITES IN (