APPS.PQH_BCE_INS SQL Statements

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

Line: 49

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

Line: 60

  insert into pqh_bdgt_cmmtmnt_elmnts
  (	bdgt_cmmtmnt_elmnt_id,
	budget_id,
        actual_commitment_type,
	element_type_id,
	salary_basis_flag,
	element_input_value_id,
        balance_type_id,
	frequency_input_value_id,
	formula_id,
	dflt_elmnt_frequency,
	overhead_percentage,
	object_version_number
  )
  Values
  (	p_rec.bdgt_cmmtmnt_elmnt_id,
	p_rec.budget_id,
        p_rec.actual_commitment_type,
	p_rec.element_type_id,
	p_rec.salary_basis_flag,
	p_rec.element_input_value_id,
        p_rec.balance_type_id,
	p_rec.frequency_input_value_id,
	p_rec.formula_id,
	p_rec.dflt_elmnt_frequency,
	p_rec.overhead_percentage,
	p_rec.object_version_number
  );

Line: 106

End insert_dml;

Line: 145

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

Line: 149

  Cursor C_Sel1 is select pqh_bdgt_cmmtmnt_elmnts_s.nextval from sys.dual;

Line: 162

End pre_insert;

Line: 196

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

Line: 209

    pqh_bce_rki.after_insert
      (
  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
      );

Line: 240

End post_insert;

Line: 258

  pqh_bce_bus.insert_validate(p_rec
  ,p_effective_date);

Line: 263

  pre_insert(p_rec);

Line: 267

  insert_dml(p_rec);

Line: 271

  post_insert(
p_effective_date,p_rec);