Search Results timecard_hours_type_list

Overview

HXC_DEPOSIT_WRAPPER_UTILITIES is an Oracle E-Business Suite PL/SQL package owned by APPS and classified as a utility (OTHER) API. It belongs to the Oracle Time and Labor (HXC) product family and supports the timecard deposit and self-service time entry flows. Its primary business function is to serialize and deserialize complex PL/SQL collections and records — time building blocks, application attributes, messages, and descriptive flexfield context data — into string representations, and to reconstruct them back into their native PL/SQL structures. This capability is essential in the Oracle EBS web architecture, where state must be persisted across page submissions, stored in intermediate columns, or passed between the middle tier and the database tier as bounded character data.

The package is declared AUTHID CURRENT_USER and defines several public types, including t_simple_table, dupdff_code_name_rec, dupdff_code_name_TABLE, r_transaction, and t_transaction, which mirror the row shapes of time building blocks, transaction details, and descriptive flexfield contexts. Because it is referenced by nineteen other packages, it functions as shared infrastructure for the Time and Labor deposit pipeline rather than as an end-user facing API.

Key Procedures and Functions

• BUILD_CONTEXT_STRING — Assembles a descriptive flexfield context string from supplied context codes, system linkage, expenditure type, and PA alias value identifiers.
• GET_PREFERENCES — Retrieves user or resource preference data based on resource, preference string, date range, and timecard identifiers.
• BLOCKS_TO_STRING / STRING_TO_BLOCKS — Convert between the timecard_info collection of time building blocks and a string representation, enabling timecard state to be carried across calls.
• ATTRIBUTES_TO_STRING / STRING_TO_ATTRIBUTES — Convert application attribute structures to and from a string, supporting the storage and retrieval of self-service timecard attributes.
• STRING_TO_BLD_BLK_ATTRIBUTES — Reconstructs attribute values specifically for time building blocks from a serialized string.
• MESSAGES_TO_STRING / STRING_TO_MESSAGES — Serialize and deserialize validation or error message collections.
• STRING_TO_TABLE — Populates a generic PL/SQL table from a delimited string.
• AUDIT_TRANSACTION — Records transaction-level audit information for deposit processing.
• TIMECARD_HOURS_TYPE_LIST — Returns the list of valid hours types applicable to a timecard.
• ARRAY_TO_ATTRIBUTES / ATTRIBUTES_TO_ARRAY — Map attribute records to and from array representations.
• ARRAY_TO_BLOCKS / BLOCKS_TO_ARRAY — Map time building block records to and from array structures.
• GET_DUPDFF_CODE / GET_DUPDFF_NAME — Resolve duplicate descriptive flexfield context codes and names using the cached g_code_name_tab.
• REPLACE_RESOURCE_ID — Substitutes resource identifiers within collected time data.

Tables Accessed

The package reads and writes through APPS synonyms. Time data is sourced from HXC_TIME_BUILDING_BLOCKS and HXC_TRANSACTION_DETAILS, which hold timecard entries and their processing status. Descriptive flexfield metadata is resolved from FND_DESCR_FLEX_CONTEXTS, FND_DESCR_FLEX_COLUMN_USAGES, and FND_DESCRIPTIVE_FLEXS. Structural reference data comes from HXC_ALIAS_DEFINITIONS, HXC_ALIAS_TYPES, HXC_ALIAS_TYPE_COMPONENTS, HXC_ALIAS_VALUES, and HXC_ALIAS_VALUES_TL. Deposit state is tracked in HXC_DEP_TRANSACTIONS. Institutional context derives from HR_ORGANIZATION_INFORMATION, BEN_BENEFIT_CLASSIFICATIONS, FND_APPLICATION, and FND_PRODUCT_INSTALLATIONS.

Usage Notes

HXC_DEPOSIT_WRAPPER_UTILITIES is invoked indirectly during timecard submission and deposit from Time and Labor self-service pages and from concurrent deposit processing programs. Customizations that extend the deposit pipeline should call these serialization helpers rather than reimplementing string parsing, because the string formats are shared across the nineteen dependent packages. Direct modification of the package body is not supported; extensions should wrap the documented public functions.