Search Results hr_fwt_del




Overview
Explore in AI Chat

Overview

APPS.HR_FWT_DEL is a PL/SQL package that belongs to the Oracle E-Business Suite Human Resources (HR) product family and resides in the APPS schema, which is the standard deployment schema for shared EBS database objects. The package name follows the naming convention of the HR "form window" utility tier: the abbreviation "FWT" refers to "Form Window" and the suffix "DEL" indicates a delete-oriented utility. In this context, HR_FWT_DEL provides the deletion logic used by the Form Window translation infrastructure, which manages the language-specific (translated) text associated with Form Windows in Oracle HRMS. The package is documented as VALID and is classified as a non-API utility object ("OTHER") in ETRM, meaning it is not intended as a public integration API but rather as an internal building block consumed by other HR dictionary and translation framework objects.

Its primary consumer is APPS.HR_FORM_WINDOWS_API, the API package responsible for maintaining Form Window definitions. HR_FWT_DEL therefore acts as a supporting utility that removes translation rows and related records when Form Window metadata is deleted or redefined.

Key Procedures and Functions

ETRM documents a single program unit within this package:

  • DEL_TL — The "TL" suffix conventionally denotes "Translation" (or "Translated Language") tables in EBS. DEL_TL is the procedure responsible for deleting the translated-language rows associated with a Form Window. It encapsulates the delete operation against the translation table so that callers—principally HR_FORM_WINDOWS_API—do not issue direct DML. The ETRM metadata does not expose the parameter list, and the exact signature should not be assumed; consult the package specification in the database for the authoritative interface.

No public functions are documented for this package. The package body may contain additional private helper routines, but only DEL_TL is recorded in the ETRM documentation.

Tables Accessed

The ETRM metadata identifies exactly one table referenced through APPS synonyms:

  • HR_FORM_WINDOWS_TL — The translated-language table storing Form Window descriptive text (such as window names and titles) in each installed language. HR_FWT_DEL reads and deletes from this table as part of the deletion routine, ensuring that translations are removed consistently when the underlying Form Window definition is deleted, thereby preventing orphaned translation rows.

The package also references SYS.STANDARD and STANDARD, which are the standard PL/SQL built-in package dependencies and do not represent application data access.

Usage Notes

HR_FWT_DEL is an internal, low-level utility rather than an end-user API. Typical invocation scenarios include:

  • Invocation through HR_FORM_WINDOWS_API — ETRM records that HR_FWT_DEL is referenced by HR_FORM_WINDOWS_API. When the Form Window API performs a delete or maintenance operation on a Form Window, it calls HR_FWT_DEL.DEL_TL to purge the corresponding translation rows as part of the same logical transaction.
  • Form-driven maintenance — The HR "Define Form Window" and related setup forms ultimately route deletion through the API layer, which in turn delegates to this package. Users never call it directly from the UI.
  • Custom code caution — Because DEL_TL is not classified as a public API, custom extensions should not invoke it directly. Customizations that must delete Form Window translations should call the supported HR_FORM_WINDOWS_API entry points so that all dependent data is handled correctly and no orphaned rows remain in HR_FORM_WINDOWS_TL.

In EBS 12.1.1 and 12.2.2 the package is shipped VALID and is compiled against the standard APPS schema synonyms. As with all HR utility packages, any change to Form Window architecture or translation tables in future patching should be validated against this package, since it depends on the structure of HR_FORM_WINDOWS_TL.