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

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

Line: 284


procedure update_Reporting_Group
  (p_validate                       in  boolean   default false
  ,p_rptg_grp_id                    in  number
  ,p_name                           in  varchar2  default hr_api.g_varchar2
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_rptg_prps_cd                   in  varchar2  default hr_api.g_varchar2
  ,p_rpg_desc                       in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_bnr_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_function_code                  in  varchar2  default hr_api.g_varchar2
  ,p_legislation_code               in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_ordr_num                       in  number    default hr_api.g_number           --iRec
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_Reporting_Group';

Line: 340


  savepoint update_Reporting_Group;

Line: 352


    ben_Reporting_Group_bk2.update_Reporting_Group_b
      (
       p_rptg_grp_id                    =>  p_rptg_grp_id
      ,p_name                           =>  p_name
      ,p_business_group_id              =>  p_business_group_id
      ,p_rptg_prps_cd                   =>  p_rptg_prps_cd
      ,p_rpg_desc                       =>  p_rpg_desc
      ,p_bnr_attribute_category         =>  p_bnr_attribute_category
      ,p_bnr_attribute1                 =>  p_bnr_attribute1
      ,p_bnr_attribute2                 =>  p_bnr_attribute2
      ,p_bnr_attribute3                 =>  p_bnr_attribute3
      ,p_bnr_attribute4                 =>  p_bnr_attribute4
      ,p_bnr_attribute5                 =>  p_bnr_attribute5
      ,p_bnr_attribute6                 =>  p_bnr_attribute6
      ,p_bnr_attribute7                 =>  p_bnr_attribute7
      ,p_bnr_attribute8                 =>  p_bnr_attribute8
      ,p_bnr_attribute9                 =>  p_bnr_attribute9
      ,p_bnr_attribute10                =>  p_bnr_attribute10
      ,p_bnr_attribute11                =>  p_bnr_attribute11
      ,p_bnr_attribute12                =>  p_bnr_attribute12
      ,p_bnr_attribute13                =>  p_bnr_attribute13
      ,p_bnr_attribute14                =>  p_bnr_attribute14
      ,p_bnr_attribute15                =>  p_bnr_attribute15
      ,p_bnr_attribute16                =>  p_bnr_attribute16
      ,p_bnr_attribute17                =>  p_bnr_attribute17
      ,p_bnr_attribute18                =>  p_bnr_attribute18
      ,p_bnr_attribute19                =>  p_bnr_attribute19
      ,p_bnr_attribute20                =>  p_bnr_attribute20
      ,p_bnr_attribute21                =>  p_bnr_attribute21
      ,p_bnr_attribute22                =>  p_bnr_attribute22
      ,p_bnr_attribute23                =>  p_bnr_attribute23
      ,p_bnr_attribute24                =>  p_bnr_attribute24
      ,p_bnr_attribute25                =>  p_bnr_attribute25
      ,p_bnr_attribute26                =>  p_bnr_attribute26
      ,p_bnr_attribute27                =>  p_bnr_attribute27
      ,p_bnr_attribute28                =>  p_bnr_attribute28
      ,p_bnr_attribute29                =>  p_bnr_attribute29
      ,p_bnr_attribute30                =>  p_bnr_attribute30
      ,p_function_code                  =>  p_function_code
      ,p_legislation_code               =>  p_legislation_code
      ,p_object_version_number          =>  p_object_version_number
      ,p_ordr_num                       =>  p_ordr_num                    --iRec
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 399


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

Line: 456


    ben_Reporting_Group_bk2.update_Reporting_Group_a
      (
       p_rptg_grp_id                    =>  p_rptg_grp_id
      ,p_name                           =>  p_name
      ,p_business_group_id              =>  p_business_group_id
      ,p_rptg_prps_cd                   =>  p_rptg_prps_cd
      ,p_rpg_desc                       =>  p_rpg_desc
      ,p_bnr_attribute_category         =>  p_bnr_attribute_category
      ,p_bnr_attribute1                 =>  p_bnr_attribute1
      ,p_bnr_attribute2                 =>  p_bnr_attribute2
      ,p_bnr_attribute3                 =>  p_bnr_attribute3
      ,p_bnr_attribute4                 =>  p_bnr_attribute4
      ,p_bnr_attribute5                 =>  p_bnr_attribute5
      ,p_bnr_attribute6                 =>  p_bnr_attribute6
      ,p_bnr_attribute7                 =>  p_bnr_attribute7
      ,p_bnr_attribute8                 =>  p_bnr_attribute8
      ,p_bnr_attribute9                 =>  p_bnr_attribute9
      ,p_bnr_attribute10                =>  p_bnr_attribute10
      ,p_bnr_attribute11                =>  p_bnr_attribute11
      ,p_bnr_attribute12                =>  p_bnr_attribute12
      ,p_bnr_attribute13                =>  p_bnr_attribute13
      ,p_bnr_attribute14                =>  p_bnr_attribute14
      ,p_bnr_attribute15                =>  p_bnr_attribute15
      ,p_bnr_attribute16                =>  p_bnr_attribute16
      ,p_bnr_attribute17                =>  p_bnr_attribute17
      ,p_bnr_attribute18                =>  p_bnr_attribute18
      ,p_bnr_attribute19                =>  p_bnr_attribute19
      ,p_bnr_attribute20                =>  p_bnr_attribute20
      ,p_bnr_attribute21                =>  p_bnr_attribute21
      ,p_bnr_attribute22                =>  p_bnr_attribute22
      ,p_bnr_attribute23                =>  p_bnr_attribute23
      ,p_bnr_attribute24                =>  p_bnr_attribute24
      ,p_bnr_attribute25                =>  p_bnr_attribute25
      ,p_bnr_attribute26                =>  p_bnr_attribute26
      ,p_bnr_attribute27                =>  p_bnr_attribute27
      ,p_bnr_attribute28                =>  p_bnr_attribute28
      ,p_bnr_attribute29                =>  p_bnr_attribute29
      ,p_bnr_attribute30                =>  p_bnr_attribute30
      ,p_function_code                  =>  p_function_code
      ,p_legislation_code               =>  p_legislation_code
      ,p_object_version_number          =>  l_object_version_number
      ,p_ordr_num                       =>  p_ordr_num                        --iRec
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 503


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

Line: 532


    ROLLBACK TO update_Reporting_Group;

Line: 544


    ROLLBACK TO update_Reporting_Group;

Line: 547


end update_Reporting_Group;

Line: 552


procedure delete_Reporting_Group
  (p_validate                       in  boolean  default false
  ,p_rptg_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||'update_Reporting_Group';

Line: 570


  savepoint delete_Reporting_Group;

Line: 583


    ben_Reporting_Group_bk3.delete_Reporting_Group_b
      (
       p_rptg_grp_id                    =>  p_rptg_grp_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 592


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

Line: 611


    ben_Reporting_Group_bk3.delete_Reporting_Group_a
      (
       p_rptg_grp_id                    =>  p_rptg_grp_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 620


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

Line: 645


    ROLLBACK TO delete_Reporting_Group;

Line: 656


    ROLLBACK TO delete_Reporting_Group;

Line: 659


end delete_Reporting_Group;