Search Results pa_paxarpvd_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PA_PAXARPVD_XMLP_PKG is a PL/SQL package that supports the Oracle Projects (PA) concurrent program responsible for the Accounts Receivable Purge Validation report in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The naming convention — the PA module prefix followed by the identifier PAXARPVD and the XMLP_PKG suffix — indicates that this package is the report logic container for an Oracle XML Publisher (BI Publisher) based concurrent program. Its role is to assemble the data, parameter values, validation messages, and layout substitutions required to produce a printed or viewable validation report before an AR purge batch is executed.

The package is owned by the APPS schema, carries a VALID status, and is classified as OTHER in the ETRM metadata. It has no dependents among other packages, meaning it is invoked only through its associated concurrent program definition rather than being called from other PL/SQL units.

Key Procedures and Functions

The ETRM documentation records 17 procedures and functions within the package. These fall into three logical groups.

No parameter lists are documented in the ETRM metadata, and none are inferred here.

Tables Accessed

Three tables are accessed through APPS synonyms. PA_IMPLEMENTATIONS supplies organization and implementation-level setup information, including the values behind GET_COMPANY_NAME and the cover page header. PA_PURGE_BATCHES is the core transaction table: the batch name, description, status, status meaning, through date, and active/closed flag columns all derive from this table and drive the validation logic. DUAL is used for constant expressions and single-row queries within the accessor functions.

Usage Notes

This package is executed when the AR Purge Validation concurrent program is submitted from the Oracle Projects responsibility or from a request set that precedes an actual purge. The report is intended to be run in a read-only validation mode: users review batch identifiers, statuses, and through dates before committing a purge, and may restrict output to error conditions using the report-errors-only option. Because the package has no inbound package dependencies, customization should be limited to the report layout and to the concurrent program definition rather than to direct calls from custom code. In 12.2.2 the XML Publisher architecture replaces the older Oracle Reports runtime, but the package interface remains the same in both releases.