APPS.PER_RI_SETUP_TASK_API SQL Statements

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

Line: 137

Procedure update_setup_task
  ( p_validate                    In  Boolean   Default False
  ,p_setup_task_code              in     varchar2
  ,p_workbench_item_code          in     varchar2  default hr_api.g_varchar2
  ,p_setup_task_name              In     Varchar2  default hr_api.g_varchar2
  ,p_setup_task_description       In     Varchar2  default hr_api.g_varchar2
  ,p_setup_task_sequence          in     number    default hr_api.g_number
  ,p_setup_task_status            in     varchar2  default hr_api.g_varchar2
  ,p_setup_task_creation_date     in     date      default hr_api.g_date
  ,p_setup_task_last_mod_date     in     date      default hr_api.g_date
  ,p_setup_task_type              in     varchar2  default hr_api.g_varchar2
  ,p_setup_task_action            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_setup_task';

Line: 171

  savepoint update_setup_task;

Line: 241

    Rollback To update_setup_task;

Line: 252

    Rollback To update_setup_task;

Line: 259

End update_setup_task;

Line: 264

Procedure delete_setup_task
  ( p_validate                     In Boolean Default False
   ,p_setup_task_code                      in     varchar2
   ,p_object_version_number                in     number
  )

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

Line: 283

  Savepoint delete_setup_task;

Line: 325

    Rollback To delete_setup_task;

Line: 335

    Rollback To delete_setup_task;

Line: 339

End delete_setup_task;