Search Results oe_oe_form_line_payment




Overview
Explore in AI Chat

Overview

OE_OE_FORM_LINE_PAYMENT is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Order Management (ONT) module and is classified under the Order Capture / Sales Order process. The package provides the server-side logic that supports payment and payment-term related processing on the order line entry form, specifically the Order Organizer and Sales Orders window within the Order Management application. Rather than exposing a public API used by external systems, this package functions primarily as a forms-driven internal worker that the Oracle Forms user interface calls when a user enters, modifies, or validates payment attributes on an order line.

The package delegates much of its business logic to shared Order Management infrastructure — OE_ORDER_PUB, OE_ORDER_PVT, OE_LINE_PAYMENT_UTIL, and OE_DEFAULT_PVT — and it uses the FND_API, FND_MSG_PUB, and OE_MSG_PUB utility packages for the standard EBS API error-handling and message-stack conventions. The dependency listing confirms that it references OE_ORDER_LINES_ALL and the Forms PL/SQL table construct PLITBLM, and that it is not referenced by any other database object, reinforcing its role as a leaf-level form support package.

Key Procedures and Functions

The documented package exposes seven procedures and functions, as follows:

  • DEFAULT_ATTRIBUTES — Applies default values to payment-related attributes on the order line record, typically drawing values from OE_DEFAULT_PVT and the order header or line context.
  • CHANGE_ATTRIBUTE — Handles the change of a single attribute on the form line record, triggering dependent updates and validations consistent with Order Management attribute rules.
  • VALIDATE_AND_WRITE — Validates the accumulated line payment changes and commits them to the underlying order line record via the Order Management public APIs.
  • DELETE_ROW — Removes a row from the form's in-memory record set, supporting deletion of a payment-related line or attribute row.
  • PROCESS_ENTITY — Serves as the central dispatcher that routes an action against the payment entity to the appropriate handler (default, change, validate, delete).
  • LOCK_ROW — Obtains a lock on the selected row to prevent concurrent modification while the user maintains the record.
  • COPY_ATTRIBUTE_TO_REC — Copies an attribute value from a source record into the target form record, used when propagating payment values across related lines.

Tables Accessed

The package operates against two documented objects. OE_ORDER_LINES_ALL is the base table for order line data in Order Management; the package reads and writes payment-related columns on this table through the OE_ORDER_PUB and OE_ORDER_PVT APIs rather than through direct DML. PLITBLM is the standard Oracle Forms PL/SQL table of VARCHAR2 used for message handling; the package references it in conjunction with FND_MSG_PUB and OE_MSG_PUB to surface errors and warnings to the form.

Usage Notes

OE_OE_FORM_LINE_PAYMENT is invoked implicitly by the Oracle Forms front end during sales order entry and maintenance. It is not a public API and should not be called directly from custom code or concurrent programs. Customizations that require equivalent behavior should call the supported Order Management public APIs (OE_ORDER_PUB) instead. The package is marked VALID and is not referenced by any other database object, so it may be safely recompiled without affecting dependent program units.