Search Results copy_line

Overview

ASO_COPY_QUOTE_PUB is a public PL/SQL API package in the Oracle EBS Order-to-Cash (ASO) module that provides the programmatic interface for duplicating existing Oracle Quoting quotations. The package encapsulates the business logic required to create a new quote as a copy of an existing quote, including its header, lines, and related detail records. In Oracle EBS 12.1.1 and 12.2.2, this API is the supported entry point for applications and extensions that need to replicate quotation structures without re-entering data manually, supporting scenarios such as creating revised versions, template-based quoting, and volume entry of similar quotes. The package body is identified in the header as asopcpyb.pls (version 120.1.12010000.5), follows the standard Oracle EBS API architecture using FND_API savepoints, message handling, and compatibility checks, and exposes its procedures under the PUBLIC API classification with the APPS owner.

Key Procedures and Functions

• COPY_QUOTE — The primary documented procedure. It performs the copy of a quotation from source data supplied by the caller, accepting header, control, and (where applicable) quote header, shipment, payment, and tax detail records, and returning the identifier and number of the newly created quote together with standard API return status and message outputs. It establishes a savepoint, initializes the debug flag from the ASO_ENABLE_DEBUG profile, and validates API version compatibility through FND_API.Compatible_API_Call before executing the copy logic.
• COPY_LINE — The second documented procedure, which supports copying of individual quotation lines. This is the routine associated with the "copy_line" search term and is the line-level counterpart to COPY_QUOTE. It is invoked to duplicate line records within the quoting data model, allowing callers to replicate specific configured lines rather than only whole quotes.

Both procedures are declared in the package specification and implemented in the body, and the package is referenced by eight other packages within the EBS codebase, indicating it functions as a shared copy utility across quoting-related components.

Tables Accessed

• ASO_QUOTE_LINES_ALL — The core quotation lines table. The package reads source line records and writes new line records to this table when copying quote lines, preserving the line-level attributes, pricing references, and relationships that define the quotation structure.
• PLITBLM — An application utility table referenced in the package metadata. It is used in the copy processing, typically for temporary or intermediate data handling during the duplication of quote records.

Access to these objects occurs through APPS synonyms, consistent with the standard EBS schema design in which public APIs operate on the APPS-owned synonyms rather than base tables directly.

Usage Notes

ASO_COPY_QUOTE_PUB is typically invoked from Oracle Quoting forms (such as the Copy Quote action in the Quoting UI), from concurrent programs that perform bulk quote duplication, and from custom PL/SQL code that requires programmatic quote replication. Callers should pass a valid P_API_VERSION_NUMBER, initialize the message list, and set the commit flag according to transaction control requirements; the API returns standard X_RETURN_STATUS, X_MSG_COUNT, and X_MSG_DATA outputs for error handling. Because the procedures follow the FND_API savepoint model, callers can roll back to the savepoint on failure. The COPY_LINE procedure should be used when only line-level duplication is required, while COPY_QUOTE provides the complete header-to-detail copy. In 12.2.2, the package remains the documented public interface and should be preferred over any direct table manipulation to ensure validation, defaults, and auditing behavior are applied.