APPS.PAY_CNU_UPD SQL Statements

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

Line: 54

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

Line: 70

  update pay_fr_contribution_usages
    set
     date_to                         = p_rec.date_to
    ,contribution_code               = p_rec.contribution_code
    ,contribution_type               = p_rec.contribution_type
    ,retro_contribution_code         = p_rec.retro_contribution_code
    ,object_version_number           = p_rec.object_version_number
    ,code_rate_id                    = p_rec.code_rate_id
    where contribution_usage_id = p_rec.contribution_usage_id
      and contribution_usage_type= p_rec.contribution_usage_type ;

Line: 104

End update_dml;

Line: 138

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

Line: 148

End pre_update;

Line: 182

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

Line: 192

    pay_cnu_rku.after_update
      (p_contribution_usage_id     => p_rec.contribution_usage_id
      ,p_date_to                   => p_rec.date_to
      ,p_retro_contribution_code   => p_rec.retro_contribution_code
      ,p_object_version_number     => p_rec.object_version_number
      ,p_date_from_o               => pay_cnu_shd.g_old_rec.date_from
      ,p_date_to_o                 => pay_cnu_shd.g_old_rec.date_to
      ,p_group_code_o              => pay_cnu_shd.g_old_rec.group_code
      ,p_process_type_o            => pay_cnu_shd.g_old_rec.process_type
      ,p_element_name_o            => pay_cnu_shd.g_old_rec.element_name
      ,p_rate_type_o               => pay_cnu_shd.g_old_rec.rate_type
      ,p_contribution_code_o       => pay_cnu_shd.g_old_rec.contribution_code
      ,p_retro_contribution_code_o => pay_cnu_shd.g_old_rec.retro_contribution_code
      ,p_contribution_type_o       => pay_cnu_shd.g_old_rec.contribution_type
      ,p_contribution_usage_type_o => pay_cnu_shd.g_old_rec.contribution_usage_type
      ,p_rate_category_o           => pay_cnu_shd.g_old_rec.rate_category
      ,p_business_group_id_o       => pay_cnu_shd.g_old_rec.business_group_id
      ,p_object_version_number_o   => pay_cnu_shd.g_old_rec.object_version_number
      ,p_code_rate_id_o            => pay_cnu_shd.g_old_rec.code_Rate_id
      );

Line: 224

End post_update;

Line: 362

  pay_cnu_bus.update_validate
     ( p_effective_date
      ,p_rec
     );

Line: 369

  pay_cnu_upd.pre_update(p_rec);

Line: 373

  pay_cnu_upd.update_dml(p_rec);

Line: 377

  pay_cnu_upd.post_update
     (p_rec
     );