Search Results pay_validate_process




Overview
Explore in AI Chat

Overview

PAY_HXC_DEPOSIT_INTERFACE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that serves as the deposit interface layer for the Oracle Time and Labor (OTL) and Oracle Payroll integration. Its primary responsibility is to retrieve, validate, and update timecard and deposit-related data flowing between the Time and Labor repository and the Payroll application so that time entered by employees can ultimately be processed as payroll input values and earnings. The package bridges the HXC (Time and Labor) and PAY (Payroll) table families, resolving time entries into the input values, element types, and assignment-based element links required for payroll costing and net calculation. The search term "iv_id" points directly to the package's central abstraction: input value identifiers. The embedded record type r_iv_mapping explicitly declares iv_id pay_input_values_f.input_value_id%TYPE alongside iv_name, iv_seq (display sequence), and iv_uom, and related structures such as r_iv_lk_map and r_ivn carry input value names keyed by element type and lookup codes. This confirms that the package is fundamentally an input-value resolution engine: it maps Time and Labor building blocks onto payroll input values so they can be passed to payroll processing.

Key Procedures and Functions

The documented API surface consists of six procedures, grouped into retrieval, validation, and update pairs for the payroll and HR flows:

  • PAY_RETRIEVAL_PROCESS — Retrieves payroll-side data, resolving element types, input values (iv_id), and their effective-dated mappings required to interpret timecard information for payroll.
  • HR_RETRIEVAL_PROCESS — Retrieves the HR-side context, including assignment and person name data used to associate time entries with the correct assignment and business group.
  • PAY_VALIDATE_PROCESS — Validates the retrieved payroll data, ensuring that input values, element links, and effective dates are consistent before any update or payroll submission.
  • PAY_VALIDATE_TIMECARD — Performs timecard-specific validation, checking that time entries align with valid input value and element type definitions.
  • PAY_UPDATE_PROCESS — Applies the processed payroll data, updating the relevant records after successful validation.
  • PAY_UPDATE_TIMECARD — Writes back timecard-level results, marking entries as processed and updating the mapping state.

No parameter lists are documented in the available metadata; parameter signatures should be confirmed against the package specification in the target environment.

Tables Accessed

The package reads and writes a well-defined set of APPS synonym tables. PAY_INPUT_VALUES_F is the anchor table for input value resolution and supplies input_value_id (iv_id), name, and display_sequence. FND_DESCR_FLEX_COLUMN_USAGES supports descriptive flexfield column resolution. The Time and Labor tables HXC_MAPPING_COMPONENTS, HXC_TIME_BUILDING_BLOCKS, HXC_TIME_RECIPIENTS, and HXC_DEBUG hold mapping definitions, time building blocks, recipient mappings, and debug output. Payroll element configuration is sourced from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPES_F_TL, and PAY_NET_CALCULATION_RULES. Assignment and person context comes from PER_ALL_ASSIGNMENTS_F and PER_ASSIGNMENT_STATUS_TYPES. PLITBLM is an internal PL/SQL table used for bulk processing within the package.

Usage Notes

PAY_HXC_DEPOSIT_INTERFACE is normally invoked indirectly—through Time and Labor payroll submission flows, deposit processes, and the OTL-to-Payroll concurrent programs—rather than being called directly by end users. The package is referenced by one other package, indicating a layered dependency consistent with a supporting interface utility. Custom code that integrates external time sources with Payroll may call these procedures, but direct invocation is typically reserved for the standard OTL/Payroll integration. Because the package is classified as OTHER (not a public API), callers should treat it as internal and verify behavior against the 12.1.1 or 12.2.2 patch level in use.