APPS.WF_NOTIFICATION dependencies on WF_PARAMETER_LIST_T

Line 1111: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

1107: atype varchar2(8);
1108: format varchar2(240);
1109: rname varchar2(320);
1110: role_info_tbl wf_directory.wf_local_roles_tbl_type;
1111: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
1112: l_language varchar2(30);
1113: l_recipient_role varchar2(320);
1114:
1115: begin

Line 3589: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

3585: attr_dvalue date;
3586: -- Bug 2376033
3587: attr_evalue wf_event_t;
3588: -- Bug 2283697
3589: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
3590: -- the following variables for Dynamic SQL
3591: sqlbuf varchar2(2000);
3592: l_from_role varchar2(320);
3593: l_send_comment varchar2(4000);

Line 4166: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

4162: -- Bug 2331070
4163: l_from_role varchar2(320);
4164:
4165: --Bug 2283697
4166: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
4167:
4168: --Bug 2474770
4169: l_more_info_role VARCHAR2(320);
4170: l_dispname VARCHAR2(360);

Line 4517: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

4513: context varchar2(2000);
4514: dummy pls_integer;
4515:
4516: --Bug 2283697
4517: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
4518:
4519: --Bug 2373925
4520: l_mail varchar2(4);
4521: l_from_role varchar2(320);

Line 4753: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

4749: -- Dynamic sql stuff
4750: sqlbuf varchar2(2000);
4751:
4752: --Bug 2283697
4753: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
4754:
4755:
4756: cursor notification_attrs_cursor(nid number) is
4757: select WNA.NAME, WMA.TYPE, WNA.TEXT_VALUE, WNA.NUMBER_VALUE,

Line 5362: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

5358:
5359: result attrs%rowtype;
5360:
5361: --Bug 2283697
5362: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
5363:
5364: l_language varchar2(30);
5365:
5366: begin

Line 6262: l_parameterlist wf_parameter_list_t;

6258: l_nls_sort varchar2(64);
6259: l_nls_currency varchar2(64);
6260:
6261: l_defer_denormalize boolean;
6262: l_parameterlist wf_parameter_list_t;
6263: l_orig_nlsterritory varchar2(64);
6264: l_orig_nlsCode varchar2(64);
6265: l_orig_nlsDateFormat varchar2(64);
6266: l_orig_nlsDateLang varchar2(64);

Line 6313: l_parameterlist := wf_parameter_list_t();

6309: end if;
6310: end if;
6311:
6312: l_defer_denormalize := FALSE;
6313: l_parameterlist := wf_parameter_list_t();
6314:
6315: -- if username is supplied, use the language setting of such user
6316: -- default to Recipient's setting if no valid language is found.
6317: begin

Line 6705: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

6701: mydispname varchar2(360);
6702: l_messageType varchar2(8);
6703: l_messageName varchar2(30);
6704: l_groupId number;
6705: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
6706: mailpref varchar2 (8);
6707: recipient_role VARCHAR2 (320);
6708: cb varchar2(240);
6709: context varchar2(2000);

Line 7243: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

7239: mydispname varchar2(360);
7240: l_messageType varchar2(8);
7241: l_messageName varchar2(30);
7242: l_groupId number;
7243: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
7244: role_info_tbl wf_directory.wf_local_roles_tbl_type;
7245: l_username varchar2(320);
7246: l_stat varchar2(8);
7247:

Line 7609: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();

7605: replyby varchar2(320);
7606: l_messageType varchar2(8);
7607: l_messageName varchar2(30);
7608: l_groupId number;
7609: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
7610:
7611: l_more_info_role varchar2(320);
7612: cb varchar2(240);
7613: context varchar2(2000);

Line 9222: l_paramlist wf_parameter_list_t := wf_parameter_list_t();

9218: l_mail_status varchar2(8);
9219: l_status varchar2(8);
9220: l_message_type varchar2(8);
9221: l_message_name varchar2(30);
9222: l_paramlist wf_parameter_list_t := wf_parameter_list_t();
9223:
9224: l_display_name varchar2(360);
9225: l_email_address varchar2(320);
9226: l_notification_pref varchar2(8);