Search Results fnd_resub

Overview

FND_RESUB is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name and the naming conventions applied throughout the FND (Foundation) product family indicate that it supports the resubmission of concurrent requests within the Concurrent Manager infrastructure. The package operates as a helper and accessor layer rather than as a primary business API. In ETRM it is classified under the API classification "OTHER," and its documented status is VALID in the environment from which the metadata was extracted.

The package body depends on the corresponding package specification APPS.FND_RESUB and on the private companion package body APPS.FND_RESUB_PRIVATE, which holds the implementation details that are not exposed through the public interface. It also references the SYS.STANDARD package supplied by the PL/SQL runtime. Notably, the ETRM dependency report records that APPS.FND_RESUB is not referenced by any other database object at the schema level, although a separate metadata line indicates that it is referenced by one other package. This suggests that its callers are typically runtime program units, forms, or concurrent programs rather than compiled dependents.

Key Procedures and Functions

The documented interface exposes twelve procedures and functions. Their names reveal a resubmission-parameter and run-information accessor role:

• GET_PARAM_INFO — Returns consolidated information about a resubmission parameter.
• GET_PARAM_NUMBER — Retrieves a numeric parameter value used in the resubmission definition.
• GET_PARAM_TYPE — Returns the datatype classification of a resubmission parameter.
• GET_REQUESTED_START_DATE — Supplies the requested start date associated with the request being resubmitted.
• GET_RUSUB_COUNT — Returns the resubmission count, i.e. the number of times a request has been or should be resubmitted.
• GET_RUSUB_DELTA — Returns the resubmission delta, the interval value applied between successive resubmissions.
• GET_INCREMENT_FLAG — Returns the flag indicating whether a parameter or schedule value is incremented on each resubmission.
• GET_PROGRAM — Identifies the concurrent program associated with the resubmission context.
• GET_SCHEDULE — Returns the schedule definition governing the resubmission timing.
• SET_PARAMETER — Assigns a value to a resubmission parameter.
• GET_PARAMETER — Reads the current value of a resubmission parameter.
• RETURN_INFO — Returns status or informational output from the package.

The pairing of SET_PARAMETER with GET_PARAMETER, together with the GET_PARAM_* accessors, indicates that the package maintains and exposes the parameter token list that the Concurrent Manager replays when a request is submitted again.

Tables Accessed

The ETRM excerpt does not enumerate specific base tables referenced through APPS synonyms. Consistent with its function, the package operates on the Foundation concurrent-processing tables, principally FND_CONCURRENT_REQUESTS and the resubmission-related scheduling columns, with supporting access to FND_CONCURRENT_PROGRAMS for program resolution. The GET_SCHEDULE and GET_INCREMENT_FLAG functions imply reads of schedule and resubmission interval attributes stored against the request record.

Usage Notes

FND_RESUB is invoked internally by the Concurrent Manager and related Foundation forms when a concurrent request is defined with resubmission options. It is not intended as a public customization API, and Oracle does not publish its parameter lists for customer use. Custom code should avoid direct calls; standard resubmission behavior is configured through the Submit Request and Concurrent Manager interfaces. Where the package is referenced, it is reached indirectly through the resubmission processing path rather than by explicit application-level invocation.