APPS.OKC_TERMS_COPY_PVT dependencies on OKC_ALLOWED_TMPL_USAGES

Line 2634: SELECT '!' FROM OKC_ALLOWED_TMPL_USAGES

2630: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
2631: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
2632:
2633: CURSOR l_get_allwd_tmp_usages_csr IS
2634: SELECT '!' FROM OKC_ALLOWED_TMPL_USAGES
2635: WHERE template_id=p_source_doc_id
2636: AND document_type = p_target_doc_type;
2637:
2638: CURSOR l_get_tmpl_csr IS

Line 2684: SELECT * from okc_allowed_tmpl_usages where

2680: WHERE DOCUMENT_TYPE=p_target_doc_type
2681: AND DOCUMENT_ID=p_target_doc_id;
2682:
2683: CURSOR l_get_allwd_usage_csr(b_source_doc_id NUMBER) IS
2684: SELECT * from okc_allowed_tmpl_usages where
2685: template_id=b_source_doc_id;
2686:
2687: l_tmpl_rec l_get_tmpl_csr%ROWTYPE;
2688: l_usage_rec l_get_usage_csr%ROWTYPE;

Line 2841: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'160:Calling OKC_ALLOWED_TMPL_USAGES_GRP.Create_Allowed_Tmpl_Usages');

2837:
2838: IF p_target_template_rec.working_copy_flag='Y' THEN
2839:
2840: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2841: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'160:Calling OKC_ALLOWED_TMPL_USAGES_GRP.Create_Allowed_Tmpl_Usages');
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

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 2847: OKC_ALLOWED_TMPL_USAGES_GRP.Create_Allowed_Tmpl_Usages(

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,
2851: x_return_status => x_return_status,