Search Results ota_predel_pos_validation
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:
OTA_PREDEL_JOB_VALIDATION— validates whether a job identified by its job ID may be deleted, checking for dependent OTA data.OTA_PREDEL_POS_VALIDATION— validates whether a position identified by its position ID may be deleted.OTA_PREDEL_ORG_VALIDATION— validates whether an organization identified by its organization ID may be deleted.OTA_PREDEL_PER_VALIDATION— validates whether a person identified by their person ID may be deleted.OTA_PREDEL_ASG_VALIDATION— validates whether an assignment identified by its assignment ID may be deleted.
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:
OTA_ACTIVITY_VERSIONS— versioned activity definitions tied to HR entities.OTA_DELEGATE_BOOKINGS— delegate enrollment and booking records referencing people and assignments.OTA_EVENTSandOTA_EVENT_ASSOCIATIONS— event definitions and their associations to HR records.OTA_FINANCE_HEADERS— financial header data linked to time entries.OTA_NOTRNG_HISTORIES— notification history records associated with time and labor events.
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.