Search Results ibe_cfg_config_pvt




Overview
Explore in AI Chat

Overview

APPS.IBE_CFG_CONFIG_PVT is a private PL/SQL package in the Oracle E-Business Suite (EBS) iStore/Configurator module. It is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking schema rather than the owner (APPS), an attribute typical of private helper packages that assume the caller already holds the necessary grants on underlying objects. The package header carries the RCS identifier IBEVFSCS.pls 120.1 2010/11/30.

The package provides the server-side plumbing that links Oracle Configurator runtime sessions to Oracle Quoting. Its two documented procedures address the two halves of a configuration-driven sales cycle: determining whether an item can be configured and how the Configurator UI should be launched (GET_CONFIG_LAUNCH_INFO), and then persisting a finished configuration against a quote header and line (ADD_CONFIG_TO_QUOTE). Because it is classified PVT in the ETRM metadata, it is an internal implementation package — not part of Oracle's published, committed public API surface — and Oracle therefore does not guarantee backward compatibility of its signatures across patches.

Key Procedures and Functions

  • GET_CONFIG_LAUNCH_INFO — Evaluates a given inventory item within an operating unit/organization and reports back whether that item is configurable. It returns the flags, database identifiers, servlet URL, and system date required by the calling application to open the Configurator session for the item. Notably, the header history comment records that a former ICX session ticket output parameter was removed ("taken out as we're using a new java api for bug 3137603"), confirming that launch mechanics were moved to a Java-based API. It follows the standard OAF/PLSQL API conventions: p_api_version, p_init_msg_list, p_commit, p_validation_level for control, and the standard x_return_status / x_msg_count / x_msg_data trio for error propagation.
  • ADD_CONFIG_TO_QUOTE — Commits a completed configuration to a quote. It accepts the quote header ID, quote line ID, configuration header ID, and configuration revision number, together with validity and completeness indicators (p_valid_cfg, p_complete_cfg) and pricing control inputs — pricing request type, header and line pricing events, tax and shipping calculation switches, and the pricing mode.

The pricing mode parameter defaults to 'ENTIRE_QUOTE', with the in-line comment "change line logic pricing". This value directs the pricing engine to reprice the whole quote rather than only the affected line, which is significant because inserting or modifying a configured line can alter dependent line relationships, qualifiers, and totals across the entire quote.

Tables Accessed

The only documented table reference is ASO_QUOTE_LINE_DETAILS, accessed through an APPS synonym. This is the Oracle Quoting table that stores line-level detail attributes. Given the procedure's purpose, ADD_CONFIG_TO_QUOTE writes the returned configuration header ID and revision number into this table to associate the configured item with its quote line, while GET_CONFIG_LAUNCH_INFO is principally a read/evaluation routine. Other configuration and quote tables are referenced indirectly via the Configurator and Quoting APIs rather than directly in this package.

Usage Notes

This package is invoked internally by iStore/Quoting flows and by the Oracle Configurator integration layer, not by end users directly. In a typical sequence, the application first calls GET_CONFIG_LAUNCH_INFO to validate item configurability and obtain launch parameters, hands off to the Configurator UI, and then calls ADD_CONFIG_TO_QUOTE when the user finishes or saves the configuration against a quote. Because it is a PVT package with no inbound referrers documented (Referenced by: 0 other packages), customizations should avoid calling it directly; integrators should prefer Oracle's public Quoting and Configurator APIs. Any direct use should be reviewed after patching, since private signatures such as these are subject to change without notice.