Search Results pa_ci_supplier_pkg




Overview
Explore in AI Chat

Overview

PA_CI_SUPPLIER_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a component of the Projects (PA) module supporting the Capital/Construction Industry (CI) supplier integration functionality. The package is documented as VALID in both EBS 12.1.1 and 12.2.2. Its primary business function is to provide the low-level data manipulation routines that govern supplier records associated with project control items and CI supplier details. In practice, the package encapsulates the insert, update, delete, and locking logic for the PA_CI_SUPPLIER_DETAILS entity and its related project setup data, ensuring that changes to supplier-driven project structures are performed consistently and in conformity with the surrounding Project Control APIs.

The ETRM metadata classifies the object as API classification OTHER, indicating it is not a public, supported extension API in the same manner as PA_CONTROL_API_PUB, but rather an internal helper package consumed by the public and private Project Control APIs.

Key Procedures and Functions

The ETRM documentation records five subprograms within PA_CI_SUPPLIER_PKG, four of which are named:

  • INSERT_ROW — Creates a new supplier detail record in the CI supplier structures, populating the columns required for downstream project control processing.
  • UPDATE_ROW — Modifies an existing CI supplier detail record, typically as part of re-generation or maintenance of supplier definitions tied to project elements.
  • DELETE_ROW — Removes a CI supplier detail record, used during cleanup or replacement of supplier data on a project.
  • LOCK_ROW — Acquires a row-level lock on the target supplier record to prevent concurrent modification, following the standard EBS API pattern of lock-before-update.
  • A fifth documented subprogram is present in the package body; the metadata does not name it explicitly, so no parameter or purpose detail can be confirmed from the ETRM record.

None of the procedures should be assumed to expose a specific parameter list; the metadata confirms names and the conventional CRUD-plus-lock behaviour associated with EBS table-handler packages.

Tables Accessed

The package reads and writes a wide set of PA tables through APPS synonyms. Directly owned by the CI supplier function are PA_CI_SUPPLIER_DETAILS and its sequence-backed view PA_CI_SUPPLIER_DETAILS_S, which store the supplier detail rows the package maintains. Project structure context is drawn from PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEM_VER_STRUCTURE, and PA_TASKS. Financial and budgeting context is supplied by PA_BILL_RATES_ALL, PA_BUDGET_VERSIONS, and PA_PROJ_FP_OPTIONS. Resource and assignment data is retrieved from PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_ASSIGNMENTS_S, PA_RESOURCE_ASGN_CURR, and PA_RESOURCE_LIST_MEMBERS. Finally, PA_CONTROL_ITEMS holds the control item records that the supplier details support. PLITBLM is the standard PL/SQL table type used for bulk processing. These references confirm the package operates at the intersection of project structure, budgeting, and resource assignment data.

Usage Notes

PA_CI_SUPPLIER_PKG is referenced by five other packages, most notably PA_CI_SUPPLIER_UTILS, PA_CONTROL_API_PUB, and PA_CONTROL_API_PVT. This dependency chain indicates the package is invoked indirectly when users or concurrent programs call the public Project Control API to create, update, or remove control items that involve supplier details. It is therefore encountered during project setup and maintenance in Oracle Projects forms that drive the Control API, and during concurrent processes that regenerate control items or supplier allocations. Custom code should call the calling public APIs (such as PA_CONTROL_API_PUB) rather than this package directly, since PA_CI_SUPPLIER_PKG is an internal implementation detail subject to change between releases. Developers troubleshooting supplier-related project control errors should inspect this package's execution path through the Project Control private API.