Search Results pay_population_ranges_pkg




Overview
Explore in AI Chat

Overview

PAY_POPULATION_RANGES_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as an OTHER-type API within the Oracle Payroll module. It is a server-side utility that controls the creation and maintenance of population ranges — the internal groupings of assignment actions that Oracle Payroll builds during the processing of a payroll run. Population ranges determine which assignment actions are bundled together and in what sequence they are submitted to the payroll engine, and they are a prerequisite for the parallel processing of large payroll populations. The package therefore sits between the assignment action generation phase and the actual payroll calculation phase, providing the mechanism by which the payroll process catalogues and orders the work to be performed. The object is documented as VALID in release 12.2.2 of the ETRM reference, and its dependency footprint is confined to the SYS schema and the STANDARD package at the compilation level.

Key Procedures and Functions

Two procedures are documented for this package:

  • PERFORM_RANGE_CREATION — The principal entry point. It drives the assembly of population ranges for the assignment actions that have been selected for a payroll run. Invoking this procedure causes the package to read the pending assignment actions and payroll action context, apply the applicable legislation rules, and write the resulting range definitions into the population ranges table. It is the routine responsible for turning a flat set of assignment actions into the ordered range blocks that the payroll processing engine consumes.
  • RESET_ERRORED_RANGES — A recovery procedure. When a payroll run fails partway through range processing, or when a range is left in an error state, this routine resets those ranges so that they can be re-created and reprocessed. It supports retry and restart of payroll runs without requiring the entire population to be rebuilt from scratch.

No parameter lists are published in the available metadata, and none are asserted here.

Tables Accessed

The package operates across the core payroll transaction tables. It reads and writes PAY_POPULATION_RANGES, the table that stores the range definitions themselves. It reads PAY_ASSIGNMENT_ACTIONS, which holds the individual assignment-level actions generated for the run, and PAY_PAYROLL_ACTIONS, which identifies the payroll action being processed. Processing state and locking are managed through PAY_ACTION_INTERLOCKS, PAY_CHUNK_STATUS, and PAY_TEMP_OBJECT_ACTIONS, the last of which is used for temporary working sets. PAY_LEGISLATION_RULES is consulted to apply the country-specific rules that govern how ranges may be constructed, and PAY_MESSAGE_LINES is used to record diagnostic or error messages. DUAL supports simple single-row queries, and PLITBLM is the standard PL/SQL index-by table of VARCHAR2 used for in-memory collections within the package.

Usage Notes

The package is invoked internally by the payroll processing flow rather than directly by end users, and it is not referenced by any other documented package. In practice it is called from within the payroll run and range-generation logic, and indirectly through concurrent programs that process payroll populations. Custom code or extensions that need to rebuild or clear ranges should call PERFORM_RANGE_CREATION to generate them and RESET_ERRORED_RANGES to recover from failures, but such calls should be restricted to development and support scenarios where the standard payroll flow has stalled. Because the package touches interlock and chunk status records, direct invocation while a payroll run is active risks corrupting run state and should be avoided.