1 package hr_ca_ff_udfs as
2 /* $Header: pycaudfs.pkh 120.1.12000000.3 2007/02/20 01:20:21 ssouresr noship $ */
3 /*
4 +======================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +======================================================================+
9
10 Date Name Vers Bug No Description
11 ---- ---- ---- ------ -----------
12 05-MAY-1999 mmukherj 110.0 Created
13 The file is Canadian
14 version of pyusudfs.pkh
15 14-FEB-2000 SSattineni 110.1 Changed the datatype
16 of date_earned from
17 varchar2 to date.
18 19-SEP-2001 SSattineni 110.3 Changed the default values
19 from 'NULL' to 'NOT ENTERED'
20 for parameters
21 P_ASST_WORK_SCHEDULE,
22 P_FROM_FREQ, P_TO_FREQ
23 to maintain consistency in
24 pkg header and pkg body.
25 10-Jan-2002 vpandya 115.4 Added dbdrv lines for gscc
26 22-Jan-2003 vpandya 115.5 Added nocopy with out parameter
27 28-OCT-2005 mmukherj 115.6 Added extra parameters in
28 calculate_period_earnings
29 and convert_period_type
30 21-NOV-2006 saikrish 115.7 5097793 Added get_earnings_and_type
31
32 --- See below for old history --
33
34 The History for pyusudfs is below
35 Name : chained_element_exists
36 Filename : pychaind.sql
37 Change List
38 -----------
39 Date Name Vers Bug No Description
40 ---- ---- ---- ------ -----------
41 16-NOV-93 hparicha 1.0 Created
42 07-JAN-94 jmychale 40.7 G491 Removed actual hours worked
43 param from Calculate_Period_
44 Earnings.
45 13-JAN-94 hparicha 40.8 G497 Reverted to version 40.6
46 NEED actual hours worked for
47 Statement of Earnings report.
48 02-FEB-94 hparicha 40.9 G542 Added Dedn_Freq_Factor.
49 06-JUN-94 hparicha 40.10 G815 Added Arrearage function.
50 15-JUL-94 hparicha 40.2 G907 Beta I freeze (new version
51 numbers b/c now in UK arcs)
52 26-OCT-94 hparicha 40.3 G1342 Included as part of this STU
53 bug. Added "addr_val" for
54 use by VERTEX formulae and
55 "get_geocode".
56 04-JAN-95 hparicha 40.4 G1565 Vacation/Sick correlation
57 to Regular Pay - changes to
58 Calc Period Earns.
59 40.5 ???
60 40.6 ???
61 40.7 ???
62
63 12-JUL-96 hparicha 40.8 366215 Removed consumed_entry fn
64 because package body too
65 large...moved into
66 pay_consumed_entry pckg
67 pyconsum.pkh, pkb.
68 --
69 08-Dec-97 kmundair 40.9(110.1) 509120 overloaded addr_val function.
70 */
71 --
72 FUNCTION Calculate_Period_Earnings (
73 p_bus_grp_id in NUMBER,
74 p_asst_id in NUMBER,
75 p_assignment_action_id in NUMBER,
76 p_payroll_id in NUMBER,
77 p_ele_entry_id in NUMBER,
78 p_tax_unit_id in NUMBER,
79 p_date_earned in DATE,
80 p_pay_basis in VARCHAR2 default NULL,
81 p_inpval_name in VARCHAR2 default NULL,
82 p_ass_hrly_figure in NUMBER,
83 p_period_start in DATE,
84 p_period_end in DATE,
85 p_work_schedule in VARCHAR2 default NULL,
86 p_asst_std_hrs in NUMBER default NULL,
87 p_actual_hours_worked in out nocopy NUMBER,
88 p_prorate in VARCHAR2 default 'Y',
89 p_asst_std_freq in VARCHAR2 default NULL)
90 RETURN NUMBER;
91 --
92 FUNCTION standard_hours_worked(
93 p_std_hrs in NUMBER,
94 p_range_start in DATE,
95 p_range_end in DATE,
96 p_std_freq in VARCHAR2) RETURN NUMBER;
97 --
98 FUNCTION Convert_Period_Type(
99 p_bus_grp_id in NUMBER,
100 p_payroll_id in NUMBER,
101 p_assignment_action_id in NUMBER,
102 p_assignment_id in NUMBER,
103 p_element_entry_id in NUMBER,
104 p_date_earned in DATE,
105 p_asst_work_schedule in VARCHAR2 default 'NOT ENTERED',
106 p_asst_std_hours in NUMBER default NULL,
107 p_figure in NUMBER,
108 p_from_freq in VARCHAR2 default 'NOT ENTERED',
109 p_to_freq in VARCHAR2 default 'NOT ENTERED',
110 p_period_start_date in DATE default NULL,
111 p_period_end_date in DATE default NULL,
112 p_asst_std_freq in VARCHAR2 default NULL)
113 RETURN NUMBER;
114 --
115 FUNCTION work_schedule_total_hours(
116 p_bg_id in NUMBER,
117 p_ws_name in VARCHAR2,
118 p_range_start in DATE default NULL,
119 p_range_end in DATE default NULL) RETURN NUMBER;
120 --
121 FUNCTION chained_element_exists(p_bg_id in NUMBER,
122 p_asst_id in NUMBER,
123 p_payroll_id in NUMBER,
124 p_date_earned in DATE,
125 p_ele_name IN VARCHAR2) RETURN VARCHAR2;
126 --
127 FUNCTION us_jurisdiction_val (p_jurisdiction_code in VARCHAR2) RETURN VARCHAR2;
128 --
129 FUNCTION get_process_run_flag ( p_date_earned IN DATE,
130 p_ele_type_id IN NUMBER) RETURN VARCHAR2;
131 --
132 FUNCTION check_dedn_freq ( p_payroll_id IN NUMBER,
133 p_bg_id IN NUMBER,
134 p_pay_action_id IN NUMBER,
135 p_date_earned IN DATE,
136 p_ele_type_id IN NUMBER) RETURN VARCHAR2;
137 --
138 FUNCTION Separate_Check_Skip (
139 p_bg_id in NUMBER,
140 p_element_type_id in NUMBER,
141 p_assact_id in NUMBER,
142 p_payroll_id in NUMBER,
143 p_date_earned in DATE) RETURN VARCHAR2;
144 --
145 FUNCTION Other_Non_Separate_Check (
146 p_date_earned IN DATE,
147 p_ass_id IN NUMBER) RETURN VARCHAR2;
148 --
149 FUNCTION OT_Base_Rate ( p_bg_id in NUMBER,
150 p_pay_id in NUMBER,
151 p_ass_id in NUMBER,
152 p_ass_action_id in NUMBER,
153 p_date_earned in DATE,
154 p_work_sched in VARCHAR2 default NULL,
155 p_std_hours in NUMBER default NULL,
156 p_ass_salary in NUMBER,
157 p_ass_sal_basis in VARCHAR2,
158 p_std_freq in VARCHAR2 default NULL)
159 RETURN NUMBER;
160 --
161 FUNCTION Dedn_Freq_Factor (
162 p_payroll_id in NUMBER,
163 p_element_type_id in NUMBER,
164 p_date_earned in DATE,
165 p_ele_period_type in VARCHAR2 default NULL)
166 RETURN NUMBER;
167 --
168 FUNCTION Arrearage ( p_eletype_id IN NUMBER,
169 p_date_earned IN DATE,
170 p_partial_flag IN VARCHAR2 DEFAULT 'N',
171 p_net_asg_run IN NUMBER,
172 p_arrears_itd IN NUMBER,
173 p_guaranteed_net IN NUMBER,
174 p_dedn_amt IN NUMBER,
175 p_to_arrears IN OUT NOCOPY NUMBER,
176 p_not_taken IN OUT NOCOPY NUMBER)
177 RETURN NUMBER;
178 --
179 FUNCTION addr_val ( p_state_abbrev IN VARCHAR2 DEFAULT NULL,
180 p_county_name IN VARCHAR2 DEFAULT NULL,
181 p_city_name IN VARCHAR2 DEFAULT NULL,
182 p_zip_code IN VARCHAR2 DEFAULT NULL)
183 RETURN VARCHAR2;
184 --
185 FUNCTION addr_val ( p_state_abbrev IN VARCHAR2 DEFAULT NULL,
186 p_county_name IN VARCHAR2 DEFAULT NULL,
187 p_city_name IN VARCHAR2 DEFAULT NULL,
188 p_zip_code IN VARCHAR2 DEFAULT NULL,
189 p_skip_rule IN VARCHAR2 )
190 RETURN VARCHAR2;
191 --
192 FUNCTION get_earnings_and_type( p_bus_grp_id IN NUMBER,
193 p_asst_id IN NUMBER,
194 p_assignment_action_id IN NUMBER,
195 p_payroll_id IN NUMBER,
196 p_ele_entry_id IN NUMBER,
197 p_tax_unit_id IN NUMBER,
198 p_date_earned IN DATE,
199 p_pay_basis IN VARCHAR2 DEFAULT NULL,
200 p_period_start IN DATE,
201 p_period_end IN DATE,
202 p_element_type IN OUT NOCOPY VARCHAR2,
203 p_value IN OUT NOCOPY NUMBER,
204 p_input_value_name IN OUT NOCOPY VARCHAR2)
205 RETURN NUMBER;
206 --
207 END hr_ca_ff_udfs;