Search Results get_rusub_count

Overview

FND_RESUB is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It provides the runtime support layer for Oracle Applications concurrent request resubmission and scheduling. The package exposes a small, focused API that lets a running concurrent program interrogate its own execution context—its submitted parameters, the requesting program and application, the assigned schedule, and the date on which execution was requested—and then hand control back to the concurrent manager via a standard return convention. Because the package is declared AUTHID CURRENT_USER, its procedures execute with the privileges of the calling session, and every function carries a pragma restrict_references (..., WNDS) directive, signalling that the routines are pure with respect to database writes and therefore safe for use inside SQL.

Key Procedures and Functions

• GET_PARAM_INFO — Returns a parameter value by positional number while emitting the corresponding parameter name, allowing a program to walk its argument list by position.
• GET_PARAM_NUMBER — Resolves a parameter name to its positional number, the inverse of the lookup above.
• GET_PARAM_TYPE — Returns the declared data type of the parameter at a given position.
• GET_REQUESTED_START_DATE — Returns the date on which the current concurrent request was requested to start. This is the routine targeted by the search term and is the package's most frequently referenced entry point for schedule-aware logic.
• GET_RUSUB_COUNT and GET_RUSUB_DELTA — Expose the resubmission counter and the offset applied on each resubmission, enabling a program to detect how many times it has run.
• GET_INCREMENT_FLAG — Indicates whether the schedule is advancing incrementally.
• GET_PROGRAM — Returns the concurrent program short name and its owning application name.
• GET_SCHEDULE — Returns the schedule type, application identifier, schedule identifier, and name.
• SET_PARAMETER and GET_PARAMETER — Allow parameters to be written to and read from the package's internal session context.
• RETURN_INFO — Accepts an error code and message buffer, providing the canonical completion call that reports success or failure to the concurrent manager.

Tables Accessed

The ETRM metadata documents no direct table references for this package via APPS synonyms; the twelve functions and procedures operate against the in-memory session context established by the concurrent manager rather than issuing SQL against application tables. This design is consistent with the WNDS purity pragmas applied throughout.

Usage Notes

FND_RESUB is normally invoked from within a running concurrent program—most commonly the PL/SQL resubmission stub that Oracle generates when a request set or schedule is defined. A typical program calls GET_PARAMETER or GET_PARAM_INFO to read its inputs, uses GET_REQUESTED_START_DATE together with GET_RUSUB_COUNT and GET_RUSUB_DELTA to compute the next run window, and terminates by calling RETURN_INFO with the resulting error code. ETRM records the package as referenced by one other package, confirming its role as a dependent utility rather than a top-level entry point. Custom code may call these routines directly, but doing so is only meaningful inside the concurrent manager execution context, since the session state they read is populated by that manager.