Search Results ibe_order_save_pvt




Overview
Explore in AI Chat

Overview

IBE_ORDER_W1_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle iStore (IBE) module of Oracle E-Business Suite. The "PVT" suffix indicates a private API package, meaning it is intended to be called only from within the iStore application layer rather than directly from external or customer code. Its role is to support the save and validation processing of iStore shopping cart and order data as that data moves from the web storefront into the Oracle Order Management base tables. The package acts as a lower-level worker routine that is invoked by the public iStore order save package, IBE_ORDER_SAVE_PVT, which the user search term "ibe_order_save_pvt" directly references.

Key Procedures and Functions

The ETRM metadata documents a single procedure or function within this package: SAVEWRAPPER. Consistent with its name, SAVEWRAPPER serves as a wrapper routine that encapsulates the order-save logic and exposes a controlled entry point for the calling layer. Rather than containing all save logic itself, it coordinates the underlying data operations and delegates processing to dependent routines and helpers. The private classification means this wrapper is not part of the supported public API surface; it exists to be consumed internally by IBE_ORDER_SAVE_PVT, which calls into IBE_ORDER_W1_PVT to complete portions of the save workflow. The ETRM data does not document a parameter list for SAVEWRAPPER, and none should be assumed.

Tables Accessed

Only one table is documented as referenced through APPS synonyms: PLITBLM. This is a standard Oracle EBS internal table whose name follows the pattern used for PL/SQL index-by or nested-table staging structures within the application, and it is used here to hold intermediate collections as part of the processing performed by SAVEWRAPPER. Beyond the single documented table, the package depends on several shared collection types and utilities, including FND_API (the standard EBS API utility package), and the JTF collection types JTF_DATE_TABLE, JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, and JTF_VARCHAR2_TABLE_300. These types are commonly used to pass arrays of dates, numbers, and character values through PL/SQL interfaces, and their presence indicates that SAVEWRAPPER manipulates bulk collections of order line or attribute data during the save process.

Usage Notes

IBE_ORDER_W1_PVT is not designed for direct invocation from forms, concurrent programs, or custom extensions. It is a private implementation package invoked internally at runtime, chiefly by IBE_ORDER_SAVE_PVT, which is the public iStore order save program that developers and implementers interact with when integrating or extending iStore checkout behavior. The dependency graph confirms this relationship: IBE_ORDER_W1_PVT is referenced by IBE_ORDER_SAVE_PVT, and the package also references itself, indicating recursive or internally chained processing within the save workflow. This behavior is consistent across Oracle EBS 12.1.1 and 12.2.2, where the iStore order architecture retains the same public/private package split. For customization or integration purposes, the supported entry point remains IBE_ORDER_SAVE_PVT; IBE_ORDER_W1_PVT should be treated as an internal worker package whose interfaces may change between patches and releases. Because SAVEWRAPPER depends on FND_API conventions, errors raised during save processing are typically surfaced through the standard EBS API error-handling mechanism rather than through custom exception handling.