Search Results get_source_id

Overview

APPS.PAY_CA_PMED is a Canadian payroll localization package body in Oracle E-Business Suite (12.1.1 / 12.2.2) that supports Provincial Medical (PMED) processing — the employer health tax or provincial medical premiums levied by certain Canadian provinces. The package resolves the correct source identifier (source_id) that links a payroll assignment to a valid provincial medical account record maintained in the PAY_CA_PMED_ACCOUNTS table. This source identifier drives downstream payroll costing and remittance processing, ensuring that provincial medical liabilities are attributed to the correct legal employer and remittance account.

The package header comment identifies it as pay_ca_pmed with an internal source header of pycapmcl.pkb, revision 115.1 (2003/03/20). It is classified in ETRM as an OTHER API, meaning it is an internal utility package rather than a formally published public API, and it is not referenced by any other documented package.

Key Procedures and Functions

A single documented program unit exists within the package:

• GET_SOURCE_ID — a function that returns the correct Source Id for a payroll assignment. Its resolution logic operates against two input contexts: the jurisdiction code and the tax unit id, and it accepts a business group, a default jurisdiction account number (used when no explicit account number is supplied), and an account number parameter passed as IN OUT NOCOPY so the resolved value can be returned to the caller. Internally the function declares cursors that look up the source id either directly by account number for the business group or by traversing the legal employer's organization information to match the jurisdiction and account number. The "p_gre" token observed in user searches corresponds to the internal cursor parameter representing the legal employer's organization id (the GRE, or Group Reporting Entity) used to join HR_ORGANIZATION_INFORMATION for provincial reporting information.

Tables Accessed

• PAY_CA_PMED_ACCOUNTS — the primary configuration table holding provincial medical account numbers, their associated source ids, enabled flags, and organization and business group references. GET_SOURCE_ID queries this table both by account number and by joining through organization information to derive the source_id.
• HR_ORGANIZATION_INFORMATION — an Oracle HRMS key flexfield-style descriptive information table. It is referenced multiple times (aliases ogi1 through ogi4) to establish that the organization is classified as HR_LEGAL, that provincial reporting information exists for the specified jurisdiction, and to link the legal employer organization to the provincial medical account record.

Both tables are accessed through APPS synonyms, confirming the package executes under the APPS schema with standard EBS data security and synonym conventions.

Usage Notes

Because the package is classified as OTHER and is referenced by no other documented package, it is typically invoked indirectly by Canadian payroll processes rather than by customer-written code. It is most likely called during payroll run processing, prepayments, or costing routines that must associate an assignment's provincial medical deduction with the correct remittance source. Typical invocation paths include the Canadian payroll calculation engine, provincial medical reporting or remittance concurrent programs, and any localization logic that resolves legal-employer-level account mappings. Custom integrations should avoid depending directly on this internal package, since it is an unsupported internal object; the supported route for provincial medical configuration is through the standard Canadian payroll setup forms that populate PAY_CA_PMED_ACCOUNTS and HR_ORGANIZATION_INFORMATION. The IN OUT NOCOPY account number parameter indicates the function is designed for tight internal loops where the resolved account number is reused by the caller, reinforcing its role as an internal resolution utility rather than a standalone public API.