APPS.BEN_EGL_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from ben_eligy_criteria
  where eligy_criteria_id = p_rec.eligy_criteria_id;

Line: 78

End delete_dml;

Line: 112

Procedure pre_delete(p_rec in ben_egl_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_egl_shd.g_rec_type
			,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 167

    ben_egl_rkd.after_delete
      (
    p_eligy_criteria_id                =>p_rec.eligy_criteria_id
   ,p_name_o                           =>ben_egl_shd.g_old_rec.name
   ,p_short_code_o                     =>ben_egl_shd.g_old_rec.short_code
   ,p_description_o                    =>ben_egl_shd.g_old_rec.description
   ,p_criteria_type_o		       =>ben_egl_shd.g_old_rec.criteria_type
   ,p_crit_col1_val_type_cd_o	       =>ben_egl_shd.g_old_rec.crit_col1_val_type_cd
   ,p_crit_col1_datatype_o	       =>ben_egl_shd.g_old_rec.crit_col1_datatype
   ,p_col1_lookup_type_o	       =>ben_egl_shd.g_old_rec.col1_lookup_type
   ,p_col1_value_set_id_o              =>ben_egl_shd.g_old_rec.col1_value_set_id
   ,p_access_table_name1_o             =>ben_egl_shd.g_old_rec.access_table_name1
   ,p_access_column_name1_o	       =>ben_egl_shd.g_old_rec.access_column_name1
   ,p_time_entry_access_tab_nam1_o     =>ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
   ,p_time_entry_access_col_nam1_o     =>ben_egl_shd.g_old_rec.time_entry_access_col_nam1
   ,p_crit_col2_val_type_cd_o	       =>ben_egl_shd.g_old_rec.crit_col2_val_type_cd
   ,p_crit_col2_datatype_o	       =>ben_egl_shd.g_old_rec.crit_col2_datatype
   ,p_col2_lookup_type_o	       =>ben_egl_shd.g_old_rec.col2_lookup_type
   ,p_col2_value_set_id_o              =>ben_egl_shd.g_old_rec.col2_value_set_id
   ,p_access_table_name2_o	       =>ben_egl_shd.g_old_rec.access_table_name2
   ,p_access_column_name2_o	       =>ben_egl_shd.g_old_rec.access_column_name2
   ,p_time_entry_access_tab_nam2_o     =>ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
   ,p_time_entry_access_col_nam2_o     =>ben_egl_shd.g_old_rec.time_entry_access_col_nam2
   ,p_access_calc_rule_o	       =>ben_egl_shd.g_old_rec.access_calc_rule
   ,p_allow_range_validation_flg_o     =>ben_egl_shd.g_old_rec.allow_range_validation_flg
   ,p_user_defined_flag_o              =>ben_egl_shd.g_old_rec.user_defined_flag
   ,p_business_group_id_o 	       =>ben_egl_shd.g_old_rec.business_group_id
   ,p_legislation_code_o 	       =>ben_egl_shd.g_old_rec.legislation_code
   ,p_egl_attribute_category_o         =>ben_egl_shd.g_old_rec.egl_attribute_category
   ,p_egl_attribute1_o                 =>ben_egl_shd.g_old_rec.egl_attribute1
   ,p_egl_attribute2_o                 =>ben_egl_shd.g_old_rec.egl_attribute2
   ,p_egl_attribute3_o                 =>ben_egl_shd.g_old_rec.egl_attribute3
   ,p_egl_attribute4_o                 =>ben_egl_shd.g_old_rec.egl_attribute4
   ,p_egl_attribute5_o                 =>ben_egl_shd.g_old_rec.egl_attribute5
   ,p_egl_attribute6_o                 =>ben_egl_shd.g_old_rec.egl_attribute6
   ,p_egl_attribute7_o                 =>ben_egl_shd.g_old_rec.egl_attribute7
   ,p_egl_attribute8_o                 =>ben_egl_shd.g_old_rec.egl_attribute8
   ,p_egl_attribute9_o                 =>ben_egl_shd.g_old_rec.egl_attribute9
   ,p_egl_attribute10_o                =>ben_egl_shd.g_old_rec.egl_attribute10
   ,p_egl_attribute11_o                =>ben_egl_shd.g_old_rec.egl_attribute11
   ,p_egl_attribute12_o                =>ben_egl_shd.g_old_rec.egl_attribute12
   ,p_egl_attribute13_o                =>ben_egl_shd.g_old_rec.egl_attribute13
   ,p_egl_attribute14_o                =>ben_egl_shd.g_old_rec.egl_attribute14
   ,p_egl_attribute15_o                =>ben_egl_shd.g_old_rec.egl_attribute15
   ,p_egl_attribute16_o                =>ben_egl_shd.g_old_rec.egl_attribute16
   ,p_egl_attribute17_o                =>ben_egl_shd.g_old_rec.egl_attribute17
   ,p_egl_attribute18_o                =>ben_egl_shd.g_old_rec.egl_attribute18
   ,p_egl_attribute19_o                =>ben_egl_shd.g_old_rec.egl_attribute19
   ,p_egl_attribute20_o                =>ben_egl_shd.g_old_rec.egl_attribute20
   ,p_egl_attribute21_o                =>ben_egl_shd.g_old_rec.egl_attribute21
   ,p_egl_attribute22_o                =>ben_egl_shd.g_old_rec.egl_attribute22
   ,p_egl_attribute23_o                =>ben_egl_shd.g_old_rec.egl_attribute23
   ,p_egl_attribute24_o                =>ben_egl_shd.g_old_rec.egl_attribute24
   ,p_egl_attribute25_o                =>ben_egl_shd.g_old_rec.egl_attribute25
   ,p_egl_attribute26_o                =>ben_egl_shd.g_old_rec.egl_attribute26
   ,p_egl_attribute27_o                =>ben_egl_shd.g_old_rec.egl_attribute27
   ,p_egl_attribute28_o                =>ben_egl_shd.g_old_rec.egl_attribute28
   ,p_egl_attribute29_o                =>ben_egl_shd.g_old_rec.egl_attribute29
   ,p_egl_attribute30_o                =>ben_egl_shd.g_old_rec.egl_attribute30
   ,p_object_version_number_o          =>ben_egl_shd.g_old_rec.object_version_number
   ,p_allw_range_validation_flg2_o     =>ben_egl_shd.g_old_rec.allow_range_validation_flag2
   ,p_access_calc_rule2_o              =>ben_egl_shd.g_old_rec.access_calc_rule2
   ,p_time_access_calc_rule1_o         =>ben_egl_shd.g_old_rec.time_access_calc_rule1
   ,p_time_access_calc_rule2_o         =>ben_egl_shd.g_old_rec.time_access_calc_rule2
      );

Line: 247

End post_delete;

Line: 273

  ben_egl_bus.delete_validate(p_rec,p_effective_date);

Line: 277

  pre_delete(p_rec);

Line: 281

  delete_dml(p_rec);

Line: 285

  post_delete(p_rec,p_effective_date);