Search Results copy_opp_quote

Overview

ASO_COPY_QUOTE_PVT is the private PL/SQL package that implements the quote duplication logic for Oracle Order Capture (Oracle Quoting) in Oracle E-Business Suite. It belongs to the ASO (Oracle Advanced Sales and Quoting) application and carries the owner APPS with an API classification of PVT, meaning it is intended for internal consumption rather than as a public integration interface. The package header is identified by the version string asovcpys.pls 120.2, dated 2005/08/16.

The stated purpose of the package is to hold the specification for PL/SQL records and tables together with the private API of Order Capture that supports copying an existing quote into a new quote. The public-facing entry point is exposed through the companion package ASO_COPY_QUOTE_PUB, which the private package depends upon for its record and table types. In the context of a user search for "service_copy", the SERVICE_COPY procedure is the relevant routine, handling the duplication of service-related data when a quote is copied.

Key Procedures and Functions

The ETRM metadata documents eleven procedures within the package:

• COPY_QUOTE — The principal driver routine that orchestrates the creation of a new quote from an existing one. It accepts a copy-quote header record and a control record, and returns the new header identifier, quote number, return status, and message information. All parameters carry the FND_API standard messaging and commit conventions.
• COPY_HEADER_ROWS — Copies the header-level data for the source quote, returning the new header identifier and a price index link table used during downstream processing.
• COPY_LINE_ROWS — Copies the quote line rows associated with the source quote header.
• CONFIG_COPY — Handles duplication of configuration data for configured items on the source quote.
• SERVICE_COPY — Copies service-related rows attached to the source quote, including subscription and service instance data.
• GET_QUOTE_EXP_DATE — Computes or retrieves the expiration date to be applied to the copied quote.
• COPY_SALES_SUPPLEMENT — Duplicates sales supplement content linked to the source quote.
• COPY_OPP_QUOTE — Copies quote data originating from an opportunity, preserving the opportunity association.
• SPLIT_MODEL_LINE — Decomposes a model line into its component lines during the copy operation.
• INSERT_SALES_SUPP_DATA — Inserts the prepared sales supplement data into the target tables.
• COPY_PAYMENT_ROW — Copies payment rows from the source quote to the new quote.

Tables Accessed

The package reads and writes the core Order Capture schema through APPS synonyms. Header and line data are handled through ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL, with descriptive detail stored in ASO_QUOTE_LINE_DETAILS. New quote numbers are drawn from ASO_QUOTE_NUMBER_S. Pricing information is duplicated into ASO_PRICE_ADJUSTMENTS and ASO_PRICE_ADJ_RELATIONSHIPS, while line hierarchy is maintained through ASO_LINE_RELATIONSHIPS. Service and subscription data involved in SERVICE_COPY and configuration copy reside in ASO_SUP_INSTANCE_VALUE and ASO_SUP_TMPL_INSTANCE.

Additional tables support access control (ASO_QUOTE_ACCESSES), related-object tracking (ASO_QUOTE_RELATED_OBJECTS), status derivation (ASO_QUOTE_STATUSES_B), shipment and payment duplication (ASO_SHIPMENTS and ASO_PAYMENTS_S), and customer identification through HZ_CUST_ACCOUNTS.

Usage Notes

Because this is a private package, it is not intended for direct invocation by external integrations. It is invoked indirectly when a user performs a quote copy action in the Oracle Quoting user interface, and is referenced by five other packages within the same application. Custom code requiring quote copy behaviour should call the public wrapper ASO_COPY_QUOTE_PUB, which validates inputs and manages the FND_API message stack before delegating to this private implementation. The package relies on the standard FND_API conventions for initialization of the message list, commit control, and return status reporting.