Search Results ben_create_ptnl_ler_ss




Overview
Explore in AI Chat

Overview

BEN_CREATE_PTNL_LER_SS is an Oracle Apps (APPS) schema PL/SQL package belonging to the Oracle Advanced Benefits (BEN) module. Its name reflects its function: it creates "potential" Life Event Record (LER) entries for participants. In Oracle Advanced Benefits, a life event — such as marriage, birth, or a change in employment status — can trigger a participant to become eligible for new plan enrollments or to make election changes. The concept of a "potential" LER captures the circumstance where an event has occurred (or a date has been detected) that may give rise to a life event record, and the system must evaluate whether a formal LER should be created and processed.

The package is registered in ETRM as an OTHER-classification API and is documented as VALID in both 12.1.1 and 12.2.2. It contains six documented procedures and functions, and its primary purpose is to persist potential life event records into the BEN_PTNL_LER_FOR_PER table and to drive the associated life event processing logic through the standard HR API transaction mechanism.

Key Procedures and Functions

The following procedures and functions are documented in the package metadata. Parameter lists are not reproduced here.

  • CREATE_PTNL_LER_FOR_PER — The principal entry point. It constructs and inserts a potential life event record for a given person, based on detected life event data. This is the routine invoked when a potential LER must be written for a participant.
  • GET_PTNL_LER_DATA_FROM_TT — Retrieves potential LER data from a PL/SQL table type (TT) structure supplied by the caller. This supports bulk or in-memory processing of candidate life events before they are persisted.
  • PROCESS_API — Invokes the underlying HR API transaction processing framework, coordinating the database operations performed by this package with the HR_API_TRANSACTION_STEPS mechanism.
  • GET_STEP — Returns a step definition used within the API transaction processing sequence, allowing the package to participate in the ordered execution of HR API steps.

Tables Accessed

The package accesses the following documented tables (via APPS synonyms):

  • BEN_PTNL_LER_FOR_PER — The primary target; stores the potential life event records created for participants.
  • BEN_LER_F — The life event reason definition table, consulted to identify valid life event reasons against which potential records are evaluated.
  • PER_ALL_PEOPLE_F — The person record table, used to validate and associate the participant for whom a potential LER is created.
  • HR_API_TRANSACTION_STEPS — Tracks the step-level progress of API transactions initiated by the package.
  • WF_ITEM_ATTRIBUTES — The Oracle Workflow item attribute table, reflecting integration with the Workflow engine that drives benefits life event processing.

Usage Notes

BEN_CREATE_PTNL_LER_SS is not typically invoked directly by end users. It is most commonly called through Oracle Advanced Benefits life event processing flows, such as eligibility and life event concurrent programs, or from other BEN packages. The ETRM metadata confirms that the package is referenced by BEN_PROCESS_COBRA_PERSON_SS, which processes COBRA participants, and self-references its own dependent code. The presence of PROCESS_API and GET_STEP indicates the package participates in the HR API transaction framework, meaning any custom invocation should respect that transaction context to avoid orphaned or partially processed potential LER records. When extending benefits processing, developers should treat this package as an internal engine rather than a public API and validate behavior carefully in a non-production environment.