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 832: parameterlist wf_parameter_list_t := wf_parameter_list_t();

828: -- Bug# 2301881 variables to handle new error message format
829: value_found varchar2(1000);
830: remarks varchar2(1000);
831:
832: parameterlist wf_parameter_list_t := wf_parameter_list_t();
833:
834: role varchar2(320);
835: group_id number;
836: mType varchar2(8);

Line 7555: l_parameter_list wf_parameter_list_t;

7551:
7552: l_msg_doc clob;
7553: l_event wf_event_t;
7554: l_agent wf_agent_t;
7555: l_parameter_list wf_parameter_list_t;
7556: l_event_name varchar2(240);
7557: l_event_key varchar2(240);
7558: l_recp_type varchar2(10);
7559: l_name varchar2(360);