Search Results hr_fwn_upd




Overview
Explore in AI Chat

Overview

HR_FWN_UPD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the maintenance of form window definitions used by Oracle Human Resources. In Oracle EBS 12.1.1 and 12.2.2 the package functions as a low-level update utility for the HR form window infrastructure, which governs how the Forms-based HR windows are registered, referenced, and maintained within the application. The object is documented in ETRM with a status of VALID and an API classification of OTHER, indicating that it is an internal supporting package rather than a formally published business API. Its naming convention, with the UPD suffix, reflects its role as a dedicated update handler, separating update logic from the broader window management responsibilities handled by related packages such as HR_FORM_WINDOWS_API.

The package depends upon APPS.HR_API, APPS.HR_FWN_SHD, and the SYS.STANDARD package. It is referenced by APPS.HR_FORM_WINDOWS_API and recursively by itself, confirming that it occupies a supporting position in the HR form window dependency chain rather than a top-level entry point.

Key Procedures and Functions

ETRM documents a single procedure for this package:

  • UPD — The sole documented procedure, responsible for performing the update operation against the HR form window definition data. Consistent with the package's name and classification, this procedure encapsulates the write path for form window records, allowing dependent packages to modify window definitions without embedding the update logic directly. The ETRM metadata does not publish a parameter list, and no parameter details should be assumed beyond the procedure's stated update purpose.

No additional functions or procedures are documented in the ETRM extract for this object, although the package body may contain private helper routines not exposed in the metadata.

Tables Accessed

The documented table access for HR_FWN_UPD is through the APPS synonym HR_FORM_WINDOWS_B, the base table that stores form window definitions in Oracle HRMS. The package reads and writes rows in this table as part of the update operation performed by the UPD procedure. Because the table is the base ("_B") table in a typical Oracle EBS base-and-translation table pair, the update routine is responsible only for the language-independent window definition; any corresponding translation rows are handled elsewhere in the form window infrastructure.

The package also references HR_API, which supplies HRMS API utility routines and error handling conventions, and HR_FWN_SHD, a shadow package that supports the audit or mirrored processing associated with window definitions. These dependencies indicate that updates performed through this package observe the standard HRMS API behavior, including validation and error propagation.

Usage Notes

HR_FWN_UPD is not intended for direct invocation from concurrent programs or end-user interfaces. It is an internal package invoked by APPS.HR_FORM_WINDOWS_API, which acts as the public entry point for form window maintenance operations. Customizations and extensions that need to modify HR form window definitions should call HR_FORM_WINDOWS_API rather than HR_FWN_UPD directly, since the higher-level API applies the required validation and orchestration that this package does not perform on its own.

Because the package is documented at the OTHER classification and exposes only a single update procedure, it is best regarded as an implementation detail of the HR form window maintenance subsystem. Oracle EBS 12.1.1 and 12.2.2 share the same APPS-owned object with matching status, and no version-specific behavioral differences are indicated in the ETRM metadata. The package is proprietary Oracle code and should not be altered; any functional change must be implemented through supported extension mechanisms.