Search Results get_next_proc_chunk

Overview

HR_NONRUN_ASACT is an Oracle EBS HRMS/Payroll PL/SQL package (owner APPS) that performs non-payroll-run assignment action processing. Its header comment dates to the earliest releases of the product (1991–1993), and the package has been maintained continuously through the 12.1.1 and 12.2.2 code lines (header revision pynonrun.pkh 120.0.12010000.1). The package exists to create, interlock, and reconcile assignment action records that are generated outside a standard payroll run — for example, when assignment sets, action classifications, prepayments, or archiver-style legislative processes require assignment actions to be staged or amended directly rather than through the normal payroll engine.

In the ETRM 12.2.2 documentation this object carries the API classification OTHER, and it is referenced by 259 other packages, indicating that it is a widely depended-upon internal utility rather than a public, supported API.

Key Procedures and Functions

The documented procedures and functions (seven total) are:

• GET_NEXT_PROC_CHUNK — Returns the next processing chunk for a non-payroll-run action. It was added in the 23-FEB-2004 revision (115.12) specifically to support chunked processing, complementing the related "get_next_pop" logic whose header block appears in the same source area.
• NAME — The package-level construct listed first in the ETRM inventory; it represents the package specification identity rather than a callable business routine.
• ASACT — Creates/inserts assignment actions for non-payroll-run processing. Change history shows the use_pop_person variable being passed into this routine (2003), and p_actype being passed to REINTERLOCK (2001).
• INSACT — Inserts an action record. Introduced in 1998 so that legislations could call it for Archiver coding; later enhanced with source_action_id (2001), start_date and end_date (2002), and revised parameters (2003).
• INSINT — Inserts an interlock record tying assignment actions to payroll action interlocks; added 05-AUG-1998.
• REINTERLOCK — Re-creates or re-establishes interlocks for existing assignment actions, added 19-MAY-2000 and subsequently passed the action type.
• INS_ADDITIONAL_ASG_ACTION — Inserts an additional assignment action, reflecting multi-assignment prepayment processing; added 20-AUG-2003.

Parameter lists are intentionally not reproduced here; the documented evidence covers behaviour and change history only.

Tables Accessed

Documented table access (via APPS synonyms) is extensive, reflecting the package's role as a staging and reconciliation layer:

• Assignment structure and population: HR_ASSIGNMENT_SETS, HR_ASSIGNMENT_SET_AMENDMENTS, PAY_POPULATION_RANGES.
• Action and action-classification reference data: PAY_ACTION_CLASSIFICATIONS, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S.
• Interlocks and chunk processing: PAY_ACTION_INTERLOCKS, PAY_CHUNK_STATUS.
• Payment and batch detail: PAY_BATCH_HEADERS, PAY_BATCH_LINES, PAY_CONTRIBUTING_PAYMENTS, PAY_CE_RECONCILED_PAYMENTS, PAY_ORG_PAYMENT_METHODS_F, PAY_ALL_PAYROLLS_F.

These tables support identifying the assignment action to create, linking it into the payroll action interlock machinery, tracking chunked progress, and reconciling payment contributions.

Usage Notes

HR_NONRUN_ASACT is classified OTHER and is not a documented public API; it is invoked internally by payroll processing, legislative/Archiver routines, and the 259 packages that reference it. The GET_NEXT_PROC_CHUNK routine is relevant to callers performing chunk-oriented (batched) processing of non-run actions, returning the next work unit. Because parameters and return types are not documented in ETRM, custom code should not call these routines directly; instead, use supported payroll APIs. When troubleshooting, note the 120.0.12010000.1 header version applies to both 12.1.1 and 12.2.2.