Search Results c_batch_status

Overview

PA_PAXARPPR_XMLP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name follows the standard Oracle EBS naming convention for packages associated with Oracle Reports (or XML Publisher) concurrent programs: the suffix _XMLP_PKG indicates that the package acts as the report-side PL/SQL library that supports an XML Publisher (BI Publisher) report, invoked as a concurrent program from the Projects (PA) module. In ETRM 12.2.2 the package is classified as an "OTHER" API, meaning it is not a public, supported integration interface but rather an internal implementation artifact supporting a specific report.

The functional area addressed is project purge. The report supported by this package produces an "Archive Purge Report" (the name pattern PAXARPPR suggests Projects Purge), which presents details of purge batches and the archival/purge activity executed against project data. The package supplies the runtime data, parameter values, and formatting controls needed to render the report correctly, including batch identifiers, descriptions, statuses, through-dates, purge dates, and commit size information. It also provides cover-page and header/footer values such as the company name and the standard Yes/No indicators used throughout the report layout.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions, primarily report triggers and constant accessors:

• BEFOREREPORT and AFTERREPORT — Standard report lifecycle triggers that initialize and finalize report execution, respectively.
• BETWEENPAGE — Executes between report pages, typically used for page-level formatting or state management.
• GET_COVER_PAGE_VALUES — Populates the values displayed on the report cover page.
• GET_COMPANY_NAME — Retrieves the organization/company name used in the report header.
• C_COMPANY_NAME_HEADER_P, C_NO_DATA_FOUND_P, C_DUMMY_DATA_P, C_BATCH_NAME_P, C_BATCH_DESCRIPTION_P, C_BATCH_STATUS_P, C_THROUGH_DATE_P, C_BATCH_STATUS_MEANING_P, C_BATCH_ACTIVE_CLOSED_P, C_YES_P, C_NO_P, C_RUN_PURGE_P, C_COMMIT_SIZE_P, C_BATCH_PURGED_DATE_P — A set of constant/placeholder functions that return fixed or derived strings used as report labels, column headings, and default values. They cover the company name header, no-data and dummy-data placeholders, batch name and description headings, batch status and status meaning, through date, active/closed indicator, Yes/No literals, run-purge indicator, commit size label, and batch purged date.

Tables Accessed

Through APPS synonyms, the package references three database objects:

• PA_IMPLEMENTATIONS — Stores implementation-level configuration and operating unit information; read to derive company and organizational context for the report (e.g., company name).
• PA_PURGE_BATCHES — The purge batch master table; read to obtain batch name, description, status, through date, purged date, and related purge execution attributes displayed in the report.
• DUAL — Used in singleton queries for constant and placeholder value resolution.

Usage Notes

PA_PAXARPPR_XMLP_PKG is invoked indirectly at runtime by the XML Publisher/BI Publisher report engine when the associated Projects purge archive report concurrent program is executed. It is not intended to be called directly from forms or custom PL/SQL code, and ETRM confirms it is referenced by no other packages. Because it is classified as OTHER rather than a public API, customization or direct invocation should be avoided; any required change should be implemented through supported Oracle extension mechanisms or by cloning the report definition. Its dependency footprint is minimal — relying only on SYS.STANDARD and the APPS schema — which reflects its narrow, report-specific role.