Search Results c_amount

Overview

APPS.PO_POXPRIPR_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite concurrent program and XML Publisher report commonly known as the "Invoice Price Variance" or "Purchase Price Variance" report (report short name POXPRIPR). It belongs to the Oracle Purchasing (PO) module and follows the standard XML Publisher concurrent program packaging convention, in which an automatic PL/SQL package encapsulates the report's BeforeReport trigger, AfterReport trigger, formula columns, and helper routines. The package is owned by APPS and is classified under ETRM as OTHER rather than as a public callable API.

The report compares average purchase prices against average invoice prices for purchased items and calculates the resulting price variance percentage. Its formulas also produce primary quantity conversions and base-currency amounts using exchange rates. The header comment identifies the file as POXPRIPRB.pls, version 120.3 (2008/01/22), indicating it is a long-standing component carried forward into both 12.1.1 and 12.2.2. The package is referenced by zero other packages, confirming that it is an entry-point concurrent program package rather than a shared library.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions, which fall into four groups.

• Report lifecycle: BEFOREREPORT and AFTERREPORT execute at report open and close respectively. BEFOREREPORT derives the ORDER BY clause from PO_LOOKUP_CODES, sets the quantity precision, and defaults the base currency.
• Sorting and precision: ORDERBY_CLAUSEFORMULA returns the effective ORDER BY clause; GET_PRECISION and GET_P_STRUCT_NUM resolve quantity precision and structure number values for the layout.
• Variance and amount calculations: IPVFORMULA computes the invoice price variance percentage; AVERAGE_PURCHASEFORMULA and AVERAGE_INVOICEFORMULA derive average purchase and invoice prices; AVERAGE_PURCHASE_ROUNDFORMULA, AVERAGE_INVOICE_ROUNDFORMULA, C_AMOUNT_ROUNDFORMULA, and C_AMOUNT_TOT_ROUNDFORMULA apply rounding to those amounts and their totals.
• Quantity and currency conversion: RATEFORMULA resolves the exchange rate; PO_PRIMARY_QTYFORMULA and AP_PRIMARY_QTYFORMULA convert purchased and invoiced quantities into the primary unit of measure; ITEM_AVERAGE_PURCHASE_ROUNDFOR and ITEM_AVERAGE_INVOICE_ROUNDFORM complete the item-level rounded averages.

The user's search term, c_amount, maps directly to C_AMOUNT_ROUNDFORMULA and C_AMOUNT_TOT_ROUNDFORMULA, which format the base-currency amount column and its report total. No parameter lists are documented, so the routines should be treated as report-internal formulas rather than callable APIs.

Tables Accessed

Two tables are documented as referenced through APPS synonyms.

• FINANCIALS_SYSTEM_PARAMETERS: supplies the ledger and currency context—most notably the base currency and rate information used by RATEFORMULA and the amount formulas.
• GL_PERIOD_STATUSES: provides period open/closed status so the report can restrict invoice and purchase activity to valid accounting periods.

The package body excerpt additionally shows a read of PO_LOOKUP_CODES for the 'SRS ORDER BY' lookup type, though this table is not listed in the ETRM table metadata for the object.

Usage Notes

This package is not intended for direct invocation from forms or custom code. It is invoked automatically by the Oracle EBS concurrent manager when the associated POXPRIPR XML Publisher concurrent program is submitted, receiving the report's parameters (including P_orderby, P_qty_precision, and P_BASE_CURRENCY) and executing BEFOREREPORT before data extraction and AFTERREPORT at completion. Because it is an APPS-owned generated package with zero dependent packages, any customization should be performed by copying the concurrent program rather than modifying the seeded package. The commented-out SRW.USER_EXIT and SRW.MESSAGE calls reflect the historical migration from Oracle Reports to XML Publisher; they are inert in current releases and should not be re-enabled.