Search Results ibe_sh_quote_access_s1

Overview

IBE_QUOTE_SAVESHARE_V2_PVT is a private PL/SQL package body in the APPS schema that implements the version 2 quote save-and-share logic for Oracle iStore / Oracle Quoting within Oracle E-Business Suite 12.1.1 and 12.2.2. It is the successor to the original IBE_QUOTE_SAVESHARE_PVT and extends it to support version-2 sharing semantics, including shared-recipient records and the newer access model built around the IBE_SH_QUOTE_ACCESS table. The package orchestrates the transactional steps needed to persist a quote, register the parties with whom it is shared, create contact point records for e-mail delivery, and transition the quote between active and inactive (working versus shared) states.

Because the package is classified as a private (PVT) API, it is not intended as a public integration surface. It is invoked internally by higher-level public APIs and concurrent programs that manage quote lifecycle and collaboration. The ETRM metadata records its status as VALID and confirms that it is referenced by several other packages while itself depending on a wide range of ASO, IBE, HZ, and FND components.

Key Procedures and Functions

The documented package exposes eleven procedures. Their names and the described purposes are as follows:

• SAVE_CONTACT_POINT — Persists contact point information (typically e-mail addresses) for the parties receiving a shared quote, using the HZ contact point infrastructure.
• SAVE_SHARE_V2 — The primary entry point for version-2 quote sharing; records the sharing relationship and associated recipient details.
• SAVE_RECIPIENTS — Writes the list of recipients with whom the quote is shared, linking them to the quote access records.
• ACTIVATE_QUOTE — Transitions a quote into an active state, making it available for ongoing use.
• DEACTIVATE_QUOTE — Reverses activation, taking a quote out of the active working set.
• APPEND_QUOTE — Adds or appends quote content when extending an existing shared quote.
• STOP_SHARING — Terminates an existing sharing arrangement, removing recipient access.
• END_WORKING — Concludes the working (editing) phase of a quote, moving it to a non-working state.
• SHARE_READONLY — Shares a quote in a read-only mode where recipients can view but not modify it.
• DELETE_RECIPIENT — Removes an individual recipient from the sharing list and revokes that party’s access.
• VALIDATE_SHARE_UPDATE — Validates that a proposed sharing or update change is permissible before it is committed.

Tables Accessed

The package operates across several functional schemas through APPS synonyms. Quote header data is read and written in ASO_QUOTE_HEADERS and ASO_QUOTE_HEADERS_ALL, the base tables of Oracle Quoting. The active quote registry is maintained in IBE_ACTIVE_QUOTES, managed through IBE_ACTIVE_QUOTES_ALL_PKG. Sharing access is recorded in IBE_SH_QUOTE_ACCESS, with IBE_SH_QUOTE_ACCESS_S1 acting as a sequence for generating access identifiers. Recipient party data is drawn from HZ_PARTIES and HZ_CONTACT_POINTS (via HZ_CONTACT_POINT_V2PUB), and user identity is resolved from FND_USER. DUAL and PLITBLM are used for trivial selection and temporary ID list handling. The presence of the IBE_SH_QUOTE_ACCESS_S1 sequence is directly relevant to the searched term “ibe_sh_quote_access_s1” and underlies the primary keys of access records produced by this package.

Usage Notes

IBE_QUOTE_SAVESHARE_V2_PVT is invoked indirectly rather than directly by end users. Typical call paths originate from Oracle Quoting and iStore pages when a user saves a quote and elects to share it with other parties, and from the Oracle iStore administration interfaces that manage shared-quote access. It is called by IBE_QUOTE_SAVESHARE_V2_PVT’s sibling packages IBE_QUOTE_SAVE_PVT, IBE_SH_QUOTE_ACCESS_PKG, and IBE_QUOTE_SAVESHARE_PVT, and it references the ASO_QUOTE_PUB, FND_API, FND_MSG_PUB, and IBE_WORKFLOW_PVT APIs for its validation, messaging, and workflow interactions. Because it is a private body, custom code should prefer the public quoting and sharing APIs. When diagnosing shared-quote issues, the IBE_SH_QUOTE_ACCESS and IBE_SH_QUOTE_ACCESS_S1 objects identified here are the principal tables to inspect.