DBA Data[Home] [Help]

APPS.WF_XML dependencies on WF_PARAMETER_LIST_T

Line 3088: p_parameter_list in wf_parameter_list_t)

3084: p_pos in out NOCOPY number,
3085: p_recipient_role in varchar2,
3086: p_event_name in varchar2,
3087: p_event_key in varchar2,
3088: p_parameter_list in wf_parameter_list_t)
3089: is
3090: -- message CLOB;
3091: l_sec_policy varchar2(100);
3092: t_name varchar2(100);

Line 4078: p_parameter_list in wf_parameter_list_t)

4074: p_orig_system in varchar2,
4075: p_orig_system_id in number,
4076: p_event_name in varchar2,
4077: p_event_key in varchar2,
4078: p_parameter_list in wf_parameter_list_t)
4079: is
4080:
4081: cursor members(rname varchar2, rorig varchar2, rorigid number) is
4082: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID

Line 4192: p_parameter_list in wf_parameter_list_t)

4188: -- To generate the XML content for a single notification
4189: procedure GenerateMessage(p_doc in out nocopy CLOB,
4190: p_event_name in varchar2,
4191: p_event_key in varchar2,
4192: p_parameter_list in wf_parameter_list_t)
4193: is
4194: nid NUMBER;
4195:
4196: pos integer;

Line 4426: p_parameter_list in wf_parameter_list_t)

4422: p_pos in out NOCOPY number,
4423: p_recipient_role in varchar2,
4424: p_event_name in varchar2,
4425: p_event_key in varchar2,
4426: p_parameter_list in wf_parameter_list_t)
4427: is
4428: pos integer;
4429: attrlist wf_xml_attr_table_type;
4430: occurance integer;

Line 4842: p_parameter_list in wf_parameter_list_t)

4838: p_orig_system in varchar2,
4839: p_orig_system_id in number,
4840: p_event_name in varchar2,
4841: p_event_key in varchar2,
4842: p_parameter_list in wf_parameter_list_t)
4843: is
4844:
4845: cursor members(rname varchar2, rorig varchar2, rorigid number) is
4846: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID

Line 4940: p_parameter_list in wf_parameter_list_t)

4936: -- To generate the XML content for the enqueued Summary notifications.
4937: procedure GenerateSummary (p_doc in out nocopy CLOB,
4938: p_event_name in varchar2,
4939: p_event_key in varchar2,
4940: p_parameter_list in wf_parameter_list_t)
4941: is
4942: pos integer;
4943:
4944: attrlist wf_xml_attr_table_type;

Line 5035: p_parameter_list in wf_parameter_list_t)

5031: -- Generate
5032: -- To generate the XML content for the enqueued notifications.
5033: function Generate(p_event_name in varchar2,
5034: p_event_key in varchar2,
5035: p_parameter_list in wf_parameter_list_t)
5036: return clob
5037: is
5038: l_doc CLOB;
5039: l_evt wf_event_t;

Line 5040: l_parameters wf_parameter_list_t;

5036: return clob
5037: is
5038: l_doc CLOB;
5039: l_evt wf_event_t;
5040: l_parameters wf_parameter_list_t;
5041: l_erragt wf_agent_t;
5042:
5043: begin
5044: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

Line 5491: l_paramlist wf_parameter_list_t;

5487: p_event in out NOCOPY WF_EVENT_T) return varchar2
5488: is
5489: l_eventName varchar2(80);
5490: l_eventkey varchar(80);
5491: l_paramlist wf_parameter_list_t;
5492: l_eventData CLOB;
5493: l_node varchar2(30);
5494: l_version integer;
5495: l_user varchar2(320);

Line 5749: l_paramlist wf_parameter_list_t;

5745: is
5746: l_eventName varchar2(80);
5747: result varchar2(30);
5748: erragt wf_agent_t;
5749: l_paramlist wf_parameter_list_t;
5750: errMsg varchar2(4000);
5751: errStack varchar2(4000);
5752:
5753: begin

Line 5815: l_paramlist wf_parameter_list_t;

5811: p_event in out NOCOPY WF_EVENT_T) return varchar2
5812: is
5813: l_eventName varchar2(80);
5814: l_eventkey varchar(80);
5815: l_paramlist wf_parameter_list_t;
5816:
5817: l_event_paramlist wf_parameter_list_t;
5818: -- NOTE: For bug 6049086, more_info_role is included in the SQL
5819: -- in order to send summary mail to more_info_role and not

Line 5817: l_event_paramlist wf_parameter_list_t;

5813: l_eventName varchar2(80);
5814: l_eventkey varchar(80);
5815: l_paramlist wf_parameter_list_t;
5816:
5817: l_event_paramlist wf_parameter_list_t;
5818: -- NOTE: For bug 6049086, more_info_role is included in the SQL
5819: -- in order to send summary mail to more_info_role and not
5820: -- to recepient_role if notification more_info_role is not null.
5821: CURSOR c_get_summary_roles is

Line 5838: l_event_paramlist := wf_parameter_list_t();

5834: l_paramList := p_event.getParameterList();
5835:
5836: for rec_summary_role in c_get_summary_roles loop
5837:
5838: l_event_paramlist := wf_parameter_list_t();
5839: wf_event.addParameterToList('ROLE_NAME',
5840: rec_summary_role.RECIPIENT,
5841: l_event_paramlist);
5842: -- Set AQs correlation id to item type i.e. 'WFMAIL'

Line 6034: param_list wf_parameter_list_t;

6030: FUNCTION error_rule(p_subscription_guid in raw,
6031: p_event in out nocopy wf_event_t) return varchar2
6032: is
6033: nid number;
6034: param_list wf_parameter_list_t;
6035: cb varchar2(240);
6036: ctx varchar2(2000);
6037: itemType varchar2(8);
6038: itemKey varchar2(240);