DBA Data[Home] [Help]

APPS.ECX_RULE dependencies on WF_EVENT_SUBSCRIPTIONS

Line 36: from wf_event_subscriptions

32: l_module varchar2(2000);
33:
34: cursor c_debug_level
35: is select parameters
36: from wf_event_subscriptions
37: where guid = p_subscription_guid;
38:
39:
40: begin

Line 301: from wf_event_subscriptions

297: begin
298: -- Get Params
299: select parameters
300: into r_myparams
301: from wf_event_subscriptions
302: where guid = p_subscription_guid;
303: exception
304: when others then
305: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

Line 671: from wf_event_subscriptions

667: begin
668: -- Get Params
669: select parameters
670: into myparams
671: from wf_event_subscriptions
672: where guid = p_subscription_guid;
673: exception
674: when others then
675: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 765: from wf_event_subscriptions

761: select out_agent_guid, to_agent_guid, wf_process_type, wf_process_name,
762: priority, parameters, map_code, standard_type, standard_code
763: into l_out_guid, l_to_guid, l_wftype, l_wfname, l_pri, l_subparams,
764: l_map_code, l_std_type, l_std_code
765: from wf_event_subscriptions
766: where guid = p_subscription_guid;
767:
768: if (p_wftype is not null) then
769: l_wftype := p_wftype;

Line 1164: from wf_event_subscriptions

1160: l_sub_param varchar2(4000);
1161:
1162: cursor c_sub_param is
1163: select parameters
1164: from wf_event_subscriptions
1165: where guid = p_subscription_guid;
1166:
1167: begin
1168: -- always takes event debug mode over the subscription debug mode.