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

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

Line: 308


Procedure Delete_Pension_Type
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_pension_type_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
  ,p_api_warning                     out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 327


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

Line: 333


  savepoint delete_pension_type_swi;

Line: 354


  pqp_pension_types_api.delete_pension_type
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_pension_type_id              => p_pension_type_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
    ,p_api_warning                  => p_api_warning
    );

Line: 386


    rollback to delete_pension_type_swi;

Line: 403


    rollback to delete_pension_type_swi;

Line: 416


End Delete_Pension_Type;

Line: 420


Procedure Update_Pension_Type
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_pension_type_id              in     number
  ,p_object_version_number        in out nocopy number
  ,p_pension_type_name            in     varchar2  default hr_api.g_varchar2
  ,p_pension_category             in     varchar2  default hr_api.g_varchar2
  ,p_pension_provider_type        in     varchar2  default hr_api.g_varchar2
  ,p_salary_calculation_method    in     varchar2  default hr_api.g_varchar2
  ,p_threshold_conversion_rule    in     varchar2  default hr_api.g_varchar2
  ,p_contribution_conversion_rule in     varchar2  default hr_api.g_varchar2
  ,p_er_annual_limit              in     number    default hr_api.g_number
  ,p_ee_annual_limit              in     number    default hr_api.g_number
  ,p_er_annual_salary_threshold   in     number    default hr_api.g_number
  ,p_ee_annual_salary_threshold   in     number    default hr_api.g_number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_minimum_age                  in     number    default hr_api.g_number
  ,p_ee_contribution_percent      in     number    default hr_api.g_number
  ,p_maximum_age                  in     number    default hr_api.g_number
  ,p_er_contribution_percent      in     number    default hr_api.g_number
  ,p_ee_annual_contribution       in     number    default hr_api.g_number
  ,p_er_annual_contribution       in     number    default hr_api.g_number
  ,p_annual_premium_amount        in     number    default hr_api.g_number
  ,p_ee_contribution_bal_type_id  in     number    default hr_api.g_number
  ,p_er_contribution_bal_type_id  in     number    default hr_api.g_number
  ,p_balance_init_element_type_id in     number    default hr_api.g_number
  ,p_ee_contribution_fixed_rate   in     number    default hr_api.g_number --added for UK
  ,p_er_contribution_fixed_rate   in     number    default hr_api.g_number --added for UK
  ,p_pty_attribute_category       in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute1               in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute2               in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute3               in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute4               in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute5               in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute6               in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute7               in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute8               in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute9               in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute10              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute11              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute12              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute13              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute14              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute15              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute16              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute17              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute18              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute19              in     varchar2  default hr_api.g_varchar2
  ,p_pty_attribute20              in     varchar2  default hr_api.g_varchar2
  ,p_pty_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_pty_information1             in     varchar2  default hr_api.g_varchar2
  ,p_pty_information2             in     varchar2  default hr_api.g_varchar2
  ,p_pty_information3             in     varchar2  default hr_api.g_varchar2
  ,p_pty_information4             in     varchar2  default hr_api.g_varchar2
  ,p_pty_information5             in     varchar2  default hr_api.g_varchar2
  ,p_pty_information6             in     varchar2  default hr_api.g_varchar2
  ,p_pty_information7             in     varchar2  default hr_api.g_varchar2
  ,p_pty_information8             in     varchar2  default hr_api.g_varchar2
  ,p_pty_information9             in     varchar2  default hr_api.g_varchar2
  ,p_pty_information10            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information11            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information12            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information13            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information14            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information15            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information16            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information17            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information18            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information19            in     varchar2  default hr_api.g_varchar2
  ,p_pty_information20            in     varchar2  default hr_api.g_varchar2
  ,p_special_pension_type_code    in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_pension_sub_category         in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_pension_basis_calc_method    in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_pension_salary_balance       in     number    default hr_api.g_number    -- added for NL Phase 2B
  ,p_recurring_bonus_percent      in     number    default hr_api.g_number    -- added for NL Phase 2B
  ,p_non_recurring_bonus_percent  in     number    default hr_api.g_number    -- added for NL Phase 2B
  ,p_recurring_bonus_balance      in     number    default hr_api.g_number    -- added for NL Phase 2B
  ,p_non_recurring_bonus_balance  in     number    default hr_api.g_number    -- added for NL Phase 2B
  ,p_std_tax_reduction            in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_spl_tax_reduction            in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_sig_sal_spl_tax_reduction    in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_sig_sal_non_tax_reduction    in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_sig_sal_std_tax_reduction    in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_sii_std_tax_reduction        in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_sii_spl_tax_reduction        in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_sii_non_tax_reduction        in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_previous_year_bonus_included in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_recurring_bonus_period       in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_non_recurring_bonus_period   in     varchar2  default hr_api.g_varchar2  -- added for NL Phase 2B
  ,p_ee_age_threshold             in     varchar2  default hr_api.g_varchar2  -- added for ABP TAR Fixes
  ,p_er_age_threshold             in     varchar2  default hr_api.g_varchar2  -- added for ABP TAR Fixes
  ,p_ee_age_contribution          in     varchar2  default hr_api.g_varchar2  -- added for ABP TAR Fixes
  ,p_er_age_contribution          in     varchar2  default hr_api.g_varchar2  -- added for ABP TAR Fixes
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_return_status                   out nocopy varchar2
  ,p_api_warning                     out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 529


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

Line: 535


  savepoint update_pension_type_swi;

Line: 556


  pqp_pension_types_api.update_pension_type
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_pension_type_id              => p_pension_type_id
    ,p_object_version_number        => p_object_version_number
    ,p_pension_type_name            => p_pension_type_name
    ,p_pension_category             => p_pension_category
    ,p_pension_provider_type        => p_pension_provider_type
    ,p_salary_calculation_method    => p_salary_calculation_method
    ,p_threshold_conversion_rule    => p_threshold_conversion_rule
    ,p_contribution_conversion_rule => p_contribution_conversion_rule
    ,p_er_annual_limit              => p_er_annual_limit
    ,p_ee_annual_limit              => p_ee_annual_limit
    ,p_er_annual_salary_threshold   => p_er_annual_salary_threshold
    ,p_ee_annual_salary_threshold   => p_ee_annual_salary_threshold
    ,p_business_group_id            => p_business_group_id
    ,p_legislation_code             => p_legislation_code
    ,p_description                  => p_description
    ,p_minimum_age                  => p_minimum_age
    ,p_ee_contribution_percent      => p_ee_contribution_percent
    ,p_maximum_age                  => p_maximum_age
    ,p_er_contribution_percent      => p_er_contribution_percent
    ,p_ee_annual_contribution       => p_ee_annual_contribution
    ,p_er_annual_contribution       => p_er_annual_contribution
    ,p_annual_premium_amount        => p_annual_premium_amount
    ,p_ee_contribution_bal_type_id  => p_ee_contribution_bal_type_id
    ,p_er_contribution_bal_type_id  => p_er_contribution_bal_type_id
    ,p_balance_init_element_type_id => p_balance_init_element_type_id
    ,p_ee_contribution_fixed_rate   => p_ee_contribution_fixed_rate   --added for UK
    ,p_er_contribution_fixed_rate   => p_er_contribution_fixed_rate   --added for UK
    ,p_pty_attribute_category       => p_pty_attribute_category
    ,p_pty_attribute1               => p_pty_attribute1
    ,p_pty_attribute2               => p_pty_attribute2
    ,p_pty_attribute3               => p_pty_attribute3
    ,p_pty_attribute4               => p_pty_attribute4
    ,p_pty_attribute5               => p_pty_attribute5
    ,p_pty_attribute6               => p_pty_attribute6
    ,p_pty_attribute7               => p_pty_attribute7
    ,p_pty_attribute8               => p_pty_attribute8
    ,p_pty_attribute9               => p_pty_attribute9
    ,p_pty_attribute10              => p_pty_attribute10
    ,p_pty_attribute11              => p_pty_attribute11
    ,p_pty_attribute12              => p_pty_attribute12
    ,p_pty_attribute13              => p_pty_attribute13
    ,p_pty_attribute14              => p_pty_attribute14
    ,p_pty_attribute15              => p_pty_attribute15
    ,p_pty_attribute16              => p_pty_attribute16
    ,p_pty_attribute17              => p_pty_attribute17
    ,p_pty_attribute18              => p_pty_attribute18
    ,p_pty_attribute19              => p_pty_attribute19
    ,p_pty_attribute20              => p_pty_attribute20
    ,p_pty_information_category     => p_pty_information_category
    ,p_pty_information1             => p_pty_information1
    ,p_pty_information2             => p_pty_information2
    ,p_pty_information3             => p_pty_information3
    ,p_pty_information4             => p_pty_information4
    ,p_pty_information5             => p_pty_information5
    ,p_pty_information6             => p_pty_information6
    ,p_pty_information7             => p_pty_information7
    ,p_pty_information8             => p_pty_information8
    ,p_pty_information9             => p_pty_information9
    ,p_pty_information10            => p_pty_information10
    ,p_pty_information11            => p_pty_information11
    ,p_pty_information12            => p_pty_information12
    ,p_pty_information13            => p_pty_information13
    ,p_pty_information14            => p_pty_information14
    ,p_pty_information15            => p_pty_information15
    ,p_pty_information16            => p_pty_information16
    ,p_pty_information17            => p_pty_information17
    ,p_pty_information18            => p_pty_information18
    ,p_pty_information19            => p_pty_information19
    ,p_pty_information20            => p_pty_information20
    ,p_special_pension_type_code    => p_special_pension_type_code     -- added for NL Phase 2B
    ,p_pension_sub_category         => p_pension_sub_category          -- added for NL Phase 2B
    ,p_pension_basis_calc_method    => p_pension_basis_calc_method     -- added for NL Phase 2B
    ,p_pension_salary_balance       => p_pension_salary_balance        -- added for NL Phase 2B
    ,p_recurring_bonus_percent      => p_recurring_bonus_percent       -- added for NL Phase 2B
    ,p_non_recurring_bonus_percent  => p_non_recurring_bonus_percent   -- added for NL Phase 2B
    ,p_recurring_bonus_balance      => p_recurring_bonus_balance       -- added for NL Phase 2B
    ,p_non_recurring_bonus_balance  => p_non_recurring_bonus_balance   -- added for NL Phase 2B
    ,p_std_tax_reduction            => p_std_tax_reduction             -- added for NL Phase 2B
    ,p_spl_tax_reduction            => p_spl_tax_reduction             -- added for NL Phase 2B
    ,p_sig_sal_spl_tax_reduction    => p_sig_sal_spl_tax_reduction     -- added for NL Phase 2B
    ,p_sig_sal_non_tax_reduction    => p_sig_sal_non_tax_reduction     -- added for NL Phase 2B
    ,p_sig_sal_std_tax_reduction    => p_sig_sal_std_tax_reduction     -- added for NL Phase 2B
    ,p_sii_std_tax_reduction        => p_sii_std_tax_reduction         -- added for NL Phase 2B
    ,p_sii_spl_tax_reduction        => p_sii_spl_tax_reduction         -- added for NL Phase 2B
    ,p_sii_non_tax_reduction        => p_sii_non_tax_reduction         -- added for NL Phase 2B
    ,p_previous_year_bonus_included => p_previous_year_bonus_included  -- added for NL Phase 2B
    ,p_recurring_bonus_period       => p_recurring_bonus_period        -- added for NL Phase 2B
    ,p_non_recurring_bonus_period   => p_non_recurring_bonus_period    -- added for NL Phase 2B
    ,p_ee_age_threshold             => p_ee_age_threshold              -- added for ABP TAR Fixes
    ,p_er_age_threshold             => p_er_age_threshold              -- added for ABP TAR Fixes
    ,p_ee_age_contribution          => p_ee_age_contribution           -- added for ABP TAR Fixes
    ,p_er_age_contribution          => p_er_age_contribution           -- added for ABP TAR Fixes
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    ,p_api_warning                  => p_api_warning
    );

Line: 678


    rollback to update_pension_type_swi;

Line: 695


    rollback to update_pension_type_swi;

Line: 709


End Update_Pension_Type;