DBA Data[Home] [Help]

PACKAGE: APPS.PQP_PTY_RKD

Source


1 Package pqp_pty_rkd as
2 /* $Header: pqptyrhi.pkh 120.0.12000000.1 2007/01/16 04:29:04 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_delete >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_delete
9   (p_effective_date                 in date
10   ,p_datetrack_mode                 in varchar2
11   ,p_validation_start_date          in date
12   ,p_validation_end_date            in date
13   ,p_pension_type_id                in number
14   ,p_effective_start_date           in date
15   ,p_effective_end_date             in date
16   ,p_effective_start_date_o         in date
17   ,p_effective_end_date_o           in date
18   ,p_pension_type_name_o            in varchar2
19   ,p_pension_category_o             in varchar2
20   ,p_pension_provider_type_o        in varchar2
21   ,p_salary_calculation_method_o    in varchar2
22   ,p_threshold_conversion_rule_o    in varchar2
23   ,p_contribution_conversion_ru_o   in varchar2
24   ,p_er_annual_limit_o              in number
25   ,p_ee_annual_limit_o              in number
26   ,p_er_annual_salary_threshold_o   in number
27   ,p_ee_annual_salary_threshold_o   in number
28   ,p_object_version_number_o        in number
29   ,p_business_group_id_o            in number
30   ,p_legislation_code_o             in varchar2
31   ,p_description_o                  in varchar2
32   ,p_minimum_age_o                  in number
33   ,p_ee_contribution_percent_o      in number
34   ,p_maximum_age_o                  in number
35   ,p_er_contribution_percent_o      in number
36   ,p_ee_annual_contribution_o       in number
37   ,p_er_annual_contribution_o       in number
38   ,p_annual_premium_amount_o        in number
39   ,p_ee_contribution_bal_type_i_o   in number
40   ,p_er_contribution_bal_type_i_o   in number
41   ,p_balance_init_element_type__o   in number
42   ,p_ee_contribution_fixed_rate_o   in number  --added for UK
43   ,p_er_contribution_fixed_rate_o   in number  --added for UK
44   ,p_pty_attribute_category_o       in varchar2
45   ,p_pty_attribute1_o               in varchar2
46   ,p_pty_attribute2_o               in varchar2
47   ,p_pty_attribute3_o               in varchar2
48   ,p_pty_attribute4_o               in varchar2
49   ,p_pty_attribute5_o               in varchar2
50   ,p_pty_attribute6_o               in varchar2
51   ,p_pty_attribute7_o               in varchar2
52   ,p_pty_attribute8_o               in varchar2
53   ,p_pty_attribute9_o               in varchar2
54   ,p_pty_attribute10_o              in varchar2
55   ,p_pty_attribute11_o              in varchar2
56   ,p_pty_attribute12_o              in varchar2
57   ,p_pty_attribute13_o              in varchar2
58   ,p_pty_attribute14_o              in varchar2
59   ,p_pty_attribute15_o              in varchar2
60   ,p_pty_attribute16_o              in varchar2
61   ,p_pty_attribute17_o              in varchar2
62   ,p_pty_attribute18_o              in varchar2
63   ,p_pty_attribute19_o              in varchar2
64   ,p_pty_attribute20_o              in varchar2
65   ,p_pty_information_category_o     in varchar2
66   ,p_pty_information1_o             in varchar2
67   ,p_pty_information2_o             in varchar2
68   ,p_pty_information3_o             in varchar2
69   ,p_pty_information4_o             in varchar2
70   ,p_pty_information5_o             in varchar2
71   ,p_pty_information6_o             in varchar2
72   ,p_pty_information7_o             in varchar2
73   ,p_pty_information8_o             in varchar2
74   ,p_pty_information9_o             in varchar2
75   ,p_pty_information10_o            in varchar2
76   ,p_pty_information11_o            in varchar2
77   ,p_pty_information12_o            in varchar2
78   ,p_pty_information13_o            in varchar2
79   ,p_pty_information14_o            in varchar2
80   ,p_pty_information15_o            in varchar2
81   ,p_pty_information16_o            in varchar2
82   ,p_pty_information17_o            in varchar2
83   ,p_pty_information18_o            in varchar2
84   ,p_pty_information19_o            in varchar2
85   ,p_pty_information20_o            in varchar2
86   ,p_special_pension_type_code_o    in varchar2    -- added for NL Phase 2B
87   ,p_pension_sub_category_o         in varchar2    -- added for NL Phase 2B
88   ,p_pension_basis_calc_method_o    in varchar2    -- added for NL Phase 2B
89   ,p_pension_salary_balance_o       in number      -- added for NL Phase 2B
90   ,p_recurring_bonus_percent_o      in number      -- added for NL Phase 2B
91   ,p_non_recur_bonus_percent_o      in number      -- added for NL Phase 2B
92   ,p_recurring_bonus_balance_o      in number      -- added for NL Phase 2B
93   ,p_non_recur_bonus_balance_o      in number      -- added for NL Phase 2B
94   ,p_std_tax_reduction_o            in varchar2    -- added for NL Phase 2B
95   ,p_spl_tax_reduction_o            in varchar2    -- added for NL Phase 2B
96   ,p_sig_sal_spl_tax_reduction_o    in varchar2    -- added for NL Phase 2B
97   ,p_sig_sal_non_tax_reduction_o    in varchar2    -- added for NL Phase 2B
98   ,p_sig_sal_std_tax_reduction_o    in varchar2    -- added for NL Phase 2B
99   ,p_sii_std_tax_reduction_o        in varchar2    -- added for NL Phase 2B
100   ,p_sii_spl_tax_reduction_o        in varchar2    -- added for NL Phase 2B
101   ,p_sii_non_tax_reduction_o        in varchar2    -- added for NL Phase 2B
102   ,p_prev_year_bonus_include_o      in varchar2    -- added for NL Phase 2B
103   ,p_recurring_bonus_period_o       in varchar2    -- added for NL Phase 2B
104   ,p_non_recurring_bonus_period_o   in varchar2    -- added for NL Phase 2B
105   ,p_ee_age_threshold_o             in varchar2    -- added for ABP TAR Fixes
106   ,p_er_age_threshold_o             in varchar2    -- added for ABP TAR Fixes
107   ,p_ee_age_contribution_o          in varchar2    -- added for ABP TAR Fixes
108   ,p_er_age_contribution_o          in varchar2    -- added for ABP TAR Fixes
109   );
110 --
111 end pqp_pty_rkd;