Search Results cla_summary_alias_translation




Overview
Explore in AI Chat

Overview

HXC_TIMECARD_UTILITIES is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the OTHER API category. It provides the server-side foundation for Oracle Time and Labor (OTL) timecard period generation, assignment evaluation, and timecard preprocessing logic. Its principal business responsibility is to compute the sequence of time periods (daily, weekly, bi-weekly, semi-monthly, or monthly) that a resource is entitled to enter time against, applying the preferences and rules configured for the timecard layout. The package also resolves assignment-related context, PTO accrual balances, and attachment copy operations used when timecards interact with Oracle Payables.

The header comments document that the package evolved over time: the original get_time_periods procedure was overloaded by a newer implementation that evaluates period-related preferences on the server, while the legacy overload is retained only for backward compatibility with existing middle-tier callers. New development is explicitly directed to the newer procedure. This behavior is central to why users searching for get_assignment_periods are routed to this package: assignment period resolution, which determines the valid timecard periods across a worker's assignment set, is delivered through this utility layer.

Key Procedures and Functions

  • GET_TIME_PERIODS — Returns the set of timecard periods for a resource, honoring period type, duration, hire date, existing timecard visibility, and the first empty period. The newer overload performs server-side preference evaluation and is the recommended entry point.
  • GET_CURRENT_PERIOD — Derives the current timecard period from the recurring period start date, period type, duration, and current date.
  • GET_ASSIGNMENT_PERIODS — Resolves the periods applicable to a given assignment or assignment set, supporting the assignment-driven timecard views used in 12.1.1 and 12.2.2.
  • PROCESS_ASSIGNMENTS — Applies assignment selection and status logic so that only valid assignments participate in timecard entry.
  • FIND_CURRENT_PERIOD — Locates the active period for a resource within the recurring period definition.
  • GET_PERIOD_LIST and GET_PERIODS — Produce formatted period lists for the timecard UI.
  • GET_PTO_BALANCE — Retrieves paid time off balances derived from accrual plans and element entries.
  • CLA_SUMMARY_ALIAS_TRANSLATION — Translates timecard summary field aliases for display and processing.
  • INIT_GLOBALS — Initializes package-level global variables, typically during session setup.
  • COPY_ATTACHMENTS_TO_AP — Copies attached documents from the timecard to Oracle Payables records.

Tables Accessed

The package interacts with configuration, transactional, and HR tables through APPS synonyms. HXC_RECURRING_PERIODS and HXC_DATA_SETS supply the period definitions and the data set context that govern period generation. HXC_TIME_BUILDING_BLOCKS, HXC_BLD_BLK_INFO_TYPES, HXC_TIME_ATTRIBUTES, and HXC_TIME_ATTRIBUTE_USAGES provide timecard structure and attribute behavior. HXC_TIMECARD_SUMMARY and HXC_TC_AP_LINKS support summary rollups and the linkage used during Payables attachment copying. Payroll accrual data is read from PAY_ACCRUAL_PLANS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, and PAY_ELEMENT_TYPES_F to compute PTO balances. Resource and assignment validation relies on PER_ALL_ASSIGNMENTS_F and PER_ASSIGNMENT_STATUS_TYPES, while FND_ATTACHED_DOCUMENTS supports the attachment copy routine.

Usage Notes

HXC_TIMECARD_UTILITIES is invoked primarily from OTL timecard middle-tier code and from the OTL self-service timecard pages, rather than directly by end users. It is not typically exposed through its own concurrent program; instead, it is called during timecard rendering and submission, and it is referenced by six other packages within the ETRM schema. Because the older get_time_periods overload is deprecated, customizations should call the newer overload to obtain correct server-side preference evaluation. Custom extensions that resolve assignment periods should call GET_ASSIGNMENT_PERIODS rather than reconstructing period logic manually, ensuring compatibility with both 12.1.1 and 12.2.2 period preference behavior.