APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_TEMPLATE_USAGES

Line 3976: FROM okc_template_usages

3972: -- Repository Enhancement 12.1 (For Create New Version Action)
3973: CURSOR conterms_exist_csr is
3974: SELECT 'Y' FROM DUAL
3975: WHERE EXISTS (SELECT 'Y'
3976: FROM okc_template_usages
3977: WHERE DOCUMENT_ID = p_contract_id
3978: AND DOCUMENT_TYPE= contract_rec.contract_type);
3979: -- Repository Enhancement 12.1 Ends (For Create New Version Action)
3980: l_contract_source VARCHAR2(30); -- For Bug# 6902073

Line 4267: x_return_status := OKC_TEMPLATE_USAGES_PVT.Create_Version(

4263: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4264: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'300: Call Create_Version for template usages');
4265: END IF;
4266:
4267: x_return_status := OKC_TEMPLATE_USAGES_PVT.Create_Version(
4268: p_doc_type => contract_rec.contract_type,
4269: p_doc_id => p_contract_id,
4270: p_major_version => contract_rec.contract_version_num
4271: );

Line 7872: FROM okc_template_usages

7868: RETURN 'Y';
7869: ELSE
7870: BEGIN
7871: SELECT template_id INTO l_terms_template_id
7872: FROM okc_template_usages
7873: WHERE document_id = p_contract_id AND document_type = p_contract_type;
7874: EXCEPTION
7875: WHEN NO_DATA_FOUND THEN
7876: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN