Search Results okl_trx_quotes_pub




Overview
Explore in AI Chat

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

Overview

OKL_TRX_QUOTES_PUB is a public API package within the Oracle E-Business Suite (EBS) Lease Management (OKL) module, part of the Enterprise Transaction and Trade Management (ETRM) product family. It is owned by the APPS schema and carries a status of VALID. The package body encapsulates the business logic that governs transaction-level quote data associated with lease and financing transactions. Quotations represent indicative pricing, residual, and term structures that precede or accompany a formal lease contract, and this package provides the programmatic interface through which those quotation records are created, maintained, and validated within the ETRM data model.

As a public (PUB) classification package, it is intended to be callable by other application modules, concurrent programs, forms, and custom extensions rather than being restricted to internal implementation use. The dependency list confirms its integration role: it references FND_API and FND_MSG_PUB for standardized error handling and message stacking, FND_LOG and OKL_DEBUG_PUB for diagnostics and logging, OKL_API and OKC_API for core lease and contract utilities, and OKL_QTE_PVT for private quotation processing logic. This layering is consistent with the standard EBS API architecture, where a PUBLIC wrapper delegates to a PRIVATE package for validation and DML operations.

Key Procedures and Functions

The package exposes ten documented procedures and functions, of which the following core transaction operations are documented in the ETRM metadata:

  • INSERT_TRX_QUOTES — Creates new transaction quotation records. This is the primary entry point for establishing quote data against a lease or financing transaction, applying entity-level defaults and persistence logic through the underlying private package.
  • LOCK_TRX_QUOTES — Acquires a lock on existing quotation records, typically used to prevent concurrent modification during read-modify-write sequences or before a quotation is converted or committed.
  • UPDATE_TRX_QUOTES — Modifies existing quotation records, supporting changes to quote terms, pricing attributes, or status as negotiations progress.
  • DELETE_TRX_QUOTES — Removes quotation records, subject to any business-rule or referential constraints enforced during processing.
  • VALIDATE_TRX_QUOTES — Performs business validation on quotation data prior to or independent of persistence, returning standardized errors through the FND message framework.

The remaining five documented procedures follow the same naming convention and support auxiliary quotation processing activities. All operations adhere to the consistent API pattern of accepting standard parameter groups, performing validation, and raising errors via FND_MSG_PUB.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed through an APPS synonym. PLITBLM is a standard Oracle tool table (the PL/SQL integer table) used for passing numeric collections between PL/SQL constructs; it is not a business data table. Actual quotation persistence is performed by OKL_QTE_PVT and OKL_API, which write to the underlying OKL transaction quotation entities. Consequently, the substantive read/write activity against business tables occurs indirectly through those dependent packages rather than directly within OKL_TRX_QUOTES_PUB.

Usage Notes

OKL_TRX_QUOTES_PUB is referenced by 23 other database objects, indicating widespread reuse across the ETRM application. It is typically invoked from Lease Management forms and concurrent programs that manage quotation data, and from custom code or extensions requiring programmatic manipulation of transaction quotes. Developers should call the PUBLIC procedures rather than the OKL_QTE_PVT private package directly, since the public layer enforces standardized validation and message handling. Because it is not referenced by any database object (no inbound hard dependencies), it functions as a top-level interface component. Callers should initialize the FND message and global APIs, handle the returned API status, and retrieve errors from the message stack. This package is available and valid on both EBS 12.1.1 and 12.2.2 environments.