Search Results get_media

Overview

The APPS.IBE_PHY_MEDIA_PVT package is a private (PVT classification) PL/SQL API belonging to the Oracle iStore (IBE) product family within Oracle E-Business Suite. It exists to resolve the physical media assets associated with published or contextually stored content — for example, images, downloadable files, or collateral attached to a product, category, or storefront element — and to return the identifying metadata required to retrieve and render those assets. In release 12.1.1 and 12.2.2, this package is a low-level helper rather than a public integration surface; it is declared with AUTHID CURRENT_USER and exposes an API version constant (G_API_VERSION) set to 1.0, consistent with Oracle's private API conventions. The _PVT suffix signals that the package is intended for internal use by other iStore components and is not part of the supported public API contract for customer extensions.

Key Procedures and Functions

The package exposes a single documented procedure, GET_MEDIA. Its purpose is to take a content identifier, a category identifier, a display context name, a site identifier, and a language code as inputs, and to return the resolved physical media for that combination. The appropriate media file is located through the logical-to-physical mapping tables, and the procedure outputs the media file name, its description, and its file identifier so that the calling layer can construct a URL or otherwise serve the asset to the storefront. Because it is a private API, the exact parameter signatures should not be assumed by external code; integrators must reference the shipped source rather than treating the signature as a stable contract. The procedure is the only documented entry point, and no public wrapper or concurrent-program variant is documented in ETRM for this package.

Tables Accessed

The procedure is documented as referencing four tables through APPS synonyms:

• IBE_DSP_OBJ_LGL_CTNT — logical content records; supplies the P_PID and P_CATGID identifiers used to pinpoint the requested content.
• IBE_DSP_CONTEXT_B — display context definitions; supplies the access name (P_DCNAME) that selects the correct presentation context.
• IBE_DSP_LGL_PHYS_MAP — the logical-to-physical mapping that links logical content to concrete site and language variants; drives P_SITEID and P_LANGCODE resolution.
• JTF_AMV_ATTACHMENTS — the attachment repository holding the actual media file and its file identifier, which is what the procedure ultimately returns.

Together these tables form the chain from abstract content definition to a retrievable physical file.

Usage Notes

Because IBE_PHY_MEDIA_PVT is an internal iStore package, it is typically invoked by other IBE packages and storefront rendering logic rather than directly by Forms or concurrent programs. It is most relevant in multilingual or multi-site iStore deployments where the same logical content resolves to different physical media per language and per site, and where context (for example, a device- or channel-specific view) determines which asset is served. Customizations should prefer the supported public iStore APIs and should treat this package as subject to change without notice between patch levels and between 12.1.1 and 12.2.2. When diagnosing missing or incorrect storefront media, this package and its four referenced tables are the correct starting point for tracing how a logical content item is mapped to its physical attachment.