APPS.PAY_SBF_INS SQL Statements

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

Line: 50

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

Line: 61

  insert into pay_shadow_balance_feeds
  (	balance_feed_id,
	balance_type_id,
	input_value_id,
	scale,
	balance_name,
        exclusion_rule_id,
	object_version_number
  )
  Values
  (	p_rec.balance_feed_id,
	p_rec.balance_type_id,
	p_rec.input_value_id,
	p_rec.scale,
	p_rec.balance_name,
	p_rec.exclusion_rule_id,
	p_rec.object_version_number
  );

Line: 97

End insert_dml;

Line: 136

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

Line: 140

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

Line: 153

End pre_insert;

Line: 187

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

Line: 195

End post_insert;

Line: 213

  pay_sbf_bus.insert_validate(p_rec);

Line: 217

  pre_insert(p_rec);

Line: 221

  insert_dml(p_rec);

Line: 225

  post_insert(p_rec);