Search Results oe_oe_form_header_adj




Overview
Explore in AI Chat

Overview

OE_OE_FORM_HEADER_ADJ is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its naming convention and dependency profile indicate that it is a form-support package for the Order Management (OE) module, specifically responsible for the header-level adjustment functionality exposed through the Order Organizer and Sales Order forms. The package bridges the Oracle Forms user interface and the underlying Order Management public and private APIs, so that header adjustments entered interactively by a user are validated, written to the transactional tables, and propagated to dependent business logic such as price adjustment and delayed request processing.

The package is classified as VALID and is reported by ETRM as not being referenced by any other database object, meaning it is a top-level entry point invoked from the forms layer rather than a shared utility consumed by other PL/SQL units. Its API classification is OTHER, confirming that it is not part of the published Oracle Order Management public API set but rather an internal forms-support package.

Key Procedures and Functions

ETRM documents six exposed program units, each corresponding to a distinct action available from the header adjustment form:

  • DEFAULT_ATTRIBUTES — populates default values for the header adjustment record, drawing defaults from profile options and header context so that the form opens with sensible field values.
  • CHANGE_ATTRIBUTES — responds to user-driven changes to header adjustment attributes, recalculating derived values and revalidating affected fields when the user navigates or modifies the record.
  • VALIDATE_AND_WRITE — performs the final validation of the header adjustment and commits it to the database, typically invoked when the user saves the form.
  • DELETE_ROW — removes a header adjustment line from the form buffer and the underlying transaction, subject to cancellation and status checks.
  • PROCESS_DELAYED_REQUESTS — submits or flushes deferred requests accumulated during the adjustment, coordinating with OE_DELAYED_REQUESTS_PVT so that expensive processing occurs outside the interactive transaction.
  • LOCK_ROW — acquires a lock on the header adjustment row to prevent concurrent modification by another form session.

Tables Accessed

ETRM does not enumerate base tables directly for this package. The dependency list shows the package operates through the Order Management packages OE_ORDER_PUB, OE_ORDER_PVT, OE_ORDER_ADJ_PVT, and OE_HEADER_ADJ_UTIL rather than issuing SQL against the tables itself. Consequently, the tables affected — the order header and header adjustment tables within the OE schema — are read and written indirectly through those APIs, which is the supported pattern for maintaining data integrity of the order transaction.

Usage Notes

This package is invoked from the Oracle Order Management forms when a user applies, modifies, or removes a header-level price adjustment. It is not a concurrent program and is not intended to be called from custom SQL or batch interfaces; direct invocation bypasses form-level state handling and is unsupported. Developers integrating with Order Management should use the published OE_ORDER_PUB APIs instead. Because the package is not referenced by any other database object, its lifecycle is tied strictly to the forms release in which it ships, and any customization should be confined to form personalization or to the documented public APIs.