APPS.WF_EVENT_FUNCTIONS_PKG dependencies on WF_EVENT_SUBSCRIPTIONS

Line 72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

68: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
69: 2,'/');
70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));
71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then
72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

Line 74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

70: dtd := wf_event_groups_pkg.generate2(l_parameters(1), l_parameters(2));
71: elsif p_event_name = 'oracle.apps.wf.event.subscription.create' then
72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
77: /** Start of Bug 2398759 to support Agent Groups **/
78: elsif p_event_name = 'oracle.apps.wf.agent.group.create' then

Line 76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);

72: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
73: elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
74: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
75: elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
76: dtd := wf_event_subscriptions_pkg.generate(p_event_key);
77: /** Start of Bug 2398759 to support Agent Groups **/
78: elsif p_event_name = 'oracle.apps.wf.agent.group.create' then
79: l_parameters := wf_event_functions_pkg.parameters(p_event_key,
80: 2,'/');

Line 190: wf_event_subscriptions_pkg.receive(x_message);

186: wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));
187: elsif l_eventname = 'oracle.apps.wf.event.group.update' then
188: wf_event_groups_pkg.receive(x_message);
189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);
193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then
194: wf_event_subscriptions_pkg.receive(x_message);

Line 192: wf_event_subscriptions_pkg.delete_row(l_eventkey);

188: wf_event_groups_pkg.receive(x_message);
189: elsif l_eventname = 'oracle.apps.wf.event.subscription.create' then
190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);
193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then
194: wf_event_subscriptions_pkg.receive(x_message);
195: else
196: return('ERROR');

Line 194: wf_event_subscriptions_pkg.receive(x_message);

190: wf_event_subscriptions_pkg.receive(x_message);
191: elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
192: wf_event_subscriptions_pkg.delete_row(l_eventkey);
193: elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then
194: wf_event_subscriptions_pkg.receive(x_message);
195: else
196: return('ERROR');
197: end if;
198: elsif l_eventname = 'oracle.apps.wf.event.all.sync' then

Line 375: FROM wf_event_subscriptions

371: l_sqlstmt varchar2(240);
372:
373: CURSOR c_parameters IS
374: SELECT parameters
375: FROM wf_event_subscriptions
376: WHERE guid = p_subscription_guid;
377:
378: begin
379:

Line 448: FROM wf_event_subscriptions

444: --cursor to fetch subscription parameters
445:
446: CURSOR c_parameters (c_guid raw) IS
447: SELECT parameters
448: FROM wf_event_subscriptions
449: WHERE guid = c_guid;
450:
451: begin
452:

Line 523: from wf_event_subscriptions

519: l_NumSubParams := 0;
520: l_NumEvtParams := 0;
521:
522: select parameters into l_subParams
523: from wf_event_subscriptions
524: where guid = p_guid;
525:
526: -- Get a count on the subscription parameters.
527: while (eqPOS <> 0) loop

Line 705: update wf_event_subscriptions

701: update wf_events
702: set licensed_flag = l_LicenseFlag
703: where owner_tag = p_OwnerTag;
704:
705: update wf_event_subscriptions
706: set licensed_flag = l_LicenseFlag
707: where owner_tag = p_OwnerTag;
708:
709: end UpdateLicenseStatus;