Search Results ibe_dsp_dlv_not_exists

Overview

The APPS.IBE_DELIVERABLE_GRP package is a PL/SQL group or "GRP" classified API belonging to the Oracle iStore (IBE) application family within Oracle E-Business Suite 12.1.1 and 12.2.2. It provides the core programmatic interface for managing deliverable definitions used by the iStore content authoring and personalization framework. Deliverables in iStore represent units of content — such as media files, documents, images, or other assets — that can be associated with storefront pages, catalog sections, or merchandising regions. The package abstracts the underlying data manipulation logic so that deliverables may be created, updated, retrieved, and removed through a consistent, callable interface rather than through direct table access. It is registered in the ETRM as VALID with the APPS schema as owner and is exposed as a public group API, meaning it is intended to be invoked by other iStore packages, forms, or custom extensions rather than executed standalone.

Key Procedures and Functions

The package exposes three documented procedures that form its primary public interface. While the ETRM metadata records seven total documented program units, only the following are named in the available documentation:

• LIST_DELIVERABLE — Retrieves and returns deliverable records, typically as a result set or collection, for display or downstream processing. It supports the query-side of the deliverable lifecycle, allowing callers to enumerate deliverables matching defined criteria.
• SAVE_DELIVERABLE — Handles both insertion of new deliverables and update of existing ones. It encapsulates validation of the deliverable attributes and enforces business rules prior to persistence.
• DELETE_DELIVERABLE — Removes a deliverable definition from the repository, applying any referential or dependency checks required to maintain data integrity.

These three operations constitute a conventional CRUD-style API set. No parameter lists are documented in the ETRM extract, and callers should consult the package specification in the database for exact signatures.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed via an APPS synonym. PLITBLM is an Oracle-supplied PL/SQL table type used as a generic multi-purpose collection or temporary storage structure. In the context of deliverable management, it likely serves as an in-memory buffer for passing sets of deliverable identifiers or attribute values between the API and its callers, or for staging rows during list and save operations. The package does not appear to write directly to iStore deliverable base tables based on the documented metadata; instead, persistence of deliverable data is presumed to be delegated to the worker package IBE_DELIVERABLE_GRP_W, which this API wraps. Callers should be aware that PLITBLM is a transient structure and does not represent persistent application data.

Usage Notes

IBE_DELIVERABLE_GRP is typically invoked from iStore administrative forms and from other iStore PL/SQL packages rather than from concurrent programs directly. The ETRM dependency report confirms that it is referenced by IBE_DELIVERABLE_EXPIMP_PVT (the deliverable import/export private API), IBE_DELIVERABLE_GRP_W (its worker implementation), and IBE_DSP_HIERARCHY_SETUP_PVT (the display hierarchy setup package). This dependency profile indicates that deliverables are managed as part of broader iStore merchandising and hierarchy configuration flows. Custom code extending iStore content management should call this API rather than manipulating deliverable tables directly, to preserve validation and consistency. Because the package depends on FND_API, error handling follows the standard Oracle Application Object Library API convention, with callers expected to inspect the returned success/failure flags and message stacks. As with all APPS-owned APIs, direct modification is unsupported; upgrades in 12.2.2 may alter internal behavior, and customizations should be confined to wrapper code.