APPS.PAY_SFR_UPD SQL Statements

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

Line: 51

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

Line: 65

  update pay_shadow_formula_rules
  set
  element_type_id                   = p_rec.element_type_id,
  result_name                       = p_rec.result_name,
  result_rule_type                  = p_rec.result_rule_type,
  severity_level                    = p_rec.severity_level,
  input_value_id                    = p_rec.input_value_id,
  exclusion_rule_id                 = p_rec.exclusion_rule_id,
  element_name                      = p_rec.element_name,
  object_version_number             = p_rec.object_version_number
  where formula_result_rule_id = p_rec.formula_result_rule_id;

Line: 95

End update_dml;

Line: 129

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

Line: 137

End pre_update;

Line: 171

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

Line: 179

End post_update;

Line: 304

  pay_sfr_bus.update_validate(p_effective_date, p_rec);

Line: 308

  pre_update(p_rec);

Line: 312

  update_dml(p_rec);

Line: 316

  post_update(p_rec);