Search Results default_name

Overview

APPS.WF_MAILER_PARAMETER is an Oracle Workflow utility package responsible for managing the configuration parameters that govern outbound notification mail delivery in Oracle E-Business Suite. Its central role is to resolve mailer parameter values at runtime by looking up a named mailer instance and matching parameter, and, when no instance-specific value exists, falling back to a system-wide default identified by the reserved internal token -WF_DEFAULT-. This fallback behaviour is bound directly to the default_name constant (varchar2(15) := '-WF_DEFAULT-'), which appears in the package body source shipped with the EBS 12.1.1 and 12.2.2 file systems (wfmlrpb.pls, version 120.10). The package is classified as OTHER in the ETRM repository and is owned by APPS, indicating it is an internal support component rather than a public end-user API.

The business function it serves is essentially configuration resolution for the Workflow Notification Mailer. Because mailer behaviour (SMTP host, reply-to address, content tagging, validation rules, and similar settings) can differ per mailer instance and per message, this package provides a consistent mechanism to obtain the effective value of any parameter, including when extended notation in a parameter value must be substituted from a message attribute associated with a specific notification.

Key Procedures and Functions

Eight of the nineteen documented program units illustrate the package's purpose, though the ETRM metadata records the full set as GETVALUE, GETVALUES, PUTPARAMETER, PUTVALUE, PUTVALUES, GET_MAILER_TAGS_C, GETTAGS, PUTTAG, VALIDSTR, VALIDINT, VALIDLOG, VALIDPROTOCOL, VALIDSENDARG, and GETVALUEFORCORR.

• GETVALUE — Returns a parameter value for a given mailer name and parameter, failing over to the -WF_DEFAULT- instance when no specific row exists. An overloaded form accepts a notification ID so that message attributes may override the stored value.
• GETVALUES — Retrieves multiple parameter values, typically in a single call for efficiency when several settings are required.
• PUTVALUE / PUTVALUES — Store or update a parameter value for a mailer instance.
• PUTPARAMETER — Creates or maintains a parameter definition associated with a mailer.
• GETTAGS / PUTTAG / GET_MAILER_TAGS_C — Manage mailer tags used within notification content, including the retrieval cache construction.
• VALIDSTR, VALIDINT, VALIDLOG, VALIDPROTOCOL, VALIDSENDARG — Perform type and format validation on parameter values, including string, integer, boolean/logical, protocol, and send-argument checks. The valid_param and no_validation flags determine whether validation is applied.
• GETVALUEFORCORR — Resolves a parameter value in the context of a specific correspondence, an extension of the standard lookup path.

Tables Accessed

• WF_MAILER_PARAMETERS — The primary configuration table holding parameter name/value rows keyed by mailer name and parameter name; read and maintained by the GET/PUT routines.
• WF_MAILER_TAGS and WF_MAILER_TAGS_S — Store tag definitions and their translation/seed rows used when assembling notification content.
• FND_SVC_COMPONENTS and FND_SVC_COMP_PARAM_VALS — The Service Components framework tables from which mailer component settings are resolved.
• PLITBLM — A PL/SQL index-by table used for in-memory processing rather than persistent storage.

Usage Notes

WF_MAILER_PARAMETER is an internal support package, not a direct end-user interface. It is invoked by the Workflow Notification Mailer and by the three dependent packages recorded in ETRM, which call it to resolve, validate, and persist mailer settings. It is reached from concurrent-processing mailer runs, from the Workflow administrator configuration forms, and from custom PL/SQL that needs to read effective mailer parameter values. Because its lookup logic honours the -WF_DEFAULT- fallback, any customization of mailer defaults should be performed through the supporting configuration tables rather than by modifying this package, which is supplied under standard Oracle support policies.