Search Results pa_job




Overview
Explore in AI Chat

Overview

PA_JOB is an Oracle Projects PL/SQL package owned by the APPS schema. In Oracle EBS 12.1.1 and 12.2.2 it is classified under the ETRM API classification tier of OTHER, indicating that it is an internal utility package rather than a published, supported public API for external integration. Its declared purpose is to hold validation logic associated with the Job entity in Oracle Projects. The package is defined with AUTHID CURRENT_USER, meaning that its SQL statements execute under the privileges of the invoking user rather than the definer, and it is expected to be called only from within sessions that already hold the necessary Projects and HRMS privileges.

The source header identifies the file as PAJOBS.pls (version 115.0, dated 1999), confirming that the package is part of the long-standing Oracle Projects foundation layer that has been carried forward largely unchanged into the 12.1.1 and 12.2.2 releases. At present the package exposes a single documented procedure, which is oriented toward pre-deletion validation of job records rather than creation or update of those records.

Key Procedures and Functions

The ETRM metadata documents one procedure for this package.

  • PA_PREDEL_VALIDATION — A validation routine invoked to determine whether a specific job may be safely deleted. It accepts a p_job_id parameter identifying the job under consideration and performs the referential and business rule checks required before deletion is permitted. By convention in Oracle Projects, a procedure bearing the "predel" prefix raises an application error when the deletion is not allowed and returns normally when no blocking dependencies are found.

No other procedures or functions are documented for PA_JOB. The package contains no public API surface for job creation, update, or query, and no functions are declared.

Tables Accessed

ETRM documents the following tables referenced through APPS synonyms.

  • FND_PRODUCT_INSTALLATIONS — Used to confirm that the relevant Oracle application product, in this case Oracle Projects, is installed and licensed in the current environment. This guards the validation logic against execution in instances where Projects is not enabled.
  • PA_IMPLEMENTATIONS_ALL — Holds implementation and configuration settings for Oracle Projects, including organization-level controls. The package consults it to apply the correct business rules for the operating unit.
  • PER_JOBS — The Oracle HRMS table that stores job definitions. It is the primary subject of the pre-deletion validation, since a job is deleted from the HRMS job repository, and this table is queried to confirm the job's existence and its attributes.

The reference by PA_JOB to PER_JOBS reflects the fact that jobs in Oracle Projects are shared with Oracle HRMS rather than being maintained independently.

Usage Notes

PA_JOB is not a standalone API and is not intended for direct invocation by custom applications. It is invoked internally by Oracle Projects as part of the job deletion path, typically from the Projects setup forms that manage job definitions and from the code that enforces referential integrity across Projects, HRMS, and related transactional data.

The metadata records that PA_JOB is referenced by two other packages, which is consistent with its role as a shared validation routine called by multiple deletion handlers rather than a top-level entry point. It is not associated with a concurrent program in the documented metadata.

Because the package is classified as OTHER, its interface is subject to change without notice, and any custom code that calls it directly assumes an unsupported dependency. Users integrating with Oracle Projects should prefer supported job-related APIs or the standard setup forms. The AUTHID CURRENT_USER setting also means callers must ensure that the invoking schema has the required synonyms and privileges on FND_PRODUCT_INSTALLATIONS, PA_IMPLEMENTATIONS_ALL, and PER_JOBS for the validation to complete successfully.