Search Results chk_npw_number

Overview

APPS.PER_PER_BUS is the table handler business rule package for the PER_PERSON_TYPES entity in Oracle EBS Human Resources. It encapsulates the row-level validation logic that governs inserts, updates, and deletes against the person type definition, the configuration construct that determines how a person (employee, applicant, contingent worker, or other classification) is processed by the application. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, and it is classified in ETRM as an OTHER API rather than a public or private API in the strict sense. Its header carries the internal identifier peperrhi.pkh, consistent with the Oracle Forms Generator (FXG-style) table handler naming convention used throughout the HR product family. As the business rule layer, it exists to keep data in the person type tables internally consistent and to enforce cross-entity validation before any DML is committed. It is referenced by 60 other packages, reflecting its central position in the person model.

Key Procedures and Functions

The package exposes 22 documented procedures and functions. The orchestration layer consists of INSERT_VALIDATE, UPDATE_VALIDATE, and DELETE_VALIDATE, which control execution of all business rule checks for the respective DML operations. These are documented as private procedures called from the corresponding insert, update, and delete entry points, and are marked "Internal Table Handler Use Only."

• RETURN_LEGISLATION_CODE — derives the legislation code that drives subsequent legislative validation.
• CHK_SYSTEM_PERS_TYPE — validates the system person type, the seeded classification that anchors person processing.
• CHK_PERSON_TYPE — validates the user-defined person type value.
• CHK_START_DATE — verifies the effective start date supplied for the person type row.
• CHK_ORIG_AND_START_DATES — checks the relationship and consistency between the original and start dates.
• CHK_PARTY_ID — validates the associated TCA party identifier.
• CHK_VENDOR_ID — validates the vendor identifier where the person type is tied to a supplier context.
• CHK_DATE_OF_BIRTH — enforces date of birth validity rules.
• CHK_DATE_EMP_DATA_VERIFIED — validates the date on which employee data was verified, ensuring it is a permissible value relative to the record's dates.
• CHK_NATIONAL_IDENTIFIER — validates the national identifier value.
• CHK_EMPLOYEE_NUMBER — validates the employee number, with logic that can be bypassed during a global transfer.
• CHK_NPW_NUMBER — validates the non-payroll worker number.
• CHK_APPLICANT_NUMBER — validates the applicant number.
• CHK_SEX_TITLE — validates the sex and title combination.
• SET_SECURITY_GROUP_ID — establishes the security group context for the operation.

The header also declares global variables g_previous_sys_per_type and g_global_transfer_in_process, which cache the system person type across repeated validation calls in a single pass and suppress employee number validation during global transfers.

Tables Accessed

The package reads and writes PER_ALL_PEOPLE_F, PER_PERIODS_OF_SERVICE, and PER_PERSON_TYPES, which hold the person, period of service, and person type records being validated. It references HR_ORGANIZATION_INFORMATION for organization-related attributes, HZ_PARTIES for TCA party validation, and PAY_LEGISLATIVE_FIELD_INFO for legislative field definitions. ALL_TABLES is queried in the context of the boilerplate header markup. Access is made through APPS synonyms, so the package always operates in the APPS schema context regardless of the caller.

Usage Notes

PER_PER_BUS is invoked indirectly through the person type table handler and by the 60 dependent packages that require person type validation, rather than being called directly from forms in the normal course of business. Custom code should not call the private validation procedures directly; callers requiring insert, update, or delete behavior should use the corresponding public API entry points, which invoke the private procedures documented here. The AUTHID CURRENT_USER declaration means callers must hold appropriate privileges on the underlying APPS objects. When the validation date for employee data verified is being checked, the CHK_DATE_EMP_DATA_VERIFIED procedure applies the standard date-range and cross-field rules before the row is committed.