Search Results as_opp_copy_pvt




Overview
Explore in AI Chat

Overview

APPS.AS_OPP_COPY_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Oracle Sales (AS) module. It implements the server-side logic that supports the "Copy Opportunity" business function, allowing a user or process to duplicate an existing opportunity record while selectively carrying forward its dependent detail records. The package is declared with AUTHID CURRENT_USER, meaning it executes under the privileges of the invoking schema, and it is built on the Oracle EBS PL/SQL API framework, as evidenced by the standard API parameters (p_api_version_number, p_init_msg_list, p_commit, p_validation_level) exposed through the FND_API package. The header comment dates to 2000, with the sourced revision ($Header: asxvlcps.pls 115.8) last updated in December 2002, and the documented metadata applies to both 12.1.1 and 12.2.2. The package is classified as private because it is not intended as a public, committed integration point; it is an internal implementation invoked by other sales packages and forms.

Key Procedures and Functions

The package exposes a single documented program unit, the procedure COPY_OPPORTUNITY. Its stated purpose is to copy an existing opportunity header, with configurable options to also copy the sales team, opportunity lines, sales credits, contacts, competitors, and methodology. The documented parameter intent shows that the copy behavior is governed by individual Boolean-style flags, and the metadata records two important constraints:

  • If sales credits are to be copied, opportunity lines must also be copied.
  • If the sales team is not copied, it is defaulted exactly as it would be when creating a new opportunity; if sales credits are not copied, they are defaulted 100 percent to the logged-on salesforce.

The procedure identifies the source opportunity through an opportunity/lead identifier and accepts a description for the new opportunity, together with targets such as a new customer identifier. No parameter lists are invented here; the documented signature reflects the standard EBS API conventions.

Tables Accessed

The package reads from and writes to the core Oracle Sales opportunity and lead tables referenced through APPS synonyms. It accesses AS_LEADS_ALL, which stores the opportunity header and source record, and copies associated detail records into AS_LEAD_LINES_ALL (opportunity lines), AS_SALES_CREDITS (sales credit assignments), AS_LEAD_COMPETITORS and AS_LEAD_COMP_PRODUCTS (competitor and competitor-product data), and AS_LEAD_DECISION_FACTORS (decision-maker information). Resource references, such as sales team members, are resolved against JTF_RS_RESOURCE_EXTNS. Collectively these tables allow the copy operation to reproduce both the opportunity header and its configurable child records.

Usage Notes

Because AS_OPP_COPY_PVT is a private package, it is generally invoked indirectly rather than called directly from custom code. It is referenced by one other package in the ETRM metadata, indicating it serves as a building block for higher-level opportunity management APIs. Typical invocation scenarios include the Oracle Sales opportunity form, where a user selects a "Copy" action, and any concurrent or scripted process that needs to duplicate opportunities with selective detail. Customers extending or integrating with Oracle Sales should prefer the corresponding public API where available; direct calls to this private package carry upgrade risk, since private packages are not part of Oracle's supported public interface and may change between releases. The standard p_init_msg_list, p_commit, and p_validation_level parameters permit callers to control message list initialization, transaction commit behavior, and validation depth, consistent with other EBS PL/SQL APIs.