1 PACKAGE hr_au_holidays AS
2 -- $Header: hrauhol.pkh 120.0.12000000.1 2007/01/22 14:15:25 appldev ship $
3 --
4 -- Copyright (C) 2000 Oracle Corporation
5 -- All Rights Reserved
6 --
7 -- Script to create AU HRMS hr_au_holidays package
8 --
9 -- Change List
10 -- ===========
11 --
12 -- Date Author Ver Description
13 -- -----------+---------+-------+------------------------------------------
14 -- 02 Dec 2002 Apunekar 115.12 Bug#2689173-Added Nocopy to out and in out parameters
15 -- 10-Dec-2001 srussell 115.10 Put in checkfile syntax.
16 -- 28-Nov-2001 nnaresh 115.9 Updated for GSCC Standards
17 -- 12-Sep-2001 shoskatt 115.8 Included the get_leave_initialise function. Bug #1942971
18 -- 25-Jan-2000 sclarke 115.7 Moved term_lsl_eligibility_years to pay_au_terminations
19 -- 29-May-2000 makelly 115.6 Added get_net_accrual_wrapper back
20 -- 26-May-2000 makelly 115.5 Bug 1313971 Removed get_net_accrual wrapper.
21 -- 03-May-2000 makelly 115.4 Bug 1273677 and added accrual_entitlement fn
22 -- to simplify calls from accrual/absence forms
23 -- 21-Mar-2000 makelly 115.3 Bug in call to asg_working_hours
24 -- 15-MAR-2000 sclarke 115.2 New procedure for LSL
25 -- 21 Jan 2000 makelly 115.1 Initial - Based on hrnzhol.pkh
26 --
27
28 g_package constant varchar2(33) := ' hr_au_holidays.';
29
30 FUNCTION get_accrual_plan_by_category
31 (p_assignment_id IN NUMBER
32 ,p_effective_date IN DATE
33 ,p_plan_category IN VARCHAR2)
34 RETURN NUMBER;
35
36 --
37 -- get_net_accrual
38 --
39 -- This function is a wrapper for the
40 -- per_accrual_calc_functions.get_net_accrual procedure. The
41 -- wrapper is required so that a FastFormula function can be
42 -- registered for use in formulas.
43 --
44
45 FUNCTION get_net_accrual
46 (p_assignment_id IN NUMBER
47 ,p_payroll_id IN NUMBER
48 ,p_business_group_id IN NUMBER
49 ,p_plan_id IN NUMBER
50 ,p_calculation_date IN DATE)
51 RETURN NUMBER;
52
53
54 FUNCTION get_accrual_entitlement
55 (p_assignment_id IN NUMBER
56 ,p_payroll_id IN NUMBER
57 ,p_business_group_id IN NUMBER
58 ,p_plan_id IN NUMBER
59 ,p_calculation_date IN DATE
60 ,p_net_accrual OUT NOCOPY NUMBER
61 ,p_net_entitlement OUT NOCOPY NUMBER
62 ,p_calc_start_date OUT NOCOPY DATE
63 ,p_last_accrual OUT NOCOPY DATE
64 ,p_next_period_end OUT NOCOPY DATE)
65 RETURN NUMBER;
66
67 FUNCTION get_annual_leave_plan
68 (p_assignment_id IN NUMBER
69 ,p_business_group_id IN NUMBER
70 ,p_calculation_date IN DATE)
71 RETURN NUMBER;
72
73 FUNCTION get_continuous_service_date
74 (p_assignment_id IN NUMBER
75 ,p_business_group_id IN NUMBER
76 ,p_accrual_plan_id IN NUMBER
77 ,p_calculation_date IN DATE)
78 RETURN DATE;
79
80
81 -----------------------------------------------------------------------------
82 -- accrual_daily_basis function
83 -----------------------------------------------------------------------------
84
85 FUNCTION accrual_daily_basis
86 ( p_payroll_id IN NUMBER
87 ,p_accrual_plan_id IN NUMBER
88 ,p_assignment_id IN NUMBER
89 ,p_calculation_start_date IN DATE
90 ,p_calculation_end_date IN DATE
91 ,p_service_start_date IN DATE
92 ,p_business_group_hours IN NUMBER
93 ,p_business_group_freq IN VARCHAR2)
94 RETURN NUMBER ;
95
96 FUNCTION days_suspended
97 ( p_assignment_id IN NUMBER
98 ,p_start_date IN DATE
99 ,p_end_date IN DATE)
100 RETURN NUMBER;
101
102 FUNCTION check_periods
103 ( p_payroll_id IN NUMBER)
104 RETURN DATE;
105
106 FUNCTION adjust_for_suspend_assign
107 ( p_assignment_id IN NUMBER
108 ,p_adjust_date IN DATE
109 ,p_start_date IN DATE
110 ,p_end_date IN DATE)
111 RETURN DATE;
112
113 ----------------------------------------------------------------------
114 --- Bug #1942971 ---- Start
115 ----------------------------------------------------------------------
116 FUNCTION get_leave_initialise
117 ( p_assignment_id IN NUMBER
118 ,p_accrual_plan_id IN NUMBER
119 ,p_calc_end_date IN DATE
120 ,p_initialise_type IN VARCHAR2
121 ,p_start_date IN DATE
122 ,p_end_date IN DATE)
123 RETURN NUMBER;
124 ----------------------------------------------------------------------
125 --- Bug #1942971 ---- End
126 ----------------------------------------------------------------------
127
128 FUNCTION get_lsl_entitlement_date
129 ( p_accrual_plan_id IN NUMBER
130 ,p_assignment_id IN NUMBER
131 ,p_enrollment_date IN DATE
132 ,p_service_start_date IN DATE
133 ,p_calculation_date IN DATE
134 ,p_next_entitlement_date IN OUT NOCOPY DATE)
135 RETURN DATE;
136
137 FUNCTION validate_accrual_plan_name
138 ( p_business_group_id IN NUMBER
139 ,p_entry_value IN VARCHAR2)
140 RETURN NUMBER;
141
142 END hr_au_holidays ;