Search Results okl_adj_pvt




Overview
Explore in AI Chat

Overview

OKL_ADJ_PVT is the private API package body for the Oracle Lease and Finance Management (OKL) module in Oracle E-Business Suite, classified under the PVT (private) API tier. It encapsulates the core database manipulation logic for contract adjustment records, which represent changes applied to an existing lease or loan contract such as rate adjustments, term changes, or billing modifications. The package serves as the internal implementation layer that supports the public OKL adjustment APIs, enforcing business rules, validating adjustment data, and maintaining the integrity of adjustment status records across the OKL_TRX_AR_ADJSTS tables. The package retains a VALID status in the APPS schema and is documented under ETRM for both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented procedure and function set reflects a standard Oracle EBS private API implementation pattern. QC is a quality-control routine used to verify package integrity. CHANGE_VERSION manages optimistic locking by advancing the object version number to prevent concurrent update conflicts. API_COPY duplicates an existing adjustment record. ADD_LANGUAGE inserts translated description rows into the language-specific table, supporting multi-language deployments. INSERT_ROW creates a new adjustment record, while UPDATE_ROW modifies an existing one. DELETE_ROW removes an adjustment record. LOCK_ROW selects and locks a record for update to serialize concurrent transactions. VALIDATE_ROW applies the business validation rules that govern adjustment eligibility and consistency before a row is committed. All procedures follow the FND_API error-handling convention, returning status codes and raising exceptions through APP_EXCEPTIONS and OKL_API.

Tables Accessed

Through APPS synonyms, the package reads and writes the adjustment status base table OKL_TRX_AR_ADJSTS_B and its translation counterpart OKL_TRX_AR_ADJSTS_TL, with the _ALL_B variant providing the multi-organization view. It references OKL_TRX_AR_INVOICES_B to associate adjustments with lease invoices, OKL_TRX_CONTRACTS to anchor adjustments to their parent contract, and OKL_TRX_TYPES_B for transaction type validation. FND_LANGUAGES supplies installed-language data for the ADD_LANGUAGE routine, while DUAL and PLITBLM support internal SQL and PL/SQL table operations.

Usage Notes

OKL_ADJ_PVT is a private package and is not intended for direct invocation by end users or custom code. It is called internally by the corresponding public OKL adjustment API and is referenced by seven other packages within the OKL application. Typical invocation occurs through the lease adjustment forms, concurrent programs that process batch adjustments, and upstream public APIs performing contract modifications. Customizations should target the public API layer rather than OKL_ADJ_PVT to preserve upgrade integrity. Because it depends on FND_API, OKL_API, OKC_API, and OKL_TRX_AR_ADJSTS_ALL_B, any customization must account for the standard EBS dependency chain.