Results for “ibe_attachment_grp”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IBE_ATTACHMENT_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the iStore (IBE) product family and is classified in the ETRM repository as a Group (GRP) API, indicating that its entry points orchestrate related operations against multiple underlying objects rather than exposing a single entity-level API. The package provides the procedural interface through which iStore and related e-commerce modules manage file attachments associated with store content, deliverables, and media objects. It encapsulates the logic required to enumerate, persist, and remove attachment records while delegating standard error handling and message construction to FND_API, the EBS common API utility package. Because the object status is VALID in both releases, the package is considered a supported and functioning component of the application tier.

Key Procedures and Functions

The ETRM documentation identifies four documented procedures and functions within the package, of which three are explicitly named:

• LIST_ATTACHMENT — Retrieves attachment information associated with a given business entity and returns it to the caller, typically for display in a form, table, or storefront page.
• SAVE_ATTACHMENT — Persists attachment metadata, handling both the insertion of new attachment records and the update of existing ones.
• DELETE_ATTACHMENT — Removes an attachment record and its associated metadata reference from the underlying attachment store.

The remaining documented unit is not individually named in the available metadata. Consistent with the GRP classification, the package exposes these operations as a cohesive group, and parameter lists should be verified against the deployed package specification for the specific release rather than assumed.

Tables Accessed

The package references two tables through APPS synonyms:

• JTF_AMV_ATTACHMENTS — The shared attachment repository used across EBS modules to store media and document attachment records. IBE_ATTACHMENT_GRP reads and writes here to manage the attachment lifecycle.
• PLITBLM — A PL/SQL index-by table type used for bulk processing and the structured passing of attachment data between procedures.

Usage Notes

IBE_ATTACHMENT_GRP is not typically invoked directly by end users. It is called by higher-level iStore packages, including IBE_ATTACHMENT_GRP_W (the wrapper), IBE_DELIVERABLE_GRP, and IBE_DELIVERABLE_EXPIMP_PVT, which drive attachment handling during deliverable management and import/export processing. Customizations that need to create, list, or remove storefront attachments should call the package's public procedures rather than issuing direct DML against JTF_AMV_ATTACHMENTS, so that FND_API validation and error handling are preserved. At runtime the package depends on APPS.FND_API and the SYS.STANDARD library. Because it is part of the APPS schema, grants are normally made through the standard APPS privilege model, not to individual schemas.