APPS.HR_TEMPLATE_DATA_GROUPS_API SQL Statements

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

Line: 26

  SELECT tdg.form_data_group_id
  FROM hr_template_data_groups tdg
  WHERE tdg.template_data_group_id = p_template_data_group_id_from;

Line: 34

  SELECT tit1.template_item_id
  FROM hr_template_items_b tit2
  ,hr_template_items_b tit1
  ,hr_template_data_groups tdg
  WHERE tit2.template_item_id IS NULL
  AND tit2.form_template_id (+) = p_form_template_id
  AND tit2.form_item_id (+) = tit1.form_item_id
  AND tit1.form_template_id = tdg.form_template_id
  AND tdg.template_data_group_id = p_template_data_group_id_from;

Line: 48

  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
  WHERE hsf.form_template_id_to = p_form_template_id;

Line: 226

  SELECT fit.form_item_id
  FROM hr_template_items tit
  ,hr_form_items fit
  ,hr_form_data_group_items fgi
  WHERE tit.template_item_id IS NULL
  AND tit.form_template_id (+) = p_form_template_id
  AND tit.form_item_id (+) = fit.form_item_id
  AND fit.form_item_id = fgi.form_item_id
  AND fgi.form_data_group_id = p_form_data_group_id;

Line: 240

  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
  WHERE hsf.form_template_id_to = p_form_template_id;

Line: 383

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

  CURSOR cur_tmplt_item
  IS
  SELECT tit.template_item_id
  ,tit.object_version_number
  FROM hr_template_items tit
  ,hr_form_data_group_items fgi
  ,hr_template_data_groups tdg
  WHERE tit.form_template_id = tdg.form_template_id
  AND tit.form_item_id = fgi.form_item_id
  AND fgi.form_data_group_id = tdg.form_data_group_id
  AND tdg.template_data_group_id = p_template_data_group_id
  MINUS
  SELECT tit.template_item_id
  ,tit.object_version_number
  FROM hr_template_items tit
  ,hr_form_data_group_items fgi
  ,hr_template_data_groups tdg2
  ,hr_template_data_groups tdg1
  WHERE tit.form_template_id = tdg2.form_template_id
  AND tit.form_item_id = fgi.form_item_id
  AND fgi.form_data_group_id = tdg2.form_data_group_id
  AND tdg2.template_data_group_id <> tdg1.template_data_group_id
  AND tdg2.form_template_id = tdg1.form_template_id
  AND tdg1.template_data_group_id = p_template_data_group_id;

Line: 421

  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
       ,hr_template_data_groups tdg
  WHERE hsf.form_template_id_to = tdg.form_template_id
  AND tdg.template_data_group_id = p_template_data_group_id;

Line: 427

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

Line: 433

  savepoint delete_template_data_group;

Line: 438

    hr_template_data_groups_bk3.delete_template_data_group_b
      (p_template_data_group_id       => p_template_data_group_id
       ,p_object_version_number        => p_object_version_number);

Line: 444

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

Line: 477

    hr_template_items_api.delete_template_item(
               p_template_item_id             => cur_rec.template_item_id
              ,p_object_version_number        => cur_rec.object_version_number);

Line: 493

    hr_template_data_groups_bk3.delete_template_data_group_a
      (p_template_data_group_id       => p_template_data_group_id
       ,p_object_version_number        => p_object_version_number);

Line: 499

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

Line: 519

    rollback to delete_template_data_group;

Line: 530

    rollback to delete_template_data_group;

Line: 533

end delete_template_data_group;