Search Results hr_fwt_shd




Overview
Explore in AI Chat

Overview

HR_FWT_SHD is an Oracle Application Object Library package owned by the APPS schema and classified under the OTHER API category. Its name follows the Oracle EBS convention for shadow (or seeding) logic associated with the HR_FWT (Form Window Translation) family of packages. In Oracle EBS 12.1.1 and 12.2.2 the HR_FWT package group supports the maintenance of translatable form window metadata held in HR_FORM_WINDOWS_B and HR_FORM_WINDOWS_TL. HR_FWT_SHD encapsulates the internal logic used to create, update, delete, and validate those translation rows, and it acts as the low-level engine invoked by the public-facing HR_FWT_BUS package. Because it is not intended for direct customer invocation, it does not carry a formal public API classification and its documented interface is largely procedural utility in nature.

Key Procedures and Functions

The ETRM metadata documents five callable units within the package:

  • CONSTRAINT_ERROR — a utility that detects and reports constraint-related failures raised while manipulating form window rows, allowing the calling layer to translate low-level integrity errors into meaningful messages.
  • API_UPDATING — a status flag routine used to signal whether the package is currently processing an API-driven update, preventing re-entrant or conflicting modifications.
  • LCK — the locking routine, used to serialize concurrent access to the underlying HR_FORM_WINDOWS rows before an update or delete proceeds.
  • ADD_LANGUAGE — the translation routine that populates the TL table with the appropriate language rows, ensuring all installed languages are represented for a form window definition.
  • CONVERT_ARGS — an argument-normalization helper that maps the incoming parameters from the business wrapper into the internal representation expected by the shadow procedures.

Individual parameter lists are not published in the ETRM record and are intentionally not restated here.

Tables Accessed

HR_FWT_SHD references two application tables through APPS synonyms, in addition to the data dictionary view ALL_CONSTRAINTS:

  • HR_FORM_WINDOWS_B — the base (non-translatable) table holding form window definitions; the package contends with this table for insert, update, and delete operations and checks its constraints.
  • HR_FORM_WINDOWS_TL — the translation table; ADD_LANGUAGE and the related shadow logic write language-specific rows here.
  • ALL_CONSTRAINTS — queried to validate constraint definitions before DML is committed.

Usage Notes

HR_FWT_SHD is not designed for direct invocation by end users, forms, or concurrent programs. Its documented dependency graph shows that it is referenced by HR_FWT_BUS, HR_FWT_DEL, HR_FWT_INS, and HR_FWT_UPD — the insertion, update, and deletion layers that together expose the supported operations on HR_FORM_WINDOWS. Custom code should therefore call HR_FWT_BUS rather than HR_FWT_SHD. The package is exercised during performance/creation-time seeding of form window data, during concurrent processing that maintains translations, and whenever the form window definition is modified through the supported maintenance path. Because it manipulates shared translation rows, the LCK routine exists to guard against concurrent modification, and the API_UPDATING and CONSTRAINT_ERROR helpers exist to keep error handling consistent across the HR_FWT family.