Search Results reload_pen

Overview

APPS.BEN_GLOBAL_ENRT is the Enrollment Globals package within the Oracle E-Business Suite Advanced Benefits (BEN) module. Its stated purpose, per the package header, is to load and return global values used during enrollment save processing. The package acts as a session-level cache and accessor layer for records that the enrollment engine requires repeatedly while validating and persisting participant elections. Rather than re-querying core HR and Benefits tables on every call, the enrollment save routines call BEN_GLOBAL_ENRT to populate and retrieve package globals representing the person, assignment, eligibility, plan-in-program, program-in-life-event, and enrollment result contexts currently being processed.

The package header carries the revision identifier bengenrt.pkb 120.0.12010000.2, dated 2008/08/05. Its history log spans versions 115.0 through 115.12 and records several behavior changes relevant to administrators, including the decision to always query the database for certain globals, the removal of a mandatory condition from GET_PIL, exclusion of contingent worker assignments during assignment data fetches, and the Nocopy changes introduced at version 115.8. These entries confirm that the package has been tuned primarily for correctness of enrollment context rather than for pure caching performance.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions in this package:

• GET_EPE — returns the eligibility-per-electable-choice global, the eligibility determination relevant to the electable choice being processed.
• RELOAD_EPE — forces a refresh of the eligibility-per-electable-choice global from the database.
• GET_PEL — returns the plan-in-program eligibility global, identifying the plan's relationship to the program for the current enrollment context.
• GET_PIL — returns the person-in-life-event global. History entries at versions 115.5 and 115.10 indicate the mandatory condition was removed and the procedure was changed to query always, with cursor c1 modified under Bug 4157759.
• CLEAR_ENB — clears the enrollment benefit global, releasing cached enrollment context.
• GET_ENB — returns the enrollment benefit global representing the benefit being enrolled.
• GET_ASG — returns the assignment global. This is the object referenced by the search term "get_asg". It supplies the assignment record used by enrollment processing, with version 115.7 recording that contingent worker assignments are excluded when assignment data is fetched.
• CLEAR_PEN — clears the person enrollment global.
• GET_PEN — returns the person enrollment global.
• RELOAD_PEN — reloads the person enrollment global from the database.

Parameter lists are not reproduced here, as the documented metadata does not expose them.

Tables Accessed

The package reads from core HR and Benefits tables through APPS synonyms. PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F supply person and assignment context, with PER_ASSIGNMENT_STATUS_TYPES used to reconcile assignment status, consistent with the contingent worker exclusion noted in the history. Benefits tables include BEN_ELIG_PER_ELCTBL_CHC, BEN_PER_IN_LER, BEN_LER_F, BEN_PIL_ELCTBL_CHC_POPL, BEN_ENRT_BNFT, and BEN_PRTT_ENRT_RSLT_F, which together define eligibility, life-event and program relationships, electable choices, enrollment benefits, and participant enrollment results. The package also appears in the dependency list of eight other packages, reflecting its role as a shared context provider.

Usage Notes

BEN_GLOBAL_ENRT is invoked indirectly through the Benefits enrollment save flow rather than directly by end users. Forms-based enrollment pages and the underlying enrollment APIs trigger the save process, which calls GET_ASG, GET_PEN, GET_ENB, GET_PIL, GET_PEL, and GET_EPE to establish context before validation and insert or update against the enrollment result tables. CLEAR_ENB, CLEAR_PEN, RELOAD_EPE, and RELOAD_PEN are used to reset or refresh state between transactions. Custom code extending Benefits enrollment should treat these procedures as internal infrastructure and call the supported enrollment APIs instead, since global state assumptions are tightly coupled to the save process.