Search Results get_cer_extract_date




Overview
Explore in AI Chat

Overview

APPS.HR_CERIDIAN is a PL/SQL package that supports the Ceridian payroll interface within Oracle E-Business Suite. Ceridian is a third-party payroll and human capital management outsourcing provider, and implementations that outsource payroll processing to Ceridian require Oracle EBS to exchange employee, tax, and payroll data with the external system. The package encapsulates the Oracle-side logic needed for that integration. The package header (pecerpkg.pkh) shows it maintains a package-level global variable, g_cer_extract_date, which serves as a single control point for the date associated with a Ceridian extraction run. Because Ceridian extracts are date-sensitive — determining which payroll period, effective-dated assignment, or tax record is included — anchoring the run date in a package global ensures consistency across all processing that occurs within the same session or extraction cycle. Within Oracle EBS 12.1.1 and 12.2.2, the package is classified as OTHER, meaning it is not a public, fully supported business API in the same category as the HR_* person and assignment APIs, but it remains a documented object that other code references.

Key Procedures and Functions

  • SET_CER_EXTRACT_DATE — A procedure that accepts a Ceridian extraction date and assigns it to the package global g_cer_extract_date. It establishes the working date for a Ceridian extraction run so that subsequent calls within the package operate against a consistent reference date.
  • GET_CER_EXTRACT_DATE — A function that returns the current value of g_cer_extract_date. This is the object referenced by the search term "get_cer_extract_date." It carries the compiler pragma RESTRICT_REFERENCES with the WNDS (Write No Database State) constraint, confirming that the function does not modify database state — it is a pure accessor suitable for use in SQL and PL/SQL expressions without side effects.
  • FICA_FUTA_EXEMPT — A function that evaluates FICA (Social Security and Medicare) and FUTA (federal unemployment) tax exemption status. It takes Medicare, Social Security, and FUTA exemption indicators as inputs and returns a resultant value used to determine how an employee's wages should be treated for these statutory taxes in the Ceridian extract.

Tables Accessed

The ETRM metadata for HR_CERIDIAN does not document any tables referenced via APPS synonyms. The package is defined primarily around in-memory control state (the extraction-date global) and tax-exemption evaluation logic rather than direct table DML. Where database access occurs, it would be through schema-level constructs maintained in the Oracle HRMS tax and payroll data model, but no specific tables are confirmed in the documented metadata; consumers should not assume direct table dependencies without code inspection.

Usage Notes

HR_CERIDIAN is an internal integration component rather than an end-user-facing API. The metadata records that it is referenced by 19 other packages, indicating it sits near the base of the Ceridian-specific dependency chain: higher-level packages call SET_CER_EXTRACT_DATE to establish the run date, then invoke GET_CER_EXTRACT_DATE to retrieve it consistently, and use FICA_FUTA_EXEMPT when resolving statutory tax treatment. Typical invocation paths include Oracle HRMS payroll processes, Ceridian extract concurrent programs, and custom bidirectional integration code that stages or reads Ceridian payroll output. Because GET_CER_EXTRACT_DATE is pragma-restricted as WNDS, it can be safely embedded in SQL statements and expressions. Implementations upgrading between 12.1.1 and 12.2.2 should treat the package as version-sensitive and regression-test the extraction-date and tax-exemption behavior, since the package governs date consistency across the interdependent Ceridian interface packages.