Search Results del_asg_amends

Overview

APPS.HR_RUNGEN is an Oracle E-Business Suite PL/SQL package that provides the server-side logic used to generate payroll runs. It is the programmatic engine behind the "Run Payroll"-type processing that creates and populates payroll actions, assignment actions, and the associated element entries required to calculate pay for a selected population of assignments. In Oracle Payroll, a "run" is the execution of a payroll process (for example a regular run, a supplemental run, or a special process) against a payroll, a consolidation set, and a set of assignments for a defined time period.

The package is created with AUTHID CURRENT_USER, meaning that name resolution and privileges are evaluated in the context of the invoking user rather than the package owner. Its two documented entry points are GENERATE_RUNS and DEL_ASG_AMENDS. A private exception, zero_req_id, is declared and initialized against Oracle error -9999 to signal a missing concurrent request identifier during processing.

Key Procedures and Functions

• GENERATE_RUNS — The primary driver procedure. It accepts a range of parameters that identify the run to be built, including a process name (the ACTION_TYPE on the payroll action, defaulting to 'RUN'), a payroll action identifier, a payroll identifier, a consolidation set identifier, an earned date and a date paid, an assignment set identifier, an element set identifier, legacy/leg parameters, and a pay advice message. It exposes standard concurrent-program out parameters (ERRBUF and RETCODE) so it can be called directly as a concurrent program. The p_leg_params argument selects the run type: 'R' for Regular, 'S' for Supplemental, 'SEPCHECK', or 'SPECIALPROC'.
• DEL_ASG_AMENDS — Accepts an assignment set identifier and removes assignment set amendment records associated with that set. It supports housekeeping of amendment definitions following run generation or during corrective processing.

Tables Accessed

The package reads and writes the core payroll action and assignment action tables that constitute a payroll run:

• PAY_PAYROLL_ACTIONS — the payroll action being created or maintained (the run header).
• PAY_ASSIGNMENT_ACTIONS — one row per assignment processed within the run.
• PAY_ACTION_INTERLOCKS — sequencing and dependency records between payroll actions.
• PAY_CONSOLIDATION_SETS / PAY_CONSOLIDATION_SETS_S — the consolidation set definitions used to group the run for costing and reporting.
• HR_ASSIGNMENT_SETS / HR_ASSIGNMENT_SETS_S and HR_ASSIGNMENT_SET_AMENDMENTS — the assignment set that defines the population to be processed, together with its amendments (relevant to DEL_ASG_AMENDS).
• PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, and PAY_INPUT_VALUES_F — the element link and entry structures populated so that the run has the element entries and input values required for calculation.

Usage Notes

HR_RUNGEN is not a public, general-purpose API intended for arbitrary customer extension. It is invoked internally by the Oracle Payroll run-generation flow — typically through the concurrent program that creates a payroll run from a submitted payroll action — and by the payroll forms that submit and manage runs. Because it is not referenced by any other documented PL/SQL package, it is best understood as a top-level entry point rather than a shared service routine.

The presence of the standard ERRBUF/RETCODE out parameters confirms that it is designed to be registered and executed as a concurrent program. Custom code should not call GENERATE_RUNS directly unless replicating Oracle's own invocation pattern; the parameters map closely to internal payroll action state, and incorrect values for the process name, leg parameters, or consolidation set can leave the run in an inconsistent state. The authoritative behavior of this package is defined by Oracle's payroll processing rules, and its documented metadata here is intentionally limited to the procedure signatures and the tables involved.