Search Results hr_chkfmt




Overview
Explore in AI Chat

Overview

The APPS.HR_CHKFMT package body is a utility package within the Oracle E-Business Suite Human Resources (HR) module. Its name, "chkfmt," denotes "check format," indicating that the package provides services for validating and transforming value formats — most notably currency amounts and formatted strings — according to the operating environment's profile settings. In Oracle EBS 12.1.1 and 12.2.2, HR_CHKFMT serves as a shared validation routine invoked by other HR and payroll-related packages to ensure that user-supplied or stored values conform to expected formats before they are processed or displayed.

Although the documented API metadata classifies HR_CHKFMT as "OTHER" rather than a public HRMS API, its dependency footprint demonstrates its role as an internal workhorse. The package body is VALID and resides in the APPS schema. It is referenced by 91 other database objects, confirming that it is a foundational, low-level utility used extensively across the HR schema rather than a standalone user-facing API.

Key Procedures and Functions

The ETRM documentation records three documented procedures/functions for this package. Two are named explicitly:

  • CHECKFORMAT — The core validation routine. It verifies whether a supplied value conforms to the expected format, applying the environment's profile-driven format rules. Callers use it to detect malformed input before committing data.
  • CHANGEFORMAT — The transformation routine. It converts a value from one format to another, typically normalizing a displayed or user-entered value into the internal representation, or presenting an internally stored value according to profile settings.

The third documented entry, appearing in the dependency list and cross-reference between the specification and body, is the package-level HR_CHKFMT reference itself, reflecting the overarching specification-to-body linkage. No parameter lists are documented in the ETRM metadata; parameter details are intentionally omitted here and must be confirmed against the package specification in the target environment.

Tables Accessed

The documented dependency information identifies the following key database objects referenced by HR_CHKFMT:

  • FND_CURRENCIES — The Oracle Application Object Library (FND) currency definition table. HR_CHKFMT reads this table to resolve currency codes and their associated formatting attributes, such as precision and extended precision, when validating monetary values.
  • DBMS_SQL — The Oracle-supplied dynamic SQL package. HR_CHKFMT uses dynamic SQL, presumably to evaluate format patterns or to execute context-dependent SQL that cannot be determined at compile time.
  • DUAL — The standard single-row Oracle table, typically used for evaluating expressions or performing lightweight function calls without touching application data.

Additional dependencies include the FND_DATE, FND_NUMBER, and FND_PROFILE packages, along with HR_UTILITY and the STANDARD package, further evidencing the package's reliance on profile-driven formatting and numeric/date conversion utilities.

Usage Notes

HR_CHKFMT is an internal utility rather than a concurrent program or a form directly registered in the Applications menu. It is invoked programmatically from other PL/SQL packages — the metadata confirms 91 dependent objects — whenever formatting validation or conversion is required during HR and payroll processing. Typical invocations occur during data entry validation, payroll run preparation, and UI rendering logic where currency amounts or numeric strings must match the profile-defined format.

Because HR_CHKFMT is not referenced by any object outside the current dependency list and is flagged as "OTHER" rather than a published API, Oracle does not guarantee its interface across releases. Custom code that calls this package should treat it as unsupported and verify the specification in the specific EBS 12.1.1 or 12.2.2 instance before reliance. Where possible, developers should favor documented public HRMS APIs over direct use of this internal utility.