APPS.PER_RI_VIEW_REPORT_API SQL Statements

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

Line: 137

Procedure update_view_report
  (   p_validate                       In  Boolean   Default False
     ,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.userenv_lang
     ,p_effective_date                 In  Date
     ,p_object_version_number          In Out Nocopy Number
     ,p_primary_industry	       In Varchar2  Default hr_api.g_varchar2
     ,p_enabled_flag               In Varchar2 Default 'Y'
  )  Is
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'update_view_report';

Line: 170

  savepoint update_view_report;

Line: 238

    Rollback To update_view_report;

Line: 249

    Rollback To update_view_report;

Line: 256

End update_view_report;

Line: 261

Procedure delete_view_report
   (  p_validate                     In Boolean Default False
     ,p_workbench_view_report_code   In Varchar2
     ,p_object_version_number        IN Number )

Is
  --
  --
  -- Declare cursors and local variables
  --
  l_proc Varchar2(72) := g_package||'delete_view_report';

Line: 279

  Savepoint delete_view_report;

Line: 321

    Rollback To delete_view_report;

Line: 331

    Rollback To delete_view_report;

Line: 335

End delete_view_report;