APPS.HR_NAME_FORMAT_API SQL Statements

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

Line: 139

procedure update_name_format
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_name_format_id                in     number
  ,p_format_mask                   in     varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number   hr_name_formats.object_version_number%TYPE;

Line: 151

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

Line: 157

  savepoint update_name_format;

Line: 168

    hr_name_format_bk2.update_name_format_b
      (p_effective_date                => l_effective_date
      ,p_name_format_id                => p_name_format_id
      ,p_format_mask                   => p_format_mask
      ,p_object_version_number         => p_object_version_number
      );

Line: 177

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

Line: 194

    hr_name_format_bk2.update_name_format_a
      (p_effective_date                => l_effective_date
      ,p_name_format_id                => p_name_format_id
      ,p_format_mask                   => p_format_mask
      ,p_object_version_number         => l_object_version_number
      );

Line: 203

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

Line: 225

    rollback to update_name_format;

Line: 229

end update_name_format;

Line: 235

procedure delete_name_format
  (p_validate                      in     boolean  default false
  ,p_name_format_id                in     number
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number   hr_name_formats.object_version_number%TYPE;

Line: 245

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

Line: 251

  savepoint delete_name_format;

Line: 258

    hr_name_format_bk3.delete_name_format_b
      (p_name_format_id                => p_name_format_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 265

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

Line: 280

    hr_name_format_bk3.delete_name_format_a
      (p_name_format_id                => p_name_format_id
      ,p_object_version_number         => l_object_version_number
      );

Line: 287

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

Line: 309

    rollback to delete_name_format;

Line: 313

end delete_name_format;