APPS.HR_TEMPLATE_ITEM_TAB_PAGES_API SQL Statements

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

Line: 29

  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
       ,hr_template_items_b hti
  WHERE hsf.form_template_id_to = hti.form_template_id
  AND hti.template_item_id = p_template_item_id;

Line: 40

    SELECT tic.template_item_context_id
      FROM hr_template_item_contexts_b tic
     WHERE NOT EXISTS (SELECT 0
                         FROM hr_template_item_context_pages tcp
                        WHERE tcp.template_tab_page_id = p_template_tab_page_id
                          AND tcp.template_item_context_id = tic.template_item_context_id)
       AND tic.template_item_id = p_template_item_id;

Line: 191

procedure delete_template_item_tab_page
  (p_validate                      in     boolean  default false
  ,p_template_item_tab_page_id     in      number
  ,p_object_version_number         in      number
  ,p_upd_template_item_contexts    in     boolean  default false
  ) is
  --
  -- Declare cursors and local variables
  --
  l_temp number;

Line: 204

  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
       ,hr_template_items_b hti
       ,hr_template_item_tab_pages htit
  WHERE hsf.form_template_id_to = hti.form_template_id
  AND hti.template_item_id = htit.template_item_id
  AND htit.template_item_tab_page_id = p_template_item_tab_page_id;

Line: 216

    SELECT tcp.template_item_context_page_id
          ,tcp.object_version_number
      FROM hr_template_item_context_pages tcp
          ,hr_template_item_contexts_b tic
          ,hr_template_item_tab_pages tip
     WHERE tcp.template_tab_page_id = tip.template_tab_page_id
       AND tcp.template_item_context_id = tic.template_item_context_id
       AND tic.template_item_id = tip.template_item_id
       AND tip.template_item_tab_page_id = p_template_item_tab_page_id;

Line: 227

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

Line: 233

  savepoint delete_template_item_tab_page;

Line: 239

    hr_template_item_tab_pages_bk2.delete_tip_b
      (p_template_item_tab_page_id     => p_template_item_tab_page_id
       ,p_object_version_number        => p_object_version_number
       ,p_upd_template_item_contexts   => p_upd_template_item_contexts
      );

Line: 247

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

Line: 278

      hr_tcp_api.delete_tcp
        (p_template_item_context_page_i => l_template_item_context_page.template_item_context_page_id
        ,p_object_version_number        => l_template_item_context_page.object_version_number
        );

Line: 296

    hr_template_item_tab_pages_bk2.delete_tip_a
      (p_template_item_tab_page_id     => p_template_item_tab_page_id
       ,p_object_version_number        => p_object_version_number
       ,p_upd_template_item_contexts   => p_upd_template_item_contexts
      );

Line: 304

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

Line: 322

    rollback to delete_template_item_tab_page;

Line: 333

    rollback to delete_template_item_tab_page;

Line: 336

end delete_template_item_tab_page;