APPS.PAY_SFR_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_sfr_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 61

  insert into pay_shadow_formula_rules
  (	formula_result_rule_id,
	shadow_element_type_id,
	element_type_id,
	result_name,
	result_rule_type,
	severity_level,
	input_value_id,
	exclusion_rule_id,
        element_name,
	object_version_number
  )
  Values
  (	p_rec.formula_result_rule_id,
	p_rec.shadow_element_type_id,
	p_rec.element_type_id,
	p_rec.result_name,
	p_rec.result_rule_type,
	p_rec.severity_level,
	p_rec.input_value_id,
	p_rec.exclusion_rule_id,
	p_rec.element_name,
	p_rec.object_version_number
  );

Line: 103

End insert_dml;

Line: 142

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

Line: 146

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

Line: 159

End pre_insert;

Line: 193

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

Line: 201

End post_insert;

Line: 219

  pay_sfr_bus.insert_validate(p_effective_date, p_rec);

Line: 223

  pre_insert(p_rec);

Line: 227

  insert_dml(p_rec);

Line: 231

  post_insert(p_rec);