Search Results g_list_type

Overview

QP_MODIFIER_LIST_UTIL is a utility PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It supports the Advanced Pricing module (Oracle Price Management / QP), which governs modifier lists — the pricing entities commonly known as price lists, discount lists, surcharge lists, promotion lists, and related agreement constructs. The package provides low-level, reusable routines that other pricing packages and forms call to manipulate and validate modifier list records at the header and line level.

The package is declared with AUTHID CURRENT_USER and is catalogued in ETRM as a UTIL classification object. Its most recognizable public symbol is the constant G_ROUNDING_FACTOR, defined as the number 36 in the package's global constants block. This constant identifies the position of the Rounding Factor column as it appears in the internal record layout used by the modifier list maintenance routines. Sibling constants such as G_DISCOUNT_LINES, G_LIST_HEADER, G_LIST_TYPE, and G_PRORATE confirm that the constants enumerate columns of the QP_LIST_HEADERS and QP_LIST_LINES structures rather than arbitrary application values. Developers searching for g_rounding_factor are typically tracing how rounding results on a price list or modifier are positioned and applied through the shared record-processing logic.

Key Procedures and Functions

The package exposes twelve documented procedures and functions. They fall into three functional groups:

• Row maintenance: INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, QUERY_ROW, and COMPLETE_RECORD provide standard insert, update, delete, locking, query, and record-completion operations for modifier list data. These routines encapsulate the DML and column-population logic so that callers need not repeat it.
• Attribute processing: APPLY_ATTRIBUTE_CHANGES and CLEAR_DEPENDENT_ATTR manage dependent attribute behavior when qualifier or pricing attribute values change, ensuring that dependent columns are reset or recalculated consistently, including monetary columns such as rounding factor.
• Lookup and identification: GET_VALUES, GET_IDS, GET_SEGMENT_LEVEL_FOR_GROUP, and CONVERT_MISS_TO_NULL support value retrieval, surrogate identifier resolution, segment-level determination for a pricing group, and normalization of the "missing" sentinel value to NULL.

Tables Accessed

All table references resolve through APPS synonyms. Header-level operations target QP_LIST_HEADERS_ALL_B, QP_LIST_HEADERS_B (its primary-key join partner), and QP_LIST_HEADERS_TL for translated header text. Line-level operations address QP_LIST_LINES. Qualifier data is handled through QP_QUALIFIERS, QP_LIMIT_ATTRIBUTES, and QP_LIMITS, while pricing context and segment metadata are read from QP_PRC_CONTEXTS_B, QP_PRICING_ATTRIBUTES, QP_PTE_SEGMENTS, and QP_SEGMENTS_B. Relationship data is drawn from QP_RLTD_MODIFIERS, and language validation uses FND_LANGUAGES.

Usage Notes

QP_MODIFIER_LIST_UTIL is a supporting utility rather than an end-user entry point. It is referenced by seven other packages within the pricing family and is normally invoked indirectly from the Advanced Pricing setup forms, concurrent program logic, and pricing engine routines. Customizations should treat it as an internal helper: direct calls are possible from custom PL/SQL, but the supported extension points are the documented modifier list APIs. Because the constants define column positions rather than database values, code that reads or passes G_ROUNDING_FACTOR must operate on the same record structure the package expects.