APPS.PQH_CEF_INS SQL Statements

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

Line: 50

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

Line: 77

  insert into pqh_copy_entity_functions
  (	copy_entity_function_id,
	table_route_id,
	function_type_cd,
	pre_copy_function_name,
	copy_function_name,
	post_copy_function_name,
	object_version_number,
	context
  )
  Values
  (	p_rec.copy_entity_function_id,
	p_rec.table_route_id,
	p_rec.function_type_cd,
	p_rec.pre_copy_function_name,
	p_rec.copy_function_name,
	p_rec.post_copy_function_name,
	p_rec.object_version_number,
	p_rec.context
  );

Line: 115

End insert_dml;

Line: 154

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

Line: 158

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

Line: 171

End pre_insert;

Line: 205

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

Line: 218

    pqh_cef_rki.after_insert
      (
  p_copy_entity_function_id       =>p_rec.copy_entity_function_id
 ,p_table_route_id                =>p_rec.table_route_id
 ,p_function_type_cd              =>p_rec.function_type_cd
 ,p_pre_copy_function_name        =>p_rec.pre_copy_function_name
 ,p_copy_function_name            =>p_rec.copy_function_name
 ,p_post_copy_function_name       =>p_rec.post_copy_function_name
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_context                       =>p_rec.context
 ,p_effective_date                =>p_effective_date
      );

Line: 245

End post_insert;

Line: 263

  pqh_cef_bus.insert_validate(p_rec
  ,p_effective_date);

Line: 268

  pre_insert(p_rec);

Line: 272

  insert_dml(p_rec);

Line: 276

  post_insert(
p_effective_date,p_rec);