Search Results duplicate_cart

Overview

IBE_QUOTE_SAVE_PVT is a private PL/SQL package belonging to the Oracle iStore (IBE) application module in Oracle E-Business Suite 12.1.1 and 12.2.2. It performs the persistence and manipulation logic behind the iStore quote and shopping cart experience, providing the internal save routines that the public quote APIs and iStore storefront pages call. The package interacts directly with the Oracle Quoting (ASO) tables — ASO_QUOTE_HEADERS, ASO_QUOTE_LINES and their _ALL counterparts — and with Oracle Contracts (OKC) tables when a quote is converted to a contract. Because it is classified as a PVT package, it is not intended to be called directly by customer extensions; it sits beneath the supported public APIs and contains the bulk of the transactional logic, default-derivation logic and validation routines used when a shopper or sales agent saves, updates, duplicates or deletes a cart/quote. The source header references IBEVQCUB.pls, confirming the package ships as part of the iStore quoting codebase. The package is referenced by five other packages, indicating it is a shared internal utility rather than a leaf module.

Key Procedures and Functions

• SAVE — the primary persistence routine that writes a quote header, lines and line details to the database, coordinating inserts and updates across the ASO tables and returning status to the caller.
• DELETE and DELETEALLLINES — remove individual quote lines or the entire set of lines associated with a cart/quote, maintaining referential integrity with line details, shipments, payments and price attributes.
• ADDITEMSTOCART and ADDITEMSTOCART_ORIG — add one or more items to an existing cart, resolving item, organization and pricing information before persisting new quote lines.
• DUPLICATE_CART — the routine relevant to the "duplicate_cart" search; it copies an existing cart/quote into a new quote, replicating header, line and detail records for reuse by the shopper.
• GETHDRDEFAULTVALUES, GETHDRDEFAULTADDRESS, GETHDRDEFAULTSHIPMETHOD, GETHDRDEFAULTPAYMENTMETHOD, GETHDRDEFAULTTAXEXEMPTION, GETHDRDEFAULTENDCUSTOMER — derive default header attributes (address, shipping, payment, tax exemption and end customer) from site information and user profile data when a new cart is created.
• GET_QUOTE_EXPIRATION_DATE — determines the expiration date to apply to a quote.
• UPDATEQUOTEFORSHAREE, UPDATE_SUPPORT_AND_QUANTITY, RECONFIGURE_FROM_IB — update quote attributes for shared carts, adjust support and quantity values, and reconfigure a quote originating from Install Base.
• REQUEST_FOR_SALES_ASSISTANCE — flags a cart for sales assistance.
• CREATE_CONTRACT_FOR_QUOTE — converts an accepted quote into an Oracle Contracts agreement, writing to the OKC tables.

Tables Accessed

The package reads and writes the core quoting tables ASO_QUOTE_HEADERS, ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES, ASO_QUOTE_LINES_ALL and ASO_QUOTE_LINE_DETAILS, which hold the cart header, line and attribute-level data. Supporting tables include ASO_PAYMENTS, ASO_SHIPMENTS, ASO_TAX_DETAILS, ASO_PRICE_ATTRIBUTES and ASO_QUOTE_STATUSES_B, used to store payment, shipping, tax, pricing and status information attached to a quote. OKC_K_HEADERS_B and OKC_K_REL_OBJS are touched when a quote is converted to a contract. FND_USER and FND_LOOKUP_VALUES supply user identity and lookup validation, while IBE_MSITE_INFORMATION provides iStore site context for default derivation.

Usage Notes

IBE_QUOTE_SAVE_PVT is invoked indirectly through iStore storefront pages and the public Oracle Quoting APIs rather than being called directly. Custom code that needs to save, duplicate or delete a cart should use the supported ASO public APIs; direct calls to this private package risk breaking on patch upgrades because its signature and internal logic are not part of the supported interface. The DUPLICATE_CART routine in particular is exercised when a shopper selects a duplicate-cart action in the iStore UI.