APPS.PAY_USER_TABLE_API SQL Statements

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

Line: 143

procedure update_user_table
  (p_validate                      in     boolean  default false
  ,p_user_table_id                 in     number
  ,p_effective_date                in     date
  ,p_user_table_name               in     varchar2 default hr_api.g_varchar2
  ,p_user_row_title                in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'update_user_table';

Line: 162

  savepoint update_user_table;

Line: 171

    pay_user_table_bk2.update_user_table_b
      (p_effective_date                => l_effective_date
      ,p_user_table_id                 => p_user_table_id
      ,p_user_table_name               => p_user_table_name
      ,p_user_row_title                => p_user_row_title
      ,p_object_version_number         => l_ovn
      );

Line: 181

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

Line: 199

    pay_user_table_bk2.update_user_table_a
      (p_effective_date                => l_effective_date
      ,p_user_table_id                 => p_user_table_id
      ,p_user_table_name               => p_user_table_name
      ,p_user_row_title                => p_user_row_title
      ,p_object_version_number         => l_ovn
      );

Line: 209

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

Line: 235

    rollback to update_user_table;

Line: 247

    rollback to update_user_table;

Line: 250

end update_user_table;

Line: 256

procedure delete_user_table
  (p_validate                      in     boolean  default false
  ,p_user_table_id                 in     number
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 272

  savepoint delete_user_table;

Line: 277

    pay_user_table_bk3.delete_user_table_b
      (p_user_table_id                 => p_user_table_id
      ,p_object_version_number         => l_ovn
      );

Line: 284

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

Line: 299

    pay_user_table_bk3.delete_user_table_a
      (p_user_table_id                 => p_user_table_id
      ,p_object_version_number         => l_ovn
      );

Line: 306

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

Line: 332

    rollback to delete_user_table;

Line: 344

    rollback to delete_user_table;

Line: 347

end delete_user_table;