Search Results chk_speed_quota

Overview

PQH_FR_SPEED is an Oracle Applications (APPS) PL/SQL package that belongs to the Oracle Public Sector / Human Resources family of modules, specifically the French HR (PQH_FR) localization area. The PQH prefix denotes the Public Sector and Higher Education product line, while the FR suffix identifies French statutory and collective-agreement features. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package supports the management of career advancement tied to French public-sector grading and speed (quota-based progression) rules.

The package encapsulates the business logic required to evaluate employee eligibility for grade advancement, checking progression constraints such as speed quotas and length-of-service thresholds before an advancement index is applied. It also provides notification support so that managers can be alerted when an advancement action requires attention. The object is documented as VALID in the APPS schema and is classified as an API of type OTHER, indicating it is primarily a supporting internal utility rather than a publicly published interface.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions within PQH_FR_SPEED:

• GET_INCREASED_INDEX — Determines the increased (new) index value applicable to an employee following an advancement or speed step.
• CHK_NOTIFY — Evaluates whether a notification condition is met, providing the control logic that precedes manager notification.
• GET_APPRAISAL — Retrieves appraisal information for an employee, supporting the assessment-driven criteria used in advancement decisions.
• GET_MARKS — Obtains assessment marks or scores, typically consumed when grading or ranking candidates for progression.
• CHK_SPEED_QUOTA — Validates whether a speed (rapid advancement) quota remains available or is exceeded, enforcing quota limits.
• UPDATE_SPEED — Performs the update operation that records the speed advancement result, writing the outcome of the processing to the relevant tables.
• NOTIFY_MANAGER — Issues notification to the responsible manager regarding an advancement or speed event.
• CHK_SPEED_LENGTH — Checks the length-of-service or duration criteria that must be satisfied before speed advancement is permitted.
• GET_MGR_USER — Resolves the manager's FND_USER identifier so that notifications can be directed to the correct recipient.

No parameter lists are published in the ETRM documentation; the descriptions above reflect the documented purpose of each routine only.

Tables Accessed

The package reads and writes data through APPS synonyms across HR, Performance Management, and French public-sector localization tables:

• PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F — Core employee and assignment records that supply the context (assignment, effective dates, person) for advancement processing.
• PER_APPRAISALS and PER_ASSESSMENTS — Source of appraisal and assessment results used by GET_APPRAISAL and GET_MARKS.
• PER_GRADE_SPINES_F, PER_PARENT_SPINES, PER_SPINAL_POINTS, PER_SPINAL_POINT_PLACEMENTS_F, and PER_SPINAL_POINT_STEPS_F — Support the grade spine and spinal point structure that underpins index and step determination.
• PER_ASSIGNMENT_STATUS_TYPES — Provides status validation for assignment-related checks.
• PQH_FR_GLOBAL_INDICES_F, PQH_CORPS_DEFINITIONS, and PQH_CORPS_EXTRA_INFO — French localization tables holding corps definitions, extra information, and global index values for the localization rules.
• BEN_PGM_EXTRA_INFO — Provides benefit program extra information where advancement interacts with benefit eligibility.
• FND_USER — Used by GET_MGR_USER to resolve the manager's application user account for notification.

Usage Notes

PQH_FR_SPEED is referenced by no other packages (0 dependents), which indicates it is a leaf-level utility invoked directly rather than an entry point in a larger call chain. It depends only on SYS.STANDARD and is self-referencing according to the dependency listing. In practice, this package is typically invoked from French HR localization forms, concurrent programs that batch-process speed advancements and quota checks, or from custom extensions that must enforce the same statutory progression rules. Because it is classified as OTHER rather than a published API, direct custom calls should be treated with caution; the underlying business rules and signatures may be internal and subject to change across patch levels or between the 12.1.1 and 12.2.2 releases. Developers extending French public-sector HR functionality should prefer the supported public APIs where available and treat PQH_FR_SPEED as an implementation detail of the localization.