Search Results retro_sum_to_mix

Overview

HXT_RETRO_MIX is an Oracle Applications (APPS) PL/SQL package belonging to the Oracle E-Business Suite Time and Labor / OTL (HXT) schema, deployed in releases 12.1.1 and 12.2.2. Its header identifies it as having been created in 2007 under the hxtrmix.pkh prefix and it is classified in ETRM as an "OTHER" API rather than a published public API. The core purpose of the package is to reconcile retrospective (retro) time-and-labor results back into the summarized "mix" of hours used by Time and Labor processing. In Time and Labor, hours can be stored at different levels — detailed timecard lines, summarized hours by time entry rule, and the "mix" of hours buckets that payroll and costing routines consume. When retroactive changes occur (a prior period timecard is corrected, a new assignment or element link takes effect for a past date), those retro changes must be re-flowed into the summarized hours and the mix so downstream payroll and costing remain consistent. HXT_RETRO_MIX encapsulates that movement of retro sum data into the mix structure, triggered with a batch identifier and a time (tim) identifier context.

Key Procedures and Functions

• RETRO_SUM_TO_MIX — the sole entry point declared in the package header. Given a batch id and a tim id, it moves summarized retro hours into the mix and returns a status code (p_sum_retcode) plus an error buffer (p_err_buf). It is the operational heart of the package and the reason the package exists.
• SNAP_RETRIEVAL_DETAILS — a documented collection routine that retrieves snapshotted detail rows, supporting the retro reconciliation by supplying the detailed source records the mix derivation depends upon.
• BATCH_LINE_HOURS — a documented routine that computes or exposes batch-line hour values, tying the retro processing back to the batch lines being processed.

Parameter lists for the latter two are not expanded in the metadata; only RETRO_SUM_TO_MIX's signature is publicly documented in the header excerpt. Callers should treat the package as an internal, version-sensitive API rather than a stabilized extension point.

Tables Accessed

The package touches a broad payroll and time footprint. Time and labor data comes from HXT_SUM_HOURS_WORKED_F, HXT_DET_HOURS_WORKED_F and HXC_RET_PAY_LATEST_DETAILS, which hold the summarized hours, detailed hours and the latest retro-pay details that must be re-mixed. Calendar and location context come from PER_TIME_PERIODS and HR_LOCATIONS_ALL_TL. Payroll processing tables include PAY_BATCH_LINES, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F (and its _TL translation), PAY_NET_CALCULATION_RULES, PAY_ACCRUAL_PLANS and PAY_COST_ALLOCATION_KEYFLEX. FND_FLEX_VALUES supplies key flexfield segment values used during costing. Together these support reading retro hours, resolving the associated payroll elements and rules, and writing the resulting mix back for costing and payroll consumption.

Usage Notes

HXT_RETRO_MIX is not a user-invoked object. It is called internally by Time and Labor batch processing — most commonly during retro processing and the payroll batch push that follows a retro calculation. The ETRM metadata records it as referenced by one other package, indicating it sits low in the OTL call stack rather than at the top. Typical invocation contexts are overtime/retro calculation concurrent programs, the HXC retro-pay flow, and occasionally custom extensions that wrap the OTL APIs. Because it is classified OTHER and its header carries the 120.0.12000000.1 version stamp, functional behavior can change between patch levels; custom code should call it only when no public API alternative exists and should always inspect the returned retcode and error buffer before proceeding.