Search Results ibe_quote_w1_pvt




Overview
Explore in AI Chat

Overview

IBE_QUOTE_W1_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle iStore (IBE) product family and forms part of the server-side infrastructure that supports the quote-to-order flow within the iStore storefront. The W1 suffix and the PVT classification indicate that this is an internal, private API layer: the procedures it exposes are wrappers intended to be called by sibling public packages rather than directly by external application code or end users. In EBS 12.1.1 and 12.2.2 the package is registered as VALID in the data dictionary, confirming that it is a supported component of the shipped application.

The package encapsulates the logic that bridges storefront cart activity and the quoting engine, including the transformation of a shopping cart into a persistent quote, the submission of that quote for downstream processing, and the reconfiguration of existing quotes when the underlying model configuration changes. Because it is a private package, its primary role is to isolate volatile implementation details from the public iStore APIs.

Key Procedures and Functions

The ETRM documentation records five entry points in this package. Their purposes are as follows:

  • MERGEACTIVEQUOTEWRAPPER — consolidates or merges the currently active quote for a storefront session, ensuring that duplicate or superseded quote records are reconciled before further processing.
  • SAVEWRAPPER — persists the current quote state, writing the accumulated cart and quote lines so that the quote survives session interruption or navigation.
  • SUBMITQUOTEWRAPPER — submits a completed quote for downstream order or approval processing, transitioning it out of the editable draft state.
  • ADDMODELSTOCARTWRAPPER — adds configured models (and their associated option classes and components) into the storefront cart as quote lines.
  • RECONFIGURE_FROM_IB_WRAPPER — rebuilds a quote from an existing configuration originating in Oracle iStore/Configurator, supporting reconfiguration of previously quoted items.

Each procedure is a thin wrapper; the naming convention confirms that the substantive business logic resides in the underlying public API layer, with these routines handling parameter marshalling and invocation context.

Tables Accessed

According to the documented metadata, the package accesses the table PLITBLM through an APPS synonym. PLITBLM is a PL/SQL index-by table type definition (a numeric table), not a physical application table; it is used internally for bulk collection handling within PL/SQL calls. No persistent application tables are recorded as directly referenced by this package, which is consistent with its wrapper role — the actual inserts and updates to quote, cart, and line tables are performed by the public APIs that this package delegates to.

Usage Notes

IBE_QUOTE_W1_PVT is invoked indirectly. The dependency record shows the package referencing FND_API (the Oracle Application Object Library API framework) and a family of JTF_* collection types (JTF_DATE_TABLE, JTF_NUMBER_TABLE, and the JTF_VARCHAR2_TABLE variants), which are the standard Oracle EBS mechanisms for passing multi-row parameters into APIs. It is referenced by its own package body and, per the documented metadata, by no other packages directly.

In practice, this means the package is called from the iStore quote and cart processing flow during runtime user actions — adding a configured model to a cart, saving a quote, submitting an order from a quote, or reconfiguring an item. It is not exposed as a standalone concurrent program and should not be called from custom code; developers extending iStore functionality should use the corresponding public IBE APIs, which in turn invoke these private wrappers. Because it is a private package, its signature may change between patch levels, so direct invocation from customizations is not supported.