Search Results qp_default_curr_lists




Overview
Explore in AI Chat

Overview

QP_DEFAULT_CURR_LISTS is a PL/SQL package in the APPS schema that supports the Oracle Advanced Pricing (QP) module's currency list functionality. Its role is to construct and return a defaulted currency list record on behalf of calling APIs, most notably the QP_Currency_PUB public API. Rather than requiring every caller to manually populate each attribute of a currency list record, this package centralizes the defaulting logic so that standard values are applied consistently across all entry points.

The package is declared with AUTHID CURRENT_USER, which means executing privileges are resolved against the invoker's schema rather than the definer's. In practice this is consistent with Oracle E-Business Suite's standard for API-layer packages, ensuring that calling code operates under its own privilege set while accessing the QP dictionary tables through APPS synonyms. The package is classified as an "OTHER" API, meaning it is an internal utility rather than a public interface intended for direct external use.

The business context for this package is the pricing and currency setup performed during Advanced Pricing configuration. A currency list defines the set of currencies available for price lists, and defaulting ensures that newly created or partially specified lists receive valid values for their attributes before being validated and persisted.

Key Procedures and Functions

The package exposes a single documented procedure:

  • Attributes — This procedure accepts an incoming currency list record and returns a populated output record with defaulted attribute values applied. It handles the case where the input record has not been supplied by the caller, applying default behavior rather than failing. It also accepts an iteration parameter, which allows the defaulting operation to run repeatedly, a pattern commonly used in EBS concurrent or multi-pass processing where values are resolved in successive passes. The procedure operates entirely against the in-memory PL/SQL record and returns the result through an unconstrained output parameter.

No other procedures or functions are documented in the package specification. The procedure's signature references the shared PL/SQL record type QP_Currency_PUB.Curr_Lists_Rec_Type, which ties the package's contract directly to the public currency API layer and ensures type compatibility with that API's calling conventions.

Tables Accessed

The documented table references for this package are limited to the following:

  • QP_CURRENCY_LISTS_B_S — the base table storing currency list definition data. It is accessed through an APPS synonym. This table supplies the default or existing values that the Attributes procedure draws upon when populating the output record.
  • DUAL — the standard Oracle single-row utility table, used for scalar evaluation and constant expressions within the package logic, such as default value assignment or sequence-free lookups.

No insert, update, or delete activity against these tables is documented. The package is a read-and-default utility; persistence of the currency list is the responsibility of the calling API, not this defaulting layer.

Usage Notes

QP_DEFAULT_CURR_LISTS is invoked indirectly. The ETRM metadata records that the package is referenced by one other package, which places it inside the internal call chain of the Advanced Pricing currency API family rather than at the user-facing boundary. Its most likely caller is QP_Currency_PUB or a sibling package that prepares records before validation.

Typical invocation paths include:

  • Advanced Pricing setup forms where a currency list is created or modified, and the form layer delegates defaulting to the API stack;
  • Concurrent programs that bulk-create or maintain currency lists, where consistent defaults are required for every generated record;
  • Custom PL/SQL code that legitimately operates on currency lists and needs to conform to standard QP defaulting behavior instead of hard-coding values.

Because the package is not a public API, customizations should normally call the documented public currency API rather than this package directly. Direct invocation risks bypassing validation performed elsewhere in the chain and may be affected by internal signature changes across EBS releases. In 12.1.1 and 12.2.2 the object is unchanged in placement and purpose, and it remains a supporting utility within the QP currency list defaulting framework.