Search Results hxt_retro_val




Overview
Explore in AI Chat

Overview

HXT_RETRO_VAL is a PL/SQL package owned by the APPS schema that supports the retrospective timecard validation logic within Oracle E-Business Suite's Oracle Time and Labor (OTL) module. Its principal business function is to validate retroactive timecard entries — that is, timecards submitted for periods that have already been processed, approved, or closed — and to reconcile the hours associated with those entries against prior balances. Because retroactive time changes can affect previously calculated overtime, shift differentials, and payroll costing, the package provides the validation layer that confirms whether a retroactive adjustment is legitimate before downstream processing continues.

The package occupies a supporting role in the broader retroactive processing architecture. ETRM metadata identifies it as a boundary object that both consumes and is consumed by sibling packages; notably, APPS.HXT_BATCH_PROCESS references HXT_RETRO_VAL, and HXT_RETRO_VAL itself references HXT_BATCH_PROCESS, forming a tight integration with the batch timecard processing framework. This bidirectional dependency reflects the reality that retroactive validation is performed in the context of batch runs while also invoking batch processing services.

Key Procedures and Functions

  • VAL_RETRO_TIMECARD — The core validation routine. It evaluates a retroactive timecard against the rules governing the retroactive time period, verifying that the adjustment is permitted and that the associated detail hours are consistent. This procedure is the primary entry point for callers seeking to validate a retro timecard record.
  • MARK_ROWS_COMPLETE — A housekeeping and state-management routine that flags processed rows as complete once validation has finished. It ensures that batch routines do not re-process rows that have already been handled, preserving idempotency across batch cycles.

The metadata documents exactly two procedures; no additional public or private routines are recorded in the ETRM reference. Neither parameter list is reproduced here, as the documented metadata does not enumerate signatures.

Tables Accessed

  • HXT_TIMECARDS_F — The master timecard table. The package reads the timecard under validation and may update header-level state after successful processing.
  • HXT_DET_HOURS_WORKED_F — The detailed hours-worked table. Retroactive validation compares and reconciles hour distributions here, since retro changes affect detail-level allocations.
  • FND_USER — Used to resolve the identity of the user performing or associated with the retroactive adjustment, supporting auditing and security checks.
  • PLITBLM — A PL/SQL internal table construct rather than a physical application table; it supports in-memory collection processing within the package.

Usage Notes

HXT_RETRO_VAL is not intended for direct end-user invocation. It is typically called programmatically by the batch timecard processing infrastructure (HXT_BATCH_PROCESS) and by the retroactive processing package (HXT_RETRO_PROCESS) during concurrent program runs, such as batch timecard import or retroactive recalculation. In Oracle EBS 12.1.1 and 12.2.2, these batch executions are commonly scheduled as concurrent programs under the Time and Labor responsibility. Because the package also appears in its own referenced-by list, it may invoke itself recursively for row-level iteration over collections. Custom extensions that need to validate retro timecards should call VAL_RETRO_TIMECARD rather than manipulating the underlying _F tables directly, and should respect the completion flags set by MARK_ROWS_COMPLETE to avoid duplicate processing. The package status is VALID in the documented environment, indicating a compiled and active object.