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

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

Line: 361


procedure update_dpnt_eligy_criteria
  (
     p_validate                        in boolean    default false
     ,p_eligy_criteria_dpnt_id              in  number
     ,p_name                           in  varchar2  default hr_api.g_varchar2
     ,p_short_code                     in  varchar2  default hr_api.g_varchar2
     ,p_description                    in  varchar2  default hr_api.g_varchar2
     ,p_criteria_type		       in  varchar2  default hr_api.g_varchar2
     ,p_crit_col1_val_type_cd	       in  varchar2  default hr_api.g_varchar2
     ,p_crit_col1_datatype	       in  varchar2  default hr_api.g_varchar2
     ,p_col1_lookup_type	       in  varchar2  default hr_api.g_varchar2
     ,p_col1_value_set_id              in  number    default hr_api.g_number
     ,p_access_table_name1             in  varchar2  default hr_api.g_varchar2
     ,p_access_column_name1	       in  varchar2  default hr_api.g_varchar2
     ,p_time_entry_access_tab_nam1     in  varchar2  default hr_api.g_varchar2
     ,p_time_entry_access_col_nam1     in  varchar2  default hr_api.g_varchar2
     ,p_crit_col2_val_type_cd	       in  varchar2  default hr_api.g_varchar2
     ,p_crit_col2_datatype	       in  varchar2  default hr_api.g_varchar2
     ,p_col2_lookup_type	       in  varchar2  default hr_api.g_varchar2
     ,p_col2_value_set_id              in  number    default hr_api.g_number
     ,p_access_table_name2	       in  varchar2  default hr_api.g_varchar2
     ,p_access_column_name2	       in  varchar2  default hr_api.g_varchar2
     ,p_time_entry_access_tab_nam2     in  varchar2  default hr_api.g_varchar2
     ,p_time_entry_access_col_nam2     in  varchar2  default hr_api.g_varchar2
     ,p_allow_range_validation_flg     in  varchar2  default hr_api.g_varchar2
     ,p_user_defined_flag              in  varchar2  default hr_api.g_varchar2
     ,p_business_group_id 	       in  number    default hr_api.g_number
     ,p_egd_attribute_category         in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute1                 in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute2                 in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute3                 in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute4                 in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute5                 in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute6                 in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute7                 in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute8                 in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute9                 in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute10                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute11                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute12                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute13                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute14                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute15                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute16                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute17                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute18                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute19                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute20                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute21                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute22                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute23                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute24                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute25                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute26                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute27                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute28                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute29                in  varchar2  default hr_api.g_varchar2
     ,p_egd_attribute30                in  varchar2  default hr_api.g_varchar2
     ,p_object_version_number          in out nocopy number
     ,p_effective_date                 in  date
     ,p_allow_range_validation_flag2   in  varchar2  default hr_api.g_varchar2
     ,p_time_access_calc_rule1         in  number    default hr_api.g_number
     ,p_time_access_calc_rule2         in  number    default hr_api.g_number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_eligy_criteria_dpnt_id       ben_eligy_criteria_dpnt.eligy_criteria_dpnt_id%TYPE;

Line: 429


  l_proc varchar2(72)      := g_package||'update_dpnt_eligy_criteria';

Line: 441


  savepoint update_dpnt_eligy_criteria;

Line: 454


    ben_elig_crit_dpnt_bk2.update_dpnt_eligy_criteria_b
      (
            p_eligy_criteria_dpnt_id             => l_eligy_criteria_dpnt_id
           ,p_name                          => p_name
           ,p_short_code                    => p_short_code
           ,p_description                   => p_description
           ,p_criteria_type		    => p_criteria_type
           ,p_crit_col1_val_type_cd	    => p_crit_col1_val_type_cd
           ,p_crit_col1_datatype	    => p_crit_col1_datatype
           ,p_col1_lookup_type		    => p_col1_lookup_type
           ,p_col1_value_set_id             => p_col1_value_set_id
           ,p_access_table_name1            => p_access_table_name1
           ,p_access_column_name1	    => p_access_column_name1
           ,p_time_entry_access_tab_nam1    => p_time_entry_access_tab_nam1
           ,p_time_entry_access_col_nam1    => p_time_entry_access_col_nam1
           ,p_crit_col2_val_type_cd	    => p_crit_col2_val_type_cd
           ,p_crit_col2_datatype	    => p_crit_col2_datatype
           ,p_col2_lookup_type		    => p_col2_lookup_type
           ,p_col2_value_set_id             => p_col2_value_set_id
           ,p_access_table_name2	    => p_access_table_name2
           ,p_access_column_name2	    => p_access_column_name2
           ,p_time_entry_access_tab_nam2    => p_time_entry_access_tab_nam2
           ,p_time_entry_access_col_nam2    => p_time_entry_access_col_nam2
           ,p_allow_range_validation_flg    => p_allow_range_validation_flg
           ,p_user_defined_flag             => p_user_defined_flag
           ,p_business_group_id 	    => p_business_group_id
           ,p_egd_attribute_category        => p_egd_attribute_category
           ,p_egd_attribute1                => p_egd_attribute1
           ,p_egd_attribute2                => p_egd_attribute2
           ,p_egd_attribute3                => p_egd_attribute3
           ,p_egd_attribute4                => p_egd_attribute4
           ,p_egd_attribute5                => p_egd_attribute5
           ,p_egd_attribute6                => p_egd_attribute6
           ,p_egd_attribute7                => p_egd_attribute7
           ,p_egd_attribute8                => p_egd_attribute8
           ,p_egd_attribute9                => p_egd_attribute9
           ,p_egd_attribute10               => p_egd_attribute10
           ,p_egd_attribute11               => p_egd_attribute11
           ,p_egd_attribute12               => p_egd_attribute12
           ,p_egd_attribute13               => p_egd_attribute13
           ,p_egd_attribute14               => p_egd_attribute14
           ,p_egd_attribute15               => p_egd_attribute15
           ,p_egd_attribute16               => p_egd_attribute16
           ,p_egd_attribute17               => p_egd_attribute17
           ,p_egd_attribute18               => p_egd_attribute18
           ,p_egd_attribute19               => p_egd_attribute19
           ,p_egd_attribute20               => p_egd_attribute20
           ,p_egd_attribute21               => p_egd_attribute21
           ,p_egd_attribute22               => p_egd_attribute22
           ,p_egd_attribute23               => p_egd_attribute23
           ,p_egd_attribute24               => p_egd_attribute24
           ,p_egd_attribute25               => p_egd_attribute25
           ,p_egd_attribute26               => p_egd_attribute26
           ,p_egd_attribute27               => p_egd_attribute27
           ,p_egd_attribute28               => p_egd_attribute28
           ,p_egd_attribute29               => p_egd_attribute29
           ,p_egd_attribute30               => p_egd_attribute30
          ,p_object_version_number          => l_object_version_number
          ,p_effective_date                 => trunc(p_effective_date)
           ,p_allow_range_validation_flag2  =>  p_allow_range_validation_flag2
           ,p_time_access_calc_rule1        =>  p_time_access_calc_rule1
           ,p_time_access_calc_rule2        =>  p_time_access_calc_rule2
      );

Line: 520


        (p_module_name => 'UPDATE_dpnt_eligy_criteria'
        ,p_hook_type   => 'BP'
        );

Line: 596


    ben_elig_crit_dpnt_bk2.update_dpnt_eligy_criteria_a
      (
            p_eligy_criteria_dpnt_id             => l_eligy_criteria_dpnt_id
           ,p_name                          => p_name
           ,p_short_code                    => p_short_code
           ,p_description                   => p_description
           ,p_criteria_type		    => p_criteria_type
           ,p_crit_col1_val_type_cd	    => p_crit_col1_val_type_cd
           ,p_crit_col1_datatype	    => p_crit_col1_datatype
           ,p_col1_lookup_type		    => p_col1_lookup_type
           ,p_col1_value_set_id             => p_col1_value_set_id
           ,p_access_table_name1            => p_access_table_name1
           ,p_access_column_name1	    => p_access_column_name1
           ,p_time_entry_access_tab_nam1    => p_time_entry_access_tab_nam1
           ,p_time_entry_access_col_nam1    => p_time_entry_access_col_nam1
           ,p_crit_col2_val_type_cd	    => p_crit_col2_val_type_cd
           ,p_crit_col2_datatype	    => p_crit_col2_datatype
           ,p_col2_lookup_type		    => p_col2_lookup_type
           ,p_col2_value_set_id             => p_col2_value_set_id
           ,p_access_table_name2	    => p_access_table_name2
           ,p_access_column_name2	    => p_access_column_name2
           ,p_time_entry_access_tab_nam2    => p_time_entry_access_tab_nam2
           ,p_time_entry_access_col_nam2    => p_time_entry_access_col_nam2
           ,p_allow_range_validation_flg    => p_allow_range_validation_flg
           ,p_user_defined_flag             => p_user_defined_flag
           ,p_business_group_id 	    => p_business_group_id
           ,p_egd_attribute_category        => p_egd_attribute_category
           ,p_egd_attribute1                => p_egd_attribute1
           ,p_egd_attribute2                => p_egd_attribute2
           ,p_egd_attribute3                => p_egd_attribute3
           ,p_egd_attribute4                => p_egd_attribute4
           ,p_egd_attribute5                => p_egd_attribute5
           ,p_egd_attribute6                => p_egd_attribute6
           ,p_egd_attribute7                => p_egd_attribute7
           ,p_egd_attribute8                => p_egd_attribute8
           ,p_egd_attribute9                => p_egd_attribute9
           ,p_egd_attribute10               => p_egd_attribute10
           ,p_egd_attribute11               => p_egd_attribute11
           ,p_egd_attribute12               => p_egd_attribute12
           ,p_egd_attribute13               => p_egd_attribute13
           ,p_egd_attribute14               => p_egd_attribute14
           ,p_egd_attribute15               => p_egd_attribute15
           ,p_egd_attribute16               => p_egd_attribute16
           ,p_egd_attribute17               => p_egd_attribute17
           ,p_egd_attribute18               => p_egd_attribute18
           ,p_egd_attribute19               => p_egd_attribute19
           ,p_egd_attribute20               => p_egd_attribute20
           ,p_egd_attribute21               => p_egd_attribute21
           ,p_egd_attribute22               => p_egd_attribute22
           ,p_egd_attribute23               => p_egd_attribute23
           ,p_egd_attribute24               => p_egd_attribute24
           ,p_egd_attribute25               => p_egd_attribute25
           ,p_egd_attribute26               => p_egd_attribute26
           ,p_egd_attribute27               => p_egd_attribute27
           ,p_egd_attribute28               => p_egd_attribute28
           ,p_egd_attribute29               => p_egd_attribute29
           ,p_egd_attribute30               => p_egd_attribute30
           ,p_object_version_number         => l_object_version_number
	   ,p_effective_date                => trunc(p_effective_date)
           ,p_allow_range_validation_flag2  =>  p_allow_range_validation_flag2
           ,p_time_access_calc_rule1        =>  p_time_access_calc_rule1
           ,p_time_access_calc_rule2        =>  p_time_access_calc_rule2
      );

Line: 662


        (p_module_name => 'UPDATE_dpnt_eligy_criteria'
        ,p_hook_type   => 'AP'
        );

Line: 691


    ROLLBACK TO update_dpnt_eligy_criteria;

Line: 703


    ROLLBACK TO update_dpnt_eligy_criteria;

Line: 706


end update_dpnt_eligy_criteria;

Line: 711


procedure delete_dpnt_eligy_criteria
  (p_validate                       in  boolean  default false
  ,p_eligy_criteria_dpnt_id              in  number
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_dpnt_eligy_criteria';

Line: 729


  savepoint delete_dpnt_eligy_criteria;

Line: 742


    ben_elig_crit_dpnt_bk3.delete_dpnt_eligy_criteria_b
      (
       p_eligy_criteria_dpnt_id              =>  p_eligy_criteria_dpnt_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 751


        (p_module_name => 'DELETE_dpnt_eligy_criteria'
        ,p_hook_type   => 'BP'
        );

Line: 770


    ben_elig_crit_dpnt_bk3.delete_dpnt_eligy_criteria_a
      (
       p_eligy_criteria_dpnt_id              =>  p_eligy_criteria_dpnt_id
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 779


        (p_module_name => 'DELETE_dpnt_eligy_criteria'
        ,p_hook_type   => 'AP'
        );

Line: 804


    ROLLBACK TO delete_dpnt_eligy_criteria;

Line: 815


    ROLLBACK TO delete_dpnt_eligy_criteria;

Line: 818


end delete_dpnt_eligy_criteria;