APPS.OKC_TERMS_VERSION_PVT dependencies on OKC_TEMPLATE_USAGES

Line 43: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

39: ) IS
40: l_api_name CONSTANT VARCHAR2(30) := 'clear_amendment';
41: l_change_nonstd okc_k_articles_b.change_nonstd_yn%TYPE;
42: --Fix for bug# 3990983
43: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
44:
45: CURSOR scn_crs IS
46: SELECT id, object_version_number,amendment_operation_code,summary_amend_operation_code
47: FROM okc_sections_b

Line 92: FROM okc_template_usages

88: -- Fix for bug# 3990983
89: -- Cursor to fetch the contract_source_code for the given document_type, document_id
90: CURSOR l_ctrt_src_crs IS
91: SELECT contract_source_code
92: FROM okc_template_usages
93: WHERE document_type = p_doc_type AND document_id = p_doc_id;
94: BEGIN
95: x_return_status := G_RET_STS_SUCCESS;
96: /* IF (l_debug = 'Y') THEN

Line 396: OKC_TEMPLATE_USAGES_PVT.update_row(

392: FETCH l_ctrt_src_crs into l_contract_source_code;
393: CLOSE l_ctrt_src_crs;
394:
395: IF(l_contract_source_code = 'ATTACHED') THEN
396: OKC_TEMPLATE_USAGES_PVT.update_row(
397: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
398: x_return_status => x_return_status,
399: p_document_type => p_doc_type,
400: p_document_id => p_doc_id,

Line 601: x_return_status := OKC_TEMPLATE_USAGES_PVT.Create_Version(

597: FND_LOG.STRING(G_PROC_LEVEL,
598: G_PKG_NAME, '100: Call Create_Version for template usages' );
599: END IF;
600:
601: x_return_status := OKC_TEMPLATE_USAGES_PVT.Create_Version(
602: p_doc_type => p_doc_type,
603: p_doc_id => p_doc_id,
604: p_major_version => p_version_number
605: );

Line 889: x_return_status := OKC_TEMPLATE_USAGES_PVT.Restore_Version(

885: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
886: FND_LOG.STRING(G_PROC_LEVEL,
887: G_PKG_NAME, '100: Call Restore_Version for template usages');
888: END IF;
889: x_return_status := OKC_TEMPLATE_USAGES_PVT.Restore_Version(
890: p_doc_type => p_doc_type,
891: p_doc_id => p_doc_id,
892: p_major_version => p_version_number
893: );

Line 1049: x_return_status := OKC_TEMPLATE_USAGES_PVT.Delete_Version(

1045: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1046: FND_LOG.STRING(G_PROC_LEVEL,
1047: G_PKG_NAME, '100: Call Delete_Version for template usages' );
1048: END IF;
1049: x_return_status := OKC_TEMPLATE_USAGES_PVT.Delete_Version(
1050: p_doc_type => p_doc_type,
1051: p_doc_id => p_doc_id,
1052: p_major_version => p_version_number
1053: );