Search Results get_quote_expiration_date




Overview
Explore in AI Chat

Overview

IBE_QUOTE_SAVE_PVT is a private (PVT class) PL/SQL package in the APPS schema that provides the server-side save, update, and cart-management logic for Oracle iStore (IBE) quotation and shopping-cart functionality in Oracle E-Business Suite 12.1.1 and 12.2.2. It acts as the persistence and orchestration layer between the iStore storefront user interface and the Oracle Quoting / Advanced Pricing foundation, coordinating calls into ASO_QUOTE_PUB, OKC_API, and OKC contract tables to create and maintain quote headers and lines. Its status is documented as VALID in the ETRM repository, and it sits at the center of a dependency cluster: it references ASO_QUOTE_PUB, FND_API, IBE_QUOTE_SAVESHARE_PVT, JTF_NUMBER_TABLE, and OKC_API, and is in turn referenced by IBE_ORD_ONECLICK_PVT, IBE_QUOTE_SAVESHARE_PVT, IBE_QUOTE_SAVESHARE_V2_PVT, IBE_QUOTE_W1_PVT, and IBE_SHOP_LIST_PVT. This position confirms it as a shared internal service rather than an end-user API.

Key Procedures and Functions

The package documents 19 procedures and functions, reflecting its broad responsibility across quote lifecycle operations:

  • SAVE and DUPLICATE_CART persist a quote or clone an existing cart, driving ASO_QUOTE_PUB and the OKC contract records.
  • DELETE and DELETEALLLINES remove a quote or all of its lines.
  • GET_QUOTE_EXPIRATION_DATE derives the quote expiry date used when validating or persisting a quote.
  • REQUEST_FOR_SALES_ASSISTANCE flags a quote for sales representative involvement.
  • UPDATEQUOTEFORSHAREE updates a quote as part of the sharee (quote sharing) flow, working in conjunction with IBE_QUOTE_SAVESHARE_PVT.
  • ADDITEMSTOCART and ADDITEMSTOCART_ORIG add configured or catalog items to a cart. The _ORIG variant preserves the original add-to-cart logic, typically retained for backward compatibility or specific call paths.
  • GETHDRDEFAULTVALUES, GETHDRDEFAULTADDRESS, GETHDRDEFAULTSHIPMETHOD, GETHDRDEFAULTPAYMENTMETHOD, GETHDRDEFAULTTAXEXEMPTION, and GETHDRDEFAULTENDCUSTOMER form a family of default-derivation routines that populate quote header attributes from iStore site information, user profile, and lookup values before a quote is saved.
  • CREATE_CONTRACT_FOR_QUOTE generates the OKC contract header and related object rows that underpin a quote, linking the ASO quote to the OKC contract model.
  • RECONFIGURE_FROM_IB rebuilds a cart or quote line configuration originating from Oracle iStore/IB configuration data.
  • UPDATE_SUPPORT_AND_QUANTITY updates service/support attributes and quantities on an existing quote line.

Parameter lists are not reproduced here; each routine is described by purpose only, consistent with the documented metadata.

Tables Accessed

The package reads and writes through APPS synonyms against several schema families. Quote data is stored in ASO_QUOTE_HEADERS, ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES, ASO_QUOTE_LINES_ALL, and ASO_QUOTE_LINE_DETAILS, with status values validated against ASO_QUOTE_STATUSES_B. Pricing and payment detail are held in ASO_PRICE_ATTRIBUTES, ASO_PAYMENTS, ASO_SHIPMENTS, and ASO_TAX_DETAILS. The OKC contract integration is supported by OKC_K_HEADERS_B and OKC_K_REL_OBJS, while OKX_QUOTE_HEADERS_V is referenced as a view for quote header data. Setup and user context are obtained from FND_LOOKUP_VALUES, FND_USER, and IBE_MSITE_INFORMATION, which supply defaults and site-level configuration.

Usage Notes

IBE_QUOTE_SAVE_PVT is an internal package and is not intended for direct invocation by customers or integrators; Oracle does not publish its signatures as a supported API. It is invoked indirectly through the iStore storefront (quotes and shopping-cart flows), through the dependent iStore packages listed above (notably IBE_ORD_ONECLICK_PVT for one-click ordering and IBE_QUOTE_SAVESHARE_PVT / IBE_QUOTE_SAVESHARE_V2_PVT for quote sharing), and through any custom code that calls those packages. Because it manipulates ASO and OKC records directly via FND_API error handling, customizations should call the supported ASO_QUOTE_PUB API rather than this package. Its signature and internal behavior should be treated as version-specific to 12.1.1 and 12.2.2 and subject to change in patches or upgrades.