APPS.PER_RI_SETUP_SUB_TASK_API SQL Statements

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

Line: 144

Procedure update_setup_sub_task
  (   p_validate                       In  Boolean   Default False
     ,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.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_sub_task';

Line: 180

  savepoint update_setup_sub_task ;

Line: 252

    Rollback To update_setup_sub_task;

Line: 263

    Rollback To update_setup_sub_task;

Line: 270

End update_setup_sub_task;

Line: 275

Procedure delete_setup_sub_task
   (  p_validate                     In Boolean Default False
     ,p_setup_sub_task_code          In Varchar2
     ,p_object_version_number        IN Number )

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

Line: 293

  Savepoint delete_setup_sub_task;

Line: 335

    Rollback To delete_setup_sub_task;

Line: 345

    Rollback To delete_setup_sub_task;

Line: 349

End delete_setup_sub_task;