eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DPNT_EGD_UPD SQL Statements

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

Line: 54


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

Line: 69


  update ben_eligy_criteria_dpnt
  set
   eligy_criteria_dpnt_id                =    p_rec.eligy_criteria_dpnt_id
  ,name                             = 	 p_rec.name
  ,short_code                       = 	 p_rec.short_code
  ,description                      = 	 p_rec.description
  ,criteria_type		    = 	 p_rec.criteria_type
  ,crit_col1_val_type_cd	    = 	 p_rec.crit_col1_val_type_cd
  ,crit_col1_datatype	      	    = 	 p_rec.crit_col1_datatype
  ,col1_lookup_type		    = 	 p_rec.col1_lookup_type
  ,col1_value_set_id          	    = 	 p_rec.col1_value_set_id
  ,access_table_name1         	    = 	 p_rec.access_table_name1
  ,access_column_name1	      	    = 	 p_rec.access_column_name1
  ,time_entry_access_table_name1    = 	 p_rec.time_entry_access_tab_nam1
  ,time_entry_access_col_name1 	    = 	 p_rec.time_entry_access_col_nam1
  ,crit_col2_val_type_cd	    = 	 p_rec.crit_col2_val_type_cd
  ,crit_col2_datatype	      	    = 	 p_rec.crit_col2_datatype
  ,col2_lookup_type		    = 	 p_rec.col2_lookup_type
  ,col2_value_set_id          	    = 	 p_rec.col2_value_set_id
  ,access_table_name2	      	    = 	 p_rec.access_table_name2
  ,access_column_name2	      	    = 	 p_rec.access_column_name2
  ,time_entry_access_table_name2     = 	 p_rec.time_entry_access_tab_nam2
  ,time_entry_access_col_name2 	    = 	 p_rec.time_entry_access_col_nam2
  ,allow_range_validation_flag 	    = 	 p_rec.allow_range_validation_flg
  ,user_defined_flag          	    = 	 p_rec.user_defined_flag
  ,business_group_id 	      	    = 	 p_rec.business_group_id
  ,egd_attribute_category           = 	 p_rec.egd_attribute_category
  ,egd_attribute1                   = 	 p_rec.egd_attribute1
  ,egd_attribute2                   = 	 p_rec.egd_attribute2
  ,egd_attribute3                   = 	 p_rec.egd_attribute3
  ,egd_attribute4                   = 	 p_rec.egd_attribute4
  ,egd_attribute5                   = 	 p_rec.egd_attribute5
  ,egd_attribute6                   = 	 p_rec.egd_attribute6
  ,egd_attribute7                   = 	 p_rec.egd_attribute7
  ,egd_attribute8                   = 	 p_rec.egd_attribute8
  ,egd_attribute9                   = 	 p_rec.egd_attribute9
  ,egd_attribute10                  = 	 p_rec.egd_attribute10
  ,egd_attribute11                  = 	 p_rec.egd_attribute11
  ,egd_attribute12                  = 	 p_rec.egd_attribute12
  ,egd_attribute13                  = 	 p_rec.egd_attribute13
  ,egd_attribute14                  = 	 p_rec.egd_attribute14
  ,egd_attribute15                  = 	 p_rec.egd_attribute15
  ,egd_attribute16                  = 	 p_rec.egd_attribute16
  ,egd_attribute17                  = 	 p_rec.egd_attribute17
  ,egd_attribute18                  = 	 p_rec.egd_attribute18
  ,egd_attribute19                  = 	 p_rec.egd_attribute19
  ,egd_attribute20                  = 	 p_rec.egd_attribute20
  ,egd_attribute21                  = 	 p_rec.egd_attribute21
  ,egd_attribute22                  = 	 p_rec.egd_attribute22
  ,egd_attribute23                  = 	 p_rec.egd_attribute23
  ,egd_attribute24                  = 	 p_rec.egd_attribute24
  ,egd_attribute25                  = 	 p_rec.egd_attribute25
  ,egd_attribute26                  = 	 p_rec.egd_attribute26
  ,egd_attribute27                  =	 p_rec.egd_attribute27
  ,egd_attribute28                  =	 p_rec.egd_attribute28
  ,egd_attribute29                  =	 p_rec.egd_attribute29
  ,egd_attribute30                  =	 p_rec.egd_attribute30
  ,object_version_number            =	 p_rec.object_version_number
  ,allow_range_validation_flag2     = 	 p_rec.allow_range_validation_flag2
  ,time_access_calc_rule1	    = 	 p_rec.time_access_calc_rule1
  ,time_access_calc_rule2	    = 	 p_rec.time_access_calc_rule2


  where eligy_criteria_dpnt_id = p_rec.eligy_criteria_dpnt_id;

Line: 157


End update_dml;

Line: 191


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

Line: 199


End pre_update;

Line: 233


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

Line: 247


    ben_dpnt_egd_rku.after_update
  (
   p_eligy_criteria_dpnt_id                =>         p_rec.eligy_criteria_dpnt_id
  ,p_name                             => 	 p_rec.name
  ,p_short_code                       => 	 p_rec.short_code
  ,p_description                      => 	 p_rec.description
  ,p_criteria_type		      => 	 p_rec.criteria_type
  ,p_crit_col1_val_type_cd	      => 	 p_rec.crit_col1_val_type_cd
  ,p_crit_col1_datatype	      	      => 	 p_rec.crit_col1_datatype
  ,p_col1_lookup_type		      => 	 p_rec.col1_lookup_type
  ,p_col1_value_set_id                => 	 p_rec.col1_value_set_id
  ,p_access_table_name1               => 	 p_rec.access_table_name1
  ,p_access_column_name1	      => 	 p_rec.access_column_name1
  ,p_time_entry_access_tab_nam1       => 	 p_rec.time_entry_access_tab_nam1
  ,p_time_entry_access_col_nam1       => 	 p_rec.time_entry_access_col_nam1
  ,p_crit_col2_val_type_cd	      => 	 p_rec.crit_col2_val_type_cd
  ,p_crit_col2_datatype	      	      => 	 p_rec.crit_col2_datatype
  ,p_col2_lookup_type		      => 	 p_rec.col2_lookup_type
  ,p_col2_value_set_id                => 	 p_rec.col2_value_set_id
  ,p_access_table_name2	      	      => 	 p_rec.access_table_name2
  ,p_access_column_name2	      => 	 p_rec.access_column_name2
  ,p_time_entry_access_tab_nam2       => 	 p_rec.time_entry_access_tab_nam2
  ,p_time_entry_access_col_nam2       => 	 p_rec.time_entry_access_col_nam2
  ,p_allow_range_validation_flg       => 	 p_rec.allow_range_validation_flg
  ,p_user_defined_flag                => 	 p_rec.user_defined_flag
  ,p_business_group_id 	      	      => 	 p_rec.business_group_id
  ,p_egd_attribute_category           => 	 p_rec.egd_attribute_category
  ,p_egd_attribute1                   => 	 p_rec.egd_attribute1
  ,p_egd_attribute2                   => 	 p_rec.egd_attribute2
  ,p_egd_attribute3                   => 	 p_rec.egd_attribute3
  ,p_egd_attribute4                   => 	 p_rec.egd_attribute4
  ,p_egd_attribute5                   => 	 p_rec.egd_attribute5
  ,p_egd_attribute6                   => 	 p_rec.egd_attribute6
  ,p_egd_attribute7                   => 	 p_rec.egd_attribute7
  ,p_egd_attribute8                   => 	 p_rec.egd_attribute8
  ,p_egd_attribute9                   => 	 p_rec.egd_attribute9
  ,p_egd_attribute10                  => 	 p_rec.egd_attribute10
  ,p_egd_attribute11                  => 	 p_rec.egd_attribute11
  ,p_egd_attribute12                  => 	 p_rec.egd_attribute12
  ,p_egd_attribute13                  => 	 p_rec.egd_attribute13
  ,p_egd_attribute14                  => 	 p_rec.egd_attribute14
  ,p_egd_attribute15                  => 	 p_rec.egd_attribute15
  ,p_egd_attribute16                  => 	 p_rec.egd_attribute16
  ,p_egd_attribute17                  => 	 p_rec.egd_attribute17
  ,p_egd_attribute18                  => 	 p_rec.egd_attribute18
  ,p_egd_attribute19                  => 	 p_rec.egd_attribute19
  ,p_egd_attribute20                  => 	 p_rec.egd_attribute20
  ,p_egd_attribute21                  => 	 p_rec.egd_attribute21
  ,p_egd_attribute22                  => 	 p_rec.egd_attribute22
  ,p_egd_attribute23                  => 	 p_rec.egd_attribute23
  ,p_egd_attribute24                  => 	 p_rec.egd_attribute24
  ,p_egd_attribute25                  => 	 p_rec.egd_attribute25
  ,p_egd_attribute26                  => 	 p_rec.egd_attribute26
  ,p_egd_attribute27                  =>	 p_rec.egd_attribute27
  ,p_egd_attribute28                  =>	 p_rec.egd_attribute28
  ,p_egd_attribute29                  =>	 p_rec.egd_attribute29
  ,p_egd_attribute30                  =>	 p_rec.egd_attribute30
  ,p_object_version_number            =>	 p_rec.object_version_number
  ,p_effective_date   		      =>         p_effective_date
  ,p_allow_range_validation_flag2     => 	 p_rec.allow_range_validation_flag2
  ,p_time_access_calc_rule1	      => 	 p_rec.time_access_calc_rule1
  ,p_time_access_calc_rule2	      => 	 p_rec.time_access_calc_rule2
  ,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: 383


End post_update;

Line: 704


  ben_dpnt_egd_bus.update_validate(p_rec,p_effective_date);

Line: 708


  pre_update(p_rec);

Line: 712


  update_dml(p_rec);

Line: 716


  post_update(p_rec,p_effective_date);