Search Results hxt_clock_user_edits

Overview

HXT_CLOCK_USER_EDITS is an Oracle Application Object Library PL/SQL package owned by the APPS schema and validated for Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Time and Labor (HXT) product family, specifically the time clock (HXC/HXT) component used to capture employee time entries through self-service timecard and time collection devices. The package supports the editing of time clock records by validating and enriching user-supplied edits before those records are committed to the time store. Its role is therefore a defensive and augmentation layer: it resolves the relationship between the logged-in user and the underlying person record, and it derives the correct payroll date against which edited clock events should be attributed. The ETRM classification lists the package API classification as OTHER, indicating it is an internal supporting package rather than a documented public API. Its declared status is VALID, and it depends only on SYS.STANDARD in the static dependency listing, with dynamic dependencies on APPS objects recorded at runtime.

Key Procedures and Functions

The ETRM metadata documents two procedures or functions within the package:

• GET_PERSON_ID — Resolves the person identifier associated with the current user or with the record being edited. Time clock data is keyed to a person (assignment) rather than to a login, so this routine bridges the application user context and the HR person model. It is typically consumed by the timecard editing logic to ensure that an edit is applied against the correct employee.
• DETERMINE_PAY_DATE — Derives the applicable pay date for a clock edit. Because time clock punches may fall near period boundaries, on shift differential boundaries, or in retroactive ranges, the pay date must be computed rather than taken literally from the punch timestamp. This routine applies the payroll calendar and assignment rules to return the date against which the edited event should be processed.

The metadata does not expose parameter signatures or return types; only the names and their functional intent are documented.

Tables Accessed

The supplied metadata does not enumerate base tables directly through APPS synonyms for this package. The static dependency report shows only SYS.STANDARD as a referenced object, and the package is referenced by HXT_CLOCK_USER_EDITS itself (the trigger or form-layer object of the same name) and by HXT_TIME_CLOCK. In practice, the routines above operate against the Time and Labor and HR person entities reached through APPS synonyms — person and assignment lookups for GET_PERSON_ID, and payroll period and time entry data for DETERMINE_PAY_DATE — but the ETRM record does not document specific table names for this object. Any implementation review should confirm the actual table access via the package body rather than assuming a fixed table list.

Usage Notes

HXT_CLOCK_USER_EDITS is an internal helper package. It is referenced by APPS.HXT_CLOCK_USER_EDITS (the same-named object, typically the editing form or API layer) and by APPS.HXT_TIME_CLOCK, which is the primary time clock processing package. This means it is invoked implicitly during self-service timecard edits and time clock transactions rather than being called directly by end users or by most custom code. It is not a documented public API in the Time and Labor integration surface, so customizations should avoid calling it directly; instead, use the supported Time and Labor APIs. Because it is invoked inside transaction paths, any modification or invalidation of this package can affect timecard saves and should be treated as a core-object change subject to normal EBS patch and extension governance.