Search Results ben_sva_del




Overview
Explore in AI Chat

Overview

BEN_SVA_DEL is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It forms part of the Oracle Advanced Benefits (OLAM) module and is responsible for the logical and physical deletion of Service Area (SVA) records maintained within that module. Service Areas are used within Benefits configuration to group geographic or organizational criteria against which eligibility and plan participation rules are evaluated. The package provides the deletion primitives invoked when a Service Area definition is removed from the system, either through the standard Benefits setup user interface or through programmatic maintenance routines. Its documented status is VALID, and it is classified under the ETRM API classification "OTHER," indicating that it is an internal supporting package rather than a public or customer-facing API.

Key Procedures and Functions

The ETRM metadata documents three program units within this package body. Each serves a distinct role in the deletion workflow:

  • DEL — The principal deletion entry point. It orchestrates the removal process for a Service Area record, coordinating the business logic required before and after the underlying data manipulation occurs. As the named top-level routine, it is typically the procedure called by dependent packages and by the Benefits setup layer when a Service Area must be removed.
  • DELETE_DML — The data manipulation routine that performs the actual delete against the Service Area entity. It isolates the DML operation from the surrounding business logic, which allows the orchestration logic in DEL to remain independent of the physical delete mechanics.
  • The package also includes an internal deletion construct (referenced in the dependency listing as BEN_SVA_DEL) that supports the row-level removal processing performed on behalf of the caller.

The parameter lists for these procedures are not documented in the ETRM extract and are therefore not reproduced here.

Tables Accessed

The documented table accessed by this package is BEN_SVC_AREA_F, the Service Area base table in the Benefits schema, reached through an APPS synonym. This is the primary entity acted upon by the deletion routines: DEL and DELETE_DML exist to remove rows from this table (or to mark them for deletion) in accordance with the object's deletion semantics. No other application tables are documented as direct references.

Usage Notes

BEN_SVA_DEL is invoked indirectly rather than through direct customer calls. It is referenced by two other database objects and does not itself reference any package that references it in turn, placing it near the leaf of the Benefits Service Area call hierarchy. Its dependencies include BEN_SVA_BUS (business logic), BEN_SVA_RKD and BEN_SVA_SHD (row-key and shadow/audit handling utilities) plus the generic HR_API and HR_UTILITY packages. This dependency pattern indicates that deletion calls flow through BEN_SVA_BUS, which delegates to BEN_SVA_DEL, and that row-key and shadow processing is applied to preserve referential integrity and audit history. In practice the package is exercised when a functional administrator deletes a Service Area through the Benefits configuration forms, or when a concurrent process or extension script needs to remove Service Area definitions as part of data maintenance. Customers should avoid calling it directly; use the supported Benefits business APIs instead.