Results for “pa_hr_project_setup”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_HR_PROJECT_SETUP is an Oracle Applications (APPS) PL/SQL package that supports project setup validation within the Oracle Enterprise Business Suite (EBS) Projects (PA) module. Its documented role is to verify whether HR-related master data — specifically persons and jobs — are already referenced by project setup entities before those records are modified or deleted. This type of referential integrity check is standard in Oracle Projects, where assignments of people and jobs to tasks and other project structures must not be orphaned.

The package header carries the identifier PAHRPRJS.pls 120.1, dated 2005/08/19, and declares AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the package owner. This is consistent with many Oracle Projects validation utilities, which are invoked from forms and concurrent programs running under the APPS schema but intended to respect the caller's security context.

ETRM classifies the package under the API classification OTHER, indicating that it is not a public, supported business API but rather an internal validation utility. The presence of "Reference_Exist" output parameters, rather than raised exceptions, confirms that the package is designed for programmatic pre-checks rather than as a transactional API.

Key Procedures and Functions

• CHECK_PERSON_REFERENCE — Accepts a person identifier and returns two OUT parameters: an error message and a flag indicating whether a reference exists. It is used to determine whether a given person is referenced by project setup data before allowing the person record to be changed or removed.
• CHECK_JOB_REFERENCE — Accepts a job identifier and returns the same pair of OUT parameters: an error message and a reference-existence flag. It performs the analogous check for job definitions used in project structures.

Both procedures follow an identical pattern, returning status through output parameters instead of raising exceptions. The NOCOPY hint on the OUT parameters indicates a performance optimization for large VARCHAR2 values.

Tables Accessed

ETRM documents a single table reference via APPS synonyms: PA_TASKS. PA_TASKS stores the task hierarchy for projects, including task assignments to persons and jobs. It is the logical point at which a person or job reference would need to be detected before permitting changes to the underlying HR records. The package reads PA_TASKS to determine whether the supplied person or job identifier appears in task assignments, setting the reference-existence flag accordingly.

Usage Notes

This package is typically invoked from Oracle Projects setup forms or from custom validation logic that must enforce referential constraints involving HR master data. Because ETRM lists it as referenced by two other packages, it likely serves as a shared validation helper rather than a directly user-facing API. Developers extending Oracle Projects should call these procedures before attempting to modify or delete persons or jobs that may be assigned to project tasks, and should treat the returned error message and reference flag as the authoritative signal for whether such an operation is safe.

Given the package's age (last header revision in 2005) and its OPEN/private nature, it is best regarded as internal plumbing that has remained stable across EBS 12.1.1 and 12.2.2. Custom code should not depend on it without verifying behavior in the target environment, but its two procedures remain the documented mechanism for person and job reference validation within project setup.