Results for “csf_ib”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.CSF_IB is a public PL/SQL package body in Oracle E-Business Suite that provides a programmatic wrapper for Oracle Installed Base operations. Its documented API classification is OTHER, and it is owned by the APPS schema. The package encapsulates the creation of customer products (instances) and the association of shipment and serial number information against those instances. It is intended for callers that require a simplified, stable entry point to Installed Base functionality, particularly the creation of base products from external or feeder flows such as order fulfillment, inventory shipping, or service fulfillment. The package header revision recorded in the source excerpt is csfibasb.pls 120.2.12000000.2, dated 2007/07/26, indicating that this is a long-standing component carried forward into the 12.1.1 and 12.2.2 releases. The package body declares five documented procedures: CREATE_BASE_PRODUCT1, CREATE_BASE_PRODUCT2, REPLACE_PRODUCT, UPDATE_PRODUCT, and UPDATE_INSTALL_BASE.
Key Procedures and Functions
CREATE_BASE_PRODUCT1 is the primary wrapper procedure. It accepts an API version, standard return status and message outputs, and a set of product attributes including customer identifier, inventory item identifier, status, quantity, unit of measure, currency, delivered flag, and installation date. It builds an Installed Base customer product record and delegates to CS_INSTALLEDBASE_PUB.CREATE_BASE_PRODUCT. When the underlying call succeeds and a serial number is supplied, the procedure then constructs a shipment record and invokes CS_INSTALLEDBASE_PUB.RECORD_SHIPMENT_INFO to attach shipping quantity, shipped date, and serial number to the newly created instance.
CREATE_BASE_PRODUCT2 provides the alternate creation path, typically used where the caller must distinguish between the base product creation step and a companion shipment or serial tracking step. REPLACE_PRODUCT supports substitution of an existing customer product, addressing scenarios such as returns followed by replacement shipments or warranty swaps. UPDATE_PRODUCT modifies attributes of an existing instance, preserving the instance identifier and object version for optimistic locking. UPDATE_INSTALL_BASE performs the broader update against the installed base record, allowing the caller to refresh instance data without recreating it. Each procedure follows Oracle's API conventions, taking p_api_version and returning x_return_status, x_msg_count, and x_msg_data.
Tables Accessed
The documented metadata does not enumerate the underlying tables because the package operates entirely through the Installed Base public APIs rather than issuing direct SQL. Internally, CS_INSTALLEDBASE_PUB manipulates the base tables that store customer product instances, status assignments, shipment and serial number associations, and object versioning records. Because APPS.CSF_IB carries no direct table references, all insert and update activity is subject to the validation, security, and message handling enforced by the Installed Base API layer itself.
Usage Notes
This package is referenced by one other package in the documented dependency set and is classified as a public API for Installed Base operations. It is typically invoked from custom PL/SQL that must register an instance outside of standard Order Management or Service flows, from forms-based extensions, or from concurrent programs that reconcile shipped inventory items against Installed Base records. Callers should check x_return_status against FND_API.G_RET_STS_SUCCESS before proceeding, and should note that CREATE_BASE_PRODUCT1 invokes shipment recording only when the instance creation succeeds and a serial number value is present. The dropbox reference accompanying the user's search is unrelated to the package's functional behavior.
-
PACKAGE BODY: APPS.CSF_IB 12.2.2
-
PACKAGE: APPS.CSF_IB 12.1.1
-
PACKAGE BODY: APPS.CSF_IB 12.1.1
-
PACKAGE: APPS.CSF_IB 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.CSF_IB 12.2.2
-
PACKAGE: APPS.CSF_IB 12.1.1
-
PACKAGE BODY: APPS.CSF_IB 12.2.2
-
PACKAGE BODY: APPS.CSF_IB 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1