APPS.BEN_COMP_LEVEL_FACTORS_API SQL Statements

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

Line: 334

      /* Inserted for nocopy changes */
    p_object_version_number := l_object_version_number;

Line: 343

procedure update_comp_level_factors
  (p_validate                       in  boolean   default false
  ,p_comp_lvl_fctr_id               in  number
  ,p_name                           in  varchar2  default hr_api.g_varchar2
  ,p_comp_lvl_det_cd                in  varchar2  default hr_api.g_varchar2
  ,p_comp_lvl_det_rl                in  number    default hr_api.g_number
  ,p_comp_lvl_uom                   in  varchar2  default hr_api.g_varchar2
  ,p_comp_src_cd                    in  varchar2  default hr_api.g_varchar2
  ,p_no_mn_comp_flag                in  varchar2  default hr_api.g_varchar2
  ,p_no_mx_comp_flag                in  varchar2  default hr_api.g_varchar2
  ,p_mx_comp_val                    in  number    default hr_api.g_number
  ,p_mn_comp_val                    in  number    default hr_api.g_number
  ,p_rndg_cd                        in  varchar2  default hr_api.g_varchar2
  ,p_rndg_rl                        in  number    default hr_api.g_number
  ,p_defined_balance_id             in  number    default hr_api.g_number
  ,p_bnfts_bal_id                   in  number    default hr_api.g_number
  ,p_comp_alt_val_to_use_cd         in  varchar2  default hr_api.g_varchar2
  ,p_comp_calc_rl                   in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_proration_flag                 in  varchar2  default hr_api.g_varchar2
  ,p_start_day_mo                   in  varchar2  default hr_api.g_varchar2
  ,p_end_day_mo                     in  varchar2  default hr_api.g_varchar2
  ,p_start_year                     in  varchar2  default hr_api.g_varchar2
  ,p_end_year                       in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_clf_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_sttd_sal_prdcty_cd             in  varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_comp_level_factors';

Line: 415

  savepoint update_comp_level_factors;

Line: 427

    ben_comp_level_factors_bk2.update_comp_level_factors_b
      (
       p_comp_lvl_fctr_id               =>  p_comp_lvl_fctr_id
      ,p_name                           =>  p_name
      ,p_comp_lvl_det_cd                =>  p_comp_lvl_det_cd
      ,p_comp_lvl_det_rl                =>  p_comp_lvl_det_rl
      ,p_comp_lvl_uom                   =>  p_comp_lvl_uom
      ,p_comp_src_cd                    =>  p_comp_src_cd
      ,p_no_mn_comp_flag                =>  p_no_mn_comp_flag
      ,p_no_mx_comp_flag                =>  p_no_mx_comp_flag
      ,p_mx_comp_val                    =>  p_mx_comp_val
      ,p_mn_comp_val                    =>  p_mn_comp_val
      ,p_rndg_cd                        =>  p_rndg_cd
      ,p_rndg_rl                        =>  p_rndg_rl
      ,p_defined_balance_id             =>  p_defined_balance_id
      ,p_bnfts_bal_id                   =>  p_bnfts_bal_id
      ,p_comp_alt_val_to_use_cd         =>  p_comp_alt_val_to_use_cd
      ,p_comp_calc_rl                   =>  p_comp_calc_rl
      ,p_business_group_id              =>  p_business_group_id
      ,p_proration_flag                 =>  p_proration_flag
      ,p_start_day_mo                   =>  p_start_day_mo
      ,p_end_day_mo                     =>  p_end_day_mo
      ,p_start_year                     =>  p_start_year
      ,p_end_year                       =>  p_end_year
      ,p_clf_attribute_category         =>  p_clf_attribute_category
      ,p_clf_attribute1                 =>  p_clf_attribute1
      ,p_clf_attribute2                 =>  p_clf_attribute2
      ,p_clf_attribute3                 =>  p_clf_attribute3
      ,p_clf_attribute4                 =>  p_clf_attribute4
      ,p_clf_attribute5                 =>  p_clf_attribute5
      ,p_clf_attribute6                 =>  p_clf_attribute6
      ,p_clf_attribute7                 =>  p_clf_attribute7
      ,p_clf_attribute8                 =>  p_clf_attribute8
      ,p_clf_attribute9                 =>  p_clf_attribute9
      ,p_clf_attribute10                =>  p_clf_attribute10
      ,p_clf_attribute11                =>  p_clf_attribute11
      ,p_clf_attribute12                =>  p_clf_attribute12
      ,p_clf_attribute13                =>  p_clf_attribute13
      ,p_clf_attribute14                =>  p_clf_attribute14
      ,p_clf_attribute15                =>  p_clf_attribute15
      ,p_clf_attribute16                =>  p_clf_attribute16
      ,p_clf_attribute17                =>  p_clf_attribute17
      ,p_clf_attribute18                =>  p_clf_attribute18
      ,p_clf_attribute19                =>  p_clf_attribute19
      ,p_clf_attribute20                =>  p_clf_attribute20
      ,p_clf_attribute21                =>  p_clf_attribute21
      ,p_clf_attribute22                =>  p_clf_attribute22
      ,p_clf_attribute23                =>  p_clf_attribute23
      ,p_clf_attribute24                =>  p_clf_attribute24
      ,p_clf_attribute25                =>  p_clf_attribute25
      ,p_clf_attribute26                =>  p_clf_attribute26
      ,p_clf_attribute27                =>  p_clf_attribute27
      ,p_clf_attribute28                =>  p_clf_attribute28
      ,p_clf_attribute29                =>  p_clf_attribute29
      ,p_clf_attribute30                =>  p_clf_attribute30
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_sttd_sal_prdcty_cd             =>  p_sttd_sal_prdcty_cd
      );

Line: 489

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

Line: 561

    ben_comp_level_factors_bk2.update_comp_level_factors_a
      (
       p_comp_lvl_fctr_id               =>  p_comp_lvl_fctr_id
      ,p_name                           =>  p_name
      ,p_comp_lvl_det_cd                =>  p_comp_lvl_det_cd
      ,p_comp_lvl_det_rl                =>  p_comp_lvl_det_rl
      ,p_comp_lvl_uom                   =>  p_comp_lvl_uom
      ,p_comp_src_cd                    =>  p_comp_src_cd
      ,p_no_mn_comp_flag                =>  p_no_mn_comp_flag
      ,p_no_mx_comp_flag                =>  p_no_mx_comp_flag
      ,p_mx_comp_val                    =>  p_mx_comp_val
      ,p_mn_comp_val                    =>  p_mn_comp_val
      ,p_rndg_cd                        =>  p_rndg_cd
      ,p_rndg_rl                        =>  p_rndg_rl
      ,p_defined_balance_id             =>  p_defined_balance_id
      ,p_bnfts_bal_id                   =>  p_bnfts_bal_id
      ,p_comp_alt_val_to_use_cd         =>  p_comp_alt_val_to_use_cd
      ,p_comp_calc_rl                   =>  p_comp_calc_rl
      ,p_business_group_id              =>  p_business_group_id
      ,p_proration_flag                 =>  p_proration_flag
      ,p_start_day_mo                   =>  p_start_day_mo
      ,p_end_day_mo                     =>  p_end_day_mo
      ,p_start_year                     =>  p_start_year
      ,p_end_year                       =>  p_end_year
      ,p_clf_attribute_category         =>  p_clf_attribute_category
      ,p_clf_attribute1                 =>  p_clf_attribute1
      ,p_clf_attribute2                 =>  p_clf_attribute2
      ,p_clf_attribute3                 =>  p_clf_attribute3
      ,p_clf_attribute4                 =>  p_clf_attribute4
      ,p_clf_attribute5                 =>  p_clf_attribute5
      ,p_clf_attribute6                 =>  p_clf_attribute6
      ,p_clf_attribute7                 =>  p_clf_attribute7
      ,p_clf_attribute8                 =>  p_clf_attribute8
      ,p_clf_attribute9                 =>  p_clf_attribute9
      ,p_clf_attribute10                =>  p_clf_attribute10
      ,p_clf_attribute11                =>  p_clf_attribute11
      ,p_clf_attribute12                =>  p_clf_attribute12
      ,p_clf_attribute13                =>  p_clf_attribute13
      ,p_clf_attribute14                =>  p_clf_attribute14
      ,p_clf_attribute15                =>  p_clf_attribute15
      ,p_clf_attribute16                =>  p_clf_attribute16
      ,p_clf_attribute17                =>  p_clf_attribute17
      ,p_clf_attribute18                =>  p_clf_attribute18
      ,p_clf_attribute19                =>  p_clf_attribute19
      ,p_clf_attribute20                =>  p_clf_attribute20
      ,p_clf_attribute21                =>  p_clf_attribute21
      ,p_clf_attribute22                =>  p_clf_attribute22
      ,p_clf_attribute23                =>  p_clf_attribute23
      ,p_clf_attribute24                =>  p_clf_attribute24
      ,p_clf_attribute25                =>  p_clf_attribute25
      ,p_clf_attribute26                =>  p_clf_attribute26
      ,p_clf_attribute27                =>  p_clf_attribute27
      ,p_clf_attribute28                =>  p_clf_attribute28
      ,p_clf_attribute29                =>  p_clf_attribute29
      ,p_clf_attribute30                =>  p_clf_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_sttd_sal_prdcty_cd             =>  p_sttd_sal_prdcty_cd
      );

Line: 623

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

Line: 652

    ROLLBACK TO update_comp_level_factors;

Line: 665

    ROLLBACK TO update_comp_level_factors;

Line: 666

    /* Inserted for nocopy changes */
    raise;

Line: 669

end update_comp_level_factors;

Line: 674

procedure delete_comp_level_factors
  (p_validate                       in  boolean  default false
  ,p_comp_lvl_fctr_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||'update_comp_level_factors';

Line: 693

  savepoint delete_comp_level_factors;

Line: 706

    ben_comp_level_factors_bk3.delete_comp_level_factors_b
      (
       p_comp_lvl_fctr_id               =>  p_comp_lvl_fctr_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 715

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

Line: 734

    ben_comp_level_factors_bk3.delete_comp_level_factors_a
      (
       p_comp_lvl_fctr_id               =>  p_comp_lvl_fctr_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 743

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

Line: 768

    ROLLBACK TO delete_comp_level_factors;

Line: 780

    ROLLBACK TO delete_comp_level_factors;

Line: 783

end delete_comp_level_factors;