Search Results copy_quote

Overview

ASO_COPY_QUOTE_PUB is the public PL/SQL API within the Oracle E-Business Suite Order Capture module responsible for duplicating existing sales quotes. Distributed under the APPS schema and classified as a PUB (public) interface, it exposes a supported programmatic entry point for copying quote structures rather than requiring direct DML against the underlying Order Capture tables. The package header carries the version identifier asopcpys.pls 120.2, last updated November 1, 2005, and its stated purpose is to expose the public API of Order Capture along with the PL/SQL record and table type specifications those APIs require.

The business problem it solves is straightforward: sales organizations frequently need to reproduce an existing quote — including its lines, notes, tasks, attachments, and pricing context — as a new quote or as a new version of the same quote. Rather than reconstructing that structure manually, the calling application passes a control record and a header record to the API, and the package performs the copy operation while honoring the caller's choices about what should and should not be carried forward.

Key Procedures and Functions

• COPY_QUOTE — The primary public procedure. It accepts the control record and header record structures defined in the package and performs the quote duplication. The Copy_Quote_Control_Rec_Type record governs behavior: Copy_Header_Only restricts the operation to the header, New_Version indicates whether the result is a new version, and the Copy_Note, Copy_Task, and Copy_Attachment flags determine which dependent entities accompany the copied quote. Pricing behavior is directed through Pricing_Request_Type (default 'ASO'), Header_Pricing_Event, Price_Mode (default 'ENTIRE_QUOTE'), and the freight and tax calculation flags. The Copy_Quote_Header_Rec_Type record supplies target header attributes such as quote name, number, source code, expiration date, resource identifiers, and pricing/tax status and update indicators.
• COPY_LINE — The companion public procedure that handles line-level duplication within the quote copy operation.

Both procedures follow standard EBS API conventions, including the use of FND_API.G_MISS_* and FND_API.G_FALSE/G_TRUE sentinels to distinguish "not supplied" from an explicit value.

Tables Accessed

The package operates against ASO_QUOTE_LINES_ALL through its APPS synonym, which is the base table storing quote line data and therefore the principal write target for the line copy operation. It also references PLITBLM, the standard Order Capture PL/SQL index-by table type used to pass collections of records between the API and its callers. In practice, the copy operation additionally affects the quote header and related note, task, and attachment structures according to the control flags supplied.

Usage Notes

ASO_COPY_QUOTE_PUB is a foundational API referenced by eight other packages in the Order Capture schema, which indicates it is embedded in higher-level quote processing flows rather than being called exclusively from the UI. It is typically invoked from Oracle Forms quote-entry screens when a user selects a copy or new-version action, from concurrent programs performing bulk quote duplication, and from custom extensions that need to clone quotes without bypassing Oracle's supported interfaces. Because it is a PUB API, custom code should call it directly rather than writing to the quote tables. Callers must populate the control and header records carefully, relying on the G_MISS sentinels for fields that should default, and should expect the API to raise standard FND_API exceptions on validation failure.