Search Results hxt_timecard_info




Overview
Explore in AI Chat

Overview

HXT_TIMECARD_INFO is an Oracle Application Object Library (APPS) PL/SQL package that belongs to the Oracle Time and Labor (OTL) module of Oracle E-Business Suite. Its internal identifier and object type, combined with the naming convention of its procedures and the tables it accesses, indicate that it is responsible for generating and validating timecard information derived from an employee's assigned work plan, rotation plan, and work schedules. Rather than acting as an end-user-facing API, HXT_TIMECARD_INFO functions as a supporting package that produces the default timecard rows an employee would normally see when they open the self-service timecard, or when a batch process needs to pre-populate a timecard based on schedule and earnings setup.

The package is documented with a classification of OTHER and is not treated as a public, supported API. Its status is VALID, and it is referenced by one other package, HXC_SELF_SERVICE_TIMECARD, which is the primary Java/Forms-facing self-service timecard component. This dependency confirms that HXT_TIMECARD_INFO is a subordinate utility invoked during the timecard generation lifecycle.

Key Procedures and Functions

The ETRM documentation identifies four documented procedures and functions within the package:

  • GEN_WORK_PLAN — Generates a work plan for a given timecard or assignment, drawing on the employee's assigned work schedule to determine which days are scheduled work days. This procedure provides the basis for the default timecard line structure.
  • GEN_ROT_PLAN — Generates a rotation plan, applying rotation schedule definitions so that employees on rotating shifts receive the correct scheduled days for the timecard period. It extends the logic of GEN_WORK_PLAN for rotated work patterns.
  • GET_WORK_DAY — Returns or evaluates whether a specific date qualifies as a work day for the given assignment, based on the applicable work schedule, shift, and any calendar or holiday exclusions.
  • GENERATE_TIME — Produces the actual timecard time entries, taking the generated work or rotation plan and surfacing it as timecard information. This is the procedure most directly associated with populating timecard data.

Parameter lists are not published in the referenced metadata and must be obtained from the package specification in a live instance.

Tables Accessed

The package reads from and references several OTL and HR configuration tables through APPS synonyms:

Usage Notes

HXT_TIMECARD_INFO is typically invoked indirectly. The primary caller is HXC_SELF_SERVICE_TIMECARD, which uses its routines when a self-service timecard is built or retroactively generated. Custom development should not call this package directly unless the underlying specification is reviewed, because it is classified as OTHER and is not covered by Oracle's public API support policy. Typical invocation points include the self-service timecard generation flow and any concurrent process that pre-populates timecards for scheduled employees.