Search Results reconfigure_from_ib




Overview

ASO_CONFIG_OPERATIONS_PVT is a private (PVT) PL/SQL API package owned by APPS that supports configuration-related operations within the Oracle E-Business Suite Oracle Advanced Pricing and Oracle Quoting (ASO) module. Its central responsibility is to orchestrate configuration changes against a quote — adding configurations sourced from Oracle Installed Base (IB), reconfiguring existing quote lines to reflect a modified configuration, and deactivating configuration content from a quote. The package acts as an internal workhorse consumed by higher-level public APIs and other internal packages, encapsulating the logic needed to keep quote headers, quote lines, line details, configuration headers, and item instance records synchronized when configuration state changes.

The "$Header" comment (asovcfos.pls 120.2, dated 2005/11/18) reflects a mature, long-standing component whose interface has been stable across releases, including 12.1.1 and 12.2.2. As a PVT package it is not intended as a published integration surface; callers should prefer supported public APIs (such as ASO_QUOTE_PUB) unless implementing controlled internal extensions.

Key Procedures and Functions

  • ADD_TO_CONTAINER_FROM_IB — Adds configuration content originating from Oracle Installed Base into a container associated with a quote line. It accepts the standard ASO API control and quote header record structures, a quote line identifier, and an instance table describing the IB instances involved, returning the updated quote header record plus standard return status, message count, and message data.
  • RECONFIGURE_FROM_IB — The procedure corresponding to the search term reconfigure_from_ib. It reconfigures an existing quote (or quote line) based on instance data supplied from Oracle Installed Base, updating the quote header record as part of the operation. Its signature mirrors ADD_TO_CONTAINER_FROM_IB, taking API version, initialization and commit flags, validation level, control/header records, and an instance table, and returning status and message outputs.
  • DEACTIVATE_FROM_QUOTE — Deactivates configuration content from a quote, accepting the standard control and quote header records together with commit and validation options. This supports end-dating or removing configuration elements without deleting the underlying quote structure.

All three procedures follow the Oracle Application Object Library API convention: they return a return status, a message count, and message data, and honor initialization, commit, and validation-level parameters, enabling callers to control transaction boundaries and error handling.

Tables Accessed

The documented tables (accessed through APPS synonyms) span quoting and configuration:

  • ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL — the quote header and line tables updated or read when configurations change.
  • ASO_QUOTE_LINE_DETAILS — line-level detail records tied to configuration content.
  • CZ_CONFIG_HDRS — the configuration header table storing configuration model instances for a quote.
  • CSI_ITEM_INSTANCES — item instance records shared with Oracle Installed Base, the source of configuration data for the IB-related procedures.
  • PLITBLM — the Application Object Library message table used to retrieve and format error and informational messages.

Usage Notes

ASO_CONFIG_OPERATIONS_PVT is invoked internally rather than directly by end users. Typical callers include ASO quoting forms and related public APIs (for example, when a user adds, reconfigures, or removes a configured item on a quote) and other internal packages; documentation indicates the package is referenced by one other package. Because the procedures expose commit and validation parameters, batch or concurrent program integrations can call them with commit control disabled and perform a single commit at the transaction boundary. Custom code that must invoke these routines should replicate the documented call signature exactly and check the return status and message outputs after each call.