Search Results wf_mailer_parameter




Overview
Explore in AI Chat

Overview

WF_MAILER_PARAMETER is a PL/SQL package owned by the APPS schema that supports the Oracle Workflow notification mailer infrastructure in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to resolve, validate, and persist the configuration parameters that govern how the Workflow Notification Mailer constructs, addresses, and dispatches outbound notification e-mail. Rather than hard-coding mailer settings, Oracle Workflow stores them as name/value pairs that the mailer service component reads at runtime; WF_MAILER_PARAMETER provides the programmatic interface for retrieving those values, applying defaults and tag substitutions, and writing updated values back to the underlying repository. In this respect the package acts as the parameter-management layer between the Workflow Notification Mailer service component and the configuration tables that describe it, and it is listed in the ETRM repository with a status of VALID and an API classification of OTHER.

Key Procedures and Functions

The ETRM metadata documents nineteen callable units within the package. The retrieval group centres on GETVALUE and GETVALUES, which return a single parameter value or a set of values for a mailer configuration, together with GETVALUEFORCORR, which resolves parameter values in the specific context of a correlation identifier. GETTAGS and GET_MAILER_TAGS_C expose the mailer tag definitions, the substitution tokens that are expanded when notification message bodies are composed. The update group comprises PUTPARAMETER, PUTVALUE, PUTVALUES, and PUTTAG, which insert or modify parameter and tag settings. A distinct family of validation routines — VALIDSTR, VALIDINT, VALIDLOG, VALIDPROTOCOL, and VALIDSENDARG — enforces the expected data type and allowable domain for string, integer, logical (Yes/No style), protocol, and send-argument parameters respectively. Because the metadata does not publish individual parameter lists, the signatures should be inspected in the data dictionary before the routines are called directly.

Tables Accessed

The package operates against a small set of configuration and service-component tables, reached through APPS synonyms. WF_MAILER_PARAMETERS holds the mailer configuration parameters themselves and is the primary target of the GET and PUT routines. WF_MAILER_TAGS and WF_MAILER_TAGS_S store the mailer tag definitions and their translated or seeded variants, supporting tag expansion during message construction. FND_SVC_COMPONENTS and FND_SVC_COMP_PARAM_VALS hold the Service Component Architecture definitions and their parameter values, allowing the mailer's own component registration to be read and maintained. PLITBLM is an Oracle-supplied PL/SQL internal table type used as a transient structure for holding collections of parameter values during processing; it is a language construct rather than an application data table.

Usage Notes

WF_MAILER_PARAMETER is not intended for direct end-user invocation. It is called internally by the Workflow Notification Mailer and by the higher-level PL/SQL units that reference it — WF_MAIL, WF_NOTIFICATION, WF_XML, and the package itself in recursive calls — which together assemble and transmit notification e-mail. Administrators interact with the same configuration data indirectly through the Workflow Notification Mailer setup screens and the Autoconfig-managed mailer configuration files, where changes are validated by the routines described above. Custom code should generally avoid modifying mailer parameters directly; where programmatic access is required, the documented GET and PUT subprograms, together with the validation functions, provide the supported route and help ensure that stored values conform to the formats the mailer expects. Because tag and parameter handling can vary between releases, behaviour should be verified against the specific EBS 12.1.1 or 12.2.2 instance in use.