APPS.PER_SSB_UPD SQL Statements

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

Line: 54

Procedure update_dml
  (p_rec in out nocopy per_ssb_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 70

  update per_ri_setup_sub_tasks
    set
     setup_sub_task_code             = p_rec.setup_sub_task_code
    ,setup_task_code                 = p_rec.setup_task_code
    ,setup_sub_task_sequence         = p_rec.setup_sub_task_sequence
    ,setup_sub_task_status           = p_rec.setup_sub_task_status
    ,setup_sub_task_type             = p_rec.setup_sub_task_type
    ,setup_sub_task_data_pump_link   = p_rec.setup_sub_task_data_pump_link
    ,setup_sub_task_action           = p_rec.setup_sub_task_action
    ,setup_sub_task_creation_date    = p_rec.setup_sub_task_creation_date
    ,setup_sub_task_last_mod_date    = p_rec.setup_sub_task_last_mod_date
    ,legislation_code                = p_rec.legislation_code
    ,object_version_number           = p_rec.object_version_number
    where setup_sub_task_code = p_rec.setup_sub_task_code;

Line: 108

End update_dml;

Line: 142

Procedure pre_update
  (p_rec in per_ssb_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 152

End pre_update;

Line: 186

Procedure post_update
  (p_effective_date               in date
  ,p_rec                          in per_ssb_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 197

    per_ssb_rku.after_update
      (p_effective_date                 => p_effective_date
      ,p_setup_sub_task_code            => p_rec.setup_sub_task_code
      ,p_setup_task_code                => p_rec.setup_task_code
      ,p_setup_sub_task_sequence        => p_rec.setup_sub_task_sequence
      ,p_setup_sub_task_status          => p_rec.setup_sub_task_status
      ,p_setup_sub_task_type            => p_rec.setup_sub_task_type
      ,p_setup_sub_task_data_pump_lin   => p_rec.setup_sub_task_data_pump_link
      ,p_setup_sub_task_action          => p_rec.setup_sub_task_action
      ,p_setup_sub_task_creation_date   => p_rec.setup_sub_task_creation_date
      ,p_setup_sub_task_last_mod_date   => p_rec.setup_sub_task_last_mod_date
      ,p_legislation_code               => p_rec.legislation_code
      ,p_object_version_number          => p_rec.object_version_number
      ,p_setup_task_code_o              => per_ssb_shd.g_old_rec.setup_task_code
      ,p_setup_sub_task_sequence_o      => per_ssb_shd.g_old_rec.setup_sub_task_sequence
      ,p_setup_sub_task_status_o        => per_ssb_shd.g_old_rec.setup_sub_task_status
      ,p_setup_sub_task_type_o          => per_ssb_shd.g_old_rec.setup_sub_task_type
      ,p_setup_sub_task_data_pump_l_o   => per_ssb_shd.g_old_rec.setup_sub_task_data_pump_link
      ,p_setup_sub_task_action_o        => per_ssb_shd.g_old_rec.setup_sub_task_action
      ,p_setup_sub_task_creation_da_o   => per_ssb_shd.g_old_rec.setup_sub_task_creation_date
      ,p_setup_sub_task_last_mod_da_o   => per_ssb_shd.g_old_rec.setup_sub_task_last_mod_date
      ,p_legislation_code_o             => per_ssb_shd.g_old_rec.legislation_code
      ,p_object_version_number_o        => per_ssb_shd.g_old_rec.object_version_number
      );

Line: 233

End post_update;

Line: 355

  per_ssb_bus.update_validate
     (p_effective_date
     ,p_rec
     );

Line: 365

  per_ssb_upd.pre_update(p_rec);

Line: 369

  per_ssb_upd.update_dml(p_rec);

Line: 373

  per_ssb_upd.post_update
     (p_effective_date
     ,p_rec
     );