Search Results ins_lck




Overview
Explore in AI Chat

Overview

APPS.GHR_DUT_INS is a generated PL/SQL package body belonging to the Oracle E-Business Suite HRMS (Human Resources Management System) schema. It is one of the standard DateTrack insert handler packages produced by the Oracle Designer/Headstart table API generation utility, and its name follows the convention <table>_INS, where the underlying table is GHR_DUTY_STATIONS_F. The package encapsulates the physical insert logic required to maintain a DateTrack-enabled (datetracked) entity: Duty Stations defined within the HRMS organization and location model.

The business function of the package is to insert rows into the duty stations table while correctly deriving and defaulting the effective start and end dates and the object version number, and while maintaining the correct API DML flag used by the DateTrack framework to distinguish direct DML from API-driven DML. It enforces the integrity constraints of the underlying schema and surfaces constraint violations in a controlled manner rather than allowing raw Oracle errors to propagate. The header comment in the source identifies the package as originating from a generated .pkb file (ghdutrhi.pkb), confirming its role as a generated, non-shipped-customization API.

Key Procedures and Functions

The ETRM registry documents three callable units in the package, of which two are named procedures and the third corresponds to the internal DML helper referenced in the source comments.

  • INSERT_DML — The main insert handler entry point. It controls the actual DateTrack insert logic, obtaining the object version number, setting the effective start and end dates from the corresponding validation dates, setting the object version number on the row being inserted, and toggling the g_api_dml status immediately before performing the DML. It also traps constraint violations and re-raises other errors. The procedure is documented as an internal private routine that must be called from the insert_dml and pre_update logic paths with all mandatory arguments supplied, using a PL/SQL record structure as its in parameter.
  • INS — The public insert procedure exposed by the package's specification. It is the routine intended for external callers wishing to create a new duty station record through the supported API rather than by direct SQL. It delegates the row-level work to the internal DML logic described above.
  • dt_insert_dml — The internal private procedure flagged in the source header as the core DateTrack insert routine, structured around the six documented steps: version number acquisition, effective date assignment, API DML status management, row insertion, constraint violation trapping, and error propagation. It is referenced from INSERT_DML and, logic permitting, from the pre-update path.

Tables Accessed

The package operates against three documented objects, resolved through APPS synonyms:

  • GHR_DUTY_STATIONS_F — The date-effective (datetracked) base table holding duty station definitions, including their effective start and end dates and object version number. This is the primary target of the insert operations.
  • GHR_DUTY_STATIONS_F_S — The corresponding DateTrack shadow table, used by the DateTrack framework to maintain the historical/audit view of row changes. The package's insert logic participates in keeping this shadow structure consistent with the base table.
  • DUAL — Used for single-row scalar evaluations, typically to obtain the next object version number or to evaluate sysdate-based defaults before the row is written.

Usage Notes

GHR_DUT_INS is normally invoked indirectly rather than by end users. In a standard Oracle EBS 12.1.1 or 12.2.2 environment, it is called from the HRMS forms and from other API packages that create or maintain duty station data; the ETRM registry records that the package is referenced by two other packages, confirming this dependency. Customizations and extensions should call the public INS procedure (or the equivalent table handler API) rather than performing direct INSERT statements against GHR_DUTY_STATIONS_F, so that DateTrack validation dates, object version numbers, and the shadow table records are maintained correctly.

The identifier “ins_lck” that prompted this lookup does not appear as a documented unit within this package; it most likely refers to a similarly named locking or insert-lock construct in a related table handler, and should be confirmed against the specific object where it was encountered. Because the package is generated code, it should not be modified in place; any behavioural change must be made through the supported table handler API or an appropriately designed extension.