Results for “fnd_set_copy”

22 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_SET_COPY is an Oracle Application Object Library (FND) package belonging to the APPS schema. Its declared purpose is to support the cloning and argument propagation of request set definitions within the concurrent processing framework. Request sets are containers that group multiple concurrent programs and their execution parameters so they can be submitted as a single unit. When a request set is copied — either through the standard "Copy" action in the Concurrent Programs and Request Sets forms or programmatically — the stored arguments for every member program must be carried forward to the new definition. FND_SET_COPY encapsulates that logic.

The package header carries the legacy version stamp $Header: AFRSCPSS.pls 115.1 99/07/16, indicating it originated in the Release 11 era and has been retained largely unchanged through 12.1.1 and 12.2.2. It is declared AUTHID CURRENT_USER and is classified in ETRM as OTHER, meaning it is an internal API rather than a public, documented extension point.

Key Procedures and Functions

The ETRM metadata documents a single program unit:

  • set_program_args — A function that takes a parent identifier and a request set program identifier (req_set_prog_id), together with a large block of attribute1 through attributeN parameters declared IN OUT VARCHAR2. Its purpose is to accept the parameter values already captured for a source request set program and populate or return the argument strings needed for the copied program row. The signature is deliberately wide because concurrent program arguments are storable across many attribute columns; the routine maps and returns those values in place. No other procedures or functions are documented for this package, and it is referenced by zero other packages, confirming its role as a leaf-level internal utility.

Tables Accessed

FND_SET_COPY operates against two core concurrent processing tables, accessed through APPS synonyms:

  • FND_CONCURRENT_PROGRAMS — The definition table for concurrent programs. It is read to resolve the executable, argument method, and parameter metadata associated with the source program so that argument handling remains consistent when the request set is duplicated.
  • FND_RUN_REQUESTS — The table storing request set membership and per-program argument values. FND_SET_COPY reads the source rows and supplies the argument strings that will be written for the copied entries.

Usage Notes

FND_SET_COPY is not a developer-facing API. It is invoked internally by the FND request set maintenance forms and by the standard request set copy processing whenever a user duplicates a request set definition. In Oracle EBS 12.1.1 and 12.2.2, the same behavior is surfaced through the Request Sets form, where copying a set triggers the underlying argument propagation this package performs.

Because the package is AUTHID CURRENT_USER and undocumented in the public API sense, custom code should not call set_program_args directly; the signature may change between releases and no compatibility guarantee is provided. Developers who need to manipulate request set arguments programmatically should prefer the supported concurrent processing APIs or the FNDLOAD utility for migration. Any direct invocation should be limited to diagnostics and executed with a full understanding of the APPS schema privilege model.