Search Results add_delivery_option
Overview
FND_SUBMIT is the core PL/SQL package body in Oracle E-Business Suite Concurrent Processing that provides the programmatic interface for defining and submitting concurrent requests, request sets, and their associated output and delivery options. The package encapsulates the server-side logic used throughout the EBS runtime to construct a submission, apply repeat and increment-date rules, resolve NLS and organization context, assign printers and delivery destinations, and finally hand the request to the concurrent manager. It is classified under ETRM as an OTHER API package owned by APPS and is the same object referenced when users search for "set_request_set," the procedure that associates an inline request set definition with the pending submission.
Because request sets (and their constituent stages and programs) are themselves stored as concurrent definitions, FND_SUBMIT bridges the definition side of the data model — FND_REQUEST_SETS, FND_REQUEST_SET_PROGRAMS, and FND_REQUEST_SET_STAGES — with the execution side, FND_CONCURRENT_REQUESTS and FND_RUN_REQUESTS. It is a heavily reused dependency, referenced by 17 other packages across the applications schema.
Key Procedures and Functions
The documented interface exposes 27 procedures and functions organized around configuration, set content, and delivery:
- Submission core: SUBMIT_PROGRAM submits a single concurrent program; SUBMIT_SET submits an entire request set; SET_REQUEST_SET binds the current submission to a specific request set definition.
- Runtime options: SET_MODE configures the submission mode; SET_NLS_OPTIONS establishes language and territory; SET_REPEAT_OPTIONS and SET_INCREMENT_DATES_OPTION control recurring schedules and date increments; SET_REL_CLASS_OPTIONS applies request class and related attributes; SET_ORG_ID sets the operating unit context.
- Output and printing: SET_PRINT_OPTIONS, ADD_PRINTER, SET_DEST_OPS, ADD_LAYOUT, and ADD_IPP_PRINTER configure printing behavior, printer assignment, destination operations, and layout templates.
- Delivery channels: ADD_DELIVERY_OPTION, ADD_EMAIL, ADD_FAX, ADD_FTP, and ADD_WEBDAV register post-processing delivery destinations.
- Notifications: ADD_NOTIFICATION registers notification recipients and their on-normal, on-warning, and on-error flags, including orig_system and orig_system_id attributes introduced in the 12.1 project changes.
Tables Accessed
The package reads application and program metadata from FND_APPLICATION and FND_CONCURRENT_PROGRAMS to resolve executable definitions and application short names. Request set structure is read from FND_REQUEST_SETS, FND_REQUEST_SET_PROGRAMS, and FND_REQUEST_SET_STAGES; the ordering logic accounts for multiple occurrences of the same program within a stage using the RSP sequence. Execution and run context are stored in FND_CONCURRENT_REQUESTS, FND_RUN_REQUESTS, and FND_RUN_REQ_PP_ACTIONS. Printing and delivery configuration is sourced from FND_PRINTER, FND_PRINTER_INFORMATION, FND_PRINTER_STYLES, FND_CP_DELIVERY_OPTIONS, FND_CP_DELIVERY_COMMANDS, and FND_CP_IPP_PRINTERS. DUAL supports simple expression evaluation.
Usage Notes
FND_SUBMIT is invoked from concurrent program forms, the Submit Request form, request set definitions, and custom code that programmatically launches requests. Typical custom usage chains SET_NLS_OPTIONS, SET_ORG_ID, and optional SET_PRINT_OPTIONS or ADD_PRINTER calls before SUBMIT_PROGRAM or SUBMIT_SET. Because the package maintains private package state (P_OPS_ID, P_SET_ID, P_PRINT_STYLE, and similar variables), option setters must precede the submit call within the same session. Applications upgrading between 12.1.1 and 12.2.2 should note the notification record changes documented in the source header.