Search Results submit_quotes




Overview
Explore in AI Chat

Overview

IBE_ONECLK_PVT is a private PL/SQL package in the Oracle iStore (IBE) application module. It supports the "One-Click" quotation capability within Oracle EBS, a feature that enables customers to convert an online shopping or configuration session into a formal sales quotation with minimal manual entry. The package is classified as PVT (private) in the ETRM metadata, indicating it is intended for internal use by Oracle's iStore and Order Capture frameworks rather than as a public, customer-callable API.

The package header is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner. This is a deliberate security posture: the package acts on behalf of the connected user, which is appropriate for a utility that manipulates quoting data during an interactive iStore session. The header comment ($Header: IBEVOCPS.pls 115.9 2002/12/13) indicates the source file name is IBEVOCPS.pls and that the last shipped version was 115.9, dating the core logic to the Oracle 11i era. Despite this vintage, the package remains present in EBS 12.1.1 and 12.2.2, consistent with Oracle's practice of retaining stable iStore utilities across release boundaries.

Key Procedures and Functions

The ETRM metadata documents a single procedure:

  • SUBMIT_QUOTES — The sole documented entry point. It is defined with errbuf OUT NOCOPY VARCHAR2 and retcode OUT NOCOPY NUMBER parameters, a signature that conforms to the standard Oracle concurrent program / host-callable interface convention. The procedure's purpose is to persist quoted line information captured during a one-click session into the Oracle Quoting data model, thereby creating or updating the corresponding quote entities. The presence of the standard errbuf/retcode pair suggests the procedure may be registered as, or invoked from, a concurrent program, although the metadata classifies the package as PVT rather than as a documented public API.

No additional procedures or functions are documented for this package in the ETRM extract. No parameter lists beyond those shown in the source excerpt should be assumed.

Tables Accessed

The package operates against the following documented tables, resolved through APPS synonyms:

  • ASO_QUOTE_HEADERS — The Oracle Quoting header table. SUBMIT_QUOTES reads and writes this table to create or update the quote header record that represents the top-level quotation generated by the one-click process.
  • ASO_QUOTE_HEADERS_ALL — The multi-organization (MLS/org-striped) variant of the quote header table. Access here supports operation across operating units and language installations, ensuring the quotation is visible in the correct organizational and linguistic context.
  • IBE_ORD_ONECLICK — An iStore table that stores one-click order and quotation staging data captured during the online session. SUBMIT_QUOTES consumes this staging data and maps it into the ASO quoting tables, forming the bridge between the iStore storefront and the Quoting schema.

Together these tables establish a clear data flow: one-click session data (IBE_ORD_ONECLICK) is transformed and written into Oracle Quoting headers (ASO_QUOTE_HEADERS / ASO_QUOTE_HEADERS_ALL).

Usage Notes

The ETRM metadata records that IBE_ONECLK_PVT is referenced by zero other packages, indicating it is not embedded in a documented package-to-package call hierarchy. Its private (PVT) classification means it is not a supported integration point for customer extensions. Invocation typically originates from the iStore one-click quotation flow, where a customer or storefront process triggers submission of a quote from the online session. Because the procedure exposes the conventional errbuf/retcode out parameters, it can be wrapped in a concurrent program definition or called from custom PL/SQL that emulates the standard concurrent interface, but such use falls outside Oracle's documented public API surface.

Consultants encountering this package should treat it as an internal iStore utility whose behavior is tied to the storefront configuration. Any debugging or extension effort should first confirm that the one-click feature is enabled and that IBE_ORD_ONECLICK is being populated, since SUBMIT_QUOTES depends on that staging data being present.