Search Results send_terminate_quote




Overview
Explore in AI Chat

Overview

OKL_CS_CREATE_QUOTE_PVT is a private PL/SQL package in the Oracle E-Business Suite (EBS) Lease Management / ETRM (Enterprise Territory and Revenue Management, here in the Oracle Lease and Finance Management context) module. It resides in the APPS schema and is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking user rather than the definer. The package header identifies a $Header revision of OKLRCTQS.pls 115.3, indicating a long-standing internal component of the Oracle Lease Management quoting infrastructure.

The package performs the server-side work needed to create, validate, and manage terminate quotes — quotations used when an existing lease or contract is being terminated early. It coordinates the assembly of quote header/line records, association data, and quote party records, and it exposes a helper to derive the parties governed by quoting rules. Because it is classified as a PVT (private) API, it is intended for internal consumption by other EBS packages and forms rather than being a supported public interface for customer extension.

Key Procedures and Functions

Four documented procedures are exposed in the package specification:

  • CREATE_TERMINATE_QUOTE — The primary driver procedure. It accepts quote table records, association records, and quote party records, and returns the resulting quote table, terminate quote line table, and association table. It is the entry point for building a terminate quotation within the quoting engine.
  • FETCH_RULE_QUOTE_PARTIES — Accepts quote table records and returns quote party table records plus a party user-view table and a record count. It is used to resolve which parties apply to a quote based on business rules, returning that set to the caller for further processing.
  • SUBMIT_FOR_APPROVAL — Accepts a terminate quote table and returns the same table after submission. It transitions a terminate quote into the approval workflow/queue so that the required authorization can be obtained before the quote takes effect.
  • SEND_TERMINATE_QUOTE — The procedure associated with the search term "send_terminate_quote". It takes quote party table records and is responsible for dispatching or transmitting the terminate quote to the relevant parties (for example, generating the communication that accompanies a termination quotation). Full parameter details beyond the party table are truncated in the documented header excerpt.

The package also relies on subtype definitions drawn from OKL_QTE_PVT.qtev_tbl_type, OKL_QUOTE_PARTIES_PUB.qpyv_tbl_type, and the association and terminate-quote-line table types defined in OKL_AM_CREATE_QUOTE_PUB, reflecting its integration with the broader Oracle Lease Management quoting API family.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed via an APPS synonym. In Oracle Lease Management, PLITBLM is a standard multi-organization / descriptive-flex infrastructure table used to hold descriptive and reference data. The package's procedural logic additionally operates over the quote, quote party, and association structures surfaced through the OKL_QTE_PVT, OKL_QUOTE_PARTIES_PUB, and OKL_AM_CREATE_QUOTE_PUB API families; these are passed as PL/SQL table types rather than accessed as base tables directly within this package's documented interface.

Usage Notes

As a PVT-classified API, OKL_CS_CREATE_QUOTE_PVT is not intended for direct customer invocation. It is referenced by one other package in the EBS codebase and is most commonly driven from the Oracle Lease Management quoting forms and the quotation concurrent programs that handle terminate quote creation, approval submission, and party notification. Customizations should invoke the supported public APIs (for example, the OKL_AM_CREATE_QUOTE_PUB family and the quote party public packages) rather than calling this private package directly, since its signature is subject to change without notice. When troubleshooting the "send_terminate_quote" flow, this package is the correct diagnostic starting point for understanding how terminate quote party records are assembled and dispatched.