Search Results get_assignment_status_type

Overview

APPS.PQH_ASG_WRAPPER is a PL/SQL package body that belongs to the Oracle E-Business Suite Public Sector/HR (PQH) product family, specifically the ETRM (Enterprise Talent/HR Management) module area dedicated to assignment maintenance. It is classified as an "OTHER" API, meaning it is not a formal public API in the same sense as the standard HRMS date-tracked APIs, but it still exposes callable functions and procedures. Based on its documented content, the package functions as a wrapper utility layer that consolidates assignment and applicant-assignment update logic, validates organizational and positional hierarchy membership, resolves assignment status types, and formats worker identifiers. It bridges the base HR assignment tables (PER_ALL_ASSIGNMENTS_F and related status/type tables) with position and organization hierarchy structures. The package is owned by APPS and references objects exclusively through APPS synonyms, consistent with standard EBS coding practice.

Key Procedures and Functions

The package documents eleven callable units, named as follows.

• SHOW_WORKER_NUMBER — Formats a display string for a worker by concatenating employee number and non-personal (NPW) number, joining them with a comma. The header comment and inline note indicate applicant number handling was removed.
• IS_PERSON_CORRECT_TYPE — Determines whether a person record conforms to an expected person type.
• IS_TYPE_AN_APPLICANT_TYPE — Tests whether a given type qualifies as an applicant type.
• IS_TYPE_A_SYSTEM_TYPE — Tests whether a given type is a system-defined type.
• IS_ORG_IN_HIERARCHY — Validates that an organization belongs to a specified organization hierarchy.
• IS_ORG_A_NODE — Confirms that an organization represents a node within an organization hierarchy structure.
• IS_POSITION_IN_HIERARCHY — Validates that a position participates in a specified position hierarchy.
• IS_POS_A_NODE — Confirms that a position represents a node within a position hierarchy structure.
• UPDATE_ASSIGNMENT — Updates an assignment record; the primary business operation exposed by the package.
• UPD_ASG — The documented target of the searched term "upd_asg"; performs the core assignment update logic, likely invoked by UPDATE_ASSIGNMENT and other callers.
• UPDATE_APPLICANT_ASG — Applies assignment updates to applicant assignments, paralleling the assignment update path for non-employees/applicants.

Tables Accessed

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

• PER_ALL_ASSIGNMENTS_F — Primary date-tracked assignment table; the central target of update logic.
• PER_ASSIGNMENT_STATUS_TYPES — Resolves assignment status type to system status via GET_ASSIGNMENT_STATUS_TYPE.
• PER_PERSON_TYPES — Supports the IS_PERSON_CORRECT_TYPE and applicant/system type checks.
• HR_ORGANIZATION_INFORMATION, PER_ORG_STRUCTURE_ELEMENTS, PER_ORG_STRUCTURE_VERSIONS — Support organization hierarchy and node validation.
• HR_ALL_POSITIONS_F, PER_POS_STRUCTURE_ELEMENTS, PER_POS_STRUCTURE_VERSIONS — Support position hierarchy and node validation.
• PQH_COPY_ENTITY_ATTRIBS — Controls copy/attribute behavior for PQH entity updates.
• HR_SOFT_CODING_KEYFLEX — Participation in assignment-level key flexfield validation.
• FND_SESSIONS — Session context resolution.
• DUAL — Constants and utility evaluations.
• PLITBLM — PL/SQL table/BLOB utility usage.

Usage Notes

PQH_ASG_WRAPPER is referenced by zero other packages according to the documented metadata, indicating it is not a shared dependency within the EBS codebase and is likely invoked directly by forms, concurrent programs, or custom extensions rather than through internal API chaining. Typical invocation scenarios include institutional/HR maintenance forms where an administrator reassigns or transfers a worker, and custom PL/SQL that must programmatically update PER_ALL_ASSIGNMENTS_F while respecting hierarchy and person-type validation. The "upd_asg" search term points to the UPD_ASG procedure as the principal entry point for assignment updates. Because the package is classified as OTHER rather than a formal HRMS API, consumers should verify date-tracked integrity and leverage the wrapper's built-in hierarchy and type validation routines to maintain data consistency.