Search Results oe_agreement_util




Overview
Explore in AI Chat

Overview

APPS.OE_AGREEMENT_UTIL is a utility package within the Oracle Order Management (OM) module of Oracle E-Business Suite. It provides the low-level application programming interface used to create, maintain, query, and validate agreement records — the customer-specific pricing, invoicing, and freight arrangements that govern how orders are priced and billed. Agreements in Order Management are stored in the OE_AGREEMENTS and OE_AGREEMENTS_B tables and are linked to pricing entities in Oracle Advanced Pricing, so this package acts as the bridge between the agreement data model and the calling forms, concurrent programs, or custom code that manipulate it.

A distinguishing feature of the package is its extensive block of global constants, which assign numeric attribute identifiers to each column of the agreement entity. G_ACCOUNTING_RULE is defined as constant NUMBER := 1, G_AGREEMENT_CONTACT as 2, G_AGREEMENT as 3, and so on through the remaining attributes, including the descriptive flexfield columns (G_ATTRIBUTE1 through G_ATTRIBUTE15, G_CONTEXT) and the standard WHO audit columns (G_CREATED_BY, G_CREATION_DATE, G_LAST_UPDATED_BY, G_LAST_UPDATE_DATE, G_LAST_UPDATE_LOGIN). Because the header dates from release 12.0.x, these constants underpin the generic, attribute-number-driven logic used throughout the package.

Key Procedures and Functions

The package exposes twelve documented program units that together form a complete record-level API:

  • INSERT_ROW — inserts a new agreement record, populating the columns identified by the attribute constants.
  • UPDATE_ROW — applies changes to an existing agreement row.
  • DELETE_ROW — removes an agreement record.
  • QUERY_ROW and QUERY_ROWS — retrieve a single record or a set of records matching supplied criteria.
  • LOCK_ROW — obtains a row-level lock to support concurrent modification.
  • COMPLETE_RECORD — finalizes validation and defaulting before the record is committed.
  • CLEAR_DEPENDENT_ATTR — resets attributes that become invalid or irrelevant when a controlling attribute changes.
  • APPLY_ATTRIBUTE_CHANGES — propagates the effect of modified attributes to dependent columns or related records.
  • CONVERT_MISS_TO_NULL — normalizes the Oracle Forms "miss" placeholder value to a true NULL for database writes.
  • GET_VALUES — returns column values for the current agreement, typically into form block items.
  • GET_IDS — resolves and returns the identifier values for an agreement record.

Tables Accessed

The package operates primarily on OE_AGREEMENTS and OE_AGREEMENTS_B, the base and translated tables holding agreement header information, and it references OE_AGREEMENTS_TL indirectly through the same synonym structure. Because agreements carry pricing and qualifier information, it also touches the Advanced Pricing tables QP_LIST_HEADERS, QP_LIST_LINES, and QP_QUALIFIERS, which store price lists, pricing lines, and qualifier rules linked to the agreement. PLITBLM is the standard Order Management table used for storing descriptive flexfield context and segment data, supporting the G_CONTEXT and G_ATTRIBUTEn constants declared in the package specification.

Usage Notes

OE_AGREEMENT_UTIL is classified as a UTIL package and is invoked from the Agreement and Customer Pricing forms within Order Management, where the block-level triggers call INSERT_ROW, UPDATE_ROW, and DELETE_ROW as users maintain agreements. The QUERY_ROW, QUERY_ROWS, GET_VALUES, and GET_IDS routines support form query and navigation logic, while LOCK_ROW prevents lost updates in multi-user sessions. The package is referenced by four other packages in the application, indicating that higher-level APIs depend on it rather than touching the agreement tables directly. Oracle does not certify this package as a public, supported API; custom development should treat it as internal and prefer documented Order Management or Advanced Pricing public APIs where available, recognizing that the 12.1.1 and 12.2.2 implementations share the same 12.0.x header lineage.