Search Results pa_pacintar_xmlp_pkg

Overview

PA_PACINTAR_XMLP_PKG is an Oracle Application Object Library package body owned by the APPS schema, classified in the ETRM repository under the generic API classification OTHER. As indicated by the _XMLP_PKG suffix, this package is associated with an Oracle XML Publisher (BI Publisher) concurrent program report, and it belongs to the Oracle Projects (PA) product family. The PL/SQL package body supplies the report-level programmatic logic that XML Publisher executes around the extraction of report data. In the Oracle E-Business Suite 12.1.1 and 12.2.2 architectures, report-specific XMLP packages such as this one are generated or seeded by Oracle to support server-side triggers and post-processing behavior for a data template. The object's name element "PACINTAR" suggests an Oracle Projects report relating to interface or transaction accounting extraction, although the ETRM metadata excerpt does not enumerate the specific report display name. The package ensures the concurrent report executes its pre-report and post-report processing consistently, and it holds a VALID status, confirming the compiled body is present and usable in the database.

Key Procedures and Functions

The documented package body exposes two procedures:

• BEFOREREPORT — A standard XML Publisher report trigger procedure that executes before the report data is generated. It is used to initialize package-level state, set report session context, derive or validate run-time parameters, and prepare any global variables consumed by the report's data model before extraction begins.
• AFTERREPORT — A standard XML Publisher report trigger procedure that executes after report data generation. It is used to perform post-processing tasks, such as resetting package state, releasing resources, and any completion logic required once the report output has been produced.

The ETRM documentation does not list parameter signatures for these procedures; their definitions conform to the XML Publisher trigger convention of an optional function return value used by the report engine to control execution flow.

Tables Accessed

The ETRM metadata reports no documented tables referenced directly by this package through APPS synonyms. This is consistent with XML Publisher helper packages, which typically contain trigger and formatting logic rather than direct DML. Data retrieval for the report is defined in the associated XML data template, which queries the underlying Oracle Projects interface and transaction tables; the package body itself serves as orchestration rather than a data-access layer. Where table references exist at run time, they are resolved through APPS synonyms and the standard Oracle EBS security model.

Usage Notes

PA_PACINTAR_XMLP_PKG is invoked implicitly by the XML Publisher concurrent program engine when the associated Oracle Projects report is submitted. The BEFOREREPORT trigger fires at the start of report execution and AFTERREPORT fires on completion; neither procedure is intended to be called directly by forms, other concurrent programs, or custom code. The ETRM dependency data confirms that this package is not referenced by any other database object, reinforcing its role as a report-private implementation unit bound to a single concurrent program definition. Administrators and developers generally encounter this object when diagnosing report errors, reviewing execution plans, or migrating the owning concurrent program between environments. Because Oracle may regenerate the package body during patching or upgrade, custom modifications are not supported, and any functional changes should be implemented through a copied report definition or a supported extension point.