Search Results cf_calculate_total_prsiformula

Overview

APPS.PAY_PAYIEP30_XMLP_PKG is the generated PL/SQL package that backs the Oracle Payroll seeded XML Publisher concurrent program PAYIEP30, the Irish Payroll End of Year / P30 and P35-related legislative report. In Oracle EBS 12.1.1 and 12.2.2, seeded BI Publisher (XML Publisher) reports are produced by a report-specific package whose name is derived from the report short name with the suffix _XMLP_PKG. The package supplies the data model for the report: it accepts the concurrent program parameters, executes the driving SQL against Payroll and HR tables, populates global variables that act as report placeholders, and exposes value-returning functions (the _P functions) that the XML template calls to embed computed figures into the generated output. The package is compiled with AUTHID CURRENT_USER and is owned by APPS, confirming it runs with the privileges of the invoking APPS session. It is classified in ETRM as an "OTHER" API object, meaning it is not a supported public interface but an internal implementation object generated for the report.

Key Procedures and Functions

The documented package exposes twenty-two procedures and functions. BEFOREREPORT and AFTERREPORT are the standard XML Publisher report triggers; BEFOREREPORT performs pre-query initialization (legislation and currency setup, date handling), while AFTERREPORT closes out processing. Formatting helpers include CF_BUSINESS_GROUPFORMULA, CF_LEGISLATION_CODEFORMULA, CF_CURRENCY_FORMAT_MASKFORMULA and SET_CURRENCY_FORMAT_MASK, which derive the business group name, the legislation code, and the currency display mask. CF_CALCULATE_TOTAL_PRSIFORMULA computes aggregated PRSI (Pay Related Social Insurance) amounts per report and assignment, and CF_PAYROLL_NAMEFORMULA resolves a payroll identifier into its descriptive name. P_BUSINESS_GROUP_IDVALIDTRIGGE is the parameter validation trigger for the business group parameter. The remaining functions are accessors returning report figures: CP_PAYE_YTD_P, CP_EE_PRSI_YTD_P, CP_ER_PRSI_YTD_P (year-to-date PAYE, employee PRSI, and employer PRSI), CP_TOTAL_PRSI_REPORT_P and CP_TOTAL_PRSI_YTD_P, the period-to-date accessors CP_PAYE_PTD_P, CP_EE_PRSI_PTD_P, CP_ER_PRSI_PTD_P, and the descriptive accessors CP_PAYROLL_ID_P, CP_SUPPLEMENTARY_RUN_P, and CP_REPORT_DATE_P. The last of these corresponds to the reported search term cp_report_date_p, the accessor for the report date global.

Tables Accessed

The package reads Payroll and HR data through APPS synonyms. Payroll action and action-information data come from PAY_PAYROLL_ACTIONS, PAY_ACTION_INFORMATION, PAY_ACTION_INTERLOCKS, and PAY_ASSIGNMENT_ACTIONS. Balance data used for PAYE and PRSI totals is sourced from PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, and PAY_BALANCE_DIMENSIONS. Legislative behaviour is driven by PAY_LEGISLATION_RULES. Organization and business group descriptions are obtained from HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION, and currency formatting attributes come from FND_CURRENCIES. No insert, update or delete activity is documented; the package is read-only with respect to these tables.

Usage Notes

PAY_PAYIEP30_XMLP_PKG is invoked indirectly by the concurrent manager when the PAYIEP30 XML Publisher report is submitted; the report template drives calls to the _P accessor functions. It is not referenced by any other PL/SQL package (referenced by 0 packages in the ETRM metadata), confirming that its consumers are the XML Publisher engine and the report definition rather than application code. Direct invocation from custom code is not supported; the documented interface belongs to the report's internal data model, and the global variables are populated only within a report run.