APPS.HR_FSC_API SQL Statements

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

Line: 123

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

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

Line: 138

  savepoint delete_form_tab_stacked_canvas;

Line: 143

    hr_fsc_api_bk2.delete_fsc_b
      (p_form_tab_stacked_canvas_id    => p_form_tab_stacked_canvas_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 150

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

Line: 166

    hr_fsc_api_bk2.delete_fsc_a
      (p_form_tab_stacked_canvas_id    => p_form_tab_stacked_canvas_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 173

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

Line: 191

    rollback to delete_form_tab_stacked_canvas;

Line: 201

    rollback to delete_form_tab_stacked_canvas;

Line: 204

end delete_form_tab_stacked_canvas;