Search Results ben_bri_ins




Overview
Explore in AI Chat

Overview

The APPS.BEN_BRI_INS package is a PL/SQL database object belonging to the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite. Its name follows the standard BEN naming convention: BRI denotes Batch Rate Information, and INS denotes an insert operation. The package therefore provides the internal insert logic used to create and populate batch rate information records within the benefits rate processing framework.

The package is documented in ETRM as VALID under the APPS schema and is classified as an API of type OTHER. It consists of both a package specification and a package body. Its primary structural dependency is on APPS.BEN_BRI_SHD, the shadow (audit) table associated with the batch rate information entity, and on the SYS STANDARD package. The package is referenced by APPS.BEN_BATCH_RATE_INFO_API, which indicates that it functions as a supporting, internal layer beneath the public batch rate information API rather than as a standalone public interface.

Key Procedures and Functions

ETRM documents two procedures or functions for this package. Only the insert-oriented entry point is explicitly identified:

  • INS — The documented insert procedure. Its purpose is to perform the physical insertion of batch rate information rows into the underlying tables. This is the core write operation of the package and is the routine invoked whenever new batch rate information must be persisted.
  • BEN_BRI_INS (the package itself, self-referencing entry) — ETRM lists BEN_BRI_INS among the objects that reference APPS.BEN_BRI_INS, reflecting the internal call structure within the package body.

No parameter lists are documented in the supplied metadata, and none are asserted here. In practice, insert routines of this family accept the batch rate information attributes required to construct a complete row, but the exact signature must be confirmed from the package specification in the target instance.

Tables Accessed

The package operates against two documented tables, accessed through APPS synonyms:

  • BEN_BATCH_RATE_INFO — The base transaction table holding batch rate information records. The INS procedure writes new rows into this table.
  • BEN_BATCH_RATE_INFO_S — The corresponding shadow table that stores the audit trail of insert, update, and delete activity. The insert logic populates this table in parallel with the base table, preserving the mandatory audit record required by the BEN data model.

The dependency on BEN_BRI_SHD is consistent with this design, as it is the shadow-table companion object used to support the audit and datetrack columns of the batch rate information entity.

Usage Notes

BEN_BRI_INS is not intended for direct invocation by end users or by external integrations. It is an internal implementation package, called by APPS.BEN_BATCH_RATE_INFO_API when batch rate information rows are created. Custom code should therefore invoke the public API rather than calling BEN_BRI_INS directly, ensuring that validation, datetrack handling, and audit insertion remain consistent.

Typical invocation paths are batch rate processing and rate information maintenance flows within Oracle Advanced Benefits, whether triggered from the application forms or from concurrent programs that generate and load rate data. Because the package is documented in both EBS 12.1.1 and 12.2.2, its behavior is consistent across these releases, though any signature or behavior verification should always be performed against the specific instance's package specification and ETRM listing.