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 2830: l_event_t wf_event_t;

2826: itemkey VARCHAR2,
2827: actid NUMBER,
2828: funcmode VARCHAR2,
2829: resultout OUT NOCOPY VARCHAR2 ) IS
2830: l_event_t wf_event_t;
2831: l_error_name varchar2(240);
2832: l_error_type varchar2(240);
2833: l_error_message varchar2(2000);
2834: l_error_stack varchar2(2000);

Line 2881: from wf_event_subscriptions

2877: --
2878: if l_subscription is not null then
2879: -- If a subscription found, look at its source
2880: select source_type into l_source
2881: from wf_event_subscriptions
2882: where guid = l_subscription;
2883:
2884: if l_source = 'ERROR' then
2885: l_source := 'LOCAL';

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

2911: -- Get the Errored Subscription GUID
2912: l_subscription := l_event_t.GetErrorSubscription();
2913:
2914: -- Generate the URL
2915: wf_event_html.GetFWKEvtSubscriptionUrl(l_subscription, l_url);
2916: l_eventdataurl := wf_oam_util.GetViewXMLURL(p_eventattribute => 'EVENT_MESSAGE',
2917: p_itemtype => itemtype,
2918: p_itemkey => itemkey);
2919:

Line 3002: l_event_t wf_event_t;

2998: l_receive_date_text varchar2(60);
2999:
3000: i pls_integer;
3001:
3002: l_event_t wf_event_t;
3003: l_parmlist_t wf_parameter_list_t;
3004: l_cells wf_notification.tdType;
3005: j number;
3006: l_result varchar2(32000);

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

3063: --
3064: -- Build the Table
3065: if (display_type = wf_notification.doc_html) then
3066: i := 1;
3067: l_cells(i) := wf_core.translate('WF_EVENT_HEADING');
3068: l_cells(i) := 'S30%:'||l_cells(i);
3069:
3070: i := i + 1;
3071: l_cells(i) := wf_core.translate('WF_VALUE');

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

3071: l_cells(i) := wf_core.translate('WF_VALUE');
3072: l_cells(i) := 'S70%:'||l_cells(i);
3073:
3074: i := i + 1;
3075: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_NAME');
3076: i := i + 1;
3077: l_cells(i) := 'S:'||nvl(l_event_t.GetEventName(),'&'||'nbsp');
3078:
3079: i := i + 1;

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

3076: i := i + 1;
3077: l_cells(i) := 'S:'||nvl(l_event_t.GetEventName(),'&'||'nbsp');
3078:
3079: i := i + 1;
3080: l_cells(i) := 'S:'||wf_core.translate('WF_EVENT_KEY');
3081: i := i + 1;
3082: l_cells(i) := 'S:'||nvl(l_event_t.GetEventKey(),'&'||'nbsp');
3083:
3084: i := i + 1;

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

3119: i := i + 1;
3120: l_cells(i) := 'S:'||nvl(l_event_t.GetCorrelationId(),'&'||'nbsp');
3121:
3122: else
3123: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)
3124: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3125:
3126: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3127: l_event_t.GetEventName()||Wf_Core.Newline||

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

3122: else
3123: l_result := Wf_Core.Newline||rpad(wf_core.translate('WF_EVENT_HEADING'),40)
3124: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3125:
3126: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3127: l_event_t.GetEventName()||Wf_Core.Newline||
3128: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3129: l_event_t.GetEventKey()||Wf_Core.Newline||
3130: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||

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

3124: ||wf_core.translate('WF_VALUE')||Wf_Core.Newline;
3125:
3126: l_result := l_result||rpad(wf_core.translate('WF_EVENT_NAME'),40)||
3127: l_event_t.GetEventName()||Wf_Core.Newline||
3128: rpad(wf_core.translate('WF_EVENT_KEY'),40)||
3129: l_event_t.GetEventKey()||Wf_Core.Newline||
3130: rpad(wf_core.translate('WF_FROM_AGENT_NAME'),40)||
3131: l_From_Agent||Wf_Core.Newline||
3132: rpad(wf_core.translate('WF_FROM_AGENT_SYSTEM'),40)||

Line 3202: l_event_t wf_event_t;

3198: funcmode in varchar2,
3199: resultout out nocopy varchar2 ) IS
3200:
3201: aname varchar2(100);
3202: l_event_t wf_event_t;
3203: l_toagent wf_agent_t;
3204: l_skip_sub varchar2(300) := null;
3205: l_parameterList wf_parameter_list_t := null;
3206:

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

3223: -- be passed over to raise in all the cases.
3224: l_skip_sub := l_event_t.GETVALUEFORPARAMETER('SKIP_ERROR_SUB');
3225: if (l_skip_sub is not null) then
3226: l_parameterList := wf_parameter_list_t();
3227: wf_event.addParameterToList('SKIP_ERROR_SUB', l_skip_sub, l_parameterList);
3228: end if;
3229:
3230: IF aname = 'RAISE_KEY' THEN
3231: wf_event.raise(p_event_name => l_event_t.GetEventName(),

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

3227: wf_event.addParameterToList('SKIP_ERROR_SUB', l_skip_sub, l_parameterList);
3228: end if;
3229:
3230: IF aname = 'RAISE_KEY' THEN
3231: wf_event.raise(p_event_name => l_event_t.GetEventName(),
3232: p_event_key => l_event_t.GetEventKey(),
3233: p_parameters => l_parameterList);
3234:
3235: ELSIF aname = 'RAISE_KEY_DATA' THEN

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

3232: p_event_key => l_event_t.GetEventKey(),
3233: p_parameters => l_parameterList);
3234:
3235: ELSIF aname = 'RAISE_KEY_DATA' THEN
3236: wf_event.raise(p_event_name => l_event_t.GetEventName(),
3237: p_event_key => l_event_t.GetEventKey(),
3238: p_event_data => l_event_t.GetEventData(),
3239: p_parameters => l_parameterList);
3240:

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

3238: p_event_data => l_event_t.GetEventData(),
3239: p_parameters => l_parameterList);
3240:
3241: ELSIF aname = 'RAISE_KEY_DATA_PARAM' THEN
3242: wf_event.raise(l_event_t.GetEventName(),
3243: l_event_t.GetEventKey(),
3244: l_event_t.GetEventData(),
3245: l_event_t.GetParameterList());
3246: ELSIF aname = 'ENQUEUE' THEN

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

3245: l_event_t.GetParameterList());
3246: ELSIF aname = 'ENQUEUE' THEN
3247: l_toagent := l_event_t.GetToAgent();
3248: l_event_t.SetPriority(-1); -- want this dequeued ASAP
3249: wf_event.enqueue(l_event_t, l_toagent);
3250: ELSE
3251: wf_core.raise('WFSQL_ARGS');
3252:
3253: END IF;

Line 3289: from wf_event_subscriptions

3285: l_toagent varchar2(100);
3286:
3287: cursor c_agents is
3288: select out_agent_guid, to_agent_guid
3289: from wf_event_subscriptions
3290: where guid = l_subguid;
3291:
3292: begin
3293:

Line 3368: l_event_t wf_event_t;

3364: funcmode in varchar2,
3365: resultout out nocopy varchar2)
3366: is
3367:
3368: l_event_t wf_event_t;
3369: l_toagentattr varchar2(100);
3370: l_system varchar2(30);
3371: l_agent varchar2(30);
3372:

Line 3446: l_event_t wf_event_t;

3442: i pls_integer;
3443: j pls_integer;
3444: l_document varchar2(32000);
3445: l_sub_param_list wf_parameter_list_t;
3446: l_event_t wf_event_t;
3447: l_result varchar2(22000);
3448: l_result2 varchar2(10000);
3449: l_url varchar2(500);
3450: l_sub_url varchar2(1000);

Line 3466: FROM wf_event_subscriptions

3462: if (l_subscription is not null) then
3463:
3464: SELECT parameters, java_rule_func
3465: INTO l_params, l_rule_func
3466: FROM wf_event_subscriptions
3467: WHERE guid = l_subscription;
3468:
3469: l_sub_param_list := wf_event.GetParamListFromString(l_params);
3470:

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

3465: INTO l_params, l_rule_func
3466: FROM wf_event_subscriptions
3467: WHERE guid = l_subscription;
3468:
3469: l_sub_param_list := wf_event.GetParamListFromString(l_params);
3470:
3471: if (display_type = wf_notification.doc_html) then
3472: i := 1;
3473: l_cells(i) := 'S30%:'||wf_core.Translate('WF_PARAMETER');

Line 3638: l_event_t wf_event_t;

3634: actid in number,
3635: funcmode in varchar2,
3636: resultout in out nocopy varchar2)
3637: is
3638: l_event_t wf_event_t;
3639: l_subscription raw(16);
3640: l_action_code varchar2(30);
3641: begin
3642:

Line 3651: FROM wf_event_subscriptions

3647: l_subscription := l_event_t.GetErrorSubscription();
3648:
3649: SELECT action_code
3650: INTO l_action_code
3651: FROM wf_event_subscriptions
3652: WHERE guid = l_subscription;
3653:
3654: if (l_action_code is not null) then
3655: resultout := wf_engine.eng_completed||':'||l_action_code;