Search Results parent_deleted

Overview

APPS.BEN_BENEFIT_CONTRIBUTIONS_PKG is a Benefits table handler package in Oracle E-Business Suite (12.1.1 and 12.2.2) responsible for interfacing with the Benefit Contributions entity and maintaining its integrity. The package body originates from the early Benefits implementation (header pybco.pkb, originally created January 1994) and follows the standard Oracle table-handler pattern in which a package encapsulates the business rules and referential-integrity logic associated with a single entity. In this case the entity is the set of benefit contribution definitions stored in the BEN_BENEFIT_CONTRIBUTIONS_F table.

Its central responsibility is to preserve data consistency when a master (parent) record referenced by a benefit contribution is deleted or shut down. Because benefit contributions reference multiple independent parent entities — pay element types, business groups, and COBRA coverage benefits — the package must respond generically to a parent deletion and clear or remove any dependent contribution rows that would otherwise be orphaned.

Key Procedures and Functions

• PARENT_DELETED — Documented as the sole procedure in the package. Its stated purpose is to handle the case when a referenced master entity has one of its records deleted or shut down. It is designed to be called by any parent entity that holds a foreign-key relationship to benefit contributions. The procedure receives the identifier of the parent record, a delete mode (defaulting to 'DELETE'), a session date, and the name of the parent entity from which the deletion was made. The parent entity name is used to decode which foreign key applies — PAY_ELEMENT_TYPES_F, PER_BUSINESS_GROUPS, or PER_COBRA_COVERAGE_BENEFITS_F — allowing one procedure to serve all parent relationships. Internally it opens an updatable cursor over the orphaned rows in BEN_BENEFIT_CONTRIBUTIONS_F and processes them according to the delete mode.

Tables Accessed

• BEN_BENEFIT_CONTRIBUTIONS_F — The primary entity table. The package reads this table through a cursor that selects all rows whose foreign key matches the supplied parent identifier, using a DECODE on the parent entity name to determine whether the match is against element_type_id, business_group_id, or coverage_type. The cursor is declared FOR UPDATE, and the retrieved rows are then removed (or otherwise processed) as orphaned records as part of the parent-deletion cleanup.

Usage Notes

BEN_BENEFIT_CONTRIBUTIONS_PKG is an internal Benefits infrastructure package rather than an end-user-facing API. It is classified in ETRM as "OTHER" and is referenced by three other packages, indicating that it is invoked programmatically by related Benefits table handlers when a parent entity record is deleted or terminated. Typical invocation paths include the deletion logic of the pay element type, business group, and COBRA coverage benefit handlers, as well as any concurrent or forms-driven maintenance process that removes a referenced master record. Custom code should not call PARENT_DELETED directly; instead, deletion of the parent entity should be routed through the appropriate parent handler so that the correct parent entity name and identifiers are passed. Developers extending Benefits should note that the orphaned-row cleanup is driven entirely by the parent name supplied at call time, so any new foreign key added to BEN_BENEFIT_CONTRIBUTIONS_F requires a corresponding extension of the decode logic to remain consistent.