Search Results qp_parameter_values_s

Overview

QP_PARAM_UTIL is a utility package body in the APPS schema that supports the Oracle Advanced Pricing (QP) parameter framework. It is classified as a UTIL API within ETRM 12.2.2 and carries a VALID status in Oracle EBS 12.1.1 and 12.2.2. The package provides the programmatic plumbing behind parameter definitions and parameter values used throughout Oracle Advanced Pricing, allowing seeded and user-defined parameters to be stored, retrieved, and validated against their associated value sets.

Parameters in Oracle Advanced Pricing drive configurable behavior for pricing entities such as price lists, modifiers, qualifiers, and request types. QP_PARAM_UTIL abstracts the mechanics of resolving a parameter's value set, generating the corresponding SQL selection, and maintaining the QP_PARAMETER_VALUES table. Because the package is a utility rather than a public business API, it is primarily consumed internally by other pricing packages, forms, and concurrent processes rather than being called directly from customer code.

Key Procedures and Functions

• GET_VALUESET_SELECT — Constructs the value set selection logic used to resolve valid values for a given parameter, enabling dynamic lookup behavior tied to FND value sets.
• POPULATE_PARAMETER_VALUES — Populates parameter value records, typically seeding QP_PARAMETER_VALUES for a parameter or parameter group based on defined value sets.
• INSERT_PARAMETER_VALUES — Inserts individual parameter value rows into QP_PARAMETER_VALUES, supporting create operations from forms or batch routines.
• DELETE_PARAMETER_VALUES — Removes parameter value records, supporting maintenance and reset activities on parameter definitions.
• GET_PARAMETER_VALUE — Returns the value of a named parameter for a given context, serving as the primary read accessor used by dependent pricing logic.
• IS_SEED_USER — Determines whether the current user is a seeded (Oracle-owned) user, used to control whether seeded parameter data may be modified.

Tables Accessed

The package references the following tables via APPS synonyms: QP_PARAMETERS_B, QP_PARAMETERS_TL, QP_PARAMETER_VALUES, QP_PARAMETER_VALUES_S, QP_PTE_REQUEST_TYPES_B, and DUAL.

• QP_PARAMETERS_B / QP_PARAMETERS_TL — Base and translation tables holding parameter definitions; read to identify parameters and their attributes.
• QP_PARAMETER_VALUES / QP_PARAMETER_VALUES_S — Store and validate parameter values; QP_PARAMETER_VALUES_S is the sequence source used when inserting new value rows, which is why the search term "qp_parameter_values_s" surfaces this package.
• QP_PTE_REQUEST_TYPES_B — Holds pricing request type definitions associated with parameters.
• DUAL — Used for single-row lookups and value set selection scaffolding.

Usage Notes

QP_PARAM_UTIL is typically invoked indirectly. Oracle Advanced Pricing setup forms (such as the parameter and value set maintenance windows) and other pricing packages call its procedures to populate, insert, delete, and read parameter values. The package is referenced by four other database objects but does not itself reference external customer code, confirming its role as an internal utility.

Developers integrating with Oracle Advanced Pricing should retrieve parameter values through the supported public interfaces rather than calling QP_PARAM_UTIL directly, since its signatures and behavior are not guaranteed across patches or releases. Where the sequence QP_PARAMETER_VALUES_S is involved, custom inserts into QP_PARAMETER_VALUES should consistently use this sequence to avoid primary key conflicts. Because it depends on FND_API, FND_GLOBAL, FND_VSET, and QP_UTIL, the package assumes an initialized applications context (FND_GLOBAL.APPS_INITIALIZE) before execution, as is standard for EBS utility packages.