Search Results hr_fwn_shd




Overview
Explore in AI Chat

Overview

APPS.HR_FWN_SHD is a shadow (SHD suffix) package body in the Oracle E-Business Suite Human Resources (HR) module. The "_SHD" naming convention in EBS designates a shadow package that mirrors a corresponding primary API package, providing a stable, backward-compatible entry point that delegates work to the underlying HR API layer. In this case, HR_FWN_SHD supports the HR Form Windows functionality, an internal HR construct used to control which application windows and form-level navigation elements are exposed to a user based on their security profile and configuration.

The package is documented as OTHER in the ETRM classification, indicating it is a supporting utility rather than a public, externalized business API. Its primary role is to encapsulate validation, concurrency locking, and message-handling logic required when form window definitions are queried or maintained by HR forms. In the Oracle 12.1.1 and 12.2.2 releases, this package remains VALID in the APPS schema and is not referenced by any other database object, meaning it is invoked directly rather than through dependency chains.

Key Procedures and Functions

Four documented program units are exposed by HR_FWN_SHD:

  • CONSTRAINT_ERROR — Raises or reports a constraint violation error, typically when a data integrity rule on form window configuration is breached. It standardizes the error message surfaced to the calling form or API.
  • API_UPDATING — Signals whether an API layer is currently performing an update, guarding recursive or conflicting updates to the form window definition and preventing interference with in-flight transactions.
  • LCK — Performs the locking operation on the underlying form window record, ensuring serialized access when a form window definition is modified.
  • CONVERT_ARGS — Translates or normalizes incoming argument values into the internal representation expected by the HR form window logic, supporting flexible call signatures.

These units collectively represent the validation, locking, and argument-handling scaffolding around the HR form window maintenance flow. No parameter lists are documented in the ETRM metadata, and none are asserted here.

Tables Accessed

The package operates against two documented tables through APPS synonyms:

  • HR_FORM_WINDOWS_B — The base table storing HR form window definitions. HR_FWN_SHD reads and locks rows here during update operations, and it is the primary business object of the package.
  • ALL_CONSTRAINTS — The data dictionary view used to verify constraint metadata, supporting the CONSTRAINT_ERROR logic by identifying the constraint that a violation has breached.

Usage Notes

HR_FWN_SHD is an internal, form-driven package. It is invoked from the HR Forms framework when form window definitions are loaded or maintained, rather than from concurrent programs or customer extensions. The package depends on HR_API, HR_UTILITY, HR_FORM_WINDOWS_B, and FND_MESSAGE, relying on FND_MESSAGE for localized error text and HR_API/HR_UTILITY for shared HR infrastructure routines.

Because it is not referenced by any other database object but is itself referenced by five other packages, it should be treated as a private implementation detail of the HR form window subsystem. Developers should avoid calling it directly; supported integration points are the public HR APIs and the HR Forms user interface. Any modification to HR_FORM_WINDOWS_B outside the package risks bypassing the locking and validation guarantees this body provides.