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

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

Line: 355


procedure update_dpnt_eligy_crit_val
  (
   p_validate                     In  Boolean      default false
  ,p_dpnt_eligy_crit_values_id         In  Number
  ,p_dpnt_cvg_eligy_prfl_id                In  Number       default hr_api.g_number
  ,p_eligy_criteria_dpnt_id            In  Number       default hr_api.g_number
  ,p_effective_start_date         Out nocopy Date
  ,p_effective_end_date           Out nocopy Date
  ,p_ordr_num                     In  Number       default hr_api.g_number
  ,p_number_value1                In  Number       default hr_api.g_number
  ,p_number_value2                In  Number       default hr_api.g_number
  ,p_char_value1                  In  Varchar2     default hr_api.g_varchar2
  ,p_char_value2                  In  Varchar2     default hr_api.g_varchar2
  ,p_date_value1                  In  Date         default hr_api.g_date
  ,p_date_value2                  In  Date         default hr_api.g_date
  ,p_excld_flag                   In  Varchar2     default hr_api.g_varchar2
  ,p_business_group_id            In  Number       default hr_api.g_number
  ,p_edc_attribute_category       In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute1               In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute2               In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute3               In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute4               In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute5               In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute6               In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute7               In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute8               In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute9               In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute10              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute11              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute12              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute13              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute14              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute15              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute16              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute17              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute18              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute19              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute20              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute21              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute22              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute23              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute24              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute25              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute26              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute27              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute28              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute29              In  Varchar2     default hr_api.g_varchar2
  ,p_edc_attribute30              In  Varchar2     default hr_api.g_varchar2
  ,p_object_version_number        In  Out nocopy Number
  ,p_effective_date               In  Date
  ,p_datetrack_mode               In  varchar2
  ,p_char_value3                  In  Varchar2     default hr_api.g_varchar2
  ,p_char_value4                  In  Varchar2     default hr_api.g_varchar2
  ,p_number_value3                In  Number       default hr_api.g_number
  ,p_number_value4                In  Number       default hr_api.g_number
  ,p_date_value3                  In  Date         default hr_api.g_date
  ,p_date_value4                  In  Date         default hr_api.g_date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_eligy_crit_values';

Line: 427


  savepoint dpnt_update_eligy_crit_values;

Line: 439


    ben_dpnt_elig_crit_val_bk2.update_dpnt_eligy_crit_val_b
       (
       p_dpnt_eligy_crit_values_id        	=>   p_dpnt_eligy_crit_values_id,
       p_dpnt_cvg_eligy_prfl_id               	=>   p_dpnt_cvg_eligy_prfl_id,
       p_eligy_criteria_dpnt_id           	=>   p_eligy_criteria_dpnt_id,
       p_ordr_num                       =>   p_ordr_num,
       p_number_value1               	=>   p_number_value1,
       p_number_value2               	=>   p_number_value2,
       p_char_value1                 	=>   p_char_value1,
       p_char_value2                 	=>   p_char_value2,
       p_date_value1                 	=>   p_date_value1,
       p_date_value2                 	=>   p_date_value2,
       p_excld_flag                     =>   p_excld_flag,
       p_business_group_id           	=>   p_business_group_id,
       p_edc_attribute_category      	=>   p_edc_attribute_category,
       p_edc_attribute1              	=>   p_edc_attribute1,
       p_edc_attribute2              	=>   p_edc_attribute2,
       p_edc_attribute3              	=>   p_edc_attribute3,
       p_edc_attribute4              	=>   p_edc_attribute4,
       p_edc_attribute5              	=>   p_edc_attribute5,
       p_edc_attribute6              	=>   p_edc_attribute6,
       p_edc_attribute7              	=>   p_edc_attribute7,
       p_edc_attribute8              	=>   p_edc_attribute8,
       p_edc_attribute9              	=>   p_edc_attribute9,
       p_edc_attribute10             	=>   p_edc_attribute10,
       p_edc_attribute11             	=>   p_edc_attribute11,
       p_edc_attribute12             	=>   p_edc_attribute12,
       p_edc_attribute13             	=>   p_edc_attribute13,
       p_edc_attribute14             	=>   p_edc_attribute14,
       p_edc_attribute15             	=>   p_edc_attribute15,
       p_edc_attribute16             	=>   p_edc_attribute16,
       p_edc_attribute17             	=>   p_edc_attribute17,
       p_edc_attribute18             	=>   p_edc_attribute18,
       p_edc_attribute19             	=>   p_edc_attribute19,
       p_edc_attribute20             	=>   p_edc_attribute20,
       p_edc_attribute21             	=>   p_edc_attribute21,
       p_edc_attribute22             	=>   p_edc_attribute22,
       p_edc_attribute23             	=>   p_edc_attribute23,
       p_edc_attribute24             	=>   p_edc_attribute24,
       p_edc_attribute25             	=>   p_edc_attribute25,
       p_edc_attribute26             	=>   p_edc_attribute26,
       p_edc_attribute27             	=>   p_edc_attribute27,
       p_edc_attribute28             	=>   p_edc_attribute28,
       p_edc_attribute29             	=>   p_edc_attribute29,
       p_edc_attribute30             	=>   p_edc_attribute30,
       p_object_version_number       	=>   p_object_version_number,
       p_effective_date              	=>   trunc(p_effective_date),
       p_datetrack_mode                 =>   p_datetrack_mode,
       p_char_value3                    =>   p_char_value3,
       p_char_value4                  	=>   p_char_value4,
       p_number_value3                	=>   p_number_value3,
       p_number_value4                	=>   p_number_value4,
       p_date_value3                  	=>   p_date_value3,
       p_date_value4                  	=>   p_date_value4
       );

Line: 497


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

Line: 569


    ben_dpnt_elig_crit_val_bk2.update_dpnt_eligy_crit_val_a
      (
       p_dpnt_eligy_crit_values_id       	=>   p_dpnt_eligy_crit_values_id,
       p_dpnt_cvg_eligy_prfl_id              	=>   p_dpnt_cvg_eligy_prfl_id,
       p_eligy_criteria_dpnt_id           	=>   p_eligy_criteria_dpnt_id,
       p_effective_start_date           =>   p_effective_start_date,
       p_effective_end_date             =>   p_effective_end_date,
       p_ordr_num                       =>   p_ordr_num,
       p_number_value1               	=>   p_number_value1,
       p_number_value2               	=>   p_number_value2,
       p_char_value1                 	=>   p_char_value1,
       p_char_value2                 	=>   p_char_value2,
       p_date_value1                 	=>   p_date_value1,
       p_date_value2                 	=>   p_date_value2,
       p_excld_flag                     =>   p_excld_flag,
       p_business_group_id           	=>   p_business_group_id,
       p_edc_attribute_category      	=>   p_edc_attribute_category,
       p_edc_attribute1              	=>   p_edc_attribute1,
       p_edc_attribute2              	=>   p_edc_attribute2,
       p_edc_attribute3              	=>   p_edc_attribute3,
       p_edc_attribute4              	=>   p_edc_attribute4,
       p_edc_attribute5              	=>   p_edc_attribute5,
       p_edc_attribute6              	=>   p_edc_attribute6,
       p_edc_attribute7              	=>   p_edc_attribute7,
       p_edc_attribute8              	=>   p_edc_attribute8,
       p_edc_attribute9              	=>   p_edc_attribute9,
       p_edc_attribute10             	=>   p_edc_attribute10,
       p_edc_attribute11             	=>   p_edc_attribute11,
       p_edc_attribute12             	=>   p_edc_attribute12,
       p_edc_attribute13             	=>   p_edc_attribute13,
       p_edc_attribute14             	=>   p_edc_attribute14,
       p_edc_attribute15             	=>   p_edc_attribute15,
       p_edc_attribute16             	=>   p_edc_attribute16,
       p_edc_attribute17             	=>   p_edc_attribute17,
       p_edc_attribute18             	=>   p_edc_attribute18,
       p_edc_attribute19             	=>   p_edc_attribute19,
       p_edc_attribute20             	=>   p_edc_attribute20,
       p_edc_attribute21             	=>   p_edc_attribute21,
       p_edc_attribute22             	=>   p_edc_attribute22,
       p_edc_attribute23             	=>   p_edc_attribute23,
       p_edc_attribute24             	=>   p_edc_attribute24,
       p_edc_attribute25             	=>   p_edc_attribute25,
       p_edc_attribute26             	=>   p_edc_attribute26,
       p_edc_attribute27             	=>   p_edc_attribute27,
       p_edc_attribute28             	=>   p_edc_attribute28,
       p_edc_attribute29             	=>   p_edc_attribute29,
       p_edc_attribute30             	=>   p_edc_attribute30,
       p_object_version_number       	=>   l_object_version_number,
       p_effective_date              	=>   trunc(p_effective_date),
       p_datetrack_mode                 =>   p_datetrack_mode,
       p_char_value3                    =>   p_char_value3,
       p_char_value4                  	=>   p_char_value4,
       p_number_value3                	=>   p_number_value3,
       p_number_value4                	=>   p_number_value4,
       p_date_value3                  	=>   p_date_value3,
       p_date_value4                  	=>   p_date_value4
       );

Line: 630


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

Line: 661


    ROLLBACK TO dpnt_update_eligy_crit_values;

Line: 673


    ROLLBACK TO dpnt_update_eligy_crit_values;

Line: 681


end update_dpnt_eligy_crit_val;

Line: 686


procedure delete_dpnt_eligy_crit_val
(
   p_validate                       In Boolean        default false
  ,p_dpnt_eligy_crit_values_id           In Number
  ,p_effective_start_date           Out nocopy date
  ,p_effective_end_date             Out nocopy date
  ,p_object_version_number          In Out nocopy number
  ,p_effective_date                 In Date
  ,p_datetrack_mode                 In Varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'delete_eligy_crit_values';

Line: 710


  savepoint dpnt_delete_eligy_crit_values;

Line: 723


    ben_dpnt_elig_crit_val_bk3.delete_dpnt_eligy_crit_val_b
       (
        p_dpnt_eligy_crit_values_id              =>  p_dpnt_eligy_crit_values_id
       ,p_object_version_number             =>  p_object_version_number
       ,p_effective_date                    =>  trunc(p_effective_date)
       ,p_datetrack_mode                    =>  p_datetrack_mode
       );

Line: 733


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

Line: 755


    ben_dpnt_elig_crit_val_bk3.delete_dpnt_eligy_crit_val_a
      (
       p_dpnt_eligy_crit_values_id           =>  p_dpnt_eligy_crit_values_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      ,p_datetrack_mode                 => p_datetrack_mode
      );

Line: 767


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

Line: 776


    (p_event                       => 'DELETE',
     p_base_table                  => 'ben_dpnt_cvg_eligy_prfl_f',
     p_base_table_column           => 'dpnt_cvg_eligy_prfl_id',
     p_base_table_column_value     => ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id,
     p_base_table_reference_column => 'DPNT_CRIT_FLAG',
     p_reference_table             => 'ben_dpnt_eligy_crit_values_f',
     p_reference_table_column      => 'dpnt_cvg_eligy_prfl_id');

Line: 801


    ROLLBACK TO dpnt_delete_eligy_crit_values;

Line: 814


    ROLLBACK TO dpnt_delete_eligy_crit_values;

Line: 823


end delete_dpnt_eligy_crit_val;