Search Results okl_am_create_quote_pub_w




Overview
Explore in AI Chat

Overview

The APPS.OKL_AM_CREATE_QUOTE_PUB_W package is a public PL/SQL API belonging to the Oracle E-Business Suite Enterprise Trading and Risk Management (ETRM) module, also marketed as Oracle Lease and Finance Management. It resides in the APPS schema and carries a status of VALID across the EBS 12.1.1 and 12.2.2 code lines. Its object name — combining the OKL application prefix with "AM" (Asset Management / authoring), "CREATE", "QUOTE", and the "_PUB_W" suffix denoting a public wrapper — indicates that it exposes quote-generation and contract-search functionality as a callable interface for external consumers such as forms, concurrent programs, and custom integrations.

The package is classified in ETRM documentation as an OTHER API, meaning it is not a standard interface-table-driven open interface but rather a utility wrapper that other application components invoke directly. It is designed to accept data in bulk through PL/SQL collection types while relying on the FND_API framework for standardized return-status handling and error messaging.

Key Procedures and Functions

ETRM 12.2.2 documentation identifies two public procedures within this package:

  • ADVANCE_CONTRACT_SEARCH — Supports the retrieval and filtering of contract records, allowing a caller to search the lease/loan contract population and advance through a result set. This is typically used to identify a source contract against which a quote or termination action can subsequently be performed.
  • CREATE_TERMINATE_QUOTE — Creates a quote associated with the early termination of a contract. The procedure generates the quote record that captures the financial terms required to terminate or buy out an existing agreement, forming part of the ETRM quotation lifecycle.

Documentation does not publish the formal parameter lists for these procedures; callers should inspect the package specification in the database (for example, via ALL_ARGUMENTS) before invoking them programmatically.

Tables Accessed

The dependency metadata records the collection and framework types used by the package rather than individual application tables. These include FND_API for the standard API return-status and message conventions, and the JTF collection types JTF_VARCHAR2_TABLE_100, _200, _400, _500, _600, _2000, JTF_NUMBER_TABLE, and JTF_DATE_TABLE. These strongly typed PL/SQL tables allow the API to accept and return multi-row data sets — such as arrays of contract identifiers, dates, and quoted amounts — in a single call. The underlying OKL lease and quote tables are referenced indirectly through APPS synonyms in the package body; the excerpt does not enumerate them, so specific table names should be confirmed by inspecting the source in the database.

Usage Notes

The package is intended for internal or custom invocation rather than exposure through a seeded concurrent program. It is most commonly called from ETRM quote and termination forms, from custom concurrent programs that batch-generate termination quotes, or from bespoke PL/SQL integrations that need to search contracts and produce quotes programmatically. Callers should always check the FND_API return status (x_return_status) and inspect the associated message table for validation errors, and should initialize the JTF collection types with the appropriate row identifiers before passing them. Because the package is documented as being referenced by no other packages, it does not participate in a larger dependency chain within the shipped code, which reinforces its role as a leaf-level public wrapper. As with all APPS-owned APIs in EBS 12.1.1 and 12.2.2, direct modification is not supported; any customization should wrap the public procedures.