Search Results ben_sva_rki

Overview

BEN_SVA_RKI is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Advanced Benefits (BEN) module. The "_RKI" suffix follows the Oracle EBS convention for "Row Kernel Insert" packages — these are the lowest-level insert handlers in the BEN row-handler architecture, responsible for performing the physical DML operations that create new rows in the base benefits tables. BEN_SVA_RKI belongs to the "SVA" family of BEN objects and operates specifically as an AFTER-INSERT row-level trigger body module, meaning its logic is invoked after a row has been successfully inserted into its parent table. In the benefits configuration model, insert processing is central to establishing eligibility, enrollment, and plan setup records. This package encapsulates that insert-time processing so that it can be reused by higher-level BEN row-handler packages and by database triggers without duplicating logic in each caller.

Key Procedures and Functions

The documented package exposes a single public program unit:

• AFTER_INSERT — This procedure implements the post-insert processing logic for the BEN SVA entity. Because the row has already been physically written to the table when this procedure executes, its purpose is to perform the work that must occur after a successful insert: propagating key values, maintaining dependent or derived records, and enforcing the BEN business rules that apply to newly created configuration data. It is the insert counterpart to similar AFTER_UPDATE and AFTER_DELETE handlers in the BEN row-kernel family. No parameter list is documented; callers are expected to reference the correct package interface as shipped by Oracle.

The ETRM metadata identifies the API classification as OTHER, indicating that BEN_SVA_RKI is not a public, customer-callable API but an internal implementation package. It should be treated as Oracle-internal code.

Tables Accessed

The ETRM documentation excerpt for BEN_SVA_RKI does not enumerate specific base tables accessed through APPS synonyms, so the precise table list cannot be confirmed from the supplied metadata. By architectural analogy with other BEN row-kernel insert packages, the AFTER_INSERT logic operates against the benefits base table associated with the SVA entity, together with any dependent setup tables whose rows must be created or synchronized as part of the insert transaction. The dependency listing records references only to the package specification BEN_SVA_RKI, the HR_UTILITY package, and the SYS STANDARD package — no other application objects are documented as referenced. HR_UTILITY is the standard HRMS utility package providing date and other common conversions used throughout Oracle HRMS and Benefits code.

Usage Notes

BEN_SVA_RKI is invoked indirectly. The package is not referenced by any other database object according to the ETRM dependency data, but it is documented as being referenced by one other package, which indicates that the surrounding BEN row-handler layer calls into it during insert processing. The typical invocation path is either:

• A database AFTER INSERT trigger on the base benefits table, which calls the row kernel to complete post-insert processing; or
• A higher-level BEN configuration API or concurrent process (for example, benefits setup and plan configuration programs) that inserts a row and relies on the row kernel to finish the transaction.

Because the package is classified as an internal OTHER API, it should not be called directly from custom forms, concurrent programs, or customer-written PL/SQL. Upgrades and patches may change its internal behavior; customizations should instead use the supported BEN public APIs. When troubleshooting insert failures in Oracle Advanced Benefits on release 12.1.1 or 12.2.2, this package often appears in the error stack and should be inspected in conjunction with its caller.