Search Results has_null_data

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:

• Creation and maintenance: ADD_CONTROL_ITEM, UPDATE_CONTROL_ITEM, DELETE_CONTROL_ITEM, and DELETE_ALL_CONTROL_ITEMS manage the lifecycle of individual control item rows and bulk removal.
• Replication: COPY_CONTROL_ITEM and COPY_RELATED_ITEMS duplicate control item definitions and their associated object relationships, supporting project and template reuse.
• Inclusion and change requests: INCLUDE_CONTROL_ITEM, CHANGE_INCLUDED_CR_STATUS, and DELETE_ALL_INCLUDED_CRS govern whether a control item participates in change request processing.
• Action tracking: UPDATE_NUMBER_OF_ACTIONS and ADD_RELATED_ITEM, DELETE_RELATED_ITEM, DELETE_ALL_RELATED_ITEMS maintain counts and object relationship records.
• Status and numbering: UPDATE_CONTROL_ITEM_STATUS, ASSIGN_CONTROL_ITEM_NUMBER, and LOCK_CONTROL_ITEM manage workflow-relevant state transitions and concurrency control.
• Validation helpers: HAS_NULL_DATA, CI_NUMBER_EXISTS, and IS_LOOKUP_VALID perform mandatory-field, uniqueness, and lookup validation before persistence.

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.