Search Results aso_quote




Overview
Explore in AI Chat

Overview

ASO_QUOTE_HOOK is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Order Capture (ASO) product family and is classified under the BUSINESS_ENTITY category ASO_QUOTE. The package is declared with AUTHID CURRENT_USER and is registered in ETRM with a lifecycle status of "active" and compatibility level "S" (standard, supported).

The package exists to bridge Oracle Quoting and Oracle Configurator at the point where a configuration session is launched from a quote. It supplies the calling application with the model configuration effective date and the model configuration lookup date, and it returns the initialization parameters that must be passed from Quoting into Configurator when the configurator session starts. In effect, it acts as a hook — a controlled extension point — so that the correct dating context and launch parameters are established before configuration begins, rather than being hard-coded within the Quoting flow.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package.

  • GET_MODEL_CONFIGURATION_DATE — Returns the model configuration effective date and the model configuration lookup date for a given quote context. The comment block identifies inputs for the quote header and the quote line representing the top-level model item, and outputs for the configuration effective date and configuration model lookup date. These values determine which configuration model version and effective-dated model structure apply when the user configures the model.
  • GET_MODEL_INIT_PARAMETERS — Returns the set of initialization parameters that Quoting passes to Configurator when the configurator session is launched. This allows the launch context, including the model configuration dates resolved by the companion procedure, to be propagated into the Configurator runtime.

The package header carries the standard Oracle source header and report annotations, including scope, product, display name, lifecycle, compatibility, and business entity. No tables are listed as directly referenced through APPS synonyms in the documented metadata.

Tables Accessed

The ETRM record lists no tables referenced via APPS synonyms for ASO_QUOTE_HOOK. This is consistent with the package's design intent: it is a hook whose public contract is to compute and return dates and launch parameters rather than to own or persist quote data. Where data is required, the package is expected to derive it from the quote context supplied through its parameters or from configuration repository structures accessed under the Configurator domain, leaving direct table ownership to the packages that manage those entities. Two other packages reference ASO_QUOTE_HOOK, indicating that it is consumed by higher-level Quoting or Configurator integration logic rather than being self-contained.

Usage Notes

ASO_QUOTE_HOOK is invoked during the transition from a quote line to a Configurator session. Typical call paths include the Oracle Quoting user interface when a user launches configuration for a model line, and any custom or extension code that must reproduce the same launch contract. Because both procedures are declared public and the package is registered with compatibility level S, it is supported for customer extension and integration use, but the documented parameter contract should be respected.

The effective date and lookup date returned by GET_MODEL_CONFIGURATION_DATE govern which effective-dated model definition Configurator resolves, so callers should invoke it immediately before session launch to avoid stale dating. The initialization parameters returned by GET_MODEL_INIT_PARAMETERS should be passed unmodified into the Configurator launch call. As with all Oracle EBS seed packages, customers should not modify the package body; extensions should be implemented through supported hooks and wrapper calls.