Search Results hr_fwn_ins




Overview
Explore in AI Chat

Overview

The APPS.HR_FWN_INS package is a database-tier component within the Oracle E-Business Suite Human Resources (HR) module, operating in the APPS schema. Its name and associated objects indicate that it is responsible for insert (INS) processing against the HR_FORM_WINDOWS entity, which stores the configuration of "form windows" — the windows, tabs, and task-flow groupings presented to users in the Oracle HRMS forms interface. Form windows are the configurable containers that determine which windows appear in the Personal Information, Assignment, and similar self-service and professional-user forms.

In ETRM terms the package is classified as OTHER, meaning it is not a formally documented public API with a fixed interface contract, but an internal worker package invoked by other application logic. Its documented status is VALID in the APPS schema. It derives its insert behavior by delegating to the shadow table HR_FWN_SHD, the shadow entity associated with the HR_FORM_WINDOWS_B base table, which is the standard Oracle HRMS mechanism for capturing audit/versioning information when rows are created.

Key Procedures and Functions

ETRM documents a single callable program unit within this package, named INS. As the name implies, its purpose is to perform the insert of a new form-window definition row. In the typical HRMS pattern, such a worker procedure accepts the descriptive and keyed attributes of the record, writes the row to the base table (HR_FORM_WINDOWS_B), and then invokes the shadow-table routine (HR_FWN_SHD) so that the corresponding shadow record is written with the correct WHO columns and date-tracked (DATETRACK) information.

The ETRM metadata does not publish a parameter list for INS; the procedure should therefore be treated as an internal implementation detail rather than a stable callable interface. No other procedures or functions are documented for this package.

Tables Accessed

Two database tables are documented as referenced through APPS synonyms:

  • HR_FORM_WINDOWS_B — the base (non-translated) table holding form-window definitions. The INS procedure inserts new rows here.
  • HR_FORM_WINDOWS_B_S — the shadow table linked to the base table. It is written by the shadow-handling package HR_FWN_SHD to preserve historical versions and audit context for each inserted row.

Both are standard Oracle HRMS tables. In 12.1.1 and 12.2.2 the _B / _B_S pair follows the DateTrack convention: the base table stores the current effective definition, while the shadow table stores the lineage of changes. The package neither reads nor writes any other application table, as far as the documented metadata shows.

Usage Notes

HR_FWN_INS is not intended for direct invocation by end users or by ordinary custom code. The ETRM dependency list shows it is referenced by HR_FORM_WINDOWS_API, the public API for maintaining form-window definitions, and by itself (internal recursion or overload reference). Consequently the normal call path is: a form or concurrent program calls HR_FORM_WINDOWS_API, which in turn calls HR_FWN_INS.INS to persist the new definition. This layering means that upgrading or patching the HR forms component can change HR_FWN_INS without notice, so customizations should target HR_FORM_WINDOWS_API rather than this package.

Because the object is owner APPS and status VALID, it is present in supported 12.1.1 and 12.2.2 installations and is invoked during setup or configuration when new form windows are defined through the standard HRMS windows UI. Any direct call from custom code carries a high risk of bypassing validation, DateTrack, and audit logic, and is not recommended.