Search Results pa_control_items_pvt




Overview
Explore in AI Chat

Overview

PA_CONTROL_ITEMS_PVT is a private PL/SQL package in the APPS schema that encapsulates the core business logic for maintaining project control items within Oracle Projects. Control items represent configurable checkpoints — such as change orders, deliverables, or approval gates — that govern whether a project or task may proceed, and that trigger workflow-driven status transitions when certain conditions are met. The package is classified as a PVT API, meaning it is intended for internal consumption by the public APIs and utility packages layered above it rather than for direct invocation by external callers.

In Oracle EBS 12.1.1 and 12.2.2, PA_CONTROL_ITEMS_PVT functions as the transactional engine behind the control item feature. It provides the insert, update, delete, copy, and inclusion routines that public wrappers such as PA_CONTROL_ITEMS_PUB and PA_CONTROL_API_PUB delegate to, keeping validation and data-integrity rules centralized in one private layer.

Key Procedures and Functions

The documented interface exposes nineteen procedures and functions grouped by functional area:

Parameter signatures are not reproduced here; callers should consult the package specification for exact argument lists.

Tables Accessed

The package manipulates data through APPS synonyms. PA_CONTROL_ITEMS is the primary transactional table. PA_OBJECT_RELATIONSHIPS stores the links between control items and related project objects, while PA_CI_TYPES_B holds control item type definitions. PA_CLASS_CODES and PA_PROJECT_STATUSES contribute classification and status context. PA_WF_PROCESSES and FND_CURRENCIES_TL supply workflow and currency lookup reference data.

Usage Notes

Because PA_CONTROL_ITEMS_PVT is a PVT API, it is not documented for direct customer use. It is invoked indirectly through PA_CONTROL_ITEMS_PUB, PA_CONTROL_API_PUB, PA_CI_ACTIONS_PVT, PA_CONTROL_ITEMS_WORKFLOW, and PA_CONTROL_ITEMS_WF_CLIENT, which are triggered from Oracle Projects forms, workflow background processes, and concurrent programs. Users searching for PA_CONTROL_ITEMS_UTILS should note that the utility package is a dependent of this private package and shares its table footprint; customizations should target the public API rather than either private package.