Results for “hr_pft_shd”

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

Overview

APPS.HR_PFT_SHD is a shadow (SHD) PL/SQL package that belongs to the Oracle E-Business Suite Human Resources "HR_PFT" family, a set of database objects supporting position and position-definition processing within Oracle HRMS. In Oracle EBS 12.1.1 and 12.2.2, the _SHD naming convention typically identifies a package that holds the shared or shadowed implementation logic invoked indirectly by the primary business packages (HR_PFT_BUS, HR_PFT_INS, HR_PFT_UPD, and HR_PFT_DEL). Its documented API classification is OTHER, indicating that it is not a formally published public API but an internal supporting package. It provides concurrency control, argument conversion, language handling, and constraint-error management services consumed by the higher-level position processing packages.

Key Procedures and Functions

The ETRM metadata documents five procedures/functions within HR_PFT_SHD:

• CONSTRAINT_ERROR — Handles database constraint violations raised during position processing, allowing caller packages to intercept and translate integrity errors into meaningful application-level messages.
• API_UPDATING — Provides an update-in-progress indicator or guard, generally used to signal or detect when an API-driven update is under way to control transaction state.
• LCK — Implements locking logic, ensuring that concurrent position operations do not conflict at the row or logical level.
• ADD_LANGUAGE — Manages language-related processing, supporting the multilingual (translation) aspects of Oracle HRMS position data.
• CONVERT_ARGS — Performs argument conversion, normalizing or transforming input values passed between calling packages and the underlying processing logic.

Parameter lists are not documented in the ETRM excerpt and are therefore not reproduced here.

Tables Accessed

HR_PFT_SHD interacts with the following tables through APPS synonyms:

• ALL_CONSTRAINTS — Read to identify constraint definitions and validate integrity, supporting the CONSTRAINT_ERROR procedure.
• FND_LANGUAGES — Read to determine installed languages, supporting ADD_LANGUAGE and translation-related processing.
• HR_ALL_POSITIONS_F — The base position entity, accessed for position data manipulation and validation.
• HR_ALL_POSITIONS_F_TL — The translation table for positions, supporting language-specific position names and descriptions.
• PER_POSITION_DEFINITIONS — Holds position definition records, accessed when processing position structure and validation rules.

Usage Notes

HR_PFT_SHD is not typically invoked directly by end users or custom code. It is referenced by four packages — HR_PFT_BUS, HR_PFT_DEL, HR_PFT_INS, and HR_PFT_UPD — which are the primary drivers of position processing. These callers are commonly triggered from Oracle HRMS forms (such as the Position form), concurrent programs handling mass position updates or dataload, and custom integrations using the position APIs. Custom developers should prefer the documented business packages rather than calling HR_PFT_SHD directly, since it is an internal implementation layer whose interface may change between point releases. Any dependency on its procedures should be treated as unsupported and revalidated after upgrades or patches to the HRMS position schema.