APPS.PAY_DATED_TABLES_API SQL Statements

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

Line: 140

procedure update_dated_table
  (p_validate                       in     boolean default false
  ,p_dated_table_id               in     number
  ,p_object_version_number        in out nocopy number
  ,p_table_name                   in     varchar2  default hr_api.g_varchar2
  ,p_application_id               in     number    default hr_api.g_number
  ,p_surrogate_key_name           in     varchar2  default hr_api.g_varchar2
  ,p_start_date_name              in     varchar2  default hr_api.g_varchar2
  ,p_end_date_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_dyn_trigger_type             in     varchar2  default hr_api.g_varchar2
  ,p_dyn_trigger_package_name     in     varchar2  default hr_api.g_varchar2
  ,p_dyn_trig_pkg_generated       in     varchar2  default hr_api.g_varchar2
  )is
  --
  -- Declare cursors and local variables
  --
  l_proc         varchar2(72) := g_package ||'update_dated_table';

Line: 166

    savepoint update_dated_table;

Line: 174

  pay_dated_tables_bk2.update_dated_table_b
  (
   p_dated_table_id          => p_dated_table_id
  ,p_object_version_number   => l_object_version_number
  ,p_table_name              => p_table_name
  ,p_application_id          => p_application_id
  ,p_surrogate_key_name      => p_surrogate_key_name
  ,p_start_date_name         => p_start_date_name
  ,p_end_date_name           => p_end_date_name
  ,p_business_group_id       => p_business_group_id
  ,p_legislation_code        => p_legislation_code
  ,p_dyn_trigger_type        => p_dyn_trigger_type
  ,p_dyn_trigger_package_name => p_dyn_trigger_package_name
  ,p_dyn_trig_pkg_generated   => p_dyn_trig_pkg_generated
  );

Line: 192

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

Line: 218

  pay_dated_tables_bk2.update_dated_table_a
  (
   p_dated_table_id          => p_dated_table_id
  ,p_object_version_number   => l_object_version_number
  ,p_table_name              => p_table_name
  ,p_application_id          => p_application_id
  ,p_surrogate_key_name      => p_surrogate_key_name
  ,p_start_date_name         => p_start_date_name
  ,p_end_date_name           => p_end_date_name
  ,p_business_group_id       => p_business_group_id
  ,p_legislation_code        => p_legislation_code
  ,p_dyn_trigger_type        => p_dyn_trigger_type
  ,p_dyn_trigger_package_name => p_dyn_trigger_package_name
  ,p_dyn_trig_pkg_generated   => p_dyn_trig_pkg_generated
  );

Line: 236

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

Line: 253

    ROLLBACK TO update_dated_table;

Line: 263

end update_dated_table;

Line: 273

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

Line: 288

    savepoint delete_dated_table;

Line: 296

  pay_dated_tables_bk3.delete_dated_table_b
  (
    p_dated_table_id =>  p_dated_table_id
   ,p_object_version_number    => l_object_version_number
  );

Line: 304

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

Line: 320

  pay_dated_tables_bk3.delete_dated_table_a
  (
    p_dated_table_id =>  p_dated_table_id
   ,p_object_version_number    => l_object_version_number
  );

Line: 328

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

Line: 343

    ROLLBACK TO delete_dated_table;

Line: 345

end delete_dated_table;