Search Results p_amount_due_high

Overview

APPS.AP_APXINAGE_XMLP_PKG is the server-side PL/SQL package body that supports the Oracle Payables Invoice Aging Report, an XML Publisher (BI Publisher) concurrent program in Oracle E-Business Suite 12.1.1 and 12.2.2. The Invoice Aging Report presents open and outstanding supplier invoices grouped by aging buckets, allowing Payables managers to analyze liability exposure across configurable periods.

Unlike a conventional API package, this package exists to service a report definition. It supplies initialization logic, lexical parameters, session-level NLS strings, currency precision metadata, and the calculated columns that the XML template renders. Every procedure and function is oriented toward preparing data and formatting context for the report output rather than performing transactional business logic. The package is classified as OTHER in the ETRM repository and is not referenced by any other package, confirming its role as a terminal report-support unit.

The user search term p_amount_due_high corresponds to a report parameter used on the Invoice Aging Report to constrain or filter the high end of the amount-due range. It is bound at runtime by the concurrent program's parameter form and evaluated within the package's query and formula logic, alongside the counterpart low-range parameter.

Key Procedures and Functions

• GET_BASE_CURRENCY_DATA — Retrieves the ledger base currency code, precision, minimum accountable unit, and description from AP_SYSTEM_PARAMETERS and FND_CURRENCIES_VL, populating package globals used in currency formatting throughout the report.
• CUSTOM_INIT — Resolves lookup meanings for sort, summary, format, NLS, and invoice-type parameters by querying AP_LOOKUP_CODES and FND_LOOKUPS, and derives party name context from HZ_PARTIES. This drives the report header and grouping behavior.
• GET_COVER_PAGE_VALUES — Builds the cover page content, including company name, report title, and parameter echo values.
• GET_NLS_STRINGS — Loads translated labels and text constants for the report's multilingual output.
• BEFOREREPORT — The standard XML Publisher before-report trigger; orchestrates initialization by invoking the currency, custom-init, cover-page, and NLS routines prior to data retrieval.
• AFTERREPORT — The after-report trigger, used for cleanup or final formatting tasks once the report body has been generated.
• GET_COMPANY_NAME — Returns the operating unit or legal entity name for display on the report header.
• GET_FLEXDATA — Retrieves descriptive flexfield context and segment values associated with report records.
• SET_ORDER_BY — Dynamically constructs the ORDER BY clause based on the user-selected sort option.
• GET_PERIOD_INFO — Returns aging period definitions from AP_AGING_PERIODS and AP_AGING_PERIOD_LINES so the report can label and bound each aging bucket.
• Formula functions — A family of XML Publisher formula columns, including C_CONTACT_LINEFORMULA, C_PERCENT_REMAININGFORMULA, C_INV_DUE_AMT_1FORMULA through C_INV_DUE_AMT_4FORMULA, and C_PER_V_INV_AMT_1FORMULA through C_PER_V_INV_AMT_4FORMULA, which compute due amounts and percentage-remaining values for each of up to four aging buckets.

Tables Accessed

• AP_SYSTEM_PARAMETERS — Source of the base currency code used to determine report currency context.
• AP_AGING_PERIODS — Defines the aging buckets applied to report output.
• AP_AGING_PERIOD_LINES — Provides the lower and upper day boundaries for each aging period.
• HZ_PARTIES — Supplies supplier party name information used in custom initialization and header rendering.

Additional lookups and currency tables (FND_LOOKUPS, FND_CURRENCIES_VL, AP_LOOKUP_CODES) are accessed through documented query logic within CUSTOM_INIT and GET_BASE_CURRENCY_DATA.

Usage Notes

The package is invoked exclusively through the Invoice Aging Report concurrent program, executed from the Payables responsibility. The XML Publisher engine calls BEFOREREPORT before extracting data, then evaluates the formula functions as each row is rendered. Parameters such as p_amount_due_high are supplied by the concurrent program parameter form and consumed during query construction and formula evaluation. Because the package is unreferenced by other PL/SQL units, customizations should be limited to the report definition and its template rather than direct calls to this body.