Search Results ibe_phy_media_pvt




Overview
Explore in AI Chat

Overview

IBE_PHY_MEDIA_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle iStore (IBE) product family. Its responsibility is to resolve and return the physical media — for example, product images, thumbnails, and other binary attachments — that are associated with catalog entities displayed through the iStore storefront. The package functions as the private implementation layer (the PVT suffix denotes a private, internal API) behind media retrieval logic that iStore publishing and storefront rendering rely upon. Business users do not call this package directly; it is invoked by other iStore components to present the correct asset for a product, category, or legal content entity in a given display context.

The documented object is a VALID package body in ETRM 12.2.2, and it depends on the public specification IBE_PHY_MEDIA_PVT. Its dependency list also includes the iStore display context, entity-mapping, and object-content objects, as well as the generic attachment and media item infrastructure in JTF. The API classification is PVT, confirming that it is not part of the supported public integration surface.

Key Procedures and Functions

The ETRM metadata documents a single public subprogram exposed by this package body:

  • GET_MEDIA — Returns media associated with a catalog or display entity. In the iStore context this procedure resolves the physical media asset that should be shown for the requested entity, honoring the active display context and any legal or object-level content mapping. Because the procedure signature is not published in the metadata, callers must not assume a parameter list; the routine is intended for internal consumption only.

The package also has access to the standard Oracle E-Business Suite API error and message infrastructure through FND_API and FND_MSG_PUB, which indicates that GET_MEDIA follows the conventional EBS API error-handling pattern, populating the message stack and returning a status to its caller rather than raising unhandled exceptions.

Tables Accessed

The documented table dependencies, resolved through APPS synonyms, are:

  • IBE_DSP_CONTEXT_B — The display context base table. It supplies the context under which media is rendered, allowing the package to return the correct asset for a given storefront presentation.
  • IBE_DSP_LGL_PHYS_MAP — The mapping table between legal entities and physical media. It identifies which physical medium applies to a display object in a particular legal or organizational context.
  • IBE_DSP_OBJ_LGL_CTNT — The object-level legal content table. It links display objects to their authorized content, which the media lookup must respect.
  • JTF_AMV_ATTACHMENTS and JTF_AMV_ITEMS_VL — The shared attachment and media-item views used across EBS to store and retrieve the actual media files and their descriptive metadata.

The package is a read-only consumer of these tables; no insert, update, or delete behavior is documented. No other database object references IBE_PHY_MEDIA_PVT, underscoring its role as a leaf-level implementation package.

Usage Notes

IBE_PHY_MEDIA_PVT is invoked indirectly during iStore storefront rendering and publishing operations whenever a media asset must be resolved for a display object. Typical entry points are other iStore PL/SQL packages, iStore JSP or Java components, and the iStore administrative UI, all of which call the public specification to fetch media. Because the API classification is PVT and the package is referenced by zero other objects according to ETRM, customizations should not call it directly; the supported approach is to use the corresponding public iStore APIs or the storefront views. Customers extending iStore media display should treat this package as internal and expect its signature and behavior to change without notice in future releases.