Search Results okl_trx_contracts_pvt




Overview
Explore in AI Chat

Overview

The APPS.OKL_TRX_CONTRACTS_PVT package body is a private (PVT-classified) PL/SQL API that belongs to the Oracle E-Business Suite Enterprise Contracts / Lease and Finance Management (ETRM) module. Its primary business function is to encapsulate the transaction-level processing logic for contract headers and contract lines that originate from Oracle Purchasing, Order Management, or other feeder systems. In contrast to the public OKL_TRX_CONTRACTS_PUB layer, this PVT package performs the low-level validation, defaulting, locking, and DML operations required to persist and maintain transaction contract records. It is a supporting internal engine invoked by higher-level public APIs and by concurrent programs rather than by end users directly, which is why its status remains VALID but its procedures are not surfaced as public entry points. The package is documented in ETRM 12.2.2 and its lineage is compatible with 12.1.1, where the same architectural split between public and private APIs is observed. Dependency metadata confirms the package is consumed by 28 other database objects, underlining its central role in the transaction-contract processing chain.

Key Procedures and Functions

The documented interface exposes 23 procedures and functions, including the following transaction-oriented entry points:

Each routine follows the standard ETRM pattern of calling OKL_API for error handling, OKC_API for core contract services, and OKL_ACCOUNTING_UTIL for accounting event preparation.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

  • OKL_TRX_CONTRACTS — Stores transaction contract headers; the primary DML target.
  • OKL_TXL_CNTRCT_LNS — Stores transaction contract lines associated with each header.
  • OKL_K_HEADERS — Provides the contract header supporting data structure used during creation and validation.
  • OKL_PRODUCTS and OKL_PDT_QUALITYS — Supply product and product-quality validation data for contract lines.
  • OKL_PROD_QLTY_VAL_UV — A validation view used to confirm product/quality combinations.
  • OKL_STRM_TYPE_B — Stream type definitions used for contract term setup.
  • GL_LEDGERS — Supplies ledger context for accounting-related processing.
  • PLITBLM — A standard PL/SQL table type used internally for bulk collections.

Usage Notes

OKL_TRX_CONTRACTS_PVT is not designed for direct invocation from forms or custom reports. It is called internally by the ETRM transaction contract generation flow, typically triggered from Purchasing or Order Management when lease or financing terms must be captured. Concurrent programs that import or interface lease transactions also invoke these routines through the public API layer. Custom extensions should route calls through OKL_TRX_CONTRACTS_PUB to preserve validation and locking semantics, and any direct use of the PVT layer must respect the LOCK-then-UPDATE sequencing to avoid concurrency conflicts.