Search Results ben_org_delete




Overview
Explore in AI Chat

Overview

APPS.BEN_ORG_DELETE is an Oracle E-Business Suite PL/SQL package that belongs to the Oracle Advanced Benefits (OAB) module within the Oracle Human Resources (HRMS) product family. Its principal responsibility is to support the deletion of benefits configuration data, specifically organizational units and benefit groups, while enforcing the referential integrity rules that govern these records. The package is classified in the ETRM as an "OTHER" API, meaning it is not published as a full public business API but is nonetheless invoked internally by Oracle-delivered components.

The central purpose of the package is to coordinate the safe removal of data that sits below a benefit group (BG) or below an organization in the benefits hierarchy. Because benefit groups and organizations are heavily referenced by plan, program, and eligibility records, removal cannot be performed as a simple DML operation. The package provides dedicated procedures that manage the deletion in a controlled fashion. The package header carries the source control identifier bebgdchk.pkh, indicating a long-standing origin within the benefits development line and consistent inclusion through 12.1.1 and 12.2.2.

Key Procedures and Functions

  • PERFORM_RI_CHECK — Accepts a benefit group identifier and performs a referential integrity check against that benefit group. Its role is to determine whether dependent records exist that would block or require special handling before deletion proceeds. It acts as a validation gate that protects data consistency.
  • DELETE_BELOW_BG — Accepts a benefit group identifier and deletes the records that reside below that benefit group in the benefits hierarchy. This is the procedure directly relevant to the user's search term. It is intended to cascade removal of dependent configuration data associated with the specified benefit group.
  • DELETE_BELOW_ORG — Accepts an organization identifier and deletes records positioned below that organization. It parallels the benefit-group variant but operates against the organizational dimension of the benefits structure.

All three procedures take a single numeric identifier argument as the anchor for their operations. No return values are documented.

Tables Accessed

The ETRM metadata records fifteen underlying tables referenced by this package through APPS synonyms. These fall primarily into three families:

These references confirm that the package touches a wide cross-section of benefits configuration data when cascading a deletion, reflecting the interconnected nature of the OAB data model.

Usage Notes

BEN_ORG_DELETE is not a standalone user-facing utility. It is invoked by Oracle-delivered forms and concurrent processes that manage benefit group and organization maintenance. The ETRM metadata states that the package is referenced by zero other packages, indicating it functions as a leaf-level helper rather than a shared dependency.

Typical invocation occurs when an administrator deletes or reorganizes a benefit group or organization within the Benefits configuration forms, or through seeded concurrent programs that perform cleanup of benefits setup data. The RI check is generally executed first to establish that deletion is permissible, followed by the appropriate delete_below procedure to remove dependent rows. Custom code should exercise caution when calling these procedures directly, because the cascade affects effective-dated rate, factor, and eligibility records. In 12.1.1 and 12.2.2 the package behavior is consistent, and the existing references to BEN_ACTN_TYP imply that deletions may generate or depend on associated action-type audit trail entries.