Search Results pa_deliverable_utils




Overview
Explore in AI Chat

Overview

PA_DELIVERABLE_UTILS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the "OTHER" API category. It provides the technical foundation for the Deliverables feature within Oracle Projects, the subsystem that allows project managers and administrators to define, track, and report on contractual items produced for a customer, such as documents, hardware, software, or services. The package encapsulates the validation, lookup, and structural logic that governs deliverable types, deliverable actions, and the association of deliverables to project tasks and structures.

In EBS 12.1.1 and 12.2.2, the package functions as a utility layer rather than a public integration API. It is referenced by 23 other packages, and its dependency list includes other Project utilities such as PA_UTILS, PA_PROGRESS_UTILS, PA_PROJ_ELEMENTS_UTILS, PA_TASKS_MAINT_UTILS, and OKE_DELIVERABLE_UTILS_PUB, indicating that it sits beneath higher-level deliverable and project structure processing. As of the documented metadata, the object status is VALID, and it is not referenced by any database object, confirming that it acts exclusively as a supplier of utility logic.

Key Procedures and Functions

The documented package body exposes 81 procedures and functions. The most significant groups are summarized below.

Tables Accessed

The package reads and validates against a broad set of Project and Foundation tables through APPS synonyms.

These accesses support validation of deliverable type usage, resolution of task and structure context, and verification that attachments and associations are correctly recorded.

Usage Notes

PA_DELIVERABLE_UTILS is invoked indirectly by Oracle Projects forms and concurrent programs, such as the Deliverables windows and deliverable-related project processing, rather than being called directly by end users. Because it depends on PA_DEBUG, FND_MSG_PUB, and FND_MESSAGE, failures are surfaced through the standard EBS message stack. The package is documented for ETRM 12.2.2 and remains applicable to 12.1.1; custom code extending deliverables should call the higher-level public APIs such as PA_PROJECT_STRUCTURE_PUB1 or OKE_DELIVERABLE_UTILS_PUB instead of this internal utility layer, ensuring that validation and message handling remain consistent across releases.