Search Results as_opp_competitor_pvt




Overview
Explore in AI Chat

Overview

The AS_OPP_COMPETITOR_PVT package body in the APPS schema implements the private application programming interface for managing competitor information associated with Oracle E-Business Suite opportunity and lead records. It forms part of the Oracle Sales (AS) module's PL/SQL API infrastructure, which underpins the Sales Foundation, Leads, and Opportunities functionality. The PVT suffix designates this as a private package — it is not intended to be called directly by external consumers; rather, it is invoked internally by the corresponding public API and by the sales forms and concurrent processes that manage opportunity data.

The package's business responsibility is to handle the competitor records that sales representatives attach to leads and opportunities, allowing organizations to track which competing vendors are involved in a given sales pursuit. It encapsulates the create, update, and delete lifecycle operations for these competitor associations, together with the validation logic that enforces data integrity and security constraints before records are persisted.

Key Procedures and Functions

The documented package exposes nine procedures and functions, grouped into two functional categories: data manipulation and validation.

The validation routines apply the ARS/lead-and-opportunity business rules, including the security checks implemented through the access and sales-organization manager packages referenced as dependencies.

Tables Accessed

The package operates against the following tables, accessed through APPS synonyms:

  • AS_LEADS_ALL — The base table holding lead and opportunity header records; used to confirm the parent record to which competitors are attached.
  • AS_LEAD_COMPETITORS — The primary transaction table in which competitor associations are created, updated, and deleted.
  • HZ_PARTIES — The Trading Community Architecture parties table, consulted to validate the competitor as a legitimate, registered party.
  • PLITBLM — An internal PL/SQL index-by table used for bulk processing of identifiers during validation loops.

Usage Notes

Because AS_OPP_COMPETITOR_PVT is a private package, it is not intended for direct invocation by external application code. It is called by the public sales APIs and by the Oracle Sales forms that present competitor information on the lead and opportunity screens. Its dependencies on AS_OPPORTUNITY_PUB, AS_SALES_MEMBER_PUB, AS_ACCESS_PUB, and AS_SALES_ORG_MANAGER_PVT indicate that it participates in the standard opportunity security model, enforcing visibility rules based on sales organization and membership. Customizations should call the corresponding public APIs rather than this private package to preserve upgrade safety across EBS 12.1.1 and 12.2.2.