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);
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
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,'/');
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);
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');
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
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:
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:
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
689: update wf_events
690: set licensed_flag = l_LicenseFlag
691: where owner_tag = p_OwnerTag;
692:
693: update wf_event_subscriptions
694: set licensed_flag = l_LicenseFlag
695: where owner_tag = p_OwnerTag;
696:
697: end UpdateLicenseStatus;