Search Results get_config_type_values

Overview

APPS.PQP_UTILITIES is a shared service package within the Oracle EBS Payroll (PQP) product family, classified in the ETRM repository with an API classification of OTHER. It supplies a broad library of reusable convenience routines for Payroll and element-related processing rather than exposing a single public business API. Its header dates to the 11i/12.0 era (pqputifn.pkh 120.10), and the package remains present and documented in both EBS 12.1.1 and 12.2.2 under the APPS schema.

The package's principal responsibilities are threefold: resolving payroll element and element-type metadata, reading and caching user-defined table (UDT) and descriptive flexfield values, and providing a lightweight debug/trace facility for Payroll code paths. The header defines an hr_application_error exception (initialized on -20001), nested-level counters, global debug flags (g_debug, g_debug_timestamps, g_debug_entry_exits_only), and several PL/SQL collection types used to cache user tables, user columns, UDT buckets, and configuration values in package global memory. Thirty data-type and record declarations precede the 46 documented subprograms.

Key Procedures and Functions

Element and extra-element resolution forms the core of the package and is the area most relevant to the search term pqp_get_extra_element_mult:

• PQP_GET_EXTRA_ELEMENT_MULT — returns the multiplier associated with an extra element definition, used when an element's input value must be scaled or replicated.
• PQP_GET_EXTRA_ELEMENT_INFO and PQP_GET_EXTRA_ELEMENT_INFO_DET — return header-level and detail-level attributes for extra element information.
• PQP_GET_ELEMENT_EXTRA_INFO and PQP_GET_ELEMENT_EXTRA_INFO_DET — retrieve extra information attached to an element.
• PQP_GET_ELE_TYPE_EXTRA_INFO_ID and PQP_GET_ELEMENT_TYPE_ID — resolve element type identifiers and their associated extra-information IDs.

Value-retrieval helpers include GET_COL_VALUE, GET_DATA_TYPE, GET_DDF_VALUE (descriptive flexfield), GET_DF_VALUE (flexfield), GET_SEGMENT_NAME, GET_CONFIG_TYPE_VALUES, PQP_GET_CONCAT_VALUE, and the generic user-table accessors PQP_GB_GET_TABLE_VALUE and PQP_GB_GET_TABLE_VALUE_ID. The remaining documented procedures — DEBUG, DEBUG_ENTER, DEBUG_EXIT, and DEBUG_OTHERS — implement entry/exit tracing governed by the global debug flags.

Tables Accessed

Tables are referenced through APPS synonyms. Element and element-type metadata is read from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPE_INFO_TYPES, and PAY_DATETRACKED_EVENTS; event grouping uses PAY_EVENT_GROUPS. User-defined table and column values are resolved from PAY_USER_TABLES, PAY_USER_COLUMNS, PAY_USER_ROWS_F, and PAY_USER_COLUMN_INSTANCES_F. Configuration lookups read PQP_CONFIGURATION_VALUES. Flexfield and FastFormula metadata comes from FND_DESCRIPTIVE_FLEXS, FND_COLUMNS, FND_TABLES, FF_COMPILED_INFO_F, and FF_FDI_USAGES_F, and FND_NEW_MESSAGES supports message retrieval.

Usage Notes

PQP_UTILITIES is designed for internal consumption, as indicated by the ETRM "OTHER" classification and by the fact that 44 other packages reference it. It is typically invoked from Payroll forms, concurrent programs, and custom PL/SQL rather than called directly by end users. Because it exposes cached collection globals, callers should treat the package as stateless between sessions; caching is only valid within a database session. Custom code should prefer the documented element extra-information lookups over direct table queries to remain compatible with changes in the underlying Payroll data model.