Search Results oke_contract_pub




Overview
Explore in AI Chat

Overview

OKE_CLE_PVT is a private (PVT) PL/SQL package in the APPS schema that belongs to the Oracle Contracts Intelligence family of modules, specifically the OKE (Oracle Knowledge and Contracts) product line. As a private package, it is not intended for direct invocation by external consumers; rather it encapsulates the low-level row maintenance logic that supports the public contract authoring and import APIs. The package name combines the "OKE" prefix with "CLE," which corresponds to the contract line element structures used throughout the OKE contract model. OKE_CLE_PVT provides the internal insert, update, delete, and validation routines that manipulate contract header and line records, along with the auxiliary billing-method, customer-item, and project/task reference data associated with those lines.

Its API classification is PVT and its status is VALID. It depends on OKE_API, OKE_K_LINES, and the SYS.STANDARD package, and it is referenced by four other packages: OKE_CONTRACT_PUB, OKE_CONTRACT_PVT, OKE_IMPORT_CONTRACT_PUB, and OKE_KCOPY_PKG, plus the public wrapper OKE_CLE_PVT.

Key Procedures and Functions

The documented interface exposes eight procedures and functions, centered on four named operations:

  • INSERT_ROW — Creates a new contract line element record, populating the contract header and line tables with the attributes supplied by the caller.
  • UPDATE_ROW — Modifies an existing contract line element record, applying changes to header, line, and associated reference data.
  • DELETE_ROW — Removes a contract line element record and its dependent rows from the contract tables.
  • VALIDATE_ROW — Performs the business-rule validation checks required before an insert or update is committed, ensuring the line element is internally consistent and references valid project, task, customer item, and billing-method data.

Parameter lists are not published in the metadata and are intentionally omitted here. The routines are designed as a cohesive private API, so they are always called together in the correct sequence by the higher-level public packages.

Tables Accessed

OKE_CLE_PVT reads and writes the core contract tables via APPS synonyms. OKC_K_HEADERS_B and OKC_K_LINES_B hold the base contract header and line records, while OKE_K_HEADERS and OKE_K_LINES store the OKE-specific header and line attributes. OKC_ANCESTRYS maintains the line-element hierarchy and parent-child relationships. OKE_K_BILLING_METHODS supplies the billing method configuration applied to lines. MTL_CUSTOMER_ITEMS links contract lines to customer-defined item definitions. PA_PROJECTS_ALL and PA_TASKS provide the project and task references used for project-related contract lines. PLITBLM is used internally for name-value pair or lookup resolution. Together these tables define the complete contract line element state managed by the package.

Usage Notes

Because OKE_CLE_PVT is a private package, it is never called directly from Oracle Forms, concurrent programs, or customer extensions. Instead it is invoked indirectly through the public contract APIs — OKE_CONTRACT_PUB, OKE_CONTRACT_PVT, OKE_IMPORT_CONTRACT_PUB, and OKE_KCOPY_PKG — which serve the Contract Authoring forms, the Contract Import concurrent program, and the contract copy utility. During a contract save, import, copy, or delete, those public APIs delegate row-level maintenance to OKE_CLE_PVT so that validation, persistence, and cascade logic remain centralized. Customizations that need to create or modify contract line elements must call the public OKE_CONTRACT_PUB routines rather than this package, preserving upgrade safety across both EBS 12.1.1 and 12.2.2.