Search Results pay_retro_status_internal




Overview
Explore in AI Chat

Overview

The APPS.PAY_RETRO_STATUS_INTERNAL package body is an internal Oracle Payroll server-side PL/SQL component that manages the lifecycle and status transitions of retroactive (retro) payroll processing entities. Retroactive payroll in Oracle EBS handles recalculation of prior-period earnings when an element entry, rate, or assignment change takes effect in an earlier payroll period than the current one. The package acts as the engine behind maintaining the retro assignments records, retro components, and retro entries that the payroll engine evaluates when retroactive adjustments are warranted.

The object resides in the APPS schema, holds a VALID status, and is classified as OTHER in the ETRM metadata rather than as a formal public API. This classification signals that the package is intended for internal invocation by other payroll packages rather than as a formally supported entry point for customer extensions. It is not directly referenced by any database object other than other packages, but it references two other payroll packages in turn — PAY_RETRO_PKG and PAY_RETRO_UTILS_PKG — indicating it sits within the broader retro processing call stack.

Key Procedures and Functions

The package body exposes eight documented procedures and functions, each supporting retro status maintenance:

  • GET_UNPROCESSED_RETRO_ASG — Retrieves retro assignment records that have not yet been processed, providing the caller with candidate retro assignments for further evaluation.
  • CREATE_SUPER_RETRO_ASG — Creates a "super" retro assignment record, typically used to consolidate or group retro processing across multiple assignments or periods.
  • UPDATE_RETRO_ASG — Updates an existing retro assignment record, refining its status or attributes.
  • DELETE_RETRO_ASG — Removes a retro assignment record.
  • DELETE_RETRO_ASG_CASCADE — Deletes a retro assignment and its dependent child records (retro components, usages, and entries) in a cascading fashion.
  • MAINTAIN_RETRO_ENTRY — Maintains retro entry records, aligning them with the retro assignment state.
  • DELETE_RETRO_ENTRY — Deletes a retro entry record.
  • UPDATE_REPROCESS_DATE — Updates the reprocess date on a retro record, driving when the retro calculation is re-evaluated.

Parameter lists are not formally published, consistent with its internal classification.

Tables Accessed

The package operates over a focused set of payroll and HR tables accessed through APPS synonyms:

Usage Notes

Because PAY_RETRO_STATUS_INTERNAL is an internal package body, direct invocation from customer forms, concurrent programs, or custom code is discouraged. It is typically called within the retro processing flow initiated by Oracle Payroll's RetroPay concurrent processes, which in turn drive PAY_RETRO_PKG and related utilities. Administrators troubleshooting retro entries or unexpected statuses should examine the underlying PAY_RETRO_* tables rather than call these procedures directly. Where extensions require retro manipulation, Oracle's supported public retro APIs should be preferred; the procedures documented here should be treated as implementation detail exposed only via dependency metadata.