APPS.WF_MAIL dependencies on WF_PARAMETER_LIST_T

Line 170: parameterList wf_parameter_list_t;

166: l_currState VARCHAR2(8);
167: updateState boolean;
168: l_role varchar2(320);
169:
170: parameterList wf_parameter_list_t;
171: begin
172: select message_type, message_name, mail_status, recipient_role
173: into l_mType, l_mName, l_currState, l_role
174: from wf_notifications

Line 203: parameterlist := wf_parameter_list_t();

199: external_error => UpdateStatus2.external_error);
200: elsif (UpdateStatus2.status = 'FAILED') then
201: -- Here we only raise an event and leave the message as is.
202: -- oracle.apps.wf.notification.send.failure
203: parameterlist := wf_parameter_list_t();
204:
205: wf_event.AddParameterToList('NOTIFICATION_ID',nid,parameterlist);
206: wf_event.AddParameterToList('ROLE',l_role,parameterlist);
207: wf_event.AddParameterToList('STATUS',status,parameterlist);

Line 225: parameterlist := wf_parameter_list_t();

221: -- in the C mailer. It only happens when there is a match on
222: -- the pattern/actions. Here we can start to raise an event
223: -- that indicates that a recipient is not available to respond
224: -- to the notification.
225: parameterlist := wf_parameter_list_t();
226:
227: wf_event.AddParameterToList('NOTIFICATION_ID', UpdateStatus2.nid, parameterlist);
228: wf_event.AddParameterToList('STATUS', UpdateStatus2.status, parameterlist);
229:

Line 415: params wf_parameter_list_t;

411: recipient varchar2(320);
412: pref varchar2(8);
413: email_address varchar2(320);
414: recipientAddress varchar2(320);
415: params wf_parameter_list_t;
416: errorName varchar2(320);
417: externError varchar2(4000);
418: nid number;
419:

Line 433: paramList wf_parameter_list_t;

429:
430: orig_system varchar2(30);
431: orig_system_id number;
432:
433: paramList wf_parameter_list_t;
434:
435: invalidRoleList varchar2(32000);
436: reasonList varchar2(32000);
437: invalidRoleCount pls_integer := 0;

Line 540: paramList := wf_parameter_list_t(null);

536: end if;
537: end if;
538:
539: tokens := wf_mail_util.strParser(externError, '{}');
540: paramList := wf_parameter_list_t(null);
541:
542: invalidRoleList := '';
543: reasonList := '';
544: invalidRoleCount := 0;

Line 843: parameterlist wf_parameter_list_t := wf_parameter_list_t();

839: -- Bug# 2301881 variables to handle new error message format
840: value_found varchar2(1000);
841: remarks varchar2(1000);
842:
843: parameterlist wf_parameter_list_t := wf_parameter_list_t();
844:
845: role varchar2(320);
846: group_id number;
847: mType varchar2(8);

Line 7871: l_parameter_list wf_parameter_list_t;

7867:
7868: l_msg_doc clob;
7869: l_event wf_event_t;
7870: l_agent wf_agent_t;
7871: l_parameter_list wf_parameter_list_t;
7872: l_event_name varchar2(240);
7873: l_event_key varchar2(240);
7874: l_recp_type varchar2(10);
7875: l_name varchar2(360);