Search Results pay_ca_payrg_pkg




Overview
Explore in AI Chat

Overview

PAY_CA_PAYRG_PKG is an Oracle Payroll package owned by the APPS schema and shipped as part of the Oracle E-Business Suite Canadian Payroll (Payroll Canada) product family. It is a VALID database package comprising a specification and a package body, and is classified in the ETRM repository as an "OTHER" API rather than a formally published public interface. Its core business purpose is the processing and presentation of Canadian payroll run results — specifically the pay run group and earnings-balance reporting logic used by Canadian payroll output and payslip-style reporting. The package bundles utility logic for driving balance-based reporting views (such as PAY_CA_EARN_BALANCES_ALL_RBR_V and PAY_CA_SOE_EARN_BALANCES_RBR_V), handling range-based cursors, sorting the resulting action rows, resolving parameters, and formatting balance names for display. Because it is not an officially supported public API, it should be treated as a diagnostic or internal dependency rather than a supported integration point.

Key Procedures and Functions

The ETRM documentation records five procedures/functions within PAY_CA_PAYRG_PKG:

  • RANGE_CURSOR — constructs and manages the range-based cursor used to drive the balance/earnings reporting query, enabling the reporting views to iterate over the payroll action and balance data selected by the caller.
  • ACTION_CREATION — handles the creation or initialization of payroll action-related records used by the reporting process, setting up the action context against which balances are evaluated.
  • SORT_ACTION — performs the ordering of payroll action rows so that reporting output appears in a consistent, meaningful sequence.
  • GET_PARAMETER — retrieves parameter values supplied to the reporting routine, allowing the package to resolve caller-supplied selection criteria.
  • HOURS_BAL_NAME — resolves or derives the balance name associated with hours, supporting the display of hours-based earnings balances in the Canadian reporting views.

Parameter lists and return types are not documented in the ETRM excerpt and should not be assumed; the descriptions above reflect the evident functional role of each routine.

Tables Accessed

Access to base tables occurs via APPS synonyms. The package references:

Usage Notes

PAY_CA_PAYRG_PKG is not an API intended for direct customer invocation; it is invoked indirectly by the Canadian balance reporting views (PAY_CA_EARN_BALANCES_ALL_RBR_V and PAY_CA_SOE_EARN_BALANCES_RBR_V), which surface its logic to concurrent programs, reports, and payslip-style output. Two other packages reference it, and it in turn depends on SYS.STANDARD. Remediation planning should account for its role as an internal dependency of those views rather than as a supported extension point.