APPS.HR_TCP_API SQL Statements

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

Line: 31

  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
    ,hr_template_windows_b htw
    ,hr_template_canvases_b htb
    ,hr_template_tab_pages_b htt
  WHERE htt.template_tab_page_id = p_template_tab_page_id
  AND htt.template_canvas_id = htb.template_canvas_id
  AND htb.template_window_id = htw.template_window_id
  AND htw.form_template_id = hsf.form_template_id_to;

Line: 161

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

Line: 173

  SELECT source_form_template_id
  FROM hr_source_form_templates hsf
    ,hr_template_windows_b htw
    ,hr_template_canvases_b htb
    ,hr_template_tab_pages_b htt
    ,hr_template_item_context_pages tcp
  WHERE htt.template_tab_page_id = tcp.template_tab_page_id
  AND htt.template_canvas_id = htb.template_canvas_id
  AND htb.template_window_id = htw.template_window_id
  AND htw.form_template_id = hsf.form_template_id_to
  AND tcp.template_item_context_page_id = p_template_item_context_page_i;

Line: 185

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

Line: 191

  savepoint delete_tcp;

Line: 196

    hr_tcp_api_bk2.delete_tcp_b
      ( p_template_item_context_page_i => p_template_item_context_page_i
       ,p_object_version_number        => p_object_version_number
      );

Line: 203

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

Line: 238

    hr_tcp_api_bk2.delete_tcp_a
      ( p_template_item_context_page_i => p_template_item_context_page_i
       ,p_object_version_number        => p_object_version_number
      );

Line: 245

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

Line: 263

    rollback to delete_tcp;

Line: 274

    rollback to delete_tcp;

Line: 277

end delete_tcp;