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.PER_BF_PAYROLL_RUNS_API SQL Statements

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

Line: 278


procedure update_payroll_run
  (p_payroll_run_id                in number
  ,p_payroll_identifier            in varchar2         default hr_api.g_varchar2
  ,p_period_start_date             in date             default hr_api.g_date
  ,p_period_end_date               in date             default hr_api.g_date
  ,p_processing_date               in date             default hr_api.g_date
  ,p_bpr_attribute_category        in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute1                in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute2                in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute3                in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute4                in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute5                in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute6                in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute7                in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute8                in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute9                in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute10               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute11               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute12               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute13               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute14               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute15               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute16               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute17               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute18               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute19               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute20               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute21               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute22               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute23               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute24               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute25               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute26               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute27               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute28               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute29               in varchar2         default hr_api.g_varchar2
  ,p_bpr_attribute30               in varchar2         default hr_api.g_varchar2
  ,p_validate                      in boolean          default false
  ,p_effective_date                in date
  ,p_object_version_number         in out nocopy number
  )
IS
--
  --
  -- Declare cursors and local variables
  --
  l_object_version_number   NUMBER;

Line: 325


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

Line: 331


  savepoint update_payroll_run;

Line: 341


    PER_BF_PAYROLL_RUNS_BK2.update_payroll_run_b
      (p_effective_date                => p_effective_date
      ,p_payroll_identifier            => p_payroll_identifier
      ,p_period_start_date             => p_period_start_date
      ,p_period_end_date               => p_period_end_date
      ,p_processing_date               => p_processing_date
      ,p_bpr_attribute_category        => p_bpr_attribute_category
      ,p_bpr_attribute1                => p_bpr_attribute1
      ,p_bpr_attribute2                => p_bpr_attribute2
      ,p_bpr_attribute3                => p_bpr_attribute3
      ,p_bpr_attribute4                => p_bpr_attribute4
      ,p_bpr_attribute5                => p_bpr_attribute5
      ,p_bpr_attribute6                => p_bpr_attribute6
      ,p_bpr_attribute7                => p_bpr_attribute7
      ,p_bpr_attribute8                => p_bpr_attribute8
      ,p_bpr_attribute9                => p_bpr_attribute9
      ,p_bpr_attribute10               => p_bpr_attribute10
      ,p_bpr_attribute11               => p_bpr_attribute11
      ,p_bpr_attribute12               => p_bpr_attribute12
      ,p_bpr_attribute13               => p_bpr_attribute13
      ,p_bpr_attribute14               => p_bpr_attribute14
      ,p_bpr_attribute15               => p_bpr_attribute15
      ,p_bpr_attribute16               => p_bpr_attribute16
      ,p_bpr_attribute17               => p_bpr_attribute17
      ,p_bpr_attribute18               => p_bpr_attribute18
      ,p_bpr_attribute19               => p_bpr_attribute19
      ,p_bpr_attribute20               => p_bpr_attribute20
      ,p_bpr_attribute21               => p_bpr_attribute21
      ,p_bpr_attribute22               => p_bpr_attribute22
      ,p_bpr_attribute23               => p_bpr_attribute23
      ,p_bpr_attribute24               => p_bpr_attribute24
      ,p_bpr_attribute25               => p_bpr_attribute25
      ,p_bpr_attribute26               => p_bpr_attribute26
      ,p_bpr_attribute27               => p_bpr_attribute27
      ,p_bpr_attribute28               => p_bpr_attribute28
      ,p_bpr_attribute29               => p_bpr_attribute29
      ,p_bpr_attribute30               => p_bpr_attribute30
      ,p_payroll_run_id                => p_payroll_run_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 384


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

Line: 445


    PER_BF_PAYROLL_RUNS_BK2.update_payroll_run_a
      (p_effective_date                => p_effective_date
      ,p_payroll_identifier            => p_payroll_identifier
      ,p_period_start_date             => p_period_start_date
      ,p_period_end_date               => p_period_end_date
      ,p_processing_date               => p_processing_date
      ,p_payroll_run_id                => p_payroll_run_id
      ,p_object_version_number         => p_object_version_number
      ,p_bpr_attribute_category        => p_bpr_attribute_category
      ,p_bpr_attribute1                => p_bpr_attribute1
      ,p_bpr_attribute2                => p_bpr_attribute2
      ,p_bpr_attribute3                => p_bpr_attribute3
      ,p_bpr_attribute4                => p_bpr_attribute4
      ,p_bpr_attribute5                => p_bpr_attribute5
      ,p_bpr_attribute6                => p_bpr_attribute6
      ,p_bpr_attribute7                => p_bpr_attribute7
      ,p_bpr_attribute8                => p_bpr_attribute8
      ,p_bpr_attribute9                => p_bpr_attribute9
      ,p_bpr_attribute10               => p_bpr_attribute10
      ,p_bpr_attribute11               => p_bpr_attribute11
      ,p_bpr_attribute12               => p_bpr_attribute12
      ,p_bpr_attribute13               => p_bpr_attribute13
      ,p_bpr_attribute14               => p_bpr_attribute14
      ,p_bpr_attribute15               => p_bpr_attribute15
      ,p_bpr_attribute16               => p_bpr_attribute16
      ,p_bpr_attribute17               => p_bpr_attribute17
      ,p_bpr_attribute18               => p_bpr_attribute18
      ,p_bpr_attribute19               => p_bpr_attribute19
      ,p_bpr_attribute20               => p_bpr_attribute20
      ,p_bpr_attribute21               => p_bpr_attribute21
      ,p_bpr_attribute22               => p_bpr_attribute22
      ,p_bpr_attribute23               => p_bpr_attribute23
      ,p_bpr_attribute24               => p_bpr_attribute24
      ,p_bpr_attribute25               => p_bpr_attribute25
      ,p_bpr_attribute26               => p_bpr_attribute26
      ,p_bpr_attribute27               => p_bpr_attribute27
      ,p_bpr_attribute28               => p_bpr_attribute28
      ,p_bpr_attribute29               => p_bpr_attribute29
      ,p_bpr_attribute30               => p_bpr_attribute30
      );

Line: 488


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

Line: 511


    rollback to update_payroll_run;

Line: 523


    rollback to update_payroll_run;

Line: 526


end update_payroll_run;

Line: 532


procedure delete_payroll_run
  (p_payroll_run_id                in number
  ,p_validate                      in boolean          default false
  ,p_object_version_number         in number
  )
IS
--
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_payroll_run';

Line: 548


  savepoint delete_payroll_run;

Line: 558


    PER_BF_PAYROLL_RUNS_BK3.delete_payroll_run_b
      (
       p_payroll_run_id                => p_payroll_run_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 566


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

Line: 589


    PER_BF_PAYROLL_RUNS_BK3.delete_payroll_run_a
      (
       p_payroll_run_id                => p_payroll_run_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 597


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

Line: 618


    rollback to delete_payroll_run;

Line: 629


    rollback to delete_payroll_run;

Line: 632


end delete_payroll_run;