Search Results qp_qualifier_group_no_s

Overview

OE_PRICE_LIST_UTIL is a utility package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM framework as a UTIL object. Its principal role is to provide a reusable programmatic layer over price list header and qualifier data in Oracle Advanced Pricing and Order Management. The package encapsulates row-level operations — insert, update, delete, query, and lock — against the pricing repository so that calling modules do not need to duplicate low-level DML logic or handle partition-style table access directly.

The package participates in both the Order Management and Advanced Pricing schemas. It depends on OE_PRICE_LIST_PUB, OE_VALUE_TO_ID, OE_ID_TO_VALUE, and OE_MSG_PUB within the OE family, and on QP_LIST_HEADERS_B, QP_LIST_HEADERS_PKG, QP_LIST_HEADERS_VL, QP_PRICE_LIST_PVT, QP_QUALIFIERS, QP_QUALIFIER_GROUP_NO_S, and QP_UTIL within the QP family. It also consumes FND_API, FND_MESSAGE, APP_EXCEPTIONS, OE_GLOBALS, and OE_DEBUG_PUB for error handling and logging, indicating the package is written to the standard EBS API conventions.

Key Procedures and Functions

Eleven documented procedures and functions comprise the public surface of the package:

• CLEAR_DEPENDENT_ATTR — removes or nullifies dependent attribute values when a parent qualifying attribute changes, preserving attribute consistency.
• APPLY_ATTRIBUTE_CHANGES — applies a set of attribute modifications to the affected price list records in a controlled manner.
• COMPLETE_RECORD — populates default or derived values on a record so it satisfies the pricing model's completeness rules.
• CONVERT_MISS_TO_NULL — normalizes the MIS spelling convention to NULL, allowing callers to treat "no value" uniformly.
• UPDATE_ROW — updates an existing price list or qualifier row.
• INSERT_ROW — inserts a new price list or qualifier row.
• DELETE_ROW — removes a row from the underlying table.
• QUERY_ROW — retrieves one or more rows according to supplied criteria.
• LOCK_ROW — obtains a row lock to serialize concurrent modification.
• GET_VALUES — returns attribute values in a caller-supplied structure.
• GET_IDS — returns the surrogate primary keys associated with a given set of pricing entities.

Parameter lists are intentionally omitted here; refer to the package specification in the APPS schema for exact signatures.

Tables Accessed

The package reads and writes four documented tables through APPS synonyms:

• QP_LIST_HEADERS_B — the base price list header table; rows are created, updated, deleted, queried, and locked here.
• QP_QUALIFIERS — the qualifier definitions associated with a price list.
• QP_QUALIFIERS_S — the sequence generator used to assign qualifier primary keys.
• QP_QUALIFIER_GROUP_NO_S — the sequence used to assign qualifier group numbers, which is the object frequently identified by the search term "qp_qualifier_group_no_s".

These tables form the supporting layer beneath QP_LIST_HEADERS_VL and QP_LIST_HEADERS_PKG and give the package its authoritative position for qualifier group numbering.

Usage Notes

OE_PRICE_LIST_UTIL is an internal utility rather than an end-user API. It is referenced by six other packages within the APPS schema, and is itself not referenced by any database object, confirming it is a shared code dependency within the Order Management pricing stack. It is typically invoked from PL/SQL when pricing data must be manipulated outside the standard forms, such as during concurrent program processing, order import, or custom extension code that must respect qualifier numbering rules. Because it relies on FND_API and APP_EXCEPTIONS, callers should follow the standard EBS error-handling pattern: check the return status and inspect the message stack after each call. Direct DML against QP_QUALIFIER_GROUP_NO_S should be avoided in favour of this package, since it centralises the sequence assignment and dependent attribute maintenance logic required for data integrity across the pricing model.