Search Results ibe_active_quotes




Overview
Explore in AI Chat

Overview

The APPS.IBE_ACTIVE_QUOTES_ALL_PKG package body is a core data-maintenance component within the Oracle iStore (IBE) module of Oracle E-Business Suite. Its primary business function is to provide the procedural interface used to insert, update, and delete records held in the active quotes tables that underlie the iStore quoting and internet sales functionality. The _ALL suffix indicates that the package operates against the multi-organization (MLS/MOAC) flavor of the underlying entity, meaning it is designed to respect organization-level and language-level partitioning when manipulating quote data.

In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and is reported with a status of VALID per the ETRM repository. It is classified as an OTHER API rather than a standard FND-style public API. The package body wraps the Data Manipulation Language (DML) logic for the IBE_ACTIVE_QUOTES_ALL table and its associated objects, providing a controlled, reusable entry point so that forms, concurrent programs, and other PL/SQL units do not need to embed direct DML against these tables.

Key Procedures and Functions

The documented package body exposes three procedures. The parameter lists are not published in the ETRM metadata, so their signatures are not reproduced here.

  • INSERT_ROW — Creates a new active quote record in the underlying tables. This procedure encapsulates the required column population and any associated sequence or surrogate-key derivation needed to persist a new quote row within the correct organization and language context.
  • UPDATE_ROW — Modifies an existing active quote record. It applies changes to the persisted quote attributes while maintaining the integrity constraints defined on the underlying tables.
  • DELETE_ROW — Removes an active quote record from the multi-organization tables. It ensures the deletion targets the correct organizational row, consistent with MOAC conventions.

All three procedures rely on FND_API for standardized return-status handling and on FND_MESSAGE / FND_MSG_PUB for error and message management, which is typical of EBS data-maintenance APIs.

Tables Accessed

The package body references the following objects, resolved through APPS synonyms:

  • IBE_ACTIVE_QUOTES — The base (non-MLS) active quotes table. Referenced for the transactional quote data itself.
  • IBE_ACTIVE_QUOTES_ALL — The multi-organization / translated view or table that combines organization and language rows; the primary target of the INSERT, UPDATE, and DELETE operations.
  • IBE_ACTIVE_QUOTES_ALL_S1 — A supporting object, typically a sequence or index used during row creation and key generation.
  • DUAL — The standard SYS single-row table, used for lightweight scalar operations such as sequence lookups or constant evaluation.

Additional dependencies of note include FND_API, FND_GLOBAL, MO_GLOBAL, and FND_MSG_PUB, which together supply API status, session/organization context, and message stack services.

Usage Notes

Because IBE_ACTIVE_QUOTES_ALL_PKG is not referenced by any other database object per the ETRM dependency data, it is invoked directly by external callers rather than nested within another package. Typical invocation paths include:

  • Oracle iStore and quoting forms or UI flows that persist active quote header and line information on behalf of the end user.
  • Concurrent programs and batch processes that maintain or migrate active quote data.
  • Custom PL/SQL extensions and integrations that must create, change, or remove active quote records without issuing raw DML.

Callers should invoke these procedures within the correct FND_GLOBAL and MO_GLOBAL session context so that the operating organization and language are properly resolved. Since the package is an OTHER-classified API, it does not carry the same backward-compatibility guarantee as formal public APIs; usage should be validated against the target release (12.1.1 or 12.2.2) before deployment.