Search Results pa_copy_change_doc_pvt




Overview
Explore in AI Chat

Overview

PA_COPY_CHANGE_DOC_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a PVT (private) API within the Oracle Projects (PA) module. Its raison d'être is the duplication and adjustment of change document records used by Oracle Projects control item and change management functionality. Change documents in Oracle Projects capture scope changes, budget impacts, supplier details, and comments associated with control items tracked against a project. When a project manager or administrator elects to copy an existing change document — for example, to seed a new change request from a previously approved one — this package performs the underlying record-level copy operations across the Project Control Item (CI) related tables.

The package is formally documented in ETRM at status VALID and is present in both release 12.1.1 and 12.2.2. Because it is a PVT package, it is not intended for direct customer invocation; it should be called only from supported public APIs or standard Oracle Projects forms and concurrent programs.

Key Procedures and Functions

  • COPY_CHANGE_DOC — Performs the core copy of a change document, creating a new set of control item / change document rows derived from the source document. This is the principal entry point of the package and is responsible for the cross-table duplication logic that re-establishes relationships, impact type usage, and supplier detail records under the newly created document.
  • UPDATE_COMMENTS — Handles the comment records associated with a copied or modified change document. This procedure manages the insertion or maintenance of comment text in the PA_CI_COMMENTS table, ensuring the new document carries the appropriate comment history or refreshed commentary.
  • One additional documented subprogram exists in the package but is not individually named in the extracted metadata; practitioners should inspect ALL_ARGUMENTS in the dictionary for its signature.

Tables Accessed

The package reads and writes the following documented tables, all referenced through APPS synonyms:

  • PA_CONTROL_ITEMS — the master control item / change document header, the primary object copied.
  • PA_CI_ACTIONS — actions recorded against a change document; duplicated to preserve the action trail.
  • PA_CI_COMMENTS — comment lines maintained by UPDATE_COMMENTS.
  • PA_CI_IMPACT_TYPE_USAGE — records which impact types (cost, schedule, etc.) a document affects.
  • PA_CI_SUPPLIER_DETAILS — supplier-related change detail lines.
  • PA_BUDGET_VERSIONS — budget version context for the change.
  • PA_OBJECT_RELATIONSHIPS — the generic relationship model linking the change document to other project objects.
  • PA_PROJECT_STATUSES — used for status validation and derivation of the copied document's state.

Usage Notes

Because APPS.PA_COPY_CHANGE_DOC_PVT depends on FND_API and OKL_API, it operates within the standard OAF/Forms exception-handling framework and typically raises FND_API.G_EXC_ERROR style exceptions on validation failure. It is invoked indirectly — most commonly from the Oracle Projects change management forms or a supported public change document API, rather than by end users or custom code directly. Oracle recommends against calling PVT packages directly, since signatures may change between patches and point releases. Customizations requiring change document copy behavior should route through the supported public API layer or the seeded concurrent programs and forms that wrap this private package.