Search Results round_amount_list_subtotal_rep

Overview

PO_POXPOPAR_XMLP_PKG is the PL/SQL package body that supports the Oracle Purchasing XML Publisher report POXPOMPAR (Purchasing Activity / Procurement Activity Report) in Oracle E-Business Suite 12.1.1 and 12.2.2. The package is owned by APPS and is classified as AUTHID CURRENT_USER, meaning all unqualified object references execute under the privileges of the invoking session. Its primary responsibility is to drive report-level business logic that cannot be expressed declaratively in the XML Publisher (BI Publisher) data template: parameter defaulting, dynamic WHERE-clause construction, lookup-meaning translation, currency rounding, and conditional display logic for government-versus-commercial report layouts.

The package is not a general-purpose API. It is a report-controller package, invoked exclusively by the Oracle Reports/XML Publisher runtime during execution of the POXPOMPAR report. It is referenced by zero other packages, confirming its narrow, purpose-built role. Because the report supports organization-specific variations in layout and content, the package exposes flags that control whether government-specific or core fields are rendered.

Key Procedures and Functions

• SET_DISPLAY_FOR_GOV — Documented as a function returning BOOLEAN. This is the object most frequently located by users searching "set_display_for_gov." It evaluates configuration and parameter conditions to determine whether the government-specific layout variant of the report should be displayed, gating the visibility of government-oriented columns and totals.
• SET_DISPLAY_FOR_CORE — The companion function to SET_DISPLAY_FOR_GOV. Returns BOOLEAN and controls whether the core (standard commercial) report layout elements are displayed.
• COMPANY — Returns the formatted company name used in headers.
• COST_CENTER — Returns the formatted cost center value for report presentation.
• GET_PRECISION — Resolves the currency quantity precision applied to numeric report columns.
• ORDERBY_CLAUSEFORMULA — Builds the dynamic ORDER BY clause based on the P_ORDERBY parameter.
• BEFOREREPORT — Standard XML Publisher/Reports before-report trigger; initializes report state.
• AFTERREPORT — Standard after-report trigger; performs cleanup.
• AFTERPFORM — Executes after parameter form submission; typically used to derive dependent parameters such as P_ORDERBY_DISPLAYED.
• GET_LOOKUP_MEANING — Translates a lookup code into its display meaning for a given lookup type.
• GET_BOILER_PLATES — Populates boilerplate text blocks used in report headers/footers.
• ROUND_AMOUNT_LIST_SUBTOTAL_REP — Rounds open-invoice subtotal amounts to the appropriate currency precision.
• C_INDUSTRY_CODE_P and C_COMPANY_TITLE_P — Accessor functions exposing the C_industry_code and C_company_title package variables.

Tables Accessed

• FINANCIALS_SYSTEM_PARAMETERS — Read to derive ledger and currency precision information that feeds GET_PRECISION and rounding logic.
• FND_SEGMENT_ATTRIBUTE_VALUES — Read to determine descriptive-flexfield segment attributes, supporting the company and cost center display functions.

Both tables are accessed through APPS synonyms.

Usage Notes

PO_POXPOPAR_XMLP_PKG is invoked implicitly by the XML Publisher engine when the POXPOMPAR concurrent program runs. Developers rarely call it directly; instead, they extend it when customizing the government or core layout variants. Because the package uses AUTHID CURRENT_USER, customizations must ensure the executing user has appropriate grants. In 12.2.2 the object remains unchanged from its 12.1.1 form (header version 120.2). Any change to SET_DISPLAY_FOR_GOV directly alters which columns render in the output, making it the primary extension point for jurisdiction-specific reporting requirements.