APPS.OKC_TERMS_UTIL_PVT dependencies on FND_PROFILE

Line 3: g_concat_art_no VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OKC_CONCAT_ART_NO'),'N');

1: PACKAGE BODY OKC_TERMS_UTIL_PVT AS
2: /* $Header: OKCVDUTB.pls 120.34.12020000.4 2013/03/12 06:50:46 nbingi ship $ */
3: g_concat_art_no VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OKC_CONCAT_ART_NO'),'N');
4:
5: ---------------------------------------------------------------------------
6: -- GLOBAL MESSAGE CONSTANTS
7: ---------------------------------------------------------------------------

Line 2768: -- fnd_profile.get('ORG_ID',l_current_org_id);

2764: FETCH l_get_article_org_csr INTO l_article_org_id;
2765: CLOSE l_get_article_org_csr;
2766:
2767: -- current Org Id
2768: -- fnd_profile.get('ORG_ID',l_current_org_id);
2769: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_document_type, p_document_id);
2770:
2771: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2772: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_article_org_id : '||l_article_org_id);

Line 4853: select fnd_profile.value('ASO_DEFAULT_LAYOUT_TEMPLATE') into l_layout_template_code from dual;

4849: fetch get_bsa_lay_templ_csr into l_layout_template_code;
4850: close get_bsa_lay_templ_csr;
4851: END IF;
4852: ELSIF p_doc_type_class = 'QUOTE' THEN
4853: select fnd_profile.value('ASO_DEFAULT_LAYOUT_TEMPLATE') into l_layout_template_code from dual;
4854:
4855: --ER Structured Terms Authoring in Repository - strivedi
4856: ELSIF p_doc_type_class = 'REPOSITORY' THEN
4857: OPEN get_rep_lay_templ_csr;