APPS.OKC_TEMPLATE_USAGES_PVT dependencies on OKC_TEMPLATE_USAGES_H

Line 2053: INSERT INTO OKC_TEMPLATE_USAGES_H (

2049:
2050: -----------------------------------------
2051: -- Saving Base Table
2052: -----------------------------------------
2053: INSERT INTO OKC_TEMPLATE_USAGES_H (
2054: major_version,
2055: DOCUMENT_TYPE,
2056: DOCUMENT_ID,
2057: TEMPLATE_ID,

Line 2232: FROM OKC_TEMPLATE_USAGES_H

2228: CONTRACT_ADMIN_ID,
2229: LEGAL_CONTACT_ID,
2230: LOCKED_BY_USER_ID,
2231: CONTRACT_EXPERT_FINISH_FLAG
2232: FROM OKC_TEMPLATE_USAGES_H
2233: WHERE document_type = p_doc_type and document_id = p_doc_id AND major_version = p_major_version;
2234:
2235: --If contract expert uses new okc rules engine, then copy resposnes from history table to base table.
2236: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine

Line 2280: FROM OKC_TEMPLATE_USAGES_H

2276: -----------------------------------------
2277: -- Restoring Base Table
2278: -----------------------------------------
2279: DELETE
2280: FROM OKC_TEMPLATE_USAGES_H
2281: WHERE document_type = p_doc_type
2282: AND document_id = p_doc_id
2283: AND major_version = p_major_version;
2284: