Search Results oe_header_adj_cl_dep_attr




Overview
Explore in AI Chat

Overview

The APPS.OE_HEADER_ADJ_CL_DEP_ATTR package body is a dependency-related PL/SQL object within the Oracle E-Business Suite Order Management (OM) module, positioned in the Order Entry (OE) schema area. Its name indicates that it governs the attribute handling associated with header-level price adjustment clauses. In Oracle EBS 12.1.1 and 12.2.2, pricing and adjustment logic for sales orders is driven by the pricing engine (QP) and its interaction with order entry structures. This package functions as a supporting attribute-resolution layer that links order header adjustments to their dependent clause attributes, ensuring that price adjustment data surfaced on header-level views is consistent with the underlying order and pricing model.

Per the ETRM documentation, the object is classified as an OTHER API type rather than a formal public API. Its status is VALID, and it resides in the APPS schema. Within the dependency chain, it references OE_AK_HEADER_PRCADJS_V, OE_HEADER_ADJ_UTIL, and OE_ORDER_PUB, placing it squarely in the header price-adjustment processing family used by the Order Management pricing integration.

Key Procedures and Functions

The ETRM metadata documents sixteen procedures or functions within this package body. These include:

  • AUTOMATIC — Supports the determination of automatically applied adjustments versus manual ones during header adjustment processing.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns handling, used to stamp and track record-level who/when information when adjustment attribute rows are persisted.
  • DISCOUNT — Processes discount-type adjustments applied at the order header level.
  • DISCOUNT_LINE — Handles line-level discount adjustments that propagate or relate to header adjustment clauses.
  • HEADER — Manages header-scoped adjustment attribute data.
  • LINE — Manages line-scoped adjustment attribute data tied to the header adjustment context.
  • PERCENT — Handles percentage-based adjustment values.
  • PRICE_ADJUSTMENT — Core routine for reading or resolving price adjustment attributes.
  • PROGRAM_APPLICATION, PROGRAM, PROGRAM_UPDATE_DATE — Concurrent program and audit tracking for batch invocation contexts.
  • REQUEST — Captures the concurrent request identifier associated with batch processing of adjustments.

Tables Accessed

The ETRM excerpt does not enumerate base tables directly but identifies referenced objects that imply data access. OE_AK_HEADER_PRCADJS_V is a header price-adjustments view that supplies adjustment rows for header-level display. OE_HEADER_ADJ_UTIL is a utility package providing shared logic for header adjustment manipulation. OE_ORDER_PUB is the primary public Order Management API package used to read and write order headers and lines. Collectively, this indicates the package reads order header adjustment data through these views and APIs and writes attributes back via the order publish interfaces. Audit columns stored on relevant tables are populated through the CREATED_BY / LAST_UPDATED_BY family of routines.

Usage Notes

This package is not referenced by any other database object, suggesting it is invoked indirectly—typically through the Order Management pricing flow, the Sales Orders form (OEXOEORD), or concurrent adjustment processing rather than being called by external customizations. Because it carries a REQUEST and PROGRAM routine set, batch or concurrent invocation is plausible. Customizations should avoid calling internal routines directly; instead, use OE_ORDER_PUB and the supported pricing APIs. Any modification requires care, as the package sits in the APPS schema and is a dependency target for the header adjustment processing chain in both 12.1.1 and 12.2.2.