APPS.PER_RI_VIEW_REPORT_SWI SQL Statements

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

Line: 127

PROCEDURE delete_view_report
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_workbench_view_report_code   in     varchar2
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 140

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

Line: 146

  savepoint delete_view_report_swi;

Line: 166

  per_ri_view_report_api.delete_view_report
    (p_validate                     => l_validate
    ,p_workbench_view_report_code   => p_workbench_view_report_code
    ,p_object_version_number        => p_object_version_number
    );

Line: 193

    rollback to delete_view_report_swi;

Line: 207

    rollback to delete_view_report_swi;

Line: 217

end delete_view_report;

Line: 221

PROCEDURE update_view_report
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_workbench_view_report_code   in     varchar2
  ,p_workbench_view_report_name   in     varchar2  default hr_api.g_varchar2
  ,p_wb_view_report_description   in     varchar2  default hr_api.g_varchar2
  ,p_workbench_item_code          in     varchar2  default hr_api.g_varchar2
  ,p_workbench_view_report_type   in     varchar2  default hr_api.g_varchar2
  ,p_workbench_view_report_action in     varchar2  default hr_api.g_varchar2
  ,p_workbench_view_country       in     varchar2  default hr_api.g_varchar2
  ,p_wb_view_report_instruction   in     varchar2  default hr_api.g_varchar2
  ,p_language_code                in     varchar2  default hr_api.g_varchar2
  ,p_effective_date               in     date
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ,p_primary_industry		  in	 varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 245

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

Line: 251

  savepoint update_view_report_swi;

Line: 272

  per_ri_view_report_api.update_view_report
    (p_validate                     => l_validate
    ,p_workbench_view_report_code   => p_workbench_view_report_code
    ,p_workbench_view_report_name   => p_workbench_view_report_name
    ,p_wb_view_report_description   => p_wb_view_report_description
    ,p_workbench_item_code          => p_workbench_item_code
    ,p_workbench_view_report_type   => p_workbench_view_report_type
    ,p_workbench_view_report_action => p_workbench_view_report_action
    ,p_workbench_view_country       => p_workbench_view_country
    ,p_wb_view_report_instruction   => p_wb_view_report_instruction
    ,p_language_code                => p_language_code
    ,p_effective_date               => p_effective_date
    ,p_object_version_number        => p_object_version_number
    ,p_primary_industry		    => p_primary_industry
    );

Line: 309

    rollback to update_view_report_swi;

Line: 324

    rollback to update_view_report_swi;

Line: 335

end update_view_report;