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

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

Line: 297


procedure update_reimbmt_ctfn_prvdd
  (p_validate                       in  boolean   default false
  ,p_prtt_rmt_rqst_ctfn_prvdd_id    in  number
  ,p_prtt_clm_gd_or_svc_typ_id      in  number    default hr_api.g_number
  ,p_pl_gd_r_svc_ctfn_id            in  number    default hr_api.g_number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_reimbmt_ctfn_rqd_flag          in  varchar2  default hr_api.g_varchar2
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_prtt_enrt_actn_id              in  number    default hr_api.g_number
  ,p_reimbmt_ctfn_recd_dt           in  date      default hr_api.g_date
  ,p_reimbmt_ctfn_dnd_dt            in  date      default hr_api.g_date
  ,p_reimbmt_ctfn_typ_cd            in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_pqc_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
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_reimbmt_ctfn_prvdd';

Line: 359


  savepoint update_reimbmt_ctfn_prvdd;

Line: 371


    ben_reimbmt_ctfn_prvdd_bk2.update_reimbmt_ctfn_prvdd_b
      (
       p_prtt_rmt_rqst_ctfn_prvdd_id    =>  p_prtt_rmt_rqst_ctfn_prvdd_id
      ,p_prtt_clm_gd_or_svc_typ_id      =>  p_prtt_clm_gd_or_svc_typ_id
      ,p_pl_gd_r_svc_ctfn_id            =>  p_pl_gd_r_svc_ctfn_id
      ,p_reimbmt_ctfn_rqd_flag          =>  p_reimbmt_ctfn_rqd_flag
      ,p_business_group_id              =>  p_business_group_id
      ,p_prtt_enrt_actn_id              =>  p_prtt_enrt_actn_id
      ,p_reimbmt_ctfn_recd_dt           =>  p_reimbmt_ctfn_recd_dt
      ,p_reimbmt_ctfn_dnd_dt            =>  p_reimbmt_ctfn_dnd_dt
      ,p_reimbmt_ctfn_typ_cd            =>  p_reimbmt_ctfn_typ_cd
      ,p_pqc_attribute_category         =>  p_pqc_attribute_category
      ,p_pqc_attribute1                 =>  p_pqc_attribute1
      ,p_pqc_attribute2                 =>  p_pqc_attribute2
      ,p_pqc_attribute3                 =>  p_pqc_attribute3
      ,p_pqc_attribute4                 =>  p_pqc_attribute4
      ,p_pqc_attribute5                 =>  p_pqc_attribute5
      ,p_pqc_attribute6                 =>  p_pqc_attribute6
      ,p_pqc_attribute7                 =>  p_pqc_attribute7
      ,p_pqc_attribute8                 =>  p_pqc_attribute8
      ,p_pqc_attribute9                 =>  p_pqc_attribute9
      ,p_pqc_attribute10                =>  p_pqc_attribute10
      ,p_pqc_attribute11                =>  p_pqc_attribute11
      ,p_pqc_attribute12                =>  p_pqc_attribute12
      ,p_pqc_attribute13                =>  p_pqc_attribute13
      ,p_pqc_attribute14                =>  p_pqc_attribute14
      ,p_pqc_attribute15                =>  p_pqc_attribute15
      ,p_pqc_attribute16                =>  p_pqc_attribute16
      ,p_pqc_attribute17                =>  p_pqc_attribute17
      ,p_pqc_attribute18                =>  p_pqc_attribute18
      ,p_pqc_attribute19                =>  p_pqc_attribute19
      ,p_pqc_attribute20                =>  p_pqc_attribute20
      ,p_pqc_attribute21                =>  p_pqc_attribute21
      ,p_pqc_attribute22                =>  p_pqc_attribute22
      ,p_pqc_attribute23                =>  p_pqc_attribute23
      ,p_pqc_attribute24                =>  p_pqc_attribute24
      ,p_pqc_attribute25                =>  p_pqc_attribute25
      ,p_pqc_attribute26                =>  p_pqc_attribute26
      ,p_pqc_attribute27                =>  p_pqc_attribute27
      ,p_pqc_attribute28                =>  p_pqc_attribute28
      ,p_pqc_attribute29                =>  p_pqc_attribute29
      ,p_pqc_attribute30                =>  p_pqc_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 420


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

Line: 481


    ben_reimbmt_ctfn_prvdd_bk2.update_reimbmt_ctfn_prvdd_a
      (
       p_prtt_rmt_rqst_ctfn_prvdd_id    =>  p_prtt_rmt_rqst_ctfn_prvdd_id
      ,p_prtt_clm_gd_or_svc_typ_id      =>  p_prtt_clm_gd_or_svc_typ_id
      ,p_pl_gd_r_svc_ctfn_id            =>  p_pl_gd_r_svc_ctfn_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_reimbmt_ctfn_rqd_flag          =>  p_reimbmt_ctfn_rqd_flag
      ,p_business_group_id              =>  p_business_group_id
      ,p_prtt_enrt_actn_id              =>  p_prtt_enrt_actn_id
      ,p_reimbmt_ctfn_recd_dt           =>  p_reimbmt_ctfn_recd_dt
      ,p_reimbmt_ctfn_dnd_dt            =>  p_reimbmt_ctfn_dnd_dt
      ,p_reimbmt_ctfn_typ_cd            =>  p_reimbmt_ctfn_typ_cd
      ,p_pqc_attribute_category         =>  p_pqc_attribute_category
      ,p_pqc_attribute1                 =>  p_pqc_attribute1
      ,p_pqc_attribute2                 =>  p_pqc_attribute2
      ,p_pqc_attribute3                 =>  p_pqc_attribute3
      ,p_pqc_attribute4                 =>  p_pqc_attribute4
      ,p_pqc_attribute5                 =>  p_pqc_attribute5
      ,p_pqc_attribute6                 =>  p_pqc_attribute6
      ,p_pqc_attribute7                 =>  p_pqc_attribute7
      ,p_pqc_attribute8                 =>  p_pqc_attribute8
      ,p_pqc_attribute9                 =>  p_pqc_attribute9
      ,p_pqc_attribute10                =>  p_pqc_attribute10
      ,p_pqc_attribute11                =>  p_pqc_attribute11
      ,p_pqc_attribute12                =>  p_pqc_attribute12
      ,p_pqc_attribute13                =>  p_pqc_attribute13
      ,p_pqc_attribute14                =>  p_pqc_attribute14
      ,p_pqc_attribute15                =>  p_pqc_attribute15
      ,p_pqc_attribute16                =>  p_pqc_attribute16
      ,p_pqc_attribute17                =>  p_pqc_attribute17
      ,p_pqc_attribute18                =>  p_pqc_attribute18
      ,p_pqc_attribute19                =>  p_pqc_attribute19
      ,p_pqc_attribute20                =>  p_pqc_attribute20
      ,p_pqc_attribute21                =>  p_pqc_attribute21
      ,p_pqc_attribute22                =>  p_pqc_attribute22
      ,p_pqc_attribute23                =>  p_pqc_attribute23
      ,p_pqc_attribute24                =>  p_pqc_attribute24
      ,p_pqc_attribute25                =>  p_pqc_attribute25
      ,p_pqc_attribute26                =>  p_pqc_attribute26
      ,p_pqc_attribute27                =>  p_pqc_attribute27
      ,p_pqc_attribute28                =>  p_pqc_attribute28
      ,p_pqc_attribute29                =>  p_pqc_attribute29
      ,p_pqc_attribute30                =>  p_pqc_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                     => trunc(p_effective_date)
      ,p_datetrack_mode                     => p_datetrack_mode
      );

Line: 532


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

Line: 563


    ROLLBACK TO update_reimbmt_ctfn_prvdd;

Line: 575


    ROLLBACK TO update_reimbmt_ctfn_prvdd;

Line: 578


end update_reimbmt_ctfn_prvdd;

Line: 583


procedure delete_reimbmt_ctfn_prvdd
  (p_validate                       in  boolean  default false
  ,p_prtt_rmt_rqst_ctfn_prvdd_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||'update_reimbmt_ctfn_prvdd';

Line: 606


  savepoint delete_reimbmt_ctfn_prvdd;

Line: 619


    ben_reimbmt_ctfn_prvdd_bk3.delete_reimbmt_ctfn_prvdd_b
      (
       p_prtt_rmt_rqst_ctfn_prvdd_id    =>  p_prtt_rmt_rqst_ctfn_prvdd_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 629


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

Line: 651


    ben_reimbmt_ctfn_prvdd_bk3.delete_reimbmt_ctfn_prvdd_a
      (
       p_prtt_rmt_rqst_ctfn_prvdd_id    =>  p_prtt_rmt_rqst_ctfn_prvdd_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: 663


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

Line: 688


    ROLLBACK TO delete_reimbmt_ctfn_prvdd;

Line: 701


    ROLLBACK TO delete_reimbmt_ctfn_prvdd;

Line: 704


end delete_reimbmt_ctfn_prvdd;