Search Results fnd_set_copy




Overview
Explore in AI Chat

Overview

FND_SET_COPY is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its classification in the E-Business Suite Technical Reference Manual (ETRM) is "OTHER," indicating that it is an internal application utility rather than a formally published public API. The package is validated and available in the database, and its documented purpose centers on the cloning or replication of concurrent program definitions and their associated arguments. In practical terms, FND_SET_COPY supports the Oracle EBS concurrent manager and request submission infrastructure by allowing program argument definitions and request metadata to be duplicated or set programmatically, which is useful when administrators need to replicate request configurations across programs, operating units, or environments.

The package body depends on several core Oracle Application Object Library components, including FND_CONCURRENT_PROGRAMS, FND_CONC_REQUEST_PKG, FND_GLOBAL, and FND_RUN_REQUESTS, as well as the SQL STANDARD library. The ETRM notes that FND_SET_COPY is not referenced by any other database object, confirming that it is invoked as a standalone utility rather than being integrated into a broader dependency chain.

Key Procedures and Functions

The documented package metadata lists one procedure: SET_PROGRAM_ARGS. As the name suggests, this routine is responsible for establishing or copying the argument definitions associated with a concurrent program. The procedure operates against concurrent program metadata, reading the source program's argument configuration and applying it to a target program. Because the ETRM does not publish a formal parameter list for this package, the exact call signature is not documented here; consumers should inspect the package specification or the database source directly before invoking it.

SET_PROGRAM_ARGS is the only exposed entry point recorded in the ETRM. No additional procedures or functions are documented for FND_SET_COPY, and the package is classified as "OTHER," meaning it is not part of an officially supported public API contract. Consequently, it should be treated as an internal utility whose behavior may change between point releases without notice.

Tables Accessed

The ETRM documents that FND_SET_COPY references two tables through APPS synonyms:

  • FND_CONCURRENT_PROGRAMS — The central repository of concurrent program definitions, including program short names, executable associations, and argument metadata.
  • FND_RUN_REQUESTS — The table that stores request submission parameters and runtime argument values for concurrent requests.

The package reads program definitions from FND_CONCURRENT_PROGRAMS and accesses request argument data through FND_RUN_REQUESTS, enabling SET_PROGRAM_ARGS to propagate argument configurations between programs or request records.

Usage Notes

FND_SET_COPY is typically invoked from PL/SQL scripts, concurrent programs, or administrative utilities rather than from an Oracle Forms interface. It may also be referenced within request submission workflows that set up program arguments prior to execution. Given its reliance on FND_GLOBAL for session context and FND_CONC_REQUEST_PKG for request management, the package is designed to run within the standard EBS runtime environment.

Because the ETRM lists no objects that reference FND_SET_COPY, it is safest to consider it a helper package for one-time or administrative use. Developers should avoid calling it directly in custom code and instead rely on supported concurrent program APIs. If direct invocation is required, the package specification should be reviewed to confirm the current signature and any implicit dependencies on FND_GLOBAL session initialization.