Search Results ben_sva_rkd

Overview

BEN_SVA_RKD is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Advanced Benefits (BEN) module. The suffix "RKD" identifies the package as a row-level key deletion handler within the Oracle Forms server-side transaction framework, part of the standard family of packages Oracle generates to manage the deletion of dependent rows during form-based DML operations. Its business function is to support the correct removal of records associated with the BEN_SVA entity, ensuring that related child records and key references are handled consistently when a parent row is deleted through the Benefits setup forms.

The package is documented as VALID in both 12.1.1 and 12.2.2 and is classified as an "OTHER" API — that is, it is not a public, declaratively supported integration interface but an internal runtime artifact invoked by the Oracle Forms engine and by other Benefits packages.

Key Procedures and Functions

ETRM documents a single program unit in the package specification:

• AFTER_DELETE — The post-delete handler for the BEN_SVA record block. It executes after a row has been removed, performing the bookkeeping that must occur once the delete has committed at the form level. This typically includes coordinating key-reference cleanup so that dependent rows or cross-references keyed to the deleted BEN_SVA row do not remain orphaned. Only the procedure name and purpose are documented; no parameter list is published, and the procedure should not be called directly from custom code.

The presence of only this one documented unit confirms the package's narrow scope: it is a generated event hook rather than a library of reusable business logic.

Tables Accessed

The ETRM metadata for BEN_SVA_RKD does not enumerate specific base tables; the dependency section instead lists only SYS and STANDARD as compile-time references, which is characteristic of generated Forms server packages that operate primarily through :SYSTEM variables, block items, and SQL constructs embedded in the package body. Where the package touches data, it does so through APPS synonyms resolving to the BEN_SVA table and its key-related children, since the row-key deletion pattern requires reading the current key values from the form block and issuing the corresponding DELETE statements.

Dependency analysis shows the package is referenced by BEN_SVA_DEL, the deletion routine for the same entity, which is consistent with BEN_SVA_RKD acting as the low-level executor invoked by that higher-level delete logic.

Usage Notes

BEN_SVA_RKD is invoked implicitly by the Oracle Forms runtime when a user deletes a record in the Benefits setup form that maps to the BEN_SVA block. Application developers and functional consultants should not call AFTER_DELETE from custom PL/SQL, concurrent programs, or interfaces; the supported entry point for programmatic deletion remains the higher-level BEN_SVA_DEL package or the documented Benefits APIs.

Because the package is an internal generated artifact, it is version-sensitive: the package body may be regenerated by Oracle Forms during patching or form compilation, so customers must not modify it. In 12.2.2 it remains valid and structurally unchanged from 12.1.1, and the dependency chain (BEN_SVA_DEL → BEN_SVA_RKD) reflects the standard BEN deletion framework. When troubleshooting delete failures or orphaned Benefits setup rows, this package should be reviewed as part of the call stack originating from BEN_SVA_DEL rather than as an independently callable interface.