Search Results get_label

Overview

PAY_CA_T4A_REG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports Canadian T4A regulatory reporting within Oracle Payroll. The T4A is the Canada Revenue Agency information slip used to report pension and other income amounts paid to recipients who are not employees, such as pensioners, independent contractors, and certain benefit recipients. The package operates as an AUTHID CURRENT_USER program and forms part of the report-generation infrastructure that extracts payroll and assignment data, applies population range criteria, and produces the formatted output required for T4A slip production and filing.

The package is classified as an OTHER API in the ETRM registry for release 12.2.2, indicating that it is an internal processing component rather than a formally published public interface. Its header comment identifies the version as pycat4ar.pkh 120.0, dated 2005, reflecting the legacy lineage of Canadian payroll reporting code that has been carried forward across EBS releases including 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented program units in the package header are as follows:

• RANGE_CURSOR — Builds the SQL cursor string that defines the population of assignment actions to be processed for a given payroll action. It supplies the driving query consumed by the report generation framework.
• ACTION_CREATION — Creates assignment action records for the T4A run, iterating across a specified range of persons defined by start person, end person, and chunk parameters. This supports the chunked, restartable processing model used by Oracle Payroll reporting.
• SORT_ACTION — Constructs and returns the sort SQL applied to assignment action rows, along with the sort length, so that output records are sequenced correctly for the report layout.
• GET_PARAMETER — Retrieves a named parameter value from a supplied parameter list. It is declared with a PRAGMA RESTRICT_REFERENCES (WNDS, WNPS) constraint, confirming it performs no database writes and reads no package state.
• GET_LABEL — Returns the display label for a given lookup type and lookup code. An overloaded form accepts an additional person language argument, enabling multilingual label resolution for T4A form output.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S — Core payroll action and assignment action records that define and track the T4A run.
• PAY_POPULATION_RANGES — Supplies the person range definitions used by RANGE_CURSOR and ACTION_CREATION.
• PER_PERIODS_OF_SERVICE — Provides periods of service used to determine which assignments qualify for T4A reporting.
• FND_LOOKUP_VALUES — Source of lookup codes and meanings resolved by GET_LABEL.
• FF_ARCHIVE_ITEMS, FF_DATABASE_ITEMS, FF_USER_ENTITIES — FastFormula metadata that governs the balances and formulas archived or evaluated for the report.
• HR_ASSIGNMENT_SET_AMENDMENTS — Assignment set amendment data affecting population selection.
• PAY_REPORT_FORMAT_MAPPINGS_F — Report format mapping definitions used to lay out T4A output.
• DUAL — Used for singleton queries and utility evaluations.

Usage Notes

PAY_CA_T4A_REG is invoked indirectly by the Oracle Payroll reporting engine rather than called directly by end users. It is typically driven through the assignment action framework, where a concurrent program or report definition supplies the payroll action identifier, and the range and action creation routines populate and sequence the assignment actions to be processed. The GET_LABEL overloads are commonly referenced from report templates and generation logic to resolve lookup values into printable text in the recipient's preferred language.

Because the package is documented as referenced by one other package, customizations should avoid direct modification. Custom code that requires label resolution or range SQL should call the documented entry points rather than duplicating their logic, and must respect the WNDS/WNPS restrictions declared on GET_PARAMETER when used inside SQL statements.