Search Results gen_footer_xml

Overview

APPS.PAY_IE_P45PART3_P46_PKG is an Oracle E-Business Suite payroll package that supports Irish statutory payroll reporting. Its name associates it with the P45/P46 family of Irish Revenue returns, which employers must produce when an employee leaves a position (P45) or when details of a new employee or a change in employment circumstances must be reported (P46). In Oracle Payroll, this class of reporting is delivered through the Irish legislative payroll solution, and this package provides part of the reporting pipeline for the Part 3 / P46 segment of that process.

The package is declared with AUTHID CURRENT_USER, meaning its unqualified object references resolve against the schema of the invoking session rather than the APPS schema that owns the package. In practice it is executed from the APPS environment where synonyms for the underlying HR and Payroll tables are visible. State is held in package-level variables such as g_payroll_id, g_business_group_id, g_start_date, g_end_date, g_person_id, g_employer_id, g_file_type, g_rep_group, g_pact_id, and g_archive_effective_date, which carry payroll selection context across the reporting run. A set of WHERE-clause fragments (g_where_clause through g_where_clause3) is also maintained to isolate the records relevant to each reporting phase.

Key Procedures and Functions

The package exposes seven documented program units:

• RANGE_CODE — Accepts a payroll action identifier and returns a SQL string. It is the range-code routine used by the payroll action framework to determine which assignment actions belong to the reporting run.
• ASSIGNMENT_ACTION_CODE — Processes assignment actions within a defined person range or chunk, allowing the payroll engine to partition work across assignment actions for the selected payroll action.
• ARCHIVE_INIT — Accepts a payroll action identifier and performs initialization for the archive phase, establishing the context required before data is written to archive tables.
• ARCHIVE_DATA — Accepts an assignment action identifier and an effective date, and archives the reporting data for that assignment action as of the specified date.
• GEN_BODY_XML — Generates the body portion of the output XML document. It drives the extraction cursor c_body, which selects TRANSFER_ACT_ID values from pay_assignment_actions for the transfer payroll action stored in the PAY_MAGTAPE_GENERIC parameter set.
• GEN_HEADER_XML — Generates the header portion of the XML output. It uses cursor c_hdr, which reads the TRANSFER_PAYROLL_ACTION_ID parameter via pay_magtape_generic, so the header identifies the payroll action being reported.
• GEN_FOOTER_XML — Generates the footer portion of the XML output, completing the document produced by the header and body generators.

Tables Accessed

The package reads and processes data from the core Oracle Payroll and HR tables, accessed through APPS synonyms: PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS (and PAY_ASSIGNMENT_ACTIONS_S) for the reporting run and its assignment-level actions; PAY_ALL_PAYROLLS_F for payroll definitions; PAY_ACTION_INFORMATION and PAY_FILE_DETAILS for run parameters and output file records; PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_INPUT_VALUES_F and PAY_ELEMENT_TYPES_F for earnings and deduction balances; HR_ORGANIZATION_INFORMATION, HR_LOCATIONS_ALL and PER_ADDRESSES for employer and employee address and organization details; FND_LOOKUP_VALUES for reference codes; and DUAL as the source for singleton header parameters. The cursor definitions in the specification confirm that PAY_ASSIGNMENT_ACTIONS and DUAL are queried directly for header and body extraction.

Usage Notes

This package is an internal component of the Irish P45/P46 reporting flow rather than a public API. Within Oracle Payroll, packages of this type are invoked by the payroll action framework: archive_init and archive_data support the archive phase of a payroll action, while range_code and assignment_action_code support action-level processing and partitioning. The XML generation routines (gen_header_xml, gen_body_xml and gen_footer_xml) are the routines most relevant to the search term "gen_footer_xml" and are called to assemble the electronic return document from archived payroll data. The package is not referenced by any other documented package, indicating that it is invoked directly by the concurrent program or payroll process that owns the Irish P45/P46 report. Customizations should avoid modifying it directly, as the source header identifies it as a standard Oracle-delivered file (pyiep45p3p46.pkh) at version 120.0.12010000.1, and it is subject to change through standard patch application in both EBS 12.1.1 and 12.2.2.