Search Results p_weeks

Overview

PACKAGE: APPS.PAY_IE_P35_XML_PKG is an Oracle E-Business Suite PL/SQL package that supports statutory payroll reporting for the Republic of Ireland. Its name identifies it as the Irish (IE) P35 return generator, producing XML output. The P35 is the annual Irish employer return to the Revenue Commissioners summarising total payroll, income tax (PAYE), Pay Related Social Insurance (PRSI), and the Universal Social Charge (USC) for the tax year. The package is owned by APPS, is classified as OTHER rather than a public API, and is not referenced by any other package in the documented metadata, indicating it is an internal implementation unit invoked by a concurrent program or reporting entry point.

The header comment records a file version of 120.0.12010000.1 dated 27 July 2008, consistent with the package shipping in Oracle EBS 12.1.1 and remaining present in 12.2.2. It is a technology-layer component: it gathers payroll results into PL/SQL collections, renders them as XML against a template, and writes the result to a CLOB for subsequent extraction and transmission.

Key Procedures and Functions

• Populate_P35_Rep — The primary reporting procedure. It accepts a background process identifier (p_bg_id), employee number (p_emp_no), payroll identifier (p_payroll), assignment set (p_assignment_set), reporting period end date (p_end_date), number of weeks (p_weeks), and template name (p_template_name), returning the generated XML in an OUT NOCOPY CLOB parameter. The p_weeks parameter is the figure that carries the number of contribution weeks for the P35 return.
• Populate_Plsql_Table — Builds the in-memory PL/SQL table structure loaded from payroll data, using the same key parameters as the reporting procedure (background process, employee number, payroll, assignment set, end date and weeks). No template or CLOB parameter is required, distinguishing it as a data-assembly step.
• WriteToCLOB — Converts the assembled XML content held in a temporary LOB into the final CLOB output parameter, supporting the transfer of large generated documents.
• Get_Start_Date — Function returning the start date of the reporting period.
• Get_End_Date — Function returning the end date of the reporting period.

Two package-level data structures are declared: an XMLRec record type containing an xmlString VARCHAR2(6000), and tXMLTable, an index-by-BINARY_INTEGER table of XMLRec used to hold rendered XML fragments.

Tables Accessed

The package reads through APPS synonyms. PAY_PAYROLL_ACTIONS and PAY_ACTION_INFORMATION supply payroll run headers and action-level details; PAY_ALL_PAYROLLS_F identifies the payroll defined for the business group; PAY_ASSIGNMENT_ACTIONS links assignments to payroll actions. HR_ASSIGNMENT_SETS and HR_ASSIGNMENT_SET_AMENDMENTS resolve the assignment set scope and its amendment rules. HR_SOFT_CODING_KEYFLEX provides costing key flexfield values used in reporting. FND_LOOKUP_VALUES, FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES supply lookup meanings and site-level profile option values controlling report behaviour. DBMS_LOB and PLITBLM are Oracle-supplied packages used for LOB manipulation and PL/SQL table access rather than application data.

Usage Notes

The package is invoked when an Irish P35 return is requested — typically from a concurrent program submitted through the Payroll responsibility, with parameters corresponding to payroll, assignment set, tax year end date, and weeks. The p_bg_id parameter confirms execution within a background process context, where intermediate results and messages can be tracked. Because the package is documented as OTHER and referenced by no other package, direct calls from custom code are not supported; any extension should be implemented through a copy of the logic or an approved wrapper. Output is returned as a CLOB, so consumers should expect to extract, store or transmit the XML using DBMS_LOB operations. The template name parameter implies the XML layout is defined externally in an XML publisher style template, allowing format changes without modifying the package.