Search Results hxc_self_service_timecard




Overview
Explore in AI Chat

Overview

The APPS.HXC_SELF_SERVICE_TIMECARD package is the core server-side PL/SQL API that powers Oracle E-Business Suite Time and Labor self-service timecard functionality. It provides the programmatic engine that retrieves, assembles, and validates the blocks and attributes that make up an employee's self-service timecard within Oracle EBS 12.1.1 and 12.2.2. The package belongs to the HXC (Time and Labor) application schema and is classified as an OTHER API type in the ETRM metadata, indicating it is not a public, fully-supported open interface but rather an internal API consumed by Oracle's own self-service forms and dependent packages.

Its primary role is to bridge the timecard layout configuration (templates, blocks, attributes, and mapping rules) with the actual time entry data stored in the Time and Labor tables. It returns populated PL/SQL collection types and message arrays to the calling layer, enabling the self-service timecard user interface to render the correct fields and values. With the query term "service date (5)" in context, the package is central to how timecard date ranges and period-based time entry are resolved for display.

Key Procedures and Functions

  • FETCH_BLOCKS_AND_ATTRIBUTES — The principal procedure, overloaded across multiple signatures. It retrieves the block and attribute collections that define the structure and content of a self-service timecard for a given resource, time range, template, and approval status. The overloads accommodate variations such as template exclusion and timecard action handling. It also returns message collections and status strings back to the caller.
  • FETCH_APPL_PERIODS — Retrieves the applicable timecard or application periods, supporting date-range resolution such as that implied by "service date" selections.
  • CHECK_BLOCKS_FROM_TEMPLATE — Validates or reconciles blocks against the defined timecard template, ensuring the rendered structure conforms to configuration.
  • GET_TIMECARD_TRANSFERRED_TO — Returns information identifying to what process or destination a timecard has been transferred, supporting workflow and approval visibility.

Tables Accessed

The package reads and writes across a broad set of HXC configuration and transactional tables via APPS synonyms. Timecard and period data are drawn from HXC_TIMECARD_SUMMARY, HXC_APP_PERIOD_SUMMARY, and HXC_TC_AP_LINKS. Layout and structure come from HXC_LAYOUT_COMPONENTS, HXC_LAYOUT_COMP_QUALIFIERS, HXC_BLD_BLK_INFO_TYPES, and HXC_BLD_BLK_INFO_TYPE_USAGES. Mapping rules are resolved through HXC_MAPPINGS, HXC_MAPPING_COMPONENTS, and HXC_MAPPING_COMP_USAGES. Detail retrieval uses HXC_LATEST_DETAILS, HXC_RETRIEVAL_PROCESSES, and HXC_AP_DETAIL_LINKS. Application metadata is obtained from FND_APPLICATION and FND_APPLICATION_TL.

Usage Notes

This package is typically invoked by the Time and Labor self-service timecard forms and by one documented dependent package. It is not intended as a standalone open interface. Customizations requiring timecard block retrieval should call the appropriate FETCH_BLOCKS_AND_ATTRIBUTES overload, respecting the OUT NOCOPY collection parameters and message handling. Because signatures differ by patch level, developers must verify the overload matching their 12.1.1 or 12.2.2 environment before invocation.