Search Results transfer_to_otm

Overview

The APPS.HXT_OTC_RETRIEVAL_INTERFACE package is a component of the Oracle Time and Labor (OTL) module within Oracle E-Business Suite (EBS). OTL is part of the broader Enterprise Resource Planning (ERP) suite and is responsible for capturing, validating, approving, and transferring time entry data for payroll, project costing, and other downstream consumers. The package sits at the boundary between the Oracle Time and Labor environment and the Oracle Time and Labor Management (OTM) retrieval layer. Its primary business function is to retrieve timecard information from OTL source structures, resolve the associated employee and assignment identifiers, parse any flexfield or attribute values into meaningful components, and transfer the resulting records to the OTM interface for further processing.

The package is classified in the ETRM metadata as an OTHER API, meaning it is not a formally published public application programming interface but rather an internally invoked package that supports the retrieval and transfer flows executed by higher-level OTL processes. The package body is valid in the APPS schema, and the metadata confirms it references and is referenced by several other OTL components, including HXT_BATCH_PROCESS, HXT_RETRO_MIX, HXT_TIME_COLLECTION, and the payroll-side interface PAY_HR_OTC_RETRIEVAL_INTERFACE.

Key Procedures and Functions

The package exposes seven documented procedures and functions. Each supports a specific step in the retrieval and transfer workflow:

• GET_EMPLOYEE_NUMBER — Resolves the employee number associated with a timecard record, providing the identity needed for downstream processing.
• GET_ASSIGNMENT_ID — Returns the assignment identifier that links the employee to a specific position or assignment used during retrieval.
• PARSE_ATTRIBUTES — Decomposes flexfield or descriptive attribute values into their component parts so they can be interpreted and mapped correctly.
• FIND_EXISTING_TIMECARD — Locates an existing timecard that matches the incoming retrieval criteria, supporting reconciliation and update logic rather than blind insertion.
• TRANSFER_TO_OTM — Performs the core transfer of retrieved time data into the OTM interface structures.
• CHK_NEED_RE_EXPLOSION — Determines whether a re-explosion of timecard data is required, typically after changes that affect rule or building-block evaluation. The metadata lists six documented procedures/functions explicitly; the seventh entry reflects the package-level body reference.

Tables Accessed

The package reads and writes several OTL and OTM tables through APPS synonyms. Flexfield resolution uses FND_DESCR_FLEX_COLUMN_USAGES and FND_FLEX_VALUES, which supply the descriptive flexfield definitions and valid values needed by PARSE_ATTRIBUTES. Debugging and diagnostic output relies on HXC_DEBUG. Mapping logic uses HXC_MAPPING_COMPONENTS. Retrieved payroll details are staged in HXC_RET_PAY_DETAILS and HXC_RET_PAY_LATEST_DETAILS, while HXC_TIME_BUILDING_BLOCKS holds the building-block definitions used to construct timecard data. Timecard fact tables include HXT_TIMECARDS_F, HXT_ADD_ASSIGN_INFO_F, HXT_ADD_ELEM_INFO_F, HXT_DET_HOURS_WORKED_F, and HXT_SUM_HOURS_WORKED_F. Earning and grouping rules draw from HXT_EARNING_POLICIES, HXT_EARNING_RULES, and HXT_EARN_GROUPS.

Usage Notes

Because this is an OTHER-classified package, it is not intended for direct invocation by end users or custom applications. It is invoked by higher-level OTL processes such as HXT_BATCH_PROCESS, HXT_TIME_COLLECTION, and HXT_RETRO_MIX, and it interacts with the payroll retrieval interface PAY_HR_OTC_RETRIEVAL_INTERFACE. Typical invocation occurs during OTL retrieval and transfer concurrent programs, timecard collection batch runs, and retroactive time processing. Custom code should treat this package as internal and rely on supported OTL public APIs instead.