Search Results ibc_citem_runtime_pvt




Overview
Explore in AI Chat

Overview

IBC_CITEM_RUNTIME_PVT is a private PL/SQL package in the APPS schema that supports the runtime infrastructure for Oracle iStore / Oracle Content Items (IBC) functionality in Oracle E-Business Suite 12.1.1 and 12.2.2. Content items in EBS are structured, versioned, translatable storefront content elements — titles, images, rich text blocks, style associations, and compound relationships between reusable content assets. This package sits beneath the public API layer, IBC_CITEM_RUNTIME_PUB, and performs the heavy-lifting logic that the public package exposes to callers. Its classification as a PVT (private) package indicates it is not intended for direct invocation by external code, forms, or concurrent programs; instead, it is consumed internally by the corresponding PUB package and by the IBC_STYLESHEETS_GRP style-sheet group logic. The package encapsulates validation, metadata retrieval, XML generation, bulk loading, translated-content loading, version-number resolution, and association loading for content items.

Key Procedures and Functions

Nine documented procedures/functions are listed; the eighth, together with the others above, forms the operational core invoked by IBC_CITEM_RUNTIME_PUB.

Tables Accessed

  • IBC_CONTENT_ITEMS — The primary content item master, read and written during loading and validation.
  • IBC_CITEM_VERSIONS_B / IBC_CITEM_VERSIONS_TL — Base and translated version records; the TL table supports multilingual content.
  • IBC_CITEM_VERSION_LABELS — Stores labels used to identify and select content-item versions.
  • IBC_ASSOCIATIONS / IBC_COMPOUND_RELATIONS — Model relationships and compound structures among content items, populated by LOAD_ASSOCIATIONS.
  • FND_LOOKUP_VALUES — Provides reference lookup values used for validation and display.
  • DBMS_LOB / PLITBLM — Utility packages for LOB handling and PL/SQL table management during XML generation and bulk operations.

Dependencies also include FND_API (for the standard API error-handling framework) and JTF_CLOB_TABLE, JTF_NUMBER_TABLE, and JTF_VARCHAR2_TABLE_100 (for bulk parameter passing).

Usage Notes

Because IBC_CITEM_RUNTIME_PVT is a private package, it is not invoked directly from Oracle Forms, concurrent programs, or custom integrations. It is referenced by IBC_CITEM_RUNTIME_PUB (the public API entry point), by the IBC_STYLESHEETS_GRP concurrent program group, and recursively by itself. Callers requiring content-item validation, metadata retrieval, XML generation, bulk loading, translated-content loading, version resolution, or association loading should route through IBC_CITEM_RUNTIME_PUB, which wraps this private logic with the FND_API standard error and message conventions. In both 12.1.1 and 12.2.2, the package remains VALID and functions identically as part of the content-item runtime stack. Custom code should never call the private routines directly, as signatures and behavior are subject to change without public-API notice.