Search Results okl_setuptqualitys_pvt




Overview
Explore in AI Chat

Overview

OKL_SETUPTQUALITYS_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle Lease and Finance Management (OKL) setup of transaction quality codes. Within the ETRM (Oracle Enterprise Trade and Revenue Management) module, quality codes classify contracts, quotes, or transactions for accounting, reporting, and pricing purposes. This package provides the internal implementation logic that the public pricing and quality setup APIs (notably OKL_PTL_QUALITYS_PUB) delegate to. It is classified as a PVT package, indicating it is intended for internal use rather than direct invocation by external customers or integration code. It is depended upon by two other packages and depends on several OKL and OKC components, including OKL_API, OKC_API, FND_API, and multiple pricing value views.

Key Procedures and Functions

  • GET_REC — Retrieves a single quality setup record. It queries the underlying quality tables or views (for example, OKL_PTQ_QUALITYS_V) and returns the attributes of a quality definition, typically identified by a primary key or a unique code. GET_REC acts as the internal read accessor used by the calling public API during validation and processing.
  • INSERT_TQUALITYS — Creates a new transaction quality setup record. It validates input via OKL_API and OKC_API calls, resolves defaulting through OKL_PTV_PVT or OKL_PTQ_PVT, and writes the new row to the quality table. It is invoked when users define a new quality code for a lease or finance transaction.
  • UPDATE_TQUALITYS — Modifies an existing quality setup record. It locates the target row (frequently using GET_REC logic), applies the new attribute values, performs validation and referential checks, and commits the change. This supports maintaining quality definitions over their lifecycle.

Only these three documented procedures are exposed; no additional procedures are declared in the metadata.

Tables Accessed

Although no explicit base table list is provided, the dependency information reveals the objects this package reads and writes:

The private package reads and writes the quality setup tables underlying the quality views and uses OKL_PTQ_PVT and OKL_PTV_PVT for value handling and defaulting.

Usage Notes

OKL_SETUPTQUALITYS_PVT is an internal (PVT) package and is not intended for direct invocation by custom code. It is normally invoked indirectly through the public quality API OKL_PTL_QUALITYS_PUB, which wraps these procedures and exposes them to the Lease Management setup forms and concurrent programs. Typical usage includes the Quality Setup window within Oracle Lease Management, where administrators define and maintain quality codes. Use of the package is largely restricted to Oracle internal processing; custom developers should call the public OKL_PTL_QUALITYS_PUB API instead. Because it is not referenced by any database object, changes to intervening APIs require careful regression testing. Both Oracle EBS 12.1.1 and 12.2.2 environments share the same APPS schema ownership and PVT classification.