Results for “pay_ca_pmed”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_CA_PMED is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports Canadian Payroll processing, specifically the handling of Payer Medical (PMED) account information required for Canadian tax reporting. The package name and its internal references indicate that it functions within the Canadian Payroll (Payroll Canada) legislative framework, where employer and payer account identifiers, such as a payer ID or "CMED" identifier, must be resolved against jurisdiction and tax unit information before remittance files or year-end slips can be generated. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, a standard convention for utility and lookup packages that are invoked from multiple payroll flows.

The documented header, identified by the source control tag pycapmcl.pkh dated 2003, indicates the package has been a stable component of the Canadian Payroll codebase since the early 11i era and remains present in the 12.1.1 and 12.2.2 releases. Its API classification in the ETRM metadata is "OTHER," confirming that it is not a public, supported API but rather an internal helper used by the Canadian Payroll engine.

Key Procedures and Functions

The ETRM metadata documents a single public function, GET_SOURCE_ID. This function resolves and returns a source identifier as a numeric value, given a jurisdiction code, a tax unit identifier, a business group identifier, an indication of a differing jurisdiction, and an account number supplied as an IN OUT parameter. The account number parameter being passed by reference and marked NOCOPY suggests that the function may normalize, truncate, or otherwise correct the incoming account value while returning the corresponding source ID. In practice, this routine is used to translate a Canadian payer or medical account reference into the internal identifier expected by downstream payroll and tax reporting processes. No other procedures or functions are documented for this package; the specification consists solely of GET_SOURCE_ID between the package declaration and its closing END statement.

Tables Accessed

Two underlying objects are referenced through APPS synonyms. PAY_CA_PMED_ACCOUNTS is the principal table, holding the Canadian payer medical account definitions keyed by jurisdiction, tax unit, and business group. GET_SOURCE_ID queries this table to derive the source identifier and to validate or return the account number. HR_ORGANIZATION_INFORMATION is a standard HR foundation table that stores organization-level descriptive and classification attributes; its inclusion indicates that the package also reads organization context, most likely to associate the business group or legal entity with the appropriate Canadian tax account. The package does not appear to write to either table; its role is resolution and lookup rather than maintenance.

Usage Notes

PAY_CA_PMED is an internal package and is not exposed through a concurrent program or a standard Oracle Payroll form. It is invoked from other Canadian Payroll PL/SQL units during the calculation of payroll, the preparation of Canadian tax remittance data, and the generation of T4 and related year-end reporting where a payer account must be mapped to its source. Custom code, fast formulas, or extensions that need to resolve a Canadian payer medical account should call GET_SOURCE_ID rather than querying PAY_CA_PMED_ACCOUNTS directly, so that jurisdiction and business group logic is applied consistently. The ETRM metadata records zero packages referencing this object, which reflects the fact that its callers reside outside the ETRM dependency graph, typically within generated or obsolete Payroll Canada routines. Because the package is not a public API, its signature should be treated as subject to change between patch levels, and direct dependencies should be validated during upgrades from 12.1.1 to 12.2.2.