Search Results ben_asg_ler
Overview
BEN_ASG_LER is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Benefits module's Life Event Registry (LER) framework. The package carries an API classification of OTHER within the ETRM metadata repository, indicating that it is an internal supporting package rather than a fully exposed public API. Its role is to evaluate and process life event records associated with assignments and persons, providing the logic that determines whether a given life event satisfies the criteria configured for a participant.
BEN_ASG_LER sits within the broader Benefits processing chain. The ETRM metadata records that it is referenced by other packages, including BEN_PRO_LER and BEN_DT_TRGR_HANDLE, and that it in turn depends on a set of Benefits life event tables. This position reflects its function as a mid-tier evaluator invoked by the life event trigger and processing machinery rather than something a user or form calls directly.
Key Procedures and Functions
The ETRM metadata documents a single procedure or function for this package:
- LER_CHK — The documented entry point of the package. Consistent with the naming convention of the Benefits LER family, LER_CHK performs the life event check, evaluating a life event against the configured eligibility and processing rules and returning a determination that callers such as BEN_PRO_LER and BEN_DT_TRGR_HANDLE use to drive downstream benefits processing. The ETRM record does not publish the parameter list, and no parameters are asserted here.
No additional procedures or functions are documented in the ETRM metadata for this object. Consumers requiring more detail should inspect the package specification and body in the APPS schema.
Tables Accessed
The package reads and writes the Benefits life event tables, accessed through APPS synonyms. The documented tables are:
- BEN_LER_F — The base life event registry table, holding the definition of life events.
- BEN_LER_PER_INFO_CS_LER_F — Life event configuration relating to person information.
- BEN_LER_RLTD_PER_CS_LER_F — Configuration for life events tied to related persons.
- BEN_PER_INFO_CHG_CS_LER_F — Configuration for person information change events.
- BEN_RLTD_PER_CHG_CS_LER_F — Configuration for related person change events.
- BEN_PTNL_LER_FOR_PER — Potential life events identified for a participant.
- PER_CONTACT_RELATIONSHIPS — Contact and relationship data used to resolve related persons.
- FND_SESSIONS — Application session information used by the concurrent and online processing framework.
- DUAL — Standard single-row utility table used for scalar evaluations.
Together these tables supply both the configuration and the runtime participant data that LER_CHK requires to determine whether a potential life event meets the configured criteria.
Usage Notes
BEN_ASG_LER is an internal component of the Benefits life event processing chain and is not intended for direct invocation by end users. It is typically exercised when the Benefits module evaluates life events for participants, whether driven from the concurrent request that processes life events or from online Benefits pages that trigger the same logic. Custom code should not call this package directly; developers extending Benefits should use the documented open APIs, while BEN_ASG_LER and its LER_CHK entry point remain implementation details of the standard product.
The ETRM metadata records the object status as VALID, with no invalid subobjects, and notes dependencies on SYS and STANDARD. Because the metadata excerpt is limited, the descriptions above are grounded in the documented object type, status, dependencies, procedure name, and table list, supplemented by the standard behavior of the Benefits Life Event Registry framework.
-
PACKAGE: APPS.BEN_ASG_LER
12.1.1
owner:APPS, object_type:PACKAGE, object_name:BEN_ASG_LER, status:VALID,
-
PACKAGE BODY: APPS.BEN_ASG_LER
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_ASG_LER, status:VALID,
-
PACKAGE: APPS.BEN_PRO_LER
12.2.2
owner:APPS, object_type:PACKAGE, object_name:BEN_PRO_LER, status:VALID,
-
PACKAGE: APPS.BEN_ASG_LER
12.2.2
owner:APPS, object_type:PACKAGE, object_name:BEN_ASG_LER, status:VALID,
-
PACKAGE: APPS.BEN_PRO_LER
12.1.1
owner:APPS, object_type:PACKAGE, object_name:BEN_PRO_LER, status:VALID,
-
PACKAGE BODY: APPS.BEN_ASG_LER
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_ASG_LER, status:VALID,
-
PACKAGE: APPS.BEN_ASG_INS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:BEN_ASG_INS, status:VALID,
-
PACKAGE: APPS.BEN_ASG_INS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:BEN_ASG_INS, status:VALID,
-
PACKAGE BODY: APPS.BEN_PRO_LER
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_PRO_LER, status:VALID,
-
PACKAGE BODY: APPS.BEN_DT_TRGR_HANDLE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_DT_TRGR_HANDLE, status:VALID,
-
PACKAGE BODY: APPS.BEN_PRO_LER
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_PRO_LER, status:VALID,
-
PACKAGE BODY: APPS.BEN_DT_TRGR_HANDLE
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BEN_DT_TRGR_HANDLE, status:VALID,
-
SYNONYM: APPS.BEN_LER_RLTD_PER_CS_LER_F
12.1.1
owner:APPS, object_type:SYNONYM, object_name:BEN_LER_RLTD_PER_CS_LER_F, status:VALID,
-
SYNONYM: APPS.BEN_LER_RLTD_PER_CS_LER_F
12.2.2
owner:APPS, object_type:SYNONYM, object_name:BEN_LER_RLTD_PER_CS_LER_F, status:VALID,
-
PACKAGE: APPS.BEN_CREATE_PTNL_LER_FOR_PER
12.1.1
owner:APPS, object_type:PACKAGE, object_name:BEN_CREATE_PTNL_LER_FOR_PER, status:VALID,
-
SYNONYM: APPS.BEN_RLTD_PER_CHG_CS_LER_F
12.1.1
owner:APPS, object_type:SYNONYM, object_name:BEN_RLTD_PER_CHG_CS_LER_F, status:VALID,
-
PACKAGE: APPS.BEN_CREATE_PTNL_LER_FOR_PER
12.2.2
owner:APPS, object_type:PACKAGE, object_name:BEN_CREATE_PTNL_LER_FOR_PER, status:VALID,
-
SYNONYM: APPS.BEN_RLTD_PER_CHG_CS_LER_F
12.2.2
owner:APPS, object_type:SYNONYM, object_name:BEN_RLTD_PER_CHG_CS_LER_F, status:VALID,
-
SYNONYM: APPS.BEN_LER_PER_INFO_CS_LER_F
12.1.1
owner:APPS, object_type:SYNONYM, object_name:BEN_LER_PER_INFO_CS_LER_F, status:VALID,
-
SYNONYM: APPS.BEN_LER_PER_INFO_CS_LER_F
12.2.2
owner:APPS, object_type:SYNONYM, object_name:BEN_LER_PER_INFO_CS_LER_F, status:VALID,
-
SYNONYM: APPS.BEN_PER_INFO_CHG_CS_LER_F
12.1.1
owner:APPS, object_type:SYNONYM, object_name:BEN_PER_INFO_CHG_CS_LER_F, status:VALID,
-
SYNONYM: APPS.BEN_PER_INFO_CHG_CS_LER_F
12.2.2
owner:APPS, object_type:SYNONYM, object_name:BEN_PER_INFO_CHG_CS_LER_F, status:VALID,
-
PACKAGE: APPS.BEN_ASG_LER
12.1.1
-
PACKAGE: APPS.BEN_DETERMINE_DATE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:BEN_DETERMINE_DATE, status:VALID,
-
PACKAGE: APPS.BEN_ASG_LER
12.2.2
-
SYNONYM: APPS.BEN_PTNL_LER_FOR_PER
12.1.1
owner:APPS, object_type:SYNONYM, object_name:BEN_PTNL_LER_FOR_PER, status:VALID,
-
SYNONYM: APPS.BEN_PTNL_LER_FOR_PER
12.2.2
owner:APPS, object_type:SYNONYM, object_name:BEN_PTNL_LER_FOR_PER, status:VALID,
-
PACKAGE: APPS.BEN_DETERMINE_DATE
12.2.2
owner:APPS, object_type:PACKAGE, object_name:BEN_DETERMINE_DATE, status:VALID,
-
SYNONYM: APPS.PER_CONTACT_RELATIONSHIPS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_CONTACT_RELATIONSHIPS, status:VALID,
-
SYNONYM: APPS.PER_CONTACT_RELATIONSHIPS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_CONTACT_RELATIONSHIPS, status:VALID,
-
PACKAGE: APPS.BENUTILS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:BENUTILS, status:VALID,
-
SYNONYM: APPS.BEN_LER_F
12.2.2
owner:APPS, object_type:SYNONYM, object_name:BEN_LER_F, status:VALID,
-
SYNONYM: APPS.BEN_LER_F
12.1.1
owner:APPS, object_type:SYNONYM, object_name:BEN_LER_F, status:VALID,
-
PACKAGE: APPS.BENUTILS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:BENUTILS, status:VALID,
-
APPS.BEN_DT_TRGR_HANDLE dependencies on BEN_ASG_LER
12.1.1
-
APPS.BEN_ASG_LER dependencies on BEN_ASG_LER
12.2.2
-
APPS.BEN_ASG_LER dependencies on BEN_ASG_LER
12.1.1
-
APPS.BEN_PRO_LER dependencies on BEN_ASG_LER
12.1.1
-
APPS.BEN_PRO_LER dependencies on BEN_ASG_LER
12.1.1
-
APPS.BEN_DT_TRGR_HANDLE dependencies on BEN_ASG_LER
12.2.2
-
APPS.BEN_PRO_LER dependencies on BEN_ASG_LER
12.2.2
-
APPS.BEN_PRO_LER dependencies on BEN_ASG_LER
12.2.2
-
PACKAGE BODY: APPS.BEN_ASG_LER
12.2.2
-
PACKAGE BODY: APPS.BEN_ASG_LER
12.1.1
-
SYNONYM: APPS.FND_SESSIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_SESSIONS, status:VALID,
-
SYNONYM: APPS.FND_SESSIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_SESSIONS, status:VALID,
-
PACKAGE: APPS.FND_INSTALLATION
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_INSTALLATION, status:VALID,
-
PACKAGE: APPS.FND_INSTALLATION
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_INSTALLATION, status:VALID,
-
APPS.BEN_ASG_LER dependencies on BEN_PRO_LER
12.2.2
-
APPS.BEN_ASG_LER dependencies on BEN_PRO_LER
12.1.1