Search Results validate_delete

Overview

PER_FR_VALIDATE_DELETE_PKG is an Oracle E-Business Suite database package owned by the APPS schema and is classified as an "OTHER" API within the ETRM repository. It is part of the Oracle Human Resources (PER) module's French localization layer, as reflected by the "FR" component in its name and the header comment referencing the source file pefrorvd.pkh. The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer, and it should be considered a public package used internally by the application for validation of deletion operations against HR organization data.

The central purpose of the package is to determine whether a given organization can be safely deleted, preventing the removal of organizational units that still have dependent HR records attached to them. This kind of referential-integrity guard is common in EBS HR where organizations are referenced by assignments, people records, and organization information rows.

Key Procedures and Functions

The ETRM metadata documents a single entry point:

• VALIDATE_DELETE — accepts an organization identifier and validates that the specified organization is eligible for deletion. If dependent records exist, the procedure raises an application error or otherwise signals the caller that deletion cannot proceed.

No additional procedures or functions are documented. The specification header shows the procedure declaration at line 4 and terminates the package at line 6; the header revision dates from December 2003, indicating a long-standing component of the French HR localization.

Tables Accessed

Based on the ETRM metadata, the package touches four HR tables through APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS — the primary organization definition table; used to resolve the organization being validated.
• HR_ORGANIZATION_INFORMATION — holds descriptive flexfield-style organization attributes; checked for attached information that would block deletion.
• PER_ALL_ASSIGNMENTS_F — the date-tracked assignment table; queried to detect employees currently assigned to the organization.
• PER_ALL_PEOPLE_F — the date-tracked person table; referenced to detect people associated with the organization, for example as primary assignment holders.

The presence of assignments and people tables confirms that the validation logic is principally concerned with blocking deletion when the organization is still referenced by active HR data.

Usage Notes

The package is not referenced by any other documented package, which suggests it is invoked directly from user interface code — most likely the Organization form in Oracle HRMS — or from a concurrent program that performs organizational cleanup. When a French-localized HR implementation triggers an organization delete action, the form calls VALIDATE_DELETE, passing the organization identifier; if validation fails, an error is raised and the deletion is prevented.

Custom code should call this package rather than reimplementing the checks, since the same dependency rules that Oracle enforces through the standard HR forms should be applied consistently. The AUTHID CURRENT_USER declaration means custom callers must have appropriate privileges on the underlying HR tables, and any wrapper code should preserve the exception behaviour so that the standard error message is surfaced to the end user.