APPS.OKC_TERMS_COPY_GRP dependencies on FND_PROFILE

Line 529: 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'));

525: INTO l_template_rec.org_id from dual;
526:
527: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
528: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'110: Current Org Id : '||l_template_rec.org_id);
529: 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'));
530: END IF;
531:
532: -- check if copy from Global to Local Org
533: -- In that case make global_yn for Local Org template to N

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

531:
532: -- check if copy from Global to Local Org
533: -- In that case make global_yn for Local Org template to N
534:
535: IF nvl(fnd_profile.value('OKC_GLOBAL_ORG_ID'),'-99') <> l_template_rec.org_id THEN
536: l_template_rec.global_flag := 'N';
537: ELSE
538: -- keep flag as is as this is within the same org copy
539: l_template_rec.global_flag := p_global_flag;