Results for “ghr_dut_shd”

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

Overview

GHR_DUT_SHD is the shared (SHD) utility package body in the Oracle E-Business Suite APPS schema that supports the Duty Stations business entity used by Oracle Human Resources and Oracle Public Sector/Defense deployments. The Duty Stations feature allows an enterprise to define physical or administrative duty locations to which employees and assignments can be associated. The GHR_DUT_SHD package encapsulates the row-handling logic invoked by the Duty Stations maintenance form (typically the GHR_DUTY_STATIONS_F block) so that inserts, updates, deletes, and effective-dating operations respect the same validation, locking, and DateTrack rules applied elsewhere in the HR schema. In Oracle EBS 12.1.1 and 12.2.2 the object is documented as VALID and classified as an OTHER API, meaning it is not a public, supported interface but rather an internal, form-facing library. It is explicitly documented as not referenced by any other database object; instead, it depends on the HR foundation packages DT_API, HR_API, and HR_UTILITY, which supply DateTrack and business-group context handling.

Key Procedures and Functions

• RETURN_API_DML_STATUS — Returns the DML status of the API so that the calling form or routine can determine whether the last operation succeeded, failed, or left pending changes.
• CONSTRAINT_ERROR — Handles or reports constraint violations raised during Duty Stations DML, mapping Oracle errors to user-facing messages.
• API_UPDATING — Indicates whether an update is currently being performed by the API, allowing callers to suppress or alter validation during the update cycle.
• FIND_DT_DEL_MODES — Determines the applicable DateTrack delete modes for the Duty Stations record.
• FIND_DT_UPD_MODES — Determines the applicable DateTrack update modes, including correction and update modes.
• UPD_EFFECTIVE_END_DATE — Adjusts the effective end date on the Duty Stations row, supporting DateTrack's date-splitting behaviour.
• LCK — Locks the Duty Stations row prior to modification, preventing concurrent updates.
• CONVERT_ARGS — Normalizes or converts incoming arguments before they are passed to the underlying HR API calls.

These routines mirror the signature conventions of the standard HR DateTrack DML stack and are intended to be called in sequence by the Duty Stations form rather than individually by custom code.

Tables Accessed

The package operates against GHR_DUTY_STATIONS_F, the DateTrack-enabled base table that stores Duty Stations definitions, effective dates, and business-group ownership. Writing to this table is the core purpose of the package. It also queries the data dictionary view ALL_CONSTRAINTS to resolve constraint definitions, which supports the CONSTRAINT_ERROR routine's ability to identify and interpret the violated constraint and produce a meaningful message. The HR foundation packages DT_API, HR_API, HR_UTILITY, and FND_MESSAGE are invoked for DateTrack processing, business-group initialization, and message lookups respectively.

Usage Notes

GHR_DUT_SHD is an internal, form-invoked package. It is normally executed from the Duty Stations maintenance form and its underlying GHR_DUTY_STATIONS_F block, not directly from concurrent programs or custom applications. Because the object is documented as not referenced by any other database object, there is no supported public API contract around it. Customizations that call it directly risk breaking on patch application, since Oracle may change internal signatures without notice. Developers requiring programmatic maintenance of Duty Stations should use the supported HR DateTrack APIs instead. Where defects are suspected, the dependency chain to DT_API, HR_API, HR_UTILITY, FND_MESSAGE, and ALL_CONSTRAINTS should be reviewed before altering the package body.