[Home] [Help]
3031:
3032: i pls_integer;
3033:
3034: l_event_t wf_event_t;
3035: l_parmlist_t wf_parameter_list_t;
3036: l_cells wf_notification.tdType;
3037: j number;
3038: l_result varchar2(32000);
3039:
3233: aname varchar2(100);
3234: l_event_t wf_event_t;
3235: l_toagent wf_agent_t;
3236: l_skip_sub varchar2(300) := null;
3237: l_parameterList wf_parameter_list_t := null;
3238:
3239: begin
3240:
3241: IF (funcmode = 'RUN') THEN
3254: -- If the SKIP_ERROR_SUB is not null, then this parameber will
3255: -- be passed over to raise in all the cases.
3256: l_skip_sub := l_event_t.GETVALUEFORPARAMETER('SKIP_ERROR_SUB');
3257: if (l_skip_sub is not null) then
3258: l_parameterList := wf_parameter_list_t();
3259: wf_event.addParameterToList('SKIP_ERROR_SUB', l_skip_sub, l_parameterList);
3260: end if;
3261:
3262: IF aname = 'RAISE_KEY' THEN
3473: l_cells2 wf_notification.tdType;
3474: i pls_integer;
3475: j pls_integer;
3476: l_document varchar2(32000);
3477: l_sub_param_list wf_parameter_list_t;
3478: l_event_t wf_event_t;
3479: l_result varchar2(22000);
3480: l_result2 varchar2(10000);
3481: l_url varchar2(500);
3715: l_event_t wf_event_t;
3716: l_error_type varchar2(240);
3717: l_error_message varchar2(2000);
3718: l_error_stack varchar2(2000);
3719: l_parmlist_t wf_parameter_list_t;
3720:
3721:
3722: l_nid number;
3723: l_subject WF_NOTIFICATIONS.SUBJECT%TYPE;
3852: resultout out nocopy varchar2)
3853: IS
3854:
3855: l_event wf_event_t;
3856: l_paramlist wf_parameter_list_t := null;
3857: l_sysName WF_SYSTEMS.NAME%TYPE := null;
3858: l_agent wf_agent_t := null ;
3859:
3860:
3900: resultout out nocopy varchar2)
3901: is
3902:
3903: l_event_t wf_event_t;
3904: l_paramlist wf_parameter_list_t := null;
3905: l_nid number;
3906: l_user WF_LOCAL_ROLES.NAME%TYPE;
3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;