Search Results config_operations




Overview
Explore in AI Chat

Overview

ASO_CONFIG_OPERATIONS_INT is an internal PL/SQL package in the Oracle E-Business Suite Order Management and Advanced Pricing (ASO – Oracle Configurator/Quote) schema. It serves as the internal implementation layer for configuration-related operations performed against Oracle Quoting and Configurator data. The package exposes a single documented entry point, CONFIG_OPERATIONS, which carries out create, update, and delete actions against quote header and quote line configuration data. Because the package name carries the "_INT" suffix, it is intended as an internal API rather than a public, supported interface; external integration points are expected to call the corresponding public wrapper (ASO_QUOTE_PUB) instead. The header comment dates the source to 2005 (asoicfos.pls, version 120.2), indicating the package has been stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

  • CONFIG_OPERATIONS — The sole documented procedure. It processes a configuration operation request supplied by the caller through an operation code parameter, applying the requested action to the supplied quote header, quote line, and instance collections. It accepts the standard Oracle API parameter set: API version number, message list initialization flag, commit flag, and validation level, together with a control record and the quote header/line/instance record structures. A delete flag governs whether the operation removes or retains existing configuration rows. The procedure returns the updated quote header record along with the standard Oracle API return status, message count, and message data outputs, following the FND_API error-handling convention.

Tables Accessed

The documented table reference for this package is ASO_QUOTE_HEADERS_ALL, accessed through an APPS synonym. This is the base table holding quote header information for Oracle Quoting. The package reads and writes header data as part of the configuration operation, and the instance and line collections passed in through the parameter list are persisted against the related quote structures. The header table is central to the operation because configuration changes must remain consistent with the owning quote.

Usage Notes

Because ASO_CONFIG_OPERATIONS_INT is an internal package, it is normally invoked indirectly rather than called directly from custom code. It is referenced by four other packages in the ETRM inventory, confirming its role as a shared implementation utility behind Oracle's quoting and configuration APIs. Typical invocation paths include:

  • Oracle Quoting and Oracle Configurator form-based flows that create, modify, or remove configured items on a quote.
  • Public API wrappers such as ASO_QUOTE_PUB, which expose supported, versioned entry points and delegate configuration work to this internal procedure.
  • Concurrent or batch processes that regenerate or validate quote configurations.

Customizations should avoid direct calls to ASO_CONFIG_OPERATIONS_INT. The parameters use internal record types (ASO_QUOTE_PUB.Qte_Header_Rec_Type, Qte_line_tbl_type, and ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type) whose structure may change between patch levels, and the procedure is undocumented in the public API sense. When configuration changes must be made programmatically, the supported ASO_QUOTE_PUB interface should be used so that validation, message handling, and commit semantics are preserved. The commit flag should generally be passed as FND_API.G_FALSE when the caller manages the transaction, allowing multiple operations to be grouped into a single unit of work and rolled back together on error.