Search Results xml_rl1_report_start

Overview

PAY_CA_RL1_AMEND_MAG is a Canadian payroll legislative package that supports the generation of an amended magnetic tape RL1 report in Oracle E-Business Suite 12.1.1 and 12.2.2. The RL1 is the Canadian federal government form used by employers to report pensionable, insurable, and taxable earnings and deductions for the tax year. When an original RL1 filing requires correction, this package produces the amended version of that report. The package is owned by APPS and is classified as OTHER within the ETRM repository. It is declared with AUTHID CURRENT_USER and carries the header identifier pycarlamd.pkh, with the last significant revision dated 2012/11/21. Its stated purpose, as recorded in the package header comments, is to support the generation of amended magnetic tape RL1 output.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions. GET_REPORT_PARAMETERS retrieves the runtime parameters that drive the amended report. STORE_FURTHER_INFORMATION and GET_FURTHER_INFORMATION manage a shared list of supplemental data held in the package-level array g_further_info_list, which stores code and amount pairs. RANGE_CURSOR and CREATE_ASSIGNMENT_ACT drive selection and assignment action processing during report population.

The XML-oriented routines form the core of report generation: XML_TRANSMITTER_RECORD builds the transmitter segment, XML_EMPLOYER_START and XML_EMPLOYER_RECORD construct employer-level output, XML_EMPLOYEE_RECORD emits individual employee records, and XML_FOOTNOTE_BOXO produces the footnote box content that accompanies the amended filing. RL1XML_EMPLYER_DATA assembles employer data for the RL1 XML stream, while XML_RL1_REPORT_START and XML_REPORT_END bracket the report with opening and closing structures, and END_OF_FILE signals report termination. GET_ARCH_VAL and ARCHIVE_CA_DEINIT support retrieval from and cleanup of the archive structures used by the process. The cursor mag_rl1_amend_transmitter establishes tax unit context for the transmitter, selecting the payroll action ID and maximum CPP earnings from the legislation information for the reporting year, and grouping results accordingly.

Tables Accessed

The package reads and writes against a documented set of tables accessed through APPS synonyms. HR_ORGANIZATION_INFORMATION supplies the reporting establishment organization context, and PAY_CA_LEGISLATION_INFO provides legislative values such as maximum CPP earnings for the applicable date range. PAY_PAYROLL_ACTIONS identifies the amended RL1 payroll action, while PAY_ACTION_INTERLOCKS, PAY_ACTION_INFORMATION, PAY_ASSIGNMENT_ACTIONS, and PAY_ASSIGNMENT_ACTIONS_S are used for action-level processing and assignment relationships. PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F provide assignment and person records for employee-level reporting, and PER_ADDRESSES supplies address data. The FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, FF_CONTEXTS, and FF_DATABASE_ITEMS tables support archived fast formula and context data. DUAL is used for singleton row selection.

Usage Notes

PAY_CA_RL1_AMEND_MAG is not referenced by any other documented package, indicating it is invoked directly by the concurrent program that produces the amended RL1 magnetic tape output rather than consumed as a shared API. It is typically executed through the Canadian year-end RL1 amendment concurrent process, which supplies the reporting year and organization parameters consumed by GET_REPORT_PARAMETERS. Because the routines are XML-oriented, the package is also relevant to environments generating RL1 output in XML form. The presence of footnote box generation confirms that amended filings include the required explanatory footnotes. Custom code should treat the package as report-generation infrastructure rather than a general-purpose API, and any direct invocation should replicate the parameter and archive initialization sequence established by the standard concurrent program.