APPS.PER_RI_WORKBENCH_ITEM_API SQL Statements

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

Line: 132

Procedure update_workbench_item
  (   p_validate                       In  Boolean   Default False
     ,p_workbench_item_code            In  Varchar2
     ,p_workbench_item_name            In  Varchar2  Default hr_api.g_varchar2
     ,p_workbench_item_description     In  Varchar2  Default hr_api.g_varchar2
     ,p_menu_id                        In  Number    Default hr_api.g_number
     ,p_workbench_item_sequence        In  Number    Default hr_api.g_number
     ,p_workbench_parent_item_code     In  Varchar2  Default hr_api.g_varchar2
     ,p_workbench_item_creation_date   In  Date      Default hr_api.g_date
     ,p_workbench_item_type            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
  ) Is
  --
  -- Declare cursors and local variables
  --
  l_proc                  VARCHAR2(72) := g_package||'update_workbench_item';

Line: 163

  savepoint update_workbench_item;

Line: 229

    Rollback To update_workbench_item;

Line: 240

    Rollback To update_workbench_item;

Line: 247

End update_workbench_item;

Line: 252

Procedure delete_workbench_item
   (  p_validate                     In Boolean Default False
     ,p_workbench_item_code          In Varchar2
     ,p_object_version_number        IN Number )

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

Line: 270

  Savepoint delete_workbench_item;

Line: 312

    Rollback To delete_workbench_item;

Line: 322

    Rollback To delete_workbench_item;

Line: 326

End delete_workbench_item;