Search Results pay_core_payslip_utils




Overview
Explore in AI Chat

Overview

PAY_CORE_PAYSLIP_UTILS is an internal PL/SQL package body owned by the APPS schema that supports the Oracle Payroll payslip generation infrastructure. Its primary business function is the creation and management of payroll action records required to drive payslip processing within a payroll run. The package resolves how assignment-level and payroll-level actions must be sequenced so that payslip output can be produced correctly for each employee within a payroll action.

The package is classified as OTHER in the ETRM metadata, indicating it is not a public documented API but an internal utility package used by the payroll engine. It is referenced by eleven other database objects, confirming its role as a shared low-level building block. The status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

Four documented program units are defined in the package body:

  • RANGE_CURSOR — A cursor construct used to iterate over the range of assignment actions or payroll actions that require payslip-related processing. It provides the driving data set for subsequent action-creation logic.
  • GET_MAX_NOR_ACT_SEQ — Returns the maximum action sequence number within a normal (NOR) action context. This sequence value is essential for determining the next available action sequence when creating new child actions without colliding with existing ones.
  • ACTION_CREATION — Encapsulates the core logic for creating payroll or assignment action records. It orchestrates the insertion of the action rows that the payslip process depends upon.
  • GENERATE_CHILD_ACTIONS — Generates the child actions associated with a parent action. This is the mechanism by which per-assignment actions are spawned beneath a payroll-level action, enabling payslip output to be produced for each assignment.

No parameter lists are documented; the names and purposes above reflect the documented metadata exclusively.

Tables Accessed

The package references the following tables through APPS synonyms:

  • PAY_ASSIGNMENT_ACTIONS — The core table holding one row per assignment action; the package reads existing actions and inserts new ones.
  • PAY_ASSIGNMENT_ACTIONS_S — The sequence-bearing shadow table used to obtain unique action identifiers. This is directly relevant to the user's search term.
  • PAY_ACTION_INTERLOCKS — Manages interlocks that prevent conflicting concurrent actions from executing simultaneously.
  • PAY_PAYROLL_ACTIONS — Provides the payroll-level action context under which assignment actions are created.
  • PAY_RUN_TYPES_F — Supplies run type attributes that govern how actions are generated.
  • PER_ALL_ASSIGNMENTS_F — Validates and resolves assignments for which payslip actions are created.
  • DUAL — Used for single-row evaluations.

The package also depends on HR_UTILITY and HR_NONRUN_ASACT, indicating reuse of shared HR date and action utilities.

Usage Notes

PAY_CORE_PAYSLIP_UTILS is invoked internally during payroll processing, specifically when payslip-related actions must be generated. It is not designed for direct invocation from Oracle Forms or concurrent programs by end users. Instead, it is called by higher-level payroll packages — the eleven objects that reference it — which in turn are triggered by the payroll run and payslip concurrent processes.

Custom code should not call this package directly, as it is an internal utility subject to change. Any custom payslip logic should use documented public APIs and hook into the payroll action framework rather than manipulating PAY_ASSIGNMENT_ACTIONS or its sequence table directly. The close coupling to PAY_ASSIGNMENT_ACTIONS_S reinforces that action ID generation must flow through the payroll engine.