Search Results qp_am_util

Overview

QP_AM_UTIL is a utility PL/SQL package owned by the APPS schema within the Oracle E-Business Suite Order Management and Advanced Pricing (QP) module. Its primary business function is to provide centralized helper routines that report on the installation state and configuration of the Oracle Attributes Manager subsystem. The package exposes lightweight Boolean-style lookup functions that other pricing and modifier components call to determine whether optional Attributes Manager features are available before attempting to invoke them. By isolating these environment checks in a single utility package, Oracle ensures that dependent forms and APIs such as the Modifier setup form behave consistently whether or not the Attributes Manager option is licensed and installed.

The package header carries the source control revision marker QPXAMUTS.pls 120.0, dated June 2005, indicating it is a long-standing, stable object that has carried forward from earlier releases into EBS 12.1.1 and 12.2.2 without structural change. Its classification in the ETRM repository is UTIL, confirming that it is not an integration API or a business transaction entry point but rather an internal support library.

Key Procedures and Functions

Two documented program units are exposed in the package specification:

• Attrmgr_Installed — Returns a VARCHAR2 value indicating the installation status of the Attributes Manager component within the current environment. Callers use this function as a guard before referencing Attributes Manager data structures, allowing the application to degrade gracefully when the component is absent.
• Use_Organizer_for_Query_Find — Returns a VARCHAR2 value signalling whether the Oracle Organizer tool may be used to perform query-by-example finds launched from the Modifiers Summary and Qualifiers blocks of the Modifier form. This governs the query find behavior presented to users in that specific form context.

The metadata lists an additional identifier, TO, which reflects a truncated or parsed artifact of the specification text rather than a distinct documented unit. No parameter lists are documented for either function; implementers should not assume signatures beyond those published in the package header.

Tables Accessed

The ETRM metadata records no base tables or APPS synonyms accessed directly by QP_AM_UTIL. This is consistent with its role as a status and configuration flag provider: the functions are expected to resolve installation and licensing state from profile options, feature flags, or internal attribute manager lookups rather than from persistent application tables. Because no table dependencies are documented, the package imposes no direct read or write load on the pricing schema and cannot cause DML side effects.

Usage Notes

QP_AM_UTIL is referenced by one other PL/SQL package according to the ETRM dependency data, and is typically invoked indirectly through that dependency rather than called directly from concurrent programs. Its most visible consumer is the Modifier setup form, where Use_Organizer_for_Query_Find controls whether the Organizer-based query find is offered in the Qualifiers and Modifiers Summary blocks. Because the functions return VARCHAR2 status values rather than raising exceptions, they are safe to call repeatedly and are suitable for use in conditional branching within form triggers and validation logic.

Custom developers extending Advanced Pricing should treat QP_AM_UTIL as an internal Oracle utility rather than a supported public API. Direct invocation is possible from custom code, but the return conventions for the VARCHAR2 flags are not formally documented, so reliance on specific literal values carries upgrade risk. Oracle does not expose formal extension hooks on this package. The recommended approach for customizations requiring Attributes Manager awareness is to inspect the same profile options the package evaluates, or to reference the documented public pricing APIs instead of depending on these internal checks.