Search Results hr_pft_bus




Overview
Explore in AI Chat

Overview

HR_PFT_BUS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an "OTHER" API type. Its name and dependency profile place it squarely within the Oracle HRMS position-management feature set; the "PFT" prefix corresponds to the Position Control (position and FTE tracking) subsystem, and the package acts as the business-rule and validation layer that sits between the Position Control base tables and the surrounding transactional packages. Rather than acting as a public, directly-callable API, HR_PFT_BUS functions primarily as an internal support package: it centralises shared security, legislative, and row-level validation logic that other Programmatic Interface (PI) packages depend on. The ETRM record confirms the package is VALID and references APPS.HR_PFT_SHD and the SQL STANDARD package, and is in turn referenced by HR_PFT_DEL, HR_PFT_INS, HR_PFT_UPD as well as itself. The self-reference typically indicates internal, recursive, or shared helper invocation within the package body.

Key Procedures and Functions

Five entry points are documented for this package. Their purposes are as follows:

  • SET_SECURITY_GROUP_ID — Establishes the Oracle HRMS security group context (the Business Group / security profile identifier) under which subsequent queries and validations execute. This ensures multi-tenant and multi-Business-Group isolation in line with HRMS security model conventions.
  • RETURN_LEGISLATION_CODE — Returns the applicable legislation (country) code for the current processing context, allowing downstream validation to apply jurisdiction-specific rules and lookups.
  • INSERT_VALIDATE — Performs pre-insert validation of position/FTE data, confirming that the values about to be written satisfy business rules and referential expectations.
  • UPDATE_VALIDATE — Performs the equivalent validation for update operations, checking that modified rows remain consistent and valid before the change is committed.
  • DELETE_VALIDATE — Validates whether a position/FTE record may legally be deleted, guarding against removal of rows still referenced or otherwise protected.

No parameter lists are documented in the ETRM metadata and none are assumed here.

Tables Accessed

The documented table references are APPS.HR_ALL_POSITIONS_F (the core, date-effective Position definition table) and APPS.HR_ALL_POSITIONS_F_TL (its translation table holding language-specific position names and descriptions). Both are reached through APPS synonyms. HR_PFT_BUS reads these tables to resolve the position being validated and to confirm its existence, effective-dating, and descriptive attributes. The validation procedures almost certainly query HR_ALL_POSITIONS_F to verify referential integrity during inserts, updates, and deletes, while the translation table supports name- or description-based checks where legislation and language context apply. The dependency on HR_PFT_SHD indicates that HR_PFT_BUS also draws on the shared "shadow"/common position-control support package.

Usage Notes

HR_PFT_BUS is an internal layer, not a directly invoked end-user API. It is invoked indirectly through the three PI packages that reference it — HR_PFT_INS, HR_PFT_UPD, and HR_PFT_DEL — which handle the actual insert, update, and delete of position-control records. Each of those packages calls the corresponding *_VALIDATE procedure and the security and legislation helpers before committing changes. In a standard EBS deployment this chain is triggered by the Oracle HRMS Position Control forms, or by concurrent programs and custom PL/SQL that manipulate position and FTE data. Because it carries an "OTHER" classification and is referenced rather than referencing public APIs, customizations should treat HR_PFT_BUS as a private implementation detail and avoid direct calls; the supported integration path is through the HR_PFT_INS/UPD/DEL packages. The metadata applies to EBS 12.1.1 and 12.2.2, where the package remains VALID.