Search Results pos_return_update_mode

Overview

GHR_SF52_POS_UPDATE is an Oracle EBS Human Resources (HR) package body owned by the APPS schema, classified under the ETRM as an "OTHER" API. Its internal name and header trace to the US federal government HR localization layer (the GHR prefix denotes Government Human Resources), and the source header identifies the file as ghpauppo.pkb. The package exists to maintain position records within HR, specifically handling the update of position information and the associated "return" update mode logic that controls how position changes are applied. It reads government key flexfield setup information from organization information records (context GHR_US_ORG_INFORMATION) to drive those updates. The package is referenced by six other packages, indicating it is a shared utility used by broader government HR processing flows rather than being invoked directly by end users. The ETRM documents three procedures and no functions: UPDATE_POSITION_INFO, POS_RETURN_UPDATE_MODE, and UPDATE_POSITIONS_LOCATION.

Key Procedures and Functions

• POS_RETURN_UPDATE_MODE — This is the procedure that matches the user search term "pos_return_update_mode." It determines or sets the update mode governing how position return processing behaves. Given its name and the package's role, it controls whether position updates are applied, deferred, or returned to a prior state, serving as the decision gate for the other update procedures.
• UPDATE_POSITION_INFO — Applies changes to position definitions. The package's internal comment block for its helper retrieve_gov_kff_setup_info documents the mechanism: it retrieves government key flexfield setup from hr_organization_information where org_information_context = 'GHR_US_ORG_INFORMATION', selecting org_information1 through org_information5. This retrieved setup record (org_info_rec) supplies the configuration that UPDATE_POSITION_INFO uses when writing position data.
• UPDATE_POSITIONS_LOCATION — Updates location attributes on position records, presumably the physical or organizational location assigned to one or more positions. It works alongside UPDATE_POSITION_INFO to complete a position maintenance transaction.

Tables Accessed

• HR_ALL_POSITIONS_F — The core HR positions table; written by the update procedures to persist position changes.
• HR_ORGANIZATION_INFORMATION — Read to obtain government key flexfield setup, using the GHR_US_ORG_INFORMATION context and columns org_information1–org_information5.
• PER_POSITION_DEFINITIONS — Provides position definition attributes referenced during updates.
• PER_SHARED_TYPES — Supplies shared lookup/type values used to interpret position data.

Usage Notes

Because the package is classified as "OTHER" and is referenced by six other packages, it is intended for internal use by the government HR localization layer rather than as a public integration API. The source comments explicitly mark Access Status as "Internal Use Only" and note that calls to hr_utility procedures were commented out to avoid unintended database writes, confirming that the package is designed to avoid side effects beyond its defined update scope. In practice, these procedures are invoked programmatically—typically from parent GHR packages, concurrent processes, or custom extensions performing position maintenance for US federal customers. They are not documented as form-invoked entry points. Technical consultants integrating with this package should treat it as a dependent utility: its behavior is driven by the government KFF setup in HR_ORGANIZATION_INFORMATION, and changes to that setup directly affect the outcome of position and location updates. No direct calls should be assumed without verifying the calling package chain, and the absence of documented parameter lists in the ETRM means signatures must be confirmed against the live source before use.