Search Results okl_am_termnt_interface_pvt




Overview
Explore in AI Chat

Overview

OKL_AM_TERMNT_INTERFACE_PVT is a private PL/SQL package in the APPS schema that forms part of the Oracle Lease and Finance Management (OKL) application within Oracle E-Business Suite 12.1.1 and 12.2.2. The package name follows the ETRM naming convention in which the AM component denotes asset management functionality and the PVT suffix designates the package as a private implementation unit. Its purpose is to support the termination interface processing that transfers contract termination data from external or staging sources into the OKL termination tables. By encapsulating this logic in a private package, Oracle exposes a controlled public wrapper, OKL_AM_TERMNT_INTERFACE_PUB, which is the only documented caller of this package. This design prevents direct invocation of the underlying insertion and validation logic by external code, preserving data integrity across the termination lifecycle.

Key Procedures and Functions

The documented package metadata lists a single procedure, TERMINATION_INTERFACE. This procedure constitutes the core work unit of the package. It is responsible for driving the termination interface process, which involves reading incoming termination records, validating them against existing contract and party data, and populating the OKL termination interface tables so that downstream termination processing can consume the staged rows. No parameter list is documented in the ETRM metadata, and parameter details should not be assumed. Consistent with the private API classification, the procedure is intended to be called from within the OKL codebase rather than directly by customer extensions.

Tables Accessed

The package operates against a documented set of tables referenced through APPS synonyms:

  • OKL_TERMNT_INTERFACE — the primary termination interface (staging) table, which receives the terminated contract records assembled by the interface procedure.
  • OKL_TERMNT_INTF_PTY — the termination interface party table, holding party-level details associated with each staged termination record.
  • HZ_PARTIES — the Trading Community Architecture party master, consulted to validate and resolve customer, lessee, and guarantor identities referenced by incoming termination data.
  • OKC_K_HEADERS_B — the core contracts header table, used to validate that each termination record corresponds to an existing, eligible contract.
  • OKC_K_PARTY_ROLES_B — the contract party roles table, used to resolve role assignments such as lessee and lessor for the contract being terminated.
  • DUAL — the standard single-row utility table used for scalar evaluations and sequence or constant retrieval within PL/SQL.
  • PLITBLM — the standard PL/SQL integer table type used for in-memory collections during batch processing.

Usage Notes

Because OKL_AM_TERMNT_INTERFACE_PVT is a PVT (private) package, it is not intended for direct invocation by forms, concurrent programs, or customer-written code. It is referenced by its public counterpart, OKL_AM_TERMNT_INTERFACE_PUB, which serves as the sanctioned entry point and may itself be invoked from the OKL termination user interface, from concurrent programs that import termination data, or from integration code. The package also references the public OKC_API and the OKL termination interface tables documented in its dependency list. Customizations that need to extend or trigger termination interface behavior should target the public package or the underlying interface tables rather than the private package, so that the supported interface contract is preserved. When troubleshooting termination imports in EBS 12.1.1 or 12.2.2, DBAs commonly inspect this package's body to trace how staged rows are validated and inserted, but any modification should be treated as an unsupported customization.