Results for “system_availability_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.HR_PSF_SHD is a shadow (suffix _SHD) PL/SQL package belonging to the Oracle HRMS Position and Position Hierarchy family of APIs. It exposes the server-side logic that underpins position definition, position transaction, and position availability-status processing within Oracle E-Business Suite 12.1.1 and 12.2.2. The package header is authored with AUTHID CURRENT_USER and declares a comprehensive global record type, g_rec_type, which mirrors the column layout of the HR_ALL_POSITIONS_F and HR_ALL_POSITIONS_F_TL entities together with a number of pseudo columns such as comments. This record type is the principal data carrier passed between the package's routines and their callers.

The _SHD designation indicates that the package operates as a lower-level server component rather than as a directly user-facing API. The ETRM classification for the object is "OTHER," and the package is referenced by some twenty other packages, confirming its role as shared infrastructure for higher-level position APIs and position workflows.

Key Procedures and Functions

The ETRM metadata documents thirteen callable units. Because the published interface does not disclose parameter lists, only their purposes are described here.

• GET_AVAILABILITY_STATUS — the routine of interest to users searching this object; returns the availability status associated with a position or position transaction, resolving the availability_status_id carried on the global record type.
• GET_POSITION_JOB_ORG — retrieves the job and organization attributes tied to a given position.
• SYSTEM_AVAILABILITY_STATUS and POS_SYSTEM_AVAILABILITY_STATUS — derive the system-defined availability status for a position, typically used when a position is created or synchronised without an explicit user-supplied status.
• POSITION_WF_SYNC and MY_SYNCH_ROUTINE — synchronise position data with Oracle Workflow, ensuring that workflow routing and notification logic reflects the current position definition.
• CONSTRAINT_ERROR — centralised error handler for constraint violations raised during position DML.
• API_UPDATING — flag/utility that indicates an update is in progress, allowing dependent logic to distinguish insert from update processing.
• FIND_DT_DEL_MODES and FIND_DT_UPD_MODES — date-track helpers that determine the correct delete and update modes for date-tracked (datetracked) position rows.
• UPD_EFFECTIVE_END_DATE — adjusts the effective end date on a date-tracked position record.
• LCK — locking routine used to serialise concurrent access to position rows.
• CONVERT_ARGS — argument conversion utility supporting the package's internal API plumbing.

Tables Accessed

Through APPS synonyms the package reads and writes the core position tables: HR_ALL_POSITIONS_F (the date-tracked base table holding position definitions, including availability_status_id, FTE, headcount and validity dates) and HR_ALL_POSITIONS_F_TL (the translation table supplying the position name). PER_SHARED_TYPES provides shared type lookups used in argument conversion and validation. ALL_CONSTRAINTS is queried to identify and handle constraint violations. WF_PARAMETER_LIST_T supports the Workflow synchronisation routines, and DUAL is used for single-row utility selections.

Usage Notes

HR_PSF_SHD is not intended for direct invocation by end users. It is consumed by the Position form, by position-related concurrent programs, and by the twenty dependent packages that form the HRMS position API stack. Custom extensions should call the documented public APIs rather than HR_PSF_SHD directly, since the _SHD layer may change between patch levels. Where custom code must reference GET_AVAILABILITY_STATUS, it should be treated as a read-only lookup that resolves availability status for an already-identified position or transaction, and it should be executed within the same session context (business group and effective date) as the calling form or program.