APPS.SSP_ERN_UPD SQL Statements

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

Line: 52

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

Line: 67

  update ssp_earnings_calculations
    set	earnings_calculations_id          = p_rec.earnings_calculations_id,
	object_version_number             = p_rec.object_version_number,
	average_earnings_amount           = p_rec.average_earnings_amount,
	user_entered                      = p_rec.user_entered,
	payment_periods                   = p_rec.payment_periods
  where earnings_calculations_id = p_rec.earnings_calculations_id;

Line: 98

End update_dml;

Line: 130

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

Line: 138

End pre_update;

Line: 170

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

Line: 178

End post_update;

Line: 290

  ssp_ern_bus.update_validate(p_rec);

Line: 296

     pre_update(p_rec);

Line: 300

     update_dml(p_rec);

Line: 304

     post_update(p_rec);