Search Results l_payroll_id

Overview

APPS.PAY_GB_HIST_ARCH_PKG is a United Kingdom localization payroll package that supports the archival and forensic-retrieval of historic payroll data within Oracle E-Business Suite. Its central business function is to enable the extraction and archiving of payroll results for assignments that have already been processed by the UK payroll engine, so that historical payslip and payroll records remain available after the live payroll tables have been consolidated or purged.

The package is driven by the standard Oracle Payroll action-processing mechanism. The payroll archiver, an Oracle Payroll engine component, invokes a designated range cursor to partition the population of eligible assignments into chunks, which are then processed in parallel by payroll action workers. PAY_GB_HIST_ARCH_PKG supplies both the parameter-resolution helper used by that cursor and the archiving routine that performs the actual historic data extraction.

Key Procedures and Functions

• GET_PARAMETERS — A private helper procedure that returns the value of a named parameter (token) associated with a given payroll action. It reads from PAY_PAYROLL_ACTIONS and calls PAY_CORE_UTILS.GET_PARAMETER to resolve tokens such as PAYROLL_NAME from the legislative_parameters column. The procedure is instrumented with HR_UTILITY trace and set_location calls and re-raises any exception encountered.
• RANGE_CURSOR — Returns an SQL statement to select all people who may be eligible for payslip reports. The archiver uses this cursor to split the people into chunks for parallel processing. It calls GET_PARAMETERS to resolve the PAYROLL_NAME token for the action.
• ACTION_CREATION — Participates in the creation of the payroll action used to drive the archival process, establishing the action context for subsequent range and archive processing.
• ARCHINIT — Initializes the archival run, preparing the environment and any temporary structures required before individual boundaries are processed.
• ARCHIVE_HISTORIC_DATA — Performs the core archival of historic payroll data for the assignments identified by the range cursor.

Tables Accessed

• PAY_PAYROLL_ACTIONS — Source of the legislative_parameters column read by GET_PARAMETERS to resolve payroll tokens.
• PAY_ACTION_INFORMATION and PAY_ACTION_INTERLOCKS — Action-level data and interlock information for the archival action.
• PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S — Assignment-level action rows governing which assignments are eligible for archival.
• PAY_TEMP_OBJECT_ACTIONS — Temporary object/action mappings used during processing.
• PER_ALL_ASSIGNMENTS_F — The assignment population from which eligible people are drawn.
• DUAL — Used for single-row constant selection in supporting logic.

Usage Notes

The package is invoked by the Oracle Payroll archiver through the standard action parameter and range cursor conventions; it is not intended for direct invocation from forms or concurrent programs. GET_PARAMETERS, though central to the search query, is a private helper and is documented only as a body procedure. The package is referenced by no other packages, is classified as OTHER in ETRM, and carries a noship header, confirming it is a localization-supplied object. It should not be modified; customizations should wrap rather than alter the delivered logic.