Search Results oe_price_list_util




Overview
Explore in AI Chat

Overview

APPS.OE_PRICE_LIST_UTIL is a utility package in the Oracle Order Management (OE) module of Oracle E-Business Suite. It provides the low-level, reusable processing logic that supports the price list public APIs, principally OE_PRICE_LIST_PUB, and the underlying Oracle Advanced Pricing data model. The package exists to centralize the mechanics of manipulating a price list header record — populating dependent attributes, completing partially populated records, translating special sentinel values, and performing the individual DML operations against the base tables. It is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, which is consistent with its classification as an internal utility rather than a directly callable business API.

The package also declares a large set of global constants (G_ATTRIBUTE1 through G_ATTRIBUTE15, G_COMMENTS, G_CONTEXT, G_CREATED_BY, G_CREATION_DATE, G_CURRENCY, G_DESCRIPTION, G_END_DATE_ACTIVE, G_FREIGHT_TERMS, G_LAST_UPDATED_BY, G_LAST_UPDATE_DATE, G_LAST_UPDATE_LOGIN, G_NAME, G_PRICE_LIST, G_PROGRAM_APPLICATION, G_PROGRAM, G_PROGRAM_UPDATE_DATE, G_REQUEST, G_ROUNDING_FACTOR, G_SECONDARY_PRICE_LIST, G_SHIP_METHOD, G_START_DATE_ACTIVE, G_TERMS, and G_MAX_ATTR_ID). These constants map each descriptive and DFF attribute of a price list header to a stable numeric identifier, allowing the generic attribute-processing routines to operate on any attribute position without hard-coded column references.

Key Procedures and Functions

The documented callable units number eleven and fall into three functional groupings.

  • CLEAR_DEPENDENT_ATTR — resets attributes whose validity depends on other attribute values, using the current and prior price list record images.
  • APPLY_ATTRIBUTE_CHANGES — reconciles a record image against the attribute change set so that only changed attributes are propagated.
  • COMPLETE_RECORD — fills in required or defaulted values so that a partially populated record satisfies the constraints of the underlying tables.
  • CONVERT_MISS_TO_NULL — translates the FND_API.G_MISS_NUM / G_MISS_CHAR sentinel values into true NULLs before persistence, a standard EBS API convention.
  • UPDATE_ROW, INSERT_ROW, DELETE_ROW — perform the individual DML operations against the price list header table on behalf of the caller.
  • QUERY_ROW and LOCK_ROW — retrieve a row for validation and acquire a row-level lock to serialize concurrent updates.
  • GET_VALUES — loads column values from the base table into the PL/SQL record structure.
  • GET_IDS — the routine associated with the search term "get_ids"; it resolves and returns the internal identifier values required to bind the price list record to its underlying rows.

Tables Accessed

The package reads and writes the price list header and its qualifier structures through APPS synonyms: QP_LIST_HEADERS_B (the base table holding the price list header itself), QP_QUALIFIERS and QP_QUALIFIERS_S (the qualifier definitions and their translated/attribute columns), and QP_QUALIFIER_GROUP_NO_S. These are the core Advanced Pricing tables that back the price list entity managed by Order Management.

Usage Notes

OE_PRICE_LIST_UTIL is not intended for direct invocation. It is referenced by six other packages and is normally reached through OE_PRICE_LIST_PUB or the Order Management price list maintenance forms and concurrent programs. Custom code requiring price list manipulation should call the public API; this utility layer handles record completion, sentinel conversion, attribute dependency clearing, DML, and locking as an implementation detail of that API.