Results for “hxc_alias_translator”

50+ results




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

Overview

The APPS.HXC_ALIAS_TRANSLATOR package body is a server-side PL/SQL component within the Oracle E-Business Suite timecard and self-service applications (HXC schema). Its primary business function is to translate alias tokens — configured by administrators — into their corresponding concrete values, and vice versa, as timecard building-block attribute information flows into and out of the self-service time deposit and retrieval processes. The package therefore underpins the configurable alias substitution mechanism that allows deployments to customize, mask, or remap the underlying time and labor attributes that users enter on self-service timecards. The header comment ($Header: hxcalttlr.pkb 120.7.12010000.2 2008/08/05) indicates the file has been maintained at the 12.1.1 code level and carried forward into the 12.2.2 documentation set.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package. They are not declared as public APIs in the usual sense; rather, they are internal processing routines called during the translation lifecycle.

  • DO_DEPOSIT_TRANSLATION — This is the inbound translation routine. It is invoked when attribute information is being written (deposited) into the database from the self-service time entry layer. Its role is to inspect the incoming attribute table and message table structures, identify each attribute that carries an alias definition, resolve that alias to the configured value, and replace or annotate the attribute accordingly. The source excerpt shows the routine accepting p_attributes and p_messages as IN OUT NOCOPY parameters of the HXC_ATTRIBUTE_TABLE_TYPE and HXC_MESSAGE_TABLE_TYPE types, confirming it mutates the caller's collections in place rather than returning a new set. The body constructs working PL/SQL tables via hxc_alias_utility to hold building-block ID references and alias-value-to-attribute matches, then walks the attribute index to locate and match alias values. Diagnostic tracing is available when hr_utility.debug_enabled is set.
  • DO_RETRIEVAL_TRANSLATION — This is the outbound translation routine. It performs the reverse operation when previously stored attribute information is retrieved for display in self-service timecard screens, converting stored values back into the alias presentation expected by the user.

No public function signatures beyond these two procedures are documented; the remaining logic is contained in private working variables and helper tables internal to the body.

Tables Accessed

The package accesses several reference and configuration tables, all through APPS synonyms:

  • HXC_ALIAS_DEFINITIONS_TL — The translated alias definition table, providing the alias configuration text and locale-specific definitions used to determine what a given alias resolves to.
  • HXC_ALIAS_TYPES — Defines the categories of aliases available, driving which translation path is applied to a particular attribute.
  • HXC_ALIAS_VALUES — Holds the concrete value(s) associated with an alias definition; this is the target of the translation lookup.
  • FND_FLEX_VALUE_SETS — The Oracle Flexfields value set definition table. The package consults it to validate or resolve values that participate in flexfield-backed alias mappings, ensuring alias targets conform to the underlying key flexfield configuration.
  • DBMS_UTILITY and PLITBLM — Oracle-supplied utilities used for PL/SQL table manipulation (such as determining collection bounds when iterating indexed tables).

Usage Notes

HXC_ALIAS_TRANSLATOR is an internal dependency rather than a standalone entry point. The ETRM metadata records that it is referenced by ten other packages, which means it is invoked programmatically by higher-level timecard processing packages — most plausibly the self-service time deposit and retrieval logic — during the normal save and query cycles of a timecard. It is not typically called directly from a form, concurrent program, or external custom code. Administrators and developers should treat it as a supporting utility: changes to alias definitions, alias types, or alias values in the configuration tables will flow through these translation routines automatically. When troubleshooting alias substitution behavior, enabling hr_utility.debug_enabled will cause the deposit routine to emit trace output, which is useful for diagnosing unmatched aliases or unexpected replacements. Because the procedures mutate caller-supplied collections in place using NOCOPY semantics, any custom code that wraps this package must pass appropriately typed HXC_ATTRIBUTE_TABLE_TYPE and HXC_MESSAGE_TABLE_TYPE structures and be prepared for those structures to be modified on return.