1 PACKAGE pay_us_report_data_validation AUTHID CURRENT_USER AS
2 /* $Header: payusdatavalid.pkh 115.2 2003/10/30 15:27 ppanda noship $ */
3
4 /*===========================================================================+
5 | Copyright (c) 2001 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +============================================================================+
9
10 Name
11 pay_us_report_data_validation
12
13 Purpose
14 The purpose of this package is to validate EIN, SSN etc
15 to support the generation of magnetic tape W2 / SQWL reports
16 for US legilsative requirements.
17
18 Notes
19 Referenced By: Package pay_us_reporting_utils_pkg
20
21 Notes
22
23 History
24 15-Jul-03 ppanda 115.0 Created
25
26 */
27
28 /* Following is to validate EIN to support SQWL Reporting */
29 FUNCTION validate_SQWL_EIN( p_report_qualifier IN varchar2,
30 p_record_name IN varchar2,
31 p_input_2 IN varchar2,
32 p_input_4 IN varchar2,
33 p_validate IN varchar2,
34 p_err OUT nocopy boolean
35 ) return varchar2;
36
37 /* Following is to validate EIN to support W2 Reporting */
38 FUNCTION validate_W2_EIN( p_report_qualifier IN varchar2,
39 p_record_name IN varchar2,
40 p_input_2 IN varchar2,
41 p_input_4 IN varchar2,
42 p_validate IN varchar2,
43 p_err OUT nocopy boolean
44 ) return varchar2;
45
46 /* Following is to validate EIN to support SQWL Reporting */
47 FUNCTION validate_SQWL_SSN(p_effective_date IN varchar2,
48 p_report_type IN varchar2,
49 p_format IN varchar2,
50 p_report_qualifier IN varchar2,
51 p_record_name IN varchar2,
52 p_input_1 IN varchar2,
53 p_input_2 IN varchar2,
54 p_input_3 IN varchar2,
55 p_input_4 IN varchar2,
56 p_input_5 IN varchar2,
57 p_validate IN varchar2,
58 p_err OUT nocopy boolean
59 ) return varchar2;
60
61 /* Following is to validate EIN to support W2 Reporting */
62 FUNCTION validate_W2_SSN(p_effective_date IN varchar2,
63 p_report_type IN varchar2,
64 p_format IN varchar2,
65 p_report_qualifier IN varchar2,
66 p_record_name IN varchar2,
67 p_input_1 IN varchar2,
68 p_input_2 IN varchar2,
69 p_input_3 IN varchar2,
70 p_input_4 IN varchar2,
71 p_input_5 IN varchar2,
72 p_validate IN varchar2,
73 p_err OUT nocopy boolean
74 ) return varchar2;
75
76 END pay_us_report_data_validation;