APPS.OKS_COPY_CONTRACT_PVT dependencies on FND_PROFILE

Line 4: l_debug VARCHAR2(1) := 'Y'; -- NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: Package body OKS_COPY_CONTRACT_PVT AS
2: /*$Header: OKSCOPYB.pls 120.125.12020000.3 2013/04/05 11:52:49 vgujarat ship $*/
3:
4: l_debug VARCHAR2(1) := 'Y'; -- NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: g_count NUMBER;
6:
7: SUBTYPE oatv_rec_type IS OKC_OUTCOME_PUB.oatv_rec_type;
8: SUBTYPE ocev_rec_type IS OKC_OUTCOME_PUB.ocev_rec_type;

Line 1692: fnd_profile.get('OKC_EURO_DEFAULT_PRICELIST', g_pricelist);

1688: from okc_k_headers_b
1689: where id = l_chrv_rec.id;
1690: End If;
1691:
1692: fnd_profile.get('OKC_EURO_DEFAULT_PRICELIST', g_pricelist);
1693:
1694: if (g_pricelist is NULL) then
1695: fnd_message.set_name('OKC','OKC_PROFILE_CHECK');
1696: fnd_message.set_token('PROFILE','OKC_EURO_DEFAULT_PRICELIST');

Line 1803: IF FND_PROFILE.VALUE('OKS_CURR_CONV_DATE')='SYSDATE' then

1799:
1800: /*cgopinee bugfix for 8361496*/
1801: IF p_renew_ref_yn = 'Y' then
1802: IF ((l_chrv_rec.conversion_type is not null) and (upper(l_chrv_rec.conversion_type) <>'USER')) THEN
1803: IF FND_PROFILE.VALUE('OKS_CURR_CONV_DATE')='SYSDATE' then
1804: l_from_currency :=l_chrv_rec.currency_code;
1805: l_to_currency := OKC_CURRENCY_API.GET_OU_CURRENCY(l_chrv_rec.authoring_org_id);
1806: l_chrv_rec.conversion_rate_date := SYSDATE;
1807: okc_currency_api.get_rate

Line 15625: l_profile_value VARCHAR2(100) :=Nvl(fnd_profile.Value('OKS_COPY_NOTES'),'Y'); ----added for bugfix 14240229 by ansraj

15621: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
15622:
15623: l_SrcContractPPSetupExists_YN VARCHAR2(1) := ContractPPSetupEXISTS(P_Chr_ID => P_From_Chr_ID);
15624: l_GCDPPSetupExists_YN VARCHAR2(1) ;
15625: l_profile_value VARCHAR2(100) :=Nvl(fnd_profile.Value('OKS_COPY_NOTES'),'Y'); ----added for bugfix 14240229 by ansraj
15626:
15627: -- 03-Nov-2006 hkamdar. Bug# 5623498.
15628: CURSOR get_toplvl_uom(p_line_id IN NUMBER) IS
15629: SELECT OEL.PRICING_QUANTITY_UOM

Line 25678: l_profile_value VARCHAR2(100) :=Nvl(fnd_profile.Value('OKS_COPY_NOTES'),'Y'); --bugfix for 14240229 by ansraj

25674: l_target_doc_type VARCHAR2(60);
25675: l_target_doc_id NUMBER;
25676: l_keep_version VARCHAR2(1);
25677: l_eff_date DATE;
25678: l_profile_value VARCHAR2(100) :=Nvl(fnd_profile.Value('OKS_COPY_NOTES'),'Y'); --bugfix for 14240229 by ansraj
25679:
25680:
25681: -- 11510 get chr start date for effective date for copy_doc
25682: CURSOR c_art_eff_date (p_doc_type VARCHAR2,p_doc_id NUMBER) IS