APPS.PAY_USER_COLUMN_API SQL Statements

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

Line: 129

procedure update_user_column
  (p_validate                      in     boolean  default false
  ,p_user_column_id                in     number
  ,p_user_column_name              in     varchar2 default hr_api.g_varchar2
  ,p_formula_id                    in     number   default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ,p_formula_warning                  out nocopy boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'update_user_column';

Line: 148

  savepoint update_user_column;

Line: 153

    pay_user_column_bk2.update_user_column_b
      (p_user_column_id        => p_user_column_id
      ,p_formula_id            => p_formula_id
      ,p_user_column_name      => p_user_column_name
      ,p_object_version_number => l_ovn
      );

Line: 162

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

Line: 180

    pay_user_column_bk2.update_user_column_a
      (p_formula_id            => p_formula_id
      ,p_user_column_name      => p_user_column_name
      ,p_user_column_id        => p_user_column_id
      ,p_object_version_number => l_ovn
      ,p_formula_warning       => l_formula_warning
      );

Line: 190

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

Line: 216

    rollback to update_user_column;

Line: 228

    rollback to update_user_column;

Line: 231

end update_user_column;

Line: 237

procedure delete_user_column
  (p_validate                      in     boolean  default false
  ,p_user_column_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_column';

Line: 253

  savepoint delete_user_column;

Line: 258

    pay_user_column_bk3.delete_user_column_b
      (p_user_column_id                 => p_user_column_id
      ,p_object_version_number          => l_ovn
      );

Line: 265

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

Line: 280

    pay_user_column_bk3.delete_user_column_a
      (p_user_column_id                => p_user_column_id
      ,p_object_version_number         => l_ovn
      );

Line: 287

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

Line: 312

    rollback to delete_user_column;

Line: 324

    rollback to delete_user_column;

Line: 327

end delete_user_column;