APPS.BEN_DPNT_EGD_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from ben_eligy_criteria_dpnt
  where eligy_criteria_dpnt_id = p_rec.eligy_criteria_dpnt_id;

Line: 78

End delete_dml;

Line: 112

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

Line: 120

End pre_delete;

Line: 154

Procedure post_delete(p_rec in ben_dpnt_egd_shd.g_rec_type
			,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 168

    ben_dpnt_egd_rkd.after_delete
      (
    p_eligy_criteria_dpnt_id                =>p_rec.eligy_criteria_dpnt_id
   ,p_name_o                           =>ben_dpnt_egd_shd.g_old_rec.name
   ,p_short_code_o                     =>ben_dpnt_egd_shd.g_old_rec.short_code
   ,p_description_o                    =>ben_dpnt_egd_shd.g_old_rec.description
   ,p_criteria_type_o		       =>ben_dpnt_egd_shd.g_old_rec.criteria_type
   ,p_crit_col1_val_type_cd_o	       =>ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
   ,p_crit_col1_datatype_o	       =>ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
   ,p_col1_lookup_type_o	       =>ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
   ,p_col1_value_set_id_o              =>ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
   ,p_access_table_name1_o             =>ben_dpnt_egd_shd.g_old_rec.access_table_name1
   ,p_access_column_name1_o	       =>ben_dpnt_egd_shd.g_old_rec.access_column_name1
   ,p_time_entry_access_tab_nam1_o     =>ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
   ,p_time_entry_access_col_nam1_o     =>ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
   ,p_crit_col2_val_type_cd_o	       =>ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
   ,p_crit_col2_datatype_o	       =>ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
   ,p_col2_lookup_type_o	       =>ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
   ,p_col2_value_set_id_o              =>ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
   ,p_access_table_name2_o	       =>ben_dpnt_egd_shd.g_old_rec.access_table_name2
   ,p_access_column_name2_o	       =>ben_dpnt_egd_shd.g_old_rec.access_column_name2
   ,p_time_entry_access_tab_nam2_o     =>ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
   ,p_time_entry_access_col_nam2_o     =>ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
   ,p_allow_range_validation_flg_o     =>ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
   ,p_user_defined_flag_o              =>ben_dpnt_egd_shd.g_old_rec.user_defined_flag
   ,p_business_group_id_o 	       =>ben_dpnt_egd_shd.g_old_rec.business_group_id
   ,p_egd_attribute_category_o         =>ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
   ,p_egd_attribute1_o                 =>ben_dpnt_egd_shd.g_old_rec.egd_attribute1
   ,p_egd_attribute2_o                 =>ben_dpnt_egd_shd.g_old_rec.egd_attribute2
   ,p_egd_attribute3_o                 =>ben_dpnt_egd_shd.g_old_rec.egd_attribute3
   ,p_egd_attribute4_o                 =>ben_dpnt_egd_shd.g_old_rec.egd_attribute4
   ,p_egd_attribute5_o                 =>ben_dpnt_egd_shd.g_old_rec.egd_attribute5
   ,p_egd_attribute6_o                 =>ben_dpnt_egd_shd.g_old_rec.egd_attribute6
   ,p_egd_attribute7_o                 =>ben_dpnt_egd_shd.g_old_rec.egd_attribute7
   ,p_egd_attribute8_o                 =>ben_dpnt_egd_shd.g_old_rec.egd_attribute8
   ,p_egd_attribute9_o                 =>ben_dpnt_egd_shd.g_old_rec.egd_attribute9
   ,p_egd_attribute10_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute10
   ,p_egd_attribute11_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute11
   ,p_egd_attribute12_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute12
   ,p_egd_attribute13_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute13
   ,p_egd_attribute14_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute14
   ,p_egd_attribute15_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute15
   ,p_egd_attribute16_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute16
   ,p_egd_attribute17_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute17
   ,p_egd_attribute18_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute18
   ,p_egd_attribute19_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute19
   ,p_egd_attribute20_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute20
   ,p_egd_attribute21_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute21
   ,p_egd_attribute22_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute22
   ,p_egd_attribute23_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute23
   ,p_egd_attribute24_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute24
   ,p_egd_attribute25_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute25
   ,p_egd_attribute26_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute26
   ,p_egd_attribute27_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute27
   ,p_egd_attribute28_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute28
   ,p_egd_attribute29_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute29
   ,p_egd_attribute30_o                =>ben_dpnt_egd_shd.g_old_rec.egd_attribute30
   ,p_object_version_number_o          =>ben_dpnt_egd_shd.g_old_rec.object_version_number
   ,p_allw_range_validation_flg2_o     =>ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2
   ,p_time_access_calc_rule1_o         =>ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1
   ,p_time_access_calc_rule2_o         =>ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule2
      );

Line: 246

End post_delete;

Line: 272

  ben_dpnt_egd_bus.delete_validate(p_rec,p_effective_date);

Line: 276

  pre_delete(p_rec);

Line: 280

  delete_dml(p_rec);

Line: 284

  post_delete(p_rec,p_effective_date);