Search Results create_benefits_assignment

Overview

APPS.BEN_ELEMENT_ENTRY is a core PL/SQL package within the Oracle E-Business Suite Advanced Benefits (OAB) module, responsible for the creation, proration, and lifecycle management of payroll elements associated with employee benefit enrollments. In Oracle EBS 12.1.1 and 12.2.2, benefits enrollments ultimately flow to Oracle Payroll as element entries so that deductions, credits, and reimbursements are processed correctly. BEN_ELEMENT_ENTRY encapsulates the logic that bridges Benefits enrollment results to Payroll element entries, including proration of premiums, coverage amounts, and rates across partial pay periods.

The package is declared AUTHID CURRENT_USER and exposes a set of PL/SQL record and collection types, notably g_calculated_values for holding prorated amount and pay-period data, ext_inpval_tab_typ for extra input values, and inpval_tab_typ for element input values. It also defines a global cache structure (g_cache_quick_payrun) for rapid payrun lookups, and the global variable g_creee_calc_vals. These structures support its role as a computational and persistence gateway for benefit-related element entry data.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions supporting the benefits-to-payroll element entry pipeline:

• PRORATE_AMOUNT — Calculates prorated amounts for rates, coverage, and actual premiums based on activity base rates, coverage amount calculation methods, and person context.
• GET_LINK — Retrieves the linkage between benefit elements and their defining configuration.
• CHK_ASSIGN_EXISTS — Determines whether a benefits assignment already exists for the given person and element, preventing duplicate processing.
• CREATE_BENEFITS_ASSIGNMENT — Creates the benefits assignment record that anchors subsequent element entries.
• CREATE_ENROLLMENT_ELEMENT — Generates payroll element entries for an active benefits enrollment.
• REOPEN_CLOSED_ENROLLMENT — Reverses a closed enrollment to permit corrections or reinstatement.
• END_ENROLLMENT_ELEMENT — Terminates an enrollment element entry, typically upon enrollment close or plan termination.
• GET_ABR_ASSIGNMENT — Returns assignment data related to activity base rate processing.
• GET_EXTRA_ELE_INPUTS — Fetches extra input values required by the element definition.
• GET_INPVAL_TAB — Builds the input value table passed to element entry creation.
• CLEAR_DOWN_CACHE — Clears the package-level payrun cache to ensure data freshness.
• SET_NO_CACHE_CONTEXT — Manages the cache context flag, controlling whether cached payrun data may be reused during processing.
• RESET_MSG_DISPLAYED — Resets internal message-display state, tied to earlier bug fixes.
• CREATE_REIMBURSE_ELEMENT — Creates reimbursement element entries for benefit reimbursements (for example, FSA or HSA-style plans).
• END_REIMBURSE_ELEMENT — Ends reimbursement element entries.

Tables Accessed

The package reads and writes a substantial set of Benefits tables via APPS synonyms. Activity base rate and proration logic relies on BEN_ACTY_BASE_RT_F, BEN_PRTL_MO_RT_PRTN_VAL_F, and BEN_PRTT_RT_VAL. Enrollment results and rates are handled through BEN_PRTT_ENRT_RSLT_F and BEN_ENRT_RT. Eligibility and plan configuration are sourced from BEN_ELIG_PER_ELCTBL_CHC, BEN_PER_IN_LER, BEN_LER_F, BEN_LE_CLSN_N_RSTR, BEN_OIPL_F, BEN_PGM_F, BEN_PL_F, and BEN_POPL_YR_PERD. Element input value persistence uses BEN_EXTRA_INPUT_VALUES, while BEN_YR_PERD provides the pay-period calendar needed for proration computations.

Usage Notes

BEN_ELEMENT_ENTRY is referenced by 22 other packages and is not typically called directly by end users or forms. It is invoked primarily by OAB enrollment and payroll-processing concurrent programs, such as those that create and refresh benefit element entries after Life Event or Open Enrollment processing. Custom code integrating with OAB should call the wrappers (for example, CREATE_ENROLLMENT_ELEMENT) rather than the low-level cache or proration routines. The presence of SET_NO_CACHE_CONTEXT and CLEAR_DOWN_CACHE indicates that callers must manage cache state carefully, particularly in batch environments where payrun data may have changed between calls. The package header references header revision 120.1.12010000.1, consistent with the 12.1.1 lineage carried forward into 12.2.2.