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

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

Line: 26


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

Line: 52


procedure update_fed_tax_rule
(
   p_validate                       IN     boolean    default false
  ,p_effective_date                 IN     date
  ,p_datetrack_update_mode          IN     varchar2
  ,p_emp_fed_tax_rule_id            IN     number
  ,p_object_version_number          IN OUT nocopy number
  ,p_sui_state_code                 IN     varchar2  default hr_api.g_varchar2
  ,p_additional_wa_amount           IN     number    default hr_api.g_number
  ,p_filing_status_code             IN     varchar2  default hr_api.g_varchar2
  ,p_fit_override_amount            IN     number    default hr_api.g_number
  ,p_fit_override_rate              IN     number    default hr_api.g_number
  ,p_withholding_allowances         IN     number    default hr_api.g_number
  ,p_cumulative_taxation            IN     varchar2  default hr_api.g_varchar2
  ,p_eic_filing_status_code         IN     varchar2  default hr_api.g_varchar2
  ,p_fit_additional_tax             IN     number    default hr_api.g_number
  ,p_fit_exempt                     IN     varchar2  default hr_api.g_varchar2
  ,p_futa_tax_exempt                IN     varchar2  default hr_api.g_varchar2
  ,p_medicare_tax_exempt            IN     varchar2  default hr_api.g_varchar2
  ,p_ss_tax_exempt                  IN     varchar2  default hr_api.g_varchar2
  ,p_wage_exempt                    IN     varchar2  default hr_api.g_varchar2
  ,p_statutory_employee             IN     varchar2  default hr_api.g_varchar2
  ,p_w2_filed_year                  IN     number    default hr_api.g_number
  ,p_supp_tax_override_rate         IN     number    default hr_api.g_number
  ,p_excessive_wa_reject_date       IN     date      default hr_api.g_date
  ,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_attribute21                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute22                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute23                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute24                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute25                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute26                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute27                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute28                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute29                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute30                    in     varchar2  default hr_api.g_varchar2
  ,p_fed_information_category       in     varchar2  default hr_api.g_varchar2
  ,p_fed_information1               in     varchar2  default hr_api.g_varchar2
  ,p_fed_information2               in     varchar2  default hr_api.g_varchar2
  ,p_fed_information3               in     varchar2  default hr_api.g_varchar2
  ,p_fed_information4               in     varchar2  default hr_api.g_varchar2
  ,p_fed_information5               in     varchar2  default hr_api.g_varchar2
  ,p_fed_information6               in     varchar2  default hr_api.g_varchar2
  ,p_fed_information7               in     varchar2  default hr_api.g_varchar2
  ,p_fed_information8               in     varchar2  default hr_api.g_varchar2
  ,p_fed_information9               in     varchar2  default hr_api.g_varchar2
  ,p_fed_information10              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information11              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information12              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information13              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information14              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information15              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information16              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information17              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information18              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information19              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information20              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information21              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information22              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information23              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information24              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information25              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information26              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information27              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information28              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information29              in     varchar2  default hr_api.g_varchar2
  ,p_fed_information30              in     varchar2  default hr_api.g_varchar2
  ,p_effective_start_date           OUT nocopy date
  ,p_effective_end_date             OUT nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_fed_tax_rule';

Line: 163


    select psr.jurisdiction_code
    from   pay_state_rules psr, pay_us_states pus
    where  pus.state_code = p_sui_state_code
    and    pus.state_abbrev = psr.state_code;

Line: 175


  savepoint update_fed_tax_rule;

Line: 285


    ,p_datetrack_mode                => p_datetrack_update_mode
    ,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_attribute21                   => p_attribute21
    ,p_attribute22                   => p_attribute22
    ,p_attribute23                   => p_attribute23
    ,p_attribute24                   => p_attribute24
    ,p_attribute25                   => p_attribute25
    ,p_attribute26                   => p_attribute26
    ,p_attribute27                   => p_attribute27
    ,p_attribute28                   => p_attribute28
    ,p_attribute29                   => p_attribute29
    ,p_attribute30                   => p_attribute30
    ,p_fed_information_category            => p_fed_information_category
    ,p_fed_information1                    => p_fed_information1
    ,p_fed_information2                    => p_fed_information2
    ,p_fed_information3                    => p_fed_information3
    ,p_fed_information4                    => p_fed_information4
    ,p_fed_information5                    => p_fed_information5
    ,p_fed_information6                    => p_fed_information6
    ,p_fed_information7                    => p_fed_information7
    ,p_fed_information8                    => p_fed_information8
    ,p_fed_information9                    => p_fed_information9
    ,p_fed_information10                   => p_fed_information10
    ,p_fed_information11                   => p_fed_information11
    ,p_fed_information12                   => p_fed_information12
    ,p_fed_information13                   => p_fed_information13
    ,p_fed_information14                   => p_fed_information14
    ,p_fed_information15                   => p_fed_information15
    ,p_fed_information16                   => p_fed_information16
    ,p_fed_information17                   => p_fed_information17
    ,p_fed_information18                   => p_fed_information18
    ,p_fed_information19                   => p_fed_information19
    ,p_fed_information20                   => p_fed_information20
    ,p_fed_information21                   => p_fed_information21
    ,p_fed_information22                   => p_fed_information22
    ,p_fed_information23                   => p_fed_information23
    ,p_fed_information24                   => p_fed_information24
    ,p_fed_information25                   => p_fed_information25
    ,p_fed_information26                   => p_fed_information26
    ,p_fed_information27                   => p_fed_information27
    ,p_fed_information28                   => p_fed_information28
    ,p_fed_information29                   => p_fed_information29
    ,p_fed_information30                   => p_fed_information30
    );

Line: 356


      ,p_datetrack_mode         =>  p_datetrack_update_mode
      );

Line: 424


    ROLLBACK TO update_fed_tax_rule;

Line: 438


    ROLLBACK TO update_fed_tax_rule;

Line: 441


end update_fed_tax_rule;