APPS.OKC_TERMS_COPY_PVT dependencies on DUAL

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

2842: END IF;
2843:
2844: -- Copy Usage record.
2845: FOR cr in l_get_allwd_usage_csr(p_target_template_rec.parent_template_id) LOOP
2846: select OKC_ALLOWED_TMPL_USAGES_S.NEXTVAL into l_tmpl_usage_id from dual;
2847: OKC_ALLOWED_TMPL_USAGES_GRP.Create_Allowed_Tmpl_Usages(
2848: p_api_version =>1,
2849: p_init_msg_list =>FND_API.G_FALSE,
2850: p_commit => FND_API.G_FALSE,

Line 2996: SELECT UPPER(FND_PROFILE.VALUE('OKC_USE_CONTRACTS_RULES_ENGINE')) INTO l_cntrcts_ruls_eng_exists FROM DUAL;

2992: END IF;
2993:
2994:
2995: BEGIN
2996: SELECT UPPER(FND_PROFILE.VALUE('OKC_USE_CONTRACTS_RULES_ENGINE')) INTO l_cntrcts_ruls_eng_exists FROM DUAL;
2997: EXCEPTION
2998: WHEN OTHERS THEN
2999: l_cntrcts_ruls_eng_exists := 'N';
3000: END;

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

3271: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3272: RAISE FND_API.G_EXC_ERROR ;
3273: END IF;
3274:
3275: SELECT decode(p_keep_version,'Y','N','Y') INTO l_get_from_library FROM DUAL;
3276:
3277: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3278: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800:Entering copy_article_variables. ');
3279: END IF;