1 package hr_us_ff_udfs as
2 /* $Header: pyusudfs.pkh 120.0.12010000.1 2008/07/27 23:58:11 appldev ship $ */
3 /*
4 +======================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +======================================================================+
9
10 Name : chained_element_exists
11 Filename : pychaind.sql
12 Change List
13 -----------
14 Date Name Vers Bug No Description
15 ---- ---- ---- ------ -----------
16 16-NOV-93 hparicha 1.0 Created
17 07-JAN-94 jmychale 40.7 G491 Removed actual hours worked
18 param from Calculate_Period_
19 Earnings.
20 13-JAN-94 hparicha 40.8 G497 Reverted to version 40.6
21 NEED actual hours worked for
22 Statement of Earnings report.
23 02-FEB-94 hparicha 40.9 G542 Added Dedn_Freq_Factor.
24 06-JUN-94 hparicha 40.10 G815 Added Arrearage function.
25 15-JUL-94 hparicha 40.2 G907 Beta I freeze (new version
26 numbers b/c now in UK arcs)
27 26-OCT-94 hparicha 40.3 G1342 Included as part of this STU
28 bug. Added "addr_val" for
29 use by VERTEX formulae and
30 "get_geocode".
31 04-JAN-95 hparicha 40.4 G1565 Vacation/Sick correlation
32 to Regular Pay - changes to
33 Calc Period Earns.
34 40.5 ???
35 40.6 ???
36 40.7 ???
37
38 12-JUL-96 hparicha 40.8 366215 Removed consumed_entry fn
39 because package body too large...
40 moved into pay_consumed_entry pckg
41 pyconsum.pkh, pkb.
42 --
43 08-Dec-97 kmundair 40.9(110.1) 509120 overloaded addr_val function.
44 11-Aug-99 djsohi 115.2 added the function pay_us_country to get the country when country code
45 is given. This function is used
46 in the fast formula for Kentucky
47 diskette
48 06-Mar-01 ssarma 115.3 Added a new parameter to override
49 payroll level setting for
50 convert_period_type function.
51 24-Jun-02 rsirigir 115.6 As per bug 2429333
52 modified the thre parameters in
53 FUNCTION Convert_Period_Type from
54 p_asst_work_schedule in VARCHAR2 default NULL,
55 p_from_freq in VARCHAR2 default NULL
56 p_to_freq in VARCHAR2 default NULL,
57 to
58 p_asst_work_schedule in VARCHAR2
59 default 'NOT ENTERED',
60 p_from_freq in VARCHAR2
61 default 'NOT ENTERED',
62 p_to_freq in VARCHAR2
63 default 'NOT ENTERED',
64 09-Jan-2003 ekim 115.8 GSCC warnings fix for nocopy.
65 */
66 --
67 FUNCTION Calculate_Period_Earnings (
68 p_bus_grp_id in NUMBER,
69 p_asst_id in NUMBER,
70 p_payroll_id in NUMBER,
71 p_ele_entry_id in NUMBER,
72 p_tax_unit_id in NUMBER,
73 p_date_earned in DATE,
74 p_pay_basis in VARCHAR2 default NULL,
75 p_inpval_name in VARCHAR2 default NULL,
76 p_ass_hrly_figure in NUMBER,
77 p_period_start in DATE,
78 p_period_end in DATE,
79 p_work_schedule in VARCHAR2 default NULL,
80 p_asst_std_hrs in NUMBER default NULL,
81 p_actual_hours_worked in out nocopy NUMBER,
82 p_vac_hours_worked in out nocopy NUMBER,
83 p_vac_pay in out nocopy NUMBER,
84 p_sick_hours_worked in out nocopy NUMBER,
85 p_sick_pay in out nocopy NUMBER,
86 p_prorate in VARCHAR2 default 'Y',
87 p_asst_std_freq in VARCHAR2 default NULL)
88 RETURN NUMBER;
89 --
90 FUNCTION standard_hours_worked(
91 p_std_hrs in NUMBER,
92 p_range_start in DATE,
93 p_range_end in DATE,
94 p_std_freq in VARCHAR2) RETURN NUMBER;
95 --
96 FUNCTION Convert_Period_Type(
97 p_bus_grp_id in NUMBER,
98 p_payroll_id in NUMBER,
99 p_asst_work_schedule in VARCHAR2 default 'NOT ENTERED',
100 --p_asst_work_schedule in VARCHAR2 default NULL,
101 p_asst_std_hours in NUMBER default NULL,
102 p_figure in NUMBER,
103 p_from_freq in VARCHAR2 default 'NOT ENTERED',
104 p_to_freq in VARCHAR2 default 'NOT ENTERED',
105 --p_from_freq in VARCHAR2 default NULL,
106 --p_to_freq in VARCHAR2 default NULL,
107 p_period_start_date in DATE default NULL,
108 p_period_end_date in DATE default NULL,
109 p_asst_std_freq in VARCHAR2 default NULL,
110 p_rate_calc_override in VARCHAR2 default 'NOT ENTERED')
111 RETURN NUMBER;
112 --
113 FUNCTION work_schedule_total_hours(
114 p_bg_id in NUMBER,
115 p_ws_name in VARCHAR2,
116 p_range_start in DATE default NULL,
117 p_range_end in DATE default NULL) RETURN NUMBER;
118 --
119 FUNCTION chained_element_exists(p_bg_id in NUMBER,
120 p_asst_id in NUMBER,
121 p_payroll_id in NUMBER,
122 p_date_earned in DATE,
123 p_ele_name IN VARCHAR2) RETURN VARCHAR2;
124 --
125 FUNCTION us_jurisdiction_val (p_jurisdiction_code in VARCHAR2) RETURN VARCHAR2;
126 --
127 FUNCTION get_process_run_flag ( p_date_earned IN DATE,
128 p_ele_type_id IN NUMBER) RETURN VARCHAR2;
129 --
130 FUNCTION check_dedn_freq ( p_payroll_id IN NUMBER,
131 p_bg_id IN NUMBER,
132 p_pay_action_id IN NUMBER,
133 p_date_earned IN DATE,
134 p_ele_type_id IN NUMBER) RETURN VARCHAR2;
135 --
136 FUNCTION Separate_Check_Skip (
137 p_bg_id in NUMBER,
138 p_element_type_id in NUMBER,
139 p_assact_id in NUMBER,
140 p_payroll_id in NUMBER,
141 p_date_earned in DATE) RETURN VARCHAR2;
142 --
143 FUNCTION Other_Non_Separate_Check (
144 p_date_earned IN DATE,
145 p_ass_id IN NUMBER) RETURN VARCHAR2;
146 --
147 FUNCTION OT_Base_Rate ( p_bg_id in NUMBER,
148 p_pay_id in NUMBER,
149 p_ass_id in NUMBER,
150 p_ass_action_id in NUMBER,
151 p_date_earned in DATE,
152 p_work_sched in VARCHAR2 default NULL,
153 p_std_hours in NUMBER default NULL,
154 p_ass_salary in NUMBER,
155 p_ass_sal_basis in VARCHAR2,
156 p_std_freq in VARCHAR2 default NULL)
157 RETURN NUMBER;
158 --
159 FUNCTION Dedn_Freq_Factor (
160 p_payroll_id in NUMBER,
161 p_element_type_id in NUMBER,
162 p_date_earned in DATE,
163 p_ele_period_type in VARCHAR2 default NULL)
164 RETURN NUMBER;
165 --
166 FUNCTION Arrearage ( p_eletype_id IN NUMBER,
167 p_date_earned IN DATE,
168 p_partial_flag IN VARCHAR2 DEFAULT 'N',
169 p_net_asg_run IN NUMBER,
170 p_arrears_itd IN NUMBER,
171 p_guaranteed_net IN NUMBER,
172 p_dedn_amt IN NUMBER,
173 p_to_arrears IN OUT nocopy NUMBER,
174 p_not_taken IN OUT nocopy NUMBER)
175 RETURN NUMBER;
176 --
177 FUNCTION addr_val ( p_state_abbrev IN VARCHAR2 DEFAULT NULL,
178 p_county_name IN VARCHAR2 DEFAULT NULL,
179 p_city_name IN VARCHAR2 DEFAULT NULL,
180 p_zip_code IN VARCHAR2 DEFAULT NULL)
181 RETURN VARCHAR2;
182 --
183 FUNCTION addr_val ( p_state_abbrev IN VARCHAR2 DEFAULT NULL,
184 p_county_name IN VARCHAR2 DEFAULT NULL,
185 p_city_name IN VARCHAR2 DEFAULT NULL,
186 p_zip_code IN VARCHAR2 DEFAULT NULL,
187 p_skip_rule IN VARCHAR2 )
188 RETURN VARCHAR2;
189
190
191 -- function to return short coutry name for given coutry_code
192 -- us is united state
193
194 FUNCTION pay_us_country(p_territory_code IN VARCHAR2) RETURN VARCHAR2;
195 --
196 END hr_us_ff_udfs;