Search Results okl_tpl_pvt




Overview
Explore in AI Chat

Overview

OKL_TPL_PVT is a private PL/SQL package body in the APPS schema within the Oracle E-Business Suite Lease Management (OKL) module, part of the Oracle Enterprise Asset Management / Contracts family delivered under the ETRM (Enterprise Transaction and Reference Model) documentation set. In Oracle EBS 12.1.1 and 12.2.2, the package supports the "TPL" (Third-Party Lease / Third-Party Liability) processing area, providing the underlying transactional logic for creating, maintaining, and validating third-party invoice line data associated with lease contracts. The private ("PVT") API classification indicates the package is intended for internal use by other OKL packages and forms rather than as a public integration API. It leverages the Oracle Contracts (OKC) and Lease (OKL) public APIs, FND message and global utilities, and Multi-Org/multi-language infrastructure to keep third-party invoice records consistent with lease stream elements and tax codes.

Key Procedures and Functions

The documented package exposes fourteen procedures and functions, of which the following nine are individually named in the metadata:

  • QC – Quality-control / consistency check routine that verifies the internal coherence of the third-party invoice line record before or after a DML operation.
  • CHANGE_VERSION – Manages the version/sequence control for a row, enabling optimistic-locking or change-tracking semantics.
  • API_COPY – Copies rows (and related language rows) between records, used when duplicating third-party invoice lines.
  • ADD_LANGUAGE – Inserts translated (TL) rows into OKL_TXL_AP_INV_LNS_TL for the requested language.
  • INSERT_ROW – Performs the actual insert into the base table OKL_TXL_AP_INV_LNS_B, applying defaults, WHO columns, and validation.
  • LOCK_ROW – Issues the SELECT ... FOR UPDATE used by callers before modifying a third-party invoice line.
  • UPDATE_ROW – Applies modifications to an existing base row.
  • DELETE_ROW – Removes base and translated rows.
  • VALIDATE_ROW – Executes attribute-level validation, raising OKL_API / FND_API errors for invalid data.

The remaining five documented procedures follow the standard OKL private-package naming pattern (typically create/update helper and wrapper routines) and are invoked internally by the operations above.

Tables Accessed

The package reads from and writes to the following documented objects, all through APPS synonyms:

  • OKL_TXL_AP_INV_LNS_B – primary base table for third-party AP invoice lines; this is the main DML target.
  • OKL_TXL_AP_INV_LNS_TL – translation table populated by ADD_LANGUAGE and read for language-dependent attributes.
  • OKL_TXL_AP_INV_LNS_ALL_B – consolidated/"_ALL" view or table used by validation and query logic.
  • OKL_TRX_AP_INVOICES_B – parent AP invoice header, accessed to inherit invoice context and currency.
  • OKL_TXD_AR_LN_DTLS_B – receivable line details, referenced when reconciling third-party AP lines to AR entries.
  • OKL_STRM_ELEMENTS – lease stream elements, used to keep third-party lines aligned with the contractual payment schedule.
  • FND_LANGUAGES – supplies installed-language information for ADD_LANGUAGE.
  • DUAL and PLITBLM – utility/PL/SQL table access.

Additionally, the package calls OKC_API, OKC_P_UTIL, OKL_API, OKL_UTIL, FND_API, FND_GLOBAL, and APP_EXCEPTIONS, and selects from the OKL_CNSLD_AR_STRMS_V, OKL_K_LINES_V, OKL_STRM_TYPE_V, OKL_TXL_AP_INV_LNS_V, and OKX_TAX_CODES_V views for stream, line-type, and tax-code lookups.

Usage Notes

Because OKL_TPL_PVT is classified as a private API and is referenced by eighteen other database objects but references no public API outward, it is normally invoked indirectly: by the Lease Management third-party invoice forms, by concurrent programs that process third-party AP/AR reconciliation, or by other OKL_* packages such as data-migration and consolidate-stream routines. Custom code should call the public OKL APIs rather than this body wherever possible, since the procedure signatures and semantics are not frozen for external use. When extending or troubleshooting third-party invoice line behavior in 12.1.1 or 12.2.2, enable FND debug via OKL_API and trace through INSERT_ROW, UPDATE_ROW, VALIDATE_ROW, and QC, which provide the audit path for row-level operations.