Search Results create_affectation

Overview

APPS.PQH_FR_ASSIGNMENT_SWI is a self-service wrapper package belonging to the Oracle EBS Public Sector / Human Resources family of APIs (the PQH_FR prefix denotes a French localization of the assignment, or affectation, business object). Its role is to expose server-side PL/SQL APIs to self-service interfaces — typically Oracle Self-Service Human Resources (SSHR) — by wrapping the underlying business API layer, here pqh_fr_assignment_api. Each wrapper procedure accepts already-derived IN parameters, delegates to the corresponding API routine, and returns a status indicator through p_return_status, signalling success or failure to the calling self-service flow.

The package is classified in the ETRM metadata as API classification OTHER, with the source header comment noting it is designated "Internal Development use only." The header revision (pqastswi.pkh 120.0, dated 2005) indicates the package has been stable since the early 11i/12.0 era and remains present in the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The ETRM metadata documents seven procedures, all of which follow the self-service wrapper pattern described above:

• CREATE_AFFECTATION — Creates a new assignment (affectation) record from self-service input. Parameters include the organization, position, person, job, supervisor, assignment number, assignment status type, and affectation-specific attributes; it returns the assignment ID, object version number, effective dates, sequence, and soft-coding keyflex ID.
• TERMINATE_AFFECTATION — Ends an existing affectation, used when a worker leaves a position or organisation.
• UPDATE_AFFECTATION — Modifies attributes of an existing affectation record. This is the procedure relevant to the searched term "update_administrative_career", as administrative career changes on an affectation are handled through the update family of wrappers.
• UPDATE_EMPLOYMENT_TERMS — Adjusts employment terms (working hours, conditions) on an assignment.
• UPDATE_ADMINISTRATIVE_CAREER — Updates the administrative career attributes of an affectation, such as grade, step, or career progression details specific to the French public-sector HR model.
• SUSPEND_AFFECTATION — Places an affectation into a suspended state without terminating it.
• ACTIVATE_AFFECTATION — Reactivates a previously suspended affectation.

Tables Accessed

The ETRM metadata for this object lists no directly referenced tables via APPS synonyms, which is expected for a self-service wrapper: the actual DML is performed by the underlying API layer (pqh_fr_assignment_api and its dependencies). At runtime, the package indirectly reads and writes the standard HR assignment tables — principally HR_ASSIGNMENTS_F, HR_ASSIGNMENTS, PER_ALL_ASSIGNMENTS_F, and the French-localisation extensions that store affectation and administrative-career data — as well as soft-coding keyflex structures referenced by p_soft_coding_keyflex_id. Because the wrapper delegates rather than touching tables itself, table-level impact must be traced through the API layer.

Usage Notes

PQH_FR_ASSIGNMENT_SWI is not intended to be called directly by end users; its header explicitly restricts it to internal development use. It is typically invoked from SSHR self-service flows and, in customisations, from forms or concurrent programs that need to perform assignment or administrative-career maintenance on behalf of a self-service user. Custom code calling this package should supply a valid p_effective_date, observe the p_validate flag to perform a dry run before committing, and always inspect p_return_status before proceeding. The ETRM metadata records zero packages referencing this object, confirming it sits at the top of its call hierarchy and is invoked only by external interfaces.