Search Results ben_batch_rate_info_s

Overview

The APPS.BEN_BRI_INS package body is a PL/SQL insertion utility within the Oracle E-Business Suite Advanced Benefits (BEN) module. Its name is an abbreviation of "Benefits Batch Rate Info Insert." The package serves as the low-level data-access layer responsible for inserting rows into the BEN_BATCH_RATE_INFO table and synchronizing the corresponding BEN_BATCH_RATE_INFO_S (shadow) table that the Oracle Applications row-level locking and auditing framework requires for every transaction table.

Batch rate information is the repository of rates generated and staged during the batch processing of benefits rates. It holds the results of bulk rate calculations applied across a population of eligible participants, and is consumed downstream by enrollment, payroll deduction, and costing processes. BEN_BRI_INS isolates the mechanics of creating these rows so that the surrounding business logic does not need to embed direct SQL. This separation is a standard EBS design convention: the *_BUS package holds business rules, the *_INS package performs inserts, the *_RKI package is typically associated with a "Row Key Information" or row-handling helper, and the *_SHD package maintains the shadow table. Together these constitute the generated CRUD framework for the entity.

Key Procedures and Functions

The ETRM metadata documents two procedures/functions in total, with the single named entry INS. Consistent with Oracle naming standards for the module, INS is a private insert routine. It accepts the column values for a single new batch rate information row, executes the insert against the base table, and then performs the shadow-table insert required by the EBS developer framework. It is intentionally narrow in scope: one call inserts one logical record, and no global or multi-row processing is implied. Because the routine is private to the package body, it is not a public API surface and should not be called from external code. Its counterpart BEN_BRI_RKI handles row conversion and validation, while BEN_BRI_BUS orchestrates the higher-level business logic that ultimately invokes this insert.

Tables Accessed

The package references two base tables through APPS synonyms:

• BEN_BATCH_RATE_INFO — the primary transaction table into which the incoming batch rate rows are written. Each row represents a calculated rate for a participant, plan, or rate grouping produced by the batch rate process.
• BEN_BATCH_RATE_INFO_S — the shadow table. For every insert into the base table, a corresponding row is written here to support Oracle Forms-based locking, concurrency, and change tracking. Failure to maintain both tables in the same transaction would leave the record invisible or unmodifiable from the standard benefits forms.

The dependency list also includes HR_API and HR_UTILITY, which supply common date handling, error message generation, and DML utilities, and DUAL and STANDARD, the standard Oracle boilerplate dependencies.

Usage Notes

BEN_BRI_INS is invoked indirectly. It is called by BEN_BRI_BUS during the batch rate information creation flow, which in turn is triggered by the batch benefits rate processing concurrent programs and by rate-loading interfaces. Because the package is classified as OTHER and is not referenced by any other database object, it is not intended as an external integration point. Customizations should use the supported BEN_BRI_BUS layer rather than calling INS directly, and any direct DML against BEN_BATCH_RATE_INFO must also update BEN_BATCH_RATE_INFO_S and invoke the associated row-handling logic to preserve data integrity.