APPS.PAY_MGR_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from pay_magnetic_records
  where magnetic_block_id = p_rec.magnetic_block_id
  and   sequence = p_rec.sequence;

Line: 79

End delete_dml;

Line: 113

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

Line: 121

End pre_delete;

Line: 155

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

Line: 163

End post_delete;

Line: 198

  pay_mgr_bus.delete_validate(p_rec);

Line: 202

  pre_delete(p_rec);

Line: 206

  delete_dml(p_rec);

Line: 210

  post_delete(p_rec);