Search Results get_p60_details

Overview

The APPS.PAY_IE_P60XML package is an Oracle E-Business Suite database package that supports the generation of the Irish P60 end-of-year tax certificate. The P60 is a statutory document issued by employers in the Republic of Ireland to each employee, summarising taxable pay, PAYE tax deducted, PRSI contributions, and the Universal Social Charge (USC) for a completed tax year. This package provides the technical infrastructure for extracting payroll data, assembling it into an XML structure, and delivering that XML as a CLOB or BLOB suitable for XML Publisher (BI Publisher) report rendering.

The source header (pyiep60p.pkh 120.0.12010000.1) identifies the package as an Application Technology Group deliverable belonging to the Irish localisation (IE) module of Oracle Payroll. It is owned by the APPS schema and classified as OTHER in the ETRM registry, indicating it is not a formal public API but rather an internal helper package consumed by the P60 reporting flow.

Key Procedures and Functions

• GET_P60_DETAILS — The principal entry point. It accepts selection and date-range criteria (a 53-week indicator, start, effective, and end dates) along with business group, assignment set, payroll, consolidation set, and sort-order parameters. It drives the extraction of P60-relevant payroll data for the specified population.
• POPULATE_P60_DETAILS — Overloaded companion that mirrors the selection parameters and additionally accepts a template name and returns an XML payload through an OUT NOCOPY CLOB. This procedure builds the XML document consumed by the report template.
• WRITETOCLOB — Writes the assembled XML record collection out to a CLOB.
• CLOB_TO_BLOB — Converts the CLOB XML payload into a BLOB, required because XML Publisher RTF templates are stored and processed as binary large objects.
• FETCH_RTF_BLOB — Retrieves the RTF template BLOB for a given template identifier, supplying the layout used to render the final P60 output.

Tables Accessed

The package reads from PER_ALL_ASSIGNMENTS_F and HR_ASSIGNMENT_SETS (with its _AMENDMENTS and _CRITERIA children) to resolve the employee population and assignment filtering. Payroll and process context is drawn from PAY_ALL_PAYROLLS_F, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_ACTION_INFORMATION. The core statutory figures reside in PAY_IE_PAYE_DETAILS_F and PAY_IE_PRSI_DETAILS_F, which hold Irish PAYE and PRSI balances respectively. PER_PERIODS_OF_SERVICE and HR_ALL_ORGANIZATION_UNITS supply employment and employer details, while FND_LOBS and DBMS_LOB are used for LOB storage and manipulation, and NLS_DATABASE_PARAMETERS for locale-sensitive formatting.

Usage Notes

PAY_IE_P60XML is not referenced by any other package, confirming it is a terminal consumer invoked directly rather than a reusable API. In practice it is called by the Irish P60 concurrent program or by XML Publisher data definitions tied to that report. Typical invocation is through a concurrent program that passes the business group, payroll, consolidation set, and tax-year date range, then calls POPULATE_P60_DETAILS to obtain the XML CLOB, converts it via CLOB_TO_BLOB, and merges it with the RTF template fetched by FETCH_RTF_BLOB. Customisations should avoid modifying the package body directly, since it is a shipped ATG object; extensions should instead wrap the calls. All access occurs through APPS synonyms under the standard EBS multitenant and MOAC conventions for release 12.1.1 and 12.2.2.