APPS.PQH_CEC_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_cec_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 60

  insert into pqh_copy_entity_contexts
  (	context,
	application_short_name,
	legislation_code,
	responsibility_key,
	transaction_short_name,
	object_version_number
  )
  Values
  (	p_rec.context,
	p_rec.application_short_name,
	p_rec.legislation_code,
	p_rec.responsibility_key,
	p_rec.transaction_short_name,
	p_rec.object_version_number
  );

Line: 94

End insert_dml;

Line: 133

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

Line: 152

End pre_insert;

Line: 186

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

Line: 198

    pqh_cec_rki.after_insert
      (
  p_context                       =>p_rec.context
 ,p_application_short_name        =>p_rec.application_short_name
 ,p_legislation_code              =>p_rec.legislation_code
 ,p_responsibility_key            =>p_rec.responsibility_key
 ,p_transaction_short_name        =>p_rec.transaction_short_name
 ,p_object_version_number         =>p_rec.object_version_number
      );

Line: 222

End post_insert;

Line: 239

  pqh_cec_bus.insert_validate(p_rec);

Line: 247

  insert_dml(p_rec);

Line: 251

  post_insert(p_rec);