Search Results hxc_hrp_upd




Overview
Explore in AI Chat

Overview

HXC_HRP_UPD is the private package body counterpart to the HXC_HRP public package specification in the APPS schema. It belongs to the Oracle Time and Labor (HXC) product family and supports the maintenance of recurring period definitions used to drive timecard generation, period-based validation, and payroll-facing time calculations. The package encapsulates the insert, update, and delete logic for the HXC_RECURRING_PERIODS entity, consolidating the transactional rules in a single PL/SQL unit so that callers do not manipulate the underlying table directly.

The "HRP" component of the name refers to the recurring period construct, while the "_UPD" suffix follows the Oracle EBS convention of a table-specific DML handler. The body is documented as VALID in the ETRM metadata and is classified as an OTHER API rather than a published public API. It is therefore an internal implementation unit rather than a formally supported external interface.

Key Procedures and Functions

The documented interface consists of a single procedure, UPD. The name indicates that it performs the update and associated data-maintenance processing for recurring period records. Because the metadata does not expose a parameter list, the exact signature is not reproduced here; the procedure should be treated as an internal entry point that applies the business rules governing changes to recurring period definitions.

Although only UPD is documented, the dependency list indicates that the body also participates in the broader lifecycle of the entity. HXC_HRP_BUS is referenced for the business-rule layer, and HXC_HRP_RKU and HXC_HRP_SHD are referenced for row-history and audit/shadow-table handling. This pattern is typical of Oracle HRMS-family table handlers, where a single procedure orchestrates the business validation, the DML against the base table, and the corresponding audit trail maintenance.

Tables Accessed

The sole table documented as accessed through APPS synonyms is HXC_RECURRING_PERIODS. This table stores the recurring period definitions consumed by Time and Labor, including the period type and the start and end boundaries used to generate and validate timecards. The UPD procedure reads and modifies rows in this table as part of its maintenance role.

In addition to the base table, the dependency list implies indirect access to the associated history and audit structures through HXC_HRP_RKU and HXC_HRP_SHD. These packages preserve prior versions of recurring period rows so that changes can be audited. Supporting packages referenced by the body include HR_API, HR_UTILITY, and FND_GLOBAL, the latter supplying application context such as the current user and session identifiers used for who-columns and audit stamping.

Usage Notes

HXC_HRP_UPD is not referenced by any database object, according to the ETRM metadata. This confirms its role as a leaf-level implementation unit invoked from within the HXC package hierarchy rather than from an external caller. Typical invocation paths include the Oracle Time and Labor Setup and Administration forms when an administrator maintains recurring period definitions, and internal Time and Labor processing that realigns period definitions with employee or assignment schedules.

Custom code should call the supported public interfaces rather than HXC_HRP_UPD directly. Because the body is classified as OTHER and is not referenced elsewhere, Oracle does not guarantee its signature across patch levels. Any extension should rely on the public package or standard concurrent program options, and should respect the audit and row-history behaviour implemented through HXC_HRP_RKU and HXC_HRP_SHD.