APPS.PER_RI_SETUP_SUB_TASK_SWI SQL Statements

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

Line: 133

PROCEDURE delete_setup_sub_task
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_setup_sub_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: 146

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

Line: 152

  savepoint delete_setup_sub_task_swi;

Line: 172

  per_ri_setup_sub_task_api.delete_setup_sub_task
    (p_validate                     => l_validate
    ,p_setup_sub_task_code          => p_setup_sub_task_code
    ,p_object_version_number        => p_object_version_number
    );

Line: 199

    rollback to delete_setup_sub_task_swi;

Line: 213

    rollback to delete_setup_sub_task_swi;

Line: 223

end delete_setup_sub_task;

Line: 227

PROCEDURE update_setup_sub_task
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_setup_sub_task_code          in     varchar2
  ,p_setup_sub_task_name          in     varchar2  default hr_api.g_varchar2
  ,p_setup_sub_task_description   in     varchar2  default hr_api.g_varchar2
  ,p_setup_task_code              in     varchar2  default hr_api.g_varchar2
  ,p_setup_sub_task_sequence      in     number    default hr_api.g_number
  ,p_setup_sub_task_status        in     varchar2  default hr_api.g_varchar2
  ,p_setup_sub_task_type          in     varchar2  default hr_api.g_varchar2
  ,p_setup_sub_task_dp_link       in     varchar2  default hr_api.g_varchar2
  ,p_setup_sub_task_action        in     varchar2  default hr_api.g_varchar2
  ,p_setup_sub_task_creation_date in     date      default hr_api.g_date
  ,p_setup_sub_task_last_mod_date in     date      default hr_api.g_date
  ,p_legislation_code             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: 254

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

Line: 260

  savepoint update_setup_sub_task_swi;

Line: 281

  per_ri_setup_sub_task_api.update_setup_sub_task
    (p_validate                     => l_validate
    ,p_setup_sub_task_code          => p_setup_sub_task_code
    ,p_setup_sub_task_name          => p_setup_sub_task_name
    ,p_setup_sub_task_description   => p_setup_sub_task_description
    ,p_setup_task_code              => p_setup_task_code
    ,p_setup_sub_task_sequence      => p_setup_sub_task_sequence
    ,p_setup_sub_task_status        => p_setup_sub_task_status
    ,p_setup_sub_task_type          => p_setup_sub_task_type
    ,p_setup_sub_task_dp_link       => p_setup_sub_task_dp_link
    ,p_setup_sub_task_action        => p_setup_sub_task_action
    ,p_setup_sub_task_creation_date => p_setup_sub_task_creation_date
    ,p_setup_sub_task_last_mod_date => p_setup_sub_task_last_mod_date
    ,p_language_code                => p_language_code
    ,p_legislation_code             => p_legislation_code
    ,p_effective_date               => p_effective_date
    ,p_object_version_number        => p_object_version_number
    );

Line: 321

    rollback to update_setup_sub_task_swi;

Line: 336

    rollback to update_setup_sub_task_swi;

Line: 347

end update_setup_sub_task;