DBA Data[Home] [Help]

APPS.PAY_SBF_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_sbf_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';
Line: 65

  update pay_shadow_balance_feeds
  set
  scale                             = p_rec.scale,
  exclusion_rule_id                 = p_rec.exclusion_rule_id,
  object_version_number             = p_rec.object_version_number
  where balance_feed_id = p_rec.balance_feed_id;
Line: 90

End update_dml;
Line: 124

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

End pre_update;
Line: 166

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

End post_update;
Line: 288

  pay_sbf_bus.update_validate(p_rec);
Line: 292

  pre_update(p_rec);
Line: 296

  update_dml(p_rec);
Line: 300

  post_update(p_rec);