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

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

Line: 324


procedure update_comp_comm_types
  (p_validate                       in  boolean   default false
  ,p_cm_typ_id                      in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_name                           in  varchar2  default hr_api.g_varchar2
  ,p_desc_txt                       in  varchar2  default hr_api.g_varchar2
  ,p_cm_typ_rl                      in  number    default hr_api.g_number
  ,p_cm_usg_cd                      in  varchar2  default hr_api.g_varchar2
  ,p_whnvr_trgrd_flag               in  varchar2  default hr_api.g_varchar2
  ,p_shrt_name                      in  varchar2  default hr_api.g_varchar2
  ,p_pc_kit_cd                      in  varchar2  default hr_api.g_varchar2
  ,p_trk_mlg_flag                   in  varchar2  default hr_api.g_varchar2
  ,p_mx_num_avlbl_val               in  number    default hr_api.g_number
  ,p_to_be_sent_dt_cd               in  varchar2  default hr_api.g_varchar2
  ,p_to_be_sent_dt_rl               in  number    default hr_api.g_number
  ,p_inspn_rqd_flag                 in  varchar2  default hr_api.g_varchar2
  ,p_inspn_rqd_rl                   in  number    default hr_api.g_number
  ,p_rcpent_cd                      in  varchar2  default hr_api.g_varchar2
  ,p_parnt_cm_typ_id                in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_cct_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_cct_attribute9                 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_comp_comm_types';

Line: 393


  savepoint update_comp_comm_types;

Line: 405


    ben_comp_comm_types_bk2.update_comp_comm_types_b
      (p_cm_typ_id                      =>  p_cm_typ_id
      ,p_name                           =>  p_name
      ,p_desc_txt                       =>  p_desc_txt
      ,p_cm_typ_rl                      =>  p_cm_typ_rl
      ,p_cm_usg_cd                      =>  p_cm_usg_cd
      ,p_whnvr_trgrd_flag               =>  p_whnvr_trgrd_flag
      ,p_shrt_name                      =>  p_shrt_name
      ,p_pc_kit_cd                      =>  p_pc_kit_cd
      ,p_trk_mlg_flag                   =>  p_trk_mlg_flag
      ,p_mx_num_avlbl_val               =>  p_mx_num_avlbl_val
      ,p_to_be_sent_dt_cd               =>  p_to_be_sent_dt_cd
      ,p_to_be_sent_dt_rl               =>  p_to_be_sent_dt_rl
      ,p_inspn_rqd_flag                 =>  p_inspn_rqd_flag
      ,p_inspn_rqd_rl                   =>  p_inspn_rqd_rl
      ,p_rcpent_cd                      =>  p_rcpent_cd
      ,p_parnt_cm_typ_id                =>  p_parnt_cm_typ_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_cct_attribute_category         =>  p_cct_attribute_category
      ,p_cct_attribute1                 =>  p_cct_attribute1
      ,p_cct_attribute10                =>  p_cct_attribute10
      ,p_cct_attribute11                =>  p_cct_attribute11
      ,p_cct_attribute12                =>  p_cct_attribute12
      ,p_cct_attribute13                =>  p_cct_attribute13
      ,p_cct_attribute14                =>  p_cct_attribute14
      ,p_cct_attribute15                =>  p_cct_attribute15
      ,p_cct_attribute16                =>  p_cct_attribute16
      ,p_cct_attribute17                =>  p_cct_attribute17
      ,p_cct_attribute18                =>  p_cct_attribute18
      ,p_cct_attribute19                =>  p_cct_attribute19
      ,p_cct_attribute2                 =>  p_cct_attribute2
      ,p_cct_attribute20                =>  p_cct_attribute20
      ,p_cct_attribute21                =>  p_cct_attribute21
      ,p_cct_attribute22                =>  p_cct_attribute22
      ,p_cct_attribute23                =>  p_cct_attribute23
      ,p_cct_attribute24                =>  p_cct_attribute24
      ,p_cct_attribute25                =>  p_cct_attribute25
      ,p_cct_attribute26                =>  p_cct_attribute26
      ,p_cct_attribute27                =>  p_cct_attribute27
      ,p_cct_attribute28                =>  p_cct_attribute28
      ,p_cct_attribute29                =>  p_cct_attribute29
      ,p_cct_attribute3                 =>  p_cct_attribute3
      ,p_cct_attribute30                =>  p_cct_attribute30
      ,p_cct_attribute4                 =>  p_cct_attribute4
      ,p_cct_attribute5                 =>  p_cct_attribute5
      ,p_cct_attribute6                 =>  p_cct_attribute6
      ,p_cct_attribute7                 =>  p_cct_attribute7
      ,p_cct_attribute8                 =>  p_cct_attribute8
      ,p_cct_attribute9                 =>  p_cct_attribute9
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_datetrack_mode                 =>  p_datetrack_mode);

Line: 463


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

Line: 529


    ben_comp_comm_types_bk2.update_comp_comm_types_a
      (p_cm_typ_id                      =>  p_cm_typ_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_name                           =>  p_name
      ,p_desc_txt                       =>  p_desc_txt
      ,p_cm_typ_rl                      =>  p_cm_typ_rl
      ,p_cm_usg_cd                      =>  p_cm_usg_cd
      ,p_whnvr_trgrd_flag               =>  p_whnvr_trgrd_flag
      ,p_shrt_name                      =>  p_shrt_name
      ,p_pc_kit_cd                      =>  p_pc_kit_cd
      ,p_trk_mlg_flag                   =>  p_trk_mlg_flag
      ,p_mx_num_avlbl_val               =>  p_mx_num_avlbl_val
      ,p_to_be_sent_dt_cd               =>  p_to_be_sent_dt_cd
      ,p_to_be_sent_dt_rl               =>  p_to_be_sent_dt_rl
      ,p_inspn_rqd_flag                 =>  p_inspn_rqd_flag
      ,p_inspn_rqd_rl                   =>  p_inspn_rqd_rl
      ,p_rcpent_cd                      =>  p_rcpent_cd
      ,p_parnt_cm_typ_id                =>  p_parnt_cm_typ_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_cct_attribute_category         =>  p_cct_attribute_category
      ,p_cct_attribute1                 =>  p_cct_attribute1
      ,p_cct_attribute10                =>  p_cct_attribute10
      ,p_cct_attribute11                =>  p_cct_attribute11
      ,p_cct_attribute12                =>  p_cct_attribute12
      ,p_cct_attribute13                =>  p_cct_attribute13
      ,p_cct_attribute14                =>  p_cct_attribute14
      ,p_cct_attribute15                =>  p_cct_attribute15
      ,p_cct_attribute16                =>  p_cct_attribute16
      ,p_cct_attribute17                =>  p_cct_attribute17
      ,p_cct_attribute18                =>  p_cct_attribute18
      ,p_cct_attribute19                =>  p_cct_attribute19
      ,p_cct_attribute2                 =>  p_cct_attribute2
      ,p_cct_attribute20                =>  p_cct_attribute20
      ,p_cct_attribute21                =>  p_cct_attribute21
      ,p_cct_attribute22                =>  p_cct_attribute22
      ,p_cct_attribute23                =>  p_cct_attribute23
      ,p_cct_attribute24                =>  p_cct_attribute24
      ,p_cct_attribute25                =>  p_cct_attribute25
      ,p_cct_attribute26                =>  p_cct_attribute26
      ,p_cct_attribute27                =>  p_cct_attribute27
      ,p_cct_attribute28                =>  p_cct_attribute28
      ,p_cct_attribute29                =>  p_cct_attribute29
      ,p_cct_attribute3                 =>  p_cct_attribute3
      ,p_cct_attribute30                =>  p_cct_attribute30
      ,p_cct_attribute4                 =>  p_cct_attribute4
      ,p_cct_attribute5                 =>  p_cct_attribute5
      ,p_cct_attribute6                 =>  p_cct_attribute6
      ,p_cct_attribute7                 =>  p_cct_attribute7
      ,p_cct_attribute8                 =>  p_cct_attribute8
      ,p_cct_attribute9                 =>  p_cct_attribute9
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_datetrack_mode                 =>  p_datetrack_mode);

Line: 589


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

Line: 619


    ROLLBACK TO update_comp_comm_types;

Line: 631


    ROLLBACK TO update_comp_comm_types;

Line: 638


end update_comp_comm_types;

Line: 643


procedure delete_comp_comm_types
  (p_validate                       in  boolean  default false
  ,p_cm_typ_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_comp_comm_types';

Line: 665


  savepoint delete_comp_comm_types;

Line: 678


    ben_comp_comm_types_bk3.delete_comp_comm_types_b
      (p_cm_typ_id                      =>  p_cm_typ_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_datetrack_mode                 =>  p_datetrack_mode);

Line: 689


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

Line: 708


    ben_comp_comm_types_bk3.delete_comp_comm_types_a
      (p_cm_typ_id                      =>  p_cm_typ_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: 721


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

Line: 745


    ROLLBACK TO delete_comp_comm_types;

Line: 758


    ROLLBACK TO delete_comp_comm_types;

Line: 765


end delete_comp_comm_types;