APPS.PAY_MGB_UPD SQL Statements

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

Line: 54

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

Line: 66

  update pay_magnetic_blocks
  set
  magnetic_block_id                 = p_rec.magnetic_block_id,
  block_name                        = p_rec.block_name,
  main_block_flag                   = p_rec.main_block_flag,
  report_format                     = p_rec.report_format,
  cursor_name                       = p_rec.cursor_name,
  no_column_returned                = p_rec.no_column_returned
  where magnetic_block_id = p_rec.magnetic_block_id;

Line: 99

End update_dml;

Line: 133

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

Line: 141

End pre_update;

Line: 175

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

Line: 183

End post_update;

Line: 306

  pay_mgb_bus.update_validate(convert_defs(p_rec));

Line: 310

  pre_update(p_rec);

Line: 314

  update_dml(p_rec);

Line: 318

  post_update(p_rec);