Search Results hxc_attribute_table_type




Overview
Explore in AI Chat

Overview

The APPS.HXC_TIMECARD_ATTRIBUTE_UTILS package is a utility library within the Oracle E-Business Suite timecard and self-service time management infrastructure. It provides low-level helper routines that manipulate time attributes — the building-block attribute records associated with timecard entries stored in HXC_TIME_ATTRIBUTES. The package operates as an internal service layer beneath the timecard APIs, responsible for constructing, converting, comparing, indexing, and validating attribute records as they flow between the persistent schema representation (HXC_ATTRIBUTE_TABLE_TYPE) and the self-service deposit representation (HXC_SELF_SERVICE_TIME_DEPOSIT.building_block_attribute_info).

Because it is classified under the ETRM as an OTHER API, it is not a public integration endpoint but rather a supporting utility consumed by other Oracle Time and Labor packages. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user and therefore relies on APPS synonyms for its table access. The package is referenced by twelve other packages, confirming its role as a shared, foundational component of the timecard attribute processing chain.

Key Procedures and Functions

The documented interface exposes the following routines:

Tables Accessed

  • HXC_TIME_ATTRIBUTES — The primary source and target for attribute records; supplies identifiers and object version numbers used by BUILD_ATTRIBUTE.
  • HXC_TIME_BUILDING_BLOCKS — Provides the building block context to which attributes are attached.
  • HXC_BLD_BLK_INFO_TYPES — Resolves information type identifiers.
  • PLITBLM — A PL/SQL internal table used for collection handling within the attribute logic.

Usage Notes

HXC_TIMECARD_ATTRIBUTE_UTILS is invoked indirectly by higher-level timecard and time-entry APIs, forms, and self-service time deposit processing rather than being called directly from customer extensions. The most common caller in the search context, BUILD_ATTRIBUTE, is used whenever an attribute must be materialized from persisted identifiers during timecard save, retrieval, or validation flows. Custom code should avoid calling these utilities directly; instead, use supported public APIs such as HXC_SELF_SERVICE_TIME_DEPOSIT, which wrap the conversion and construction routines found here. Modifications to this package are delivered only through Oracle patches, and any dependence on its internal signatures should be treated as unsupported.