DBA Data[Home] [Help]

APPS.OKC_TERMS_COPY_PVT dependencies on OKC_MLP_TEMPLATE_USAGES

Line 2273: FROM OKC_MLP_TEMPLATE_USAGES

2269:
2270: --kkolukul: clm Changes
2271: CURSOR objnum_mlp_tu_csr IS
2272: SELECT object_version_number
2273: FROM OKC_MLP_TEMPLATE_USAGES
2274: WHERE DOCUMENT_TYPE = p_doc_type AND DOCUMENT_ID = p_doc_id;
2275:
2276: l_manual_art_count NUMBER;
2277: l_unassigned_scn_id OKC_SECTIONS_B.ID%TYPE := 0;

Line 3298: added to the doc in the new table created : okc_mlp_template_usages. Calling the

3294: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900:Exited copy_article_variables.Return Status '||x_return_status);
3295: END IF;
3296:
3297: /*When we are adding multiple templates to the doc, we need to copy all the templates
3298: added to the doc in the new table created : okc_mlp_template_usages. Calling the
3299: new API created to insert to this table*/
3300: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'910:Create template usage record in okc_mlp_template_usages');
3302: END IF;

Line 3301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'910:Create template usage record in okc_mlp_template_usages');

3297: /*When we are adding multiple templates to the doc, we need to copy all the templates
3298: added to the doc in the new table created : okc_mlp_template_usages. Calling the
3299: new API created to insert to this table*/
3300: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'910:Create template usage record in okc_mlp_template_usages');
3302: END IF;
3303: okc_clm_pkg.copy_usages_row(
3304: p_target_doc_type => p_target_doc_type,
3305: p_source_doc_type => p_source_doc_type,

Line 3451: all the templates added to the doc in the new table created : okc_mlp_template_usages. Calling the

3447: END IF;
3448:
3449: ELSE -- else for IF (p_retain_clauses = 'N') then
3450: /* If p_retain_clauses is 'Y' then we are adding multiple templates to the doc. So we need to save
3451: all the templates added to the doc in the new table created : okc_mlp_template_usages. Calling the
3452: new API created to insert to this table*/
3453: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3454: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'410:Create template usage record in okc_mlp_template_usages');
3455: END IF;

Line 3454: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'410:Create template usage record in okc_mlp_template_usages');

3450: /* If p_retain_clauses is 'Y' then we are adding multiple templates to the doc. So we need to save
3451: all the templates added to the doc in the new table created : okc_mlp_template_usages. Calling the
3452: new API created to insert to this table*/
3453: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3454: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'410:Create template usage record in okc_mlp_template_usages');
3455: END IF;
3456:
3457: okc_clm_pkg.insert_usages_row(p_document_type => p_target_doc_type,
3458: p_document_id => p_target_doc_id,