APPS.BEN_ELIGY_CRIT_VALUES_API SQL Statements

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

Line: 363

procedure update_eligy_crit_values
  (
   p_validate                     In  Boolean      default false
  ,p_eligy_crit_values_id         In  Number
  ,p_eligy_prfl_id                In  Number       default hr_api.g_number
  ,p_eligy_criteria_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_ecv_attribute_category       In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute1               In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute2               In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute3               In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute4               In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute5               In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute6               In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute7               In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute8               In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute9               In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute10              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute11              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute12              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute13              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute14              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute15              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute16              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute17              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute18              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute19              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute20              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute21              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute22              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute23              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute24              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute25              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute26              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute27              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute28              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_attribute29              In  Varchar2     default hr_api.g_varchar2
  ,p_ecv_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_criteria_score               In  Number       default hr_api.g_number
  ,p_criteria_weight              In  Number       default hr_api.g_number
  ,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: 437

  savepoint update_eligy_crit_values;

Line: 449

    ben_eligy_crit_values_bk2.update_eligy_crit_values_b
       (
       p_eligy_crit_values_id        	=>   p_eligy_crit_values_id,
       p_eligy_prfl_id               	=>   p_eligy_prfl_id,
       p_eligy_criteria_id           	=>   p_eligy_criteria_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_ecv_attribute_category      	=>   p_ecv_attribute_category,
       p_ecv_attribute1              	=>   p_ecv_attribute1,
       p_ecv_attribute2              	=>   p_ecv_attribute2,
       p_ecv_attribute3              	=>   p_ecv_attribute3,
       p_ecv_attribute4              	=>   p_ecv_attribute4,
       p_ecv_attribute5              	=>   p_ecv_attribute5,
       p_ecv_attribute6              	=>   p_ecv_attribute6,
       p_ecv_attribute7              	=>   p_ecv_attribute7,
       p_ecv_attribute8              	=>   p_ecv_attribute8,
       p_ecv_attribute9              	=>   p_ecv_attribute9,
       p_ecv_attribute10             	=>   p_ecv_attribute10,
       p_ecv_attribute11             	=>   p_ecv_attribute11,
       p_ecv_attribute12             	=>   p_ecv_attribute12,
       p_ecv_attribute13             	=>   p_ecv_attribute13,
       p_ecv_attribute14             	=>   p_ecv_attribute14,
       p_ecv_attribute15             	=>   p_ecv_attribute15,
       p_ecv_attribute16             	=>   p_ecv_attribute16,
       p_ecv_attribute17             	=>   p_ecv_attribute17,
       p_ecv_attribute18             	=>   p_ecv_attribute18,
       p_ecv_attribute19             	=>   p_ecv_attribute19,
       p_ecv_attribute20             	=>   p_ecv_attribute20,
       p_ecv_attribute21             	=>   p_ecv_attribute21,
       p_ecv_attribute22             	=>   p_ecv_attribute22,
       p_ecv_attribute23             	=>   p_ecv_attribute23,
       p_ecv_attribute24             	=>   p_ecv_attribute24,
       p_ecv_attribute25             	=>   p_ecv_attribute25,
       p_ecv_attribute26             	=>   p_ecv_attribute26,
       p_ecv_attribute27             	=>   p_ecv_attribute27,
       p_ecv_attribute28             	=>   p_ecv_attribute28,
       p_ecv_attribute29             	=>   p_ecv_attribute29,
       p_ecv_attribute30             	=>   p_ecv_attribute30,
       p_object_version_number       	=>   p_object_version_number,
       p_effective_date              	=>   trunc(p_effective_date),
       p_datetrack_mode                 =>   p_datetrack_mode,
       p_criteria_score                 =>   p_criteria_score,
       p_criteria_weight                =>   p_criteria_weight,
       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: 509

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

Line: 583

    ben_eligy_crit_values_bk2.update_eligy_crit_values_a
      (
       p_eligy_crit_values_id       	=>   p_eligy_crit_values_id,
       p_eligy_prfl_id              	=>   p_eligy_prfl_id,
       p_eligy_criteria_id           	=>   p_eligy_criteria_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_ecv_attribute_category      	=>   p_ecv_attribute_category,
       p_ecv_attribute1              	=>   p_ecv_attribute1,
       p_ecv_attribute2              	=>   p_ecv_attribute2,
       p_ecv_attribute3              	=>   p_ecv_attribute3,
       p_ecv_attribute4              	=>   p_ecv_attribute4,
       p_ecv_attribute5              	=>   p_ecv_attribute5,
       p_ecv_attribute6              	=>   p_ecv_attribute6,
       p_ecv_attribute7              	=>   p_ecv_attribute7,
       p_ecv_attribute8              	=>   p_ecv_attribute8,
       p_ecv_attribute9              	=>   p_ecv_attribute9,
       p_ecv_attribute10             	=>   p_ecv_attribute10,
       p_ecv_attribute11             	=>   p_ecv_attribute11,
       p_ecv_attribute12             	=>   p_ecv_attribute12,
       p_ecv_attribute13             	=>   p_ecv_attribute13,
       p_ecv_attribute14             	=>   p_ecv_attribute14,
       p_ecv_attribute15             	=>   p_ecv_attribute15,
       p_ecv_attribute16             	=>   p_ecv_attribute16,
       p_ecv_attribute17             	=>   p_ecv_attribute17,
       p_ecv_attribute18             	=>   p_ecv_attribute18,
       p_ecv_attribute19             	=>   p_ecv_attribute19,
       p_ecv_attribute20             	=>   p_ecv_attribute20,
       p_ecv_attribute21             	=>   p_ecv_attribute21,
       p_ecv_attribute22             	=>   p_ecv_attribute22,
       p_ecv_attribute23             	=>   p_ecv_attribute23,
       p_ecv_attribute24             	=>   p_ecv_attribute24,
       p_ecv_attribute25             	=>   p_ecv_attribute25,
       p_ecv_attribute26             	=>   p_ecv_attribute26,
       p_ecv_attribute27             	=>   p_ecv_attribute27,
       p_ecv_attribute28             	=>   p_ecv_attribute28,
       p_ecv_attribute29             	=>   p_ecv_attribute29,
       p_ecv_attribute30             	=>   p_ecv_attribute30,
       p_object_version_number       	=>   l_object_version_number,
       p_effective_date              	=>   trunc(p_effective_date),
       p_datetrack_mode                 =>   p_datetrack_mode,
       p_criteria_score                 =>   p_criteria_score,
       p_criteria_weight                =>   p_criteria_weight,
       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: 646

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

Line: 677

    ROLLBACK TO update_eligy_crit_values;

Line: 689

    ROLLBACK TO update_eligy_crit_values;

Line: 697

end update_eligy_crit_values;

Line: 702

procedure delete_eligy_crit_values
(
   p_validate                       In Boolean        default false
  ,p_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: 726

  savepoint delete_eligy_crit_values;

Line: 739

    ben_eligy_crit_values_bk3.delete_eligy_crit_values_b
       (
        p_eligy_crit_values_id              =>  p_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: 749

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

Line: 771

    ben_eligy_crit_values_bk3.delete_eligy_crit_values_a
      (
       p_eligy_crit_values_id           =>  p_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: 783

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

Line: 792

    (p_event                       => 'DELETE',
     p_base_table                  => 'BEN_ELIGY_PRFL_F',
     p_base_table_column           => 'ELIGY_PRFL_ID',
     p_base_table_column_value     => ben_ecv_shd.g_old_rec.eligy_prfl_id,
     p_base_table_reference_column => 'ELIG_CRIT_VALUES_FLAG',
     p_reference_table             => 'BEN_ELIGY_CRIT_VALUES_F',
     p_reference_table_column      => 'ELIGY_PRFL_ID');

Line: 817

    ROLLBACK TO delete_eligy_crit_values;

Line: 830

    ROLLBACK TO delete_eligy_crit_values;

Line: 839

end delete_eligy_crit_values;