APPS.SSP_ERN_INS SQL Statements

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

Line: 52

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

Line: 64

  insert into ssp_earnings_calculations
  (	earnings_calculations_id,
	object_version_number,
	person_id,
	effective_date,
	average_earnings_amount,
	user_entered,
	payment_periods
  )
  Values
  (	p_rec.earnings_calculations_id,
	p_rec.object_version_number,
	p_rec.person_id,
	p_rec.effective_date,
	p_rec.average_earnings_amount,
	p_rec.user_entered,
	p_rec.payment_periods
  );

Line: 105

End insert_dml;

Line: 142

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

Line: 146

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

Line: 158

End pre_insert;

Line: 190

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

Line: 198

End post_insert;

Line: 226

  ssp_ern_bus.insert_validate(p_rec);

Line: 238

     pre_insert(p_rec);

Line: 242

     insert_dml(p_rec);

Line: 246

     post_insert(p_rec);