Search Results oe_totals_grp




Overview
Explore in AI Chat

Overview

APPS.OE_TOTALS_GRP is a Group-type API package within the Oracle E-Business Suite Order Management (OM) module. Its purpose is to return aggregated monetary totals for a sales order header or for an individual order line, covering line amounts, tax, and charges. The package provides callers with a single, normalized entry point for retrieving computed values that otherwise would require custom summation across order lines, price adjustments, tax lines, and charge records. Because it is classified as a GRP (group) API rather than a business flow or a standalone utility, its functions and procedures are designed to be invoked by other OM APIs and by dependent product code rather than by end users directly.

The package supports order-level and line-level granularity. In the documented conventions, order-level totals are obtained by passing a header identifier and leaving the line identifier null, while line-level totals require both identifiers. The package has evolved to include recurring charge support and, through the Pay Now Pay Later project, the ability to isolate the pay-now portion of an order or line.

Key Procedures and Functions

  • GET_ORDER_TOTAL — Returns the order or line total for the requested total type. It is the primary function exposed by the package and serves the common request implied by the search term "get_order_total." The total type drives whether all components, line amounts, charges, or taxes are returned.
  • GET_REC_ORDER_TOTAL — Returns the recurring order or line total. It extends the base total logic to orders containing recurring charges, allowing the periodicity of the charge to qualify the result.
  • GET_RECURRING_TOTALS — Populates an output collection of recurring charge totals for a given order header. Unlike the function-based APIs, it returns a structured table of recurring charge summary rows for downstream processing.
  • GET_PAYNOW_TOTAL — Returns the pay-now portion of an order or order line, broken into subtotal, tax, charges, and pay-now total. It was introduced under the Pay Now Pay Later project to support immediate-payment business scenarios.

Tables Accessed

The package operates against the Order Management transaction schema through APPS synonyms. The principal documented table is OE_ORDER_LINES_ALL, which stores the order line records from which line amounts, quantities, and pricing attributes are drawn. The PLITBLM table is also referenced and is associated with line-level pricing and charge information used in the aggregation logic. Read access to these tables is implicit in the functions' summation behavior; the package does not own or maintain the underlying data, it derives totals from it.

Usage Notes

OE_TOTALS_GRP is typically invoked from Order Management forms, from other OM packages, and from custom PL/SQL code that requires authoritative order or line totals without re-implementing the calculation rules. Because the package is referenced by other packages within the application, changes to its behavior can propagate widely. Callers should pass a valid header identifier for order-level totals and both header and line identifiers for line-level totals. The total-type argument determines which components are returned, and the default value of 'ALL' should be used when a complete total is required. For recurring and pay-now scenarios, the corresponding dedicated functions should be used rather than the base total function to ensure the correct charge treatment is applied.