Search Results xml_report_end

Overview

PAY_CA_RL1_MAG is an Oracle EBS Canadian payroll legislative package that generates the Relevé 1 (RL-1) information return for the province of Quebec. The RL-1 is the Quebec equivalent of the federal T4 slip, reporting employment income and related deductions for provincial tax purposes. The package belongs to the APPS schema, is classified as OTHER under the ETRM API classification, and holds a VALID status in both EBS 12.1.1 and 12.2.2.

The package produces the RL-1 output in an XML-based format suitable for magnetic media and electronic filing with Revenu Québec. It orchestrates the extraction of payroll results, employee and employer identification data, and provincial legislative parameters, then assembles the formatted emission records through a dedicated internal register package, PAY_CA_RL1_REG. The presence of a parallel federal component in PAY_MAGTAPE_GENERIC indicates that this package mirrors the standard Canadian magnetic media architecture while applying Quebec-specific reporting rules.

Key Procedures and Functions

The package exposes twenty-two documented procedures and functions, which broadly fall into three categories: report initialisation, XML record assembly, and utility support.

• GET_REPORT_PARAMETERS / GET_PARAMETER — retrieve the concurrent program and legislative parameters that drive the RL-1 run.
• GET_SLIP_SEQ_NO — returns the sequential slip number assigned to each employee's RL-1 form.
• VALIDATE_QUEBEC_NUMBER — validates the Quebec identification number supplied for an employee or employer.
• GET_ARCH_VAL — retrieves archived values used during slip reconstruction.
• CONVERT_SPECIAL_CHAR — performs character translation for XML-safe output.
• GET_FURTHER_INFORMATION / STORE_FURTHER_INFORMATION — manage supplementary data carried between phases of processing.
• RANGE_CURSOR — defines the driving cursor over the assignment population.
• CREATE_ASSIGNMENT_ACT — creates the payroll assignment action record associated with the run.
• XML_EMPLOYER_START / XML_EMPLOYER_RECORD / RL1XML_EMPLYER_DATA — build the employer header and identification segments of the RL-1 XML.
• XML_EMPLOYEE_RECORD — builds the individual employee slip segment.
• XML_FOOTNOTE_BOXO — emits the footnote and Box O (Quebec parental insurance and other special amounts) content.
• XML_TRANSMITTER_RECORD — produces the transmitter identification segment required by Revenu Québec.
• XML_REPORT_END / END_OF_FILE / GET_FINAL_XML / FETCH_RL1_XML — close the XML document, signal end of file, and return the assembled XML payload to the caller.

Tables Accessed

The package reads personnel and payroll data primarily through the following documented tables: PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F supply the employee identity and assignment records; PER_ADDRESSES and HR_LOCATIONS_ALL provide address data for slip and employer identification; HR_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION supply organisational and legislative classification values; PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S hold the processed assignment action results that populate each slip; PAY_PAYROLL_ACTIONS and PAY_ACTION_INTERLOCKS govern run and action sequencing; and PAY_CA_LEGISLATION_INFO supplies Quebec-specific legislative parameters.

It also references PAY_ACTION_INFORMATION, FF_ARCHIVE_ITEMS and FF_DATABASE_ITEMS for archived payroll and fast-formula balances, and DUAL for singleton queries. Write activity is confined to the assignment action records created during the run; the remaining tables are read-only sources.

Usage Notes

PAY_CA_RL1_MAG is invoked indirectly from the Canadian Payroll magnetic media and year-end reporting flow. In a typical RL-1 run, the payroll administrator submits the Quebec RL-1 magnetic media concurrent program; the concurrent manager then calls this package to iterate the assignment population, build the XML emission file, and hand the result to the transmitter assembly logic. It is not exposed as an end-user form and should not be called directly by custom code; customisations should extend or wrap the concurrent program instead. Because the package writes PAY_ASSIGNMENT_ACTIONS rows and interacts with PAY_ACTION_INTERLOCKS, runs must be sequenced carefully against payroll action processing. In 12.2.2 the package remains VALID and is referenced by two other packages, confirming its continued role in the Quebec year-end reporting chain.