Search Results insert_summary_row




Overview
Explore in AI Chat

Overview

APPS.HXC_TC_AP_LINKS_PKG is a PL/SQL package body within the Oracle E-Business Suite Time and Labor (OTL) module, owned by the APPS schema and classified under the ETRM registry as an "OTHER" API type. Its core business function is to maintain the association between individual timecards and the application periods they span. In Oracle Time and Labor, an application period defines a payroll or distribution window against which reported time is processed. Because a single timecard may cross one or more application period boundaries—depending on resource, start time, and stop time—the relationship between timecards and application periods must be tracked explicitly. This package manages that relationship through the HXC_TC_AP_LINKS intersection table, providing insert, delete, and bulk refresh operations.

This object is part of the larger Time and Labor data-building infrastructure and is referenced by four other packages, indicating it is a supporting utility rather than an entry-point API. It is not intended for direct invocation by end users or external integrations.

Key Procedures and Functions

  • INSERT_SUMMARY_ROW — Inserts a single link row into HXC_TC_AP_LINKS, associating a given timecard with a given application period. This establishes the summary-level relationship used downstream in time processing and distribution.
  • DELETE_SUMMARY_ROW — Removes a specific link between a timecard and an application period, targeted by both the timecard identifier and application period identifier.
  • REMOVE_TIMECARD_LINKS — Deletes all application period links associated with a single timecard. This is the cleanup counterpart used when a timecard is modified or removed.
  • CREATE_TIMECARD_LINKS — The primary driver procedure. It first removes existing links for the supplied timecard, then queries HXC_TIMECARD_SUMMARY to retrieve resource, start time, and stop time, and queries HXC_APP_PERIOD_SUMMARY to identify every application period whose date range overlaps the timecard's range. It then rebuilds the link rows accordingly.
  • REMOVE_APP_PERIOD_LINKS — Deletes all timecard links associated with a given application period, the inverse cleanup operation to REMOVE_TIMECARD_LINKS.
  • CREATE_APP_PERIOD_LINKS — Builds the link set from the perspective of the application period, mirroring the logic of CREATE_TIMECARD_LINKS for the period-first scenario.

Only six procedures are documented in the ETRM registry; no public functions are recorded. The package header is not exposed as a formal API, and parameter lists should not be assumed beyond what ETRM documents.

Tables Accessed

  • HXC_TC_AP_LINKS — The primary intersection table storing timecard-to-application-period pairs; read, inserted into, and deleted from by the procedures above.
  • HXC_TIME_BUILDING_BLOCKS — Supplies the data types for the timecard identifier parameters and anchors the timecard structure in the Time and Labor model.
  • HXC_TIMECARD_SUMMARY — Queried to obtain resource identifier, start time, and stop time for a given timecard, which drive the period-overlap logic in CREATE_TIMECARD_LINKS.
  • HXC_APP_PERIOD_SUMMARY — Queried to identify which application periods overlap a timecard's time range, based on resource and the start/stop time comparison.

Usage Notes

This package is invoked internally by Oracle Time and Labor processing logic, most commonly during timecard save, submission, and distribution workflows where application period associations must be established or refreshed. It is referenced by four other packages, so any custom code should treat it as a supporting internal routine rather than a supported public API. The header comment ($Header: hxctalsum.pkb) confirms it dates to 2004 and has been largely static across 11i and 12.x releases. Consultants extending Time and Labor should avoid direct modification of HXC_TC_AP_LINKS and instead rely on the package's procedures to keep summary links consistent. Note: the "terbox link hot" search term does not correspond to any documented element of this package; no such object or procedure exists in ETRM metadata.