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