1 package pay_us_mmref_function_pkg AUTHID CURRENT_USER as
2 /* $Header: pyusmrfn.pkh 115.6 2004/03/01 15:26:24 jgoswami noship $ */
3 /*===========================================================================+
4 | Copyright (c) 2001 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +============================================================================+
8 Name
9 pay_us_mmref_function_pkg
10
11 Purpose
12 The purpose of this package is to support the generation of magnetic tape W2
13 reports for US legilsative requirements incorporating magtape resilience
14 and the new end-of-year design. New Functions will support the Year end
15 reporting in MMREF format initially and will be extended to have more
16 format.
17
18 Notes
19
20 History
21 23-Jan-02 fusman 115.0 created
22 09-feb-02 djoshi 115.1 changed for dbdrv
23 14-may-02 fusman 115.2 Added Get_Hours_Worked function.
24 02-Dec-02 ppanda 115.3 Nocopy hint added to OUT and IN OUT parameters
25 19-FEB-03 sodhingr 115.4 Changed Get_hours_worked for bug
26 2442629, to pass new balances for SUI
27 hours by state
28 23-Apr-03 fusman 115.5 Bug: 2873551 Created new function get_sqwl_extra_info
29 to calculate the SUI_ER_SUBJ_WHABLE and SUI_ER_PRE_TAX.
30 01-MAR-03 JGoswami 115.6 Bug:333497 Added IN OUT parameters to
31 Get_Sqwl_Extra_Info function
32
33 ===========================================================================*/
34
35 /* Function Name : Get_City_Values
36 Purpose : Purpose of this function is to fetch the city codes
37 and names for the given jurisdiction_code.
38 Error checking
39
40 Special Note :
41
42
43 */
44
45 FUNCTION Get_City_Values(p_jurisdiction_code IN varchar2,
46 p_effective_date IN varchar2,
47 p_input_1 IN varchar2,
48 p_input_2 IN varchar2,
49 p_input_3 IN varchar2,
50 p_input_4 IN varchar2,
51 p_input_5 IN varchar2,
52 sp_out_1 OUT nocopy varchar2,
53 sp_out_2 OUT nocopy varchar2,
54 sp_out_3 OUT nocopy varchar2,
55 sp_out_4 OUT nocopy varchar2,
56 sp_out_5 OUT nocopy varchar2,
57 sp_out_6 OUT nocopy varchar2,
58 sp_out_7 OUT nocopy varchar2,
59 sp_out_8 OUT nocopy varchar2,
60 sp_out_9 OUT nocopy varchar2,
61 sp_out_10 OUT nocopy varchar2)
62
63 return varchar2;
64
65 FUNCTION Get_Hours_Worked(p_report_type IN varchar2,
66 p_report_qualifier IN varchar2,
67 p_record_name IN varchar2,
68 p_regular_hours IN number,
69 p_sui_er_gross IN number,
70 p_gross_earnings IN number,
71 p_asg_hours IN number,
72 p_asg_freq IN varchar2,
73 p_scl_asg_work_sch IN varchar2,
74 p_input_1 IN varchar2,
75 p_input_2 IN varchar2,
76 sp_out_1 IN OUT nocopy varchar2,
77 sp_out_2 IN OUT nocopy varchar2,
78 sp_out_3 IN OUT nocopy varchar2,
79 sp_out_4 IN OUT nocopy varchar2,
80 sp_out_5 IN OUT nocopy varchar2)
81
82
83 return varchar2;
84
85
86 FUNCTION Get_Sqwl_Extra_Info(p_payroll_action_id NUMBER, --CONTEXT
87 p_tax_unit_id NUMBER, --CONTEXT
88 p_report_type IN varchar2,
89 p_report_qualifier IN varchar2,
90 p_input_1 IN varchar2,
91 p_input_2 IN varchar2,
92 p_input_3 IN varchar2,
93 p_output_1 IN OUT nocopy varchar2,
94 p_output_2 IN OUT nocopy varchar2,
95 p_output_3 IN OUT nocopy varchar2)
96
97 return varchar2;
98
99
100 END pay_us_mmref_function_pkg;