APPS.PAY_EVENT_UPDATES_API SQL Statements

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

Line: 14

procedure create_event_update
  (p_validate                       in     boolean default false
  ,p_effective_date               in     date
  ,p_dated_table_id                 in     number
  ,p_change_type                    in     varchar2
  ,p_table_name                     in     varchar2 default null
  ,p_column_name                    in     varchar2 default null
  ,p_business_group_id              in     number   default null
  ,p_legislation_code               in     varchar2 default null
  ,p_event_type                     in     varchar2 default null
  ,p_event_update_id                   out nocopy number
  ,p_object_version_number             out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'create_event_update';

Line: 32

  l_event_update_id       number;

Line: 38

    savepoint create_event_update;

Line: 49

  pay_event_updates_bk1.create_event_update_b
  (p_effective_date               => p_effective_date
  ,p_dated_table_id                 => p_dated_table_id
  ,p_change_type                    => p_change_type
  ,p_table_name                     => p_table_name
  ,p_column_name                    => p_column_name
  ,p_business_group_id              => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_event_type                     => p_event_type
  );

Line: 62

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

Line: 76

  ,p_event_update_id                => l_event_update_id
  ,p_object_version_number   => l_object_version_number
  );

Line: 83

  pay_event_updates_bk1.create_event_update_a
  (p_effective_date               => p_effective_date
  ,p_dated_table_id                 => p_dated_table_id
  ,p_change_type                    => p_change_type
  ,p_table_name                     => p_table_name
  ,p_column_name                    => p_column_name
  ,p_business_group_id              => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_event_type                     => p_event_type
  ,p_event_update_id                => l_event_update_id
  ,p_object_version_number   => l_object_version_number
  );

Line: 98

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

Line: 107

  p_event_update_id               := l_event_update_id;

Line: 116

    ROLLBACK TO create_event_update;

Line: 118

end create_event_update;

Line: 127

procedure update_event_update
  (p_validate                       in     boolean default false
  ,p_effective_date               in     date
  ,p_event_update_id              in     number
  ,p_object_version_number        in out nocopy number
  ,p_dated_table_id               in     number    default hr_api.g_number
  ,p_change_type                  in     varchar2  default hr_api.g_varchar2
  ,p_table_name                   in     varchar2  default hr_api.g_varchar2
  ,p_column_name                  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_event_type                   in     varchar2  default hr_api.g_varchar2
  )is
  --
  -- Declare cursors and local variables
  --
  l_proc         varchar2(72) := g_package ||'update_event_update';

Line: 151

    savepoint update_event_update;

Line: 159

  pay_event_updates_bk2.update_event_update_b
  (p_effective_date               => p_effective_date
  ,p_event_update_id                => p_event_update_id
  ,p_object_version_number   => l_object_version_number
  ,p_dated_table_id                 => p_dated_table_id
  ,p_change_type                    => p_change_type
  ,p_table_name                     => p_table_name
  ,p_column_name                    => p_column_name
  ,p_business_group_id              => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_event_type                     => p_event_type
  );

Line: 174

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

Line: 181

  ,p_event_update_id                => p_event_update_id
  ,p_object_version_number   => l_object_version_number
  ,p_dated_table_id                 => p_dated_table_id
  ,p_change_type                    => p_change_type
  ,p_table_name                     => p_table_name
  ,p_column_name                    => p_column_name
  ,p_business_group_id              => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_event_type                     => p_event_type
  );

Line: 197

  pay_event_updates_bk2.update_event_update_a
  (p_effective_date               => p_effective_date
  ,p_event_update_id                => p_event_update_id
  ,p_object_version_number   => l_object_version_number
  ,p_dated_table_id                 => p_dated_table_id
  ,p_change_type                    => p_change_type
  ,p_table_name                     => p_table_name
  ,p_column_name                    => p_column_name
  ,p_business_group_id              => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_event_type                     => p_event_type
  );

Line: 212

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

Line: 229

    ROLLBACK TO update_event_update;

Line: 232

end update_event_update;

Line: 242

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

Line: 257

    savepoint delete_event_update;

Line: 264

  pay_event_updates_bk3.delete_event_update_b
  (
    p_event_update_id                => p_event_update_id
   ,p_object_version_number    => p_object_version_number
  );

Line: 272

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

Line: 279

    p_event_update_id                => p_event_update_id
   ,p_object_version_number    => p_object_version_number
  );

Line: 285

  pay_event_updates_bk3.delete_event_update_a
  (
    p_event_update_id                => p_event_update_id
   ,p_object_version_number    => p_object_version_number
  );

Line: 293

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

Line: 307

    ROLLBACK TO delete_event_update;

Line: 309

end delete_event_update;