Search Results hr_fwn_bus




Overview
Explore in AI Chat

Overview

The APPS.HR_FWN_BUS package is a server-side PL/SQL business logic module within the Oracle E-Business Suite Human Resources (HR) product family. Its object name follows the Oracle naming convention in which "HR" denotes the Human Resources application, "FWN" identifies the specific functional module, and the "BUS" suffix designates a Business logic layer package. The package is catalogued in the ETRM metadata with a status of VALID and is owned by the APPS schema, which is the standard deployment convention for shared application code in Oracle EBS releases 12.1.1 and 12.2.2.

The package operates within a layered architecture that separates presentation, business, and data access concerns. HR_FWN_BUS sits at the business layer, sitting above the shadow table package HR_FWN_SHD and below the table-handler packages HR_FWN_INS, HR_FWN_UPD, and HR_FWN_DEL. It also shares a relationship with HR_FWT_BUS, its corresponding Business layer package for the "FWT" table family. In this capacity the package provides common validation, security context initialization, and legislation-code resolution services that the table handlers rely upon before performing DML against the underlying FWN tables.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within HR_FWN_BUS. Their names and documented purposes are as follows:

  • SET_SECURITY_GROUP_ID — Establishes the Oracle HR security group context by setting the session-level security group identifier. This is a prerequisite in a multi-organization or multi-business-group environment, because HR data access must be filtered by the active security group before any query or DML proceeds.
  • RETURN_LEGISLATION_CODE — A function that returns the legislation code applicable to the current context. Legislation code drives the country-specific rules attached to HR records, so this routine resolves the correct legislative context for downstream validation and processing.
  • INSERT_VALIDATE — Performs the validation logic required before a new row is inserted into the FWN table family. It is called by the insert table handler to enforce business rules and data integrity prior to the actual insert.
  • UPDATE_VALIDATE — Performs the validation logic required before an existing row in the FWN table family is modified. It is invoked by the update table handler.
  • DELETE_VALIDATE — Performs the validation logic required before an existing row is removed. It is invoked by the delete table handler.

The consistent naming of the three validate routines reflects a standard Oracle EBS table-handler pattern in which the BUS package centralizes all pre-DML business rule checks, keeping the INS, UPD, and DEL packages focused on the mechanics of the database operation.

Tables Accessed

According to the documented dependency metadata, HR_FWN_BUS references two tables through APPS synonyms: FND_APPLICATION and FND_FORM. FND_APPLICATION is the Oracle Application Object Library table that defines registered applications in the EBS instance, and FND_FORM is the Application Object Library table that defines form registrations. Access to these tables supports the package's security and context initialization routines, particularly SET_SECURITY_GROUP_ID, which is the mechanism through which the package determines and applies the appropriate security context. The package additionally depends on the HR_FWN_SHD shadow table package for access to the FWN base data.

Usage Notes

HR_FWN_BUS is not intended for direct invocation by end users. It is called programmatically by the table-handler packages that depend on it. The documented dependency list shows HR_FWN_BUS being referenced by its own package body as well as by HR_FWN_DEL, HR_FWN_INS, and HR_FWN_UPD — the delete, insert, and update handlers for the FWN table family. HR_FWT_BUS also references it, indicating shared validation and context logic across the two functional families.

Typical invocation paths include Oracle Forms-based transactions and any concurrent or custom code that routes writes through the standard table-handler API. The virtual-column or form-based maintenance of FWN records depends on SET_SECURITY_GROUP_ID being invoked first so that subsequent validation routines evaluate data within the correct security group and legislation context. Customizations that bypass these handlers and write directly to the FWN tables risk skipping the INSERT_VALIDATE, UPDATE_VALIDATE, and DELETE_VALIDATE checks and should therefore be avoided. Because the package resides in the APPS schema, it is accessible to any other APPS-owned code in the instance, and its procedures should only be referenced through the documented APIs rather than modified in place.