Results for “load_attributes”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HXC_TIMECARD_DEPOSIT_COMMON is an Oracle EBS Application Object Library package body owned by the APPS schema. It forms part of the Oracle Time and Labor (OTL) self-service timecard infrastructure and is classified under the ETRM as an "OTHER" API rather than a public, callable interface. The package provides shared internal services for the timecard deposit pipeline — the process by which a timecard entered through self-service is validated, translated, and persisted for downstream processing. In the 12.1.1 and 12.2.2 releases the package body is versioned as hxctcdpcommon.pkb 115.2, retaining the original OTL design lineage despite later EBS upgrades.

The central design premise is backward compatibility. The package exposes modern table-based block, attribute, and message collections while internally bridging them to the older "self-service time deposit" record structures, allowing legacy code paths and current interfaces to coexist during the deposit sequence.

Key Procedures and Functions

The ETRM documents five procedures. Each performs a discrete step in the timecard deposit lifecycle:

• ALIAS_TRANSLATION — The procedure most relevant to the user's search. It accepts the block, attribute, and message collection types as IN OUT NOCOPY parameters. It first calls the attribute utility to set the building-block information type identifier, then delegates to HXC_ALIAS_TRANSLATOR.DO_DEPOSIT_TRANSLATION. This resolves attribute aliases and translates incoming timecard data into the canonical attribute representation expected by downstream deposit logic. Legacy-style declarations for the timecard and attribute info structures are present in its body, reflecting the compatibility shim design.
• VALIDATE_SETUP — Confirms that the deposit configuration is complete before processing. The commented source shows a cursor over HXC_DEPOSIT_PROCESSES selecting the "OTL Deposit Process", demonstrating that the routine verifies the required deposit process definition exists and is usable prior to running a deposit.
• LOAD_BLOCKS — Populates the block collection representing the timecard's building blocks for deposit.
• LOAD_ATTRIBUTES — Populates the attribute collection, supplying the translated attribute values associated with each block.
• DELETE_TIMECARD — Removes timecard data once the deposit has completed or when cleanup is required.

Tables Accessed

The package references three tables through APPS synonyms:

• HXC_TIME_BUILDING_BLOCKS — The core repository of timecard building blocks; read and written by LOAD_BLOCKS and DELETE_TIMECARD.
• HXC_TIME_ATTRIBUTE_USAGES — Records how attributes are applied to building blocks; accessed during attribute loading and translation.
• PLITBLM — An EBS internal table used to store PL/SQL error and message information, supporting the message collection populated during validation and translation.

Usage Notes

This package is not intended for direct invocation by end users or external customizations, as indicated by its "OTHER" API classification. It is invoked internally by the OTL self-service timecard deposit flow and by the three other packages documented as referencing it. In practice, these routines are triggered when a user submits a timecard for deposit through the OTL self-service forms, or when a concurrent process drives batch deposit and validation. Custom code should not call HXC_TIMECARD_DEPOSIT_COMMON directly; instead it should use officially supported OTL APIs. The ALIAS_TRANSLATION procedure is the point at which alias-based attribute values are normalized, making it the appropriate reference for diagnosing alias resolution issues in the deposit path.