Search Results fnd_resub_private




Overview
Explore in AI Chat

Overview

FND_RESUB_PRIVATE is an internal Oracle E-Business Suite package owned by the APPS schema that supports the resubmission of concurrent requests. In EBS release 12.1.1 and 12.2.2, the Concurrent Manager and related scheduling components rely on this package to evaluate whether a submitted concurrent program should be automatically resubmitted and to reconstruct the parameters, schedule, and program definition required to create a new request. The package is classified as OTHER in the ETRM documentation, indicating that it is a private implementation helper rather than a public, supported API.

The package is declared with AUTHID CURRENT_USER, so all unqualified object references and dynamic SQL execute under the privileges of the invoking session rather than under the definer's rights. This is significant because the package reads and writes concurrent manager request data and application metadata, and it uses DBMS_SQL for dynamic statement execution. The header identifies the source as AFCPRSPS.pls, version 115.8, originally shipped in 2003, reflecting the long-standing stability of this internal component across the EBS code line, including 12.1.1 and 12.2.2.

A number of the functions carry the pragma RESTRICT_REFERENCES with WNDS, indicating they do not write to the database and can therefore be called from SQL or PL/SQL contexts where purity is enforced.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. The central routine is PROCESS_INCREMENT, which performs the incremental resubmission of a concurrent request, taking a request identifier, a new start value, and a new request identifier and returning an error code and message. DEFAULT_INCREMENT_PROC provides the default incremental processing behavior used when no specialized increment procedure is configured.

The GET_ family of functions retrieves the metadata needed to schedule a resubmission. GET_PROGRAM returns the program name and the application short name of the concurrent program being resubmitted, and is the specific routine referenced by the search term "get_program." GET_SCHEDULE returns the schedule type, application identifier, identifier, and name associated with the resubmission. GET_REQUESTED_START_DATE returns the requested start date; GET_INCREMENT_FLAG indicates whether incremental processing is enabled; GET_RUSUB_COUNT returns the resubmission count; and GET_RUSUB_DELTA returns the resubmission interval.

Parameter handling is provided by GET_PARAM_INFO, GET_PARAM_NUMBER, GET_PARAM_TYPE, GET_PARAMETER, and SET_PARAMETER, which respectively resolve a parameter's name, number, and type, and read or write individual parameter values. RETURN_INFO reports error information, and GET_PARAM_INFO, GET_PARAM_NUMBER, and GET_PARAM_TYPE return numeric or type indicators alongside their output arguments.

Tables Accessed

The package references several core concurrent processing tables through APPS synonyms. FND_CONCURRENT_PROGRAMS holds the program definition used by GET_PROGRAM. FND_CONCURRENT_REQUESTS and FND_RUN_REQUESTS store the request records being examined and resubmitted. FND_CONC_REQUEST_ARGUMENTS provides the parameter values associated with a request. FND_CONC_RELEASE_CLASSES supplies release class information, FND_RUN_REQ_PP_ACTIONS supports post-processing actions on run requests, and FND_APPLICATION provides the application short name returned with the program. DBMS_SQL is used to execute dynamically constructed statements against these objects.

Usage Notes

FND_RESUB_PRIVATE is invoked internally by the concurrent manager and related scheduling infrastructure rather than by end users. Because the package is private and its header is not a supported public interface, direct calls from custom forms, concurrent programs, or extensions are not recommended; organizations needing resubmission behavior should use the supported concurrent request APIs and the standard scheduling forms. The ETRM documentation notes that the package is referenced by one other package, consistent with its role as a supporting component within the concurrent processing stack.