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

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

Line: 287


procedure update_pgm_or_pl_yr_perd
  (p_validate                       in  boolean   default false
  ,p_yr_perd_id                     in  number
  ,p_perds_in_yr_num                in  number    default hr_api.g_number
  ,p_perd_tm_uom_cd                 in  varchar2  default hr_api.g_varchar2
  ,p_perd_typ_cd                    in  varchar2  default hr_api.g_varchar2
  ,p_end_date                       in  date      default hr_api.g_date
  ,p_start_date                     in  date      default hr_api.g_date
  ,p_lmtn_yr_strt_dt                in  date      default hr_api.g_date
  ,p_lmtn_yr_end_dt                 in  date      default hr_api.g_date
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_yrp_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_yrp_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_pgm_or_pl_yr_perd';

Line: 344


  savepoint update_pgm_or_pl_yr_perd;

Line: 356


    ben_pgm_or_pl_yr_perd_bk2.update_pgm_or_pl_yr_perd_b
      (
       p_yr_perd_id                     =>  p_yr_perd_id
      ,p_perds_in_yr_num                =>  p_perds_in_yr_num
      ,p_perd_tm_uom_cd                 =>  p_perd_tm_uom_cd
      ,p_perd_typ_cd                    =>  p_perd_typ_cd
      ,p_end_date                       =>  p_end_date
      ,p_start_date                     =>  p_start_date
      ,p_lmtn_yr_strt_dt                =>  p_lmtn_yr_strt_dt
      ,p_lmtn_yr_end_dt                 =>  p_lmtn_yr_end_dt
      ,p_business_group_id              =>  p_business_group_id
      ,p_yrp_attribute_category         =>  p_yrp_attribute_category
      ,p_yrp_attribute1                 =>  p_yrp_attribute1
      ,p_yrp_attribute2                 =>  p_yrp_attribute2
      ,p_yrp_attribute3                 =>  p_yrp_attribute3
      ,p_yrp_attribute4                 =>  p_yrp_attribute4
      ,p_yrp_attribute5                 =>  p_yrp_attribute5
      ,p_yrp_attribute6                 =>  p_yrp_attribute6
      ,p_yrp_attribute7                 =>  p_yrp_attribute7
      ,p_yrp_attribute8                 =>  p_yrp_attribute8
      ,p_yrp_attribute9                 =>  p_yrp_attribute9
      ,p_yrp_attribute10                =>  p_yrp_attribute10
      ,p_yrp_attribute11                =>  p_yrp_attribute11
      ,p_yrp_attribute12                =>  p_yrp_attribute12
      ,p_yrp_attribute13                =>  p_yrp_attribute13
      ,p_yrp_attribute14                =>  p_yrp_attribute14
      ,p_yrp_attribute15                =>  p_yrp_attribute15
      ,p_yrp_attribute16                =>  p_yrp_attribute16
      ,p_yrp_attribute17                =>  p_yrp_attribute17
      ,p_yrp_attribute18                =>  p_yrp_attribute18
      ,p_yrp_attribute19                =>  p_yrp_attribute19
      ,p_yrp_attribute20                =>  p_yrp_attribute20
      ,p_yrp_attribute21                =>  p_yrp_attribute21
      ,p_yrp_attribute22                =>  p_yrp_attribute22
      ,p_yrp_attribute23                =>  p_yrp_attribute23
      ,p_yrp_attribute24                =>  p_yrp_attribute24
      ,p_yrp_attribute25                =>  p_yrp_attribute25
      ,p_yrp_attribute26                =>  p_yrp_attribute26
      ,p_yrp_attribute27                =>  p_yrp_attribute27
      ,p_yrp_attribute28                =>  p_yrp_attribute28
      ,p_yrp_attribute29                =>  p_yrp_attribute29
      ,p_yrp_attribute30                =>  p_yrp_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 404


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

Line: 462


    ben_pgm_or_pl_yr_perd_bk2.update_pgm_or_pl_yr_perd_a
      (
       p_yr_perd_id                     =>  p_yr_perd_id
      ,p_perds_in_yr_num                =>  p_perds_in_yr_num
      ,p_perd_tm_uom_cd                 =>  p_perd_tm_uom_cd
      ,p_perd_typ_cd                    =>  p_perd_typ_cd
      ,p_end_date                       =>  p_end_date
      ,p_start_date                     =>  p_start_date
      ,p_lmtn_yr_strt_dt                =>  p_lmtn_yr_strt_dt
      ,p_lmtn_yr_end_dt                 =>  p_lmtn_yr_end_dt
      ,p_business_group_id              =>  p_business_group_id
      ,p_yrp_attribute_category         =>  p_yrp_attribute_category
      ,p_yrp_attribute1                 =>  p_yrp_attribute1
      ,p_yrp_attribute2                 =>  p_yrp_attribute2
      ,p_yrp_attribute3                 =>  p_yrp_attribute3
      ,p_yrp_attribute4                 =>  p_yrp_attribute4
      ,p_yrp_attribute5                 =>  p_yrp_attribute5
      ,p_yrp_attribute6                 =>  p_yrp_attribute6
      ,p_yrp_attribute7                 =>  p_yrp_attribute7
      ,p_yrp_attribute8                 =>  p_yrp_attribute8
      ,p_yrp_attribute9                 =>  p_yrp_attribute9
      ,p_yrp_attribute10                =>  p_yrp_attribute10
      ,p_yrp_attribute11                =>  p_yrp_attribute11
      ,p_yrp_attribute12                =>  p_yrp_attribute12
      ,p_yrp_attribute13                =>  p_yrp_attribute13
      ,p_yrp_attribute14                =>  p_yrp_attribute14
      ,p_yrp_attribute15                =>  p_yrp_attribute15
      ,p_yrp_attribute16                =>  p_yrp_attribute16
      ,p_yrp_attribute17                =>  p_yrp_attribute17
      ,p_yrp_attribute18                =>  p_yrp_attribute18
      ,p_yrp_attribute19                =>  p_yrp_attribute19
      ,p_yrp_attribute20                =>  p_yrp_attribute20
      ,p_yrp_attribute21                =>  p_yrp_attribute21
      ,p_yrp_attribute22                =>  p_yrp_attribute22
      ,p_yrp_attribute23                =>  p_yrp_attribute23
      ,p_yrp_attribute24                =>  p_yrp_attribute24
      ,p_yrp_attribute25                =>  p_yrp_attribute25
      ,p_yrp_attribute26                =>  p_yrp_attribute26
      ,p_yrp_attribute27                =>  p_yrp_attribute27
      ,p_yrp_attribute28                =>  p_yrp_attribute28
      ,p_yrp_attribute29                =>  p_yrp_attribute29
      ,p_yrp_attribute30                =>  p_yrp_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 510


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

Line: 539


    ROLLBACK TO update_pgm_or_pl_yr_perd;

Line: 551


    ROLLBACK TO update_pgm_or_pl_yr_perd;

Line: 554


end update_pgm_or_pl_yr_perd;

Line: 559


procedure delete_pgm_or_pl_yr_perd
  (p_validate                       in  boolean  default false
  ,p_yr_perd_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_pgm_or_pl_yr_perd';

Line: 577


  savepoint delete_pgm_or_pl_yr_perd;

Line: 590


    ben_pgm_or_pl_yr_perd_bk3.delete_pgm_or_pl_yr_perd_b
      (
       p_yr_perd_id                     =>  p_yr_perd_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 599


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

Line: 618


    ben_pgm_or_pl_yr_perd_bk3.delete_pgm_or_pl_yr_perd_a
      (
       p_yr_perd_id                     =>  p_yr_perd_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 627


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

Line: 652


    ROLLBACK TO delete_pgm_or_pl_yr_perd;

Line: 663


    ROLLBACK TO delete_pgm_or_pl_yr_perd;

Line: 666


end delete_pgm_or_pl_yr_perd;