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.26.12010000.2 2008/11/14 08:03:45 harchand 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 2726: -- fnd_profile.get('ORG_ID',l_current_org_id);

2722: FETCH l_get_article_org_csr INTO l_article_org_id;
2723: CLOSE l_get_article_org_csr;
2724:
2725: -- current Org Id
2726: -- fnd_profile.get('ORG_ID',l_current_org_id);
2727: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_document_type, p_document_id);
2728:
2729: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2730: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_article_org_id : '||l_article_org_id);

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

4800: fetch get_bsa_lay_templ_csr into l_layout_template_code;
4801: close get_bsa_lay_templ_csr;
4802: END IF;
4803: ELSIF p_doc_type_class = 'QUOTE' THEN
4804: select fnd_profile.value('ASO_DEFAULT_LAYOUT_TEMPLATE') into l_layout_template_code from dual;
4805:
4806: --ER Structured Terms Authoring in Repository - strivedi
4807: ELSIF p_doc_type_class = 'REPOSITORY' THEN
4808: OPEN get_rep_lay_templ_csr;