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

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

Line: 289


PROCEDURE delete_payroll
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_payroll_id                   in     number
  ,p_object_version_number        in out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 307


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

Line: 313


  savepoint delete_payroll_swi;

Line: 334


  pay_payroll_api.delete_payroll
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_payroll_id                   => p_payroll_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 365


    rollback to delete_payroll_swi;

Line: 382


    rollback to delete_payroll_swi;

Line: 395


end delete_payroll;

Line: 399


PROCEDURE update_payroll
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_payroll_id                   in out nocopy number
  ,p_object_version_number        in out nocopy number
  ,p_payroll_name                 in     varchar2  default hr_api.g_varchar2
  ,p_number_of_years              in     number    default hr_api.g_number
  ,p_default_payment_method_id    in     number    default hr_api.g_number
  ,p_consolidation_set_id         in     number    default hr_api.g_number
  ,p_cost_allocation_keyflex_id   in     number    default hr_api.g_number
  ,p_suspense_account_keyflex_id  in     number    default hr_api.g_number
  ,p_negative_pay_allowed_flag    in     varchar2  default hr_api.g_varchar2
  ,p_soft_coding_keyflex_id       in     number    default hr_api.g_number
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
  ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
  ,p_arrears_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_multi_assignments_flag       in     varchar2  default hr_api.g_varchar2
  ,p_prl_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_prl_information1             in     varchar2  default hr_api.g_varchar2
  ,p_prl_information2             in     varchar2  default hr_api.g_varchar2
  ,p_prl_information3             in     varchar2  default hr_api.g_varchar2
  ,p_prl_information4             in     varchar2  default hr_api.g_varchar2
  ,p_prl_information5             in     varchar2  default hr_api.g_varchar2
  ,p_prl_information6             in     varchar2  default hr_api.g_varchar2
  ,p_prl_information7             in     varchar2  default hr_api.g_varchar2
  ,p_prl_information8             in     varchar2  default hr_api.g_varchar2
  ,p_prl_information9             in     varchar2  default hr_api.g_varchar2
  ,p_prl_information10            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information11            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information12            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information13            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information14            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information15            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information16            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information17            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information18            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information19            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information20            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information21            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information22            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information23            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information24            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information25            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information26            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information27            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information28            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information29            in     varchar2  default hr_api.g_varchar2
  ,p_prl_information30            in     varchar2  default hr_api.g_varchar2
  ,p_prl_effective_start_date        out nocopy date
  ,p_prl_effective_end_date          out nocopy date
  ,p_comment_id                      out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 482


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

Line: 488


  savepoint update_payroll_swi;

Line: 510


  pay_payroll_api.update_payroll
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_payroll_id                   => p_payroll_id
    ,p_object_version_number        => p_object_version_number
    ,p_payroll_name                 => p_payroll_name
    ,p_number_of_years              => p_number_of_years
    ,p_default_payment_method_id    => p_default_payment_method_id
    ,p_consolidation_set_id         => p_consolidation_set_id
    ,p_cost_allocation_keyflex_id   => p_cost_allocation_keyflex_id
    ,p_suspense_account_keyflex_id  => p_suspense_account_keyflex_id
    ,p_negative_pay_allowed_flag    => p_negative_pay_allowed_flag
    ,p_soft_coding_keyflex_id       => p_soft_coding_keyflex_id
    ,p_comments                     => p_comments
    ,p_attribute_category           => p_attribute_category
    ,p_attribute1                   => p_attribute1
    ,p_attribute2                   => p_attribute2
    ,p_attribute3                   => p_attribute3
    ,p_attribute4                   => p_attribute4
    ,p_attribute5                   => p_attribute5
    ,p_attribute6                   => p_attribute6
    ,p_attribute7                   => p_attribute7
    ,p_attribute8                   => p_attribute8
    ,p_attribute9                   => p_attribute9
    ,p_attribute10                  => p_attribute10
    ,p_attribute11                  => p_attribute11
    ,p_attribute12                  => p_attribute12
    ,p_attribute13                  => p_attribute13
    ,p_attribute14                  => p_attribute14
    ,p_attribute15                  => p_attribute15
    ,p_attribute16                  => p_attribute16
    ,p_attribute17                  => p_attribute17
    ,p_attribute18                  => p_attribute18
    ,p_attribute19                  => p_attribute19
    ,p_attribute20                  => p_attribute20
    ,p_arrears_flag                 => p_arrears_flag
    ,p_multi_assignments_flag       => p_multi_assignments_flag
    ,p_prl_information_category     => p_prl_information_category
    ,p_prl_information1             => p_prl_information1
    ,p_prl_information2             => p_prl_information2
    ,p_prl_information3             => p_prl_information3
    ,p_prl_information4             => p_prl_information4
    ,p_prl_information5             => p_prl_information5
    ,p_prl_information6             => p_prl_information6
    ,p_prl_information7             => p_prl_information7
    ,p_prl_information8             => p_prl_information8
    ,p_prl_information9             => p_prl_information9
    ,p_prl_information10            => p_prl_information10
    ,p_prl_information11            => p_prl_information11
    ,p_prl_information12            => p_prl_information12
    ,p_prl_information13            => p_prl_information13
    ,p_prl_information14            => p_prl_information14
    ,p_prl_information15            => p_prl_information15
    ,p_prl_information16            => p_prl_information16
    ,p_prl_information17            => p_prl_information17
    ,p_prl_information18            => p_prl_information18
    ,p_prl_information19            => p_prl_information19
    ,p_prl_information20            => p_prl_information20
    ,p_prl_information21            => p_prl_information21
    ,p_prl_information22            => p_prl_information22
    ,p_prl_information23            => p_prl_information23
    ,p_prl_information24            => p_prl_information24
    ,p_prl_information25            => p_prl_information25
    ,p_prl_information26            => p_prl_information26
    ,p_prl_information27            => p_prl_information27
    ,p_prl_information28            => p_prl_information28
    ,p_prl_information29            => p_prl_information29
    ,p_prl_information30            => p_prl_information30
    ,p_prl_effective_start_date     => p_prl_effective_start_date
    ,p_prl_effective_end_date       => p_prl_effective_end_date
    ,p_comment_id                   => p_comment_id
    );

Line: 605


    rollback to update_payroll_swi;

Line: 624


    rollback to update_payroll_swi;

Line: 639


end update_payroll;