Search Results pay_paycnsoe_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_PAYCNSOE_XMLP_PKG is a PL/SQL package body in the Oracle E-Business Suite Oracle Payroll module. Its name follows the standard XML Publisher (BI Publisher) concurrent program naming convention: the PAY prefix identifies the Oracle Payroll product, and the XMLP_PKG suffix indicates that the body backs a report definition executed through the XML Publisher engine. The report it supports is the Payroll Consolidation Statement, a statutory-style output that summarizes payroll balances for an employee or organization over a defined period. The package is responsible for preparing the data and derived values that the report template consumes, including currency formatting, legislative context, and the aggregation of taxable, non-taxable, voluntary, and statutory earnings for both the current pay period and year-to-date. The package is owned by the APPS schema and is currently VALID in the ETRM 12.2.2 metadata.

Key Procedures and Functions

The package exposes 31 documented procedures and functions. The most significant are summarized below.

Tables Accessed

The package references several APPS synonyms. FND_CURRENCIES and FND_CURRENCY are used to resolve currency codes and formatting attributes. HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION supply organization and business group details. PAY_CONSOLIDATION_SETS holds the consolidation definitions that determine which payroll results are grouped together for the statement.

Usage Notes

PAY_PAYCNSOE_XMLP_PKG is normally invoked indirectly. The XML Publisher concurrent program invokes the report's data model, which calls this package to populate the XML data source. It is not referenced by any other database object and is not intended for direct invocation from forms or custom code. Because it is an XMLP support package, it is versioned with the report definition and should be modified only through the supported Oracle patch process.