Search Results delete_all_included_crs

Overview

PA_CONTROL_ITEMS_PVT is a private (PVT) PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema that encapsulates the core business logic for managing project control items within Oracle Projects. Control items represent trackable project issues, action items, change requests, and similar records that must be monitored through their lifecycle. The package follows the Oracle EBS API architecture, exposing the standard FND_API parameter conventions (p_api_version, p_init_msg_list, p_commit, p_validate_only, p_max_msg_count) on its primary procedures so that callers receive consistent message-stack handling, validation-only execution, and transaction control. Because it is classified as a private package, it is intended for internal consumption by other Oracle Projects packages, forms, and wrapper public APIs rather than as a directly callable interface. The object bears a source header dating to 2007 (PACICIVB.pls 120.4) and is present across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions. The central lifecycle procedures are ADD_CONTROL_ITEM, which creates a control item from a wide set of attributes (type, summary, status, owner, classification, reason, project, priority, effort level, pricing, source information, and descriptive flexfield attribute columns); UPDATE_CONTROL_ITEM, which modifies an existing control item; and DELETE_CONTROL_ITEM, which removes a single control item. DELETE_ALL_CONTROL_ITEMS removes all control items in a given scope. COPY_CONTROL_ITEM duplicates an existing control item, and INCLUDE_CONTROL_ITEM associates a control item into a container such as a change request.

Supporting procedures manage state and sequencing. UPDATE_NUMBER_OF_ACTIONS maintains the count of actions linked to a control item, UPDATE_CONTROL_ITEM_STATUS changes its status, and ASSIGN_CONTROL_ITEM_NUMBER generates or assigns the control item number. CHANGE_INCLUDED_CR_STATUS handles the change-request inclusion status. Validation and utility functions include HAS_NULL_DATA, CI_NUMBER_EXISTS, and IS_LOOKUP_VALID. LOCK_CONTROL_ITEM provides concurrency control. The related-item family — ADD_RELATED_ITEM, DELETE_RELATED_ITEM (the procedure relevant to the user's search), DELETE_ALL_RELATED_ITEMS, and COPY_RELATED_ITEMS — manipulates the relationships between control items and other project objects. DELETE_ALL_INCLUDED_CRS removes all included change requests in scope.

Tables Accessed

The package reads and writes PA_CONTROL_ITEMS, the primary transactional table storing control item records. PA_OBJECT_RELATIONSHIPS stores the relationship rows used by the related-item and inclusion procedures. PA_CI_TYPES_B holds control item type definitions referenced during validation and creation, while PA_CLASS_CODES supplies valid classification codes. PA_PROJECT_STATUSES is consulted for status validation. FND_CURRENCIES_TL provides currency translation data for price attributes, PA_WF_PROCESSES supports workflow integration, and all are accessed through APPS synonyms.

Usage Notes

PA_CONTROL_ITEMS_PVT is typically invoked by Oracle Projects forms, by concurrent programs that create or synchronize control items, and by other PL/SQL packages — it is referenced by nine other packages. Callers conventionally pass p_init_msg_list, p_commit, and p_validate_only to control message-stack initialization and transaction boundaries. Custom code should call the corresponding public API wrappers where available rather than invoking this private package directly, and should always inspect the returned message stack when p_validate_only is used.