Search Results get_recorded_hours

Overview

The APPS.HXC_TIMECARD_SUMMARY_PKG package is a core component of the Oracle E-Business Suite (EBS) Time and Labor (OTL) module, residing in the APPS schema. Its primary business function is to manage the summary-level representation of a timecard, which is the aggregate header record that consolidates all detail time entries (time building blocks) submitted by an employee for a given period. In releases 12.1.1 and 12.2.2, the package encapsulates the full lifecycle of a timecard summary, including creation, update, deletion, approval, submission, rejection, and the transfer of summarized hours to downstream processes such as payroll and project costing.

By centralizing these operations in a single API, the package ensures that timecard status transitions and hour computations are applied consistently regardless of whether the action originates from the self-service Timecard form, a manager approval workflow, or a batch retrieval process. It exposes both procedural logic and a PL/SQL record/collection type for reporting the underlying detail rows that constitute a summary.

Key Procedures and Functions

The package documents eight callable units. GET_RECORDED_HOURS is a query-oriented procedure that returns the total recorded hours for a given timecard along with a collection of detail records (time building block identifier, object version number, and creation date) that make up that total. INSERT_SUMMARY_ROW creates a new timecard summary record; it accepts a timecard identifier, an operating mode defaulting to NORMAL (with MIGRATION also defined as a valid mode), and a full set of twenty-three descriptive flexfield attribute parameters. UPDATE_SUMMARY_ROW modifies an existing summary record, typically when the underlying details change and the aggregated hours must be recalculated.

DELETE_SUMMARY_ROW removes a summary record, used when a timecard is discarded or reversed. REJECT_TIMECARD is the procedure directly associated with the search term reject_timecard; it drives the business flow that returns a submitted timecard to the worker for correction, resetting its status and related workflow state. APPROVE_TIMECARD advances a timecard to the approved state, and SUBMIT_TIMECARD transitions it from a working draft into the submitted state. UPDATE_TRANSFERRED_TO maintains the transfer status field that flags whether summarized hours have been passed to a downstream recipient system, supporting reconciliation and preventing duplicate transfers.

Tables Accessed

The package operates against a defined set of HXC and PER tables accessed through APPS synonyms. HXC_TIMECARD_SUMMARY is the primary target table for insert, update, and delete operations. HXC_TIME_BUILDING_BLOCKS supplies the detail entries and their object version numbers used by GET_RECORDED_HOURS. Supporting tables include HXC_TIME_ATTRIBUTES and HXC_TIME_ATTRIBUTE_USAGES for time attribute definitions, HXC_ABSENCE_SUMMARY_TEMP and HXC_LATEST_DETAILS for derived data, HXC_RETRIEVAL_PROCESSES for batch context, and HXC_TIME_RECIPIENTS, HXC_TRANSACTIONS, and HXC_TRANSACTION_DETAILS for transfer and audit information. PER_PERIODS_OF_SERVICE links timecards to a worker's period of service, while WF_ITEM_ACTIVITY_STATUSES connects the approval flow to the Oracle Workflow engine. DBMS_UTILITY and PLITBLM provide generic PL/SQL utilities.

Usage Notes

This package is typically invoked indirectly rather than called directly by end users. The Timecard self-service form and the manager approval pages call SUBMIT_TIMECARD, APPROVE_TIMECARD, and REJECT_TIMECARD in response to user actions. Concurrent programs such as retrieval and timecard summary generation call INSERT_SUMMARY_ROW, UPDATE_SUMMARY_ROW, and UPDATE_TRANSFERRED_TO. Because eleven other packages reference it, customizations should avoid modifying this package and instead extend behavior through the documented entry points. The MIGRATION mode on INSERT_SUMMARY_ROW supports data conversion scenarios.