Search Results per_ota_predel_validation




Overview
Explore in AI Chat

Overview

The APPS.PER_OTA_PREDEL_VALIDATION package is a PL/SQL validation package within the Oracle E-Business Suite Oracle Time and Labor (OTA) and Oracle Human Resources (PER) integration layer. Its name — "PREDEL" — indicates a pre-deletion validation role: the package is invoked before a delete operation is performed against core HR entities (jobs, positions, organizations, people, and assignments) to determine whether that deletion is permissible given existing Oracle Time and Labor data dependencies.

The package is declared with AUTHID CURRENT_USER, meaning its stored procedures execute with the privileges of the invoking user rather than the definer, which is consistent with a reusable validation utility intended to be called from multiple contexts. The header comment ($Header: peperota.pkh) confirms the source file is part of the PER/OTA shared code base. The package is classified by ETRM as API classification "OTHER," and it is referenced by nine other packages, underscoring its position as a shared, internal validation dependency rather than a directly user-facing API.

Key Procedures and Functions

The package exposes five documented procedures, each accepting a single numeric identifier that identifies the entity being validated prior to deletion:

Each procedure serves as a gatekeeper that raises an error or otherwise blocks the delete when OTA-referenced data would be orphaned. Because the metadata documents only the signatures and not the parameter lists in detail, callers should treat these as single-identifier validation entry points.

Tables Accessed

The package references, via APPS synonyms, the following OTA tables that represent the dependencies it checks:

These tables collectively support the validation logic: when a user attempts to delete a job, position, organization, person, or assignment, the package queries these tables to confirm that no OTA record depends on the entity, thereby preserving referential integrity across the HR and Time and Labor schemas.

Usage Notes

This package is typically invoked programmatically rather than through a standalone concurrent program. It is most likely called by the Oracle HRMS forms that manage jobs, positions, organizations, people, and assignments, as well as by higher-level PL/SQL APIs that perform deletion of those entities — which explains its reference by nine other packages. In Oracle EBS 12.1.1 and 12.2.2, such validation packages execute within the APPS schema and rely on APPS synonyms for table access. Custom extensions that delete HR records should call the corresponding OTA_PREDEL_*_VALIDATION procedure beforehand to avoid violating OTA dependencies; failure to do so may result in orphaned Time and Labor records or runtime integrity errors.