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

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

Line: 287


procedure update_cwb_wksht_grp
  (
   p_validate                       in boolean      default false
  ,p_business_group_id              in number
  ,p_cwb_wksht_grp_id               in number
  ,p_pl_id                          in number       default hr_api.g_number
  ,p_ordr_num                       in number       default hr_api.g_number
  ,p_wksht_grp_cd                   in varchar2     default hr_api.g_varchar2
  ,p_label                          in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute_category         in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute1                 in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute2                 in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute3                 in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute4                 in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute5                 in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute6                 in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute7                 in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute8                 in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute9                 in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute10                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute11                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute12                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute13                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute14                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute15                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute16                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute17                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute18                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute19                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute20                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute21                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute22                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute23                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute24                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute25                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute26                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute27                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute28                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute29                in varchar2     default hr_api.g_varchar2
  ,p_cwg_attribute30                in varchar2     default hr_api.g_varchar2
  ,p_status_cd                      in varchar2     default hr_api.g_varchar2
  ,p_hidden_cd                    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_cwb_wksht_grp_id number;

Line: 336


  l_proc varchar2(72) := g_package||'update_cwb_wksht_grp';

Line: 345


  savepoint update_cwb_wksht_grp;

Line: 358


    ben_cwb_wksht_grp_bk2.update_cwb_wksht_grp_b
      (
        p_cwb_wksht_grp_id         => p_cwb_wksht_grp_id
       ,p_business_group_id        =>  p_business_group_id
       ,p_pl_id                    => p_pl_id
       ,p_ordr_num                 => p_ordr_num
       ,p_wksht_grp_cd             => p_wksht_grp_cd
       ,p_label                    => p_label
       ,p_cwg_attribute_category   => p_cwg_attribute_category
       ,p_cwg_attribute1           => p_cwg_attribute1
       ,p_cwg_attribute2           => p_cwg_attribute2
       ,p_cwg_attribute3           => p_cwg_attribute3
       ,p_cwg_attribute4           => p_cwg_attribute4
       ,p_cwg_attribute5           => p_cwg_attribute5
       ,p_cwg_attribute6           => p_cwg_attribute6
       ,p_cwg_attribute7           => p_cwg_attribute7
       ,p_cwg_attribute8           => p_cwg_attribute8
       ,p_cwg_attribute9           => p_cwg_attribute9
       ,p_cwg_attribute10          => p_cwg_attribute10
       ,p_cwg_attribute11          => p_cwg_attribute11
       ,p_cwg_attribute12          => p_cwg_attribute12
       ,p_cwg_attribute13          => p_cwg_attribute13
       ,p_cwg_attribute14          => p_cwg_attribute14
       ,p_cwg_attribute15          => p_cwg_attribute15
       ,p_cwg_attribute16          => p_cwg_attribute16
       ,p_cwg_attribute17          => p_cwg_attribute17
       ,p_cwg_attribute18          => p_cwg_attribute18
       ,p_cwg_attribute19          => p_cwg_attribute19
       ,p_cwg_attribute20          => p_cwg_attribute20
       ,p_cwg_attribute21          => p_cwg_attribute21
       ,p_cwg_attribute22          => p_cwg_attribute22
       ,p_cwg_attribute23          => p_cwg_attribute23
       ,p_cwg_attribute24          => p_cwg_attribute24
       ,p_cwg_attribute25          => p_cwg_attribute25
       ,p_cwg_attribute26          => p_cwg_attribute26
       ,p_cwg_attribute27          => p_cwg_attribute27
       ,p_cwg_attribute28          => p_cwg_attribute28
       ,p_cwg_attribute29          => p_cwg_attribute29
       ,p_cwg_attribute30          => p_cwg_attribute30
       ,p_status_cd                  => p_status_cd
       ,p_hidden_cd                 => p_hidden_cd
       ,p_object_version_number    => p_object_version_number
       ,p_effective_date           => p_effective_date
      );

Line: 405


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

Line: 460


    ben_cwb_wksht_grp_bk2.update_cwb_wksht_grp_a
      (
        p_cwb_wksht_grp_id         => p_cwb_wksht_grp_id
       ,p_business_group_id        => p_business_group_id
       ,p_pl_id                    => p_pl_id
       ,p_ordr_num                 => p_ordr_num
       ,p_wksht_grp_cd             => p_wksht_grp_cd
       ,p_label                    => p_label
       ,p_cwg_attribute_category   => p_cwg_attribute_category
       ,p_cwg_attribute1           => p_cwg_attribute1
       ,p_cwg_attribute2           => p_cwg_attribute2
       ,p_cwg_attribute3           => p_cwg_attribute3
       ,p_cwg_attribute4           => p_cwg_attribute4
       ,p_cwg_attribute5           => p_cwg_attribute5
       ,p_cwg_attribute6           => p_cwg_attribute6
       ,p_cwg_attribute7           => p_cwg_attribute7
       ,p_cwg_attribute8           => p_cwg_attribute8
       ,p_cwg_attribute9           => p_cwg_attribute9
       ,p_cwg_attribute10          => p_cwg_attribute10
       ,p_cwg_attribute11          => p_cwg_attribute11
       ,p_cwg_attribute12          => p_cwg_attribute12
       ,p_cwg_attribute13          => p_cwg_attribute13
       ,p_cwg_attribute14          => p_cwg_attribute14
       ,p_cwg_attribute15          => p_cwg_attribute15
       ,p_cwg_attribute16          => p_cwg_attribute16
       ,p_cwg_attribute17          => p_cwg_attribute17
       ,p_cwg_attribute18          => p_cwg_attribute18
       ,p_cwg_attribute19          => p_cwg_attribute19
       ,p_cwg_attribute20          => p_cwg_attribute20
       ,p_cwg_attribute21          => p_cwg_attribute21
       ,p_cwg_attribute22          => p_cwg_attribute22
       ,p_cwg_attribute23          => p_cwg_attribute23
       ,p_cwg_attribute24          => p_cwg_attribute24
       ,p_cwg_attribute25          => p_cwg_attribute25
       ,p_cwg_attribute26          => p_cwg_attribute26
       ,p_cwg_attribute27          => p_cwg_attribute27
       ,p_cwg_attribute28          => p_cwg_attribute28
       ,p_cwg_attribute29          => p_cwg_attribute29
       ,p_cwg_attribute30          => p_cwg_attribute30
       ,p_status_cd                => p_status_cd
       ,p_hidden_cd                => p_hidden_cd
       ,p_object_version_number    => p_object_version_number
       ,p_effective_date           => p_effective_date
      );

Line: 507


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

Line: 536


    ROLLBACK TO update_cwb_wksht_grp;

Line: 548


    ROLLBACK TO update_cwb_wksht_grp;

Line: 552


end update_cwb_wksht_grp;

Line: 557


procedure delete_cwb_wksht_grp
  (p_validate                       in  boolean  default false
  ,p_cwb_wksht_grp_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||'delete_cwb_wksht_grp';

Line: 575


  savepoint delete_cwb_wksht_grp;

Line: 588


    ben_cwb_wksht_grp_bk3.delete_cwb_wksht_grp_b
      (
       p_cwb_wksht_grp_id                =>  p_cwb_wksht_grp_id
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 596


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

Line: 614


    ben_cwb_wksht_grp_bk3.delete_cwb_wksht_grp_a
      (
       p_cwb_wksht_grp_id                =>  p_cwb_wksht_grp_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 622


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

Line: 647


    ROLLBACK TO delete_cwb_wksht_grp;

Line: 658


    ROLLBACK TO delete_cwb_wksht_grp;

Line: 662


end delete_cwb_wksht_grp;