Results for “update_speed”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PQH_FR_SPEED is an Oracle E-Business Suite PL/SQL package body owned by APPS and classified under the ETRM taxonomy as OTHER. Its name and internal comments indicate a French (FR) localization component within the Public Sector / Human Resources (PQH) module family, concerned with "SPEED" processing — a graded career advancement concept used in French public-sector HR. The package implements logic for evaluating employee eligibility for accelerated progression through spinal point steps, and for notifying managers when such a progression is due.

The package body header ($Header: pqchgspd.pkb 120.2 ... noship $) confirms a 2005 vintage and a location-based debugging convention using HR_UTILITY.set_location. It is not shipping-restricted in the sense of containing no executable business logic; rather it is a self-contained library of functions invoked by other EBS objects rather than exposing a defined public API, which explains the OTHER classification.

Key Procedures and Functions

• GET_INCREASED_INDEX — Returns the increased (advanced) index value corresponding to a gross index and an effective date, read from the global indices reference table. The cursor filters on type_of_record = 'IND'.
• CHK_NOTIFY — Determines whether a manager notification should be generated for a given benefits program, manager, review date and effective date. It reads review-length configuration from the program extra-info table using information_type = 'PQH_FR_CORP_INFO'.
• GET_APPRAISAL — Retrieves appraisal data relevant to the SPEED evaluation.
• GET_MARKS — Retrieves marks or scores used as criteria in the SPEED decision.
• CHK_SPEED_QUOTA — Evaluates quota consumption for SPEED advancement, ensuring the number of accelerated promotions does not exceed the permitted quota.
• UPDATE_SPEED — Performs the update of SPEED-related data, i.e. the actual write-back of advancement information.
• NOTIFY_MANAGER — Generates the manager notification when CHK_NOTIFY determines one is warranted.
• CHK_SPEED_LENGTH — Validates the required length of service or elapsed time before a SPEED advancement can be granted.
• GET_MGR_USER — Resolves the FND_USER identifier of the manager associated with a given assignment, used as the notification recipient.

Tables Accessed

Reference data is drawn from PQH_FR_GLOBAL_INDICES_F (index-to-index conversion), PER_GRADE_SPINES_F, PER_PARENT_SPINES, PER_SPINAL_POINTS, PER_SPINAL_POINT_PLACEMENTS_F and PER_SPINAL_POINT_STEPS_F (the French spinal point structure). Employee data comes from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F and PER_ASSIGNMENT_STATUS_TYPES. Evaluation inputs come from PER_APPRAISALS and PER_ASSESSMENTS. Configuration and body-specific metadata come from PQH_CORPS_DEFINITIONS, PQH_CORPS_EXTRA_INFO, PQH_FR_GLOBAL_INDICES_F via BEN_PGM_EXTRA_INFO. FND_USER resolves manager identities for notification.

Usage Notes

No other package in the ETRM registry references PQH_FR_SPEED directly, indicating it is invoked from forms, concurrent programs or localization-specific customizations rather than from within a shared PL/SQL API layer. Typical invocation would be from the French HR SPEED maintenance form or a periodic concurrent request that scans assignments, checks quota and length eligibility, updates the spinal point placement, and dispatches manager notifications. All access should be granted through the APPS schema synonym, and callers should supply valid effective dates, since the index and configuration lookups are date-effective.