APPS.WF_EVENT_FUNCTIONS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

  elsif p_event_name = 'oracle.apps.wf.event.system.delete' then
    dtd := wf_systems_pkg.generate(p_event_key);

Line: 33

  elsif p_event_name = 'oracle.apps.wf.event.system.update' then
    dtd := wf_systems_pkg.generate(p_event_key);

Line: 37

  elsif p_event_name = 'oracle.apps.wf.event.agent.delete' then
    dtd := wf_agents_pkg.generate(p_event_key);

Line: 39

  elsif p_event_name = 'oracle.apps.wf.event.agent.update' then
    dtd := wf_agents_pkg.generate(p_event_key);

Line: 45

  elsif p_event_name = 'oracle.apps.wf.event.agentgroup.delete' then
    l_parameters := wf_event_functions_pkg.parameters(p_event_key,
                                2,'/');

Line: 49

  elsif p_event_name = 'oracle.apps.wf.event.agentgroup.update' then
    l_parameters := wf_event_functions_pkg.parameters(p_event_key,
                                2,'/');

Line: 55

  elsif p_event_name = 'oracle.apps.wf.event.event.delete' then
    dtd := wf_events_pkg.generate(p_event_key);

Line: 57

  elsif p_event_name = 'oracle.apps.wf.event.event.update' then
    dtd := wf_events_pkg.generate(p_event_key);

Line: 63

  elsif p_event_name = 'oracle.apps.wf.event.group.delete' then
    l_parameters := wf_event_functions_pkg.parameters(p_event_key,
                                2,'/');

Line: 67

  elsif p_event_name = 'oracle.apps.wf.event.group.update' then
    l_parameters := wf_event_functions_pkg.parameters(p_event_key,
                                2,'/');

Line: 73

  elsif p_event_name = 'oracle.apps.wf.event.subscription.delete' then
    dtd := wf_event_subscriptions_pkg.generate(p_event_key);

Line: 75

  elsif p_event_name = 'oracle.apps.wf.event.subscription.update' then
    dtd := wf_event_subscriptions_pkg.generate(p_event_key);

Line: 82

  elsif p_event_name = 'oracle.apps.wf.agent.group.delete' then
    l_parameters := wf_event_functions_pkg.parameters(p_event_key,
                                2,'/');

Line: 86

  elsif p_event_name = 'oracle.apps.wf.agent.group.update' then
    l_parameters := wf_event_functions_pkg.parameters(p_event_key,
                                2,'/');

Line: 157

    elsif l_eventname = 'oracle.apps.wf.event.system.delete' then
      wf_systems_pkg.delete_row(l_eventkey);

Line: 159

    elsif l_eventname = 'oracle.apps.wf.event.system.update' then
      wf_systems_pkg.receive(x_message);

Line: 163

    elsif l_eventname = 'oracle.apps.wf.event.agent.delete' then
      wf_agents_pkg.delete_row(l_eventkey);

Line: 165

    elsif l_eventname = 'oracle.apps.wf.event.agent.update' then
      wf_agents_pkg.receive(x_message);

Line: 169

    elsif l_eventname = 'oracle.apps.wf.agent.group.delete' then
      l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
                                2,'/');

Line: 172

      wf_agent_groups_pkg.delete_row(l_parameters(1), l_parameters(2));

Line: 173

    elsif l_eventname = 'oracle.apps.wf.agent.group.update' then
      wf_agent_groups_pkg.receive(x_message);

Line: 177

    elsif l_eventname = 'oracle.apps.wf.event.event.delete' then
      wf_events_pkg.delete_row(l_eventkey);

Line: 179

    elsif l_eventname = 'oracle.apps.wf.event.event.update' then
      wf_events_pkg.receive(x_message);

Line: 183

    elsif l_eventname = 'oracle.apps.wf.event.group.delete' then
      l_parameters := wf_event_functions_pkg.parameters(l_eventkey,
                                2,'/');

Line: 186

      wf_event_groups_pkg.delete_row(l_parameters(1), l_parameters(2));

Line: 187

    elsif l_eventname = 'oracle.apps.wf.event.group.update' then
      wf_event_groups_pkg.receive(x_message);

Line: 191

    elsif l_eventname = 'oracle.apps.wf.event.subscription.delete' then
      wf_event_subscriptions_pkg.delete_row(l_eventkey);

Line: 193

    elsif l_eventname = 'oracle.apps.wf.event.subscription.update' then
      wf_event_subscriptions_pkg.receive(x_message);

Line: 374

SELECT	parameters
FROM    wf_event_subscriptions
WHERE   guid = p_subscription_guid;

Line: 447

SELECT  parameters
FROM    wf_event_subscriptions
WHERE   guid = c_guid;

Line: 522

    select parameters into l_subParams
    from   wf_event_subscriptions
    where  guid = p_guid;

Line: 578

    WF_EVENT.sub_param_index.DELETE;

Line: 579

    WF_EVENT.evt_param_index.DELETE;

Line: 678

Procedure UpdateLicenseStatus (p_OwnerTag in varchar2, p_Status in varchar2)
is
    l_LicenseFlag varchar2(1);

Line: 689

        update wf_events
        set licensed_flag = l_LicenseFlag
        where owner_tag = p_OwnerTag;

Line: 693

        update wf_event_subscriptions
        set licensed_flag = l_LicenseFlag
        where owner_tag = p_OwnerTag;

Line: 697

end UpdateLicenseStatus;