Search Results generate_child_actions

Overview

APPS.PAY_CORE_PAYSLIP_UTILS is a core Oracle Payroll PL/SQL package that supports the payslip action processing framework within Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary business function is to drive the payroll action lifecycle for payslip generation, including cursor definition, action creation, and the derivation of child assignment actions. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, and it is compiled under the APPS schema. The header comment ($Header: pycopysl.pkh 115.0 2004/04/02) indicates the package has been stable since the early 11i code line and is carried forward unchanged into the 12.x releases. The package is classified as OTHER in the ETRM metadata and is referenced by eleven other packages, underscoring its role as a foundational utility for payroll action orchestration rather than a directly user-facing component.

Key Procedures and Functions

• RANGE_CURSOR — A procedure that constructs the SQL string used to select the range of assignments (or persons) that a payroll action will process. It accepts the payroll action identifier and returns the assembled SQL text via an OUT NOCOPY parameter. This cursor definition underlies the chunking/person-range model used by payroll concurrent processing.
• GET_MAX_NOR_ACT_SEQ — A function returning a numeric value. Based on the name and its parameters (payroll action identifier, assignment action identifier, and effective date), it determines the maximum "normal" action sequence number applicable to a given action context. This value is typically used to compute the next sequence position or to identify the highest existing action sequence for an assignment, supporting correct ordering of derived payslip and child action records.
• ACTION_CREATION — A procedure responsible for creating the payroll action rows for a processing run. It takes the action identifier along with person-range boundaries (start and end person) and a chunk value, plus report type and report qualifier attributes, to instantiate the action records that the payroll engine subsequently processes.
• GENERATE_CHILD_ACTIONS — A procedure that creates child assignment-level actions beneath a parent action. It accepts the assignment action identifier and effective date, and is invoked to expand a parent action into its constituent child actions required for downstream processing such as payslip generation.

Tables Accessed

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

• PAY_ACTION_INTERLOCKS — tracks the relationship and sequencing between parent and child actions; central to the action creation and child action logic.
• PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S — the assignment-level action records (and their shadow/_S variant) that hold per-assignment processing state.
• PAY_PAYROLL_ACTIONS — the parent payroll action definitions for which ranges and actions are created.
• PAY_RUN_TYPES_F — supplies run-type attributes that govern how actions are generated.
• PER_ALL_ASSIGNMENTS_F — the effective-dated assignment records used to resolve the population to be processed.
• DUAL — used for singleton scalar computations, consistent with the sequence-lookup behaviour of GET_MAX_NOR_ACT_SEQ.

Usage Notes

PAY_CORE_PAYSLIP_UTILS is not typically invoked directly by end users. It is called from within the Oracle Payroll action-processing framework — notably from the range cursor and action creation phases executed by payroll concurrent programs — and from other payroll packages (eleven documented dependents). Custom extensions that need to replicate payslip action behaviour, determine maximum action sequence values, or generate child actions should call these documented entry points rather than manipulating the underlying tables directly, to preserve sequencing and interlock integrity. Because the package declares AUTHID CURRENT_USER, callers must possess appropriate privileges on the referenced APPS objects.