Search Results fnd_cp_delivery_options_s

Overview

APPS.FND_DELIVERY is a public PL/SQL package body within the Oracle E-Business Suite foundation layer that manages the delivery options associated with concurrent request output. Its principal business purpose is to allow concurrent programs, reports, and custom extensions to specify how the output of a concurrent request should be distributed — by electronic mail, fax, FTP, HTTP, WebDAV, or to an IPP-compliant printer — without requiring the calling code to manipulate the underlying delivery configuration tables directly. The package serves as the supported programmatic interface to the Oracle Concurrent Processing delivery subsystem, which underpins the "Delivery Options" region of the concurrent request submission and View Requests interfaces. The header revision AFCPDELB.pls 120.8.12020000.2 dates the current shipped version to February 2013, and the package is present in both the 12.1.1 and 12.2.2 releases of the E-Business Suite.

Key Procedures and Functions

The package exposes approximately twenty documented procedures and functions. The ADD_* family (ADD_EMAIL, ADD_FAX, ADD_FTP, ADD_WEBDAV, ADD_HTTP, ADD_CUSTOM, ADD_BURST) registers a delivery method and its parameters for the current concurrent request, each delegating to FND_REQUEST.ADD_DELIVERY_OPTION with the appropriate delivery type. ADD_IPP_PRINTER is overloaded: one form accepts an IPP printer name and resolves the associated DELIVERY_ID from FND_CP_IPP_PRINTERS, while the second accepts a numeric printer identifier directly. Both validate the printer and orientation before registering the delivery. The HAS_LOB_OF_TYPE and HAS_DELIVERY_OF_TYPE functions provide predicate checks against the delivery options already configured for a request. POST_PROCESSING_RESULTS applies the post-processing actions defined for completed requests.

The credential-management routines are of particular interest to the set_temp_credentials search that led here. SET_TEMP_CREDENTIALS stores temporary authentication credentials — typically a username and password — for use during a delivery attempt, while GET_TEMP_CREDENTIALS retrieves them and DEL_TEMP_CREDENTIALS removes them once the delivery completes or fails. Parallel routines SET_SMTP_CREDENTIALS and GET_SMTP_CREDENTIALS manage persistent SMTP authentication information used when the outgoing mail server requires authentication. This separation allows transient credentials, such as those supplied at request submission time, to be handled without overwriting the site-level SMTP configuration.

Tables Accessed

The package reads and writes several foundation tables through APPS synonyms. FND_CP_DELIVERY_OPTIONS and its sequence FND_CP_DELIVERY_OPTIONS_S hold the delivery option rows created by the ADD_* routines. FND_CP_DELIVERY_COMMANDS and FND_CONC_PP_ACTIONS support post-processing action definitions, while FND_RUN_REQ_PP_ACTIONS records the actions applied to a specific request run. FND_CP_IPP_PRINTERS provides IPP printer registration and lookup. FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS supply program and request context, and XDO_LOBS holds large object output for delivery. Reference data is drawn from FND_APPLICATION, FND_LANGUAGES, and DUAL.

Usage Notes

FND_DELIVERY is invoked indirectly whenever a user submits a concurrent request with delivery options, and directly by custom concurrent programs or PL/SQL that must attach delivery instructions to their output. The credential routines, including SET_TEMP_CREDENTIALS, are most commonly called by the Concurrent Manager delivery agents and by custom code performing authenticated deliveries to remote servers. Because the package is classified as OTHER rather than a formal public API, Oracle does not guarantee interface stability, and customizations should call it defensively, checking the boolean return values and handling exceptions. In 12.2.2 the package is referenced by one other package, reflecting its role as a lower-level utility within the delivery stack.