Search Results pa_ci_impacts_pub




Overview
Explore in AI Chat

Overview

PA_CI_IMPACTS_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite release 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) application family and provides the programmatic interface for managing "control item impacts" — the associations that record how project control items affect, or are affected by, change management activities within the Projects suite. Control items are the user-defined checkpoints or gating conditions that a project manager monitors; an impact row links such a control item to a specific change or event so that its effect on schedule, cost, or scope can be tracked and audited.

The package is classified as a PUB (public) API, meaning it is intended for supported external invocation by other Oracle EBS modules and by customer extensions, rather than being an internal helper. Its dependencies include the standard Oracle Application Object Library utility package FND_API, which provides the common API error-handling and message-stack infrastructure used throughout EBS public APIs.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions in this package:

  • CREATE_CI_IMPACT — Creates a new control item impact record. This is the entry point used when a change, event, or other triggering activity must be associated with an existing control item so that the business impact is captured in the project tracking tables.
  • UPDATE_CI_IMPACT — Modifies an existing control item impact record. It supports maintenance of previously captured impact data, such as revised impact values or status changes, without requiring the row to be deleted and recreated.
  • DELETE_CI_IMPACT — Removes a control item impact record. It is used when an association is no longer valid, for example when a change is cancelled or its relationship to a control item is withdrawn.

Together these three procedures form a complete create/update/delete interface, consistent with the standard EBS public API pattern built on FND_API. Parameter lists are not documented in the ETRM record and are intentionally not reproduced here.

Tables Accessed

The package operates against three documented base tables, accessed through APPS synonyms:

  • PA_CI_IMPACTS — The primary impact table. CREATE, UPDATE, and DELETE operations insert, modify, and remove rows here, making it the central persistence target of the package.
  • PA_CONTROL_ITEMS — The control item master. It is referenced to validate that the control item associated with an impact exists and is valid within the appropriate project or change context.
  • PA_TASKS — The project task table, used to resolve and validate the task structure to which control items and their impacts relate.

Usage Notes

As a public API, PA_CI_IMPACTS_PUB is typically invoked from Oracle Projects forms, concurrent programs, or custom PL/SQL extensions rather than being called directly by end users. Customers extending Oracle Projects change management should route all control item impact maintenance through this package so that validation, security, and FND_API error handling are preserved. Because impact rows are referenced by dependent packages such as PA_CI_SUPPLIER_UTILS and PA_FP_CONTROL_ITEMS_IMPACT_PKG, direct DML against PA_CI_IMPACTS is strongly discouraged; bypassing the API risks inconsistent data across those dependent components. The package is also referenced by PA_CI_IMPACTS_PUB itself, reflecting an internal recursive or wrapper relationship in the dependency graph. Any custom code should treat these procedures as the supported contract and rely on FND_API's return status and message stack for exception handling.