Search Results get_grade_details

Overview

APPS.HR_MEE_VIEWS_GEN is a PL/SQL package belonging to the Human Resources (HR) module of Oracle E-Business Suite. Its name reflects its role as a generator of supporting data for HR Management and Employee Effectiveness (MEE) views, which present derived workforce information such as salary comparisons, grade and step positioning, training activity, and currency-converted amounts. The package exposes a library of scalar and conversion functions rather than transactional APIs, making it a read-oriented utility layer consumed by HR reporting views and dependent logic.

As documented in ETRM for release 12.2.2, the package is owned by APPS and classified as OTHER under API classification. It contains 53 documented procedures and functions and is not referenced by any other packages, indicating that it sits at the leaf of the dependency chain — it depends on other objects but does not form part of a callable public API surface for downstream PL/SQL. Its header carries a source version identifier (hrmegviw.pkh, 120.6) and dates to the 12.x code line, consistent with its presence in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The functions fall into several functional groups. Salary and compensation logic is centred on GETCOMPRATIO, which computes a comparison ratio from currencies, an annual salary, an annual grade midpoint value, and an effective date. The search term "get_annual_salary" corresponds to the annual salary input used by this function rather than to a standalone documented routine. GETCOSTCENTER returns a cost centre value for an assignment, and related grade and step helpers — GET_GRADE_DETAILS, GET_STEP_DETAILS, and GET_STEP_NUM — retrieve grade and step information effective at a given date.

Currency and duration conversion is handled by CONVERTAMOUNT, AMTINLOGINPRSNCURRENCY, CONVERTDURATION, and GETLOGINPRSNCURRENCYCODE, which translate amounts and durations between currencies or into the logged-in person's currency. GETEFFDATE supplies an effective date reference.

Training-related functions aggregate learning activity: GETAVGCLASSESPERYEAR, GETCLASSESTAKEN, GETFUTURECLASSES, GETTRNGDAYS, GETTRNGDAYSYTD, GETTRNGHRS, GETTRNGCOST, GETTRNGCOSTYTD, GETTRNGPRCTONPAYROLL, and GET_TRAINING_CENTER. Together these provide counts, hours, costs, year-to-date totals, and payroll percentages for training, supporting workforce development reporting.

Tables Accessed

The package reads from a broad set of HR, Payroll, and Oracle Training Administration (OTA) tables via APPS synonyms. Assignment and person data come from PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F, with PER_CONTACT_RELATIONSHIPS and PER_ABSENCE_ATTENDANCES supplying relationship and absence context. Grade and step logic relies on PAY_GRADE_RULES_F, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F.

Costing information is drawn from PAY_COST_ALLOCATIONS_F and PAY_COST_ALLOCATION_KEYFLEX, while organisation data comes from HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION. Training records are sourced from OTA_EVENTS, OTA_DELEGATE_BOOKINGS, and OTA_BOOKING_STATUS_TYPES. FND_SESSIONS provides the current session context used for login-currency and personalisation functions.

Usage Notes

HR_MEE_VIEWS_GEN is a backend utility package invoked primarily by HR views and forms that require computed salary, grade, step, currency, or training metrics. It is not intended for direct update operations; typical invocation occurs through SQL in view definitions or through form-level triggers that call its functions to populate display fields. Because it is referenced by no other packages, integrators should treat it as an internal supporting object rather than a supported extension point, and any custom code calling it should pin to the specific EBS release, as function signatures are governed by the shipped header and are subject to change between patch levels.