Search Results update_applicant_asg

Overview

APPS.PQH_ASG_WRAPPER is a PL/SQL package in the Oracle E-Business Suite (EBS) Public Sector/HRMS module, owned by the APPS schema. It belongs to the PQH (Public Sector Human Resources) product family, which supports position management, budget and assignment processing for government and public sector organizations. The package serves as a wrapper that centralizes validation and update logic for worker assignments and applicant records, shielding callers from the underlying HRMS and position structure APIs. It abstracts access to position hierarchies, organization hierarchies, and organization structure versions, exposing procedures and functions that determine whether a person, organization, or position meets specific structural or type-based conditions. The package is classified as OTHER in the API registry, indicating it is primarily an internal utility used by other PQH components rather than an officially supported public API. Its status is VALID in the ETRM documentation, and it is referenced by no other documented packages, meaning its callers are typically forms, concurrent programs, or custom extensions within the PQH module. The documented dependency list confirms relationships with HR_ALL_POSITIONS_F, HR_API, HR_ORGANIZATION_UNITS, PER_ORG_STRUCTURE_VERSIONS_V, PER_PERSON_TYPES, PER_POSITIONS, and PER_POS_STRUCTURE_VERSIONS_V, reinforcing its role as a bridge between assignment processing and organizational/positional structure data.

Key Procedures and Functions

The package exposes 11 documented procedures and functions. Each is described below by purpose; parameter lists are not enumerated because they are not provided in the metadata and should not be inferred.

• SHOW_WORKER_NUMBER — Displays or returns the worker number for a given person or assignment, likely used for user-facing rendering in forms or reports.
• IS_PERSON_CORRECT_TYPE — Validates whether a person belongs to the expected person type, typically used to gate assignment or applicant processing.
• IS_TYPE_AN_APPLICANT_TYPE — Determines whether a given person type is classified as an applicant type.
• IS_TYPE_A_SYSTEM_TYPE — Determines whether a given person type is a system-defined type rather than a user-defined one.
• IS_ORG_IN_HIERARCHY — Checks whether an organization is a member of a specified organization hierarchy.
• IS_ORG_A_NODE — Checks whether an organization functions as a node within an organization hierarchy.
• IS_POSITION_IN_HIERARCHY — Checks whether a position is a member of a specified position hierarchy.
• IS_POS_A_NODE — Checks whether a position functions as a node within a position hierarchy.
• UPDATE_ASSIGNMENT — Performs an update to an assignment record, likely invoking HR_API for validation and consistent processing.
• UPD_ASG — An abbreviated update routine for assignments, likely a lower-level or internal helper companion to UPDATE_ASSIGNMENT.
• UPDATE_APPLICANT_ASG — Updates an applicant assignment, applying applicant-specific validation distinct from worker assignment updates.

Tables Accessed

The package reads and writes documented tables through APPS synonyms. Position-related data comes from HR_ALL_POSITIONS_F, PER_POSITIONS, PER_POS_STRUCTURE_ELEMENTS, and PER_POS_STRUCTURE_VERSIONS, which support the position hierarchy and node checks. Organization hierarchy checks rely on HR_ORGANIZATION_INFORMATION, PER_ORG_STRUCTURE_ELEMENTS, PER_ORG_STRUCTURE_VERSIONS, and HR_ORGANIZATION_UNITS. Person and assignment processing uses PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES, and PER_PERSON_TYPES. Additional structures include HR_SOFT_CODING_KEYFLEX for key flexfield data, PQH_COPY_ENTITY_ATTRIBS for attribute copying, FND_SESSIONS for session context, DUAL for trivial queries, and PLITBLM, the PL/SQL integer table type used for array handling. The HR_API dependency indicates the package defers to the standard HR assignment API for insert, update, and validation processing rather than performing direct DML on HR tables.

Usage Notes

PQH_ASG_WRAPPER is typically invoked by PQH forms, concurrent programs, and custom extensions that need to validate hierarchy membership or update assignments and applicant assignments without calling lower-level HR APIs directly. Because it is classified as OTHER rather than a supported public API, it should be treated as an internal utility; custom code referencing it should be aware that signatures may change without notice in patches or upgrades. The presence of both UPDATE_ASSIGNMENT and UPD_ASG suggests layered abstraction, with one routine wrapping another for convenience or backward compatibility. In EBS 12.1.1 and 12.2.2, the package operates against the APPS schema and inherits the standard HRMS security and session context established at runtime.