DBA Data[Home] [Help]

APPS.HXC_LKR_DEL SQL Statements

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

Line: 53

Procedure delete_dml
  (p_rec in hxc_lkr_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72);
Line: 63

  	l_proc := g_package||'delete_dml';
Line: 71

  delete from hxc_locking_rules
  where locker_type_owner_id = p_rec.locker_type_owner_id
    and locker_type_requestor_id = p_rec.locker_type_requestor_id;
Line: 90

End delete_dml;
Line: 124

Procedure pre_delete(p_rec in hxc_lkr_shd.g_rec_type) is
--
  l_proc  varchar2(72);
Line: 132

  	l_proc := g_package||'pre_delete';
Line: 137

End pre_delete;
Line: 171

Procedure post_delete(p_rec in hxc_lkr_shd.g_rec_type) is
--
  l_proc  varchar2(72);
Line: 179

  	l_proc := g_package||'post_delete';
Line: 185

    hxc_lkr_rkd.after_delete
      (p_locker_type_owner_id
      => p_rec.locker_type_owner_id
      ,p_locker_type_requestor_id
      => p_rec.locker_type_requestor_id
      ,p_grant_lock_o
      => hxc_lkr_shd.g_old_rec.grant_lock
      );
Line: 208

End post_delete;
Line: 236

  hxc_lkr_bus.delete_validate(p_rec);
Line: 243

  hxc_lkr_del.pre_delete(p_rec);
Line: 247

  hxc_lkr_del.delete_dml(p_rec);
Line: 251

  hxc_lkr_del.post_delete(p_rec);