4 -- Copyright (C) 2000 Oracle Corporation
1 PACKAGE hr_au_holidays AUTHID CURRENT_USER AS
2 -- $Header: hrauhol.pkh 120.3 2010/11/23 12:38:29 avenkatk ship $
3 --
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 -- 16-Nov-2010 avenkatk 115.15 Bug #9950136 - Added globals and procedure for
15 -- foreign workers accruals
16 -- 16 Dec 2008 pmatamsr 115.14 Bug#7607177-Added function au_get_enrollment_startdate to
17 -- retrieve the PTO accrual enrollment start date.
18 -- 02 Dec 2002 Apunekar 115.12 Bug#2689173-Added Nocopy to out and in out parameters
19 -- 10-Dec-2001 srussell 115.10 Put in checkfile syntax.
20 -- 28-Nov-2001 nnaresh 115.9 Updated for GSCC Standards
24 -- 26-May-2000 makelly 115.5 Bug 1313971 Removed get_net_accrual wrapper.
21 -- 12-Sep-2001 shoskatt 115.8 Included the get_leave_initialise function. Bug #1942971
22 -- 25-Jan-2000 sclarke 115.7 Moved term_lsl_eligibility_years to pay_au_terminations
23 -- 29-May-2000 makelly 115.6 Added get_net_accrual_wrapper back
25 -- 03-May-2000 makelly 115.4 Bug 1273677 and added accrual_entitlement fn
26 -- to simplify calls from accrual/absence forms
27 -- 21-Mar-2000 makelly 115.3 Bug in call to asg_working_hours
28 -- 15-MAR-2000 sclarke 115.2 New procedure for LSL
29 -- 21 Jan 2000 makelly 115.1 Initial - Based on hrnzhol.pkh
30 --
31
32 g_package constant varchar2(33) := ' hr_au_holidays.';
33
34 FUNCTION get_accrual_plan_by_category
35 (p_assignment_id IN NUMBER
36 ,p_effective_date IN DATE
37 ,p_plan_category IN VARCHAR2)
38 RETURN NUMBER;
39
40 --
41 -- get_net_accrual
42 --
43 -- This function is a wrapper for the
44 -- per_accrual_calc_functions.get_net_accrual procedure. The
45 -- wrapper is required so that a FastFormula function can be
46 -- registered for use in formulas.
47 --
48
49 FUNCTION get_net_accrual
50 (p_assignment_id IN NUMBER
51 ,p_payroll_id IN NUMBER
52 ,p_business_group_id IN NUMBER
53 ,p_plan_id IN NUMBER
54 ,p_calculation_date IN DATE)
55 RETURN NUMBER;
56
57
58 FUNCTION get_accrual_entitlement
59 (p_assignment_id IN NUMBER
60 ,p_payroll_id IN NUMBER
61 ,p_business_group_id IN NUMBER
62 ,p_plan_id IN NUMBER
63 ,p_calculation_date IN DATE
64 ,p_net_accrual OUT NOCOPY NUMBER
65 ,p_net_entitlement OUT NOCOPY NUMBER
66 ,p_calc_start_date OUT NOCOPY DATE
67 ,p_last_accrual OUT NOCOPY DATE
68 ,p_next_period_end OUT NOCOPY DATE)
69 RETURN NUMBER;
70
71 FUNCTION get_annual_leave_plan
72 (p_assignment_id IN NUMBER
73 ,p_business_group_id IN NUMBER
74 ,p_calculation_date IN DATE)
75 RETURN NUMBER;
76
77 FUNCTION get_continuous_service_date
78 (p_assignment_id IN NUMBER
79 ,p_business_group_id IN NUMBER
80 ,p_accrual_plan_id IN NUMBER
81 ,p_calculation_date IN DATE)
82 RETURN DATE;
83
84
85 -----------------------------------------------------------------------------
86 -- accrual_daily_basis function
87 -----------------------------------------------------------------------------
88
89 FUNCTION accrual_daily_basis
90 ( p_payroll_id IN NUMBER
91 ,p_accrual_plan_id IN NUMBER
92 ,p_assignment_id IN NUMBER
93 ,p_calculation_start_date IN DATE
94 ,p_calculation_end_date IN DATE
95 ,p_service_start_date IN DATE
96 ,p_business_group_hours IN NUMBER
97 ,p_business_group_freq IN VARCHAR2)
98 RETURN NUMBER ;
99
100 FUNCTION days_suspended
101 ( p_assignment_id IN NUMBER
102 ,p_start_date IN DATE
103 ,p_end_date IN DATE)
104 RETURN NUMBER;
105
106 FUNCTION check_periods
107 ( p_payroll_id IN NUMBER)
108 RETURN DATE;
109
110 FUNCTION adjust_for_suspend_assign
111 ( p_assignment_id IN NUMBER
112 ,p_adjust_date IN DATE
113 ,p_start_date IN DATE
114 ,p_end_date IN DATE)
115 RETURN DATE;
116
117 ----------------------------------------------------------------------
118 --- Bug #1942971 ---- Start
119 ----------------------------------------------------------------------
120 FUNCTION get_leave_initialise
121 ( p_assignment_id IN NUMBER
122 ,p_accrual_plan_id IN NUMBER
123 ,p_calc_end_date IN DATE
124 ,p_initialise_type IN VARCHAR2
125 ,p_start_date IN DATE
126 ,p_end_date IN DATE)
127 RETURN NUMBER;
128 ----------------------------------------------------------------------
129 --- Bug #1942971 ---- End
130 ----------------------------------------------------------------------
131
132 FUNCTION get_lsl_entitlement_date
133 ( p_accrual_plan_id IN NUMBER
134 ,p_assignment_id IN NUMBER
135 ,p_enrollment_date IN DATE
136 ,p_service_start_date IN DATE
137 ,p_calculation_date IN DATE
138 ,p_next_entitlement_date IN OUT NOCOPY DATE)
139 RETURN DATE;
140
141 FUNCTION validate_accrual_plan_name
142 ( p_business_group_id IN NUMBER
143 ,p_entry_value IN VARCHAR2)
144 RETURN NUMBER;
145
146 /*Bug# 7607177 --added function au_get_enrollment_startdate to get the enrollment
147 start date for calculation of PTO Accrual*/
148
149 FUNCTION au_get_enrollment_startdate
150 ( p_accrual_plan_id IN NUMBER
151 ,p_assignment_id IN NUMBER
152 ,p_calculation_date IN DATE )
153 RETURN DATE;
154
155 /* Bug 9950136 - Introduced global variables and procedures for
156 Foreign Worker Accruals
157 */
158
162 g_fw_exists BOOLEAN;
159 g_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
160 g_fw_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
161 g_is_fw_plan BOOLEAN;
163
164 g_assignment_id per_assignments_f.assignment_id%TYPE;
165 g_fw_f_tab_dates pay_au_foreign_workers.tab_fw_dates;
166 g_fw_j_tab_dates pay_au_foreign_workers.tab_fw_dates;
167
168
169 PROCEDURE set_accrual_ids
170 (p_accrual_plan_id IN NUMBER);
171
172
173 END hr_au_holidays ;