APPS.PAY_TER_UPD SQL Statements

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

Line: 48

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

Line: 61

  update pay_template_exclusion_rules
  set
  flexfield_column                  = p_rec.flexfield_column,
  exclusion_value                   = p_rec.exclusion_value,
  description                       = p_rec.description,
  object_version_number             = p_rec.object_version_number
  where exclusion_rule_id = p_rec.exclusion_rule_id;

Line: 86

End update_dml;

Line: 120

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

Line: 128

End pre_update;

Line: 162

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

Line: 170

End post_update;

Line: 279

  pay_ter_bus.update_validate(p_rec);

Line: 283

  pre_update(p_rec);

Line: 287

  update_dml(p_rec);

Line: 291

  post_update(p_rec);