APPS.HR_FORM_DATA_GROUPS_API SQL Statements

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

Line: 161

procedure delete_form_data_group
  (p_validate                      in     boolean  default false
  ,p_form_data_group_id            in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  CURSOR cur_data_group_item IS
  SELECT form_data_group_item_id
         ,object_version_number
  FROM hr_form_data_group_items
  WHERE form_data_group_id = p_form_data_group_id;

Line: 176

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

Line: 182

  savepoint delete_form_data_group;

Line: 187

    hr_form_data_groups_api_bk2.delete_form_data_group_b
      (p_form_data_group_id            => p_form_data_group_id
       ,p_object_version_number         => p_object_version_number
      );

Line: 194

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

Line: 210

    hr_form_data_group_items_api.delete_form_data_group_item(
               p_form_data_group_item_id      => cur_rec.form_data_group_item_id
               ,p_object_version_number       => cur_rec.object_version_number);

Line: 231

    hr_form_data_groups_api_bk2.delete_form_data_group_a
      (p_form_data_group_id            => p_form_data_group_id
       ,p_object_version_number         => p_object_version_number
      );

Line: 238

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

Line: 258

    rollback to delete_form_data_group;

Line: 269

    rollback to delete_form_data_group;

Line: 272

end delete_form_data_group;

Line: 278

procedure update_form_data_group
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_language_code                 in     varchar2 default hr_api.userenv_lang
  --,p_application_id                in     number
  --,p_form_id                       in     number
  ,p_form_data_group_id            in     number
  ,p_data_group_name               in     varchar2 default hr_api.g_varchar2
  ,p_user_data_group_name          in     varchar2 default hr_api.g_varchar2
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_language_code fnd_languages.language_code%TYPE;

Line: 296

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

Line: 304

  savepoint update_form_data_group;

Line: 324

    hr_form_data_groups_api_bk3.update_form_data_group_b
      (p_effective_date                => TRUNC(p_effective_date)
      ,p_language_code                 => l_language_code
      --,p_application_id                => p_application_id
      --,p_form_id                       => p_form_id
      ,p_data_group_name               => p_data_group_name
      ,p_user_data_group_name          => p_user_data_group_name
      ,p_description                   => p_description
      ,p_form_data_group_id            => p_form_data_group_id
      ,p_object_version_number         => l_object_version_number
      );

Line: 338

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

Line: 367

    hr_form_data_groups_api_bk3.update_form_data_group_a
      (p_effective_date                => TRUNC(p_effective_date)
      ,p_language_code                 => l_language_code
      --,p_application_id                => p_application_id
      --,p_form_id                       => p_form_id
      ,p_form_data_group_id            => p_form_data_group_id
      ,p_data_group_name               => p_data_group_name
      ,p_user_data_group_name          => p_user_data_group_name
      ,p_description                   => p_description
      ,p_object_version_number         => l_object_version_number
      );

Line: 381

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

Line: 405

    rollback to update_form_data_group;

Line: 419

    rollback to update_form_data_group;

Line: 425

end update_form_data_group;