Search Results upd_payroll_actions




Overview
Explore in AI Chat

Overview

PQP_EXPREPLOD_PKG is an Oracle EBS Human Resources (Oracle Payroll) package owned by the APPS schema. Its name derives from "Exception Report Load", and it supports the multi-threaded processing and loading of payroll exception report data. Exception reports are a core payroll control that compares expected and actual payroll results across consolidation sets, surfacing variances to payroll administrators before a payroll run is finalized. The package provides the cursors and driver logic required to execute that processing across multiple threads, which is essential when a payroll encompasses large assignment volumes, multiple payrolls, or multiple consolidation sets that must be processed in parallel.

The package also contains a set of date and tax-year derivation functions used to determine the correct reporting period — financial tax year start, prior tax year, prior quarter, and offset dates — ensuring exception and statutory reporting is anchored to the correct legislation-based time frame. The header comment dates from 2005 and identifies the object as a shared (non-shipped, "noship") development artifact, indicating it is a long-standing internal component of the Payroll exception reporting infrastructure.

Key Procedures and Functions

  • LOAD_DATA — Loads payroll data for the specified action and effective date, preparing the source data set that exception report processing reads from.
  • UPD_PAYROLL_ACTIONS — Updates payroll action records, maintaining the state of the payroll action against the relevant payroll and consolidation set for the effective date.
  • RUN_PREPROCESS — The primary driver invoked to run the multi-threaded preprocessing step. It executes the preliminary processing required before exception report data can be generated, and is the procedure most commonly referenced in custom invocations and concurrent program hooks.
  • GET_OFFSET_DATE — Returns an offset date derived from the payroll, consolidation set, and effective date, used to align reporting periods.
  • GET_TAX_START_DATE — Returns the start date of the financial tax year for a given legislation code, effective date, and balance dimension.
  • GET_PREVIOUS_YEAR_TAX_DATE — Derives the previous tax year date relative to a supplied tax year start date and effective date.
  • GET_PREVIOUS_QUARTER_TAX_DATE — Derives a prior quarter date based on the financial tax year start date, effective date, and a count value.

Tables Accessed

The package references payroll and HR tables via APPS synonyms. PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_ACTION_INTERLOCKS support payroll action state tracking and interlock management. PAY_DEFINED_BALANCES, PAY_BALANCE_DIMENSIONS, and PAY_USER_ROWS_F supply balance definition and dimensional data used for comparison and reporting. PQP_EXCEPTION_REPORTS, PQP_EXCEPTION_REPORT_GROUPS, and PQP_EXCEPTION_REPORT_SUFFIX store the exception report definitions and grouping configuration. PAY_US_RPT_TOTALS and HR_SOFT_CODING_KEYFLEX provide US statutory reporting totals and soft coding key flexfield data. PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, and PER_TIME_PERIODS supply assignment, person, and period context. DUAL is used for scalar function evaluation.

Usage Notes

PQP_EXPREPLOD_PKG is typically invoked as part of the payroll exception report processing flow, most often through concurrent programs or the standard payroll run submission rather than directly from a form. Because RUN_PREPROCESS is the multi-threaded preprocessing entry point, it is the procedure most frequently referenced when troubleshooting or extending exception report behavior. The package has limited external reuse — ETRM records exactly one other package referencing it — so callers should treat it as an internal implementation component of Payroll exception reporting. The date utility functions may be called independently where legislation-specific tax year and quarter logic is required. Custom code should invoke the documented procedures using the payroll action identifier and effective date already established by the payroll process.