1 Package pay_payroll_bk2 as
2 /* $Header: pyprlapi.pkh 120.13 2007/11/20 06:17:36 pgongada noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------< update_payroll_b >-----------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_payroll_b
9 (
10 p_effective_date in date,
11 p_datetrack_mode in varchar2,
12 p_payroll_id in number,
13 p_object_version_number in number,
14 p_payroll_name in varchar2 ,
15 p_number_of_years in number ,
16 p_default_payment_method_id in number ,
17 p_consolidation_set_id in number ,
18 p_cost_alloc_keyflex_id_in in number ,
19 p_susp_account_keyflex_id_in in number ,
20 p_negative_pay_allowed_flag in varchar2 ,
21 p_soft_coding_keyflex_id_in in number ,
22 p_comments in varchar2 ,
23 p_attribute_category in varchar2 ,
24 p_attribute1 in varchar2 ,
25 p_attribute2 in varchar2 ,
26 p_attribute3 in varchar2 ,
27 p_attribute4 in varchar2 ,
28 p_attribute5 in varchar2 ,
29 p_attribute6 in varchar2 ,
30 p_attribute7 in varchar2 ,
31 p_attribute8 in varchar2 ,
32 p_attribute9 in varchar2 ,
33 p_attribute10 in varchar2 ,
34 p_attribute11 in varchar2 ,
35 p_attribute12 in varchar2 ,
36 p_attribute13 in varchar2 ,
37 p_attribute14 in varchar2 ,
38 p_attribute15 in varchar2 ,
39 p_attribute16 in varchar2 ,
40 p_attribute17 in varchar2 ,
41 p_attribute18 in varchar2 ,
42 p_attribute19 in varchar2 ,
43 p_attribute20 in varchar2 ,
44 p_arrears_flag in varchar2 ,
45 p_multi_assignments_flag in varchar2 ,
46 p_prl_information1 in varchar2 ,
47 p_prl_information2 in varchar2 ,
48 p_prl_information3 in varchar2 ,
49 p_prl_information4 in varchar2 ,
50 p_prl_information5 in varchar2 ,
51 p_prl_information6 in varchar2 ,
52 p_prl_information7 in varchar2 ,
53 p_prl_information8 in varchar2 ,
54 p_prl_information9 in varchar2 ,
55 p_prl_information10 in varchar2 ,
56 p_prl_information11 in varchar2 ,
57 p_prl_information12 in varchar2 ,
58 p_prl_information13 in varchar2 ,
59 p_prl_information14 in varchar2 ,
60 p_prl_information15 in varchar2 ,
61 p_prl_information16 in varchar2 ,
62 p_prl_information17 in varchar2 ,
63 p_prl_information18 in varchar2 ,
64 p_prl_information19 in varchar2 ,
65 p_prl_information20 in varchar2 ,
66 p_prl_information21 in varchar2 ,
67 p_prl_information22 in varchar2 ,
68 p_prl_information23 in varchar2 ,
69 p_prl_information24 in varchar2 ,
70 p_prl_information25 in varchar2 ,
71 p_prl_information26 in varchar2 ,
72 p_prl_information27 in varchar2 ,
73 p_prl_information28 in varchar2 ,
74 p_prl_information29 in varchar2 ,
75 p_prl_information30 in varchar2 ,
76
77
78 p_cost_segment1 in varchar2 ,
79 p_cost_segment2 in varchar2 ,
80 p_cost_segment3 in varchar2 ,
81 p_cost_segment4 in varchar2 ,
82 p_cost_segment5 in varchar2 ,
83 p_cost_segment6 in varchar2 ,
84 p_cost_segment7 in varchar2 ,
85 p_cost_segment8 in varchar2 ,
86 p_cost_segment9 in varchar2 ,
87 p_cost_segment10 in varchar2 ,
88 p_cost_segment11 in varchar2 ,
89 p_cost_segment12 in varchar2 ,
90 p_cost_segment13 in varchar2 ,
91 p_cost_segment14 in varchar2 ,
92 p_cost_segment15 in varchar2 ,
93 p_cost_segment16 in varchar2 ,
94 p_cost_segment17 in varchar2 ,
95 p_cost_segment18 in varchar2 ,
96 p_cost_segment19 in varchar2 ,
97 p_cost_segment20 in varchar2 ,
98 p_cost_segment21 in varchar2 ,
99 p_cost_segment22 in varchar2 ,
100 p_cost_segment23 in varchar2 ,
101 p_cost_segment24 in varchar2 ,
102 p_cost_segment25 in varchar2 ,
103 p_cost_segment26 in varchar2 ,
104 p_cost_segment27 in varchar2 ,
105 p_cost_segment28 in varchar2 ,
106 p_cost_segment29 in varchar2 ,
107 p_cost_segment30 in varchar2 ,
108 p_cost_concat_segments_in in varchar2,
109
110 p_susp_segment1 in varchar2 ,
111 p_susp_segment2 in varchar2 ,
112 p_susp_segment3 in varchar2 ,
113 p_susp_segment4 in varchar2 ,
114 p_susp_segment5 in varchar2 ,
115 p_susp_segment6 in varchar2 ,
116 p_susp_segment7 in varchar2 ,
117 p_susp_segment8 in varchar2 ,
118 p_susp_segment9 in varchar2 ,
119 p_susp_segment10 in varchar2 ,
120 p_susp_segment11 in varchar2 ,
121 p_susp_segment12 in varchar2 ,
122 p_susp_segment13 in varchar2 ,
123 p_susp_segment14 in varchar2 ,
124 p_susp_segment15 in varchar2 ,
125 p_susp_segment16 in varchar2 ,
126 p_susp_segment17 in varchar2 ,
127 p_susp_segment18 in varchar2 ,
128 p_susp_segment19 in varchar2 ,
129 p_susp_segment20 in varchar2 ,
130 p_susp_segment21 in varchar2 ,
131 p_susp_segment22 in varchar2 ,
132 p_susp_segment23 in varchar2 ,
133 p_susp_segment24 in varchar2 ,
134 p_susp_segment25 in varchar2 ,
135 p_susp_segment26 in varchar2 ,
136 p_susp_segment27 in varchar2 ,
137 p_susp_segment28 in varchar2 ,
138 p_susp_segment29 in varchar2 ,
139 p_susp_segment30 in varchar2 ,
140 p_susp_concat_segments_in in varchar2,
141
142 p_scl_segment1 in varchar2 ,
143 p_scl_segment2 in varchar2 ,
144 p_scl_segment3 in varchar2 ,
145 p_scl_segment4 in varchar2 ,
146 p_scl_segment5 in varchar2 ,
147 p_scl_segment6 in varchar2 ,
148 p_scl_segment7 in varchar2 ,
149 p_scl_segment8 in varchar2 ,
150 p_scl_segment9 in varchar2 ,
151 p_scl_segment10 in varchar2 ,
152 p_scl_segment11 in varchar2 ,
153 p_scl_segment12 in varchar2 ,
154 p_scl_segment13 in varchar2 ,
155 p_scl_segment14 in varchar2 ,
156 p_scl_segment15 in varchar2 ,
157 p_scl_segment16 in varchar2 ,
158 p_scl_segment17 in varchar2 ,
159 p_scl_segment18 in varchar2 ,
160 p_scl_segment19 in varchar2 ,
161 p_scl_segment20 in varchar2 ,
162 p_scl_segment21 in varchar2 ,
163 p_scl_segment22 in varchar2 ,
164 p_scl_segment23 in varchar2 ,
165 p_scl_segment24 in varchar2 ,
166 p_scl_segment25 in varchar2 ,
167 p_scl_segment26 in varchar2 ,
168 p_scl_segment27 in varchar2 ,
169 p_scl_segment28 in varchar2 ,
170 p_scl_segment29 in varchar2 ,
171 p_scl_segment30 in varchar2 ,
172 p_scl_concat_segments_in in varchar2 ,
173
174 p_business_group_id in number,
175
176 p_workload_shifting_level in varchar2 ,
177 p_payslip_view_date_offset in number
178 );
179 --
180 -- ----------------------------------------------------------------------------
181 -- |-------------------------< update_payroll_a >-----------------------------|
182 -- ----------------------------------------------------------------------------
183 --
184
185 procedure update_payroll_a
186 (
187 p_effective_date in date,
188 p_datetrack_mode in varchar2,
189 p_payroll_name in varchar2 ,
190 p_number_of_years in number ,
191 p_default_payment_method_id in number ,
192 p_consolidation_set_id in number ,
193 p_cost_alloc_keyflex_id_in in number ,
194 p_susp_account_keyflex_id_in in number ,
195 p_negative_pay_allowed_flag in varchar2 ,
196 p_soft_coding_keyflex_id_in in number ,
197 p_comments in varchar2 ,
198 p_attribute_category in varchar2 ,
199 p_attribute1 in varchar2 ,
200 p_attribute2 in varchar2 ,
201 p_attribute3 in varchar2 ,
202 p_attribute4 in varchar2 ,
203 p_attribute5 in varchar2 ,
204 p_attribute6 in varchar2 ,
205 p_attribute7 in varchar2 ,
206 p_attribute8 in varchar2 ,
207 p_attribute9 in varchar2 ,
208 p_attribute10 in varchar2 ,
209 p_attribute11 in varchar2 ,
210 p_attribute12 in varchar2 ,
211 p_attribute13 in varchar2 ,
212 p_attribute14 in varchar2 ,
213 p_attribute15 in varchar2 ,
214 p_attribute16 in varchar2 ,
215 p_attribute17 in varchar2 ,
216 p_attribute18 in varchar2 ,
217 p_attribute19 in varchar2 ,
218 p_attribute20 in varchar2 ,
219 p_arrears_flag in varchar2 ,
220 p_multi_assignments_flag in varchar2 ,
221 p_prl_information1 in varchar2 ,
222 p_prl_information2 in varchar2 ,
223 p_prl_information3 in varchar2 ,
224 p_prl_information4 in varchar2 ,
225 p_prl_information5 in varchar2 ,
226 p_prl_information6 in varchar2 ,
227 p_prl_information7 in varchar2 ,
228 p_prl_information8 in varchar2 ,
229 p_prl_information9 in varchar2 ,
230 p_prl_information10 in varchar2 ,
231 p_prl_information11 in varchar2 ,
232 p_prl_information12 in varchar2 ,
233 p_prl_information13 in varchar2 ,
234 p_prl_information14 in varchar2 ,
235 p_prl_information15 in varchar2 ,
236 p_prl_information16 in varchar2 ,
237 p_prl_information17 in varchar2 ,
238 p_prl_information18 in varchar2 ,
239 p_prl_information19 in varchar2 ,
240 p_prl_information20 in varchar2 ,
241 p_prl_information21 in varchar2 ,
242 p_prl_information22 in varchar2 ,
243 p_prl_information23 in varchar2 ,
244 p_prl_information24 in varchar2 ,
245 p_prl_information25 in varchar2 ,
246 p_prl_information26 in varchar2 ,
247 p_prl_information27 in varchar2 ,
248 p_prl_information28 in varchar2 ,
249 p_prl_information29 in varchar2 ,
250 p_prl_information30 in varchar2 ,
251
252 p_cost_segment1 in varchar2 ,
253 p_cost_segment2 in varchar2 ,
254 p_cost_segment3 in varchar2 ,
255 p_cost_segment4 in varchar2 ,
256 p_cost_segment5 in varchar2 ,
257 p_cost_segment6 in varchar2 ,
258 p_cost_segment7 in varchar2 ,
259 p_cost_segment8 in varchar2 ,
260 p_cost_segment9 in varchar2 ,
261 p_cost_segment10 in varchar2 ,
262 p_cost_segment11 in varchar2 ,
263 p_cost_segment12 in varchar2 ,
264 p_cost_segment13 in varchar2 ,
265 p_cost_segment14 in varchar2 ,
266 p_cost_segment15 in varchar2 ,
267 p_cost_segment16 in varchar2 ,
268 p_cost_segment17 in varchar2 ,
269 p_cost_segment18 in varchar2 ,
270 p_cost_segment19 in varchar2 ,
271 p_cost_segment20 in varchar2 ,
272 p_cost_segment21 in varchar2 ,
273 p_cost_segment22 in varchar2 ,
274 p_cost_segment23 in varchar2 ,
275 p_cost_segment24 in varchar2 ,
279 p_cost_segment28 in varchar2 ,
276 p_cost_segment25 in varchar2 ,
277 p_cost_segment26 in varchar2 ,
278 p_cost_segment27 in varchar2 ,
280 p_cost_segment29 in varchar2 ,
281 p_cost_segment30 in varchar2 ,
282 p_cost_concat_segments_in in varchar2,
283
284 p_susp_segment1 in varchar2 ,
285 p_susp_segment2 in varchar2 ,
286 p_susp_segment3 in varchar2 ,
287 p_susp_segment4 in varchar2 ,
288 p_susp_segment5 in varchar2 ,
289 p_susp_segment6 in varchar2 ,
290 p_susp_segment7 in varchar2 ,
291 p_susp_segment8 in varchar2 ,
292 p_susp_segment9 in varchar2 ,
293 p_susp_segment10 in varchar2 ,
294 p_susp_segment11 in varchar2 ,
295 p_susp_segment12 in varchar2 ,
296 p_susp_segment13 in varchar2 ,
297 p_susp_segment14 in varchar2 ,
298 p_susp_segment15 in varchar2 ,
299 p_susp_segment16 in varchar2 ,
300 p_susp_segment17 in varchar2 ,
301 p_susp_segment18 in varchar2 ,
302 p_susp_segment19 in varchar2 ,
303 p_susp_segment20 in varchar2 ,
304 p_susp_segment21 in varchar2 ,
305 p_susp_segment22 in varchar2 ,
306 p_susp_segment23 in varchar2 ,
307 p_susp_segment24 in varchar2 ,
308 p_susp_segment25 in varchar2 ,
309 p_susp_segment26 in varchar2 ,
310 p_susp_segment27 in varchar2 ,
311 p_susp_segment28 in varchar2 ,
312 p_susp_segment29 in varchar2 ,
313 p_susp_segment30 in varchar2 ,
314 p_susp_concat_segments_in in varchar2,
315
316 p_scl_segment1 in varchar2 ,
317 p_scl_segment2 in varchar2 ,
318 p_scl_segment3 in varchar2 ,
319 p_scl_segment4 in varchar2 ,
320 p_scl_segment5 in varchar2 ,
321 p_scl_segment6 in varchar2 ,
322 p_scl_segment7 in varchar2 ,
323 p_scl_segment8 in varchar2 ,
324 p_scl_segment9 in varchar2 ,
325 p_scl_segment10 in varchar2 ,
326 p_scl_segment11 in varchar2 ,
327 p_scl_segment12 in varchar2 ,
328 p_scl_segment13 in varchar2 ,
329 p_scl_segment14 in varchar2 ,
330 p_scl_segment15 in varchar2 ,
331 p_scl_segment16 in varchar2 ,
332 p_scl_segment17 in varchar2 ,
333 p_scl_segment18 in varchar2 ,
334 p_scl_segment19 in varchar2 ,
335 p_scl_segment20 in varchar2 ,
336 p_scl_segment21 in varchar2 ,
337 p_scl_segment22 in varchar2 ,
338 p_scl_segment23 in varchar2 ,
339 p_scl_segment24 in varchar2 ,
340 p_scl_segment25 in varchar2 ,
341 p_scl_segment26 in varchar2 ,
342 p_scl_segment27 in varchar2 ,
343 p_scl_segment28 in varchar2 ,
344 p_scl_segment29 in varchar2 ,
345 p_scl_segment30 in varchar2 ,
346 p_scl_concat_segments_in in varchar2,
347
348 p_business_group_id in number,
349
350 p_workload_shifting_level in varchar2 ,
351 p_payslip_view_date_offset in number ,
352
353 p_payroll_id in number,
354 p_effective_start_date in date,
355 p_effective_end_date in date,
356 p_comment_id in number,
357 p_object_version_number in number,
358
359 p_cost_alloc_keyflex_id_out in number,
360 p_susp_account_keyflex_id_out in number,
361 p_soft_coding_keyflex_id_out in number,
362
363 p_cost_concat_segments_out in varchar2,
367 );
364 p_susp_concat_segments_out in varchar2,
365 p_scl_concat_segments_out in varchar2
366
368 --
369 end pay_payroll_bk2;