Search Results ben_svc_area_f_s

Overview

BEN_SVA_INS is an Oracle EBS Advanced Benefits (BEN) package body owned by the APPS schema. In the ETRM object classification, it is tagged as OTHER rather than as a public API. Its name follows the BEN naming convention in which the SVA prefix denotes the "Service Area" validation entity, and the INS suffix denotes insert handling. The package therefore encapsulates the insert-side processing logic for the Service Area entity — the object underlying the BEN_SVC_AREA_F and BEN_SVC_AREA_F_S tables — which controls the zip code, postal code, and geographic service-area restrictions used to determine benefit eligibility.

The package is a supporting implementation component rather than an integration surface. As shown in the dependency documentation, it references BEN_SVA_BUS, BEN_SVA_RKI, and BEN_SVA_SHD, which are the business logic, row-key info, and shadow (audit) handlers for the same entity. It also calls HR_API, HR_UTILITY, FND_GLOBAL, FND_MESSAGE, and DT_API, confirming that inserts are performed within the standard BEN/HR date-tracked entity framework, using FND_GLOBAL for WHO columns and FND_MESSAGE for error reporting.

Key Procedures and Functions

Three documented program units exist in the package:

• INSERT_DML — Performs the core DML insert of a Service Area row. It is the routine that writes the validated record into the underlying BEN_SVC_AREA_F table, applying the date-tracked and WHO-column handling expected of a BEN entity.
• INS — The logical insert entry point. It wraps the business validation and row-key processing performed by BEN_SVA_BUS and BEN_SVA_RKI before handing the row to INSERT_DML, and it raises errors through FND_MESSAGE when validation fails.

The third documented unit follows the same insert-support pattern. Parameter lists are not exposed in the ETRM metadata and are therefore not enumerated here; callers should treat these routines as internal to the BEN Service Area entity.

Tables Accessed

Two tables are referenced through APPS synonyms:

• BEN_SVC_AREA_F — the base (F) table holding the Service Area entity rows. This is the primary insert target of the package.
• BEN_SVC_AREA_F_S — the corresponding shadow (S) table. The package writes here to preserve the audit trail of changes required by the BEN datetrack model.

The dependency listing also shows BEN_SVC_AREA_F_S and BEN_SVC_AREA_F as direct object references, along with SYS.DUAL and the STANDARD package for host-language PL/SQL operations.

Usage Notes

BEN_SVA_INS is not referenced by any database object, and the ETRM documentation explicitly notes that it does not appear in the dependency graph of other packages. Because it is classified as OTHER rather than as an API, it should not be called directly from custom code; the supported entry point for creating Service Area records is the BEN Service Area maintenance form and the associated business logic in BEN_SVA_BUS. The package is typically invoked:

• From the Oracle EBS Benefits Service Area maintenance form (the Form used to define geographic eligibility restrictions) during record creation.
• From the BEN business-layer packages (BEN_SVA_BUS) when a Service Area row is programmatically created.
• Indirectly during data loading or conversion routines that populate Service Area data through the supported BEN APIs, with BEN_SVA_INS performing the final physical insert.

These behaviors are consistent across EBS 12.1.1 and 12.2.2, since the BEN Service Area entity and its insert handler were not redesigned between those releases.