Search Results per_per_bus




Overview
Explore in AI Chat

Overview

APPS.PER_PER_BUS is the core business validation package body for the Oracle Human Resources "Person" (PER) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the server-side validation logic that governs the creation, update, and deletion of person records, including employees, applicants, and other person types defined in the PER schema. The package enforces business rules that cannot be expressed through simple database constraints, such as legislative-specific field validation, national identifier checking, date consistency, and person type eligibility.

Classified as an "OTHER" API in the ETRM metadata, PER_PER_BUS is not a public write API like HR_PERSON but rather a validation utility layer invoked by other PER packages and forms. The package body is documented as VALID and holds roughly 22 procedures and functions. It is referenced by 60 other database objects, indicating that it sits at the centre of the person validation stack and is depended upon by higher-level person maintenance APIs, including PER_PER_BUS1, PER_PEOPLE3_PKG, and PER_PER_SHD.

Key Procedures and Functions

The documented entry points fall into three functional groups. The DML validation procedures — INSERT_VALIDATE, UPDATE_VALIDATE, and DELETE_VALIDATE — provide row-level validation hooks invoked during the respective DML operations on the PER_PER table (the non-date-tracked person table). Their purpose is to apply all applicable business rules before the row is committed.

The CHK_* functions perform discrete validation checks, each returning a success/failure indicator for a specific field or condition:

Two supporting routines, RETURN_LEGISLATION_CODE and SET_SECURITY_GROUP_ID, resolve the current legislation and security group context used throughout the validation logic. These derive their values from profile options and business group configuration.

Tables Accessed

The package reads and writes a defined set of PER and related tables through APPS synonyms. PER_ALL_PEOPLE_F and PER_PERIODS_OF_SERVICE provide the person and assignment history used in date and type validation. PER_PERSON_TYPES supplies valid person type definitions. HR_ORGANIZATION_INFORMATION and HZ_PARTIES support organisation and TCA party lookups for the party and vendor checks. PAY_LEGISLATIVE_FIELD_INFO supplies legislative field metadata, while ALL_TABLES is queried for metadata introspection. The dependency list further records references to HR_PERSON, HR_PERSON_NAME, PER_BUSINESS_GROUPS, HZ_PARTIES, and PO_VENDORS, confirming the package's cross-module reach into Payroll and Purchasing.

Usage Notes

PER_PER_BUS is typically invoked indirectly. The Oracle Forms-based People window and the person maintenance APIs call the DML validation procedures during insert, update, and delete of person records. Custom code that manipulates PER_PER or PER_ALL_PEOPLE_F directly should call the relevant CHK_* function before committing, since the package does not install database triggers itself. Because the package is referenced by 60 objects but is not referenced by any database object external to APPS, it is intended as an internal validation layer rather than a published integration API.