Search Results chk_coord_ben_med_cvg_dates

Overview

APPS.PER_PER_BUS1 is an internal Oracle E-Business Suite PL/SQL business logic package that supports the People (PER) module, specifically the table handler infrastructure surrounding the PER_ALL_PEOPLE_F entity. In the Oracle EBS 12.1.1 and 12.2.2 releases, table handlers are generated and hand-extended packages that encapsulate row-level validation, derivation, and defaulting logic invoked through the People Data Pump (per_per_shd) and the various employee/person maintenance APIs. PER_PER_BUS1 is classified in the E-Business Suite Technical Reference Manual (ETRM) as an "OTHER" API, meaning it is not a public, externally callable API but an internal supporting package.

The presence of the header comment "Internal Table Handler Use Only" confirms that this package is not intended for direct invocation by customizations. It provides the business-layer checks that the table handler layer calls before inserting or updating rows in the person tables. Its responsibilities include descriptive flexfield validation and a substantial set of "check" routines covering benefit coordination, statutory person attributes (blood type, tobacco use, date of death), student status, work schedule, and other HR-specific validations.

Key Procedures and Functions

The ETRM documents 18 procedures and functions within this package. Representative entries include:

• DF_UPDATE_VALIDATE — Calls the descriptive flexfield validation stub (per_per_flex.df) only when the attribute_category or attribute1..30 values have changed. If neither the category nor the attributes have changed, validation is skipped and processing continues.
• CHK_UNSUPPORTED_ATTRIBUTES — Verifies that all unsupported attributes are set to null before the person record is processed.
• CHK_CORRESPONDENCE_LANGUAGE, CHK_BLOOD_TYPE, CHK_STUDENT_STATUS, CHK_WORK_SCHEDULE, CHK_USES_TOBACCO, CHK_RD_FLAG — Attribute-level checks validating statutory and preference values on the person record.
• CHK_COORD_BEN_MED_CVG_DATES, CHK_COORD_BEN_MED_DETAILS, CHK_OTHER_COVERAGES, CHK_BENEFIT_GROUP_ID — Benefit coordination and coverage validations that ensure consistency of benefit enrollment data associated with the person.
• CHK_FTE_CAPACITY, CHK_BACKGROUND_CHECK_STATUS, CHK_REHIRE_RECOMMENDATION — Workforce-related validations covering full-time-equivalent capacity, background screening, and rehire eligibility.
• CHK_DATE_DEATH_AND_RCPT_CERT, CHK_BIRTH_ADOPTION_DATE, CHK_DATE_OF_DEATH — Date-driven validations for birth, adoption, and death events, ensuring chronological consistency.

Tables Accessed

The package references the following tables through APPS synonyms:

• PER_ALL_PEOPLE_F — The primary date-tracked person table; read and validated during person row processing.
• BEN_BENFTS_GRP — Benefit group definitions, used by CHK_BENEFIT_GROUP_ID to confirm the benefit group assigned to the person exists and is valid.
• FND_LANGUAGES — Language definitions, used by CHK_CORRESPONDENCE_LANGUAGE to validate the correspondence language value.
• PER_CONTACT_RELATIONSHIPS — Contact relationship definitions, referenced when validating related-person or benefit coordination data.

Usage Notes

PER_PER_BUS1 is invoked exclusively through the People table handler layer, typically via the generated per_per_shd and per_per_bus packages during insert, update, or validation of a person row. It is triggered by the standard Oracle HRMS forms (such as the People form and its associated windows), by the person/employee maintenance APIs, and by concurrent processes that load or update person records. Because the package is marked "Internal Table Handler Use Only," customizations should not call it directly; instead, customizations should use supported public APIs such as HR_PERSON_API or HR_EMPLOYEE_API, which ultimately route through this business logic.