Search Results update_position_info

Overview

The APPS.GHR_SF52_POS_UPDATE package is a PL/SQL API belonging to the Oracle HRMS (Human Resources Management System) schema. It is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner. The package header carries a version string (ghpauppo.pkh 115.7) that indicates it forms part of the Oracle HR product family, and the naming prefix GHR associates it with the Global Human Resources codebase.

The principal business function of this package is to update position information within Oracle EBS. It provides programmatic entry points for modifying position records and the location associated with a position, while respecting the DateTrack conventions used throughout Oracle HRMS. DateTrack allows records to carry effective dates so that historical, current, and future changes coexist; the package exposes effective dates and a DateTrack mode parameter through its record structures to participate correctly in that model. The presence of pos_return_update_mode, which returns an update mode as a string, indicates the package is designed to determine the correct DateTrack operation before an update is attempted.

Key Procedures and Functions

Three documented program units are declared in the package specification:

• UPDATE_POSITION_INFO — The primary procedure for applying changes to a position. It accepts a single position_data_rec_type record, a composite structure that bundles the position identifier, organization, job, agency code subelement, location, effective dates, and DateTrack mode. This procedure carries out the core update logic for position attributes.
• POS_RETURN_UPDATE_MODE — A function that returns a varchar2 value representing the applicable DateTrack update mode. It is parameterised by a position identifier and an effective date, allowing callers to resolve whether a change should be inserted, corrected, updated, or treated under another DateTrack mode.
• UPDATE_POSITIONS_LOCATION — A procedure added specifically to update a position's location during the update-to-HR flow. It takes a position identifier, a location identifier, and an effective date, and applies the location change under DateTrack control.

In addition to these program units, the specification defines several type declarations used as parameters — notably position_data_rec_type, org_info_rec_type, and segment_tab_type — which structure the data exchanged with the package.

Tables Accessed

The package references the following tables through APPS synonyms:

• HR_ALL_POSITIONS_F — The core DateTrack-enabled table of positions; the primary target of update operations and the source of position and location identifiers.
• HR_ORGANIZATION_INFORMATION — Stores descriptive organization information and is represented in part by the org_info_rec_type structure.
• PER_POSITION_DEFINITIONS — Holds position definition data, including the segment1 value mapped to the agency code subelement.
• PER_SHARED_TYPES — A lookup table shared across the PER schema, typically consulted to resolve shared type values.

Usage Notes

Because the package is referenced by six other packages within the EBS schema, it is primarily an internal, reusable API invoked by other HRMS components rather than a standalone end-user interface. Typical invocation paths include HRMS forms and concurrent programs that update position details, as well as the flow that propagates position changes to HR. Custom extensions and interfaces that need to change position location or attributes under DateTrack should call pos_return_update_mode first to determine the correct mode, then pass a populated position_data_rec_type record to update_position_info, or call update_positions_location directly for location-only changes. Callers must supply valid effective dates and respect the DateTrack mode semantics of the environment (12.1.1 and 12.2.2 share the same API surface).