Search Results update_cp_status

Overview

CS_INSTALLEDBASE_PVT is the private implementation package body for the Oracle E-Business Suite Installed Base (Service) module. It carries the actual business logic behind the public package CS_INSTALLEDBASE_PUB, exposing the PL/SQL procedures that create, update, upgrade, and maintain customer product (CP) records in the installed base. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package is central to tracking the lifecycle of shipped products, including revisions, pricing attributes, descriptive flexfields, status changes, and contact assignments. The package follows the standard EBS API architecture: a public (PUB) specification defines the interface and record types, while this private (PVT) body implements the logic and is not intended for direct invocation by external callers.

The header comment ($Header: csvibb.pls 115.117 2003/01/28) indicates the file is named csvibb.pls, has been through 117 version iterations, and dates back well into the 11i lineage, which explains its continued presence unchanged in later 12.x releases.

Key Procedures and Functions

The documented metadata lists eleven procedures/functions. Their purposes are:

• INITIALIZE_DESC_FLEX — Populates descriptive flexfield segments for a customer product record during create or update operations.
• INITIALIZE_PRICE_ATTRIBS — Initializes pricing attribute fields on a customer product record, supporting service contract and pricing integration.
• CASCADE_TO_CHILD_ENTITIES — Propagates changes (such as splits or merges) from a parent customer product to its child entities; in the excerpt the body is a stub (null).
• CREATE_BASE_PRODUCT — Creates the base (top-level) customer product record in the installed base.
• CREATE_REVISION — Creates a new revision of an existing customer product.
• UPDATE_REVISION — Modifies attributes of an existing revision.
• RECORD_SHIPMENT_INFO — Records shipment information against a customer product, linking the installed base record to the shipment that delivered it. This is the procedure relevant to the user’s search term.
• UPGRADE_PRODUCT — Upgrades an installed product to a newer product or revision level.
• UPDATE_PRODUCT — Updates existing customer product record attributes.
• SPECIFY_CONTACT — Associates a contact party with a customer product record.
• UPDATE_CP_STATUS — Changes the status of a customer product (for example, active, inactive, or returned).

Note that Cascade_To_Child_Entities, Record_Split_In_Audit, Initialize_Order_Info, and Initialize_CP_Rec_Param also appear in the source excerpt as private helpers; several are currently implemented as null stubs, reflecting incomplete or deprecated logic retained for signature compatibility.

Tables Accessed

The ETRM metadata does not enumerate specific tables referenced by this package. Based on the Installed Base data model, the package operates against the CS_* schema tables such as CS_INSTALLED_BASE and its associated revision, pricing, flexfield, and shipment detail tables, accessed through APPS synonyms. Because the metadata lists no explicit table list, exact table usage should be confirmed by inspecting the package body in the target instance or by querying DBA_DEPENDENCIES.

Usage Notes

CS_INSTALLEDBASE_PVT is a private package and is referenced by zero other packages per the ETRM metadata. It is not a public entry point; callers should invoke CS_INSTALLEDBASE_PUB, which internally delegates to this body. In practice it is exercised by Installed Base forms, service-related concurrent programs, and custom integrations that create or maintain customer product records. When troubleshooting the record_shipment_info search term, inspect the RECORD_SHIPMENT_INFO procedure here together with its public wrapper in CS_INSTALLEDBASE_PUB.