Search Results ben_batch_dpnt_info_s




Overview
Explore in AI Chat

Overview

The APPS.BEN_BDI_INS package body is the insert-handler component of the Oracle E-Business Suite Advanced Benefits (BEN) batch dependent information processing framework. It belongs to the family of generated or seeded PL/SQL modules that manage the lifecycle of rows in the BEN_BATCH_DPNT_INFO entity, which stores batch-level information about dependents and other eligible dependents (designated beneficiaries, covered dependents, and related persons) processed through a benefits batch or open enrollment run.

In Oracle EBS 12.1.1 and 12.2.2, the BEN_BDI_ prefix denotes the business object entity "Batch Dependent Information." The _INS suffix identifies the module responsible for inserting new logical rows into the underlying table. The package works in conjunction with the related modules BEN_BDI_BUS (business validation rules), BEN_BDI_RKI (row key information and primary key derivation), and BEN_BDI_SHD (shadow/audit handling for date-tracked rows). Together these modules implement the standard Oracle HRMS date-tracked entity pattern.

Key Procedures and Functions

  • INS — The insert procedure is the single documented entry point of this package body. It performs the physical or logical insert of a batch dependent information row, coordinating with the BEN_BDI_BUS business layer for validation and with BEN_BDI_RKI for the object version number and primary key. It also invokes HR_API and HR_UTILITY routines for standard HRMS housekeeping tasks such as who-column stamping and date-track maintenance. The procedure is designed to be called only from within the BEN business object layer rather than directly by end users.

Tables Accessed

  • BEN_BATCH_DPNT_INFO — The primary table written by the INS procedure. Each row represents a batch dependent information record within a benefits processing run.
  • BEN_BATCH_DPNT_INFO_S — The shadow table associated with the primary table. It stores the audit and date-track shadow rows that allow the entity to support effective dating and the standard HRMS datetracked API contract.

The package also references DUAL and STANDARD from the SYS schema for routine PL/SQL expression evaluation and does not access any external application tables beyond the two documented above.

Usage Notes

BEN_BDI_INS is not invoked directly by Oracle Forms or concurrent programs in the standard product. Instead, it is called internally by the BEN_BDI_BUS business layer whenever a new batch dependent information record must be created. The ETRM metadata confirms that the package is referenced by exactly one other package and itself references BEN_BDI_BUS, BEN_BDI_INS, BEN_BDI_RKI, BEN_BDI_SHD, HR_API, and HR_UTILITY.

Because the module enforces HRMS date-track semantics and who-column auditing, customizations should avoid calling INS directly; instead, developers extending benefits batch processing should route inserts through the business object API. The package may be surfaced indirectly through the ben_batch_dpnt_info_s shadow table queries that administrators use to audit batch dependent changes, which is consistent with the user search term that prompted this reference.