Search Results pqh_fr_sync_sal_rates




Overview
Explore in AI Chat

Overview

The APPS.PQH_FR_SYNC_SAL_RATES package is a French localization component within the Oracle EBS Public Sector / Human Resources (PQH) module family. It provides the business logic required to synchronize Global Salary Plan (GSP) salary rates with the French legal "barème" — the statutory salary scale that governs minimum pay progression for employees in France. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the defining schema, which is typical for ETRM utilities invoked from concurrent programs or forms where the APPS schema is the effective execution context.

The header designation ($Header: pqfrssrt.pkh 115.0 2003/11/30 ... noship $) indicates the package was authored during the 11.5.x era and carried forward into 12.1.1 and 12.2.2 without substantive functional revision. Its scope is therefore narrow and stable: reconciling internal grade/step rate structures against externally mandated French salary scales.

Key Procedures and Functions

The package exposes a single documented procedure:

  • SYNC_GSP_SAL_RT_WITH_BAREME — Performs the synchronization of Global Salary Plan salary rates with the French barème. Its signature includes standard concurrent-program error handling outputs (errbuf, retcode), an effective date (p_effective_date), a mode selector (p_mode), a commit control flag (p_commit_mode) that determines whether the transaction is committed or left for the caller to roll back, and ten generic input parameters (p_ib1 through p_ib10) that allow the caller to pass supplemental selection or filtering values into the synchronization logic.

No other procedures or functions are documented in the ETRM metadata. The absence of helper routines in the specification suggests that supporting logic is contained in the package body or delegated to the PL/SQL APIs associated with the tables listed below.

Tables Accessed

The package reads and writes the following APPS-synonymed tables:

  • PAY_RATES — The core repository of defined pay rates; synchronization updates or reconciles rate rows here.
  • PAY_GRADE_RULES_F — Defines grade-rate rules; consulted to align GSP rate assignments with grade structures.
  • PQH_FR_GLOBAL_INDICES_F — Stores French global salary index values, the datastore representing the barème itself.
  • PER_SPINAL_POINTS and PER_PARENT_SPINES — Hold spinal point and spine hierarchy definitions used to map steps and progression paths.
  • PQH_COPY_ENTITY_TXNS and BEN_COPY_ENTITY_RESULTS — Transaction and result staging tables used by the PQH copy-entity framework to track and report the outcome of entity duplication or propagation operations.

Usage Notes

PQH_FR_SYNC_SAL_RT_WITH_BAREME is characteristically invoked as a concurrent program submission, reflected in its errbuf/retcode out-parameters, and is intended to be run by HR or payroll administrators responsible for French statutory pay compliance. The p_commit_mode parameter supports a dry-run or preview execution, allowing the administrator to validate proposed rate changes before committing them. The p_effective_date parameter ensures synchronization is applied against the correct date-effective rate records. The package is not referenced by any other package per the ETRM metadata (Referenced by 0 other packages), indicating it is a top-level entry point invoked directly rather than a shared utility. Organizations operating French payroll should schedule this procedure whenever the legal barème is revised, or after any structural change to Global Salary Plans, grades, or spinal points.