Search Results save_share_v2_wrapper

Overview

IBE_QUOTE_W2_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, shipped under the Oracle iStore / Oracle Quoting (IBE) product family. Its name follows Oracle's standard "PVT" (private) naming convention, indicating that it is an internal implementation package intended to be called by other packages rather than directly by end users or external integrations. The package declares AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking schema rather than the defining schema. The header comment identifies the source file as IBEVQW2S.pls and its last revision as 2010/12/13, placing the code within the R12 (12.1.1 and 12.2.2) code line.

Functionally, this package supports the "Save and Share" processing flow of Oracle Quoting. This flow persists a quote header, its lines, and its associated pricing and cart context, and then shares the resulting quote with one or more parties. The package acts as a wrapper layer that standardizes the JTF/FND API calling conventions—such as API version number, initialization message list, and commit flag—before delegating the actual business logic to lower-level quote and pricing routines.

Key Procedures and Functions

The ETRM metadata documents a single procedure in this package:

• SAVE_SHARE_V2_WRAPPER — The packaged entry point that drives the Save and Share version 2 process for a quote. It accepts a broad set of parameters organized into groups: standard API control arguments (API version number, initialization message list, and commit flag); pricing and versioning controls such as p_c_auto_version_flag, p_c_pricing_request_type, p_c_header_pricing_event, p_c_line_pricing_event, p_c_cal_tax_flag, and p_c_cal_freight_charge_flag; a pricing mode argument that defaults to ENTIRE_QUOTE to govern line-level competitive pricing logic; and shopping-cart controls including p_ssc_delete_source_cart, p_ssc_combinesameitem, p_ssc_operation_code, and p_ssc_deactivate_cart. A parallel set of p_q_* parameters carries the quote header attributes—quote header id, audit columns (creation_date, created_by, last_updated_by, last_update_date, last_update_login), concurrent program context columns (request_id, program_application_id, program_id, program_update_date), org_id, and quote attributes such as name, number, version, status, source code, and expiration date.

No other procedures or functions are documented for this package.

Tables Accessed

The ETRM metadata records one referenced table, accessed through an APPS synonym: PLITBLM. PLITBLM is a standard EBS date/character/number conversion table used by JTF/FND API message and validation utilities. Its presence indicates that the wrapper performs validation and value-conversion steps—for example, translating and validating the many FND_API.G_MISS_* sentinel defaults—before handing control to the underlying Save and Share quote logic. The actual persistence of quote headers, quote lines, and cart records is performed by the lower-level quote and pricing packages that this wrapper calls, not directly by IBE_QUOTE_W2_PVT.

Usage Notes

Because this is a private ("PVT") package, it is not intended as a public integration API. It is typically invoked indirectly through the Oracle Quoting and Oracle iStore "Save and Share" user flows in the Quote and Cart forms, or by other IBE packages that orchestrate quote sharing. The ETRM metadata states that this package is referenced by zero other packages, which suggests its callers are application modules (such as Oracle Forms or the internal quote-processing stack) rather than sibling PL/SQL packages tracked in the same repository. The p_c_price_mode default of ENTIRE_QUOTE and the cart-control parameters indicate that callers may override behavior to limit pricing to changed lines or to control source-cart deletion and deactivation. As with any private package, customizations should avoid calling it directly; the supported approach is to call the corresponding public API. Available in Oracle EBS Release 12.1.1 and 12.2.2.