APPS.PAY_MGR_INS SQL Statements

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

Line: 53

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

Line: 65

  insert into pay_magnetic_records
  (	formula_id,
	magnetic_block_id,
	next_block_id,
	last_run_executed_mode,
	overflow_mode,
	sequence,
	frequency ,
        action_level,
        block_label,
        block_row_label,
        xml_proc_name
  )
  Values
  (	p_rec.formula_id,
	p_rec.magnetic_block_id,
	p_rec.next_block_id,
	p_rec.last_run_executed_mode,
	p_rec.overflow_mode,
	p_rec.sequence,
	p_rec.frequency ,
        p_rec.action_level,
        p_rec.block_label,
        p_rec.block_row_label,
        p_rec.xml_proc_name
  );

Line: 114

End insert_dml;

Line: 153

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

Line: 165

End pre_insert;

Line: 199

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

Line: 207

End post_insert;

Line: 234

  pay_mgr_bus.insert_validate(p_rec);

Line: 238

  pre_insert(p_rec);

Line: 242

  insert_dml(p_rec);

Line: 246

  post_insert(p_rec);