1 package PER_ZA_PTO_ACCRUAL_PERIOD AUTHID CURRENT_USER as
2 /* $Header: perzaapl.pkh 120.1.12000000.1 2007/01/22 04:14:16 appldev noship $ */
3 /*==========================================================================
4 This package contains accrual plan functions. Each Accrual Plan set up
5 under HRMS has a main accrual formula which calls one of these functions
6 to calculate the accrued PTO for each period. The original PTO design
7 had the main accrual formula calling a looping sub-accrual formula but the
8 performance was a problem.
9
10 MODIFICATION HISTORY
11 Person Date Version Comments
12 ------- ------ -------- -----------------------
13 R.Kingham 15-MAR-2000 110.0 Initial Version
14 J.N. Louw 24-Aug-2000 115.0 Updated for ZAPatch11i.01
15 L.Kloppers 21-Dec-2000 115.1 Put 'create...' on one line
16 P.Vaish 07-JUL-02 115.2 Added calculation date as an
17 input parameter.
18 R.Pahune 14-Aug-2003 115.3 Added Procedure
19 ZA_PTO_CARRYOVER_RESI_VALUE
20 for the bug no 2932073
21 if the carry over is -ve made it 0
22 along with earlier ZA specific
23 requirements.
24 =========================================================================*/
25
26 function ZA_PTO_ANNLEAVE_PERIOD_LOOP (p_Assignment_ID IN Number
27 ,p_Plan_ID IN Number
28 ,p_Payroll_ID IN Number
29 ,p_calculation_date IN Date)
30 return number;
31 --
32 function ZA_PTO_SICKLEAVE_PERIOD_LOOP (p_Assignment_ID IN Number
33 ,p_Plan_ID IN Number
34 ,p_Payroll_ID IN Number)
35 return number;
36 --
37
38 /* Start Bug 2932073 And 2878657 */
39 procedure ZA_PTO_CARRYOVER_RESI_VALUE (
40 p_assignment_id IN Number
41 ,p_plan_id IN Number
42 ,l_payroll_id IN Number
43 ,p_business_group_id IN Number
44 ,l_effective_date IN Date
45 ,l_total_accrual IN Number
46 ,l_net_entitlement IN number
47 ,l_max_carryover IN Number
48 ,l_residual OUT NOCOPY Number
49 ,l_carryover OUT NOCOPY Number);
50
51
52
53 --
54 /* End Bug 2932073 And 2878657 */
55
56 end PER_ZA_PTO_ACCRUAL_PERIOD;
[Home] [Help]