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

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

Line: 274


procedure update_DEDUCT_SCHED_PAY_FREQ
  (p_validate                       in  boolean   default false
  ,p_ded_sched_py_freq_id           in  number
  ,p_py_freq_cd                     in  varchar2  default hr_api.g_varchar2
  ,p_dflt_flag                      in  varchar2  default hr_api.g_varchar2
  ,p_acty_rt_ded_sched_id           in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_dsq_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_dsq_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_DEDUCT_SCHED_PAY_FREQ';

Line: 327


  savepoint update_DEDUCT_SCHED_PAY_FREQ;

Line: 339


    ben_DEDUCT_SCHED_PAY_FREQ_bk2.update_DEDUCT_SCHED_PAY_FREQ_b
      (
       p_ded_sched_py_freq_id           =>  p_ded_sched_py_freq_id
      ,p_py_freq_cd                     =>  p_py_freq_cd
      ,p_dflt_flag                      =>  p_dflt_flag
      ,p_acty_rt_ded_sched_id           =>  p_acty_rt_ded_sched_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_dsq_attribute_category         =>  p_dsq_attribute_category
      ,p_dsq_attribute1                 =>  p_dsq_attribute1
      ,p_dsq_attribute2                 =>  p_dsq_attribute2
      ,p_dsq_attribute3                 =>  p_dsq_attribute3
      ,p_dsq_attribute4                 =>  p_dsq_attribute4
      ,p_dsq_attribute5                 =>  p_dsq_attribute5
      ,p_dsq_attribute6                 =>  p_dsq_attribute6
      ,p_dsq_attribute7                 =>  p_dsq_attribute7
      ,p_dsq_attribute8                 =>  p_dsq_attribute8
      ,p_dsq_attribute9                 =>  p_dsq_attribute9
      ,p_dsq_attribute10                =>  p_dsq_attribute10
      ,p_dsq_attribute11                =>  p_dsq_attribute11
      ,p_dsq_attribute12                =>  p_dsq_attribute12
      ,p_dsq_attribute13                =>  p_dsq_attribute13
      ,p_dsq_attribute14                =>  p_dsq_attribute14
      ,p_dsq_attribute15                =>  p_dsq_attribute15
      ,p_dsq_attribute16                =>  p_dsq_attribute16
      ,p_dsq_attribute17                =>  p_dsq_attribute17
      ,p_dsq_attribute18                =>  p_dsq_attribute18
      ,p_dsq_attribute19                =>  p_dsq_attribute19
      ,p_dsq_attribute20                =>  p_dsq_attribute20
      ,p_dsq_attribute21                =>  p_dsq_attribute21
      ,p_dsq_attribute22                =>  p_dsq_attribute22
      ,p_dsq_attribute23                =>  p_dsq_attribute23
      ,p_dsq_attribute24                =>  p_dsq_attribute24
      ,p_dsq_attribute25                =>  p_dsq_attribute25
      ,p_dsq_attribute26                =>  p_dsq_attribute26
      ,p_dsq_attribute27                =>  p_dsq_attribute27
      ,p_dsq_attribute28                =>  p_dsq_attribute28
      ,p_dsq_attribute29                =>  p_dsq_attribute29
      ,p_dsq_attribute30                =>  p_dsq_attribute30
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      );

Line: 383


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

Line: 437


    ben_DEDUCT_SCHED_PAY_FREQ_bk2.update_DEDUCT_SCHED_PAY_FREQ_a
      (
       p_ded_sched_py_freq_id           =>  p_ded_sched_py_freq_id
      ,p_py_freq_cd                     =>  p_py_freq_cd
      ,p_dflt_flag                      =>  p_dflt_flag
      ,p_acty_rt_ded_sched_id           =>  p_acty_rt_ded_sched_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_dsq_attribute_category         =>  p_dsq_attribute_category
      ,p_dsq_attribute1                 =>  p_dsq_attribute1
      ,p_dsq_attribute2                 =>  p_dsq_attribute2
      ,p_dsq_attribute3                 =>  p_dsq_attribute3
      ,p_dsq_attribute4                 =>  p_dsq_attribute4
      ,p_dsq_attribute5                 =>  p_dsq_attribute5
      ,p_dsq_attribute6                 =>  p_dsq_attribute6
      ,p_dsq_attribute7                 =>  p_dsq_attribute7
      ,p_dsq_attribute8                 =>  p_dsq_attribute8
      ,p_dsq_attribute9                 =>  p_dsq_attribute9
      ,p_dsq_attribute10                =>  p_dsq_attribute10
      ,p_dsq_attribute11                =>  p_dsq_attribute11
      ,p_dsq_attribute12                =>  p_dsq_attribute12
      ,p_dsq_attribute13                =>  p_dsq_attribute13
      ,p_dsq_attribute14                =>  p_dsq_attribute14
      ,p_dsq_attribute15                =>  p_dsq_attribute15
      ,p_dsq_attribute16                =>  p_dsq_attribute16
      ,p_dsq_attribute17                =>  p_dsq_attribute17
      ,p_dsq_attribute18                =>  p_dsq_attribute18
      ,p_dsq_attribute19                =>  p_dsq_attribute19
      ,p_dsq_attribute20                =>  p_dsq_attribute20
      ,p_dsq_attribute21                =>  p_dsq_attribute21
      ,p_dsq_attribute22                =>  p_dsq_attribute22
      ,p_dsq_attribute23                =>  p_dsq_attribute23
      ,p_dsq_attribute24                =>  p_dsq_attribute24
      ,p_dsq_attribute25                =>  p_dsq_attribute25
      ,p_dsq_attribute26                =>  p_dsq_attribute26
      ,p_dsq_attribute27                =>  p_dsq_attribute27
      ,p_dsq_attribute28                =>  p_dsq_attribute28
      ,p_dsq_attribute29                =>  p_dsq_attribute29
      ,p_dsq_attribute30                =>  p_dsq_attribute30
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      );

Line: 481


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

Line: 510


    ROLLBACK TO update_DEDUCT_SCHED_PAY_FREQ;

Line: 522


    ROLLBACK TO update_DEDUCT_SCHED_PAY_FREQ;

Line: 525


end update_DEDUCT_SCHED_PAY_FREQ;

Line: 530


procedure delete_DEDUCT_SCHED_PAY_FREQ
  (p_validate                       in  boolean  default false
  ,p_ded_sched_py_freq_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_DEDUCT_SCHED_PAY_FREQ';

Line: 548


  savepoint delete_DEDUCT_SCHED_PAY_FREQ;

Line: 561


    ben_DEDUCT_SCHED_PAY_FREQ_bk3.delete_DEDUCT_SCHED_PAY_FREQ_b
      (
       p_ded_sched_py_freq_id           =>  p_ded_sched_py_freq_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 570


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

Line: 589


    ben_DEDUCT_SCHED_PAY_FREQ_bk3.delete_DEDUCT_SCHED_PAY_FREQ_a
      (
       p_ded_sched_py_freq_id           =>  p_ded_sched_py_freq_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 598


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

Line: 623


    ROLLBACK TO delete_DEDUCT_SCHED_PAY_FREQ;

Line: 634


    ROLLBACK TO delete_DEDUCT_SCHED_PAY_FREQ;

Line: 637


end delete_DEDUCT_SCHED_PAY_FREQ;