Search Results hr_form_windows_b_s




Overview
Explore in AI Chat

Overview

HR_FORM_WINDOWS_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the data model behind the HR Form Windows (form customization) framework. Its business purpose is to provide controlled, programmatic access to the HR_FORM_WINDOWS_B base table, the HR_FORM_WINDOWS_TL translation table, and the HR_FORM_WINDOWS_B_S sequence, thereby isolating callers from the physical structure of the underlying tables. The package implements a standard EBS DML-plus-translation pattern: insert, lock, update, and delete operations on the base row are paired with language-specific procedures that populate or modify the corresponding translation rows. The body is documented in ETRM as VALID, with an API classification of OTHER. It exposes eight procedures and is not referenced by any other database object, confirming that it is a consumer API intended to be called directly from forms, concurrent programs, or custom code rather than being wrapped by higher-level packages.

Key Procedures and Functions

  • OWNER_TO_WHO — Resolves the "WHO" audit columns (typically created_by, creation_date, last_updated_by, last_update_date) for the owning row, ensuring that audit information is populated consistently when records are created or changed.
  • INSERT_ROW — Inserts a new base-table row into HR_FORM_WINDOWS_B, deriving the primary key from HR_FORM_WINDOWS_B_S and stamping the standard audit columns.
  • LOCK_ROW — Obtains a row-level lock on the targeted base-table row so that concurrent modifications cannot corrupt the record while the caller edits it.
  • UPDATE_ROW — Updates the mutable columns of an existing HR_FORM_WINDOWS_B row and refreshes the WHO audit columns.
  • DELETE_ROW — Removes the base-table row, and by extension its associated translation content, from the HR Form Windows data model.
  • ADD_LANGUAGE — Creates a translation row in HR_FORM_WINDOWS_TL for an additional language so the window definition can be presented in that language.
  • TRANSLATE_ROW — Updates the translatable attributes of an existing HR_FORM_WINDOWS_TL row for a given language.
  • LOAD_ROW — Inserts or updates a complete window definition, including its translated text, in a single call, supporting seed data and installation or upgrade loading.

Tables Accessed

The package reads and writes HR_FORM_WINDOWS_B, the base table holding the language-independent definition of each form window, and HR_FORM_WINDOWS_TL, the translation table holding language-specific display text. The sequence HR_FORM_WINDOWS_B_S supplies primary key values for new base rows, which is why HR_FORM_WINDOWS_B_S appears in the dependency list and explains the common search string "hr_form_windows_b_s." FND_APPLICATION, FND_FORM, and FND_LANGUAGES support the standard EBS language and application/form registration model. DUAL is used for single-row expression evaluation, and APP_EXCEPTION, FND_MESSAGE, and PER_RIC_PKG are referenced for error recording and message handling. No other database object references this package.

Usage Notes

HR_FORM_WINDOWS_PKG is typically invoked by the HR Form Windows maintenance form and by concurrent programs or seed-data loaders that register and translate form window definitions. Because it contains no dependent packages that wrap it, custom code should call these procedures directly rather than attempting to manipulate the base and translation tables. Callers should supply a valid primary key for update, lock, translate, and delete operations, and should invoke LOCK_ROW before UPDATE_ROW or DELETE_ROW in concurrent or multi-user scenarios. ADD_LANGUAGE and TRANSLATE_ROW must be called separately from the base-row insert whenever translated content is required. The behavior is consistent across EBS 12.1.1 and 12.2.2, since the object is documented as VALID in the 12.2.2 ETRM and the underlying HR Form Windows data model is unchanged between the two releases.