[Home] [Help]
PACKAGE: APPS.PAY_PAYROLLS_F_PKG
Source
1 PACKAGE PAY_PAYROLLS_F_PKG as
2 /* $Header: pyprl01t.pkh 120.1 2006/11/08 13:59:28 ajeyam noship $ */
3 --
4 -----------------------------------------------------------------------------
5 -- Name --
6 -- maintain_soft_coding_keyflex --
7 -- Purpose --
8 -- Maintains the SCL keyflex. As the SCL keyflex can be set at different --
9 -- levels ie. assignment, payroll, organization etc ... the standard FND --
10 -- VALID cannot deal with partial flexfields so this function replaces --
11 -- it. --
12 -- Arguments --
13 -- See below. --
14 -- Notes --
15 -- None --
16 -----------------------------------------------------------------------------
17 --
18 function maintain_soft_coding_keyflex
19 (
20 p_scl_structure number,
21 p_soft_coding_keyflex_id number,
22 p_concatenated_segments varchar2,
23 p_summary_flag varchar2,
24 p_start_date_active date,
25 p_end_date_active date,
26 p_segment1 varchar2,
27 p_segment2 varchar2,
28 p_segment3 varchar2,
29 p_segment4 varchar2,
30 p_segment5 varchar2,
31 p_segment6 varchar2,
32 p_segment7 varchar2,
33 p_segment8 varchar2,
34 p_segment9 varchar2,
35 p_segment10 varchar2,
36 p_segment11 varchar2,
37 p_segment12 varchar2,
38 p_segment13 varchar2,
39 p_segment14 varchar2,
40 p_segment15 varchar2,
41 p_segment16 varchar2,
42 p_segment17 varchar2,
43 p_segment18 varchar2,
44 p_segment19 varchar2,
45 p_segment20 varchar2,
46 p_segment21 varchar2,
47 p_segment22 varchar2,
48 p_segment23 varchar2,
49 p_segment24 varchar2,
50 p_segment25 varchar2,
51 p_segment26 varchar2,
52 p_segment27 varchar2,
53 p_segment28 varchar2,
54 p_segment29 varchar2,
55 p_segment30 varchar2
56 ) return number;
57 --
58 -----------------------------------------------------------------------------
59 -- Name --
60 -- current_values --
61 -- Purpose --
62 -- Returns the current values for several columns so that a check can be --
63 -- made to see if the value has changed. --
64 -- Arguments --
65 -- See below. --
66 -- Notes --
67 -- None --
68 -----------------------------------------------------------------------------
69 --
70 procedure current_values
71 (
72 p_rowid varchar2,
73 p_payroll_name in out nocopy varchar2,
74 p_number_of_years in out nocopy number,
75 p_default_payment_method_id in out nocopy number
76 );
77 --
78 -----------------------------------------------------------------------------
79 -- Name --
80 -- lock_payroll --
81 -- Purpose --
82 -- Locks the specified payroll. --
83 -- Arguments --
84 -- See below. --
85 -- Notes --
86 -- This is used to reduce concurrency problems when changing / checking --
87 -- time periods. --
88 -----------------------------------------------------------------------------
89 --
90 procedure lock_payroll
91 (
92 p_payroll_id number
93 );
94 --
95 -----------------------------------------------------------------------------
96 -- Name --
97 -- get_bg_and_leg_info --
98 -- Purpose --
99 -- 1.Retrieves keyflex structure for the legislations SCL and also for the --
100 -- costing keyflex for the business group. --
101 -- 2.Looks for rules in PAY_LEGISLATION_RULES for the disabling of --
102 -- update of time period --
103 -- dates ie. some legislations require that some dates cannot be changed --
104 -- eg. cannot update the regular payment date etc... --
105 -- 3.Looks for rule in PAY_LEGISLATION_RULES which determines whether --
106 -- the pay offset date must be negative or whether it can be negative --
107 -- or positive.
108 -- Arguments --
109 -- p_regular_payment_date --
110 -- p_default_dd_date TRUE if update of the particular date is --
111 -- p_pay_advice_date disallowed. --
112 -- p_cut_off_date --
113 -- p_pay_date_offset_rule --
114 -- Notes --
115 -- The existence of a row in PAY_LEGISLATION_RULES with a RULE_TYPE as --
116 -- shown below means that the date is disabled ie. cannot be updated. --
117 -- RULE_TYPE DATE --
118 -- P REGULAR_PAYMENT_DATE --
119 -- C CUT_OFF_DATE --
120 -- D DEFAULT_DD_DATE --
121 -- A PAY_ADVICE_DATE --
122 -- With a rule type of PDO the value N signifies only negative values --
123 -- are allowed , NP signifies Negative and Positive values are allowed --
124 -- If the rule is missing then the value NP is assumed. --
125 --
126 -----------------------------------------------------------------------------
127 --
128 procedure get_bg_and_leg_info
129 (
130 p_business_group_id number,
131 p_legislation_code varchar2,
132 p_cost_id_flex_num out nocopy varchar2,
133 p_scl_id_flex_num out nocopy varchar2,
134 p_regular_payment_date out nocopy boolean,
135 p_default_dd_date out nocopy boolean,
136 p_pay_advice_date out nocopy boolean,
137 p_cut_off_date out nocopy boolean,
138 p_pay_date_offset_rule out nocopy varchar2,
139 p_scl_enabled out nocopy boolean,
140 p_payslip_view_date out nocopy boolean
141 );
142 --
143 -----------------------------------------------------------------------------
144 -- Name --
145 -- dflt_scl_from_bg --
146 -- Purpose --
147 -- Retrieves the current values for the SCL that were set up for the --
148 -- business group. These are then used as defaults when creating a SCL --
149 -- for a payroll. --
150 -- Arguments --
151 -- See Below. --
152 -- Notes --
153 -- None --
154 -----------------------------------------------------------------------------
155 --
156 procedure dflt_scl_from_bg
157 (
158 p_business_group_id number,
159 p_segment1 in out nocopy varchar2,
160 p_segment2 in out nocopy varchar2,
161 p_segment3 in out nocopy varchar2,
162 p_segment4 in out nocopy varchar2,
163 p_segment5 in out nocopy varchar2,
164 p_segment6 in out nocopy varchar2,
165 p_segment7 in out nocopy varchar2,
166 p_segment8 in out nocopy varchar2,
167 p_segment9 in out nocopy varchar2,
168 p_segment10 in out nocopy varchar2,
169 p_segment11 in out nocopy varchar2,
170 p_segment12 in out nocopy varchar2,
171 p_segment13 in out nocopy varchar2,
172 p_segment14 in out nocopy varchar2,
173 p_segment15 in out nocopy varchar2,
174 p_segment16 in out nocopy varchar2,
175 p_segment17 in out nocopy varchar2,
176 p_segment18 in out nocopy varchar2,
177 p_segment19 in out nocopy varchar2,
178 p_segment20 in out nocopy varchar2,
179 p_segment21 in out nocopy varchar2,
180 p_segment22 in out nocopy varchar2,
181 p_segment23 in out nocopy varchar2,
182 p_segment24 in out nocopy varchar2,
183 p_segment25 in out nocopy varchar2,
184 p_segment26 in out nocopy varchar2,
185 p_segment27 in out nocopy varchar2,
186 p_segment28 in out nocopy varchar2,
187 p_segment29 in out nocopy varchar2,
188 p_segment30 in out nocopy varchar2
189 );
190 --
191 -----------------------------------------------------------------------------
192 -- Name --
193 -- Insert_Row --
194 -- Purpose --
195 -- Table handler procedure that supports the insert of a payroll via the --
196 -- Define Payroll form. --
197 -- Arguments --
198 -- See below. --
199 -- Notes --
200 -- --
201 -- Added Column X_payslip_view_date_offset By Rajeesha Bug 4246280 --
202 -----------------------------------------------------------------------------
203 --
204 PROCEDURE Insert_Row(X_Rowid IN out nocopy VARCHAR2,
205 X_Payroll_Id IN out nocopy NUMBER,
206 X_Effective_Start_Date DATE,
207 X_Effective_End_Date DATE,
208 X_Default_Payment_Method_Id NUMBER,
209 X_Business_Group_Id NUMBER,
210 X_Consolidation_Set_Id NUMBER,
211 X_Cost_Allocation_Keyflex_Id NUMBER,
212 X_Suspense_Account_Keyflex_Id NUMBER,
213 X_Gl_Set_Of_Books_Id NUMBER,
214 X_Soft_Coding_Keyflex_Id NUMBER,
215 X_Period_Type VARCHAR2,
216 X_Organization_Id NUMBER,
217 X_Cut_Off_Date_Offset NUMBER,
218 X_Direct_Deposit_Date_Offset NUMBER,
219 X_First_Period_End_Date DATE,
220 X_Negative_Pay_Allowed_Flag VARCHAR2,
221 X_Number_Of_Years NUMBER,
222 X_Pay_Advice_Date_Offset NUMBER,
223 X_Pay_Date_Offset NUMBER,
224 X_Payroll_Name VARCHAR2,
225 X_Workload_Shifting_Level VARCHAR2,
226 X_Comment_Id NUMBER,
227 X_Attribute_Category VARCHAR2,
228 X_Attribute1 VARCHAR2,
229 X_Attribute2 VARCHAR2,
230 X_Attribute3 VARCHAR2,
231 X_Attribute4 VARCHAR2,
232 X_Attribute5 VARCHAR2,
233 X_Attribute6 VARCHAR2,
234 X_Attribute7 VARCHAR2,
235 X_Attribute8 VARCHAR2,
236 X_Attribute9 VARCHAR2,
237 X_Attribute10 VARCHAR2,
238 X_Attribute11 VARCHAR2,
239 X_Attribute12 VARCHAR2,
240 X_Attribute13 VARCHAR2,
241 X_Attribute14 VARCHAR2,
242 X_Attribute15 VARCHAR2,
243 X_Attribute16 VARCHAR2,
244 X_Attribute17 VARCHAR2,
245 X_Attribute18 VARCHAR2,
246 X_Attribute19 VARCHAR2,
247 X_Attribute20 VARCHAR2,
248 -- Payroll Developer DF
249 X_Prl_Information_Category VARCHAR2 DEFAULT NULL,
250 X_Prl_Information1 VARCHAR2 DEFAULT NULL,
251 X_Prl_Information2 VARCHAR2 DEFAULT NULL,
252 X_Prl_Information3 VARCHAR2 DEFAULT NULL,
253 X_Prl_Information4 VARCHAR2 DEFAULT NULL,
254 X_Prl_Information5 VARCHAR2 DEFAULT NULL,
255 X_Prl_Information6 VARCHAR2 DEFAULT NULL,
256 X_Prl_Information7 VARCHAR2 DEFAULT NULL,
257 X_Prl_Information8 VARCHAR2 DEFAULT NULL,
258 X_Prl_Information9 VARCHAR2 DEFAULT NULL,
259 X_Prl_Information10 VARCHAR2 DEFAULT NULL,
260 X_Prl_Information11 VARCHAR2 DEFAULT NULL,
261 X_Prl_Information12 VARCHAR2 DEFAULT NULL,
262 X_Prl_Information13 VARCHAR2 DEFAULT NULL,
263 X_Prl_Information14 VARCHAR2 DEFAULT NULL,
264 X_Prl_Information15 VARCHAR2 DEFAULT NULL,
265 X_Prl_Information16 VARCHAR2 DEFAULT NULL,
266 X_Prl_Information17 VARCHAR2 DEFAULT NULL,
267 X_Prl_Information18 VARCHAR2 DEFAULT NULL,
268 X_Prl_Information19 VARCHAR2 DEFAULT NULL,
269 X_Prl_Information20 VARCHAR2 DEFAULT NULL,
270 X_Prl_Information21 VARCHAR2 DEFAULT NULL,
271 X_Prl_Information22 VARCHAR2 DEFAULT NULL,
272 X_Prl_Information23 VARCHAR2 DEFAULT NULL,
273 X_Prl_Information24 VARCHAR2 DEFAULT NULL,
274 X_Prl_Information25 VARCHAR2 DEFAULT NULL,
275 X_Prl_Information26 VARCHAR2 DEFAULT NULL,
279 X_Prl_Information30 VARCHAR2 DEFAULT NULL,
276 X_Prl_Information27 VARCHAR2 DEFAULT NULL,
277 X_Prl_Information28 VARCHAR2 DEFAULT NULL,
278 X_Prl_Information29 VARCHAR2 DEFAULT NULL,
280 -- Extra Columns
281 X_Validation_Start_date DATE,
282 X_Validation_End_date DATE,
283 X_Arrears_Flag VARCHAR2,
284 X_Multi_Assignments_Flag VARCHAR2 DEFAULT NULL,
285 X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
286 X_payslip_view_date_offset Number DEFAULT NULL
287 );
288 --
289 -----------------------------------------------------------------------------
290 -- Name --
291 -- Insert_Row --
292 -- Purpose --
293 -- Table handler procedure that supports the insert of a payroll via the --
294 -- Define Payroll form. --
295 -- Arguments --
296 -- See below. --
297 -- Notes --
298 -- --
299 -- Added Column X_payslip_view_date_offset By Rajeesha Bug 4246280 --
300 -- Added the Overloaded procedure to call the API 5144323 --
301 -----------------------------------------------------------------------------
302 --
303 PROCEDURE Insert_Row(X_Rowid IN out nocopy VARCHAR2,
304 X_Payroll_Id IN out nocopy NUMBER,
305 X_Default_Payment_Method_Id NUMBER,
306 X_Business_Group_Id NUMBER,
307 X_Consolidation_Set_Id NUMBER,
308 X_Cost_Allocation_Keyflex_Id NUMBER,
309 X_Suspense_Account_Keyflex_Id NUMBER,
310 X_Gl_Set_Of_Books_Id NUMBER,
311 X_Soft_Coding_Keyflex_Id NUMBER,
312 X_Period_Type VARCHAR2,
313 X_Organization_Id NUMBER,
314 X_Cut_Off_Date_Offset NUMBER,
315 X_Direct_Deposit_Date_Offset NUMBER,
316 X_First_Period_End_Date DATE,
317 X_Negative_Pay_Allowed_Flag VARCHAR2,
318 X_Number_Of_Years NUMBER,
319 X_Pay_Advice_Date_Offset NUMBER,
320 X_Pay_Date_Offset NUMBER,
321 X_Payroll_Name VARCHAR2,
322 X_Workload_Shifting_Level VARCHAR2,
323 X_Attribute_Category VARCHAR2,
324 X_Attribute1 VARCHAR2,
325 X_Attribute2 VARCHAR2,
326 X_Attribute3 VARCHAR2,
327 X_Attribute4 VARCHAR2,
328 X_Attribute5 VARCHAR2,
329 X_Attribute6 VARCHAR2,
330 X_Attribute7 VARCHAR2,
331 X_Attribute8 VARCHAR2,
332 X_Attribute9 VARCHAR2,
333 X_Attribute10 VARCHAR2,
334 X_Attribute11 VARCHAR2,
335 X_Attribute12 VARCHAR2,
336 X_Attribute13 VARCHAR2,
337 X_Attribute14 VARCHAR2,
338 X_Attribute15 VARCHAR2,
339 X_Attribute16 VARCHAR2,
340 X_Attribute17 VARCHAR2,
341 X_Attribute18 VARCHAR2,
342 X_Attribute19 VARCHAR2,
343 X_Attribute20 VARCHAR2,
344 -- Payroll Developer DF
345 X_Prl_Information_Category VARCHAR2 DEFAULT NULL,
346 X_Prl_Information1 VARCHAR2 DEFAULT NULL,
347 X_Prl_Information2 VARCHAR2 DEFAULT NULL,
348 X_Prl_Information3 VARCHAR2 DEFAULT NULL,
349 X_Prl_Information4 VARCHAR2 DEFAULT NULL,
350 X_Prl_Information5 VARCHAR2 DEFAULT NULL,
351 X_Prl_Information6 VARCHAR2 DEFAULT NULL,
352 X_Prl_Information7 VARCHAR2 DEFAULT NULL,
353 X_Prl_Information8 VARCHAR2 DEFAULT NULL,
354 X_Prl_Information9 VARCHAR2 DEFAULT NULL,
355 X_Prl_Information10 VARCHAR2 DEFAULT NULL,
356 X_Prl_Information11 VARCHAR2 DEFAULT NULL,
360 X_Prl_Information15 VARCHAR2 DEFAULT NULL,
357 X_Prl_Information12 VARCHAR2 DEFAULT NULL,
358 X_Prl_Information13 VARCHAR2 DEFAULT NULL,
359 X_Prl_Information14 VARCHAR2 DEFAULT NULL,
361 X_Prl_Information16 VARCHAR2 DEFAULT NULL,
362 X_Prl_Information17 VARCHAR2 DEFAULT NULL,
363 X_Prl_Information18 VARCHAR2 DEFAULT NULL,
364 X_Prl_Information19 VARCHAR2 DEFAULT NULL,
365 X_Prl_Information20 VARCHAR2 DEFAULT NULL,
366 X_Prl_Information21 VARCHAR2 DEFAULT NULL,
367 X_Prl_Information22 VARCHAR2 DEFAULT NULL,
368 X_Prl_Information23 VARCHAR2 DEFAULT NULL,
369 X_Prl_Information24 VARCHAR2 DEFAULT NULL,
370 X_Prl_Information25 VARCHAR2 DEFAULT NULL,
371 X_Prl_Information26 VARCHAR2 DEFAULT NULL,
372 X_Prl_Information27 VARCHAR2 DEFAULT NULL,
373 X_Prl_Information28 VARCHAR2 DEFAULT NULL,
374 X_Prl_Information29 VARCHAR2 DEFAULT NULL,
375 X_Prl_Information30 VARCHAR2 DEFAULT NULL,
376 -- Extra Columns
377 X_Validation_Start_date DATE,
378 X_Validation_End_date DATE,
379 X_Arrears_Flag VARCHAR2,
380 X_Multi_Assignments_Flag VARCHAR2 DEFAULT NULL,
381 X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
382 X_payslip_view_date_offset Number DEFAULT NULL
383 -- bug 5609830 / 5144323 TEST starts
384 ,X_Effective_Date DATE --new
385 ,X_payroll_type VARCHAR2 DEFAULT NULL --new
386 ,X_comments VARCHAR2 DEFAULT NULL --new
387 ,X_Effective_Start_Date OUT nocopy DATE --out type added
388 ,X_Effective_End_Date OUT nocopy DATE --out type added
389 ,X_Comment_Id OUT nocopy NUMBER --out type added
390 --bug 5609830 / 5144323 TEST ends
391 );
392 --
393 -----------------------------------------------------------------------------
394 -- Name --
395 -- Lock_Row --
396 -- Purpose --
397 -- Table handler procedure that supports the insert , update and delete --
398 -- of a formula by applying a lock on a payroll in the Define Payroll --
399 -- form. --
400 -- Arguments --
401 -- See below. --
402 -- Notes --
403 -- None. --
404 -- Added Column X_payslip_view_date_offset By Rajeesha Bug 4246280 --
405 -----------------------------------------------------------------------------
406 --
407 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
408 X_Payroll_Id NUMBER,
409 X_Effective_Start_Date DATE,
410 X_Effective_End_Date DATE,
411 X_Default_Payment_Method_Id NUMBER,
412 X_Business_Group_Id NUMBER,
413 X_Consolidation_Set_Id NUMBER,
414 X_Cost_Allocation_Keyflex_Id NUMBER,
415 X_Suspense_Account_Keyflex_Id NUMBER,
416 X_Gl_Set_Of_Books_Id NUMBER,
417 X_Soft_Coding_Keyflex_Id NUMBER,
418 X_Period_Type VARCHAR2,
419 X_Organization_Id NUMBER,
420 X_Cut_Off_Date_Offset NUMBER,
421 X_Direct_Deposit_Date_Offset NUMBER,
422 X_First_Period_End_Date DATE,
423 X_Negative_Pay_Allowed_Flag VARCHAR2,
424 X_Number_Of_Years NUMBER,
425 X_Pay_Advice_Date_Offset NUMBER,
426 X_Pay_Date_Offset NUMBER,
427 X_Payroll_Name VARCHAR2,
428 X_Workload_Shifting_Level VARCHAR2,
429 X_Comment_Id NUMBER,
430 X_Attribute_Category VARCHAR2,
431 X_Attribute1 VARCHAR2,
432 X_Attribute2 VARCHAR2,
433 X_Attribute3 VARCHAR2,
434 X_Attribute4 VARCHAR2,
435 X_Attribute5 VARCHAR2,
436 X_Attribute6 VARCHAR2,
440 X_Attribute10 VARCHAR2,
437 X_Attribute7 VARCHAR2,
438 X_Attribute8 VARCHAR2,
439 X_Attribute9 VARCHAR2,
441 X_Attribute11 VARCHAR2,
442 X_Attribute12 VARCHAR2,
443 X_Attribute13 VARCHAR2,
444 X_Attribute14 VARCHAR2,
445 X_Attribute15 VARCHAR2,
446 X_Attribute16 VARCHAR2,
447 X_Attribute17 VARCHAR2,
448 X_Attribute18 VARCHAR2,
449 X_Attribute19 VARCHAR2,
450 X_Attribute20 VARCHAR2,
451 -- Payroll Developer DF
452 X_Prl_Information_Category VARCHAR2 DEFAULT NULL,
453 X_Prl_Information1 VARCHAR2 DEFAULT NULL,
454 X_Prl_Information2 VARCHAR2 DEFAULT NULL,
455 X_Prl_Information3 VARCHAR2 DEFAULT NULL,
456 X_Prl_Information4 VARCHAR2 DEFAULT NULL,
457 X_Prl_Information5 VARCHAR2 DEFAULT NULL,
458 X_Prl_Information6 VARCHAR2 DEFAULT NULL,
459 X_Prl_Information7 VARCHAR2 DEFAULT NULL,
460 X_Prl_Information8 VARCHAR2 DEFAULT NULL,
461 X_Prl_Information9 VARCHAR2 DEFAULT NULL,
462 X_Prl_Information10 VARCHAR2 DEFAULT NULL,
463 X_Prl_Information11 VARCHAR2 DEFAULT NULL,
464 X_Prl_Information12 VARCHAR2 DEFAULT NULL,
465 X_Prl_Information13 VARCHAR2 DEFAULT NULL,
466 X_Prl_Information14 VARCHAR2 DEFAULT NULL,
467 X_Prl_Information15 VARCHAR2 DEFAULT NULL,
468 X_Prl_Information16 VARCHAR2 DEFAULT NULL,
469 X_Prl_Information17 VARCHAR2 DEFAULT NULL,
470 X_Prl_Information18 VARCHAR2 DEFAULT NULL,
471 X_Prl_Information19 VARCHAR2 DEFAULT NULL,
472 X_Prl_Information20 VARCHAR2 DEFAULT NULL,
473 X_Prl_Information21 VARCHAR2 DEFAULT NULL,
474 X_Prl_Information22 VARCHAR2 DEFAULT NULL,
475 X_Prl_Information23 VARCHAR2 DEFAULT NULL,
476 X_Prl_Information24 VARCHAR2 DEFAULT NULL,
477 X_Prl_Information25 VARCHAR2 DEFAULT NULL,
478 X_Prl_Information26 VARCHAR2 DEFAULT NULL,
479 X_Prl_Information27 VARCHAR2 DEFAULT NULL,
480 X_Prl_Information28 VARCHAR2 DEFAULT NULL,
481 X_Prl_Information29 VARCHAR2 DEFAULT NULL,
482 X_Prl_Information30 VARCHAR2 DEFAULT NULL,
483 --
484 X_Arrears_Flag VARCHAR2,
485 X_Multi_Assignments_Flag VARCHAR2 DEFAULT NULL,
486 X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
487 X_payslip_view_date_offset Number DEFAULT NULL
488 );
489
490 --
491 -----------------------------------------------------------------------------
492 -- Name --
493 -- Update_Row --
494 -- Purpose --
495 -- Table handler procedure that supports the update of a payroll via the --
496 -- Define Payroll form. --
497 -- Arguments --
498 -- See below. --
499 -- Notes --
500 -- None. --
501 -- Added Column X_payslip_view_date_offset By Rajeesha Bug 4246280 --
502 -----------------------------------------------------------------------------
503 --
504 PROCEDURE Update_Row(X_Rowid VARCHAR2,
505 X_Payroll_Id NUMBER,
506 X_Effective_Start_Date DATE,
507 X_Effective_End_Date DATE,
508 X_Default_Payment_Method_Id NUMBER,
509 X_Business_Group_Id NUMBER,
510 X_Consolidation_Set_Id NUMBER,
511 X_Cost_Allocation_Keyflex_Id NUMBER,
512 X_Suspense_Account_Keyflex_Id NUMBER,
513 X_Gl_Set_Of_Books_Id NUMBER,
514 X_Soft_Coding_Keyflex_Id NUMBER,
515 X_Period_Type VARCHAR2,
516 X_Organization_Id NUMBER,
517 X_Cut_Off_Date_Offset NUMBER,
518 X_Direct_Deposit_Date_Offset NUMBER,
522 X_Pay_Advice_Date_Offset NUMBER,
519 X_First_Period_End_Date DATE,
520 X_Negative_Pay_Allowed_Flag VARCHAR2,
521 X_Number_Of_Years NUMBER,
523 X_Pay_Date_Offset NUMBER,
524 X_Payroll_Name VARCHAR2,
525 X_Workload_Shifting_Level VARCHAR2,
526 X_Comment_Id NUMBER,
527 X_Attribute_Category VARCHAR2,
528 X_Attribute1 VARCHAR2,
529 X_Attribute2 VARCHAR2,
530 X_Attribute3 VARCHAR2,
531 X_Attribute4 VARCHAR2,
532 X_Attribute5 VARCHAR2,
533 X_Attribute6 VARCHAR2,
534 X_Attribute7 VARCHAR2,
535 X_Attribute8 VARCHAR2,
536 X_Attribute9 VARCHAR2,
537 X_Attribute10 VARCHAR2,
538 X_Attribute11 VARCHAR2,
539 X_Attribute12 VARCHAR2,
540 X_Attribute13 VARCHAR2,
541 X_Attribute14 VARCHAR2,
542 X_Attribute15 VARCHAR2,
543 X_Attribute16 VARCHAR2,
544 X_Attribute17 VARCHAR2,
545 X_Attribute18 VARCHAR2,
546 X_Attribute19 VARCHAR2,
547 X_Attribute20 VARCHAR2,
548 -- Payroll Developer DF
549 X_Prl_Information_Category VARCHAR2 DEFAULT NULL,
550 X_Prl_Information1 VARCHAR2 DEFAULT NULL,
551 X_Prl_Information2 VARCHAR2 DEFAULT NULL,
552 X_Prl_Information3 VARCHAR2 DEFAULT NULL,
553 X_Prl_Information4 VARCHAR2 DEFAULT NULL,
554 X_Prl_Information5 VARCHAR2 DEFAULT NULL,
555 X_Prl_Information6 VARCHAR2 DEFAULT NULL,
556 X_Prl_Information7 VARCHAR2 DEFAULT NULL,
557 X_Prl_Information8 VARCHAR2 DEFAULT NULL,
558 X_Prl_Information9 VARCHAR2 DEFAULT NULL,
559 X_Prl_Information10 VARCHAR2 DEFAULT NULL,
560 X_Prl_Information11 VARCHAR2 DEFAULT NULL,
561 X_Prl_Information12 VARCHAR2 DEFAULT NULL,
562 X_Prl_Information13 VARCHAR2 DEFAULT NULL,
563 X_Prl_Information14 VARCHAR2 DEFAULT NULL,
564 X_Prl_Information15 VARCHAR2 DEFAULT NULL,
565 X_Prl_Information16 VARCHAR2 DEFAULT NULL,
566 X_Prl_Information17 VARCHAR2 DEFAULT NULL,
567 X_Prl_Information18 VARCHAR2 DEFAULT NULL,
568 X_Prl_Information19 VARCHAR2 DEFAULT NULL,
569 X_Prl_Information20 VARCHAR2 DEFAULT NULL,
570 X_Prl_Information21 VARCHAR2 DEFAULT NULL,
571 X_Prl_Information22 VARCHAR2 DEFAULT NULL,
572 X_Prl_Information23 VARCHAR2 DEFAULT NULL,
573 X_Prl_Information24 VARCHAR2 DEFAULT NULL,
574 X_Prl_Information25 VARCHAR2 DEFAULT NULL,
575 X_Prl_Information26 VARCHAR2 DEFAULT NULL,
576 X_Prl_Information27 VARCHAR2 DEFAULT NULL,
577 X_Prl_Information28 VARCHAR2 DEFAULT NULL,
578 X_Prl_Information29 VARCHAR2 DEFAULT NULL,
579 X_Prl_Information30 VARCHAR2 DEFAULT NULL,
580 -- Extra Columns
581 X_Validation_Start_date DATE,
582 X_Validation_End_date DATE,
583 X_Arrears_Flag VARCHAR2,
584 X_Multi_Assignments_Flag VARCHAR2 DEFAULT NULL,
585 X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
586 X_payslip_view_date_offset Number DEFAULT NULL
587 );
588
589 --
590 -----------------------------------------------------------------------------
591 -- Name --
592 -- Update_Row --
593 -- Purpose --
594 -- Table handler procedure that supports the update of a payroll via the --
595 -- Define Payroll form. --
596 -- Arguments --
597 -- See below. --
598 -- Notes --
599 -- None. --
603 --
600 -- Added Column X_payslip_view_date_offset By Rajeesha Bug 4246280 --
601 -- Added the Overloaded procedure to call the API 5144323 --
602 -----------------------------------------------------------------------------
604 PROCEDURE Update_Row(X_Default_Payment_Method_Id NUMBER,
605 X_Business_Group_Id NUMBER,
606 X_Consolidation_Set_Id NUMBER,
607 X_Cost_Allocation_Keyflex_Id NUMBER,
608 X_Suspense_Account_Keyflex_Id NUMBER,
609 X_Gl_Set_Of_Books_Id NUMBER,
610 X_Soft_Coding_Keyflex_Id NUMBER,
611 X_Period_Type VARCHAR2,
612 X_Organization_Id NUMBER,
613 X_Cut_Off_Date_Offset NUMBER,
614 X_Direct_Deposit_Date_Offset NUMBER,
615 X_First_Period_End_Date DATE,
616 X_Negative_Pay_Allowed_Flag VARCHAR2,
617 X_Number_Of_Years NUMBER,
618 X_Pay_Advice_Date_Offset NUMBER,
619 X_Pay_Date_Offset NUMBER,
620 X_Payroll_Name VARCHAR2,
621 X_Workload_Shifting_Level VARCHAR2,
622 X_Attribute_Category VARCHAR2,
623 X_Attribute1 VARCHAR2,
624 X_Attribute2 VARCHAR2,
625 X_Attribute3 VARCHAR2,
626 X_Attribute4 VARCHAR2,
627 X_Attribute5 VARCHAR2,
628 X_Attribute6 VARCHAR2,
629 X_Attribute7 VARCHAR2,
630 X_Attribute8 VARCHAR2,
631 X_Attribute9 VARCHAR2,
632 X_Attribute10 VARCHAR2,
633 X_Attribute11 VARCHAR2,
634 X_Attribute12 VARCHAR2,
635 X_Attribute13 VARCHAR2,
636 X_Attribute14 VARCHAR2,
637 X_Attribute15 VARCHAR2,
638 X_Attribute16 VARCHAR2,
639 X_Attribute17 VARCHAR2,
640 X_Attribute18 VARCHAR2,
641 X_Attribute19 VARCHAR2,
642 X_Attribute20 VARCHAR2,
643 -- Payroll Developer DF
644 X_Prl_Information_Category VARCHAR2 DEFAULT NULL,
645 X_Prl_Information1 VARCHAR2 DEFAULT NULL,
646 X_Prl_Information2 VARCHAR2 DEFAULT NULL,
647 X_Prl_Information3 VARCHAR2 DEFAULT NULL,
648 X_Prl_Information4 VARCHAR2 DEFAULT NULL,
649 X_Prl_Information5 VARCHAR2 DEFAULT NULL,
650 X_Prl_Information6 VARCHAR2 DEFAULT NULL,
651 X_Prl_Information7 VARCHAR2 DEFAULT NULL,
652 X_Prl_Information8 VARCHAR2 DEFAULT NULL,
653 X_Prl_Information9 VARCHAR2 DEFAULT NULL,
654 X_Prl_Information10 VARCHAR2 DEFAULT NULL,
655 X_Prl_Information11 VARCHAR2 DEFAULT NULL,
656 X_Prl_Information12 VARCHAR2 DEFAULT NULL,
657 X_Prl_Information13 VARCHAR2 DEFAULT NULL,
658 X_Prl_Information14 VARCHAR2 DEFAULT NULL,
659 X_Prl_Information15 VARCHAR2 DEFAULT NULL,
660 X_Prl_Information16 VARCHAR2 DEFAULT NULL,
661 X_Prl_Information17 VARCHAR2 DEFAULT NULL,
662 X_Prl_Information18 VARCHAR2 DEFAULT NULL,
663 X_Prl_Information19 VARCHAR2 DEFAULT NULL,
664 X_Prl_Information20 VARCHAR2 DEFAULT NULL,
665 X_Prl_Information21 VARCHAR2 DEFAULT NULL,
666 X_Prl_Information22 VARCHAR2 DEFAULT NULL,
667 X_Prl_Information23 VARCHAR2 DEFAULT NULL,
668 X_Prl_Information24 VARCHAR2 DEFAULT NULL,
669 X_Prl_Information25 VARCHAR2 DEFAULT NULL,
670 X_Prl_Information26 VARCHAR2 DEFAULT NULL,
671 X_Prl_Information27 VARCHAR2 DEFAULT NULL,
672 X_Prl_Information28 VARCHAR2 DEFAULT NULL,
673 X_Prl_Information29 VARCHAR2 DEFAULT NULL,
674 X_Prl_Information30 VARCHAR2 DEFAULT NULL,
675 -- Extra Columns
676 X_Validation_Start_date DATE,
677 X_Validation_End_date DATE,
678 X_Arrears_Flag VARCHAR2,
682 --bug 5609830 / 5144323 TEST starts contents
679 X_Multi_Assignments_Flag VARCHAR2 DEFAULT NULL,
680 X_Period_Reset_Years VARCHAR2 DEFAULT NULL,
681 X_payslip_view_date_offset Number DEFAULT NULL
683 ,X_Dt_Update_Mode VARCHAR2 --new
684 ,X_effective_date DATE --new
685 ,X_Comments VARCHAR2 DEFAULT NULL --new
686 ,X_effective_start_date OUT nocopy DATE --type out added
687 ,X_effective_end_date OUT nocopy DATE --type out added
688 ,X_Comment_Id OUT nocopy NUMBER --type out added
689 ,X_Rowid in OUT nocopy VARCHAR2 --type in out added
690 ,X_Payroll_Id in OUT nocopy NUMBER --type in out added
691 --bug 5609830 / 5144323 TEST ends contents
692 );
693
694 --
695 -----------------------------------------------------------------------------
696 -- Name --
697 -- Delete_Row --
698 -- Purpose --
699 -- Table handler procedure that supports the delete of a payroll via the --
700 -- Define Payroll form. --
701 -- Arguments --
702 -- See below. --
703 -- Notes --
704 -- --
705 -----------------------------------------------------------------------------
706 --
707 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
708 -- Extra Columns
709 X_Payroll_Id NUMBER,
710 X_Default_Payment_Method_Id NUMBER,
711 X_Dt_Delete_Mode VARCHAR2,
712 X_Validation_Start_date DATE,
713 X_Validation_End_date DATE);
714 --
715 -----------------------------------------------------------------------------
716 -- Name --
717 -- Delete_Row --
718 -- Purpose --
719 -- Table handler procedure that supports the delete of a payroll via the --
720 -- Define Payroll form. --
721 -- Arguments --
722 -- See below. --
723 -- Notes --
724 -- --
725 -- Added the Overloaded procedure to call the API 5144323 --
726 -----------------------------------------------------------------------------
727 --
728 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
729 -- Extra Columns
730 X_Payroll_Id NUMBER,
731 X_Default_Payment_Method_Id NUMBER,
732 X_Dt_Delete_Mode VARCHAR2,
733 X_Validation_Start_date DATE,
734 X_Validation_End_date DATE
735 -- bug 5609830 / 5144323 TEST starts contents
736 ,X_effective_date DATE
737 -- bug 5609830 / 5144323 TEST ends contents
738 );
739 --
740 -----------------------------------------------------------------------------
741 -- Name --
742 -- get_offset_field_prompts --
743 -- Purpose --
744 -- To retrieve the labels for the form PAYWSDPG taking the legislation --
745 -- code as parameter. --
746 -- Arguments --
747 -- See below. --
748 -- Notes --
749 -- --
750 -- Added Column X_payslip_view_date_offset By Rajeesha Bug 4246280 --
751 -----------------------------------------------------------------------------
752 --
753 procedure get_offset_field_prompts ( p_legislation_code IN varchar2,
754 p_pay_date_prompt IN out nocopy varchar2,
755 p_dd_offset_prompt IN out nocopy varchar2,
756 p_pay_advice_offset_prompt IN out nocopy varchar2,
757 p_cut_off_date IN out nocopy varchar2,
758 p_arrears_flag IN out nocopy varchar2,
759 p_payslip_view_date_prompt IN out nocopy varchar2
760 );
761
762 --
763 -----------------------------------------------------------------------------
764 -- Name --
765 -- show_ddf_canvas_yesno --
769 -- Arguments --
766 -- Purpose --
767 -- If at least one segment has been defined for the Payroll DDF, then --
768 -- the PAYROLL_DDF canvas will be shown --
770 -- See below. --
771 -- Notes --
772 -- --
773 -----------------------------------------------------------------------------
774 --
775 PROCEDURE show_ddf_canvas_yesno ( p_ddf_name IN varchar2,
776 p_legislation_code IN varchar2,
777 p_show_ddf_canvas out nocopy boolean);
778 --
779 ------------------------------------------------------------------------------
780 --
781 PROCEDURE chk_payroll_unique
782 (
783 p_payroll_id number,
784 p_payroll_name varchar2,
785 p_business_group_id number
786 );
787 --
788 --
789 PROCEDURE validate_delete_payroll
790 (
791 p_payroll_id number,
792 p_default_payment_method_id number,
793 p_dt_delete_mode varchar2,
794 p_validation_start_date date,
795 p_validation_end_date date
796 );
797 --
798 PROCEDURE maintain_dflt_payment_method
799 (
800 p_payroll_id number,
801 p_default_payment_method_id number,
802 p_validation_start_date date,
803 p_validation_end_date date
804 );
805 --
806 PROCEDURE propagate_changes
807 (
808 p_payroll_id number,
809 p_payroll_name varchar2,
810 p_number_of_years number
811 );
812 --
813 END PAY_PAYROLLS_F_PKG;