[Home] [Help]
1146: atype varchar2(8);
1147: format varchar2(240);
1148: rname varchar2(320);
1149: role_info_tbl wf_directory.wf_local_roles_tbl_type;
1150: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
1151: l_language varchar2(30);
1152: l_recipient_role varchar2(320);
1153:
1154: begin
3699: attr_dvalue date;
3700: -- Bug 2376033
3701: attr_evalue wf_event_t;
3702: -- Bug 2283697
3703: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
3704: -- the following variables for Dynamic SQL
3705: sqlbuf varchar2(2000);
3706: l_from_role varchar2(320);
3707: l_send_comment varchar2(4000);
4304: -- Bug 2331070
4305: l_from_role varchar2(320);
4306:
4307: --Bug 2283697
4308: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
4309:
4310: --Bug 2474770
4311: l_more_info_role VARCHAR2(320);
4312: l_dispname VARCHAR2(360);
4678: context varchar2(2000);
4679: dummy pls_integer;
4680:
4681: --Bug 2283697
4682: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
4683:
4684: --Bug 2373925
4685: l_mail varchar2(4);
4686: l_from_role varchar2(320);
5194:
5195: result attrs%rowtype;
5196:
5197: --Bug 2283697
5198: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
5199:
5200: l_language varchar2(30);
5201:
5202: begin
6088: l_nls_sort varchar2(64);
6089: l_nls_currency varchar2(64);
6090:
6091: l_defer_denormalize boolean;
6092: l_parameterlist wf_parameter_list_t;
6093: l_orig_nlsterritory varchar2(64);
6094: l_orig_nlsCode varchar2(64);
6095: l_orig_nlsDateFormat varchar2(64);
6096: l_orig_nlsDateLang varchar2(64);
6139: end if;
6140: end if;
6141:
6142: l_defer_denormalize := FALSE;
6143: l_parameterlist := wf_parameter_list_t();
6144:
6145: -- if username is supplied, use the language setting of such user
6146: -- default to Recipient's setting if no valid language is found.
6147: begin
6531: mydispname varchar2(360);
6532: l_messageType varchar2(8);
6533: l_messageName varchar2(30);
6534: l_groupId number;
6535: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
6536: mailpref varchar2 (8);
6537: recipient_role VARCHAR2 (320);
6538: cb varchar2(240);
6539: context varchar2(2000);
6942: l_messageType varchar2(8);
6943: l_messageName varchar2(30);
6944: l_groupId number;
6945:
6946: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
6947: l_mail_preference varchar2 (8);
6948: l_callback_function varchar2(240);
6949: l_context varchar2(2000);
6950: l_anon_block varchar2(2000);
7401: mydispname varchar2(360);
7402: l_messageType varchar2(8);
7403: l_messageName varchar2(30);
7404: l_groupId number;
7405: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
7406: role_info_tbl wf_directory.wf_local_roles_tbl_type;
7407: l_username varchar2(320);
7408: l_stat varchar2(8);
7409:
7831: replyby varchar2(320);
7832: l_messageType varchar2(8);
7833: l_messageName varchar2(30);
7834: l_groupId number;
7835: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
7836:
7837: l_more_info_role varchar2(320);
7838: cb varchar2(240);
7839: context varchar2(2000);
9466: l_mail_status varchar2(8);
9467: l_status varchar2(8);
9468: l_message_type varchar2(8);
9469: l_message_name varchar2(30);
9470: l_paramlist wf_parameter_list_t := wf_parameter_list_t();
9471:
9472: l_display_name varchar2(360);
9473: l_email_address varchar2(320);
9474: l_notification_pref varchar2(8);
9859: -- Dynamic sql stuff
9860: sqlbuf varchar2(2000);
9861:
9862: --Bug 2283697
9863: l_parameterlist wf_parameter_list_t := wf_parameter_list_t();
9864:
9865:
9866: cursor notification_attrs_cursor(nid number) is
9867: select WNA.NAME, WMA.TYPE, WNA.TEXT_VALUE, WNA.NUMBER_VALUE,
10168: is
10169:
10170: l_eventname varchar2(60) := 'oracle.apps.wf.notification.wl.response.message';
10171: l_event wf_event_t;
10172: l_parameterlist wf_parameter_list_t := wf_parameter_list_t() ;
10173: l_agent wf_agent_t := null ;
10174:
10175: l_itemType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE := null;
10176: l_lookupCode_cnt number := 0;