Search Results set_transaction

Overview

HXT_OTC_RETRIEVAL_INTERFACE is an Oracle E-Business Suite package body owned by APPS that supports the retrieval of approved timecard data from Oracle Time and Labor (OTL) for transfer to Oracle Payroll and, where applicable, to Oracle Time and Labor's downstream payroll repository (OTM/RET). The package operates within the HXT schema family, which stores timecard, hours-worked, and earning-rule data used by the OTL retrieval engine. Its central responsibility is to determine which approved summary timecards are eligible for retrieval on a given processing day and to assemble the associated assignment, element, and payroll attribute information needed for successful transfer.

Because the package contains private helper functions such as is_retrievable and timecard_id, it embeds business logic that prevents duplicate or premature retrieval — notably respecting current timecard retrieval restrictions when timecards have already been sent to payroll. An exception handlers such as e_record_error and e_amount_hours indicate that record-level and amount/hours validation failures are captured during processing, and a package-level associative array (g_timecards) and the g_bg_id global track state across retrievals.

Key Procedures and Functions

• GET_EMPLOYEE_NUMBER — Resolves the employee number associated with a person, typically used to populate the payroll interface payload and to correlate OTL records with payroll assignment data.
• GET_ASSIGNMENT_ID — Returns the assignment identifier for a person, which is required to link retrieved timecard data to the correct payroll assignment and element entries.
• PARSE_ATTRIBUTES — Extracts and interprets descriptive flexfield or mapping-component attributes, populating the attribute structure consumed by downstream transfer logic.
• FIND_EXISTING_TIMECARD — Searches existing HXT timecard records to determine whether a timecard already exists for a person and time period, supporting duplicate-prevention and retrieval eligibility checks.
• TRANSFER_TO_OTM — Performs the actual transfer of retrieved timecard data into the OTM (Oracle Time and Labor payroll) interface tables, assembling payroll details and earning information.
• CHK_NEED_RE_EXPLOSION — Determines whether a timecard's elements or earning rules require re-explosion, ensuring that element entries reflect the latest rules and mappings before transfer.

Tables Accessed

• HXT_TIMECARDS_F — primary timecard header records used to identify and validate timecards.
• HXT_SUM_HOURS_WORKED_F and HXT_DET_HOURS_WORKED_F — summary and detail hours-worked records that carry the quantity and date-worked information evaluated for retrieval eligibility.
• HXT_ADD_ASSIGN_INFO_F and HXT_ADD_ELEM_INFO_F — additional assignment and element information storing payroll-relevant attributes.
• HXT_EARNING_POLICIES, HXT_EARNING_RULES, HXT_EARN_GROUPS — earning definitions that determine how hours are converted into payable earnings and whether re-explosion is needed.
• HXC_RET_PAY_DETAILS, HXC_RET_PAY_LATEST_DETAILS — retrieval-payroll detail tables that hold the output of the transfer process.
• HXC_MAPPING_COMPONENTS, FND_FLEX_VALUES, FND_DESCR_FLEX_COLUMN_USAGES — flexfield and mapping metadata used to parse attributes and resolve descriptive flexfield values.
• HXC_TIME_BUILDING_BLOCKS, HXC_DEBUG — time-building block definitions and the debug logging table used when hr_utility.debug_enabled is true.

Usage Notes

The package is not an end-user-facing API but an internal engine invoked by the OTL timecard retrieval and payroll transfer processes. In 12.1.1 and 12.2.2, it is typically called from concurrent programs or scheduled retrieval runs that select approved timecards for a person or batch, rather than from a standard form. Custom code should not call these procedures directly unless it mirrors the standard retrieval flow, because the private state variables and eligibility logic assume a controlled processing sequence. The package header date and version (120.11.12010000.4) indicate it is a shipped OTL retrieval component; changes should be applied through supported patches.