Search Results ben_business_groups

Overview

APPS.BEN_LRI_BUS is a business-layer PL/SQL package body within the Oracle E-Business Suite Benefits (BEN) module. The suffix convention "_BUS" identifies it as a business rules package, distinguishing it from the lower-level "_API" and "_DLS" (data-level security) packages that typically accompany it. Its responsibilities center on the BEN_LER_EXTRA_INFO entity — supplementary information attributes that extend Learning/Extensible Rules (LER) records in the Benefits configuration model — and on validating the operations performed against those records. The package derives business-group context for a given extra-info record and enforces the validation rules that constrain inserts, updates, and deletes.

The package header comment references the shared business group join pattern required to resolve a legislation code from a business group, confirming that business group scoping is intrinsic to the package's design. Because Benefits configuration is partitioned by business group, almost every validation performed here depends on resolving the correct business group for the record under manipulation.

Key Procedures and Functions

• RETURN_LEGISLATION_CODE — Public function that accepts an extra-info identifier and returns the legislation code applicable to the business group context of that record. It resolves the legislation code by joining the extra-info record to its parent LER record and then to the business group. This function is the primary entry point for determining the legislative environment under which an extra-info row operates.
• CHK_LER_INFO_TYPE — Validation routine that verifies the LER information type associated with the extra-info record is valid and consistent with the Benefits configuration.
• CHK_LER_ID — Validation routine that confirms the referenced LER identifier exists and is valid for the operation being performed.
• CHK_MULTIPLE_OCCURENCES_FLAG — Validation routine that checks the multiple-occurrences indicator governing whether more than one instance of the extra-info record is permitted.
• CHK_NON_UPDATEABLE_ARGS — Validation routine that detects attempts to modify arguments that are designated non-updateable, preventing invalid changes to key attributes.
• INSERT_VALIDATE — Orchestrates validation logic prior to inserting a new extra-info record.
• UPDATE_VALIDATE — Orchestrates validation logic prior to updating an existing extra-info record.
• DELETE_VALIDATE — Orchestrates validation logic prior to deleting an extra-info record.

Tables Accessed

The package references three Benefits tables through APPS synonyms. BEN_LER_EXTRA_INFO is the primary entity the package manages, holding the supplemental attribute values attached to LER records. BEN_LER_F is the LER master table, supplying the business group identifier that links each extra-info record to its owning business group. BEN_LER_INFO_TYPES defines the permissible information types and is consulted by the type-checking validation routine. The legislation code lookup additionally joins PER_BUSINESS_GROUPS to translate a business group identifier into its legislation code.

Usage Notes

BEN_LRI_BUS is an internal business-layer package rather than a public API. It is invoked indirectly by the Benefits forms and by higher-level API packages that construct and maintain LER extra-info records. The ETRM metadata records three dependent packages that reference it. Custom code should generally call the corresponding _API layer rather than this package directly; the validation procedures are designed to be driven by the API's insert, update, and delete processing. The package first appears in the 11i code line (header revision dated 2003) and remains present in 12.1.1 and 12.2.2 with the same structure and documented procedure set.