Search Results qp_limit_attrs_util




Overview
Explore in AI Chat

Overview

QP_LIMIT_ATTRS_UTIL is a utility package in the Oracle EBS Advanced Pricing (QP) module that supports the maintenance and validation of limit attribute records associated with pricing limits. Pricing limits allow organizations to constrain modifiers, qualifiers, and pricing behavior based on attribute-level conditions. The package is classified as an API utility (UTIL) and is owned by APPS in the 12.1.1 and 12.2.2 releases, declared with AUTHID CURRENT_USER so that execution privileges follow the invoking schema.

The package centralizes low-level operations on the QP_LIMIT_ATTRIBUTES entity and its parent QP_LIMITS records. It provides the attribute identifier constants used throughout the package (G_ATTRIBUTE1 through G_MAX_ATTR_ID) to map logical attribute columns to positional identifiers, and it exposes insert, update, query, lock, and delete helpers alongside higher-level routines such as PRE_WRITE_PROCESS and APPLY_ATTRIBUTE_CHANGES that orchestrate record-level processing. Its name and structure indicate that it is not an end-user interface but an internal service called by other pricing packages, forms, and concurrent processes to enforce consistency before records are written to the database.

Key Procedures and Functions

  • PRE_WRITE_PROCESS — Prepares limit attribute records prior to persistence, performing the validation and defaulting needed before insert or update.
  • APPLY_ATTRIBUTE_CHANGES — Applies accumulated attribute-level changes to a limit record as part of the write cycle.
  • CLEAR_DEPENDENT_ATTR — Clears dependent attribute values when an attribute changes, accepting a limit-attributes record and returning an updated record.
  • COMPLETE_RECORD — Populates any missing fields on a limit-attributes record so it is complete and ready for processing.
  • CONVERT_MISS_TO_NULL — Converts FND_API.G_MISS_* sentinel values into database NULLs to maintain consistent storage semantics.
  • UPDATE_ROW / INSERT_ROW / DELETE_ROW — Physical DML helpers for the underlying limit attribute row.
  • QUERY_ROW / QUERY_ROWS — Retrieve a single row or a set of rows for a given limit attribute query.
  • LOCK_ROW — Acquires a row-level lock to serialize concurrent updates.
  • GET_VALUES / GET_IDS — Return attribute values or identifier lists used by callers to drive downstream processing.

Tables Accessed

  • QP_LIMITS — Parent limit header records; read and locked during write operations.
  • QP_LIMIT_ATTRIBUTES — The primary entity maintained by this package.
  • QP_LIST_HEADERS_B — Pricing list headers referenced when validating limit context.
  • QP_PRC_CONTEXTS_B / QP_PTE_SEGMENTS / QP_SEGMENTS_B — Pricing context and segment definitions used to resolve attribute context metadata.
  • PLITBLM — The pricing list table maintained in the background, referenced for list-level consistency.

Usage Notes

QP_LIMIT_ATTRS_UTIL is invoked programmatically. It is referenced by five other packages, which typically call PRE_WRITE_PROCESS and its DML helpers during pricing limit setup and maintenance. It is not exposed directly to end users, though Oracle Pricing forms and concurrent programs that maintain limits indirectly depend on it through those callers. Because it is AUTHID CURRENT_USER, callers must execute with the appropriate APPS privileges. Customizations should treat this package as internal and use the documented QP_Limits_PUB API surface rather than calling QP_LIMIT_ATTRS_UTIL directly, since parameter signatures and behavior are subject to change without notice.