APPS.OKC_TERMS_COPY_GRP dependencies on FND_PROFILE

Line 647: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: Global Org Id : '||nvl(fnd_profile.value('OKC_GLOBAL_ORG_ID'),'-99'));

643: INTO l_template_rec.org_id from dual;
644:
645: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
646: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: Current Org Id : '||l_template_rec.org_id);
647: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: Global Org Id : '||nvl(fnd_profile.value('OKC_GLOBAL_ORG_ID'),'-99'));
648: END IF;
649:
650: -- check if copy from Global to Local Org
651: -- In that case make global_yn for Local Org template to N

Line 653: IF nvl(fnd_profile.value('OKC_GLOBAL_ORG_ID'),'-99') <> l_template_rec.org_id THEN

649:
650: -- check if copy from Global to Local Org
651: -- In that case make global_yn for Local Org template to N
652:
653: IF nvl(fnd_profile.value('OKC_GLOBAL_ORG_ID'),'-99') <> l_template_rec.org_id THEN
654: l_template_rec.global_flag := 'N';
655: ELSE
656: -- keep flag as is as this is within the same org copy
657: l_template_rec.global_flag := p_global_flag;