Search Results g_rec_tax_value

Overview

OE_OE_TOTALS_SUMMARY is a procedural 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) product family and provides the computation, aggregation, and presentation logic behind order totals throughout the order lifecycle. The package derives order-level monetary and quantity values — list price, selling price, adjustments, charges, tax, freight, and committed amounts — and rolls them up from line-level and adjustment-level detail. It is classified as an OTHER API in the ETRM registry rather than a formal public interface, indicating that it is primarily an internal engine consumed by Order Management forms, order entry workflows, and other order-related packages.

The package is heavily reused: it references twenty-four packages and is, in turn, referenced by twenty-four other packages. Its dependency list includes OE_ORDER_UTIL, OE_CHARGE_PVT, OE_COMMITMENT_PVT, OE_HEADER_ADJ_UTIL, OE_PRICE_ADJUSTMENTS, OE_MSG_PUB, OE_DEBUG_PUB, FND_API, and OE_SYS_PARAMETERS, which confirms its role as a shared totals and pricing-rollup utility rather than a self-contained business service.

Key Procedures and Functions

The documented API exposes thirty-three procedures and functions. They fall into several functional groups.

• Price adjustment processing: PRICE_ADJUSTMENTS, LINE_PRICE_ADJ_ORDER_MODIFIER, LINE_EXT_ADJ_ORDER_MODIFIER, and LINE_PRICE_ADJUSTMENTS compute and classify order- and line-level price adjustments, including order modifier and extended adjustment treatment.
• Charges and taxes: CHARGES and LINE_CHARGES return charge amounts (such as freight and special charges), while TAXES returns tax amounts associated with order lines.
• Subtotals and line totals: ORDER_SUBTOTALS, LINE_TOTAL, SERVICE_TOTAL, and OUTBOUND_ORDER_SUBTOTAL assemble subtotal values for standard lines, service lines, and outbound order documents.
• Global and configuration totals: GLOBAL_TOTALS, GLOBAL_REC_TOTALS, CONFIG_TOTALS, and ORDER_TOTALS aggregate totals across an entire order or a configured item, including recursively linked configuration lines.
• Quantity aggregation: TOTAL_ORDERED_QTY accumulates ordered quantities across lines.
• Output and reporting: PRT_ORDER_TOTAL and OUTBOUND_ORDER_TOTAL format and return presentation-ready totaling values for order printing and outbound documentation.
• Single-value getters: GET_ORDER_AMOUNT and GET_DISCOUNT retrieve individual derived amounts — the order value and the discount applied — for callers that require a single figure rather than a full totals structure.

The remaining documented entries provide internal helpers supporting these public calls; their parameter lists are not published in the repository and should not be assumed.

Tables Accessed

The package reads from the following APPS-synonymed tables:

• OE_ORDER_LINES_ALL — the primary source of line-level pricing attributes, quantities, and line amounts used in every totals calculation.
• OE_PRICE_ADJUSTMENTS — line and order level price adjustment detail, including modifier amounts and adjustment types.
• OE_PAYMENTS — payment and deposit information used when deriving order amounts and balances.
• MTL_SYSTEM_ITEMS — item attributes needed to distinguish service, configured, and standard inventory items during aggregation.
• PLITBLM — a standard Oracle tooling table (the PL/SQL item table used for list handling), reflecting the package's use of dynamic or bulk-collected structures.

Writes are directed through the underlying pricing and charge APIs rather than performed directly by this package; totals are returned to the caller.

Usage Notes

OE_OE_TOTALS_SUMMARY is invoked during Order Management order entry and order inquiry, when the Order Organizer or Sales Orders form refreshes header totals, and during order booking, picking, shipping, and invoicing flows where line and header amounts must be recalculated. Concurrent programs that print orders, pick slips, and outbound documents call the PRT_ORDER_TOTAL and OUTBOUND_ORDER_TOTAL routines to produce printed totals blocks. Because it is a shared utility, custom extensions that need Order Management totals should call it rather than re-derive amounts from OE_ORDER_LINES_ALL, ensuring consistency with seeded pricing, charge, and tax logic.

Callers must supply a correctly initialized Order Management global context, including organization and operating unit, and should honor the API's return status conventions. The package relies on OE_DEBUG_PUB for diagnostic output and OE_MSG_PUB for message retrieval, so error handling should follow standard ONT API patterns: check the return status, retrieve the message from the message stack, and only perform cleanup or commit when success is indicated. Because totals are derived from live line and adjustment data, invoke the package after pricing and adjustment engines have completed their work to avoid stale figures.