Search Results pay_ca_rl1_can_mag




Overview
Explore in AI Chat

Overview

PAY_CA_RL1_CAN_MAG is an Oracle EBS Payroll (PAY) package body owned by the APPS schema, classified as a Canadian legislative/regulatory reporting utility. The "CA_RL1" naming convention identifies it as part of the Canadian Record Layout 1 (RL-1) reporting family, which produces the annual Relevé 1 tax slip required by Revenu Québec. The "CAN_MAG" suffix associates it with the Canadian magnetic media (magtape) generation and archival framework, alongside related packages such as PAY_CA_RL1_MAG, PAY_CA_RL1_REG, and PAY_MAGTAPE_GENERIC.

This package body specializes the generic magtape infrastructure for the Quebec RL-1 filing. It assembles employee, employer, and transmitter data into the XML structure accepted by Revenu Québec for electronic filing, while also reading from the archive tables that hold the frozen year-end payroll results. The package is status VALID in both 12.1.1 and 12.2.2, and is not referenced by any other database object, indicating it is an entry-point package rather than a shared library.

Key Procedures and Functions

The ETRM metadata documents 13 procedures and functions. Their responsibilities are:

Tables Accessed

Dependencies show the package reads assignment and action data through PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_ACTION_INFORMATION, PAY_ACTION_INTERLOCKS, and PAY_PAYROLL_ACTIONS; person and assignment context through PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PEOPLE_F, PER_PEOPLE_EXTRA_INFO, and PER_ADDRESSES; organization and legislative lookups via HR_ORGANIZATION_INFORMATION, HR_LOCATIONS, HR_LOOKUPS, and HR_ASSIGNMENT_SET_AMENDMENTS; and archived/definition data through FF_ARCHIVE_ITEMS and FF_DATABASE_ITEMS. DUAL and PLITBLM are used for utility and PL/SQL table operations. These accesses supply the employee, employer, and archived values serialized into the RL-1 XML output.

Usage Notes

PAY_CA_RL1_CAN_MAG is invoked through the Canadian year-end magtape/electronic filing flow, typically triggered by the associated concurrent program for RL-1 magnetic media generation. It should not be called directly from custom forms; customizations should instead invoke the delivered concurrent program. Because it depends on archived payroll results, the archive process must have completed before the package is run. It is not referenced by other database objects, so its execution is driven entirely by the concurrent manager or the parent magtape driver.