APPS.PAY_EVENT_PROCEDURES_API SQL Statements

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

Line: 145

Procedure update_event_proc
  (p_validate                     in            boolean   default false
  ,p_event_procedure_id           in            number
  ,p_object_version_number        in out nocopy number
  ,p_dated_table_id               in            number    default hr_api.g_number
  ,p_procedure_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_column_name                  in            varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc         varchar2(72) := g_package ||'update_event_proc';

Line: 168

  savepoint UPDATE_EVENT_PROC;

Line: 175

  pay_event_procedures_bk2.update_event_proc_b
  (p_event_procedure_id            => p_event_procedure_id
  ,p_object_version_number        => l_object_version_number
  ,p_dated_table_id                 => p_dated_table_id
  ,p_procedure_name                 => p_procedure_name
  ,p_business_group_id              => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_column_name                    => p_column_name
  );

Line: 187

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

Line: 206

pay_event_procedures_bk2.update_event_proc_a
  (p_event_procedure_id            => p_event_procedure_id
  ,p_object_version_number        => l_object_version_number
  ,p_dated_table_id                 => p_dated_table_id
  ,p_procedure_name                 => p_procedure_name
  ,p_business_group_id              => p_business_group_id
  ,p_legislation_code               => p_legislation_code
  ,p_column_name                    => p_column_name
  );

Line: 218

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

Line: 241

    rollback to UPDATE_EVENT_PROC;

Line: 254

    rollback to UPDATE_EVENT_PROC;

Line: 264

end update_event_proc;

Line: 274

Procedure delete_event_proc
  (p_validate                             in     boolean   default false
  ,p_event_procedure_id                   in     number
  ,p_object_version_number                in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_event_proc';

Line: 288

  savepoint DELETE_EVENT_PROC;

Line: 295

  pay_event_procedures_bk3.delete_event_proc_b
  (
    p_event_procedure_id       => p_event_procedure_id
   ,p_object_version_number    => l_object_version_number
  );

Line: 303

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

Line: 319

pay_event_procedures_bk3.delete_event_proc_a
  (
    p_event_procedure_id       => p_event_procedure_id
   ,p_object_version_number    => l_object_version_number
  );

Line: 327

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

Line: 349

    rollback to DELETE_EVENT_PROC;

Line: 362

    rollback to DELETE_EVENT_PROC;

Line: 372

end delete_event_proc;