APPS.PAY_PGP_INS SQL Statements

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

Line: 50

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

Line: 61

  insert into pay_people_groups
  (	people_group_id,
	group_name,
	id_flex_num,
	summary_flag,
	enabled_flag,
	start_date_active,
	end_date_active,
	segment1,
	segment2,
	segment3,
	segment4,
	segment5,
	segment6,
	segment7,
	segment8,
	segment9,
	segment10,
	segment11,
	segment12,
	segment13,
	segment14,
	segment15,
	segment16,
	segment17,
	segment18,
	segment19,
	segment20,
	segment21,
	segment22,
	segment23,
	segment24,
	segment25,
	segment26,
	segment27,
	segment28,
	segment29,
	segment30
  )
  Values
  (	p_rec.people_group_id,
	p_rec.group_name,
	p_rec.id_flex_num,
	p_rec.summary_flag,
	p_rec.enabled_flag,
	p_rec.start_date_active,
	p_rec.end_date_active,
	p_rec.segment1,
	p_rec.segment2,
	p_rec.segment3,
	p_rec.segment4,
	p_rec.segment5,
	p_rec.segment6,
	p_rec.segment7,
	p_rec.segment8,
	p_rec.segment9,
	p_rec.segment10,
	p_rec.segment11,
	p_rec.segment12,
	p_rec.segment13,
	p_rec.segment14,
	p_rec.segment15,
	p_rec.segment16,
	p_rec.segment17,
	p_rec.segment18,
	p_rec.segment19,
	p_rec.segment20,
	p_rec.segment21,
	p_rec.segment22,
	p_rec.segment23,
	p_rec.segment24,
	p_rec.segment25,
	p_rec.segment26,
	p_rec.segment27,
	p_rec.segment28,
	p_rec.segment29,
	p_rec.segment30
  );

Line: 162

End insert_dml;

Line: 201

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

Line: 205

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

Line: 265

End pre_insert;

Line: 299

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

Line: 307

End post_insert;

Line: 334

  pay_pgp_bus.insert_validate(p_rec);

Line: 338

  pre_insert(p_rec);

Line: 342

  insert_dml(p_rec);

Line: 346

  post_insert(p_rec);