Search Results get_day_date

Overview

HXC_MAPPING_UTILITIES is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Time and Labor (HXC) product family and is classified in the ETRM repository as an OTHER API rather than a formally published public interface. The package centralizes the logic that resolves mapping values and detects changes to Time and Labor mapping configurations, which are the rules that translate raw time entry building-block values into derived attributes such as payroll elements, project attributes, and costing segments. Because mapping configurations are edited frequently by administrators while concurrent timecard processing is running, the package provides a controlled, reusable layer for reading and comparing mapping definitions. The ETRM metadata records the object status as VALID and lists eight documented procedures and functions used across the HXC integration layer and time-entry rules engine.

Key Procedures and Functions

• GET_MAPPING_VALUE — returns the mapped output value for a given mapping and input building-block value; the primary lookup routine used during timecard validation and retrieval processing.
• GET_MAPPINGVALUE_SUM — returns an aggregated mapping result, used where multiple mapping components must be summed into a single derived value.
• CHK_MAPPING_EXISTS — verifies that a mapping definition is present and usable before dependent logic attempts to apply it.
• CHK_MAPPING_CHANGED — detects whether a mapping configuration has changed since a prior read, supporting cache invalidation and re-derivation.
• CHK_BLD_BLK_CHANGED — performs the equivalent change detection for building-block structures and their associated information types.
• GET_DAY_DATE — resolves the calendar date associated with a time record, used as an input to date-effective mapping evaluation.
• ATTRIBUTE_COLUMN — resolves the physical or logical column corresponding to a Time and Labor attribute, as used by mapping component definitions.

The package also exposes additional internal entry points surfaced through the integration layer groups HXC_INTEGRATION_LAYER_V1_GRP and HXC_INTEGRATION_LAYER_V2_GRP.

Tables Accessed

The package reads the principal Time and Labor mapping and building-block tables, all referenced through APPS synonyms:

• HXC_MAPPINGS, HXC_MAPPING_COMPONENTS, HXC_MAPPING_COMP_USAGES — mapping headers, their component definitions, and where those components are applied.
• HXC_TIME_BUILDING_BLOCKS, HXC_BLD_BLK_INFO_TYPES, HXC_BLD_BLK_INFO_TYPE_USAGES — building-block structures and the information types they carry.
• HXC_TIME_ATTRIBUTES, HXC_TIME_ATTRIBUTE_USAGES — the attribute definitions mapped by the components.
• HXC_DEPOSIT_PROCESSES, HXC_RETRIEVAL_PROCESSES — deposit and retrieval processing definitions that consume mapping results.
• FND_PRODUCT_INSTALLATIONS — used to confirm installation status and product registration.
• HXC_SELF_SERVICE_TIME_DEPOSIT — referenced as a dependency by the package body.
• PLITBLM — the standard Oracle DATE/format conversion utility package used for date handling.

Usage Notes

HXC_MAPPING_UTILITIES is an internal utility package and is not intended for direct invocation by customers, though its procedures are technically callable from custom code. In standard operation it is invoked indirectly: the HXC_APPROVAL_WF_PKG calls it during workflow approval of timecards, HXC_TIME_ENTRY_RULES_UTILS_PKG calls it while evaluating time-entry rules, and the integration layer groups HXC_INTEGRATION_LAYER_V1_GRP and V2_GRP call it when Time and Labor data is passed to Payroll, Projects, and other downstream products. It is referenced by four other packages in total. Customizations should avoid modifying the package body, since it is patched by Oracle; extensions should instead wrap the documented functions or replicate their logic against the underlying HXC tables. All behavior described here is grounded in the ETRM 12.2.2 metadata and remains applicable in 12.1.1.