Search Results get_asg_ids

Overview

HR_RUNGEN is an Oracle E-Business Suite (EBS) payroll engine package owned by the APPS schema. Its name derives from "Run Generation," and its principal business function is to generate and manage payroll run actions for assignments processed through Oracle Payroll. The package coordinates the creation of payroll action records, consolidates assignments into run groups, and supports the specialized handling required for "Tax Separately" and "Separate Check" processing — logic that originates from legacy bug fixes such as G1188 and G1529 referenced in the source header. It is a low-level, internal package rather than a published API; the ETRM registry classifies it as OTHER and confirms it is not referenced by any other packaged API in the APPS schema, indicating it is invoked directly by Oracle Payroll's own concurrent processing framework.

Key Procedures and Functions

Two procedures are documented in the ETRM metadata for this package:

• GENERATE_RUNS — The primary entry point. It drives the creation of payroll run actions based on a payroll action and a set of eligible assignments. Internally, HR_RUNGEN defines a cursor named get_asg_ids that selects assignment IDs from PAY_ASSIGNMENT_ACTIONS for a given payroll action where the action status is complete (action_status = 'C'). This cursor is the mechanism by which the package obtains the assignment population for which further run generation is required. The procedure also builds assignment sets — including the "Run Gen <action_id>_TSDP ASG Set_" master set — and evaluates how many additional runs are required per assignment.
• DEL_ASG_AMENDS — Deletes assignment set amendment records, cleaning up the staging structures that HR_RUNGEN creates during run generation. This supports repeatable or corrective processing when a prior run generation attempt must be reversed or amended.

Both procedures are declared in the package specification; additional internal helpers such as setup_taxsep_asg_sets exist in the body but are not part of the documented external interface.

Tables Accessed

HR_RUNGEN reads and writes across the core Oracle Payroll and HR assignment set tables:

• PAY_ASSIGNMENT_ACTIONS — The central driving table; populated with the payroll action and assignment-action rows that represent each assignment's participation in a payroll run.
• PAY_PAYROLL_ACTIONS — Provides context for the payroll action being generated, including the primary action ID and business group.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_INPUT_VALUES_F, PAY_ELEMENT_LINKS_F — Queried to count and classify element entries, specifically to identify assignments where "Tax Separately" equals Y and "Separate Check" equals N.
• PAY_CONSOLIDATION_SETS, PAY_CONSOLIDATION_SETS_S — Used to determine and set the correct consolidation set for generated Tax Separately / Separate Check payroll actions.
• PAY_ACTION_INTERLOCKS — Manages sequencing and interdependencies between generated run actions.
• HR_ASSIGNMENT_SETS, HR_ASSIGNMENT_SETS_S, HR_ASSIGNMENT_SET_AMENDMENTS — Store the dynamically created assignment sets and their amendments, which are inserted by GENERATE_RUNS and removed by DEL_ASG_AMENDS.

Usage Notes

HR_RUNGEN is not a public API and is not intended for direct invocation by customer code. It is called internally by Oracle Payroll during the Run Payroll process and by related concurrent programs that manage Tax Separately and Separate Check run generation. Because the package maintains package-level global caches (g_taxsep_asg_sets and g_sepcheck_asg_sets), it expects to operate within a single payroll processing session. Customizations should never invoke HR_RUNGEN directly; instead, the supported approach is to extend payroll processing through element links, input values, and standard payroll setup. Any diagnostic work around "get_asg_ids" results should examine PAY_ASSIGNMENT_ACTIONS for the relevant payroll_action_id where action_status = 'C'.