Search Results delete_recipient




Overview
Explore in AI Chat

Overview

IBE_QUOTE_SAVESHARE_V2_PVT is a private PL/SQL package in the APPS schema that supports the iStore (Oracle iStore / IBE) quote sharing and collaboration framework in Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to persist and manage the state of a sales quote that one user shares with other users or contact points, and to control the lifecycle transitions of that quote between working, active, read-only, and stopped-sharing conditions. The "_PVT" suffix classifies the package as a private API: it is not intended to be called directly from external integrations, but rather is invoked by the public iStore quote packages that expose the quoting and checkout flows. It supplements the earlier IBE_QUOTE_SAVESHARE_PVT package, providing the incrementally extended sharing semantics required by later quoting and one-click ordering features.

Key Procedures and Functions

  • SAVE_SHARE_V2 — The principal entry point for persisting a quote-share operation. It writes the sharing relationships that grant other users or contact points access to the quote.
  • SAVE_CONTACT_POINT — Persists contact point information associated with the share, typically resolving or creating HZ contact point records used as share recipients.
  • SAVE_RECIPIENTS — Records the set of recipients to whom the quote is being shared.
  • ACTIVATE_QUOTE — Transitions a shared quote into its active state, making it available to the participating users.
  • DEACTIVATE_QUOTE — Reverses the active state, suspending access without destroying the share definition.
  • APPEND_QUOTE — Adds or appends quote content to an existing shared quote context.
  • STOP_SHARING — Terminates an existing share, revoking recipient access to the quote.
  • END_WORKING — Closes the working state of a quote, marking the collaborative editing phase complete.
  • SHARE_READONLY — Establishes or converts a share to read-only, preventing recipients from modifying quote content.
  • DELETE_RECIPIENT — Removes a single recipient from an existing share.
  • VALIDATE_SHARE_UPDATE — Performs validation checks before a share update is committed, ensuring the requested transition is permitted.

Tables Accessed

  • IBE_SH_QUOTE_ACCESS / IBE_SH_QUOTE_ACCESS_S1 — The core sharing-access table (and its sequence) holding recipients, access levels, and share state. This is the primary read/write target for SAVE_SHARE_V2, SAVE_RECIPIENTS, DELETE_RECIPIENT, and SHARE_READONLY.
  • IBE_ACTIVE_QUOTES — Tracks quotes in an active state; maintained by ACTIVATE_QUOTE and DEACTIVATE_QUOTE.
  • ASO_QUOTE_HEADERS / ASO_QUOTE_HEADERS_ALL — The Oracle Quoting (ASO) quote headers, referenced to validate and update the underlying quote record.
  • HZ_CONTACT_POINTS and HZ_PARTIES — Oracle Trading Community (HZ) tables used to resolve recipient contact points and parties for SAVE_CONTACT_POINT.
  • FND_USER — Referenced to validate recipient user identities.
  • DUAL and PLITBLM — Utility references (PLITBLM is the PL/SQL integer table type used for bulk/array processing).

Usage Notes

This package is not a public API. It is invoked indirectly through the iStore quoting stack: IBE_QUOTE_SAVESHARE_PVT, IBE_QUOTE_SAVE_PVT, IBE_QUOTE_CHECKOUT_PVT, IBE_QUOTE_MISC_PVT, IBE_ORD_ONECLICK_PVT, and IBE_QUOTE_W2_PVT all reference it. It depends on ASO_QUOTE_PUB and FND_API, indicating it participates in the standard ASO quoting API and returns data in the FND_API message/error convention. Typical invocation occurs when a user shares a saved quote from the iStore or Quoting UI, when a one-click order is placed against a shared quote, or during checkout of a shared quote. Because it is private and schema-owned by APPS, customizations should call the public iStore quote APIs rather than this package directly. In 12.2.2, the online patching (AD/TXK) editions model applies standard editioning considerations to the package body.