Search Results c_amount_agr




Overview
Explore in AI Chat

Overview

The APPS.PO_POXPOSTD_XMLP_PKG package body is the supporting PL/SQL library associated with the Oracle Purchasing "POXPOSTD" report definition. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher (BI Publisher) concurrent programs that originate from Oracle Reports are migrated to XMLP packages that wrap the original report logic. The _XMLP_PKG packages supply the PL/SQL functions and procedures that Oracle Reports expects to resolve at runtime, including the standard report trigger points BeforeReport, AfterReport, and AfterPForm, plus report-specific user exits and helper routines.

The business function of this package is to initialize and finalize the POXPOSTD report run. It establishes the report's organizational context, computes formatting masks for quantity display, and provides rounding logic for monetary amounts. It is an internal implementation object rather than a public application programming interface; the ETRM classification of OTHER confirms it is not exposed as a supported integration API. The package has no dependencies from other packages, as it is referenced by zero other packages in the ETRM metadata.

Key Procedures and Functions

  • BeforeReport — The report's pre-execution trigger. It invokes GET_P_STRUCT_NUM to initialize the item structure context and calls PO_COMMON_xmlp_pkg.GET_PRECISION to derive the quantity format mask (FORMAT_MASK) from the report parameter P_QTY_PRECISION. Returns TRUE to allow the report to proceed.
  • AfterReport — The report's post-execution trigger, corresponding to the legacy FND SRWEXIT user exit. It performs end-of-report cleanup and returns TRUE. In the migrated body the legacy SRW calls are retained as commented placeholders.
  • GET_P_STRUCT_NUM — Retrieves the default item structure identifier for the Purchasing functional area and assigns it to the report parameter P_STRUCT_NUM. It returns TRUE on success and FALSE on exception.
  • GET_PRECISION — Maps the P_qty_precision parameter (values 0 through 6) to the appropriate numeric format mask used for quantity columns in the report output.
  • C_AMOUNT_AGR_ROUND — A formula/group-level rounding function that accepts an aggregate amount and a precision argument and returns the rounded value, enforcing consistent presentation of currency figures.
  • AFTERPFORM — The after-parameter-form trigger, executed after the Parameters window is accepted, used to validate or adjust parameter values prior to report execution.

Tables Accessed

The package reads PO_SYSTEM_PARAMETERS (via the APPS synonym) to obtain Purchasing system-level configuration. The documented query in GET_P_STRUCT_NUM selects STRUCTURE_ID from MTL_DEFAULT_SETS_VIEW filtered by FUNCTIONAL_AREA_ID = 2, which is the Purchasing functional area. This determines which item structure (for example, a configured or manufacturer part structure) governs the item information displayed by the POXPOSTD report. No write operations are documented.

Usage Notes

This package is invoked automatically by the Oracle Reports runtime when the POXPOSTD concurrent program executes; it is not called directly by application forms or custom code. The parameter p_single_po_print, which is the term users commonly search against, is a report parameter surfaced on the POXPOSTD parameter form and consumed by the report layout rather than by a dedicated procedure in this package. Because the package is classified as OTHER and referenced by no other packages, modification is not recommended; any customization should be performed through supported report parameter and template mechanisms in Oracle XML Publisher rather than by altering this body. The package version header indicates a 2007 revision consistent across EBS 12.1.1 and 12.2.2 environments.