Search Results pay_payrpact_xmlp_pkg

Overview

PAY_PAYRPACT_XMLP_PKG is a PL/SQL package owned by the APPS schema within Oracle E-Business Suite, classified under the API classification OTHER. It functions as the report logic package for the Oracle Payroll "Payroll Action" concurrent program and associated XML Publisher (BI Publisher) report definition. In the EBS architecture, report-specific PL/SQL packages such as this one encapsulate the procedural logic that the XML Publisher engine invokes at defined execution points during report processing. The package bridges the XML Publisher template layer and the underlying payroll data model, supplying runtime parameters, computed values, and report metadata to the generated XML output.

The "_XMLP_PKG" suffix is standard for EBS report packages tied to XML Publisher report definitions. In EBS 12.1.1 and 12.2.2, these packages typically expose a set of mandatory entry points invoked automatically by the report execution framework. The package is documented as VALID in the target environment and resides entirely in the APPS schema, referencing only SYS.STANDARD within its dependency chain.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions for this package:

• BEFOREREPORT — The mandatory pre-execution entry point. It is invoked before report data retrieval, serving to initialize report-level state, resolve and store runtime parameters, and prepare the session for data querying.
• BETWEENPAGE — The mandatory inter-page entry point. The XML Publisher framework calls it between output pages, commonly used to maintain page-level counters or carry computed values forward across page boundaries.
• AFTERREPORT — The mandatory post-execution entry point. It runs after data retrieval and output generation, typically used for cleanup of temporary state or final formatting logic.
• C_BUSINESS_GROUP_NAME_P — A parameter getter function that supplies the Business Group Name value used in the report header and selection criteria.
• C_REPORT_SUBTITLE_P — A parameter getter function providing the report subtitle string displayed on the output.
• C_PERSON_NAME_P — A parameter getter function returning the person name associated with the report selection, used for identification and display.
• GET_BUSINESS_GROUP — A function that resolves the business group context for the report, deriving the appropriate business group identifier for the executing session.
• GET_PERSON_NAME — A function that retrieves the formatted person name for the report subject, resolving person identification from the payroll data model.

The "C_" prefix on parameter getters follows the EBS convention for report parameter accessors, and the "P" suffix denotes a function return value, consistent with standard XML Publisher report package structure.

Tables Accessed

The provided ETRM metadata documents no explicit table references for this package through APPS synonyms. Report packages of this class characteristically query payroll and HR foundation entities—such as business group definitions and person records—in support of the GET_BUSINESS_GROUP and GET_PERSON_NAME functions, but the metadata excerpt does not enumerate specific tables. The dependency chain lists only SYS.STANDARD, indicating no direct object-level dependencies beyond the PL/SQL runtime and the package specification/body pair itself.

Usage Notes

PAY_PAYRPACT_XMLP_PKG is invoked exclusively by the XML Publisher concurrent processing engine when the associated Payroll Action report is submitted. Administrators and technical users inspect it to trace report parameter derivation, diagnose output defects, and confirm that report logic survives patching. The metadata records zero packages referencing it, confirming it is a terminal consumer rather than a shared utility. It is not an API for custom code; modifications should be made only through Oracle-provided patches or supported extension mechanisms, as direct edits are not upgrade-safe and may be overwritten during patching or cloning in EBS 12.1.1 and 12.2.2 environments.