Search Results okl_trn_seq

Overview

OKL_TAS_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Lease Management (OKL) Transaction Asset handling framework. In the ETRM (Enterprise Transaction Resource Management) architecture the package is classified as a PVT (private) package, meaning its procedures are not intended as public APIs. Instead, they are invoked by higher-level public packages such as OKL_API, OKC_API, and other OKL modules that manage transaction assets associated with lease contracts. The package encapsulates the row-level logic — insert, update, delete, lock, validate, and copy — required to persist and maintain records in the OKL_TRX_ASSETS table, along with supporting sequence and transaction-type lookups. Because it is a private body, the package serves as an internal implementation layer that keeps the public API surface stable while concentrating business logic in a reusable module.

Key Procedures and Functions

The documented procedures and functions (13 total entities, with eight named) include:

• QC — a quality-control/consistency check routine, typically performing internal validation and cleanup of the package state or dependent records.
• CHANGE_VERSION — increments or resets the version indicator on a transaction asset record, supporting optimistic concurrency and audit versioning.
• API_COPY — copies transaction asset rows, enabling duplication of asset allocations when cloning or reusing lease transactions.
• INSERT_ROW — performs the physical insert of a new OKL_TRX_ASSETS record, invoking defaults and validations.
• LOCK_ROW — issues a SELECT ... FOR UPDATE against the target row to serialise concurrent updates.
• UPDATE_ROW — persists modifications to an existing transaction asset row.
• DELETE_ROW — removes a transaction asset row, subject to validation and referential checks.
• VALIDATE_ROW — applies business rules against attributes prior to insert, update, or delete.

These procedures are orchestrated by the public OKL_API and OKC_API entry points rather than called directly by forms or reports.

Tables Accessed

The package references the following database objects through APPS synonyms: OKL_TRX_ASSETS, the primary transaction asset table holding asset-level allocations tied to a lease transaction; OKL_TRN_SEQ, the transaction sequence source used to derive unique transaction numbers for new records (the object matching the search term "okl_trn_seq"); OKL_TRX_TYPES_B, the transaction type base table used to validate the type classified on an asset row; PLITBLM, the standard PL/SQL table-type library used for in-memory collections; and DUAL for scalar expressions. Additional dependencies include HR_OPERATING_UNITS, OKX_CUSTOMER_ACCOUNTS_V, and shared utility packages OKC_P_UTIL, OKC_UTIL, OKL_LEGAL_ENTITY_UTIL, FND_API, FND_GLOBAL, and APP_EXCEPTIONS.

Usage Notes

OKL_TAS_PVT is not referenced by any database object, confirming its classification as an internal implementation package invoked at runtime by its 42 dependent packages, most notably OKL_API and OKC_API. It is typically reached indirectly: when a user creates or updates transaction assets in the Lease Management Forms, or when concurrent programs process lease transactions, the public API delegates row maintenance to this private package. Custom code should never call OKL_TAS_PVT directly; integrators should use the documented public OKL_API procedures, which in turn route to INSERT_ROW, UPDATE_ROW, DELETE_ROW, VALIDATE_ROW, LOCK_ROW, CHANGE_VERSION, API_COPY, and QC. Because OKL_TRN_SEQ is consumed here, any customisation that manipulates transaction numbering must respect the sequence access performed within this package to avoid duplicate or skipped transaction identifiers. The package is valid across both 12.1.1 and 12.2.2, and its behaviour is consistent with standard ETRM transaction asset processing.