Search Results c_base_currency_code_p

Overview

AP_APXCMINV_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema (AUTHID CURRENT_USER) that backs the XML Publisher report associated with the invoice currency and minimum accounting unit setup for Payables. Its role is to supply the runtime data structures and helper logic required by the BI Publisher (XML Publisher) concurrent program that renders currency precision and minimum account unit information. Consistent with the standard 12.1.1 / 12.2.2 XML Publisher report package pattern, it declares report parameters and global constants, and implements the standard BeforeReport and AfterReport entry points plus a dedicated data-fetch function.

The package contains no public business API; it is an internal report support unit. The "$Header" comment (revision 120.0, dated 2007) confirms it is a long-standing, file-based report package carried forward unchanged into the 12.2.x code line.

Key Procedures and Functions

• BeforeReport — The standard XML Publisher pre-report trigger. It executes report initialization logic before the report query is formatted, typically calling the data-fetch routine and validating report inputs such as P_VENDOR_FROM/P_VENDOR_TO and P_DATE_FROM/P_DATE_TO.
• get_base_curr_data — The principal data-retrieval function. It populates the package globals that describe the ledger's base (functional) currency: C_BASE_CURRENCY_CODE, C_BASE_MIN_ACCT_UNIT, C_BASE_PRECISION, and C_BASE_DESCRIPTION. These values are sourced from AP_SYSTEM_PARAMETERS and related currency definitions.
• AfterReport — The standard post-report trigger used for cleanup or finalisation logic after the report output is generated.
• C_VENDOR_P, C_DATE_P, C_BASE_CURRENCY_CODE_P, C_BASE_MIN_ACCT_UNIT_P, C_BASE_PRECISION_P, C_BASE_DESCRIPTION_P — Getter functions returning the corresponding package globals (C_VENDOR, C_DATE, and the base-currency attributes) to the report template and layout. These are the standard "<name>_P" accessors generated by Oracle Reports/XML Publisher.

The user's search term, c_base_min_acct_unit, is the package-level global (and its accessor C_BASE_MIN_ACCT_UNIT_P) that holds the minimum accounting unit of the ledger's base currency — the smallest representable amount defined by that currency's precision.

Tables Accessed

The documented table reference is AP_SYSTEM_PARAMETERS, accessed through its APPS synonym. This table stores Payables system options, including the set of books / ledger context (P_SET_OF_BOOKS_ID) and currency-related defaults used to resolve the base currency and its minimum account unit. The package reads this table in get_base_curr_data to derive the values exposed through the C_BASE_* globals. No writes are documented; the package operates in a read-only reporting capacity.

Usage Notes

This package is not intended for direct invocation from forms or custom code. It is executed by the XML Publisher runtime when the associated concurrent program is submitted. The report driver binds the declared parameters (P_VENDOR_FROM, P_VENDOR_TO, P_DATE_FROM, P_DATE_TO, P_SET_OF_BOOKS_ID, P_CHART_OF_ACCOUNTS_ID, P_MIN_PRECISION, P_CONC_REQUEST_ID, P_DEBUG_SWITCH, P_TRACE_SWITCH), invokes BeforeReport and get_base_curr_data, formats the data, then calls AfterReport. Because the package is AUTHID CURRENT_USER and owned by APPS, it executes with the invoking user's privileges; it is referenced by zero other packages, confirming its role as a leaf-level report unit. Customisations should avoid altering the package body, as reapplication during patching can overwrite changes.