Search Results p_job_id

Overview

APPS.PA_JOB is a PL/SQL package body belonging to the Oracle Projects (PA) module of Oracle E-Business Suite, documented for releases 12.1.1 and 12.2.2. The package is classified under the ETRM taxonomy as an OTHER API, meaning it is not part of the officially supported public API surface but is nevertheless a structural component of the application's internal logic. Its principal business function is pre-deletion validation of job records. When a job defined in Oracle Human Resources (PER_JOBS) is considered for removal, the Projects application must first confirm that the job is not referenced by project setup, resource, budgeting, costing, billing, transaction, or agreement data. PA_JOB encapsulates that referential-integrity check so that deletion does not orphan historical project records or corrupt downstream cost and revenue calculations.

Key Procedures and Functions

The ETRM metadata documents a single procedure on this package:

• PA_PREDEL_VALIDATION — The documented entry point. It accepts a job identifier (parameter named p_job_id, which matches the user's search term) and performs foreign-key reference checks before permitting deletion. Internally, the source header shows the package also declares a private helper, CHECK_BUSINESS_GROUP, and a PHASE2 procedure. The validation flow first determines whether the job belongs to another business group; if so, deletion is permitted. Otherwise the procedure calls a sequence of Check_job_reference routines across multiple Projects modules and raises a not-allowed exception when any returns a positive reference indicator.

Tables Accessed

The ETRM metadata lists three referenced tables accessed through APPS synonyms:

• FND_PRODUCT_INSTALLATIONS — consulted to confirm that the relevant Oracle Applications product is installed and licensed, a standard guard used by Projects validation routines.
• PA_IMPLEMENTATIONS_ALL — the Projects implementation/configuration table, used to determine whether Projects functionality is active for the operating unit in question.
• PER_JOBS — the Oracle HR jobs definition table from which the job being validated originates; this is the parent record subject to the deletion check.

The reference checks themselves are delegated to other packages (PA_HR_PROJECT_SETUP, PA_HR_RESOURCE, PA_HR_SUMMARIZATIONS, PA_HR_BUDGETS, PA_HR_COST_RATES, PA_HR_TRANSACTIONS, PA_HR_BILL_RATES, and PA_HR_AGREEMENTS), which query their own transactional and setup tables. The package is in turn referenced by two other packages, indicating it participates in a wider validation chain.

Usage Notes

PA_JOB is typically invoked indirectly rather than called by end users. It is most commonly triggered when a job deletion is attempted from an Oracle HR or Projects maintenance form, where the pre-delete trigger routes to PA_PREDEL_VALIDATION to enforce referential integrity. Customizations that programmatically purge job records should call the same procedure before issuing a DML delete, passing the target p_job_id. Because PA_JOB is classified as a non-public (OTHER) API, its signature is not guaranteed across patches or upgrades; developers should avoid hard-coding calls to it and instead rely on supported Projects APIs where available. The package carries no concurrent program entry point of its own.