Search Results okl_am_create_quote_pub
Overview
OKL_AM_CREATE_QUOTE_PUB is a public PL/SQL package in the APPS schema that belongs to the Oracle E-Business Suite Lease and Finance Management (formerly Oracle Lease Management, OKL) application. It sits within the Asset Management and quote-generation area of the ETRM (Enterprise Transaction and Revenue Management) module family and exposes a supported public API surface for creating and processing lease quotes that involve asset termination, contract settlement, and early buyout scenarios. In the 12.1.1 and 12.2.2 releases the package carries a VALID status and is classified as a PUB (public) API, which indicates that it is intended for supported external invocation by forms, concurrent programs, and customer-written customization code rather than being reserved exclusively for internal package-to-package use.
The package acts as the public entry point over the private implementation package OKL_AM_CREATE_QUOTE_PVT. This public/private split is a standard Oracle Application Framework convention: the _PUB package owns the published signatures and validation flow, while the _PVT package contains the bulk of the business logic. Functionally, the package enables the creation of quotes for terminated or terminated-in-future contracts, allowing users and downstream processes to generate pricing and residual-related quote information that feeds the quoting and pricing engine.
Key Procedures and Functions
The documented API surface of OKL_AM_CREATE_QUOTE_PUB consists of two callable program units:
- ADVANCE_CONTRACT_SEARCH — Supports the search and retrieval of candidate contracts that are eligible for quoting activity, typically in the context of termination, payoff, or advance-related quote generation. It is used to identify the contracts that can be passed forward into the quote creation process.
- CREATE_TERMINATE_QUOTE — The principal procedure that creates a termination-related quote for a given contract. It drives the quote header and line generation logic, invoking pricing, quality plan, and term/quote template processing through the private implementation and supporting packages.
Parameter-level signatures are not reproduced here; callers should consult the package specification in the database for exact argument lists.
Tables Accessed
The documented metadata for this package does not enumerate the underlying base tables directly. The package references other API and PL/SQL layers rather than altering tables inline, and any table access is mediated through those modules. Based on the package's role and its dependencies, it operates on the core Oracle Lease Management quote and contract structures — including quote headers, quote lines, contract headers, and term/termination definitions — via the OKL_API, OKL_QTE_PVT, OKL_QPY_PVT, OKL_TQL_PVT, and OKC_API layers. The OKC_API dependency indicates interaction with Oracle Contracts core tables when the generated quote intersects contract terms.
Usage Notes
OKL_AM_CREATE_QUOTE_PUB is invoked primarily from the Lease Management quote and termination flows, including the corresponding Oracle Forms and any seeded concurrent programs that generate termination or payoff quotes. The package is referenced by six other packages, among them the OKL_AM_CREATE_QUOTE_PUB_W wrapper, OKL_CS_CREATE_QUOTE_PUB, OKL_CS_CREATE_QUOTE_PVT, OKL_AM_TERMNT_INTERFACE_PVT, OKL_CONTRACT_BOOK_PVT, and OKL_CURE_CALC_PVT, confirming that it is a shared dependency within the OKL module rather than an isolated utility.
Custom code should call the _PUB package rather than the _PVT implementation, because the public package is the supported interface and is the object preserved across upgrades. As with all EBS public APIs, callers should initialize the Oracle Application Object Library environment, provide a valid API version number where the specification requires one, and handle the standard return status and message output conventions.
-
PACKAGE: APPS.OKL_AM_CREATE_QUOTE_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_AM_CREATE_QUOTE_PUB, status:VALID,
-
PACKAGE: APPS.OKL_QPY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_QPY_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_AM_CREATE_QUOTE_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_AM_CREATE_QUOTE_PUB, status:VALID,
-
PACKAGE: APPS.OKL_AM_CREATE_QUOTE_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_AM_CREATE_QUOTE_PUB, status:VALID,
-
PACKAGE BODY: APPS.OKL_AM_CREATE_QUOTE_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_AM_CREATE_QUOTE_PUB, status:VALID,
-
PACKAGE: APPS.OKL_QPY_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_QPY_PVT, status:VALID,
-
PACKAGE: APPS.OKL_AM_CREATE_QUOTE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_AM_CREATE_QUOTE_PVT, status:VALID,
-
PACKAGE: APPS.OKL_AM_CREATE_QUOTE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_AM_CREATE_QUOTE_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_CS_CREATE_QUOTE_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_CS_CREATE_QUOTE_PUB, status:VALID,
-
PACKAGE: APPS.OKL_TQL_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_TQL_PVT, status:VALID,
-
PACKAGE: APPS.OKL_TQL_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_TQL_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_CS_CREATE_QUOTE_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_CS_CREATE_QUOTE_PUB, status:VALID,
-
PACKAGE BODY: APPS.OKL_AM_CREATE_QUOTE_PUB
12.1.1
-
PACKAGE BODY: APPS.OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
PACKAGE: APPS.OKL_AM_CREATE_QUOTE_PUB
12.1.1
-
PACKAGE: APPS.OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
PACKAGE: APPS.OKL_QTE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_QTE_PVT, status:VALID,
-
PACKAGE: APPS.OKL_QTE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_QTE_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_CS_CREATE_QUOTE_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_CS_CREATE_QUOTE_PVT, status:VALID,
-
PACKAGE: APPS.OKL_CS_CREATE_QUOTE_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_CS_CREATE_QUOTE_PUB, status:VALID,
-
PACKAGE: APPS.OKL_CS_CREATE_QUOTE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_CS_CREATE_QUOTE_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_AM_TERMNT_INTERFACE_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_AM_TERMNT_INTERFACE_PVT, status:VALID,
-
PACKAGE: APPS.OKL_CS_CREATE_QUOTE_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_CS_CREATE_QUOTE_PUB, status:VALID,
-
PACKAGE: APPS.OKL_CS_CREATE_QUOTE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_CS_CREATE_QUOTE_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_AM_CREATE_QUOTE_PUB_W
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_AM_CREATE_QUOTE_PUB_W, status:VALID,
-
PACKAGE BODY: APPS.OKL_AM_CREATE_QUOTE_PUB_W
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_AM_CREATE_QUOTE_PUB_W, status:VALID,
-
PACKAGE BODY: APPS.OKL_CS_CREATE_QUOTE_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_CS_CREATE_QUOTE_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_AM_TERMNT_INTERFACE_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_AM_TERMNT_INTERFACE_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_CURE_CALC_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_CURE_CALC_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_CURE_CALC_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_CURE_CALC_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_CONTRACT_BOOK_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_CONTRACT_BOOK_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_CONTRACT_BOOK_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_CONTRACT_BOOK_PVT, status:VALID,
-
PACKAGE: APPS.OKL_DEBUG_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKL_DEBUG_PUB, status:VALID,
-
PACKAGE: APPS.OKL_DEBUG_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKL_DEBUG_PUB, status:VALID,
-
APPS.OKL_CS_CREATE_QUOTE_PVT dependencies on OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
APPS.OKL_AM_CREATE_QUOTE_PUB dependencies on OKL_AM_CREATE_QUOTE_PUB
12.1.1
-
APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
APPS.OKL_AM_CREATE_QUOTE_PUB_W dependencies on OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
APPS.OKL_CURE_CALC_PVT dependencies on OKL_AM_CREATE_QUOTE_PUB
12.1.1
-
APPS.OKL_CS_CREATE_QUOTE_PVT dependencies on OKL_AM_CREATE_QUOTE_PUB
12.1.1
-
APPS.OKL_CS_CREATE_QUOTE_PUB dependencies on OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
APPS.OKL_CS_CREATE_QUOTE_PVT dependencies on OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
APPS.OKL_AM_CREATE_QUOTE_PUB dependencies on OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
APPS.OKL_CS_CREATE_QUOTE_PUB dependencies on OKL_AM_CREATE_QUOTE_PUB
12.1.1
-
APPS.OKL_AM_CREATE_QUOTE_PUB_W dependencies on OKL_AM_CREATE_QUOTE_PUB
12.1.1
-
APPS.OKL_CS_CREATE_QUOTE_PUB dependencies on OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
APPS.OKL_CS_CREATE_QUOTE_PVT dependencies on OKL_AM_CREATE_QUOTE_PUB
12.1.1
-
APPS.OKL_CURE_CALC_PVT dependencies on OKL_AM_CREATE_QUOTE_PUB
12.2.2
-
APPS.OKL_CS_CREATE_QUOTE_PUB dependencies on OKL_AM_CREATE_QUOTE_PUB
12.1.1