APPS.PQH_BVR_UPD SQL Statements

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

Line: 51

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

Line: 65

  update pqh_budget_versions
  set
  budget_version_id                 = p_rec.budget_version_id,
  budget_id                         = p_rec.budget_id,
  version_number                    = p_rec.version_number,
  date_from                         = p_rec.date_from,
  date_to                           = p_rec.date_to,
  transfered_to_gl_flag             = p_rec.transfered_to_gl_flag,
  gl_status                         = p_rec.gl_status,
  xfer_to_other_apps_cd             = p_rec.xfer_to_other_apps_cd,
  object_version_number             = p_rec.object_version_number,
  budget_unit1_value                = p_rec.budget_unit1_value,
  budget_unit2_value                = p_rec.budget_unit2_value,
  budget_unit3_value                = p_rec.budget_unit3_value,
  budget_unit1_available            = p_rec.budget_unit1_available,
  budget_unit2_available            = p_rec.budget_unit2_available,
  budget_unit3_available            = p_rec.budget_unit3_available
  where budget_version_id = p_rec.budget_version_id;

Line: 102

End update_dml;

Line: 136

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

Line: 144

End pre_update;

Line: 178

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

Line: 189

 select *
 from pqh_budgets
 where budget_id = p_budget_id
   and nvl(status,'X') <> 'FROZEN';

Line: 222

               pqh_budgets_api.update_budget
               (
                p_budget_id               => l_budgets_rec.budget_id,
                p_object_version_number   => l_object_version_number,
                p_status                  => 'FROZEN',
                p_effective_date          => sysdate
               );

Line: 236

    pqh_bvr_rku.after_update
      (
  p_budget_version_id             =>p_rec.budget_version_id
 ,p_budget_id                     =>p_rec.budget_id
 ,p_version_number                =>p_rec.version_number
 ,p_date_from                     =>p_rec.date_from
 ,p_date_to                       =>p_rec.date_to
 ,p_transfered_to_gl_flag         =>p_rec.transfered_to_gl_flag
 ,p_gl_status                     =>p_rec.gl_status
 ,p_xfer_to_other_apps_cd         =>p_rec.xfer_to_other_apps_cd
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_budget_unit1_value            =>p_rec.budget_unit1_value
 ,p_budget_unit2_value            =>p_rec.budget_unit2_value
 ,p_budget_unit3_value            =>p_rec.budget_unit3_value
 ,p_budget_unit1_available        =>p_rec.budget_unit1_available
 ,p_budget_unit2_available        =>p_rec.budget_unit2_available
 ,p_budget_unit3_available        =>p_rec.budget_unit3_available
 ,p_effective_date                =>p_effective_date
 ,p_budget_id_o                   =>pqh_bvr_shd.g_old_rec.budget_id
 ,p_version_number_o              =>pqh_bvr_shd.g_old_rec.version_number
 ,p_date_from_o                   =>pqh_bvr_shd.g_old_rec.date_from
 ,p_date_to_o                     =>pqh_bvr_shd.g_old_rec.date_to
 ,p_transfered_to_gl_flag_o       =>pqh_bvr_shd.g_old_rec.transfered_to_gl_flag
 ,p_gl_status_o                   =>pqh_bvr_shd.g_old_rec.gl_status
 ,p_xfer_to_other_apps_cd_o       =>pqh_bvr_shd.g_old_rec.xfer_to_other_apps_cd
 ,p_object_version_number_o       =>pqh_bvr_shd.g_old_rec.object_version_number
 ,p_budget_unit1_value_o          =>pqh_bvr_shd.g_old_rec.budget_unit1_value
 ,p_budget_unit2_value_o          =>pqh_bvr_shd.g_old_rec.budget_unit2_value
 ,p_budget_unit3_value_o          =>pqh_bvr_shd.g_old_rec.budget_unit3_value
 ,p_budget_unit1_available_o      =>pqh_bvr_shd.g_old_rec.budget_unit1_available
 ,p_budget_unit2_available_o      =>pqh_bvr_shd.g_old_rec.budget_unit2_available
 ,p_budget_unit3_available_o      =>pqh_bvr_shd.g_old_rec.budget_unit3_available
      );

Line: 284

End post_update;

Line: 428

  pqh_bvr_bus.update_validate(p_rec
  ,p_effective_date);

Line: 433

  pre_update(p_rec);

Line: 437

  update_dml(p_rec);

Line: 441

  post_update(
p_effective_date,p_rec);