Search Results pqh_fr_assignment_api




Overview
Explore in AI Chat

Overview

The APPS.PQH_FR_ASSIGNMENT_API package is a public PL/SQL API within the Oracle E-Business Suite Human Resources (HR) and Public Sector/HR-France localization modules. It provides the programmatic interface for creating, maintaining, and terminating French public-sector affectations — the localized representation of an employee's assignment to a position, grade, corps, and related career attributes. The package encapsulates the business rules governing French HR administration, including affectation lifecycle transitions, employment terms, administrative career progression, and suspension or reactivation of an employee's assignment record. Because it is classified as an API and depends on the standard HR_API utility package, it enforces the same validation, security, and date-tracking conventions applied across Oracle HRMS business objects.

Key Procedures and Functions

The package exposes seven documented procedures that manage the affectation lifecycle:

  • CREATE_AFFECTATION — Creates a new affectation record for an employee, establishing the initial assignment-to-position relationship and associated career attributes.
  • UPDATE_AFFECTATION — Modifies an existing affectation record, allowing changes to affectation details while preserving the underlying assignment history.
  • UPDATE_EMPLOYMENT_TERMS — Maintains the employment-terms information attached to an affectation, covering contractual and employment-condition attributes.
  • UPDATE_ADMINISTRATIVE_CAREER — Updates administrative-career data, including corps, grade, and career-stage information associated with the employee's affectation.
  • TERMINATE_AFFECTATION — Ends an affectation, applying the appropriate status and date-effective termination rules.
  • SUSPEND_AFFECTATION — Places an affectation into a suspended state, typically used for temporary administrative interruptions.
  • ACTIVATE_AFFECTATION — Reactivates a previously suspended affectation, restoring it to an active status.

Tables Accessed

The package reads and writes through APPS synonyms across the following documented tables:

  • PER_ALL_ASSIGNMENTS_F — The core date-effective assignment table where the affectation's assignment record is stored and maintained.
  • PER_ASSIGNMENT_STATUS_TYPES — Supplies the valid assignment statuses applied during create, suspend, activate, and terminate operations.
  • PER_SPINAL_POINT_PLACEMENTS_F — Stores spinal-point (grade/step) placement information for the employee's career.
  • PQH_CORPS_DEFINITIONS — Provides the corps definitions against which the affectation and administrative career are validated.
  • HR_SOFT_CODING_KEYFLEX — Holds the descriptive flexfield soft-coding key flexfield segments associated with the affectation record.

Usage Notes

This API is typically invoked from Oracle HRMS forms, concurrent programs, and custom extensions that manage French public-sector HR data. It is referenced by the PQH_FR_ASSIGNMENT_SWI package, which serves as the server-side wrapper delegating form and batch operations to this API. Because all logic is encapsulated within the API and routed through HR_API, direct DML against the underlying assignment tables is discouraged; developers should call these procedures to ensure date-effectivity, validation, and status consistency. The package is dependent on APPS, SYS, and HR_API, and is referenced by one other package, reinforcing its role as a controlled integration point for affectation processing within EBS 12.1.1 and 12.2.2.