Search Results maintain_ctrl_item_version




Overview
Explore in AI Chat

Overview

PA_FP_CONTROL_ITEMS_IMPACT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Project Management module's control item and plan version impact functionality. The package is classified as an "OTHER" API in the ETRM repository, meaning it is not a formally published public interface API but rather an internal processing package invoked by Oracle's own application logic. Its core responsibility is to maintain the relationship between control items, budget or forecast plan versions, and the impacts those control items exert on project funding and planning data. Control items in Oracle Projects represent findings, conditions, or corrective actions associated with a project, typically arising from quality, risk, or compliance processes. When a control item changes, the impact on the associated project plan versions must be recalculated and persisted. This package encapsulates that maintenance logic, ensuring that impact records remain synchronized with their parent plan versions and control items.

Key Procedures and Functions

The package exposes three documented procedures:

  • MAINTAIN_CTRL_ITEM_VERSION — Maintains the association between a control item and its version information, ensuring that when control item data changes, the corresponding versioned impact records are created or updated rather than left stale.
  • MAINTAIN_PLAN_VERSION — Handles the plan version side of the relationship, synchronizing budget or forecast plan version data with the control item impacts that reference it. This supports consistent versioning when plans are revised.
  • DELETE_CI_PLAN_VERSIONS — Removes control item plan version records, typically invoked when a control item is deleted or when a plan version is obsoleted, preventing orphaned impact rows.

No parameter lists are documented in the ETRM metadata, so signatures should not be assumed; callers rely on the published specification in the database.

Tables Accessed

Referenced tables include PA_CI_IMPACTS, which stores the impact records linking control items to plan versions; PA_BUDGET_VERSIONS, the budget and forecast plan version definitions; PA_PROJ_FP_OPTIONS, which holds funding and forecasting options per project; PA_AGREEMENTS_ALL, capturing project agreements; PA_PROJECTS_ALL, the master project table; and PA_FP_ROLLUP_TMP, a temporary table used in forecasting rollup processing. FND_NEW_MESSAGES is accessed for message resolution, and DUAL and PLITBLM are utility references. These tables confirm the package operates at the intersection of project control items and project planning/forecasting structures.

Usage Notes

The package is referenced by zero other packages in the ETRM repository, indicating it occupies a leaf position in the dependency graph and is invoked directly from Oracle forms, concurrent programs, or internal triggers within the Project Management suite rather than from other PL/SQL APIs. Because it is classified as OTHER, custom developers should treat it as an internal object: direct invocation is not supported, and Oracle may alter its behavior without notice between 12.1.1 and 12.2.2. Customizations that require control item impact maintenance should be routed through officially published Project APIs wherever possible.