APPS.PAY_EVENT_GROUPS_API SQL Statements

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

Line: 173

procedure update_event_group
(
   p_validate                     in     boolean default false
  ,p_effective_date               in     date
  ,p_event_group_id               in     number
  ,p_object_version_number        in out nocopy number
  ,p_event_group_name             in     varchar2  default hr_api.g_varchar2
  ,p_event_group_type             in     varchar2  default hr_api.g_varchar2
  ,p_proration_type               in     varchar2  default hr_api.g_varchar2
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
  ,p_time_definition_id           in     number    default hr_api.g_number
) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_event_group';

Line: 196

  savepoint update_event_group;

Line: 204

  pay_event_groups_bk2.update_event_group_b
  (p_effective_date            => p_effective_date
  ,p_event_group_id        => p_event_group_id
  ,p_object_version_number => l_object_version_number
  ,p_event_group_name   => p_event_group_name
  ,p_event_group_type   => p_event_group_type
  ,p_proration_type     => p_proration_type
  ,p_business_group_id  => p_business_group_id
  ,p_legislation_code   => p_legislation_code
  ,p_time_definition_id => p_time_definition_id
  );

Line: 218

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

Line: 241

  pay_event_groups_bk2.update_event_group_a
  (p_effective_date            => p_effective_date
  ,p_event_group_id        => p_event_group_id
  ,p_object_version_number => l_object_version_number
  ,p_event_group_name   => p_event_group_name
  ,p_event_group_type   => p_event_group_type
  ,p_proration_type     => p_proration_type
  ,p_business_group_id  => p_business_group_id
  ,p_legislation_code   => p_legislation_code
  ,p_time_definition_id => p_time_definition_id
  );

Line: 255

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

Line: 272

    ROLLBACK TO update_event_group;

Line: 276

    ROLLBACK TO update_event_group;

Line: 281

end update_event_group;

Line: 309

procedure delete_event_group
(
   p_validate                       in     boolean default false
  ,p_event_group_id                 in     number
  ,p_object_version_number          in number
) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_event_group';

Line: 325

  savepoint delete_event_group;

Line: 333

  pay_event_groups_bk3.delete_event_group_b
  (
    p_event_group_id           => p_event_group_id
   ,p_object_version_number    => l_object_version_number
  );

Line: 341

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

Line: 357

  pay_event_groups_bk3.delete_event_group_a
  (
    p_event_group_id           => p_event_group_id
   ,p_object_version_number    => l_object_version_number
  );

Line: 365

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

Line: 379

    ROLLBACK TO delete_event_group;

Line: 382

    ROLLBACK TO delete_event_group;

Line: 386

end delete_event_group ;