Search Results check_not_supervisor

Overview

APPS.PER_PEOPLE4_PKG is a PL/SQL package in the Oracle E-Business Suite 12.1.1 / 12.2.2 Oracle HRMS (Human Resources) module, owned by the APPS schema and classified as a server-side API of type OTHER. It is one of several numbered PER_PEOPLE packages that collectively implement validation and date-management logic for person records stored in the PER_ALL_PEOPLE_F table. Rather than performing a full hire, rehire, or termination, this package concentrates on discrete validation and date-consistency routines that surround employee record maintenance.

The object is reported as VALID in the ETRM metadata, and no dependent packages are recorded for it, indicating it functions as a leaf-level utility rather than as a central integration point. Its dependencies reference only SYS.STANDARD, confirming that no other Oracle EBS API packages are prerequisites to its compilation.

Key Procedures and Functions

The documented interface exposes six procedures and functions:

• UPDATE_ROW — performs the actual row-level update of the person record against the underlying person table, encapsulating the write operation for callers that have already completed validation.
• CHECK_FUTURE_CHANGES — evaluates whether pending future-dated changes exist for the person, which affects whether certain updates are permitted or must be deferred.
• CHECK_NOT_SUPERVISOR — validates that the person in question does not currently occupy a supervisory role, preventing invalid changes where a supervisor relationship would be broken.
• CHECK_REHIRE — determines whether the person qualifies for rehire, typically by examining prior periods of service and termination history.
• CHECK_BIRTH_DATE — validates the date of birth supplied for the person, enforcing acceptable-range and consistency rules.
• ORIGINAL_DATE_OF_HIRE — returns or derives the original hire date, which for a rehired employee differs from the most recent start date.

No parameter lists are published in the ETRM metadata for these subprograms; only names and purpose should be relied upon.

Tables Accessed

Four base tables are referenced through APPS synonyms:

• PER_ALL_PEOPLE_F — the core dated person record, read and written by UPDATE_ROW and the validation routines.
• PER_PERIODS_OF_SERVICE — supplies employment history required by CHECK_REHIRE and ORIGINAL_DATE_OF_HIRE.
• PER_PAY_PROPOSALS — accessed for salary proposal context, typically relevant when validating rehire or update eligibility.
• PER_PERSON_TYPES — provides the person type definitions that drive validation and system-person-type rules.

All access is performed through the APPS schema synonyms, consistent with Oracle EBS coding standards.

Usage Notes

PER_PEOPLE4_PKG is invoked indirectly, not as a standalone user-facing program. Typical invocation paths are Oracle Forms personalizations in the HR People window, the Employee Hire and Maintain business flows, and custom PL/SQL that calls the validation checks before issuing its own DML. Because the package contains update and validation logic rather than a single monolithic API, developers integrating with person data should call the CHECK_* routines first and then permit UPDATE_ROW to persist the record. The package is referenced by no other packages, so reimplementing its validations in custom code is unnecessary; it is safer to call it directly to preserve Oracle's date and rehire rules.