Search Results get_date_diff_for_display

Overview

APPS.PQH_LENGTH_OF_SERVICE_PKG is a public PL/SQL package within the Oracle E-Business Suite Public Sector / Human Resources (PQH) product family. Its principal business function is the calculation and retrieval of length-of-service (LOS) values for employees and assignments, together with the supporting data required to present those values accurately. The package encapsulates the rules by which Oracle EBS derives service duration from an assignment or person record, expressed in configurable return units such as days, and is closely associated with the length-of-service calculation logic originally developed for German Public Sector (PS) statutory requirements, including military service periods and correction factors.

The package is classified as OTHER in the documented API metadata. It is not a full business object API with create/update semantics, but rather a collection of calculation and lookup helper functions used to resolve service-related attributes for downstream processing, reporting, and display.

Key Procedures and Functions

The package exposes fifteen documented functions and procedures. The core routine is GET_LENGTH_OF_SERVICE, which returns a numeric length-of-service value based on the business group, person and assignment identifiers, a length-of-service type, an optional return unit, and an optional determination date. A second overload of the same function supports the German PS ruleset and returns the value as a VARCHAR2, accepting previous job and assignment start/end dates.

• GET_EMPLOYEE_TYPE — resolves the employee type associated with the calculation context; the object targeted by the user's search term.
• GET_DE_MILITARY_SERVICE_PERIOD — calculates the German military service period for a person within a given date range and LOS type.
• GET_DE_CORRECTION_FACTOR — returns the German-specific correction factor applicable to a person, LOS type, and effective date.
• GET_LENGTH_PREVIOUS_EMPLOYMENT — determines the length of prior employment for a person within a business group and LOS type.
• GET_CORRECTION_FACTOR — returns the general correction factor used to adjust LOS values.
• GET_CORPS_NAME — retrieves the corps name associated with the person or assignment.
• GET_GRADE_NAME — returns the grade name used in LOS reporting.
• GET_LOS_FOR_DISPLAY — formats the length-of-service value for presentation.
• GET_WORKING_TIME_RATIO — returns the working-time ratio applied to pro-rate service calculations.
• GET_ABSENT_PERIOD — computes absence periods that qualify for exclusion from service duration.
• GET_PARTTIME_ENTITLEMENT — derives the part-time entitlement relevant to service computation.
• GET_DATE_DIFF_FOR_DISPLAY — expresses the difference between dates in a display-ready format.

Tables Accessed

The package reads primarily from HR and PER base tables exposed through APPS synonyms. Person and assignment context is drawn from PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F, while organizational context is resolved through HR_ALL_ORGANIZATION_UNITS, HR_ALL_POSITIONS_F, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX. Grade and prior-employment data come from PER_GRADES and PER_PREVIOUS_JOBS. German PS-specific definitions are held in PQH_CORPS_DEFINITIONS and read alongside HR lookup values. Absence-related exclusions use PER_ABSENCE_ATTENDANCES and PER_ABSENCE_ATTENDANCE_TYPES. Additional descriptive attributes are obtained from PER_ASSIGNMENT_EXTRA_INFO and PER_PEOPLE_EXTRA_INFO, with key flexfield structure metadata supplied by FND_ID_FLEX_STRUCTURES and application session context by FND_SESSIONS.

Usage Notes

PQH_LENGTH_OF_SERVICE_PKG is typically invoked from Oracle HRMS forms, Public Sector calculation routines, and concurrent programs that require service duration for entitlement, seniority, or statutory processing. The documented metadata notes that the package is referenced by two other packages, confirming its role as a shared calculation layer rather than an entry-point API. Custom code should call the functions with valid organization, person, and assignment identifiers and observe the LOS type lookup codes defined for the installation, since the return values — including correction factors and employee type — directly influence the resulting length-of-service figure.