Search Results hxc_timecard_summary_pkg




Overview
Explore in AI Chat

Overview

The APPS.HXC_TIMECARD_SUMMARY_PKG package body is a core server-side component of the Oracle E-Business Suite Time and Labor (OTL) module (HXC application). Its primary business function is to manage the lifecycle and summarization of timecards within the Time and Labor repository. Specifically, it provides the programmatic interface for calculating, recording, and persisting summarized timecard data, and for driving the approval workflow states of a timecard (submission, approval, and rejection). The package bridges the raw detail-level rows stored in the time building block hierarchy with the aggregated summary rows that downstream payroll, costing, and reporting processes consume.

Because the package manipulates timecard state transitions, it is central to the Time and Labor approval and transfer process. Functions such as migration approval status evaluation support the migration of historical or staged timecards into the current approval model. The package is classified as OTHER in the ETRM metadata, indicating it is not a formally published public API but rather an internal dependency invoked by the Time and Labor application and other packages.

Key Procedures and Functions

  • GET_RECORDED_HOURS — Computes the recorded hours for a timecard by traversing the parent/child hierarchy of building blocks. It returns the aggregated hours and a details collection describing the underlying day-detail rows. A cursor resolves detail information (start time, stop time, measure, type) for active rows, and a separate cursor resolves the resource identifier associated with the timecard.
  • INSERT_SUMMARY_ROW — Inserts a new summarized timecard row into the summary repository, establishing the aggregation record for the timecard.
  • UPDATE_SUMMARY_ROW — Updates an existing summary row, typically after recalculation or re-evaluation of recorded hours.
  • DELETE_SUMMARY_ROW — Removes a summary row when the underlying timecard is deleted, re-opened, or otherwise invalidated.
  • REJECT_TIMECARD — Drives the timecard into a rejected approval state as part of the Time and Labor approval workflow.
  • APPROVE_TIMECARD — Advances the timecard to an approved state, making summarized data eligible for downstream transfer and payroll processing.
  • SUBMIT_TIMECARD — Moves the timecard into the submitted state, initiating the approval workflow.
  • UPDATE_TRANSFERRED_TO — Records or updates the identifier of the downstream consumer to which the timecard has been transferred.

Tables Accessed

The package reads and writes a set of Time and Labor repository tables using APPS synonyms. HXC_TIME_BUILDING_BLOCKS is the central detail table, holding the timecard header, day, and detail rows traversed by the hierarchy logic. HXC_TIMECARD_SUMMARY stores the aggregated summary rows inserted, updated, or deleted by the corresponding procedures. HXC_LATEST_DETAILS and HXC_ABSENCE_SUMMARY_TEMP provide detail and absence aggregation support. Workflow state is tracked via WF_ITEM_ACTIVITY_STATUSES. Recipient resolution (relevant to the get_recipient_name search term) draws on HXC_TIME_RECIPIENTS, supported by HXC_TIME_ATTRIBUTES, HXC_TIME_ATTRIBUTE_USAGES, and PER_PERIODS_OF_SERVICE. Transfer tracking uses HXC_TRANSACTIONS, HXC_TRANSACTION_DETAILS, and HXC_RETRIEVAL_PROCESSES. Utility calls include DBMS_UTILITY and PLITBLM for collection handling and debugging.

Usage Notes

HXC_TIMECARD_SUMMARY_PKG is typically invoked indirectly by the Time and Labor application—through the timecard entry and approval forms, the approval workflow, and concurrent programs that generate or transfer summarized time—rather than called directly by end users. Custom extensions should prefer published Time and Labor APIs. The package is referenced by eleven other packages, underscoring its role as an internal dependency. Developers extending timecard approval or summary logic must account for its hierarchy traversal and workflow-state side effects.