Search Results insert_event

Overview

HRI_OPL_BEN_ENRLACTN_EQ is a PL/SQL package body in the APPS schema whose stated purpose is to populate the Benefits Enrollment Action event queue. It belongs to the Oracle Human Resources Intelligence (HRI) family of "OPL" (Operational Reporting / analytics) packages and specifically serves the Benefits Enrollment Action subject area. The package acts as an integration bridge between the transactional Benefits tables and the event queue table HRI_EQ_BEN_ENRLACTN_EVTS, which feeds downstream business intelligence and event-driven processing.

The object is classified in ETRM as "OTHER" under the APPS owner. Its header comment block identifies three entry points: insert_event, update_event, and delete_event. The version stamp (hrieqeea.pkb 120.0) and the history line crediting an initial version in 2005 indicate the package originates in the 11i/12.0 code line and is carried forward unchanged into Oracle EBS 12.1.1 and 12.2.2. No other package references it (ETRM reports zero referencing packages), so it functions as a top-level event producer rather than a shared utility.

Key Procedures and Functions

• insert_event — Documented procedure that creates a new Benefits Enrollment Action event record in the queue. It accepts a record of type ben_pea_shd.g_rec_type together with an effective date and a datetrack mode, consistent with the standard Oracle datetracked API pattern. It is the primary mechanism by which a newly created enrollment action is published to the event queue.
• update_event — Documented procedure that publishes a modification to an existing enrollment action, keeping the queue synchronized when an enrollment action is changed. It follows the same parameter convention as insert_event, using an effective date and datetrack mode to determine the correct date-tracked result.
• delete_event — Documented procedure invoked when a Benefits Enrollment Action is deleted or terminated. It removes or invalidates the corresponding queue entry so that HRI_EQ_BEN_ENRLACTN_EVTS no longer reflects an action that has been undone.

In addition, the source excerpt shows an internal helper function, get_lf_evt_dt, which returns the life event occurrence date (lf_evt_ocrd_dt) from BEN_PER_IN_LER for a given per_in_ler_id. This supplies the effective date used by the event procedures. It is not part of the documented public API.

Tables Accessed

• HRI_EQ_BEN_ENRLACTN_EVTS — the Benefits Enrollment Action event queue itself; the target of the insert, update, and delete operations performed by the three documented procedures.
• BEN_PER_IN_LER — the Benefits person/learner (life event) table, read to obtain the life event occurrence date that drives the effective dating of queued events.
• BEN_ACTN_TYP — the Benefits action type reference table, used to identify and classify the enrollment action being published.
• BEN_PRTT_ENRT_RSLT_F — the participant enrollment results table, consulted to resolve enrollment detail associated with the action.

Usage Notes

Because the package is not referenced by any other package, it is not called indirectly from a shared framework API. It is invoked directly whenever Benefits enrollment action data must be propagated to the HRI event queue — typically from Benefits form logic when an enrollment action is saved, from concurrent programs that refresh the Benefits analytics tables, or from custom extension code implementing a similar event-publishing requirement. Callers should supply the BEN_PEA_SHD.g_rec_type record structure along with a valid effective date and datetrack mode, matching the conventions of the Oracle datetracked API family. There are no known public synonyms or dependencies beyond those documented, and the package is unchanged across 12.1.1 and 12.2.2.