Search Results qp_limit_balances_util




Overview
Explore in AI Chat

Overview

The APPS.QP_LIMIT_BALANCES_UTIL package is a utility (UTIL classification) PL/SQL component within the Oracle E-Business Suite Advanced Pricing (QP) module. Its business function is to encapsulate the low-level database operations required to maintain limit balance records — the accumulators that track cumulative pricing activity against defined limits such as maximum order values, discount ceilings, or quantity thresholds enforced during pricing and order capture. The package validates status of VALID in the APPS schema and is available across EBS 12.1.1 and 12.2.2.

Because limit balance maintenance involves reading, writing, and locking rows across several tightly coupled pricing tables, this utility isolates those mechanics so that higher-level pricing APIs and forms can invoke consistent, reusable data access logic rather than embedding redundant SQL. It is a supporting package rather than a public interface, and it is referenced by QP_LIMITS_PUB, QP_LIMITS_PVT, QP_DEFAULT_LIMIT_BALANCES, and QP_QP_FORM_LIMIT_BALANCES.

Key Procedures and Functions

Documented procedures and functions (12 total) provide standard data-access and maintenance primitives:

  • CLEAR_DEPENDENT_ATTR — clears derived or dependent attributes when underlying data changes.
  • APPLY_ATTRIBUTE_CHANGES — propagates modifications to dependent attributes after an update.
  • COMPLETE_RECORD — populates default or missing values so a record is fully formed.
  • CONVERT_MISS_TO_NULL — normalizes blank or "missing" values to NULL for consistency.
  • UPDATE_ROW — updates an existing limit balance row.
  • INSERT_ROW — inserts a new limit balance row.
  • DELETE_ROW — removes a limit balance row.
  • QUERY_ROW — retrieves a single record.
  • QUERY_ROWS — retrieves a set of records.
  • LOCK_ROW — applies a row-level lock to prevent concurrent modification.
  • GET_VALUES — returns attribute values for a record.
  • GET_IDS — returns identifier values for records.

Tables Accessed

The package references the following tables via APPS synonyms:

  • QP_LIMIT_BALANCES — the primary balance accumulator table written and read by this package.
  • QP_LIMITS — defines limit headers and rules governing the balances.
  • QP_LIST_HEADERS_B — pricing list headers used to associate limits with price lists.
  • QP_PRC_CONTEXTS_B — pricing context definitions.
  • QP_PTE_SEGMENTS and QP_SEGMENTS_B — pricing segment structures supporting qualification criteria.
  • PLITBLM — the generic pricing table used in list processing.

Usage Notes

This package is typically invoked indirectly by Oracle's own limit-management API layer (QP_LIMITS_PUB, QP_LIMITS_PVT), by the limit balance maintenance concurrent program, and by the Limit Balances form. Custom code should avoid calling it directly unless replicating standard limit balance maintenance, since the public supported entry point is QP_LIMITS_PUB. Direct use risks bypassing validation and dependent-attribute handling performed by the higher-level APIs.