Search Results hr_psf_shd




Overview
Explore in AI Chat

Overview

HR_PSF_SHD is a shadow (synchronization) package body in the APPS schema that supports the Oracle EBS Position Synchronization and Availability infrastructure. The "_SHD" suffix identifies this as a shadow routine set used to maintain consistency between the HR position model and the Workflow (WF) directory services, and to evaluate the availability status of positions within the enterprise. It operates against the HR_ALL_POSITIONS_F and HR_ALL_POSITIONS_F_TL position entities, and bridges the HR position store to Oracle Workflow through the WF_ENGINE, WF_EVENT, WF_LOCAL_SYNCH, and PER_HRWF_SYNCH dependencies. The package is classified under API classification OTHER and is a dependency-consumer rather than a dependency-provider, meaning it is invoked by other application logic rather than exposing a public interface; it is referenced by 20 other packages.

Key Procedures and Functions

The ETRM metadata documents 13 procedures and functions. The availability-related routines determine whether a position can be filled or used at a given point in time:

Workflow and synchronization routines manage the propagation of position data into Workflow:

  • POSITION_WF_SYNC — Synchronizes position records with the Workflow directory and event infrastructure.
  • MY_SYNCH_ROUTINE — A synchronization driver invoked to reconcile position state with Workflow.

Support and utility routines handle the mechanics of the shadow process:

  • CONSTRAINT_ERROR — Raises or handles constraint-related errors surfaced during synchronization.
  • API_UPDATING — Flags or guards the state indicating an API-driven update is in progress.
  • FIND_DT_DEL_MODES — Locates date-effective delete modes for the affected records.
  • FIND_DT_UPD_MODES — Locates date-effective update modes.
  • UPD_EFFECTIVE_END_DATE — Updates the effective end date of a position or related record to close its date-effective range.
  • LCK — Performs record locking.
  • CONVERT_ARGS — Converts argument values for downstream Workflow or API calls.

Tables Accessed

  • HR_ALL_POSITIONS_F — The primary date-effective position table; read to resolve position attributes and written when end-dating or status changes occur.
  • HR_ALL_POSITIONS_F_TL — The translated position name/description table, read to obtain language-specific position text for Workflow synchronization.
  • PER_SHARED_TYPES — Supplies shared lookup/type values used in status and mode determination.
  • WF_PARAMETER_LIST_T — The Workflow parameter list type, used to build and pass parameters to Workflow engine calls.
  • ALL_CONSTRAINTS — Read to inspect constraint definitions, supporting CONSTRAINT_ERROR handling and validation logic.
  • DUAL — Used for single-row evaluations and scalar returns.

Usage Notes

HR_PSF_SHD is an internal shadow package invoked by HR position APIs and by Workflow synchronization processes rather than being called directly from forms. It is typically triggered when position records are created, updated, or end-dated through the standard HR position APIs, and when the availability of a position must be evaluated for assignment or business-group operations. The strong dependency on PER_HRWF_SYNCH, WF_LOCAL_SYNCH, WF_ENGINE, and WF_EVENT confirms that invocation occurs in the context of HR-to-Workflow role/position reconciliation. Because the package is referenced by 20 other packages and references STANDARD, HR_API, HR_GENERAL, HR_UTILITY, and DT_API, customizations should treat it as a dependent implementation detail. Direct modification is not recommended; extensions should wrap the documented procedures. As with all shadow packages, its logic is bound to the Oracle-released position synchronization model and should be revalidated after applied patches to HR and Workflow in both 12.1.1 and 12.2.2.