Search Results get_month

Overview

HR_SA_HIJRAH_FUNCTIONS is a Saudi Arabia (SA) localization utility package owned by the APPS schema in Oracle E-Business Suite. Its purpose is to provide date conversion and Hijrah (Islamic lunar calendar) date arithmetic services to other Oracle HRMS components operating in Saudi Arabian and broader Gulf-region implementations. The package header file is identified as pesahjdt.pkh, first shipped in the 12.1.1 code line (version 120.0.12010000.1, dated 2008/07/28) and still present in the 12.2.2 ETRM inventory.

Because the Hijrah calendar is approximately eleven days shorter than the Gregorian calendar, Oracle HRMS localization for Saudi Arabia must translate dates between the two systems whenever business processes depend on both. Typical drivers include statutory reporting, probation and contract end-date calculations, leave accruals, and service-length computations that are expressed in Hijrah terms but stored against Gregorian columns. HR_SA_HIJRAH_FUNCTIONS centralizes that conversion logic so that multiple product modules and customer extensions do not re-implement it.

Key Procedures and Functions

The package exposes nine documented program units, eight of which are functions returning a value and one of which is a validation procedure:

• HIJRAH_TO_GREGORIAN — Converts an inbound Hijrah date, supplied as a character string, into its Gregorian equivalent returned as a string.
• GREGORIAN_TO_HIJRAH — Performs the inverse conversion, accepting a native Oracle DATE and returning the Hijrah date as a string.
• ADD_DAYS — Returns a Hijrah date advanced or reduced by a caller-supplied number of days, supporting duration-based date arithmetic.
• DAYS_BETWEEN — Returns the number of days separating a high Hijrah date and a low Hijrah date; used for elapsed-time and service-length computations.
• GET_DAY — Extracts the day component of a supplied Hijrah date.
• GET_MONTH — Extracts the month component of a supplied Hijrah date.
• GET_WEEKDAY — Returns the numeric weekday for a Hijrah date, essential because the Hijrah working week and weekend differ from the Gregorian convention.
• GET_YEARDAY — Returns the ordinal day number within the Hijrah year.
• VALIDATE_DATE — A procedure that accepts a candidate Hijrah date string and returns a normalized output value, confirming that the input is a structurally valid Hijrah date before it is persisted or passed to other routines.

Tables Accessed

The only documented database object referenced by this package is DUAL, the standard Oracle one-row dummy table. No application tables, HRMS base tables, or localization setup tables are read or written. This is consistent with a pure utility package: all conversion and arithmetic logic resides in PL/SQL code and constants, and the package is therefore stateless and side-effect free with respect to the database. As a consequence, it can be called from any context without transactional risk.

Usage Notes

HR_SA_HIJRAH_FUNCTIONS is invoked primarily as a called utility rather than as a directly executed entry point. ETRM records that it is referenced by one other package. In practice, it is called from Saudi Arabia localization forms and from concurrent programs where Hijrah dates are displayed, validated, or converted for reporting, and from customer-written fast formulas, PL/SQL APIs, and DFF validation routines that need Hijrah arithmetic. Because the functions are scalar and return primitive types, they are well suited to use inside SQL expressions and view definitions. Developers should note that string-format Hijrah inputs must be well formed, which is the role VALIDATE_DATE plays; and because the package carries no configuration state, deployments on 12.1.1 and 12.2.2 behave identically, allowing the same custom code to run across both releases without modification.