DBA Data[Home] [Help]

APPS.WF_STANDARD dependencies on WF_EVENT

Line 507: lEvent WF_EVENT_T;

503: actid in number,
504: funcmode in varchar2,
505: resultout in out nocopy varchar2)
506: is
507: lEvent WF_EVENT_T;
508: lAgent WF_AGENT_T;
509: lNVal NUMBER;
510: lDVal DATE;
511: lTVal VARCHAR2 (4000);

Line 719: lEvent WF_EVENT_T;

715: actid in number,
716: funcmode in varchar2,
717: resultout in out nocopy varchar2)
718: is
719: lEvent WF_EVENT_T;
720: lNVal NUMBER;
721: lDVal DATE;
722: lTVal VARCHAR2 (4000);
723: lAName VARCHAR2(30);

Line 899: lEvent WF_EVENT_T;

895: actid in number,
896: funcmode in varchar2,
897: resultout in out nocopy varchar2)
898: is
899: lEvent WF_EVENT_T;
900: lNVal NUMBER;
901: lDVal DATE;
902: lTVal VARCHAR2 (4000);
903: lAName VARCHAR2(30);

Line 2861: l_event_t wf_event_t;

2857: itemkey VARCHAR2,
2858: actid NUMBER,
2859: funcmode VARCHAR2,
2860: resultout OUT NOCOPY VARCHAR2 ) IS
2861: l_event_t wf_event_t;
2862: l_error_name varchar2(240);
2863: l_error_type varchar2(240);
2864: l_error_message varchar2(2000);
2865: l_error_stack varchar2(2000);

Line 2912: from wf_event_subscriptions

2908: --
2909: if l_subscription is not null then
2910: -- If a subscription found, look at its source
2911: select source_type into l_source
2912: from wf_event_subscriptions
2913: where guid = l_subscription;
2914:
2915: if l_source = 'ERROR' then
2916: l_source := 'LOCAL';

Line 2947: wf_event_html.GetFWKEvtSubscriptionUrl(l_subscription, l_url);

2943: -- Get the Errored Subscription GUID
2944: l_subscription := l_event_t.GetErrorSubscription();
2945:
2946: -- Generate the URL
2947: wf_event_html.GetFWKEvtSubscriptionUrl(l_subscription, l_url);
2948: l_eventdataurl := wf_oam_util.GetViewXMLURL(p_eventattribute => 'EVENT_MESSAGE',
2949: p_itemtype => itemtype,
2950: p_itemkey => itemkey);
2951:

Line 3034: l_event_t wf_event_t;

3030: l_receive_date_text varchar2(60);
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);

Line 3099: l_cells(i) := wf_core.translate('WF_EVENT_HEADING');

3095: --
3096: -- Build the Table
3097: if (display_type = wf_notification.doc_html) then
3098: i := 1;
3099: l_cells(i) := wf_core.translate('WF_EVENT_HEADING');
3100: l_cells(i) := 'S30%:'||l_cells(i);
3101:
3102: i := i + 1;
3103: l_cells(i) := wf_core.translate('WF_VALUE');

Line 3107: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_NAME');

3103: l_cells(i) := wf_core.translate('WF_VALUE');
3104: l_cells(i) := 'S70%:'||l_cells(i);
3105:
3106: i := i + 1;
3107: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_NAME');
3108: i := i + 1;
3109: l_cells(i) := 'S:'||nvl(l_event_t.GetEventName(),'&'||'nbsp');
3110:
3111: i := i + 1;

Line 3112: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_KEY');

3108: i := i + 1;
3109: l_cells(i) := 'S:'||nvl(l_event_t.GetEventName(),'&'||'nbsp');
3110:
3111: i := i + 1;
3112: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_KEY');
3113: i := i + 1;
3114: l_cells(i) := 'S:'||nvl(l_event_t.GetEventKey(),'&'||'nbsp');
3115:
3116: i := i + 1;

Line 3155: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)

3151: i := i + 1;
3152: l_cells(i) := 'S:'||nvl(l_event_t.GetCorrelationId(),'&'||'nbsp');
3153:
3154: else
3155: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)
3156: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3157:
3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||

Line 3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||

3154: else
3155: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)
3156: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3157:
3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||
3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||

Line 3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||

3156: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3157:
3158: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3159: l_event_t.GetEventName()||Wf_Core.Newline||
3160: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3161: l_event_t.GetEventKey()||Wf_Core.Newline||
3162: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3163: l_From_Agent||Wf_Core.Newline||
3164: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||

Line 3234: l_event_t wf_event_t;

3230: funcmode in varchar2,
3231: resultout out nocopy varchar2 ) IS
3232:
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:

Line 3259: wf_event.addParameterToList('SKIP_ERROR_SUB', l_skip_sub, l_parameterList);

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
3263: wf_event.raise(p_event_name => l_event_t.GetEventName(),

Line 3263: wf_event.raise(p_event_name => l_event_t.GetEventName(),

3259: wf_event.addParameterToList('SKIP_ERROR_SUB', l_skip_sub, l_parameterList);
3260: end if;
3261:
3262: IF aname = 'RAISE_KEY' THEN
3263: wf_event.raise(p_event_name => l_event_t.GetEventName(),
3264: p_event_key => l_event_t.GetEventKey(),
3265: p_parameters => l_parameterList);
3266:
3267: ELSIF aname = 'RAISE_KEY_DATA' THEN

Line 3268: wf_event.raise(p_event_name => l_event_t.GetEventName(),

3264: p_event_key => l_event_t.GetEventKey(),
3265: p_parameters => l_parameterList);
3266:
3267: ELSIF aname = 'RAISE_KEY_DATA' THEN
3268: wf_event.raise(p_event_name => l_event_t.GetEventName(),
3269: p_event_key => l_event_t.GetEventKey(),
3270: p_event_data => l_event_t.GetEventData(),
3271: p_parameters => l_parameterList);
3272:

Line 3274: wf_event.raise(l_event_t.GetEventName(),

3270: p_event_data => l_event_t.GetEventData(),
3271: p_parameters => l_parameterList);
3272:
3273: ELSIF aname = 'RAISE_KEY_DATA_PARAM' THEN
3274: wf_event.raise(l_event_t.GetEventName(),
3275: l_event_t.GetEventKey(),
3276: l_event_t.GetEventData(),
3277: l_event_t.GetParameterList());
3278: ELSIF aname = 'ENQUEUE' THEN

Line 3281: wf_event.enqueue(l_event_t, l_toagent);

3277: l_event_t.GetParameterList());
3278: ELSIF aname = 'ENQUEUE' THEN
3279: l_toagent := l_event_t.GetToAgent();
3280: l_event_t.SetPriority(-1); -- want this dequeued ASAP
3281: wf_event.enqueue(l_event_t, l_toagent);
3282: ELSE
3283: wf_core.raise('WFSQL_ARGS');
3284:
3285: END IF;

Line 3321: from wf_event_subscriptions

3317: l_toagent varchar2(100);
3318:
3319: cursor c_agents is
3320: select out_agent_guid, to_agent_guid
3321: from wf_event_subscriptions
3322: where guid = l_subguid;
3323:
3324: begin
3325:

Line 3400: l_event_t wf_event_t;

3396: funcmode in varchar2,
3397: resultout out nocopy varchar2)
3398: is
3399:
3400: l_event_t wf_event_t;
3401: l_toagentattr varchar2(100);
3402: l_system varchar2(30);
3403: l_agent varchar2(30);
3404:

Line 3478: l_event_t wf_event_t;

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);
3482: l_sub_url varchar2(1000);

Line 3498: FROM wf_event_subscriptions

3494: if (l_subscription is not null) then
3495:
3496: SELECT parameters, java_rule_func
3497: INTO l_params, l_rule_func
3498: FROM wf_event_subscriptions
3499: WHERE guid = l_subscription;
3500:
3501: l_sub_param_list := wf_event.GetParamListFromString(l_params);
3502:

Line 3501: l_sub_param_list := wf_event.GetParamListFromString(l_params);

3497: INTO l_params, l_rule_func
3498: FROM wf_event_subscriptions
3499: WHERE guid = l_subscription;
3500:
3501: l_sub_param_list := wf_event.GetParamListFromString(l_params);
3502:
3503: if (display_type = wf_notification.doc_html) then
3504: i := 1;
3505: l_cells(i) := 'S30%:'||wf_core.Translate('WF_PARAMETER');

Line 3670: l_event_t wf_event_t;

3666: actid in number,
3667: funcmode in varchar2,
3668: resultout in out nocopy varchar2)
3669: is
3670: l_event_t wf_event_t;
3671: l_subscription raw(16);
3672: l_action_code varchar2(30);
3673: begin
3674:

Line 3683: FROM wf_event_subscriptions

3679: l_subscription := l_event_t.GetErrorSubscription();
3680:
3681: SELECT action_code
3682: INTO l_action_code
3683: FROM wf_event_subscriptions
3684: WHERE guid = l_subscription;
3685:
3686: if (l_action_code is not null) then
3687: resultout := wf_engine.eng_completed||':'||l_action_code;

Line 3715: l_event_t wf_event_t;

3711: funcmode in varchar2,
3712: resultout out nocopy varchar2)
3713: is
3714:
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;

Line 3770: wf_event_html.GetFWKEvtSubscriptionUrl(l_subscription, l_url);

3766: -- Get the Errored Subscription GUID
3767: l_subscription := l_event_t.GetErrorSubscription();
3768:
3769: -- Generate the URL
3770: wf_event_html.GetFWKEvtSubscriptionUrl(l_subscription, l_url);
3771:
3772:
3773: -- Set the Item Attributes
3774:

Line 3855: l_event wf_event_t;

3851: funcmode in varchar2,
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:

Line 3870: l_agent.SYSTEM := wf_event.local_system_name;

3866: name => 'EVENT_MESSAGE' );
3867:
3868: l_agent := wf_agent_t(null, null);
3869: l_agent.name := 'WF_NOTIFICATION_IN';
3870: l_agent.SYSTEM := wf_event.local_system_name;
3871:
3872: -- enqueue the event message in to WF_NOTIFIOCATION_IN queue again
3873: wf_event_ojmstext_qh.enqueue( l_event, l_agent);
3874:

Line 3873: wf_event_ojmstext_qh.enqueue( l_event, l_agent);

3869: l_agent.name := 'WF_NOTIFICATION_IN';
3870: l_agent.SYSTEM := wf_event.local_system_name;
3871:
3872: -- enqueue the event message in to WF_NOTIFIOCATION_IN queue again
3873: wf_event_ojmstext_qh.enqueue( l_event, l_agent);
3874:
3875:
3876: EXCEPTION
3877: WHEN OTHERS THEN

Line 3903: l_event_t wf_event_t;

3899: funcmode in varchar2,
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;