Search Results get_header_xml

Overview

APPS.PAY_CA_T4_XML is a Canadian payroll year-end reporting package within Oracle E-Business Suite, responsible for generating T4 tax slip data in XML format. The T4 is the Canadian federal statement of remuneration paid, issued annually to employees and filed with the Canada Revenue Agency (CRA). This package assembles the structured XML payload that represents T4 slips, including header, trailer, assignment-level, and final submission elements, so that the output conforms to CRA electronic filing specifications.

The package is registered in the APPS schema and is currently VALID. Its API classification is OTHER, and it exposes eleven documented procedures and functions. Functionally, it depends on the payroll assignment action and magtape infrastructure (PAY_ASSIGNMENT_ACTIONS and PAY_MAGTAPE_GENERIC), which places it within the standard Oracle Payroll year-end reporting framework rather than as a standalone utility.

Key Procedures and Functions

The documented procedures and functions cover the full lifecycle of T4 XML construction and retrieval:

• GET_ASG_XML — produces the XML fragment for an individual assignment (employee) T4 record.
• GET_HEADER_XML — produces the header portion of the T4 XML submission.
• GET_TRAILER_XML — produces the trailer portion, typically summarizing totals for the submission.
• GET_FINAL_XML — assembles the final, complete XML document from its constituent parts.
• FETCH_T4_XML — retrieves the generated T4 XML content, generally for output or archival.
• CREATE_XML_STRING — builds the underlying XML string representation.
• GET_OUTFILE — returns the output file reference for the generated XML.
• GET_IANA_CHARSET — supplies the IANA character set identifier applied to the XML output encoding.
• GET_EI_EARNINGS_DISPLAY_FLAG — determines the display flag governing employment insurance (EI) earnings presentation.
• STORE_OTHER_INFORMATION — persists supplementary information associated with the T4 generation process.
• GET_OTHER_INFORMATION — retrieves that stored supplementary information.

Together these routines separate the concerns of data gathering, XML fragment construction, encoding determination, and file output.

Tables Accessed

The package reads from a defined set of payroll, HR, and FastFormula archive tables through APPS synonyms. Assignment and person data derive from PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F, with organization and location context supplied by HR_ALL_ORGANIZATION_UNITS and HR_LOCATIONS_ALL. Payroll processing context comes from PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS. Legislative parameters for Canadian payroll are drawn from PAY_CA_LEGISLATION_INFO, while FND_LOOKUP_VALUES supplies supporting lookup codes.

FastFormula archive structures — FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, FF_CONTEXTS, and FF_DATABASE_ITEMS — are accessed to resolve balances and calculation inputs used in the T4 amounts. DBMS_LOB supports large object handling for XML content, DUAL and PLITBLM serve as standard utility references, and PAY_MAGTAPE_GENERIC provides the magtape-style filing infrastructure shared with other year-end formats.

Usage Notes

PAY_CA_T4_XML is typically invoked indirectly through the Oracle Payroll Canadian year-end T4 processes rather than called directly by end users. The generating concurrent program drives the extraction, using PAY_MAGTAPE_GENERIC conventions to select assignment actions and produce the submission file identified by GET_OUTFILE. Within that framework, GET_HEADER_XML, GET_ASG_XML, GET_TRAILER_XML, and GET_FINAL_XML are orchestrated to compose the complete document.

The package is not referenced by any other documented package, indicating it functions as a terminal reporting component. Customizations should avoid modifying the packaged logic directly; instead, character set handling through GET_IANA_CHARSET and EI earnings presentation via GET_EI_EARNINGS_DISPLAY_FLAG should be treated as configuration-sensitive. Because T4 output must satisfy CRA format rules, changes to encoding or XML structure require validation against current CRA electronic filing requirements for the applicable tax year.