APPS.PQH_RLM_INS SQL Statements

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

Line: 47

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

Line: 58

  insert into pqh_routing_list_members
  (	role_id,
	routing_list_id,
	routing_list_member_id,
	seq_no,
	approver_flag,
	enable_flag,
	object_version_number,
	user_id
  )
  Values
  (	p_rec.role_id,
	p_rec.routing_list_id,
	p_rec.routing_list_member_id,
	p_rec.seq_no,
	p_rec.approver_flag,
	p_rec.enable_flag,
	p_rec.object_version_number,
	p_rec.user_id
  );

Line: 96

End insert_dml;

Line: 135

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

Line: 139

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

Line: 152

End pre_insert;

Line: 186

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

Line: 199

    pqh_rlm_rki.after_insert
      (
  p_role_id                       =>p_rec.role_id
 ,p_routing_list_id               =>p_rec.routing_list_id
 ,p_routing_list_member_id        =>p_rec.routing_list_member_id
 ,p_seq_no                        =>p_rec.seq_no
 ,p_approver_flag                 =>p_rec.approver_flag
 ,p_enable_flag                   =>p_rec.enable_flag
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_user_id                       =>p_rec.user_id
 ,p_effective_date                =>p_effective_date
      );

Line: 226

End post_insert;

Line: 244

  pqh_rlm_bus.insert_validate(p_rec
  ,p_effective_date);

Line: 249

  pre_insert(p_rec);

Line: 253

  insert_dml(p_rec);

Line: 257

  post_insert(
p_effective_date,p_rec);