Search Results create_relationship

Overview

IBE_Quote_Rel_Obj_Pvt is a private PL/SQL API package in the Oracle E-Business Suite (EBS) iStore/Quoting module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It manages the association between a quote and the various business objects that are related to that quote, such as products, configurations, or other quote-line artifacts. The package provides a controlled, API-based mechanism for establishing and removing these relationships rather than allowing direct DML against the underlying quote relationship tables.

Because the package is classified as PVT, it is intended for internal use by Oracle's own iStore and Quoting application code rather than as a publicly documented integration point. The header comment identifies the file as IBEVQROS.pls, version 115.1, last shipped in December 2002, indicating this is a long-standing component of the quoting infrastructure.

Key Procedures and Functions

The package exposes two documented procedures.

• Create_Relationship — Establishes a relationship between a quote object (identified by a quote object type code and quote object ID) and a related business object (identified by an object type code and object ID). The relationship is qualified by a relationship type code and controlled by flags that govern whether the relationship is one-to-one and whether it applies to all versions of the quote. The procedure returns the generated related object identifier to the caller through an OUT parameter.
• Delete_Relationship — Removes an existing relationship between a quote object and a related object, using the same identifying parameters as Create_Relationship. A flag indicates whether the deletion should apply across all versions of the quote.

Both procedures follow the standard Oracle EBS API convention, accepting p_api_version, p_init_msg_list, and p_commit parameters, and returning x_return_status, x_msg_count, and x_msg_data so callers can evaluate success or failure and retrieve error messages.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• ASO_QUOTE_HEADERS — The quote header table, which stores the top-level quote record. The package references it to validate and locate the quote to which a relationship is being attached.
• ASO_QUOTE_RELATED_OBJECTS — The primary table holding the actual relationship records linking a quote to its related objects. Create_Relationship inserts here; Delete_Relationship removes rows here.
• PLITBLM — The standard EBS PL/SQL message table used by the FND message-handling framework to store and retrieve API error and warning messages.

Usage Notes

IBE_Quote_Rel_Obj_Pvt is typically invoked from the iStore and Quoting application logic, including Oracle Forms-based quote entry screens and related concurrent or Java-based processes that manipulate quote contents. The Create_Relationship procedure is called when a user or process attaches an object to a quote, while Delete_Relationship — the procedure of interest for the search term "delete_relationship" — is called when that association is removed, such as when a user detaches a product or related object from an existing quote.

Since the package is classified as PVT and referenced by no other packages in the documented metadata, custom code should generally avoid calling it directly and should instead rely on the supported public quoting APIs. Where direct invocation is necessary, callers must respect the FND_API conventions: initialize the message list, inspect x_return_status, and manage commit behavior explicitly through p_commit. The p_for_all_versions parameter deserves particular attention, as it determines whether the deletion affects only the current quote version or every version in the quote's history.