Search Results p_total_type

Overview

OE_TOTALS_GRP is a PL/SQL group package in the APPS schema that provides a consolidated programmatic interface for retrieving monetary totals associated with Oracle Order Management entities. Its primary business function is to aggregate and return order-level and line-level amounts across the three principal cost components of an order: line amounts, charges, and taxes. The package abstracts the underlying summation logic so that forms, concurrent programs, and custom extensions can obtain consistent totals without directly querying the order line tables. The package body header identifies the internal version as 120.2, with an initial and current version of 1.0 as documented in the API comments.

Key Procedures and Functions

The documented API surface of OE_TOTALS_GRP comprises four functions, each addressing a distinct totals scenario:

• GET_ORDER_TOTAL — Returns the aggregate total for an order or a specific line. The API comment block indicates that when the header identifier is passed and the line identifier is null, the function returns order-level totals; when both are supplied, it returns line-level totals. The amount returned depends on the caller-supplied total type, which selects among the categories ALL, LINES, CHARGES, and TAXES.
• GET_REC_ORDER_TOTAL — Retrieves totals for recurring order constructs, supporting the pricing and billing of recurring line arrangements.
• GET_RECURRING_TOTALS — Returns aggregated recurring amounts, complementing GET_REC_ORDER_TOTAL for recurring order processing.
• GET_PAYNOW_TOTAL — Returns the pay-now total associated with an order, supporting immediate-payment processing paths.

Tables Accessed

The package operates against two documented data sources referenced through APPS synonyms. OE_ORDER_LINES_ALL is the principal order line table, supplying line amount, charge, and tax values that the functions aggregate. PLITBLM is a PL/SQL index-by table type used internally for holding and manipulating numeric collections during summation; it is not a persistent database table. Together these objects support the calculation paths for the four functions described above.

Usage Notes

OE_TOTALS_GRP is a group-type API, meaning it is intended as an internal building block rather than a public, standalone interface. It is referenced by ten other packages within the EBS code base, which indicates that it is typically invoked indirectly by higher-level order management APIs and processing routines rather than called directly by end-user code. Customizations that require order or line totals should generally prefer the calling public APIs, but developers may invoke OE_TOTALS_GRP where the aggregated result is required within server-side PL/SQL. The p_total_type parameter drives the result: callers pass ALL to obtain the combined total, or restrict the result to LINES, CHARGES, or TAXES as appropriate. Because the interface is group-classified and versioned from 2005, it should be treated as a stable but internal dependency, and any direct use in custom code should be reviewed against the supported public APIs for the target release. The behavior is consistent across Oracle EBS 12.1.1 and 12.2.2, as the package logic resides in the APPS schema and is not affected by the technology-stack changes introduced in 12.2.