Search Results hr_fwn_del




Overview
Explore in AI Chat

Overview

APPS.HR_FWN_DEL is the delete-side processing package body within the Oracle E-Business Suite Human Resources "Form Windows" (FWN) object family. Its name follows the standard EBS row-handler naming convention for HR date-tracked entities, where the suffix _DEL denotes the procedure responsible for removing rows from the associated base table and its intersecting surrogate tables. In Oracle EBS 12.1.1 and 12.2.2, the HR schema implements the DateTrack model through a triad of handler packages: the primary CUD package (HR_FWN_BUS), the delete handler (HR_FWN_DEL), and the row-key delete handler (HR_FWN_RKD), together with the shadow table maintenance package (HR_FWN_SHD).

The business function of HR_FWN_DEL is therefore the low-level, physical deletion of form-window configuration records. These records govern how Oracle HRMS windows and forms behave, including which windows are available and how they are surfaced to end users. Because this package is classified as OTHER rather than as a public API, it is intended for internal consumption by the HR forms framework and the DateTrack engine rather than for direct invocation by customers.

Key Procedures and Functions

The documented package body exposes a single procedure, DEL.

  • DEL — Performs the actual delete operation for a form-window record. In the DateTrack architecture, this procedure is invoked by the business-layer delete handler to remove the target row from the base table and to coordinate the corresponding row operations required to keep the entity's DateTrack history consistent. It is the counterpart to the insert and update handlers found in HR_FWN_BUS.

No other procedures or functions are documented in the ETRM metadata. Parameter lists are not published in this extract and must not be assumed; the signature should be confirmed against the package specification (HR_FWN_DEL) in the target environment before any custom reuse is attempted.

Tables Accessed

The documented table dependency is HR_FORM_WINDOWS_B, accessed via its APPS synonym. The _B suffix identifies this as the base (non-translated) table holding form-window definitions. HR_FWN_DEL writes to this table by deleting rows that the caller has identified as obsolete or superseded.

The package also depends on HR_FORM_WINDOWS_B indirectly through its package-level dependencies on HR_FWN_BUS, HR_FWN_RKD, and HR_FWN_SHD, which together manage the full DateTrack lifecycle. Utility support is provided by APPS.HR_API and APPS.HR_UTILITY, and the body is compiled against SYS.STANDARD.

Usage Notes

HR_FWN_DEL is not referenced by any other database object according to the ETRM dependency report, and it is not referenced by any documented concurrent program or form in the metadata provided. Its practical invocation path is therefore indirect: application logic calls HR_FWN_BUS, which in turn delegates physical removal to HR_FWN_DEL, with row-key and shadow-table maintenance handled alongside it.

  • Do not call HR_FWN_DEL directly from custom code. Direct invocation bypasses the DateTrack bookkeeping performed by the business layer and risks orphaned or inconsistent history rows.
  • Use the supported HRMS APIs or the standard HR forms when programmatically manipulating form-window configuration.
  • Because the package is marked VALID and is unpublished as an API, it should be treated as internal and subject to change across EBS patches and upgrades.

Personnel reviewing this object should confirm the current signature and any overloads against the live data dictionary, since the ETRM excerpt documents only the object's existence, its single procedure, and its declarative dependencies.