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

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

Line: 280


procedure update_cmbn_age_los_fctr
  (p_validate                       in  boolean   default false
  ,p_cmbn_age_los_fctr_id           in  number
  ,p_name                           in  varchar2  default hr_api.g_varchar2
  ,p_los_fctr_id                    in  number    default hr_api.g_number
  ,p_age_fctr_id                    in  number    default hr_api.g_number
  ,p_cmbnd_min_val                  in  number    default hr_api.g_number
  ,p_cmbnd_max_val                  in  number    default hr_api.g_number
  ,p_ordr_num                       in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_cla_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_cla_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_cmbn_age_los_fctr';

Line: 336


  savepoint update_cmbn_age_los_fctr;

Line: 348


    ben_cmbn_age_los_fctr_bk2.update_cmbn_age_los_fctr_b
      (
       p_cmbn_age_los_fctr_id           =>  p_cmbn_age_los_fctr_id
      ,p_name                           =>  p_name
      ,p_los_fctr_id                    =>  p_los_fctr_id
      ,p_age_fctr_id                    =>  p_age_fctr_id
      ,p_cmbnd_min_val                  =>  p_cmbnd_min_val
      ,p_cmbnd_max_val                  =>  p_cmbnd_max_val
      ,p_ordr_num                       =>  p_ordr_num
      ,p_business_group_id              =>  p_business_group_id
      ,p_cla_attribute_category         =>  p_cla_attribute_category
      ,p_cla_attribute1                 =>  p_cla_attribute1
      ,p_cla_attribute2                 =>  p_cla_attribute2
      ,p_cla_attribute3                 =>  p_cla_attribute3
      ,p_cla_attribute4                 =>  p_cla_attribute4
      ,p_cla_attribute5                 =>  p_cla_attribute5
      ,p_cla_attribute6                 =>  p_cla_attribute6
      ,p_cla_attribute7                 =>  p_cla_attribute7
      ,p_cla_attribute8                 =>  p_cla_attribute8
      ,p_cla_attribute9                 =>  p_cla_attribute9
      ,p_cla_attribute10                =>  p_cla_attribute10
      ,p_cla_attribute11                =>  p_cla_attribute11
      ,p_cla_attribute12                =>  p_cla_attribute12
      ,p_cla_attribute13                =>  p_cla_attribute13
      ,p_cla_attribute14                =>  p_cla_attribute14
      ,p_cla_attribute15                =>  p_cla_attribute15
      ,p_cla_attribute16                =>  p_cla_attribute16
      ,p_cla_attribute17                =>  p_cla_attribute17
      ,p_cla_attribute18                =>  p_cla_attribute18
      ,p_cla_attribute19                =>  p_cla_attribute19
      ,p_cla_attribute20                =>  p_cla_attribute20
      ,p_cla_attribute21                =>  p_cla_attribute21
      ,p_cla_attribute22                =>  p_cla_attribute22
      ,p_cla_attribute23                =>  p_cla_attribute23
      ,p_cla_attribute24                =>  p_cla_attribute24
      ,p_cla_attribute25                =>  p_cla_attribute25
      ,p_cla_attribute26                =>  p_cla_attribute26
      ,p_cla_attribute27                =>  p_cla_attribute27
      ,p_cla_attribute28                =>  p_cla_attribute28
      ,p_cla_attribute29                =>  p_cla_attribute29
      ,p_cla_attribute30                =>  p_cla_attribute30
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 394


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

Line: 450


    ben_cmbn_age_los_fctr_bk2.update_cmbn_age_los_fctr_a
      (
       p_cmbn_age_los_fctr_id           =>  p_cmbn_age_los_fctr_id
      ,p_name                           =>  p_name
      ,p_los_fctr_id                    =>  p_los_fctr_id
      ,p_age_fctr_id                    =>  p_age_fctr_id
      ,p_cmbnd_min_val                  =>  p_cmbnd_min_val
      ,p_cmbnd_max_val                  =>  p_cmbnd_max_val
      ,p_ordr_num                       =>  p_ordr_num
      ,p_business_group_id              =>  p_business_group_id
      ,p_cla_attribute_category         =>  p_cla_attribute_category
      ,p_cla_attribute1                 =>  p_cla_attribute1
      ,p_cla_attribute2                 =>  p_cla_attribute2
      ,p_cla_attribute3                 =>  p_cla_attribute3
      ,p_cla_attribute4                 =>  p_cla_attribute4
      ,p_cla_attribute5                 =>  p_cla_attribute5
      ,p_cla_attribute6                 =>  p_cla_attribute6
      ,p_cla_attribute7                 =>  p_cla_attribute7
      ,p_cla_attribute8                 =>  p_cla_attribute8
      ,p_cla_attribute9                 =>  p_cla_attribute9
      ,p_cla_attribute10                =>  p_cla_attribute10
      ,p_cla_attribute11                =>  p_cla_attribute11
      ,p_cla_attribute12                =>  p_cla_attribute12
      ,p_cla_attribute13                =>  p_cla_attribute13
      ,p_cla_attribute14                =>  p_cla_attribute14
      ,p_cla_attribute15                =>  p_cla_attribute15
      ,p_cla_attribute16                =>  p_cla_attribute16
      ,p_cla_attribute17                =>  p_cla_attribute17
      ,p_cla_attribute18                =>  p_cla_attribute18
      ,p_cla_attribute19                =>  p_cla_attribute19
      ,p_cla_attribute20                =>  p_cla_attribute20
      ,p_cla_attribute21                =>  p_cla_attribute21
      ,p_cla_attribute22                =>  p_cla_attribute22
      ,p_cla_attribute23                =>  p_cla_attribute23
      ,p_cla_attribute24                =>  p_cla_attribute24
      ,p_cla_attribute25                =>  p_cla_attribute25
      ,p_cla_attribute26                =>  p_cla_attribute26
      ,p_cla_attribute27                =>  p_cla_attribute27
      ,p_cla_attribute28                =>  p_cla_attribute28
      ,p_cla_attribute29                =>  p_cla_attribute29
      ,p_cla_attribute30                =>  p_cla_attribute30
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 496


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

Line: 525


    ROLLBACK TO update_cmbn_age_los_fctr;

Line: 538


    ROLLBACK TO update_cmbn_age_los_fctr;

Line: 541


end update_cmbn_age_los_fctr;

Line: 546


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

Line: 564


  savepoint delete_cmbn_age_los_fctr;

Line: 577


    ben_cmbn_age_los_fctr_bk3.delete_cmbn_age_los_fctr_b
      (
       p_cmbn_age_los_fctr_id           =>  p_cmbn_age_los_fctr_id
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 585


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

Line: 603


    ben_cmbn_age_los_fctr_bk3.delete_cmbn_age_los_fctr_a
      (
       p_cmbn_age_los_fctr_id           =>  p_cmbn_age_los_fctr_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 611


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

Line: 636


    ROLLBACK TO delete_cmbn_age_los_fctr;

Line: 648


    ROLLBACK TO delete_cmbn_age_los_fctr;

Line: 651


end delete_cmbn_age_los_fctr;