Search Results csicumpi_pub




Overview
Explore in AI Chat

Overview

CSICUMPI_PUB is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified as a public API (PUB). It belongs to the Customer Support / Install Base product family, whose object prefix "CSI" denotes the CSI (Common Install Base, historically "Customer Support Install Base") schema. The package encapsulates the business logic required to resolve party, account, and instance relationships for customer-facing install base entities. In practical terms, it provides a programmatic interface for retrieving information about non-primary parties associated with a customer account or install base instance, resolving the root instance of an item hierarchy, identifying the applicable root identifier, and determining whether a given node has children.

Because the package is a PUB API, it is intended to be called by external consumers — forms, concurrent programs, workflow, and custom extensions — rather than being invoked only internally. The ETRM metadata confirms its dependency graph, which reaches into both the Install Base tables (CSI_ITEM_INSTANCES, CSI_II_RELATIONSHIPS) and the Trading Community Architecture (TCA) tables (HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES), reflecting the package's role as a bridge between install base instance hierarchies and customer/party data.

Key Procedures and Functions

The ETRM documentation lists five public program units. Descriptions follow from documented metadata only; parameter signatures are not published and are deliberately omitted.

  • GET_NON_PRIMARY_PARTY_LIST — Retrieves the list of parties associated with an account or instance that are not designated as the primary party. Used to surface secondary contacts, owners, or responsible parties in support and service scenarios.
  • GET_PART_INFORMATION — Returns party-related information for a given install base entity, resolving party attributes through the TCA tables and the account/party relationship structure.
  • GET_ROOT_INFORMATION — Returns descriptive information about the root instance of a hierarchy, typically the top-level item instance from which downstream children derive.
  • GET_ROOT_ID — Returns the identifier of the root instance for a given node in the install base hierarchy. A lightweight lookup frequently used before calling GET_ROOT_INFORMATION.
  • GET_CHILDREN_FLAG — Returns a flag indicating whether a specified instance node has any child instances in CSI_II_RELATIONSHIPS. Used by UI logic to decide whether to expand a tree node.

Tables Accessed

  • CSI_ITEM_INSTANCES — Core install base instance records; source of item instance identity and attributes.
  • CSI_II_RELATIONSHIPS — Defines parent/child relationships between instances, enabling root and children resolution.
  • HZ_PARTIES — Master party records; provides party names and identifiers.
  • HZ_CUST_ACCOUNTS — Customer account records linked to parties, used to scope party lookups.
  • HZ_CUST_ACCOUNT_ROLES — Role assignments (for example, primary or non-primary) that drive non-primary party filtering.
  • MTL_SYSTEM_ITEMS_KFV — Key flexfield view of inventory items, used to describe the item behind an instance.

Read access dominates; the package is primarily query-oriented and does not appear to write to these base tables.

Usage Notes

CSICUMPI_PUB is referenced by 25 other packages, indicating wide internal reuse across the Install Base and Service product suites. It is typically invoked from Install Base and Service forms (for example, instance and party detail regions), from concurrent programs that process install base hierarchies, and from custom PL/SQL that needs to resolve root instances or enumerate non-primary parties without reimplementing the underlying joins. Callers should rely on the public specifications, observe FND_API and FND_MSG_PUB error-handling conventions, and avoid direct dependence on internal logic. Behavior is consistent across EBS 12.1.1 and 12.2.2.