Search Results hr_ort_ins




Overview
Explore in AI Chat

Overview

APPS.HR_ORT_INS is a private Oracle E-Business Suite PL/SQL package that belongs to the HR organization and translation infrastructure. Its header signature (hrortrhi.pkh) confirms an AutoPatch-managed, release 12.x source file dated 2005, consistent with the 12.1.1 and 12.2.2 code lines. The package implements the insertion half of the translated-table maintenance pattern used by Oracle's Organization Developer (ORG) APIs. Translated entities in EBS store the language-independent surrogate key in a base table and the language-specific descriptive columns in a corresponding _TL table. HR_ORT_INS encapsulates the low-level DML required to write those _TL rows without exposing the mechanics to callers. The API classification recorded in ETRM is OTHER, and the package is flagged internal development use only, meaning it is not intended as a public extension point. The search term "nl office h" reflects a user tracing the Dutch (NL) language rows for organization office records, whose translated text is populated by this package.

Key Procedures and Functions

ETRM documents two procedures for this object:

  • SET_BASE_KEY_VALUE — Registers the next primary-key value obtained from the database sequence so the surrogate identifier can be reused across subsequent inserts. Oracle documents this as a prerequisite step: a unique primary key must exist before any translated row can be written. The procedure takes the organization identifier as its base key parameter and caches it for the session.
  • INS_TL — The main interface for inserting rows into the translated table. It inserts a row into the _TL table for the base language and every installed language. Per the header comments, the caller must have already assigned a unique surrogate key and successfully inserted the row into the non-translated table. The language code parameter must be set to the base language or any installed language. On success a fully validated row is created for each installed language, and none of the rows are committed to the database — commit control remains with the calling transaction.

Tables Accessed

  • HR_ALL_ORGANIZATION_UNITS_TL — the translated table for organization units. HR_ORT_INS writes the language-specific name and description rows here, keyed by the organization identifier and language code.
  • FND_LANGUAGES — the repository of installed languages. The package reads it to determine the complete set of languages for which a translated row must be generated, which explains why every installed language receives a record rather than only the session language.

Usage Notes

HR_ORT_INS is an internal implementation package sitting beneath the HR organization entity handlers; it is not normally called directly by end users. It is invoked indirectly by the organization creation and update APIs and is referenced by one other package in the ETRM catalog, which orchestrates the base-table insert followed by the translated-table insert. Typical invocation paths include Oracle Forms handlers for the Organization window and any concurrent program or custom PL/SQL that creates organization units through the supported APIs. Because INS_TL never issues a commit, any custom code that calls it must manage transaction boundaries explicitly and must ensure SET_BASE_KEY_VALUE has been called beforehand. The package is not supported as a public API, and direct calls should be avoided in favour of the documented Organization API surface.