Search Results c_attribute




Overview
Explore in AI Chat

Overview

APPS.HXC_TIMECARD_ATTRIBUTE_UTILS is a PL/SQL utility package body in the Oracle E-Business Suite Time and Labor (HXC) module. Its primary business function is to manage the lifecycle of time attributes — the configuration-level definitions that describe what data elements appear on a timecard, how they are built into time building blocks, and how they are mapped into the Data Pump/workflow attribute (DPWR) structure consumed by the Time and Labor rules engine. The package provides internal helper logic for creating, comparing, converting, and pruning time attribute records as timecard layouts and building blocks are edited by administrators or processed by concurrent programs. Because the package is classified as OTHER rather than as a public API, it is intended to be called by other HXC packages and forms rather than by end-user customizations. The user search term c_attribute corresponds to the time attribute concept managed here; attributes are identified by TIME_ATTRIBUTE_ID and carry associated building-block information types.

Key Procedures and Functions

  • NEXT_TIME_ATTRIBUTE_ID — Returns the next available time attribute identifier by scanning a collection of attributes for the lowest existing ID and decrementing from it, ensuring new attributes receive unique negative identifiers.
  • GET_BLD_BLK_INFO_TYPE_ID and SET_BLD_BLK_INFO_TYPE_ID — Retrieve and cache building-block information type identifiers, providing a lookup between an info type ID and its descriptive type.
  • CONVERT_TO_DPWR_ATTRIBUTES — Transforms time attribute records into the DPWR attribute format required by downstream rules processing.
  • CONVERT_TO_TYPE — Performs data type conversion for attribute values so they conform to expected building-block types.
  • IS_NEW_ATTRIBUTE and IS_NEW_ATTRIBUTE2 — Determine whether a given attribute is newly introduced, supporting insert-versus-update decisions during timecard saves.
  • IS_CORRESPONDING_BLOCK — Tests whether an attribute corresponds to a specific time building block.
  • IS_SYSTEM_CONTEXT — Identifies attributes that belong to the system context rather than user-defined configuration.
  • PROCESS_ATTRIBUTE and BUILD_ATTRIBUTE — Core routines that process and assemble individual attribute records, including their building-block associations, during timecard construction.
  • ATTRIBUTES_ARE_DIFFERENT — Compares two attribute collections to detect changes that require persistence.
  • GET_ATTRIBUTE_INDEX — Returns the positional index of an attribute within a collection, used for efficient traversal.
  • APPEND_ADDITIONAL_REASONS — Adds supplementary reason information to attribute processing, typically for validation or error messaging.
  • REMOVE_DELETED_ATTRIBUTES — Purges attributes flagged for deletion from the working collection.

Tables Accessed

Via APPS synonyms the package reads and writes HXC_TIME_ATTRIBUTES, the canonical store of time attribute definitions, and HXC_TIME_BUILDING_BLOCKS, which holds the building blocks to which attributes are attached. HXC_BLD_BLK_INFO_TYPES supplies descriptive information types referenced by the cache routines. PLITBLM is accessed as part of the standard PL/SQL table handling used for in-memory collections. Together these tables support attribute identification, block association, and type resolution.

Usage Notes

This package is referenced by twelve other packages, indicating it acts as a shared utility layer within Time and Labor. It is typically invoked indirectly through timecard forms, time building-block maintenance screens, and concurrent programs that validate or process timecard data, and it may be reached from custom code that manipulates time attributes. Because the package is not a published API, direct calls should be avoided where supported alternatives exist, and any reliance on its internal routines should be expected to remain version-sensitive across EBS 12.1.1 and 12.2.2.