Search Results chk_job_group_id

Overview

APPS.BEN_EST_BUS is a business-layer (BUS) PL/SQL package body within the Oracle E-Business Suite Advanced Benefits module. It belongs to the family of generated Business Rule handlers that Oracle Benefits uses to encapsulate the table-handling (TAPI) logic for specific underlying tables. The package name derives from the Benefits eligibility supplemental role person/territory rule assignment entity, and its primary responsibility is to enforce the data integrity and validation rules that govern rows in the BEN_ELIG_SUPPL_ROLE_PRTE_F table. It sits above the corresponding shared (SHD) handler, BEN_EST_SHD, which supplies row-level context such as the api_updating flag and the g_old_rec record used during update comparisons.

The specific check the user searched for, chk_job_group_id, corresponds to the generated primary key and column validation procedures that follow the standard Oracle TAPI pattern in this package. In ben_est_bus, the analogous generated check (visible in the excerpt as chk_elig_suppl_role_prte_id) verifies that the primary key is null on insert, cannot be changed on update, and that object version numbers are consistent. The chk_job_group_id member operates in the same manner for the job group identifier column, ensuring that any job group value associated with an eligibility supplemental role rule is valid against PER_JOB_GROUPS before the row is written.

Key Procedures and Functions

• RETURN_LEGISLATION_CODE — Returns the legislation code associated with the current row context. Benefits uses this to drive legislation-specific validation and defaulting logic, ensuring that eligibility rules respect the legislative environment of the business group.
• INSERT_VALIDATE — Performs all pre-insert validation for the entity. This includes the null-primary-key check, verification that mandatory columns are populated, and validation of foreign key references such as the job group and job identifiers. It raises hr_utility errors on failure so callers can trap a consistent error stack.
• UPDATE_VALIDATE — Performs pre-update validation. It confirms the primary key has not been altered, that the object version number matches the stored row (optimistic locking), and re-validates changed columns such as job group references.
• DELETE_VALIDATE — Performs pre-delete checks, confirming that the row may legitimately be removed and that no dependent eligibility processing would be compromised by deletion.

Each procedure follows the same internal convention: it sets an hr_utility.set_location trace point on entry, calls ben_est_shd.api_updating to determine row state, and then compares values against ben_est_shd.g_old_rec.

Tables Accessed

• BEN_ELIG_SUPPL_ROLE_PRTE_F — The primary entity table. This package validates and maintains rows in this table on behalf of the forms and batch processes that call it.
• PER_JOBS — Referenced to validate that a supplied job identifier exists and is valid for the effective date.
• PER_JOB_GROUPS — Referenced by the chk_job_group_id logic to confirm that the job group identifier is a valid, enabled job group.
• ALL_TABLES — Used generically for existence checks or dynamic SQL resolution during validation.

Usage Notes

This package is classified as OTHER in the ETRM metadata and is listed as referenced by three other packages, indicating it is invoked indirectly rather than directly by end-user forms. Callers are typically the Benefits eligibility forms and concurrent programs that perform inserts, updates, and deletes on supplemental role person/territory rules, as well as custom extensions that must respect the same validation rules. Custom code should call the INSERT_VALIDATE, UPDATE_VALIDATE, and DELETE_VALIDATE procedures before issuing DML, and should never modify BEN_ELIG_SUPPL_ROLE_PRTE_F directly, as doing so bypasses the job group and job validation enforced here.