Search Results oe_default_header_payment




Overview
Explore in AI Chat

Overview

The APPS.OE_DEFAULT_HEADER_PAYMENT package is a PL/SQL defaulting utility within the Oracle Order Management (OE) module of Oracle E-Business Suite. It is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner, which is consistent with other Order Management public APIs that rely on APPS-level synonyms and grants. The package's purpose is to supply and maintain the payment attributes that appear at the order header payment level — the payment terms, payment type, and associated payment number information captured during order entry. Rather than exposing a formal public API, it functions as an internal defaulting and retrieval helper used by the Order Management transaction layer and by other packages that build or validate header payment records.

Key Procedures and Functions

  • Attributes — Applies defaulting and derivation logic to a header payment record. It accepts the current header payment record, the prior (old) header payment record, and an optional iteration counter, and modifies the record in place. The IN OUT NOCOPY parameter indicates the procedure mutates the caller's record structure directly for performance, while the old-record parameter supplies the baseline values used to detect changes or seed defaults. The iteration parameter supports repeated invocation within a defaulting cycle.
  • Get_Payment_Number — A function that returns the payment number as a NUMBER for a supplied header identifier. It provides a lookup mechanism so callers can obtain the payment number associated with a given order header without querying the underlying payment table directly.

Tables Accessed

  • OE_PAYMENTS — The core Order Management payment table. It stores payment rows linked to order headers, including the payment number that Get_Payment_Number retrieves and that the Attributes procedure derives and maintains during defaulting.
  • OE_PAYMENT_TYPES_ALL — The payment type reference table. It supplies the valid payment types and their attributes, enabling the defaulting logic to resolve and validate the payment type assigned to the header payment record.

Usage Notes

This package is an internal component rather than a documented public interface, and it is typically invoked indirectly. It is called during Order Management order entry and order import processing when header payment records are defaulted, and it is referenced by two other APPS packages that extend or wrap its defaulting behavior. Because its procedures and function are not generally intended for direct customer invocation, customizations should be cautious: any extension that manipulates header payment records should preferably operate through the supported Order Management public APIs (such as OE_Order_PUB, whose Header_Payment_Rec_Type this package consumes) rather than calling this package directly. The package remains relevant in both 12.1.1 and 12.2.2, as the header payment defaulting model is consistent across these releases. The source header reference (OEXDHPMS.pls) indicates it has been stable since the earlier 11i code line, reflecting its role as foundational, low-level defaulting infrastructure.