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_EGL_INS SQL Statements

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

Line: 53


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

Line: 65


  insert into ben_eligy_criteria
  (
    eligy_criteria_id,
    name,
    short_code,
    description,
    criteria_type,
    crit_col1_val_type_cd,
    crit_col1_datatype,
    col1_lookup_type,
    col1_value_set_id,
    access_table_name1,
    access_column_name1,
    time_entry_access_table_name1,
    time_entry_access_col_name1,
    crit_col2_val_type_cd,
    crit_col2_datatype,
    col2_lookup_type,
    col2_value_set_id,
    access_table_name2,
    access_column_name2,
    time_entry_access_table_name2,
    time_entry_access_col_name2,
    access_calc_rule,
    allow_range_validation_flag,
    user_defined_flag,
    business_group_id,
    legislation_code,
    egl_attribute_category,
    egl_attribute1,
    egl_attribute2,
    egl_attribute3,
    egl_attribute4,
    egl_attribute5,
    egl_attribute6,
    egl_attribute7,
    egl_attribute8,
    egl_attribute9,
    egl_attribute10,
    egl_attribute11,
    egl_attribute12,
    egl_attribute13,
    egl_attribute14,
    egl_attribute15,
    egl_attribute16,
    egl_attribute17,
    egl_attribute18,
    egl_attribute19,
    egl_attribute20,
    egl_attribute21,
    egl_attribute22,
    egl_attribute23,
    egl_attribute24,
    egl_attribute25,
    egl_attribute26,
    egl_attribute27,
    egl_attribute28,
    egl_attribute29,
    egl_attribute30,
    object_version_number,
    allow_range_validation_flag2,
    access_calc_rule2,
    time_access_calc_rule1,
    time_access_calc_rule2
  )
  Values
  (	p_rec.eligy_criteria_id,
	p_rec.name,
	p_rec.short_code,
	p_rec.description,
	p_rec.criteria_type,
	p_rec.crit_col1_val_type_cd,
	p_rec.crit_col1_datatype,
	p_rec.col1_lookup_type,
	p_rec.col1_value_set_id,
	p_rec.access_table_name1,
	p_rec.access_column_name1,
	p_rec.time_entry_access_tab_nam1,
	p_rec.time_entry_access_col_nam1,
	p_rec.crit_col2_val_type_cd,
	p_rec.crit_col2_datatype,
	p_rec.col2_lookup_type,
	p_rec.col2_value_set_id,
	p_rec.access_table_name2,
	p_rec.access_column_name2,
	p_rec.time_entry_access_tab_nam2,
	p_rec.time_entry_access_col_nam2,
	p_rec.access_calc_rule,
	p_rec.allow_range_validation_flg,
	p_rec.user_defined_flag,
	p_rec.business_group_id,
	p_rec.legislation_code,
	p_rec.egl_attribute_category,
	p_rec.egl_attribute1,
	p_rec.egl_attribute2,
	p_rec.egl_attribute3,
	p_rec.egl_attribute4,
	p_rec.egl_attribute5,
	p_rec.egl_attribute6,
	p_rec.egl_attribute7,
	p_rec.egl_attribute8,
	p_rec.egl_attribute9,
	p_rec.egl_attribute10,
	p_rec.egl_attribute11,
	p_rec.egl_attribute12,
	p_rec.egl_attribute13,
	p_rec.egl_attribute14,
	p_rec.egl_attribute15,
	p_rec.egl_attribute16,
	p_rec.egl_attribute17,
	p_rec.egl_attribute18,
	p_rec.egl_attribute19,
	p_rec.egl_attribute20,
	p_rec.egl_attribute21,
	p_rec.egl_attribute22,
	p_rec.egl_attribute23,
	p_rec.egl_attribute24,
	p_rec.egl_attribute25,
	p_rec.egl_attribute26,
	p_rec.egl_attribute27,
	p_rec.egl_attribute28,
	p_rec.egl_attribute29,
	p_rec.egl_attribute30,
	p_rec.object_version_number,
        p_Rec.allow_range_validation_flag2,
        p_rec.access_calc_rule2,
        p_rec.time_access_calc_rule1,
        p_Rec.time_access_calc_rule2
  );

Line: 217


End insert_dml;

Line: 256


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

Line: 260


  Cursor C_Sel1 is select ben_eligy_criteria_s.nextval from sys.dual;

Line: 273


End pre_insert;

Line: 307


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

Line: 322


    ben_egl_rki.after_insert
      (
         p_eligy_criteria_id                =>   p_rec.eligy_criteria_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_access_calc_rule		    => 	 p_rec.access_calc_rule
        ,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_legislation_code 	      	    => 	 p_rec.legislation_code
        ,p_egl_attribute_category           => 	 p_rec.egl_attribute_category
        ,p_egl_attribute1                   => 	 p_rec.egl_attribute1
        ,p_egl_attribute2                   => 	 p_rec.egl_attribute2
        ,p_egl_attribute3                   => 	 p_rec.egl_attribute3
        ,p_egl_attribute4                   => 	 p_rec.egl_attribute4
        ,p_egl_attribute5                   => 	 p_rec.egl_attribute5
        ,p_egl_attribute6                   => 	 p_rec.egl_attribute6
        ,p_egl_attribute7                   => 	 p_rec.egl_attribute7
        ,p_egl_attribute8                   => 	 p_rec.egl_attribute8
        ,p_egl_attribute9                   => 	 p_rec.egl_attribute9
        ,p_egl_attribute10                  => 	 p_rec.egl_attribute10
        ,p_egl_attribute11                  => 	 p_rec.egl_attribute11
        ,p_egl_attribute12                  => 	 p_rec.egl_attribute12
        ,p_egl_attribute13                  => 	 p_rec.egl_attribute13
        ,p_egl_attribute14                  => 	 p_rec.egl_attribute14
        ,p_egl_attribute15                  => 	 p_rec.egl_attribute15
        ,p_egl_attribute16                  => 	 p_rec.egl_attribute16
        ,p_egl_attribute17                  => 	 p_rec.egl_attribute17
        ,p_egl_attribute18                  => 	 p_rec.egl_attribute18
        ,p_egl_attribute19                  => 	 p_rec.egl_attribute19
        ,p_egl_attribute20                  => 	 p_rec.egl_attribute20
        ,p_egl_attribute21                  => 	 p_rec.egl_attribute21
        ,p_egl_attribute22                  => 	 p_rec.egl_attribute22
        ,p_egl_attribute23                  => 	 p_rec.egl_attribute23
        ,p_egl_attribute24                  => 	 p_rec.egl_attribute24
        ,p_egl_attribute25                  => 	 p_rec.egl_attribute25
        ,p_egl_attribute26                  => 	 p_rec.egl_attribute26
        ,p_egl_attribute27                  =>	 p_rec.egl_attribute27
        ,p_egl_attribute28                  =>	 p_rec.egl_attribute28
        ,p_egl_attribute29                  =>	 p_rec.egl_attribute29
        ,p_egl_attribute30                  =>	 p_rec.egl_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_access_calc_rule2		    => 	 p_rec.access_calc_rule2
        ,p_time_access_calc_rule1	    => 	 p_rec.time_access_calc_rule1
        ,p_time_access_calc_rule2	    => 	 p_rec.time_access_calc_rule2

     );

Line: 404


End post_insert;

Line: 422


  ben_egl_bus.insert_validate(p_rec
  			      ,p_effective_date);

Line: 427


  pre_insert(p_rec);

Line: 431


  insert_dml(p_rec);

Line: 435


  post_insert(p_rec
  	     ,p_effective_date);