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

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

Line: 279


procedure update_CBR_PER_IN_LER
  (p_validate                       in  boolean   default false
  ,p_cbr_per_in_ler_id              in  number
  ,p_init_evt_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_cnt_num                        in  number    default hr_api.g_number
  ,p_per_in_ler_id                  in  number    default hr_api.g_number
  ,p_cbr_quald_bnf_id               in  number    default hr_api.g_number
  ,p_prvs_elig_perd_end_dt          in  date      default hr_api.g_date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_crp_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_crp_attribute30                in  varchar2  default hr_api.g_varchar2
  ,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_CBR_PER_IN_LER';

Line: 334


  savepoint update_CBR_PER_IN_LER;

Line: 346


    ben_CBR_PER_IN_LER_bk2.update_CBR_PER_IN_LER_b
      (
       p_cbr_per_in_ler_id              =>  p_cbr_per_in_ler_id
      ,p_init_evt_flag                  =>  p_init_evt_flag
      ,p_cnt_num                        =>  p_cnt_num
      ,p_per_in_ler_id                  =>  p_per_in_ler_id
      ,p_cbr_quald_bnf_id               =>  p_cbr_quald_bnf_id
      ,p_prvs_elig_perd_end_dt          =>  p_prvs_elig_perd_end_dt
      ,p_business_group_id              =>  p_business_group_id
      ,p_crp_attribute_category         =>  p_crp_attribute_category
      ,p_crp_attribute1                 =>  p_crp_attribute1
      ,p_crp_attribute2                 =>  p_crp_attribute2
      ,p_crp_attribute3                 =>  p_crp_attribute3
      ,p_crp_attribute4                 =>  p_crp_attribute4
      ,p_crp_attribute5                 =>  p_crp_attribute5
      ,p_crp_attribute6                 =>  p_crp_attribute6
      ,p_crp_attribute7                 =>  p_crp_attribute7
      ,p_crp_attribute8                 =>  p_crp_attribute8
      ,p_crp_attribute9                 =>  p_crp_attribute9
      ,p_crp_attribute10                =>  p_crp_attribute10
      ,p_crp_attribute11                =>  p_crp_attribute11
      ,p_crp_attribute12                =>  p_crp_attribute12
      ,p_crp_attribute13                =>  p_crp_attribute13
      ,p_crp_attribute14                =>  p_crp_attribute14
      ,p_crp_attribute15                =>  p_crp_attribute15
      ,p_crp_attribute16                =>  p_crp_attribute16
      ,p_crp_attribute17                =>  p_crp_attribute17
      ,p_crp_attribute18                =>  p_crp_attribute18
      ,p_crp_attribute19                =>  p_crp_attribute19
      ,p_crp_attribute20                =>  p_crp_attribute20
      ,p_crp_attribute21                =>  p_crp_attribute21
      ,p_crp_attribute22                =>  p_crp_attribute22
      ,p_crp_attribute23                =>  p_crp_attribute23
      ,p_crp_attribute24                =>  p_crp_attribute24
      ,p_crp_attribute25                =>  p_crp_attribute25
      ,p_crp_attribute26                =>  p_crp_attribute26
      ,p_crp_attribute27                =>  p_crp_attribute27
      ,p_crp_attribute28                =>  p_crp_attribute28
      ,p_crp_attribute29                =>  p_crp_attribute29
      ,p_crp_attribute30                =>  p_crp_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 392


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

Line: 448


    ben_CBR_PER_IN_LER_bk2.update_CBR_PER_IN_LER_a
      (
       p_cbr_per_in_ler_id              =>  p_cbr_per_in_ler_id
      ,p_init_evt_flag                  =>  p_init_evt_flag
      ,p_cnt_num                        =>  p_cnt_num
      ,p_per_in_ler_id                  =>  p_per_in_ler_id
      ,p_cbr_quald_bnf_id               =>  p_cbr_quald_bnf_id
      ,p_prvs_elig_perd_end_dt          =>  p_prvs_elig_perd_end_dt
      ,p_business_group_id              =>  p_business_group_id
      ,p_crp_attribute_category         =>  p_crp_attribute_category
      ,p_crp_attribute1                 =>  p_crp_attribute1
      ,p_crp_attribute2                 =>  p_crp_attribute2
      ,p_crp_attribute3                 =>  p_crp_attribute3
      ,p_crp_attribute4                 =>  p_crp_attribute4
      ,p_crp_attribute5                 =>  p_crp_attribute5
      ,p_crp_attribute6                 =>  p_crp_attribute6
      ,p_crp_attribute7                 =>  p_crp_attribute7
      ,p_crp_attribute8                 =>  p_crp_attribute8
      ,p_crp_attribute9                 =>  p_crp_attribute9
      ,p_crp_attribute10                =>  p_crp_attribute10
      ,p_crp_attribute11                =>  p_crp_attribute11
      ,p_crp_attribute12                =>  p_crp_attribute12
      ,p_crp_attribute13                =>  p_crp_attribute13
      ,p_crp_attribute14                =>  p_crp_attribute14
      ,p_crp_attribute15                =>  p_crp_attribute15
      ,p_crp_attribute16                =>  p_crp_attribute16
      ,p_crp_attribute17                =>  p_crp_attribute17
      ,p_crp_attribute18                =>  p_crp_attribute18
      ,p_crp_attribute19                =>  p_crp_attribute19
      ,p_crp_attribute20                =>  p_crp_attribute20
      ,p_crp_attribute21                =>  p_crp_attribute21
      ,p_crp_attribute22                =>  p_crp_attribute22
      ,p_crp_attribute23                =>  p_crp_attribute23
      ,p_crp_attribute24                =>  p_crp_attribute24
      ,p_crp_attribute25                =>  p_crp_attribute25
      ,p_crp_attribute26                =>  p_crp_attribute26
      ,p_crp_attribute27                =>  p_crp_attribute27
      ,p_crp_attribute28                =>  p_crp_attribute28
      ,p_crp_attribute29                =>  p_crp_attribute29
      ,p_crp_attribute30                =>  p_crp_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 494


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

Line: 523


    ROLLBACK TO update_CBR_PER_IN_LER;

Line: 535


    ROLLBACK TO update_CBR_PER_IN_LER;

Line: 539


end update_CBR_PER_IN_LER;

Line: 544


procedure delete_CBR_PER_IN_LER
  (p_validate                       in  boolean  default false
  ,p_cbr_per_in_ler_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_CBR_PER_IN_LER';

Line: 562


  savepoint delete_CBR_PER_IN_LER;

Line: 575


    ben_CBR_PER_IN_LER_bk3.delete_CBR_PER_IN_LER_b
      (
       p_cbr_per_in_ler_id              =>  p_cbr_per_in_ler_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 584


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

Line: 603


    ben_CBR_PER_IN_LER_bk3.delete_CBR_PER_IN_LER_a
      (
       p_cbr_per_in_ler_id              =>  p_cbr_per_in_ler_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 612


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

Line: 637


    ROLLBACK TO delete_CBR_PER_IN_LER;

Line: 648


    ROLLBACK TO delete_CBR_PER_IN_LER;

Line: 652


end delete_CBR_PER_IN_LER;