DBA Data[Home] [Help]

APPS.WF_XML dependencies on WF_PARAMETER_LIST_T

Line 3089: p_parameter_list in wf_parameter_list_t)

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

Line 4094: p_parameter_list in wf_parameter_list_t)

4090: p_orig_system in varchar2,
4091: p_orig_system_id in number,
4092: p_event_name in varchar2,
4093: p_event_key in varchar2,
4094: p_parameter_list in wf_parameter_list_t)
4095: is
4096:
4097: cursor members(rname varchar2, rorig varchar2, rorigid number) is
4098: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID

Line 4183: p_parameter_list in wf_parameter_list_t)

4179: -- To generate the XML content for a single notification
4180: procedure GenerateMessage(p_doc in out nocopy CLOB,
4181: p_event_name in varchar2,
4182: p_event_key in varchar2,
4183: p_parameter_list in wf_parameter_list_t)
4184: is
4185: nid NUMBER;
4186:
4187: pos integer;

Line 4344: p_parameter_list in wf_parameter_list_t)

4340: p_pos in out NOCOPY number,
4341: p_recipient_role in varchar2,
4342: p_event_name in varchar2,
4343: p_event_key in varchar2,
4344: p_parameter_list in wf_parameter_list_t)
4345: is
4346: pos integer;
4347: attrlist wf_xml_attr_table_type;
4348: occurance integer;

Line 4752: p_parameter_list in wf_parameter_list_t)

4748: p_orig_system in varchar2,
4749: p_orig_system_id in number,
4750: p_event_name in varchar2,
4751: p_event_key in varchar2,
4752: p_parameter_list in wf_parameter_list_t)
4753: is
4754:
4755: cursor members(rname varchar2, rorig varchar2, rorigid number) is
4756: select UR.USER_NAME, UR.USER_ORIG_SYSTEM, UR.USER_ORIG_SYSTEM_ID

Line 4828: p_parameter_list in wf_parameter_list_t)

4824: -- To generate the XML content for the enqueued Summary notifications.
4825: procedure GenerateSummary (p_doc in out nocopy CLOB,
4826: p_event_name in varchar2,
4827: p_event_key in varchar2,
4828: p_parameter_list in wf_parameter_list_t)
4829: is
4830: pos integer;
4831:
4832: attrlist wf_xml_attr_table_type;

Line 4923: p_parameter_list in wf_parameter_list_t)

4919: -- Generate
4920: -- To generate the XML content for the enqueued notifications.
4921: function Generate(p_event_name in varchar2,
4922: p_event_key in varchar2,
4923: p_parameter_list in wf_parameter_list_t)
4924: return clob
4925: is
4926: l_doc CLOB;
4927: l_evt wf_event_t;

Line 4928: l_parameters wf_parameter_list_t;

4924: return clob
4925: is
4926: l_doc CLOB;
4927: l_evt wf_event_t;
4928: l_parameters wf_parameter_list_t;
4929: l_erragt wf_agent_t;
4930:
4931: begin
4932: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

Line 5378: l_paramlist wf_parameter_list_t;

5374: p_event in out NOCOPY WF_EVENT_T) return varchar2
5375: is
5376: l_eventName varchar2(80);
5377: l_eventkey varchar(80);
5378: l_paramlist wf_parameter_list_t;
5379: l_eventData CLOB;
5380: l_node varchar2(30);
5381: l_version integer;
5382: l_user varchar2(320);

Line 5651: l_paramlist wf_parameter_list_t;

5647: is
5648: l_eventName varchar2(80);
5649: result varchar2(30);
5650: erragt wf_agent_t;
5651: l_paramlist wf_parameter_list_t;
5652: errMsg varchar2(4000);
5653: errStack varchar2(4000);
5654:
5655: begin

Line 5717: l_paramlist wf_parameter_list_t;

5713: p_event in out NOCOPY WF_EVENT_T) return varchar2
5714: is
5715: l_eventName varchar2(80);
5716: l_eventkey varchar(80);
5717: l_paramlist wf_parameter_list_t;
5718: type t_users is table of boolean index by varchar2(320);
5719: l_sum_users t_users ;
5720:
5721: l_event_paramlist wf_parameter_list_t;

Line 5721: l_event_paramlist wf_parameter_list_t;

5717: l_paramlist wf_parameter_list_t;
5718: type t_users is table of boolean index by varchar2(320);
5719: l_sum_users t_users ;
5720:
5721: l_event_paramlist wf_parameter_list_t;
5722: -- NOTE: For bug 6049086, more_info_role is included in the SQL
5723: -- in order to send summary mail to more_info_role and not
5724: -- to recepient_role if notification more_info_role is not null.
5725: CURSOR c_get_summary_roles is

Line 5767: l_event_paramlist := wf_parameter_list_t();

5763: l_paramList := p_event.getParameterList();
5764:
5765: for rec_summary_role in c_get_summary_roles loop
5766:
5767: l_event_paramlist := wf_parameter_list_t();
5768: wf_event.addParameterToList('ROLE_NAME',
5769: rec_summary_role.RECIPIENT,
5770: l_event_paramlist);
5771: -- Set AQs correlation id to item type i.e. 'WFMAIL'

Line 5797: l_event_paramlist := wf_parameter_list_t();

5793:
5794: -- Checks that the summary event is already raised for the user in
5795: -- cursor 'c_get_summary_roles'. If not, then only raise the event here
5796: if(not l_sum_users.exists(rec_role_user.user_name)) then
5797: l_event_paramlist := wf_parameter_list_t();
5798: wf_event.addParameterToList('ROLE_NAME',
5799: rec_role_user.user_name,
5800: l_event_paramlist);
5801: -- Set AQs correlation id to item type i.e. 'WFMAIL'

Line 5995: param_list wf_parameter_list_t;

5991: FUNCTION error_rule(p_subscription_guid in raw,
5992: p_event in out nocopy wf_event_t) return varchar2
5993: is
5994: nid number;
5995: param_list wf_parameter_list_t;
5996: cb varchar2(240);
5997: ctx varchar2(2000);
5998: itemType varchar2(8);
5999: itemKey varchar2(240);