APPS.OKC_TERMS_COPY_PVT dependencies on FND_PROFILE

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

877: FETCH l_get_article_org_csr INTO l_article_org_id;
878: CLOSE l_get_article_org_csr;
879:
880: -- current Org Id
881: -- fnd_profile.get('ORG_ID',l_current_org_id);
882: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_target_doc_type, p_target_doc_id);
883:
884: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
885: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_article_org_id : '||l_article_org_id);

Line 1028: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Profile OKC_GLOBAL_ORG_ID : '||fnd_profile.value('OKC_GLOBAL_ORG_ID'));

1024: AND l_standard_yn='Y' THEN
1025:
1026: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1027: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Template To Template Copy l_global_yn : '||l_global_yn);
1028: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Profile OKC_GLOBAL_ORG_ID : '||fnd_profile.value('OKC_GLOBAL_ORG_ID'));
1029: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100:Target Template org_id : '||l_org_id);
1030: END IF;
1031:
1032: IF l_global_yn = 'Y'

Line 1033: AND nvl(fnd_profile.value('OKC_GLOBAL_ORG_ID'),'?') <> l_org_id THEN

1029: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100:Target Template org_id : '||l_org_id);
1030: END IF;
1031:
1032: IF l_global_yn = 'Y'
1033: AND nvl(fnd_profile.value('OKC_GLOBAL_ORG_ID'),'?') <> l_org_id THEN
1034:
1035: OPEN l_get_local_article_csr(sav_sae_tbl(i),l_org_id);
1036: FETCH l_get_local_article_csr INTO l_local_article_rec;
1037: