APPS.PER_RI_SETUP_TASK_SWI SQL Statements

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

Line: 129

PROCEDURE delete_setup_task
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_setup_task_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: 142

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

Line: 148

  savepoint delete_setup_task_swi;

Line: 168

  per_ri_setup_task_api.delete_setup_task
    (p_validate                     => l_validate
    ,p_setup_task_code              => p_setup_task_code
    ,p_object_version_number        => p_object_version_number
    );

Line: 195

    rollback to delete_setup_task_swi;

Line: 209

    rollback to delete_setup_task_swi;

Line: 219

end delete_setup_task;

Line: 223

PROCEDURE update_setup_task
  (p_validate                     in     number    default hr_api.g_false_num
  ,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.g_varchar2
  ,p_effective_date               in     date
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 248

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

Line: 254

  savepoint update_setup_task_swi;

Line: 275

  per_ri_setup_task_api.update_setup_task
    (p_validate                     => l_validate
    ,p_setup_task_code              => p_setup_task_code
    ,p_workbench_item_code          => p_workbench_item_code
    ,p_setup_task_name              => p_setup_task_name
    ,p_setup_task_description       => p_setup_task_description
    ,p_setup_task_sequence          => p_setup_task_sequence
    ,p_setup_task_status            => p_setup_task_status
    ,p_setup_task_creation_date     => p_setup_task_creation_date
    ,p_setup_task_last_mod_date     => p_setup_task_last_mod_date
    ,p_setup_task_type              => p_setup_task_type
    ,p_setup_task_action            => p_setup_task_action
    ,p_language_code                => p_language_code
    ,p_effective_date               => p_effective_date
    ,p_object_version_number        => p_object_version_number
    );

Line: 313

    rollback to update_setup_task_swi;

Line: 328

    rollback to update_setup_task_swi;

Line: 339

end update_setup_task;