Results for “okl_oin_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_OIN_PVT is a private PL/SQL package body in the APPS schema that implements the persistence and validation layer for Oracle Lease and Finance Management open interest records. The package operates over the OKL_OPEN_INT table, which stores open-interest basis and accrual information attached to lease contracts and their associated streams. It is an implementation package (API classification PVT) rather than a public interface: callers are expected to reach open-interest functionality through the corresponding public wrapper package, while OKL_OIN_PVT performs the row-level DML, concurrency control, validation, and exception handling behind that interface.

The package is heavily dependent on the ETRM and common application infrastructure. Documented dependencies include FND_API and FND_MSG_PUB for the standard API return-status and message-stack conventions, FND_GLOBAL for session context, APP_EXCEPTIONS for error handling, OKC_API and OKC_P_UTIL for the Oracle Contracts foundation layer, and OKL_API for Lease Management error constants and utilities. The body is valid in both Oracle EBS 12.1.1 and 12.2.2 on the ETRM 12.2.2 code line.

Key Procedures and Functions

Documentation lists 18 procedures and functions in the package, of which the following are identified by name. All follow the multi-row, message-stack API pattern typical of ETRM, generally accepting and returning values through the standard API parameter set rather than individual positional arguments.

• INSERT_ROW — Creates a new row in the open interest table, populating the mandatory and dependent columns and returning the generated identifier to the caller.
• UPDATE_ROW — Modifies an existing open interest row. Concurrency is protected by the caller-supplied object version number, so an update against a stale version is rejected.
• DELETE_ROW — Removes an open interest row or logically terminates it, depending on the retention rules applied by the parent transaction.
• LOCK_ROW — Acquires a row-level lock and validates the expected version number before a dependent DML operation proceeds.
• VALIDATE_ROW — Applies business validation rules to a proposed record so that errors are collected on the message stack before any write occurs.
• CHANGE_VERSION — Advances the object version number as part of a successful insert, update, or delete, supporting optimistic locking.
• QC — Performs the quantity/quality consistency check that reconciles open interest figures against the contract's stream data.
• API_COPY — Copies open interest records from a source entity to a target entity, supporting version, template, and assumption duplication flows.

Tables Accessed

The package accesses OKL_OPEN_INT through its APPS synonym. This is the primary store for open interest amounts and their accrual attributes and is the only business table directly documented as referenced. DUAL appears in scalar lookups and SYS_CONTEXT-style evaluations, and PLITBLM is the standard PL/SQL integer-indexed table type used for internal collection handling. All references are resolved through APPS synonyms, so no direct schema qualification is required.

Usage Notes

OKL_OIN_PVT is not referenced by any other database object in the reverse-dependency view, confirming its private status; instead it references the public wrapper OKL_OIN_PVT and the OKL_OPEN_INT table. It is invoked from Lease Management forms and concurrent processes indirectly, through the public open interest API, and should not be called directly by custom code. Customizations that require open interest maintenance should use the supported public package so that validation, message-stack handling, and version control remain intact.