Search Results copy_header_rows

Overview

ASO_COPY_QUOTE_PVT is the private implementation package for the Oracle E-Business Suite Quoting (ASO) copy-quote feature. Its public counterpart, ASO_COPY_QUOTE_PUB, exposes the callable API surface, while this body performs the actual row-by-row duplication of a source quote into a new quote header and its associated lines. The package header comment identifies its header version as asovcpyb.pls 120.32.12020000.4, last shipped 2013/06/04, and documents integration history spanning the legacy quoting model and the OKC (Oracle Knowledge and Contracts) integration introduced in 2003, along with fixes for bugs 2692785, 3704719, 3805575, and 4036748.

The package is classified as a PVT (private) API and is referenced by five other packages within the ASO schema, indicating it is the internal workhorse invoked through the public layer rather than directly by external integrations.

Key Procedures and Functions

The documented entry point, COPY_QUOTE, accepts an API version number, standard FND_API message-list and commit flags, a copy-quote header record, a copy-quote control record, and, following the Quoting Usability enhancement, additional header, shipment, payment, and tax-detail records. It returns the new quote header identifier, the new quote number, return status, message count, and message data. It is the only procedure whose parameter list appears in the supplied source excerpt.

The remaining documented procedures decompose the copy operation into logical units:

• COPY_HEADER_ROWS — duplicates the source quote header row, including its descriptive and control attributes, into ASO_QUOTE_HEADERS_ALL. This is the object captured by the search term "copy_header_rows".
• COPY_LINE_ROWS — copies quote line rows into ASO_QUOTE_LINES_ALL, together with associated line detail records.
• CONFIG_COPY — handles duplication of configured items and their supporting model structure, including split model lines via SPLIT_MODEL_LINE.
• SERVICE_COPY — duplicates service-oriented line content.
• COPY_SALES_SUPPLEMENT and INSERT_SALES_SUPP_DATA — replicate sales supplement template instances and their instance values for the new quote.
• COPY_PAYMENT_ROW — copies payment rows from the ASO_PAYMENTS_S table.
• COPY_OPP_QUOTE — manages the linkage between the copied quote and its originating opportunity or related object.
• GET_QUOTE_EXP_DATE — derives the expiration date for the newly created quote.

Tables Accessed

The package reads and writes the core Quoting tables. ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL receive the duplicated header and line rows. ASO_QUOTE_LINE_DETAILS stores line-level detail attributes. ASO_PAYMENTS_S and ASO_SHIPMENTS hold payment and shipment data for the new quote. ASO_QUOTE_NUMBER_S supplies the next quote number. ASO_QUOTE_STATUSES_B provides valid status values. ASO_QUOTE_ACCESSES controls user access to the copied quote, and ASO_QUOTE_RELATED_OBJECTS and ASO_LINE_RELATIONSHIPS maintain relationships between the quote, its lines, and external entities.

Pricing structures are duplicated through ASO_PRICE_ADJUSTMENTS and ASO_PRICE_ADJ_RELATIONSHIPS. Sales supplement data is held in ASO_SUP_INSTANCE_VALUE and ASO_SUP_TMPL_INSTANCE. Customer context is validated against HZ_CUST_ACCOUNTS.

Usage Notes

This private package is not intended for direct invocation by external interfaces; callers should use ASO_COPY_QUOTE_PUB, which enforces API version checks and message-list handling. In practice it is triggered from the Quoting user interface through the "Copy Quote" action, where a user selects a source quote and the form initiates the copy flow, and from the five referencing packages within the ASO schema that depend on its internal procedures. Because the body sets G_USER_ID and G_LOGIN_ID from FND_GLOBAL at package initialization, it respects the current application session or concurrent request context.

The package checks for running concurrent pricing requests, as noted in the 2002 fix for bug 2692785, and callers should honor the P_Commit flag so that multi-table duplication can be committed as a unit. Standard FND_API message handling is expected in the out parameters X_Return_Status, X_Msg_Count, and X_Msg_Data. ETRM documents this object in both Oracle EBS 12.1.1 and 12.2.2; behavior is consistent across these releases.