Search Results hr_fwt_bus




Overview
Explore in AI Chat

Overview

The APPS.HR_FWT_BUS package is a business-layer (BUS) PL/SQL unit within the Oracle E-Business Suite Human Resources (HR) module. It supports the FWT (Federal/State withholding tax) feature set, which manages tax withholding information associated with payroll processing. The package encapsulates the business rules that govern the validation and maintenance of withholding tax records, acting as an intermediary between the underlying database tables (accessed through the HR_FWT_SHD shadow table and related DML packages) and the calling forms, concurrent programs, or custom code.

As reflected in the ETRM metadata, the package is classified as OTHER rather than as a public API, indicating that it is primarily an internal business-layer component intended for consumption by the HR forms and other HR packages rather than as a formally published integration interface. The package holds a VALID status and resides in the APPS schema.

Key Procedures and Functions

The documented unit exposes five procedures/functions:

  • SET_SECURITY_GROUP_ID — Establishes the security group context for the current session, ensuring that subsequent operations are scoped correctly for multi-organization or security-restricted access.
  • RETURN_LEGISLATION_CODE — Retrieves the applicable legislation code, which governs the tax rules and validation logic applied to FWT records for a given business group or jurisdiction.
  • INSERT_VALIDATE — Performs the business validations required before a new FWT record can be inserted, ensuring data integrity prior to the insert operation.
  • UPDATE_VALIDATE — Executes validation logic for modifications to existing FWT records prior to update.
  • DELETE_VALIDATE — Applies validation rules to determine whether a FWT record may be deleted, thereby protecting referential and business integrity.

Tables Accessed

According to the documented table references (via APPS synonyms), the package accesses FND_LANGUAGES. This table is read to resolve language-dependent values, typically supporting the legislation code retrieval and any validation messages returned to the user. The dependency metadata further indicates that HR_FWT_BUS references HR_FWT_SHD and that it is referenced by companion packages HR_FWT_DEL, HR_FWT_INS, and HR_FWT_UPD, as well as recursively by itself. These companion packages carry out the actual insert, update, and delete DML against the FWT tables, with HR_FWT_BUS providing the shared validation and context-setting logic.

Usage Notes

HR_FWT_BUS is typically invoked indirectly. The HR forms that maintain withholding tax information call the DML wrapper packages (HR_FWT_INS, HR_FWT_UPD, HR_FWT_DEL), which in turn invoke the corresponding *_VALIDATE routines in HR_FWT_BUS before committing changes. The SET_SECURITY_GROUP_ID routine is normally called at the start of a session or transaction to set the correct security context. Because the package is not classified as a public API, direct calls from custom code should be undertaken cautiously; customers should prefer documented HR public APIs, and use HR_FWT_BUS only where no supported alternative exists.