APPS.OKC_TERMS_COPY_PVT dependencies on DUAL

Line 2251: select OKC_ALLOWED_TMPL_USAGES_S.NEXTVAL into l_tmpl_usage_id from dual;

2247: END IF;
2248:
2249: -- Copy Usage record.
2250: FOR cr in l_get_allwd_usage_csr(p_target_template_rec.parent_template_id) LOOP
2251: select OKC_ALLOWED_TMPL_USAGES_S.NEXTVAL into l_tmpl_usage_id from dual;
2252: OKC_ALLOWED_TMPL_USAGES_GRP.Create_Allowed_Tmpl_Usages(
2253: p_api_version =>1,
2254: p_init_msg_list =>FND_API.G_FALSE,
2255: p_commit => FND_API.G_FALSE,

Line 2547: SELECT decode(p_keep_version,'Y','N','Y') INTO l_get_from_library FROM DUAL;

2543: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2544: RAISE FND_API.G_EXC_ERROR ;
2545: END IF;
2546:
2547: SELECT decode(p_keep_version,'Y','N','Y') INTO l_get_from_library FROM DUAL;
2548:
2549: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2550: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800:Entering copy_article_variables. ');
2551: END IF;