APPS.PAY_EVENT_VALUE_CHANGES_API SQL Statements

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

Line: 95

    select count(*)
    into  l_counter
    from  pay_event_value_changes_f
    where p_effective_date between effective_start_date and effective_end_date
    and   p_datetracked_event_id = datetracked_event_id
    and   default_event = 'Y';

Line: 220

procedure update_event_value_change
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_event_qualifier_id           in     number
  ,p_default_event                in     varchar2
  ,p_valid_event                  in     varchar2
  ,p_datetracked_event_id         in     number   default hr_api.g_number
  ,p_business_group_id            in     number   default hr_api.g_number
  ,p_legislation_code             in     varchar2 default hr_api.g_varchar2
  ,p_from_value                   in     varchar2 default hr_api.g_varchar2
  ,p_to_value                     in     varchar2 default hr_api.g_varchar2
  ,p_proration_style              in     varchar2 default hr_api.g_varchar2
  ,p_qualifier_value              in     varchar2 default hr_api.g_varchar2
  ,p_event_value_change_id        in     number
  ,p_object_version_number        in out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72) := g_package||'update_event_value_change';

Line: 262

  savepoint update_event_value_change;

Line: 273

    pay_event_value_changes_bk2.update_event_value_change_b
      (p_effective_date           =>  l_effective_date
      ,p_datetrack_mode           => p_datetrack_mode
      ,p_event_qualifier_id       => p_event_qualifier_id
      ,p_default_event            => p_default_event
      ,p_valid_event              => p_valid_event
      ,p_datetracked_event_id     => p_datetracked_event_id
      ,p_business_group_id        => p_business_group_id
      ,p_legislation_code         => p_legislation_code
      ,p_from_value               => p_from_value
      ,p_to_value                 => p_to_value
      ,p_proration_style          => p_proration_style
      ,p_qualifier_value          => p_qualifier_value
      ,p_event_value_change_id    => p_event_value_change_id
      ,p_object_version_number    => l_object_version_number
      );

Line: 293

        (p_module_name => 'update_event_value_change'
        ,p_hook_type   => 'BP'
        );

Line: 328

    pay_event_value_changes_bk2.update_event_value_change_a
      (p_effective_date           =>  l_effective_date
      ,p_datetrack_mode           => p_datetrack_mode
      ,p_event_qualifier_id       => p_event_qualifier_id
      ,p_default_event            => p_default_event
      ,p_valid_event              => p_valid_event
      ,p_datetracked_event_id     => p_datetracked_event_id
      ,p_business_group_id        => p_business_group_id
      ,p_legislation_code         => p_legislation_code
      ,p_from_value               => p_from_value
      ,p_to_value                 => p_to_value
      ,p_proration_style          => p_proration_style
      ,p_qualifier_value          => p_qualifier_value
      ,p_event_value_change_id    => p_event_value_change_id
      ,p_object_version_number    => l_object_version_number
      ,p_effective_start_date     =>  l_effective_start_date
      ,p_effective_end_date       =>  l_effective_end_date
      );

Line: 349

        (p_module_name => 'update_event_value_change_a'
        ,p_hook_type   => 'AP'
        );

Line: 374

    rollback to update_event_value_change;

Line: 388

    rollback to update_event_value_change;

Line: 392

end update_event_value_change;

Line: 399

procedure delete_event_value_change
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_mode                in     varchar2
  ,p_event_value_change_id         in     number
  ,p_object_version_number         in out nocopy number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc               varchar2(72) := g_package||'delete_event_value_change';

Line: 429

  savepoint delete_event_value_change;

Line: 439

    pay_event_value_changes_bk3.delete_event_value_change_b
     (p_effective_date              =>     l_effective_date
     ,p_datetrack_mode              =>     p_datetrack_mode
     ,p_event_value_change_id       =>     p_event_value_change_id
     ,p_object_version_number       =>     p_object_version_number
     ,p_business_group_id           =>     p_business_group_id
     ,p_legislation_code            =>     p_legislation_code
     );

Line: 451

        (p_module_name => 'delete_event_value_change'
        ,p_hook_type   => 'BP'
        );

Line: 492

    pay_event_value_changes_bk3.delete_event_value_change_a
      (p_effective_date            => l_effective_date
      ,p_datetrack_mode     => p_datetrack_mode
      ,p_event_value_change_id     => p_event_value_change_id
      ,p_object_version_number     => p_object_version_number
      ,p_business_group_id         => p_business_group_id
      ,p_legislation_code          => p_legislation_code
      ,p_effective_start_date      => l_effective_start_date
      ,p_effective_end_date        => l_effective_end_date
      );

Line: 525

    ROLLBACK TO delete_event_value_change;

Line: 539

    ROLLBACK TO delete_event_value_change;

Line: 546

end delete_event_value_change;