1 package pay_au_leave_liability AUTHID CURRENT_USER as
2 -- $Header: pyaullal.pkh 115.3 2002/12/04 07:23:12 ragovind ship $
3
4 -- Copyright (C) 1999 Oracle Corporation
5 -- All Rights Reserved
6 --
7 -- Script to create AU HRMS leave liability package.
8 --
9 -- Change List
10 -- ===========
11 --
12 -- Date Author Reference Description
13 -- -----------+--------+---------+-------------
14 -- 14 JUL 2000 rayyadev N/A Created
15 -- 06 oct 2000 rayyadev N/A Added the Specification for the leave_
16 -- net accrual Procedure
17 -- 05 Dec 2002 Ragovind 2689226 Added NOCOPY for the functions leave_net_accrual, leave_net_entitlement, range_code and added gscc
18
19 -----------------------------------------------------------------------------
20 -- range_code procedure
21 -----------------------------------------------------------------------------
22
23 procedure range_code
24 (p_payroll_action_id in number
25 ,p_sql out NOCOPY varchar2) ;
26
27 -----------------------------------------------------------------------------
28 -- assignment_action_code procedure
29 -----------------------------------------------------------------------------
30
31 procedure assignment_action_code
32 (p_payroll_action_id in number
33 ,p_start_person_id in number
34 ,p_end_person_id in number
35 ,p_chunk in number) ;
36
37 -----------------------------------------------------------------------------
38 -- initialization_code procedure
39 -----------------------------------------------------------------------------
40
41 procedure initialization_code
42 (p_payroll_action_id in number) ;
43
44 -----------------------------------------------------------------------------
45 -- archive_code procedure
46 -----------------------------------------------------------------------------
47
48 procedure archive_code
49 (p_assignment_action_id in number
50 ,p_effective_date in date) ;
51
52 -----------------------------------------------------------------------------
53 -- hourly_rate procedure
54 -----------------------------------------------------------------------------
55
56
57 procedure hourly_rate ;
58
59 -----------------------------------------------------------------------------
60 -- leave_net_entitlement
61 -----------------------------------------------------------------------------
62
63 procedure leave_net_entitlement
64 (p_assignment_id in number
65 ,p_payroll_id in number
66 ,p_business_group_id in number
67 ,p_plan_id in number
68 ,p_calculation_date in date
69 ,p_start_date out NOCOPY date
70 ,p_end_date out NOCOPY date
71 ,p_net_entitlement out NOCOPY number);
72
73 procedure leave_net_accrual
74 (p_assignment_id IN NUMBER
75 ,p_payroll_id IN NUMBER
76 ,p_business_group_id IN NUMBER
77 ,p_plan_id IN NUMBER
78 ,p_calculation_date IN DATE
79 ,p_net_accrual OUT NOCOPY NUMBER
80 ,p_net_entitlement OUT NOCOPY NUMBER
81 ,p_calc_start_date OUT NOCOPY DATE
82 ,p_last_accrual OUT NOCOPY DATE
83 ,p_next_period_end OUT NOCOPY DATE) ;
84
85 FUNCTION get_weekdays_in_period
86 (p_start_date IN DATE
87 ,p_end_date IN DATE)
88 RETURN NUMBER;
89
90 end pay_au_leave_liability ;