DBA Data[Home] [Help]

PACKAGE: APPS.PQP_PENSION_TYPES_BK1

Source


1 Package PQP_Pension_Types_BK1 As
2 /* $Header: pqptyapi.pkh 120.1.12000000.1 2007/01/16 04:28:57 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------< Create_Pension_Type_b >-------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 Procedure Create_Pension_Type_b
9   (p_validate                     in Boolean
10   ,p_effective_date               in date
11   ,p_pension_type_name            in varchar2
12   ,p_pension_category             in varchar2
13   ,p_pension_provider_type        in varchar2
14   ,p_salary_calculation_method    in varchar2
15   ,p_threshold_conversion_rule    in varchar2
16   ,p_contribution_conversion_rule in varchar2
17   ,p_er_annual_limit              in number
18   ,p_ee_annual_limit              in number
19   ,p_er_annual_salary_threshold   in number
20   ,p_ee_annual_salary_threshold   in number
21   ,p_business_group_id            in number
22   ,p_legislation_code             in varchar2
23   ,p_description                  in varchar2
24   ,p_minimum_age                  in number
25   ,p_ee_contribution_percent      in number
26   ,p_maximum_age                  in number
27   ,p_er_contribution_percent      in number
28   ,p_ee_annual_contribution       in number
29   ,p_er_annual_contribution       in number
30   ,p_annual_premium_amount        in number
31   ,p_ee_contribution_bal_type_id  in number
32   ,p_er_contribution_bal_type_id  in number
33   ,p_balance_init_element_type_id in number
34   ,p_ee_contribution_fixed_rate   in number --added for UK
35   ,p_er_contribution_fixed_rate   in number --added for UK
36   ,p_pty_attribute_category       in varchar2
37   ,p_pty_attribute1               in varchar2
38   ,p_pty_attribute2               in varchar2
39   ,p_pty_attribute3               in varchar2
40   ,p_pty_attribute4               in varchar2
41   ,p_pty_attribute5               in varchar2
42   ,p_pty_attribute6               in varchar2
43   ,p_pty_attribute7               in varchar2
44   ,p_pty_attribute8               in varchar2
45   ,p_pty_attribute9               in varchar2
46   ,p_pty_attribute10              in varchar2
47   ,p_pty_attribute11              in varchar2
48   ,p_pty_attribute12              in varchar2
49   ,p_pty_attribute13              in varchar2
50   ,p_pty_attribute14              in varchar2
51   ,p_pty_attribute15              in varchar2
52   ,p_pty_attribute16              in varchar2
53   ,p_pty_attribute17              in varchar2
54   ,p_pty_attribute18              in varchar2
55   ,p_pty_attribute19              in varchar2
56   ,p_pty_attribute20              in varchar2
57   ,p_pty_information_category     in varchar2
58   ,p_pty_information1             in varchar2
59   ,p_pty_information2             in varchar2
60   ,p_pty_information3             in varchar2
61   ,p_pty_information4             in varchar2
62   ,p_pty_information5             in varchar2
63   ,p_pty_information6             in varchar2
64   ,p_pty_information7             in varchar2
65   ,p_pty_information8             in varchar2
66   ,p_pty_information9             in varchar2
67   ,p_pty_information10            in varchar2
68   ,p_pty_information11            in varchar2
69   ,p_pty_information12            in varchar2
70   ,p_pty_information13            in varchar2
71   ,p_pty_information14            in varchar2
72   ,p_pty_information15            in varchar2
73   ,p_pty_information16            in varchar2
74   ,p_pty_information17            in varchar2
75   ,p_pty_information18            in varchar2
76   ,p_pty_information19            in varchar2
77   ,p_pty_information20            in varchar2
78   ,p_special_pension_type_code    in varchar2    -- added for NL Phase 2B
79   ,p_pension_sub_category         in varchar2    -- added for NL Phase 2B
80   ,p_pension_basis_calc_method    in varchar2    -- added for NL Phase 2B
81   ,p_pension_salary_balance       in number      -- added for NL Phase 2B
82   ,p_recurring_bonus_percent      in number      -- added for NL Phase 2B
83   ,p_non_recurring_bonus_percent  in number      -- added for NL Phase 2B
84   ,p_recurring_bonus_balance      in number      -- added for NL Phase 2B
85   ,p_non_recurring_bonus_balance  in number      -- added for NL Phase 2B
86   ,p_std_tax_reduction            in varchar2    -- added for NL Phase 2B
87   ,p_spl_tax_reduction            in varchar2    -- added for NL Phase 2B
88   ,p_sig_sal_spl_tax_reduction    in varchar2    -- added for NL Phase 2B
89   ,p_sig_sal_non_tax_reduction    in varchar2    -- added for NL Phase 2B
90   ,p_sig_sal_std_tax_reduction    in varchar2    -- added for NL Phase 2B
91   ,p_sii_std_tax_reduction        in varchar2    -- added for NL Phase 2B
92   ,p_sii_spl_tax_reduction        in varchar2    -- added for NL Phase 2B
93   ,p_sii_non_tax_reduction        in varchar2    -- added for NL Phase 2B
94   ,p_previous_year_bonus_included in varchar2    -- added for NL Phase 2B
95   ,p_recurring_bonus_period       in varchar2    -- added for NL Phase 2B
96   ,p_non_recurring_bonus_period   in varchar2    -- added for NL Phase 2B
97   ,p_ee_age_threshold             in varchar2    -- added for ABP TAR fixes
98   ,p_er_age_threshold             in varchar2    -- added for ABP TAR fixes
99   ,p_ee_age_contribution          in varchar2    -- added for ABP TAR fixes
100   ,p_er_age_contribution          in varchar2    -- added for ABP TAR fixes
101   );
102 --
103 -- ----------------------------------------------------------------------------
104 -- |-------------------------< Create_Pension_Type_a >-------------------------|
105 -- ----------------------------------------------------------------------------
106 --
107 Procedure Create_Pension_Type_a
108   (p_validate                     in Boolean
109   ,p_effective_date               in date
110   ,p_pension_type_name            in varchar2
111   ,p_pension_category             in varchar2
112   ,p_pension_provider_type        in varchar2
113   ,p_salary_calculation_method    in varchar2
114   ,p_threshold_conversion_rule    in varchar2
115   ,p_contribution_conversion_rule in varchar2
116   ,p_er_annual_limit              in number
117   ,p_ee_annual_limit              in number
118   ,p_er_annual_salary_threshold   in number
119   ,p_ee_annual_salary_threshold   in number
120   ,p_business_group_id            in number
121   ,p_legislation_code             in varchar2
122   ,p_description                  in varchar2
123   ,p_minimum_age                  in number
124   ,p_ee_contribution_percent      in number
125   ,p_maximum_age                  in number
126   ,p_er_contribution_percent      in number
127   ,p_ee_annual_contribution       in number
128   ,p_er_annual_contribution       in number
129   ,p_annual_premium_amount        in number
130   ,p_ee_contribution_bal_type_id  in number
131   ,p_er_contribution_bal_type_id  in number
132   ,p_balance_init_element_type_id in number
133   ,p_ee_contribution_fixed_rate   in number --added for UK
134   ,p_er_contribution_fixed_rate   in number --added for UK
135   ,p_pty_attribute_category       in varchar2
136   ,p_pty_attribute1               in varchar2
137   ,p_pty_attribute2               in varchar2
138   ,p_pty_attribute3               in varchar2
139   ,p_pty_attribute4               in varchar2
140   ,p_pty_attribute5               in varchar2
141   ,p_pty_attribute6               in varchar2
142   ,p_pty_attribute7               in varchar2
143   ,p_pty_attribute8               in varchar2
144   ,p_pty_attribute9               in varchar2
145   ,p_pty_attribute10              in varchar2
146   ,p_pty_attribute11              in varchar2
147   ,p_pty_attribute12              in varchar2
148   ,p_pty_attribute13              in varchar2
149   ,p_pty_attribute14              in varchar2
150   ,p_pty_attribute15              in varchar2
151   ,p_pty_attribute16              in varchar2
152   ,p_pty_attribute17              in varchar2
153   ,p_pty_attribute18              in varchar2
154   ,p_pty_attribute19              in varchar2
155   ,p_pty_attribute20              in varchar2
156   ,p_pty_information_category     in varchar2
157   ,p_pty_information1             in varchar2
158   ,p_pty_information2             in varchar2
159   ,p_pty_information3             in varchar2
160   ,p_pty_information4             in varchar2
161   ,p_pty_information5             in varchar2
162   ,p_pty_information6             in varchar2
163   ,p_pty_information7             in varchar2
164   ,p_pty_information8             in varchar2
165   ,p_pty_information9             in varchar2
166   ,p_pty_information10            in varchar2
167   ,p_pty_information11            in varchar2
168   ,p_pty_information12            in varchar2
169   ,p_pty_information13            in varchar2
170   ,p_pty_information14            in varchar2
171   ,p_pty_information15            in varchar2
172   ,p_pty_information16            in varchar2
173   ,p_pty_information17            in varchar2
174   ,p_pty_information18            in varchar2
175   ,p_pty_information19            in varchar2
176   ,p_pty_information20            in varchar2
177   ,p_special_pension_type_code    in varchar2    -- added for NL Phase 2B
178   ,p_pension_sub_category         in varchar2    -- added for NL Phase 2B
179   ,p_pension_basis_calc_method    in varchar2    -- added for NL Phase 2B
180   ,p_pension_salary_balance       in number      -- added for NL Phase 2B
181   ,p_recurring_bonus_percent      in number      -- added for NL Phase 2B
182   ,p_non_recurring_bonus_percent  in number      -- added for NL Phase 2B
183   ,p_recurring_bonus_balance      in number      -- added for NL Phase 2B
184   ,p_non_recurring_bonus_balance  in number      -- added for NL Phase 2B
185   ,p_std_tax_reduction            in varchar2    -- added for NL Phase 2B
186   ,p_spl_tax_reduction            in varchar2    -- added for NL Phase 2B
187   ,p_sig_sal_spl_tax_reduction    in varchar2    -- added for NL Phase 2B
188   ,p_sig_sal_non_tax_reduction    in varchar2    -- added for NL Phase 2B
189   ,p_sig_sal_std_tax_reduction    in varchar2    -- added for NL Phase 2B
190   ,p_sii_std_tax_reduction        in varchar2    -- added for NL Phase 2B
191   ,p_sii_spl_tax_reduction        in varchar2    -- added for NL Phase 2B
192   ,p_sii_non_tax_reduction        in varchar2    -- added for NL Phase 2B
193   ,p_previous_year_bonus_included in varchar2    -- added for NL Phase 2B
194   ,p_recurring_bonus_period       in varchar2    -- added for NL Phase 2B
195   ,p_non_recurring_bonus_period   in varchar2    -- added for NL Phase 2B
196   ,p_ee_age_threshold             in varchar2    -- added for ABP TAR fixes
197   ,p_er_age_threshold             in varchar2    -- added for ABP TAR fixes
198   ,p_ee_age_contribution          in varchar2    -- added for ABP TAR fixes
199   ,p_er_age_contribution          in varchar2    -- added for ABP TAR fixes
200   ,p_pension_type_id              in number
201   ,p_object_version_number        in number
202   ,p_effective_start_date         in date
203   ,p_effective_end_date           in date
204   ,p_api_warning                  in varchar2
205   );
206 --
207 end PQP_Pension_Types_BK1;