Search Results get_t4a_pp_regno

Overview

PAY_CA_T4A_MAG is an Oracle EBS Payroll legislative reporting package owned by APPS and delivered under the Canadian (CA) localization. Its stated purpose is to support the generation of magnetic tape T4A reports for Canadian legislative requirements, incorporating magtape resilience features and the redesigned end-of-year processing model. The T4A is the Canadian statement of pension or other income, filed for recipients such as pensioners, and the package encapsulates the data extraction, formatting, and electronic filing logic required to produce the transmitter and employer records that make up the T4A magnetic tape or XML submission. The package is classified as OTHER in the ETRM catalogue, indicating it is an internal supporting object rather than a public API, and it is referenced by one other package. The source header indicates an origin in 2000 with maintenance releases through 2004 (version 115.6), including a change to read tables instead of views in order to avoid security group issues in a multi-organization environment.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions within this package:

• GET_REPORT_PARAMETERS — Retrieves the parameters required to drive the T4A report run. A change list entry records the addition of an out parameter, p_legislative_parameters, at version 115.3.
• RANGE_CURSOR — Supports ranged selection of records, typically to chunk or bound the result set processed by the report.
• CREATE_ASSIGNMENT_ACT — Creates assignment action records associated with the reporting run.
• GET_PARAMETER — Returns individual parameter values used during report generation.
• GET_T4A_PP_REGNO — Added at version 115.4 as part of the fix for bug 2696309. It returns the T4A transmitter's pension plan registration number, a mandatory identifier on the T4A slip and transmitter record. This is the function associated with the user's search term.
• GET_T4A_FOOTNOTE_AMOUNTS — Obtains the footnote amount values printed on the T4A output.
• VALIDATE_GRE_DATA — Validates the Great-West/employer-related data prior to producing output.
• GET_DBITEM_VALUE — Retrieves the value of a database item, resolving data element values used in the report formatting.
• CONVERT_2_XML — Converts the assembled magnetic tape data into XML, reflecting the transition from fixed-format magtape to XML electronic filing.
• CONVERT_T4A_OTH_INFO_AMT — Converts the "other information" amount fields for T4A reporting.
• GET_ARCH_VAL — Returns archived values, used where current data has been superseded by archive records.

Tables Accessed

The package reads through APPS synonyms. Payroll and assignment data are drawn from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_ACTION_INTERLOCKS, and PAY_ACTION_INFORMATION. Person and assignment details come from PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F. Organization context is obtained from HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION. Fast Formula data elements and archive values are resolved via FF_DATABASE_ITEMS and FF_ARCHIVE_ITEMS. DUAL is used for singleton lookups, and PLITBLM is the PL/SQL table used to carry multi-row values in and out of the database. A version 115.6 change replaced views with base tables specifically to remove security group problems.

Usage Notes

PAY_CA_T4A_MAG is invoked indirectly rather than as a standalone user-facing API. It is driven by the Canadian year-end T4A process, typically through concurrent programs that assemble and write the T4A magnetic tape or XML file, and by the corresponding Oracle Payroll legislative report forms. Custom code should not call the package directly: its signature and cursor definitions are internal and subject to change between patch levels, as the change list demonstrates. The history also shows the package is sensitive to security group configuration, so any deployment in a multi-organization environment should account for the table-based access introduced at version 115.6. For the specific search term get_t4a_pp_regno, the function returns the pension plan registration number, and its behaviour is tied to the cursor and employer-data changes made under bug 2696309.