APPS.OKC_TEMPLATE_USAGES_PVT dependencies on OKC_TEMPLATE_USAGES_H

Line 2027: INSERT INTO OKC_TEMPLATE_USAGES_H (

2023:
2024: -----------------------------------------
2025: -- Saving Base Table
2026: -----------------------------------------
2027: INSERT INTO OKC_TEMPLATE_USAGES_H (
2028: major_version,
2029: DOCUMENT_TYPE,
2030: DOCUMENT_ID,
2031: TEMPLATE_ID,

Line 2197: FROM OKC_TEMPLATE_USAGES_H

2193: ENABLE_REPORTING_FLAG,
2194: CONTRACT_ADMIN_ID,
2195: LEGAL_CONTACT_ID,
2196: LOCKED_BY_USER_ID
2197: FROM OKC_TEMPLATE_USAGES_H
2198: WHERE document_type = p_doc_type and document_id = p_doc_id AND major_version = p_major_version;
2199:
2200: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2201: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10500: Leaving restore_version');

Line 2240: FROM OKC_TEMPLATE_USAGES_H

2236: -----------------------------------------
2237: -- Restoring Base Table
2238: -----------------------------------------
2239: DELETE
2240: FROM OKC_TEMPLATE_USAGES_H
2241: WHERE document_type = p_doc_type
2242: AND document_id = p_doc_id
2243: AND major_version = p_major_version;
2244: