Search Results okl_transaction_pub




Overview
Explore in AI Chat

Overview

OKL_TRANSACTION_PUB is a public PL/SQL API package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It exposes the transactional operations that underpin the life cycle of lease and loan contracts, allowing external callers to create transactions against a contract, advance or otherwise change the status of an existing transaction, and abandon revision records that are no longer required. The package is classified as a PUB (public) interface within the ETRM architecture, which means its signatures are intended for consumption by other application modules, Oracle Forms, concurrent programs, and customer extensions rather than being restricted to internal processing.

Within the OKL module, contracts are frequently revised to reflect rebooking, restructuring, or renegotiation of terms. Each such change generates transaction and revision records. OKL_TRANSACTION_PUB provides the controlled entry point for manipulating those records while enforcing the validation and consistency rules implemented in the underlying private packages OKL_TRANSACTION_PVT, OKL_TCN_PVT, OKL_TRX_CONTRACTS_PVT, and OKL_API. As a public wrapper, it insulates callers from the internal data structure of the transaction tables and ensures that all business rules are applied consistently.

Key Procedures and Functions

The package documents three procedures:

  • CREATE_TRANSACTION — Creates a transaction record for a lease or loan contract. This is the primary entry point for introducing a new transaction into the system, and it validates the target contract before persisting the transaction.
  • UPDATE_TRX_STATUS — Changes the status of an existing transaction, supporting the progression of a transaction through its defined statuses as processing advances.
  • ABANDON_REVISIONS — Marks contract revisions as abandoned, allowing superseded or cancelled revision records to be set aside while preserving the integrity of the surviving contract version.

The metadata does not enumerate parameter lists for these procedures; callers should obtain the exact signatures from the package specification in the APPS schema before invoking them.

Tables Accessed

The ETRM documentation for this object does not list direct table references; the package operates through APPS synonyms and delegates persistence to the private packages. Based on its dependencies, OKL_TRANSACTION_PUB works with the transaction and revision data structures managed by OKL_TRANSACTION_PVT and OKL_TCN_PVT, and reads contract header information through OKC_K_HEADERS_V, the contract header view from Oracle Contracts (OKC). This means transaction creation and status changes are always evaluated against the associated contract header, ensuring that a transaction cannot be applied to an invalid or inactive contract.

Usage Notes

OKL_TRANSACTION_PUB is referenced by OKL_ACTIVATE_CONTRACT_PUB, indicating that transaction creation and status maintenance form part of the contract activation flow, as well as by its own wrapper OKL_TRANSACTION_PUB_W. The "_W" wrapper is the conventional EBS pattern that adds multi-organization (MOAC) and logging context before delegating to the public package, so callers in a multi-org environment should generally invoke the public package through that wrapper. Typical invocation points include OKL contract setup and maintenance forms, concurrent programs that process contract revisions or rebookings, and custom PL/SQL extensions that need to create transactions programmatically. Because the package encapsulates validation logic in the private layer, direct DML against the underlying transaction tables should be avoided in favor of these documented APIs.