Search Results g_invoicegroupfilter

Overview

APPS.AP_APXPPHIS_XMLP_PKG is a PL/SQL package that supports the Oracle Payables historical payments report, internally associated with the APXPPHIS XML Publisher (BI Publisher) concurrent program. The package encapsulates the report-level logic required to prepare runtime data, resolve user-entered report parameters, derive language-dependent (NLS) strings, and return control values to the report layout engine before and after report execution. It forms the technical backbone behind the "Payments History" style output that lists payment records for a given set of books, vendor, and payment date range, with optional detail printing.

The package is owned by APPS and is classified under the OTHER API classification, indicating it is an internal implementation object rather than a supported public API. It is not referenced by any other package, confirming its role as a leaf-level report support unit invoked directly by the Oracle Reports / XML Publisher runtime rather than by application code.

Key Procedures and Functions

The documented surface of the package consists of 24 procedures and functions. The principal logic is contained in the following:

• BEFOREREPORT — Standard report trigger executed before the report body is generated; drives initialization and parameter preparation.
• AFTERREPORT — Corresponding post-report cleanup trigger.
• CUSTOM_INIT — Performs package-level initialization and custom setup.
• GET_COVER_PAGE_VALUES — Populates cover-page fields displayed at the top of the report output.
• GET_BASE_CURR_DATA — Retrieves base currency attributes (code, precision, minimum accounting unit, description).
• GET_COMPANY_NAME — Resolves the company/legal entity name used in the report header.
• GET_FLEXDATA — Builds the concatenated key flexfield segment string (P_FLEXDATA) used for display.
• GET_NLS_STRINGS — Loads translated strings (Yes/No/All, "no data exists," vendor type, end-of-report text).
• CALCULATE_RUN_TIME — Computes and formats the report run timestamp.
• G_INVOICEGROUPFILTER — The function associated with the search term g_invoicegroupfilter; it implements the invoice group filter condition applied to the report query.
• Getter functions — C_BASE_CURRENCY_CODE_P, C_BASE_PRECISION_P, C_BASE_MIN_ACCT_UNIT_P, C_BASE_DESCRIPTION_P, C_COMPANY_NAME_HEADER_P, C_REPORT_START_DATE_P, C_NLS_YES_P, C_NLS_NO_P, C_NLS_ALL_P, and C_NLS_NO_DATA_EXISTS_P expose the corresponding package-level variables to the report layout.

Tables Accessed

The package reads AP_SYSTEM_PARAMETERS through the APPS synonym. This table supplies system-level Payables configuration, most notably the Set of Books (ledger) identifier and associated currency and precision defaults that the report requires to derive base currency context and to constrain payment data to the correct accounting books. No other tables are documented as being directly accessed by the package; the primary payment data is retrieved by the underlying report query rather than by package code.

Usage Notes

AP_APXPPHIS_XMLP_PKG is invoked automatically when the APXPPHIS concurrent program (Payments History report) is submitted from the Payables responsibility or scheduled through the concurrent manager. The BeforeReport trigger calls the initialization, cover-page, NLS, flexfield, and run-time functions, while the C_*_P getter functions are called from the report template to render values. Because the package is classified OTHER and exposes no documented public API, custom code should not call it directly; the supported extension approach is to modify or wrap the concurrent program definition and report template, or to use supported Payables APIs and views for custom reporting. Any customization should account for the base-currency and set-of-books dependencies resolved from AP_SYSTEM_PARAMETERS, since these determine precision and formatting in the output.