Search Results ibe_sh_quote_access_pkg




Overview
Explore in AI Chat

Overview

IBE_SH_QUOTE_ACCESS_PKG is an Oracle EBS PL/SQL package body owned by the APPS schema. It resides within the iStore/IBE (Internet Business Exchange) product family, specifically the Sales and Hosting (SH) module area dealing with quote access control. The package serves as the programmatic interface for managing access rights to sales quotes stored in Oracle iStore and related quoting components. Its primary business function is to create, maintain, and remove records in the quote access repository so that the correct parties — customers, contacts, or internal users — are granted or denied visibility and modification privileges on a given quote.

The package is classified as OTHER in the ETRM documentation, and its body status is VALID. It is a low-level data-manipulation layer, relying on Oracle's FND_API error-handling conventions and FND_GLOBAL for session context such as user ID, login ID, and responsibility. It is documented as not being referenced by any database object, indicating that it normally executes as a top-level routine invoked directly by application code, forms logic, or concurrent processing rather than being embedded in other database-level constructs.

Key Procedures and Functions

The documented public API consists of three procedures, each following a conventional DML verb pattern:

  • INSERT_ROW — Establishes a new quote access record, assigning access privileges to a designated party for a specified quote. This is the entry point used when a quote is created or when a new participant must be granted access.
  • UPDATE_ROW — Modifies an existing access record, allowing changes to the nature or level of the privilege already associated with a quote and party combination.
  • DELETE_ROW — Removes an access record, revoking a previously granted quote access right.

Parameter lists are not enumerated in the ETRM excerpt and must be obtained from the source definition. All three procedures interact with the APPS synonym for the underlying access table and honor FND_API conventions for success/failure signaling.

Tables Accessed

The package accesses a single documented table through its APPS synonym:

  • IBE_SH_QUOTE_ACCESS — The repository of quote access grants. Each row associates a quote with a party and its permitted access level. INSERT_ROW writes new grants, UPDATE_ROW modifies them, and DELETE_ROW removes them.

Dependency metadata further confirms references to STANDARD (the package specification) and to FND_API and FND_GLOBAL for error handling and session context retrieval.

Usage Notes

IBE_SH_QUOTE_ACCESS_PKG is typically invoked from Oracle iStore/Sales quoting applications whenever the access control list of a quote changes — during quote creation, participant assignment, or quote closure. Because the package is not referenced by any database object, it must be called explicitly by forms, OAF pages, concurrent programs, or custom extensions. The package exposes a specification (IBE_SH_QUOTE_ACCESS_PKG) as its callable interface, and the ETRM metadata notes that it is referenced by two other packages, indicating integration points within the IBE quoting stack. Developers extending quote access behavior should call these procedures rather than manipulating IBE_SH_QUOTE_ACCESS directly, so that FND_API validation and error conventions are preserved.