Search Results lock_pricing_attributes

Overview

OE_PRICE_LIST_LINE_UTIL is a utility package in the Oracle Order Management (OE) module of Oracle E-Business Suite. Its role is to support the maintenance and manipulation of price list line records, which reside in the Oracle Advanced Pricing tables shared with Order Management. The package provides a low-level interface for inserting, updating, deleting, querying, and locking price list lines and their associated pricing attributes without requiring callers to interact directly with the underlying base tables. It is classified as a utility (UTIL) API, meaning it is intended primarily for internal use by Oracle application code and by dependent packages rather than as a formally supported public integration API.

The package declares a comprehensive set of global constants that map the columns of the price list line entity and its pricing attributes to numeric positions. The constants named G_PRICING_ATTRIBUTE1 through G_PRICING_ATTRIBUTE15 correspond to the fifteen descriptive pricing attribute columns available on price list lines. The user search term g_pricing_attribute1 refers directly to the constant declared as G_PRICING_ATTRIBUTE1 CONSTANT NUMBER := 31; in the package specification. This constant identifies the first pricing attribute slot within the internal column-ordering scheme used by the package's generic row-handling routines.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions. Their purposes are as follows:

• CLEAR_DEPENDENT_ATTR — Clears dependent pricing attribute values when a controlling attribute changes, maintaining consistency among related attribute columns.
• APPLY_ATTRIBUTE_CHANGES — Applies pending attribute modifications to the target record.
• COMPLETE_RECORD — Populates default or derived values to produce a complete record prior to persistence.
• CONVERT_MISS_TO_NULL — Normalizes internal "missing value" indicators to null.
• UPDATE_ROW — Updates an existing price list line or pricing attribute row.
• INSERT_ROW — Inserts a new row.
• DELETE_ROW — Deletes an existing row.
• QUERY_ROW — Retrieves a single row.
• QUERY_ROWS — Retrieves multiple rows.
• LOCK_ROW — Obtains a row-level lock.
• GET_VALUES — Returns the set of values associated with a record.
• GET_IDS — Returns identifying keys for a record.
• MAINTAIN_PRICING_ATTRIBUTES — Performs coordinated maintenance of pricing attribute rows.
• LOCK_PRICING_ATTRIBUTES — Locks pricing attribute rows.
• QUERY_PRICING_ATTRIBUTES — Queries pricing attribute rows for a given entity.

Tables Accessed

The package operates against the Advanced Pricing and Order Management base tables exposed through APPS synonyms. QP_LIST_HEADERS_B stores the price list header. QP_LIST_LINES holds the individual price list line records that this utility primarily manipulates. QP_PRICING_ATTRIBUTES and its _S counterpart, together with QP_PRICING_ATTR_GROUP_NO_S, QP_RLTD_MODIFIERS, QP_RLTD_MODIFIERS_S, and QP_RLTD_MODIFIER_GRP_NO_S, store pricing attributes and related modifier groupings. DUAL and the internal PLITBLM structure are used for utility and bulk-processing operations.

Usage Notes

OE_PRICE_LIST_LINE_UTIL is referenced by five other packages and is normally invoked indirectly. It is called during price list line maintenance from Order Management and Advanced Pricing forms, from internal concurrent processing, and from dependent application code rather than being called directly by end users. Because the package is classified as a utility API and its constants encode an internal column ordering, custom code should rely on the documented procedures rather than on hard-coded positional constants wherever a supported alternative exists. The G_PRICING_ATTRIBUTE1 constant remains valid across both EBS 12.1.1 and 12.2.2 since the package specification source is unchanged between releases.