Results for “p_min_inv_amount”

4 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AP_APXINLST_XMLP_PKG is the PL/SQL package that backs the Oracle Payables Invoice Listing report (APXINLST), an XML Publisher/BI Publisher concurrent program. The package encapsulates the report's server-side logic, exposing a set of public package variables and functions that are bound to the report's parameters and layout. Its central role is to accept runtime parameters supplied by the user, derive dependent context values such as the functional currency and precision, resolve NLS (National Language Support) strings, and provide the "before report" and "after report" hooks that Oracle Reports/PUBLISHER invokes during execution.

The parameter p_min_inv_amount is declared at line 10 of the package specification as a NUMBER. It corresponds to the user-facing concurrent program parameter commonly labelled "Minimum Invoice Amount," allowing the user to suppress invoices below a threshold value from the report output. Because it is declared as a package-level variable, its value is set by the report parameter form and is then available to the internal query and any supporting functions for the duration of the report run.

Key Procedures and Functions

The documented 25 functions are predominantly report lifecycle hooks, NLS/context accessors, and formula helpers. Primary entry points include:

Tables Accessed

Only one table is documented as referenced through APPS synonyms: AP_SYSTEM_PARAMETERS. This table supplies Payables system-level defaults, notably the set of books (ledger) identifier and the base functional currency, which the package reads to populate P_SET_OF_BOOKS_ID, C_BASE_CURRENCY_CODE, C_BASE_PRECISION, and related values. The invoice data itself is retrieved by the report's main query, not by this package directly.

Usage Notes

The package is not intended to be called from custom code; it is invoked automatically by the Oracle Reports/PUBLISHER runtime when the APXINLST concurrent program executes. The report parameter form binds user inputs (including p_min_inv_amount, p_date_since, p_invoice_type, and p_sort_option) to the package variables before BEFOREREPORT runs. Customization is normally achieved through the report definition and the concurrent program parameter list rather than by modifying the package. The package header indicates a 120.0 version dated 2007, and it is referenced by no other packages.