Search Results set_cer_extract_date




Overview
Explore in AI Chat

Overview

HR_CERIDIAN is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It supports the Ceridian payroll interface used by Oracle Payroll for North American (United States and Canadian) legislative environments, where Ceridian is engaged as the third-party payroll services provider rather than Oracle Payroll's native check-writing path. The package encapsulates Ceridian-specific payroll logic: it manages the extract date that governs which payroll actions are selected for a Ceridian submission, and it exposes a federal tax exemption check used when evaluating FICA and FUTA treatment for an assignment. The ETRM record classifies the package under API classification OTHER, confirming that it is an internal implementation package rather than a formally published public API. The body is VALID in the documented environment, and it is not referenced by any database object, meaning no other stored object depends upon it — a characteristic typical of a top-level driver package invoked by form logic or concurrent processing. Dependencies are limited to SYS.STANDARD and APPS.HR_PAY_INTERFACE_PKG, indicating that Ceridian processing reuses the standard payroll interface utilities for its data movement. In the 12.2.2 metadata the package is referenced by nineteen other packages, which places it within a broader Ceridian integration layer rather than as an isolated routine.

Key Procedures and Functions

  • SET_CER_EXTRACT_DATE — Sets the Ceridian extract date used by the payroll extract process. This value establishes the cutoff that determines which payroll actions and results are considered eligible for transmission to Ceridian, allowing the extract to be re-run or scoped to a specific period.
  • GET_CER_EXTRACT_DATE — Returns the currently stored Ceridian extract date. It provides the read counterpart to SET_CER_EXTRACT_DATE, so that extraction logic, forms, and reporting can consistently identify the active extract window.
  • FICA_FUTA_EXEMPT — Determines whether an assignment is exempt from FICA (Social Security and Medicare) and FUTA (Federal Unemployment Tax Act) withholding. The result is used to decide whether the corresponding federal tax deductions should be applied during Ceridian processing.

No parameter lists are asserted here; only the documented names and purposes are described. Per ETRM, these three routines constitute the complete documented surface of the package.

Tables Accessed

The documented ETRM record for HR_CERIDIAN lists no directly referenced tables. All table access is therefore presumed to occur indirectly through the APPS synonyms used by the package's dependencies and the wider payroll data model, and no specific base tables can be attributed to this object from the available metadata. The absence of a documented table list is itself significant: it indicates that the package's persistence for the extract date and its tax-exemption lookups are mediated by the payroll interface layer (HR_PAY_INTERFACE_PKG) and related Payroll objects rather than by direct DML against named tables in this unit.

Usage Notes

HR_CERIDIAN is typically invoked from the Oracle Payroll Ceridian integration, most often through concurrent programs or form-driven actions that submit payroll data to Ceridian. The extract date routines are called at the start and end of an extract run to bracket the selection window, while FICA_FUTA_EXEMPT is called during tax determination to suppress federal withholding for exempt assignments. Because the package is not referenced by any database object and is classified as OTHER, it should be treated as an internal, non-public API: custom code should avoid direct calls unless the same Ceridian extraction contract is being deliberately extended. The nineteen referencing packages documented in 12.2.2 confirm that the package participates in a shared internal interface, and any modification must be assessed against those dependents. Sites on 12.1.1 and 12.2.2 should verify the package remains VALID after patching, since invalidation of HR_CERIDIAN can interrupt Ceridian payroll extraction.