Search Results copy_template

Overview

The ASO_COPY_TMPL_PUB package body in the APPS schema supports Oracle EBS Order Capture and Quoting functionality by providing the public API layer used to copy quotation data into reusable template structures. Its principal business purpose is to enable organizations to derive templates from existing quotes, cloning header, line, service, and configuration detail so that frequently repeated sales scenarios can be standardized and reused across the quoting lifecycle. The package is classified as a PUB API, indicating it is intended for external invocation rather than serving as a private implementation detail of a single form or workflow.

The package body is registered as VALID and has no inbound dependencies from other database objects, which confirms its role as an entry point rather than an internal helper module. It sits within the Oracle Advanced Supply Chain Planning / Order Capture (ASO) module family and operates against the core quoting base tables that underpin the Quote and Order Capture forms.

Key Procedures and Functions

The documented API exposes five procedures, each addressing a distinct layer of the copy operation:

• COPY_QUOTE_TO_TMPL — The primary orchestrating routine. It drives the end-to-end copy of a source quotation into a template, sequencing the subordinate copy operations and managing the overall transaction context.
• COPY_TMPL_HEADER — Handles the replication of header-level quote attributes, including the quote number sequence reference, status, and associated header records.
• COPY_TMPL_LINES — Copies quotation line records and their supporting line detail, preserving the structural relationships between parent and child lines.
• COPY_TMPL_SERVICE — Addresses service-oriented lines and related shipment-level information carried on the quotation.
• CONFIG_COPY_TMPL — Manages the transfer of configuration data, integrating with the configuration model via ASO_CFG_INT and CZ_API_PUB.

Parameter lists are not reproduced here; invocation details should be obtained from the ETRM package specification.

Tables Accessed

The package reads and writes the core quoting tables through APPS synonyms:

• ASO_QUOTE_HEADERS_ALL — Source and target quotation headers, accessed alongside ASO_QUOTE_HEADERS_PVT.
• ASO_QUOTE_LINES_ALL and ASO_QUOTE_LINE_DETAILS — Line-level and attribute-level detail for the copy.
• ASO_QUOTE_NUMBER_S — The quote number sequence, referenced when assigning identifiers to newly created template records.
• ASO_QUOTE_STATUSES_B — Status code validation and assignment.
• ASO_SHIPMENTS and ASO_LINE_RELATIONSHIPS — Service lines and inter-line relationship structure.

Supporting utility and framework objects include FND_API, FND_MSG_PUB, FND_MESSAGE, FND_GLOBAL, FND_PROFILE, ASO_DEBUG_PUB, ASO_UTILITY_PVT, and MTL_SYSTEM_ITEMS_VL. PLITBLM and DUAL are used for PL/SQL table and utility operations.

Usage Notes

ASO_COPY_TMPL_PUB is normally invoked from the Oracle Quoting / Order Capture forms when a user elects to save a quote as a template, and from concurrent or workflow processes that build template libraries programmatically. Because it is a PUB API, custom extensions and integrations targeting EBS 12.1.1 or 12.2.2 may call it directly, provided they respect the standard FND_API error-handling and message-stack conventions. Callers should note the dependency on ASO_QUOTE_NUMBER_S for numbering and on the configuration APIs for configurable items, and should ensure the source quote is in a state suitable for template derivation.