Search Results action_creation

Overview

APPS.PAY_CA_ARCHIVE_RULES is a Canadian (CA) legislation-specific PL/SQL package body within the Oracle E-Business Suite Payroll module. Its stated purpose, per the embedded header comment, is to contain "the rules for archiving for missing assignment report specific to CA legislation." The package encapsulates the logic that determines how payroll action records for assignments missing required payroll actions are identified, filtered, and archived for Canadian payroll operations, with particular emphasis on Quebec-specific regulatory conditions.

The package was originally created on 30-NOV-2005 (version 115.0, author pganguly) and subsequently revised through version 115.5 (07-NOV-2008). The revision history reveals the evolution of its business rules: version 115.1 added conditions for RL1 and RL2 PRE records within both range_cursor and action_creation, and introduced the archive_code procedure. Versions 115.3 and 115.4 added and modified a condition within action_creation to restrict processing to Quebec location assignments for RL1 and RL2. Version 115.5 refined action_creation to verify whether the employee was in a Quebec location for the year in which the Missing Assignments concurrent request executes.

The package is classified as "OTHER" in the ETRM API classification scheme, indicating it is an internal, rules-oriented component rather than a public API intended for external integration.

Key Procedures and Functions

The package exposes three documented units: RANGE_CURSOR, ACTION_CREATION, and ARCHIVE_CODE.

• RANGE_CURSOR — A cursor construct that defines the driving data set processed by the archival logic. Its definition was modified in version 115.1 to incorporate conditions for RL1 and RL2 PRE records, ensuring that only the qualifying rows are selected for subsequent processing by the missing assignment routines.
• ACTION_CREATION — The central procedure responsible for creating payroll action records associated with missing assignment handling. Its logic was repeatedly revised: version 115.1 added RL1 and RL2 PRE conditions; versions 115.3 and 115.4 restricted qualifying records to Quebec location assignments for RL1 and RL2; and version 115.5 further refined the check so that the condition evaluates whether the employee held a Quebec location during the year in which the Missing Assignments concurrent request was executed, rather than relying on a point-in-time check. This final revision aligns the archival behavior with the employee's Quebec status for the relevant payroll year.
• ARCHIVE_CODE — A procedure introduced in version 115.1 (bug 4886285) to handle archiving of code data. It complements ACTION_CREATION by performing the archive-side persistence or code assignment work required by the Canadian missing assignment process.

No parameter lists are documented; behavior should be inferred only from the procedure names and the change history summarized above.

Tables Accessed

The ETRM metadata documents a single table referenced through an APPS synonym: PAY_PAYROLL_ACTIONS. This is the core Oracle Payroll table that stores payroll action records created for assignment-level processing. Given the package's role in "action creation" for missing assignments, PAY_PAYROLL_ACTIONS is the primary write target for the ACTION_CREATION procedure. The RANGE_CURSOR and ARCHIVE_CODE logic would also logically interact with payroll action data, though the metadata confirms only this one table by name.

Usage Notes

PAY_CA_ARCHIVE_RULES is an internal rules package, not a publicly invoked API — the ETRM record shows zero other packages referencing it. It is expected to be driven by the Canadian Missing Assignments concurrent request process, which invokes the package's procedures to evaluate assignments, determine whether qualifying employees are in Quebec locations for the applicable year, create the necessary payroll actions, and archive the corresponding code records. Organizations running Canadian payroll should be aware that the package behavior is highly jurisdiction-sensitive: the 115.3, 115.4, and 115.5 revisions progressively tightened the Quebec location filtering for RL1 and RL2 actions. Direct calls from custom code are not documented and are not anticipated; changes to the archival rules are delivered via Oracle patches rather than customer extension. The header references the file paycaarcyema.pkb at version 120.4.12010000.5, consistent with Oracle EBS 12.1.1 and 12.2.2 file naming conventions.