APPS.HZ_DUP_PVT dependencies on FND_PROFILE

Line 209: l_prof_value := nvl(fnd_profile.value('HZ_PARTY_MASTER_DEFAULT'),'MOST_ACCOUNTS');

205: open get_def_master_lu_csr(l_status);
206: fetch get_def_master_lu_csr into l_lu_master_party_id, l_lu_master_party_name;
207: close get_def_master_lu_csr;
208:
209: l_prof_value := nvl(fnd_profile.value('HZ_PARTY_MASTER_DEFAULT'),'MOST_ACCOUNTS');
210: if l_prof_value = 'MOST_ACCOUNTS'
211: then
212: open get_def_master_macc_csr(l_status);
213: fetch get_def_master_macc_csr into l_master_party_id, x_master_party_name;

Line 1696: fnd_profile.get(

1692:
1693: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
1694: --FND_FILE.PUT_LINE (FND_FILE.LOG, 'Checking Profile Value for HZ_DL_DQM_MERGE_SUGG');
1695: --Bug 5635453
1696: fnd_profile.get(
1697: name => 'HZ_DL_DQM_MERGE_SUGG',
1698: val => l_default_mapping
1699: );
1700:

Line 1886: IF NVL(fnd_profile.value('HZ_DL_PROTECT_PARTY_MODELING'), 'Y') = 'Y' THEN

1882: x_cert_warn := 'HZ_PMODEL_PROTECT_CERT_WARN';
1883: end if;
1884: CLOSE c_cursor; */
1885:
1886: IF NVL(fnd_profile.value('HZ_DL_PROTECT_PARTY_MODELING'), 'Y') = 'Y' THEN
1887: l_count := 0;
1888: ---Party Modeling for relationship Hierarchy
1889: open c_cursor FOR ' select distinct parent_id,child_id,nvl(top_parent_flag,''N'') top_parent_flag,level_number,hierarchy_type,'||
1890: ' p1.party_number parent_reg_id,p2.party_number child_reg_id '||

Line 1954: end if; -- if nvl(fnd_profile.value...

1950: l_token_str := rtrim(l_token_str,',');
1951: x_reln_token := l_token_str;
1952: x_reln_warn := 'HZ_PMODEL_PROTECT_REL_WARN';
1953: END IF;
1954: end if; -- if nvl(fnd_profile.value...
1955: END;
1956:
1957: FUNCTION get_automerge_candidate(p_party_score NUMBER, p_automerge_score NUMBER)
1958: RETURN VARCHAR2 IS

Line 2008: l_dl_dss_prof := NVL(fnd_profile.value('HZ_DL_DISPLAY_LOCK'), 'N');

2004: x_return_status := FND_API.G_RET_STS_SUCCESS;
2005: FND_MSG_PUB.initialize;
2006:
2007: x_dss_update_flag := 'Y';
2008: l_dl_dss_prof := NVL(fnd_profile.value('HZ_DL_DISPLAY_LOCK'), 'N');
2009: open get_merge_parties_csr;
2010: loop
2011: fetch get_merge_parties_csr into l_party_id;
2012: exit when get_merge_parties_csr%notfound;

Line 2015: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' and l_dl_dss_prof <> 'F' THEN

2011: fetch get_merge_parties_csr into l_party_id;
2012: exit when get_merge_parties_csr%notfound;
2013:
2014: -- DSS Check if dss profile enabled and dl dss rule is not set to F(do not check DSS)
2015: IF NVL(fnd_profile.value('HZ_DSS_ENABLED'), 'N') = 'Y' and l_dl_dss_prof <> 'F' THEN
2016:
2017: l_test_security := hz_dss_util_pub.test_instance(
2018: p_operation_code => 'UPDATE',
2019: p_db_object_name => 'HZ_PARTIES',

Line 2083: if NVL(fnd_profile.value('HZ_DL_DISPLAY_LOCK'), 'N') = 'Y'

2079: l_msg_count NUMBER;
2080: l_msg_data VARCHAR2(2000);
2081:
2082: begin
2083: if NVL(fnd_profile.value('HZ_DL_DISPLAY_LOCK'), 'N') = 'Y'
2084: then
2085: party_merge_dss_check(p_merge_batch_id => p_dup_set_id,
2086: x_dss_update_flag => l_dss_update_flag,
2087: x_return_status => l_return_status,