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.
PACKAGE BODY: APPS.PQP_PENSION_TYPES_BK1

Source


1 package body PQP_PENSION_TYPES_BK1 as
2 /* $Header: pqptyapi.pkb 120.4.12000000.2 2007/04/11 03:19:41 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/10/22 07:17:40 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_PENSION_TYPE_A
6 (P_VALIDATE in BOOLEAN
7 ,P_EFFECTIVE_DATE in DATE
8 ,P_PENSION_TYPE_NAME in VARCHAR2
9 ,P_PENSION_CATEGORY in VARCHAR2
10 ,P_PENSION_PROVIDER_TYPE in VARCHAR2
11 ,P_SALARY_CALCULATION_METHOD in VARCHAR2
12 ,P_THRESHOLD_CONVERSION_RULE in VARCHAR2
13 ,P_CONTRIBUTION_CONVERSION_RULE in VARCHAR2
14 ,P_ER_ANNUAL_LIMIT in NUMBER
15 ,P_EE_ANNUAL_LIMIT in NUMBER
16 ,P_ER_ANNUAL_SALARY_THRESHOLD in NUMBER
17 ,P_EE_ANNUAL_SALARY_THRESHOLD in NUMBER
18 ,P_BUSINESS_GROUP_ID in NUMBER
19 ,P_LEGISLATION_CODE in VARCHAR2
20 ,P_DESCRIPTION in VARCHAR2
21 ,P_MINIMUM_AGE in NUMBER
22 ,P_EE_CONTRIBUTION_PERCENT in NUMBER
23 ,P_MAXIMUM_AGE in NUMBER
24 ,P_ER_CONTRIBUTION_PERCENT in NUMBER
25 ,P_EE_ANNUAL_CONTRIBUTION in NUMBER
26 ,P_ER_ANNUAL_CONTRIBUTION in NUMBER
27 ,P_ANNUAL_PREMIUM_AMOUNT in NUMBER
28 ,P_EE_CONTRIBUTION_BAL_TYPE_ID in NUMBER
29 ,P_ER_CONTRIBUTION_BAL_TYPE_ID in NUMBER
30 ,P_BALANCE_INIT_ELEMENT_TYPE_ID in NUMBER
31 ,P_EE_CONTRIBUTION_FIXED_RATE in NUMBER
32 ,P_ER_CONTRIBUTION_FIXED_RATE in NUMBER
33 ,P_PTY_ATTRIBUTE_CATEGORY in VARCHAR2
34 ,P_PTY_ATTRIBUTE1 in VARCHAR2
35 ,P_PTY_ATTRIBUTE2 in VARCHAR2
36 ,P_PTY_ATTRIBUTE3 in VARCHAR2
37 ,P_PTY_ATTRIBUTE4 in VARCHAR2
38 ,P_PTY_ATTRIBUTE5 in VARCHAR2
39 ,P_PTY_ATTRIBUTE6 in VARCHAR2
40 ,P_PTY_ATTRIBUTE7 in VARCHAR2
41 ,P_PTY_ATTRIBUTE8 in VARCHAR2
42 ,P_PTY_ATTRIBUTE9 in VARCHAR2
43 ,P_PTY_ATTRIBUTE10 in VARCHAR2
44 ,P_PTY_ATTRIBUTE11 in VARCHAR2
45 ,P_PTY_ATTRIBUTE12 in VARCHAR2
46 ,P_PTY_ATTRIBUTE13 in VARCHAR2
47 ,P_PTY_ATTRIBUTE14 in VARCHAR2
48 ,P_PTY_ATTRIBUTE15 in VARCHAR2
49 ,P_PTY_ATTRIBUTE16 in VARCHAR2
50 ,P_PTY_ATTRIBUTE17 in VARCHAR2
51 ,P_PTY_ATTRIBUTE18 in VARCHAR2
52 ,P_PTY_ATTRIBUTE19 in VARCHAR2
53 ,P_PTY_ATTRIBUTE20 in VARCHAR2
54 ,P_PTY_INFORMATION_CATEGORY in VARCHAR2
55 ,P_PTY_INFORMATION1 in VARCHAR2
56 ,P_PTY_INFORMATION2 in VARCHAR2
57 ,P_PTY_INFORMATION3 in VARCHAR2
58 ,P_PTY_INFORMATION4 in VARCHAR2
59 ,P_PTY_INFORMATION5 in VARCHAR2
60 ,P_PTY_INFORMATION6 in VARCHAR2
61 ,P_PTY_INFORMATION7 in VARCHAR2
62 ,P_PTY_INFORMATION8 in VARCHAR2
63 ,P_PTY_INFORMATION9 in VARCHAR2
64 ,P_PTY_INFORMATION10 in VARCHAR2
65 ,P_PTY_INFORMATION11 in VARCHAR2
66 ,P_PTY_INFORMATION12 in VARCHAR2
67 ,P_PTY_INFORMATION13 in VARCHAR2
68 ,P_PTY_INFORMATION14 in VARCHAR2
69 ,P_PTY_INFORMATION15 in VARCHAR2
70 ,P_PTY_INFORMATION16 in VARCHAR2
71 ,P_PTY_INFORMATION17 in VARCHAR2
72 ,P_PTY_INFORMATION18 in VARCHAR2
73 ,P_PTY_INFORMATION19 in VARCHAR2
74 ,P_PTY_INFORMATION20 in VARCHAR2
75 ,P_SPECIAL_PENSION_TYPE_CODE in VARCHAR2
76 ,P_PENSION_SUB_CATEGORY in VARCHAR2
77 ,P_PENSION_BASIS_CALC_METHOD in VARCHAR2
78 ,P_PENSION_SALARY_BALANCE in NUMBER
79 ,P_RECURRING_BONUS_PERCENT in NUMBER
80 ,P_NON_RECURRING_BONUS_PERCENT in NUMBER
81 ,P_RECURRING_BONUS_BALANCE in NUMBER
82 ,P_NON_RECURRING_BONUS_BALANCE in NUMBER
83 ,P_STD_TAX_REDUCTION in VARCHAR2
84 ,P_SPL_TAX_REDUCTION in VARCHAR2
85 ,P_SIG_SAL_SPL_TAX_REDUCTION in VARCHAR2
86 ,P_SIG_SAL_NON_TAX_REDUCTION in VARCHAR2
87 ,P_SIG_SAL_STD_TAX_REDUCTION in VARCHAR2
88 ,P_SII_STD_TAX_REDUCTION in VARCHAR2
89 ,P_SII_SPL_TAX_REDUCTION in VARCHAR2
90 ,P_SII_NON_TAX_REDUCTION in VARCHAR2
91 ,P_PREVIOUS_YEAR_BONUS_INCLUDED in VARCHAR2
92 ,P_RECURRING_BONUS_PERIOD in VARCHAR2
93 ,P_NON_RECURRING_BONUS_PERIOD in VARCHAR2
94 ,P_EE_AGE_THRESHOLD in VARCHAR2
95 ,P_ER_AGE_THRESHOLD in VARCHAR2
96 ,P_EE_AGE_CONTRIBUTION in VARCHAR2
97 ,P_ER_AGE_CONTRIBUTION in VARCHAR2
98 ,P_PENSION_TYPE_ID in NUMBER
99 ,P_OBJECT_VERSION_NUMBER in NUMBER
100 ,P_EFFECTIVE_START_DATE in DATE
101 ,P_EFFECTIVE_END_DATE in DATE
102 ,P_API_WARNING in VARCHAR2
103 )is
104 begin
105 hr_utility.set_location('Entering: PQP_PENSION_TYPES_BK1.CREATE_PENSION_TYPE_A', 10);
106 hr_utility.set_location(' Leaving: PQP_PENSION_TYPES_BK1.CREATE_PENSION_TYPE_A', 20);
107 end CREATE_PENSION_TYPE_A;
108 procedure CREATE_PENSION_TYPE_B
109 (P_VALIDATE in BOOLEAN
110 ,P_EFFECTIVE_DATE in DATE
111 ,P_PENSION_TYPE_NAME in VARCHAR2
112 ,P_PENSION_CATEGORY in VARCHAR2
113 ,P_PENSION_PROVIDER_TYPE in VARCHAR2
114 ,P_SALARY_CALCULATION_METHOD in VARCHAR2
115 ,P_THRESHOLD_CONVERSION_RULE in VARCHAR2
116 ,P_CONTRIBUTION_CONVERSION_RULE in VARCHAR2
117 ,P_ER_ANNUAL_LIMIT in NUMBER
118 ,P_EE_ANNUAL_LIMIT in NUMBER
119 ,P_ER_ANNUAL_SALARY_THRESHOLD in NUMBER
120 ,P_EE_ANNUAL_SALARY_THRESHOLD in NUMBER
121 ,P_BUSINESS_GROUP_ID in NUMBER
122 ,P_LEGISLATION_CODE in VARCHAR2
123 ,P_DESCRIPTION in VARCHAR2
124 ,P_MINIMUM_AGE in NUMBER
125 ,P_EE_CONTRIBUTION_PERCENT in NUMBER
126 ,P_MAXIMUM_AGE in NUMBER
127 ,P_ER_CONTRIBUTION_PERCENT in NUMBER
128 ,P_EE_ANNUAL_CONTRIBUTION in NUMBER
129 ,P_ER_ANNUAL_CONTRIBUTION in NUMBER
130 ,P_ANNUAL_PREMIUM_AMOUNT in NUMBER
131 ,P_EE_CONTRIBUTION_BAL_TYPE_ID in NUMBER
132 ,P_ER_CONTRIBUTION_BAL_TYPE_ID in NUMBER
133 ,P_BALANCE_INIT_ELEMENT_TYPE_ID in NUMBER
134 ,P_EE_CONTRIBUTION_FIXED_RATE in NUMBER
135 ,P_ER_CONTRIBUTION_FIXED_RATE in NUMBER
136 ,P_PTY_ATTRIBUTE_CATEGORY in VARCHAR2
137 ,P_PTY_ATTRIBUTE1 in VARCHAR2
138 ,P_PTY_ATTRIBUTE2 in VARCHAR2
139 ,P_PTY_ATTRIBUTE3 in VARCHAR2
140 ,P_PTY_ATTRIBUTE4 in VARCHAR2
141 ,P_PTY_ATTRIBUTE5 in VARCHAR2
142 ,P_PTY_ATTRIBUTE6 in VARCHAR2
143 ,P_PTY_ATTRIBUTE7 in VARCHAR2
144 ,P_PTY_ATTRIBUTE8 in VARCHAR2
145 ,P_PTY_ATTRIBUTE9 in VARCHAR2
146 ,P_PTY_ATTRIBUTE10 in VARCHAR2
147 ,P_PTY_ATTRIBUTE11 in VARCHAR2
148 ,P_PTY_ATTRIBUTE12 in VARCHAR2
149 ,P_PTY_ATTRIBUTE13 in VARCHAR2
150 ,P_PTY_ATTRIBUTE14 in VARCHAR2
151 ,P_PTY_ATTRIBUTE15 in VARCHAR2
152 ,P_PTY_ATTRIBUTE16 in VARCHAR2
153 ,P_PTY_ATTRIBUTE17 in VARCHAR2
154 ,P_PTY_ATTRIBUTE18 in VARCHAR2
155 ,P_PTY_ATTRIBUTE19 in VARCHAR2
156 ,P_PTY_ATTRIBUTE20 in VARCHAR2
157 ,P_PTY_INFORMATION_CATEGORY in VARCHAR2
158 ,P_PTY_INFORMATION1 in VARCHAR2
159 ,P_PTY_INFORMATION2 in VARCHAR2
160 ,P_PTY_INFORMATION3 in VARCHAR2
161 ,P_PTY_INFORMATION4 in VARCHAR2
162 ,P_PTY_INFORMATION5 in VARCHAR2
163 ,P_PTY_INFORMATION6 in VARCHAR2
164 ,P_PTY_INFORMATION7 in VARCHAR2
165 ,P_PTY_INFORMATION8 in VARCHAR2
166 ,P_PTY_INFORMATION9 in VARCHAR2
167 ,P_PTY_INFORMATION10 in VARCHAR2
168 ,P_PTY_INFORMATION11 in VARCHAR2
169 ,P_PTY_INFORMATION12 in VARCHAR2
170 ,P_PTY_INFORMATION13 in VARCHAR2
171 ,P_PTY_INFORMATION14 in VARCHAR2
172 ,P_PTY_INFORMATION15 in VARCHAR2
173 ,P_PTY_INFORMATION16 in VARCHAR2
174 ,P_PTY_INFORMATION17 in VARCHAR2
175 ,P_PTY_INFORMATION18 in VARCHAR2
176 ,P_PTY_INFORMATION19 in VARCHAR2
177 ,P_PTY_INFORMATION20 in VARCHAR2
178 ,P_SPECIAL_PENSION_TYPE_CODE in VARCHAR2
179 ,P_PENSION_SUB_CATEGORY in VARCHAR2
180 ,P_PENSION_BASIS_CALC_METHOD in VARCHAR2
181 ,P_PENSION_SALARY_BALANCE in NUMBER
182 ,P_RECURRING_BONUS_PERCENT in NUMBER
183 ,P_NON_RECURRING_BONUS_PERCENT in NUMBER
184 ,P_RECURRING_BONUS_BALANCE in NUMBER
185 ,P_NON_RECURRING_BONUS_BALANCE in NUMBER
186 ,P_STD_TAX_REDUCTION in VARCHAR2
187 ,P_SPL_TAX_REDUCTION in VARCHAR2
188 ,P_SIG_SAL_SPL_TAX_REDUCTION in VARCHAR2
189 ,P_SIG_SAL_NON_TAX_REDUCTION in VARCHAR2
190 ,P_SIG_SAL_STD_TAX_REDUCTION in VARCHAR2
191 ,P_SII_STD_TAX_REDUCTION in VARCHAR2
192 ,P_SII_SPL_TAX_REDUCTION in VARCHAR2
193 ,P_SII_NON_TAX_REDUCTION in VARCHAR2
194 ,P_PREVIOUS_YEAR_BONUS_INCLUDED in VARCHAR2
195 ,P_RECURRING_BONUS_PERIOD in VARCHAR2
196 ,P_NON_RECURRING_BONUS_PERIOD in VARCHAR2
197 ,P_EE_AGE_THRESHOLD in VARCHAR2
198 ,P_ER_AGE_THRESHOLD in VARCHAR2
199 ,P_EE_AGE_CONTRIBUTION in VARCHAR2
200 ,P_ER_AGE_CONTRIBUTION in VARCHAR2
201 )is
202 begin
203 hr_utility.set_location('Entering: PQP_PENSION_TYPES_BK1.CREATE_PENSION_TYPE_B', 10);
204 hr_utility.set_location(' Leaving: PQP_PENSION_TYPES_BK1.CREATE_PENSION_TYPE_B', 20);
205 end CREATE_PENSION_TYPE_B;
206 end PQP_PENSION_TYPES_BK1;