Search Results ghr_dut_ins




Overview
Explore in AI Chat

Overview

GHR_DUT_INS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Oracle HRMS (Human Resources Management System) family of APIs, specifically the module concerned with Duty Stations — the locations or organizational units to which employees are assigned in a given enterprise or government configuration. In releases 12.1.1 and 12.2.2 the object retains a VALID status and is documented in the ETRM repository with an API classification of OTHER, indicating that it is an internal supporting package rather than a formally published public API.

The package exists to encapsulate the low-level insert logic for duty station records. Rather than exposing insert operations directly through the user-facing Duty Station API, Oracle separates the raw DML handling into GHR_DUT_INS, allowing the higher-level packages to delegate the mechanics of row creation. This separation mirrors the common EBS design pattern in which a "DML" layer handles direct table manipulation while a "business" layer enforces validation rules, date-effectivity logic, and multi-organization access controls.

Key Procedures and Functions

The ETRM metadata documents three procedures and functions within GHR_DUT_INS. Only two are explicitly named:

  • INSERT_DML — The core insert routine. It performs the direct Data Manipulation Language operation against the duty station tables, populating the base and translated rows required for a new duty station definition. It is the implementation layer that the surrounding public API calls after all business validations have passed.
  • INS — The insert entry point exposed to dependent packages. It likely wraps INSERT_DML, applying the calling context, such as the session's business group, date tracking mode, and who-column values, before invoking the DML routine. It serves as the invocation surface used by GHR_DUTY_STATION_API, GHR_DUT_UPD, and GHR_DUT_INS itself.

The third documented procedure or function is not individually named in the available metadata; it should be treated as an internal helper supporting the insert flow. Parameter lists are not reproduced here, and callers should reference the package specification in the database for exact signatures.

Tables Accessed

GHR_DUT_INS references the following tables through APPS synonyms:

  • GHR_DUTY_STATIONS_F — The base (date-tracked, non-translated) table holding duty station definitions, including effective dates, business group, and location attributes. This is the principal target of the insert routines.
  • GHR_DUTY_STATIONS_F_S — The corresponding translated or "_S" shadow table, generally used to hold language-specific descriptive information. Inserts to the base table are typically accompanied by inserts here.
  • DUAL — The standard Oracle single-row utility table, used for expression evaluation, sequence retrieval, or conditional checks within the PL/SQL logic.

In addition, the package depends on GHR_DUT_SHD, a shadow or history table referenced in the dependency listing, which supports the date-tracked auditing behavior characteristic of HRMS datetrack-enabled entities.

Usage Notes

GHR_DUT_INS is not intended for direct invocation by end users. It is referenced by GHR_DUTY_STATION_API, which is the preferred public entry point for creating duty stations, and by GHR_DUT_UPD as part of a shared insert/update pattern. Custom code should always call the published API rather than GHR_DUT_INS directly, because the wrapper packages enforce validation, security, and date-effectivity rules that the internal insert layer assumes have already been applied.

Typical invocation occurs during data loading, setups, and integrations — for example, when a concurrent program or an external interface loads duty station data, or when a form performs a create operation that routes through the API layer. In Oracle EBS 12.1.1 and 12.2.2 the package behaves consistently, and its VALID status confirms it remains current and supported in both releases.