Search Results extract_data_from_attr_tbl

Overview

The APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE package is a PL/SQL interface component within Oracle E-Business Suite that bridges Oracle Time and Labor (OTL) timecard data with Oracle Payroll. In EBS 12.1.1 and 12.2.2, this package supports the Oracle Time and Labor Payroll batch retrieval process, which gathers approved timecard information and converts it into payroll batch elements for processing by the payroll engine. Its classification under ETRM is OTHER, indicating it is an internal supporting package rather than a formally published public API, though it remains a valid, compiled object in the APPS schema.

The package relies on the generic Oracle Time and Labor retrieval framework, including HXC_GENERIC_RETRIEVAL_PKG, and integrates with the BEE (Batch Element Entry) and OTM (Oracle Time and Labor Mapping) mechanisms used by payroll. It is principally responsible for extracting OTL transaction data, building batch headers and lines, applying adjustments, and transferring results into HR Payroll for further processing.

Key Procedures and Functions

The package exposes twenty documented procedures and functions. Notable ones include:

• PROCESS_OTLR_EMPLOYEES — Drives processing of employees flagged for OTL retrieval, orchestrating extraction and transfer activities.
• EXTRACT_DATA_FROM_ATTR_TBL — Extracts relevant timecard attribute data from the OTL attribute table for downstream processing.
• CREATE_BATCH_HEADER and ADD_TO_BATCH — Build payroll batch structures and append retrieved time entries as batch lines.
• BEE_BATCH_LINE — Generates Batch Element Entry lines representing timecard data mapped to payroll elements.
• MAKE_ADJUSTMENTS_BEE and MAKE_ADJUSTMENTS_OTM — Apply adjustments for BEE and OTM processing modes respectively.
• TRANSFER_TO_HR_PAYROLL — Moves the constructed batch data into HR Payroll for costing and payment.
• RECORD_BATCH_INFO and RECORD_PAY_PA_DETAILS — Persist batch metadata and pay/payroll-action detail records.
• BATCH_NAME, BATCHES_CREATED, RETRO_BATCH_SUFFIX, SET_RETRO_BATCH_SUFFIX — Manage batch naming conventions, including retroactive batch suffixes.
• WHERE_CLAUSE — Constructs dynamic filtering criteria for retrieval selection.
• CACHE_PREFERENCES, CHK_INTG_ENABLED, and MARK_BATCHES_FOR_ROLLBACK — Handle preference caching, integration enablement checks, and rollback flagging.

Tables Accessed

The package reads and writes against several core EBS tables. Time and Labor sources include HXC_TRANSACTIONS, HXC_TIME_BUILDING_BLOCKS, HXC_RETRIEVAL_PROCESSES, and HXC_PAY_PA_LINK_ALL. Payroll batch output is stored in PAY_BATCH_HEADERS and PAY_BATCH_LINES, with element mapping resolved via PAY_ELEMENT_TYPES_F. HR data is sourced from PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_BUSINESS_GROUPS_PERF, HR_ALL_ORGANIZATION_UNITS, and HR_SOFT_CODING_KEYFLEX. Utility and message data come from FND_APPLICATION, FND_NEW_MESSAGES, FND_CONCURRENT_REQUESTS, and FND_FLEX_VALUES.

Usage Notes

This package is typically invoked by the OTL Payroll batch retrieval concurrent program during payroll processing cycles for assignments configured to use the OTL Payroll integration. Administrators do not call it directly; rather, it executes as part of the seeded retrieval framework following management approval of timecards. Customizations should be approached cautiously, as the package is not classified as a public API and its procedures are subject to change between EBS releases.