Search Results get_element_payment_rate




Overview
Explore in AI Chat

Overview

APPS.PAY_AU_REC_DET_ARCHIVE is an Oracle EBS payroll archive package that supports the Australian legislative requirement to retain detailed payroll records for terminated employees over an extended statutory period. The package implements the payroll action archive framework for Australian payrolls, providing the procedural hooks invoked by the payroll engine during the archive and reconciliation process. It gathers assignment-level run results, element entries, and payment information, then writes the consolidated output required for statutory reporting and audit.

The package specification retains a single global record type, parameters, used to pass archive run options between the individual entry points. Its change history shows progressive additions between 2003 and 2008, culminating in version 1.10, which backed out a parameters variable change introduced in version 1.9 (Bug 6839263).

Key Procedures and Functions

  • RANGE_CODE — Defines the chunking logic used to divide the payroll action population into parallel processing chunks. It returns a SQL statement fragment that the payroll engine uses to generate assignment ranges.
  • INITIALIZATION_CODE — Performs one-time setup at the start of the archive action, initializing package state, parameters, and any required definitional balance collections.
  • ASSIGNMENT_ACTION_CODE — Executes the core archive processing for each assignment within a range, assembling the relevant run results, element entries, and payment details for archived output.
  • ARCHIVE_CODE — Handles the final stage of the archive action, consolidating and persisting the archived data after all assignment chunks complete.
  • SPAWN_ARCHIVE_REPORTS — Submits the concurrent reports associated with the archive process.
  • CHECK_TERMINATION — Added in version 1.2 (Bug 3662449) to verify the termination status of an assignment, ensuring only terminated employees are included in the archive.
  • GET_ELEMENT_PAYMENT_HOURS — Added in version 1.4 (Bug 5603254) to return the payment hours associated with a given element entry.
  • GET_ELEMENT_PAYMENT_RATE — Added in version 1.8 (Bug 5599310) to return the payment rate associated with an element entry. This function is the object associated with the search term, and it complements the hours function by supplying the rate component of pay calculations for archived records.

Tables Accessed

The package reads and writes against payroll and HR base tables through APPS synonyms. PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS (with their _S shadow tables) provide the action context and assignment-level rows. PAY_RUN_RESULTS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_CLASSIFICATIONS, and PAY_INPUT_VALUES_F supply calculated results, element entries, classifications, and input values. PER_ALL_PEOPLE_F and PER_ASSIGNMENT_STATUS_TYPES supply person and status data, while HR_ALL_ORGANIZATION_UNITS and HR_SOFT_CODING_KEYFLEX provide organizational and costing context. PAY_ACTION_INFORMATION and PAY_ACTION_INFORMATION_S store intermediate archive parameter data, and FND_CONCURRENT_REQUESTS is used to track spawned report submissions.

Usage Notes

The package is invoked indirectly by the Oracle Payroll archive process rather than being called directly from a form. It is referenced by two other packages and executes within the payroll action framework, where the engine calls RANGE_CODE, INITIALIZATION_CODE, ASSIGNMENT_ACTION_CODE, and ARCHIVE_CODE in sequence. SPAWN_ARCHIVE_REPORTS submits the associated concurrent programs, with status tracked through FND_CONCURRENT_REQUESTS. The get_element_payment_rate and get_element_payment_hours functions are utility entry points that custom code or downstream reports can call to retrieve the rate and hours for an element entry when reconstructing archived pay detail. Both functions exist to satisfy Australian record-keeping obligations, and modifications should be validated against the ETRM change history to avoid regressing fixes such as the version 1.10 reversion.