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

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

Line: 18


  SELECT pd.personal_payment_method_id
  FROM per_bf_payment_details pd
  WHERE pd.payment_detail_id = p_payment_detail_id;

Line: 25


  SELECT opm.currency_code
  FROM pay_org_payment_methods_f opm
      ,pay_personal_payment_methods_f ppm
  WHERE ppm.org_payment_method_id = opm.org_payment_method_id
    AND ppm.personal_payment_method_id = l_ppm_id
    AND p_effective_date BETWEEN
        opm.effective_start_date AND opm.effective_end_date
    AND p_effective_date BETWEEN
        ppm.effective_start_date AND ppm.effective_end_date;

Line: 128


  SELECT processed_assignment_id, object_version_number
    FROM per_bf_processed_assignments
   WHERE payroll_run_id = p_payroll_run_id
     AND assignment_id = p_assignment_id;

Line: 411


procedure update_payment_detail
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_check_number                  in     number   default hr_api.g_number
  ,p_payment_date                  in     date     default hr_api.g_date
  ,p_amount                        in     number   default hr_api.g_number
  ,p_check_type                    in     varchar2 default hr_api.g_varchar2
  ,p_payment_detail_id             in     number
  ,p_currency_code                 in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute_category        in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute1                in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute2                in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute3                in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute4                in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute5                in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute6                in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute7                in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute8                in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute9                in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute10               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute11               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute12               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute13               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute14               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute15               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute16               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute17               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute18               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute19               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute20               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute21               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute22               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute23               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute24               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute25               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute26               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute27               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute28               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute29               in     varchar2 default hr_api.g_varchar2
  ,p_bpd_attribute30               in     varchar2 default hr_api.g_varchar2
  ,p_payment_detail_ovn            in     out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  l_payment_detail_ovn  PER_BF_PAYMENT_DETAILS.OBJECT_VERSION_NUMBER%TYPE;

Line: 457


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

Line: 463


  savepoint update_payment_detail;

Line: 473


    per_bf_payment_details_bk2.update_payment_detail_b
      (p_effective_date                => p_effective_date
      ,p_check_number                  => p_check_number
      ,p_payment_date                    => p_payment_date
      ,p_amount                        => p_amount
      ,p_check_type                    => p_check_type
      ,p_bpd_attribute_category            => p_bpd_attribute_category
      ,p_bpd_attribute1                    => p_bpd_attribute1
      ,p_bpd_attribute2                    => p_bpd_attribute2
      ,p_bpd_attribute3                    => p_bpd_attribute3
      ,p_bpd_attribute4                    => p_bpd_attribute4
      ,p_bpd_attribute5                    => p_bpd_attribute5
      ,p_bpd_attribute6                    => p_bpd_attribute6
      ,p_bpd_attribute7                    => p_bpd_attribute7
      ,p_bpd_attribute8                    => p_bpd_attribute8
      ,p_bpd_attribute9                    => p_bpd_attribute9
      ,p_bpd_attribute10                   => p_bpd_attribute10
      ,p_bpd_attribute11                   => p_bpd_attribute11
      ,p_bpd_attribute12                   => p_bpd_attribute12
      ,p_bpd_attribute13                   => p_bpd_attribute13
      ,p_bpd_attribute14                   => p_bpd_attribute14
      ,p_bpd_attribute15                   => p_bpd_attribute15
      ,p_bpd_attribute16                   => p_bpd_attribute16
      ,p_bpd_attribute17                   => p_bpd_attribute17
      ,p_bpd_attribute18                   => p_bpd_attribute18
      ,p_bpd_attribute19                   => p_bpd_attribute19
      ,p_bpd_attribute20                   => p_bpd_attribute20
      ,p_bpd_attribute21                   => p_bpd_attribute21
      ,p_bpd_attribute22                   => p_bpd_attribute22
      ,p_bpd_attribute23                   => p_bpd_attribute23
      ,p_bpd_attribute24                   => p_bpd_attribute24
      ,p_bpd_attribute25                   => p_bpd_attribute25
      ,p_bpd_attribute26                   => p_bpd_attribute26
      ,p_bpd_attribute27                   => p_bpd_attribute27
      ,p_bpd_attribute28                   => p_bpd_attribute28
      ,p_bpd_attribute29                   => p_bpd_attribute29
      ,p_bpd_attribute30                   => p_bpd_attribute30
      ,p_payment_detail_id             => p_payment_detail_id
      ,p_payment_detail_ovn            => p_payment_detail_ovn
      );

Line: 516


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

Line: 582


    per_bf_payment_details_bk2.update_payment_detail_a
      (p_effective_date                => p_effective_date
      ,p_check_number                  => p_check_number
      ,p_payment_date                    => p_payment_date
      ,p_amount                        => p_amount
      ,p_check_type                    => p_check_type
      ,p_bpd_attribute_category            => p_bpd_attribute_category
      ,p_bpd_attribute1                    => p_bpd_attribute1
      ,p_bpd_attribute2                    => p_bpd_attribute2
      ,p_bpd_attribute3                    => p_bpd_attribute3
      ,p_bpd_attribute4                    => p_bpd_attribute4
      ,p_bpd_attribute5                    => p_bpd_attribute5
      ,p_bpd_attribute6                    => p_bpd_attribute6
      ,p_bpd_attribute7                    => p_bpd_attribute7
      ,p_bpd_attribute8                    => p_bpd_attribute8
      ,p_bpd_attribute9                    => p_bpd_attribute9
      ,p_bpd_attribute10                   => p_bpd_attribute10
      ,p_bpd_attribute11                   => p_bpd_attribute11
      ,p_bpd_attribute12                   => p_bpd_attribute12
      ,p_bpd_attribute13                   => p_bpd_attribute13
      ,p_bpd_attribute14                   => p_bpd_attribute14
      ,p_bpd_attribute15                   => p_bpd_attribute15
      ,p_bpd_attribute16                   => p_bpd_attribute16
      ,p_bpd_attribute17                   => p_bpd_attribute17
      ,p_bpd_attribute18                   => p_bpd_attribute18
      ,p_bpd_attribute19                   => p_bpd_attribute19
      ,p_bpd_attribute20                   => p_bpd_attribute20
      ,p_bpd_attribute21                   => p_bpd_attribute21
      ,p_bpd_attribute22                   => p_bpd_attribute22
      ,p_bpd_attribute23                   => p_bpd_attribute23
      ,p_bpd_attribute24                   => p_bpd_attribute24
      ,p_bpd_attribute25                   => p_bpd_attribute25
      ,p_bpd_attribute26                   => p_bpd_attribute26
      ,p_bpd_attribute27                   => p_bpd_attribute27
      ,p_bpd_attribute28                   => p_bpd_attribute28
      ,p_bpd_attribute29                   => p_bpd_attribute29
      ,p_bpd_attribute30                   => p_bpd_attribute30
      ,p_payment_detail_id             => p_payment_detail_id
      ,p_payment_detail_ovn            => l_payment_detail_ovn
      );

Line: 625


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

Line: 648


    rollback to UPDATE_PAYMENT_DETAIL;

Line: 661


    rollback to UPDATE_PAYMENT_DETAIL;

Line: 666


end UPDATE_PAYMENT_DETAIL;

Line: 670


procedure delete_payment_detail
  (p_validate                     in      boolean  default false
  ,p_payment_detail_id            in      number
  ,p_payment_detail_ovn           in      number
  ) is
  --
  -- Declare cursors and local variables
  --
  CURSOR csr_get_pa_id IS
  SELECT pa.processed_assignment_id, pa.object_version_number
    FROM PER_BF_PAYMENT_DETAILS  pd
	,PER_BF_PROCESSED_ASSIGNMENTS pa
   WHERE pd.payment_detail_id = p_payment_detail_id
     AND pd.processed_assignment_id = pa.processed_assignment_id;

Line: 687


  SELECT 1
    FROM per_bf_payment_details
   WHERE processed_assignment_id = p_processed_assignment_id
     AND payment_detail_id <> p_payment_detail_id
   UNION
  SELECT 1
    FROM per_bf_balance_amounts
   WHERE processed_assignment_id = p_processed_assignment_id;

Line: 699


  l_delete_pa_row            BOOLEAN;

Line: 701


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

Line: 708


  savepoint delete_payment_detail;

Line: 718


    per_bf_payment_details_bk3.delete_payment_detail_b
      (p_payment_detail_id             => p_payment_detail_id
      ,p_payment_detail_ovn            => p_payment_detail_ovn
      );

Line: 725


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

Line: 761


    l_delete_pa_row := TRUE;

Line: 767


    l_delete_pa_row := FALSE;

Line: 776


  IF l_delete_pa_row THEN
    --
    -- The processed_assignment row is to be removed, so
    -- remove it
    --
    per_bpa_del.del
      ( p_processed_assignment_id      => l_processed_assignment_id
      , p_object_version_number        => l_processed_assignment_ovn
      );

Line: 793


    per_bf_payment_details_bk3.delete_payment_detail_a
      (p_payment_detail_id             => p_payment_detail_id
      ,p_payment_detail_ovn            => p_payment_detail_ovn
      );

Line: 800


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

Line: 822


    rollback to DELETE_PAYMENT_DETAIL;

Line: 833


    rollback to DELETE_PAYMENT_DETAIL;

Line: 836


end DELETE_PAYMENT_DETAIL;