APPS.OKC_TERMS_COPY_PVT dependencies on OKC_ALLOWED_TMPL_USAGES

Line 2063: SELECT '!' FROM OKC_ALLOWED_TMPL_USAGES

2059: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
2060: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
2061:
2062: CURSOR l_get_allwd_tmp_usages_csr IS
2063: SELECT '!' FROM OKC_ALLOWED_TMPL_USAGES
2064: WHERE template_id=p_source_doc_id
2065: AND document_type = p_target_doc_type;
2066:
2067: CURSOR l_get_tmpl_csr IS

Line 2097: SELECT * from okc_allowed_tmpl_usages where

2093: WHERE DOCUMENT_TYPE=p_target_doc_type
2094: AND DOCUMENT_ID=p_target_doc_id;
2095:
2096: CURSOR l_get_allwd_usage_csr(b_source_doc_id NUMBER) IS
2097: SELECT * from okc_allowed_tmpl_usages where
2098: template_id=b_source_doc_id;
2099:
2100: l_tmpl_rec l_get_tmpl_csr%ROWTYPE;
2101: l_usage_rec l_get_usage_csr%ROWTYPE;

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

2242:
2243: IF p_target_template_rec.working_copy_flag='Y' THEN
2244:
2245: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2246: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'160:Calling OKC_ALLOWED_TMPL_USAGES_GRP.Create_Allowed_Tmpl_Usages');
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

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

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