Search Results record_number




Overview
Explore in AI Chat

Overview

The APPS.OKL_AM_TERMNT_INTERFACE_PVT package body is a private (PVT) PL/SQL implementation unit within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It supports the asset termination lifecycle by processing lease and asset termination records staged in the OKL termination interface tables and converting them into quote-related transactions. In the context of ETRM 12.1.1 and 12.2.2, this package acts as the engine behind the termination interface, orchestrating validation, quote creation, and error logging for termination transactions that have been loaded via external or batch sources.

The package body defines a rich set of local subtypes and record structures that mirror the public APIs of related OKL packages, including OKL_TRX_QUOTES_PUB, OKL_AM_CREATE_QUOTE_PUB, OKL_TXL_QUOTE_LINES_PUB, and OKL_QUOTE_PARTIES_PUB. This architecture allows the termination interface to assemble quote headers, lines, parties, and termination quote details programmatically before persisting them. The internal record types log_rec_type, log_msg_rec_type, and error_message_type indicate that the package performs structured logging for validation, processing, and error outcomes, preserving traceability for each interface row.

Key Procedures and Functions

The package exposes a single documented procedure, TERMINATION_INTERFACE. This procedure drives the core processing of termination interface records. It reads staged termination data, resolves associated contract and asset context, constructs the necessary quote structures, and invokes the appropriate quote creation APIs. It also populates the validation, processing, and error log collections declared at package level (val_log_tbl, pro_log_tbl, err_log_tbl and their associated message tables), enabling downstream diagnostics of each transaction. Parameter lists are not enumerated here, as the documented metadata does not define them.

Tables Accessed

The package references several tables through APPS synonyms:

  • OKL_TERMNT_INTERFACE — the primary staging table holding termination interface header rows, including transaction number, contract number, asset number, effective date, quote type, and quote reason.
  • OKL_TERMNT_INTF_PTY — stores party-related termination interface information used to build quote party records.
  • HZ_PARTIES — the Trading Community Architecture party master, used to resolve and validate party identities associated with termination transactions.
  • OKC_K_HEADERS_B — the contract headers base table, accessed to validate and retrieve contract context for the termination.
  • OKC_K_PARTY_ROLES_B — contract party roles base table, used to resolve role assignments for parties on the contract.
  • DUAL — used for single-row PL/SQL evaluations and date/number derivations.
  • PLITBLM — the standard PL/SQL table (index-by table) helper, consistent with the package's in-memory table processing.

Usage Notes

OKL_AM_TERMNT_INTERFACE_PVT is a private package and is not intended for direct invocation by end users or external integrations. It is referenced by one other package, which serves as the public entry point for termination interface processing. Typical invocation paths include:

  • Concurrent programs that batch-process termination interface records loaded from external systems.
  • Oracle Forms or OAF-based termination entry screens that trigger the public wrapper, which in turn calls this private package.
  • Custom extensions that must repurpose termination interface logic, though these should call the public wrapper rather than the private body.

Because the package writes log records keyed by transaction_number and related header attributes such as contract_number, asset_number, and quote_number, administrators commonly query the termination interface log tables to investigate failures. The record_number search term frequently surfaces when users inspect the interface log output to correlate individual staged rows with their processing results and error messages.