APPS.PQH_BCE_UPD SQL Statements

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

Line: 50

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

Line: 64

  update pqh_bdgt_cmmtmnt_elmnts
  set
  bdgt_cmmtmnt_elmnt_id             = p_rec.bdgt_cmmtmnt_elmnt_id,
  budget_id                         = p_rec.budget_id,
  actual_commitment_type            = p_rec.actual_commitment_type,
  element_type_id                   = p_rec.element_type_id,
  salary_basis_flag                 = p_rec.salary_basis_flag,
  element_input_value_id            = p_rec.element_input_value_id,
  balance_type_id                   = p_rec.balance_type_id,
  frequency_input_value_id          = p_rec.frequency_input_value_id,
  formula_id                        = p_rec.formula_id,
  dflt_elmnt_frequency              = p_rec.dflt_elmnt_frequency,
  overhead_percentage               = p_rec.overhead_percentage,
  object_version_number             = p_rec.object_version_number
  where bdgt_cmmtmnt_elmnt_id = p_rec.bdgt_cmmtmnt_elmnt_id;

Line: 98

End update_dml;

Line: 132

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

Line: 140

End pre_update;

Line: 174

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

Line: 187

    pqh_bce_rku.after_update
      (
  p_bdgt_cmmtmnt_elmnt_id         =>p_rec.bdgt_cmmtmnt_elmnt_id
 ,p_budget_id                     =>p_rec.budget_id
 ,p_actual_commitment_type        =>p_rec.actual_commitment_type
 ,p_element_type_id               =>p_rec.element_type_id
 ,p_salary_basis_flag             =>p_rec.salary_basis_flag
 ,p_element_input_value_id        =>p_rec.element_input_value_id
 ,p_balance_type_id               =>p_rec.balance_type_id
 ,p_frequency_input_value_id      =>p_rec.frequency_input_value_id
 ,p_formula_id                    =>p_rec.formula_id
 ,p_dflt_elmnt_frequency          =>p_rec.dflt_elmnt_frequency
 ,p_overhead_percentage           =>p_rec.overhead_percentage
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_budget_id_o                   =>pqh_bce_shd.g_old_rec.budget_id
 ,p_actual_commitment_type_o      =>pqh_bce_shd.g_old_rec.actual_commitment_type
 ,p_element_type_id_o             =>pqh_bce_shd.g_old_rec.element_type_id
 ,p_salary_basis_flag_o           =>pqh_bce_shd.g_old_rec.salary_basis_flag
 ,p_element_input_value_id_o      =>pqh_bce_shd.g_old_rec.element_input_value_id
 ,p_balance_type_id_o             =>pqh_bce_shd.g_old_rec.balance_type_id
 ,p_frequency_input_value_id_o    =>pqh_bce_shd.g_old_rec.frequency_input_value_id
 ,p_formula_id_o                  =>pqh_bce_shd.g_old_rec.formula_id
 ,p_dflt_elmnt_frequency_o        =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
 ,p_overhead_percentage_o         =>pqh_bce_shd.g_old_rec.overhead_percentage
 ,p_object_version_number_o       =>pqh_bce_shd.g_old_rec.object_version_number
      );

Line: 229

End post_update;

Line: 362

  pqh_bce_bus.update_validate(p_rec
  ,p_effective_date);

Line: 367

  pre_update(p_rec);

Line: 371

  update_dml(p_rec);

Line: 375

  post_update(
p_effective_date,p_rec);