APPS.BEN_CSO_DEL SQL Statements

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

Line: 51

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

Line: 64

  delete from ben_cwb_stock_optn_dtls
  where cwb_stock_optn_dtls_id = p_rec.cwb_stock_optn_dtls_id;

Line: 80

End delete_dml;

Line: 114

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

Line: 122

End pre_delete;

Line: 156

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

Line: 164

    ben_cso_rkd.after_delete
      (p_cwb_stock_optn_dtls_id
      => p_rec.cwb_stock_optn_dtls_id
      ,p_grant_id_o
      => ben_cso_shd.g_old_rec.grant_id
      ,p_grant_number_o
      => ben_cso_shd.g_old_rec.grant_number
      ,p_grant_name_o
      => ben_cso_shd.g_old_rec.grant_name
      ,p_grant_type_o
      => ben_cso_shd.g_old_rec.grant_type
      ,p_grant_date_o
      => ben_cso_shd.g_old_rec.grant_date
      ,p_grant_shares_o
      => ben_cso_shd.g_old_rec.grant_shares
      ,p_grant_price_o
      => ben_cso_shd.g_old_rec.grant_price
      ,p_value_at_grant_o
      => ben_cso_shd.g_old_rec.value_at_grant
      ,p_current_share_price_o
      => ben_cso_shd.g_old_rec.current_share_price
      ,p_current_shares_outstanding_o
      => ben_cso_shd.g_old_rec.current_shares_outstanding
      ,p_vested_shares_o
      => ben_cso_shd.g_old_rec.vested_shares
      ,p_unvested_shares_o
      => ben_cso_shd.g_old_rec.unvested_shares
      ,p_exercisable_shares_o
      => ben_cso_shd.g_old_rec.exercisable_shares
      ,p_exercised_shares_o
      => ben_cso_shd.g_old_rec.exercised_shares
      ,p_cancelled_shares_o
      => ben_cso_shd.g_old_rec.cancelled_shares
      ,p_trading_symbol_o
      => ben_cso_shd.g_old_rec.trading_symbol
      ,p_expiration_date_o
      => ben_cso_shd.g_old_rec.expiration_date
      ,p_reason_code_o
      => ben_cso_shd.g_old_rec.reason_code
      ,p_class_o
      => ben_cso_shd.g_old_rec.class
      ,p_misc_o
      => ben_cso_shd.g_old_rec.misc
      ,p_employee_number_o
      => ben_cso_shd.g_old_rec.employee_number
      ,p_person_id_o
      => ben_cso_shd.g_old_rec.person_id
      ,p_business_group_id_o
      => ben_cso_shd.g_old_rec.business_group_id
      ,p_prtt_rt_val_id_o
      => ben_cso_shd.g_old_rec.prtt_rt_val_id
      ,p_object_version_number_o
      => ben_cso_shd.g_old_rec.object_version_number
      ,p_cso_attribute_category_o
      => ben_cso_shd.g_old_rec.cso_attribute_category
      ,p_cso_attribute1_o
      => ben_cso_shd.g_old_rec.cso_attribute1
      ,p_cso_attribute2_o
      => ben_cso_shd.g_old_rec.cso_attribute2
      ,p_cso_attribute3_o
      => ben_cso_shd.g_old_rec.cso_attribute3
      ,p_cso_attribute4_o
      => ben_cso_shd.g_old_rec.cso_attribute4
      ,p_cso_attribute5_o
      => ben_cso_shd.g_old_rec.cso_attribute5
      ,p_cso_attribute6_o
      => ben_cso_shd.g_old_rec.cso_attribute6
      ,p_cso_attribute7_o
      => ben_cso_shd.g_old_rec.cso_attribute7
      ,p_cso_attribute8_o
      => ben_cso_shd.g_old_rec.cso_attribute8
      ,p_cso_attribute9_o
      => ben_cso_shd.g_old_rec.cso_attribute9
      ,p_cso_attribute10_o
      => ben_cso_shd.g_old_rec.cso_attribute10
      ,p_cso_attribute11_o
      => ben_cso_shd.g_old_rec.cso_attribute11
      ,p_cso_attribute12_o
      => ben_cso_shd.g_old_rec.cso_attribute12
      ,p_cso_attribute13_o
      => ben_cso_shd.g_old_rec.cso_attribute13
      ,p_cso_attribute14_o
      => ben_cso_shd.g_old_rec.cso_attribute14
      ,p_cso_attribute15_o
      => ben_cso_shd.g_old_rec.cso_attribute15
      ,p_cso_attribute16_o
      => ben_cso_shd.g_old_rec.cso_attribute16
      ,p_cso_attribute17_o
      => ben_cso_shd.g_old_rec.cso_attribute17
      ,p_cso_attribute18_o
      => ben_cso_shd.g_old_rec.cso_attribute18
      ,p_cso_attribute19_o
      => ben_cso_shd.g_old_rec.cso_attribute19
      ,p_cso_attribute20_o
      => ben_cso_shd.g_old_rec.cso_attribute20
      ,p_cso_attribute21_o
      => ben_cso_shd.g_old_rec.cso_attribute21
      ,p_cso_attribute22_o
      => ben_cso_shd.g_old_rec.cso_attribute22
      ,p_cso_attribute23_o
      => ben_cso_shd.g_old_rec.cso_attribute23
      ,p_cso_attribute24_o
      => ben_cso_shd.g_old_rec.cso_attribute24
      ,p_cso_attribute25_o
      => ben_cso_shd.g_old_rec.cso_attribute25
      ,p_cso_attribute26_o
      => ben_cso_shd.g_old_rec.cso_attribute26
      ,p_cso_attribute27_o
      => ben_cso_shd.g_old_rec.cso_attribute27
      ,p_cso_attribute28_o
      => ben_cso_shd.g_old_rec.cso_attribute28
      ,p_cso_attribute29_o
      => ben_cso_shd.g_old_rec.cso_attribute29
      ,p_cso_attribute30_o
      => ben_cso_shd.g_old_rec.cso_attribute30
      );

Line: 292

End post_delete;

Line: 315

  ben_cso_bus.delete_validate(p_rec);

Line: 322

  ben_cso_del.pre_delete(p_rec);

Line: 326

  ben_cso_del.delete_dml(p_rec);

Line: 330

  ben_cso_del.post_delete(p_rec);