1 PACKAGE pay_us_custom_sqwl_format_rec AS
2 /* $Header: pyuscussqfr.pkh 120.0.12000000.1 2007/01/18 02:14:26 appldev 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_custom_sqwl_format_rec
12
13 Purpose
14 The purpose of this package is to format reacord to support the
15 generation of SQWL magnetic tape for US legilsative requirements.
16
17 Notes
18 Referenced By: Package pay_us_reporting_utils_pkg
19
20 History
21
22 24-feb-2004 jgoswami 115.0 3334497 Created
23
24 */
25
26
27 --
28 -- This function formats Custom_Submitter Record for SQWL reporting
29 -- For Future Use
30
31 --
32 -- This function formats Custom Employer Record for SQWL reporting
33 --
34 --
35 FUNCTION FORMAT_SQWL_CUSTOM_EMPLOYER(
36 p_effective_date IN varchar2,
37 p_report_type IN varchar2,
38 p_format IN varchar2,
39 p_report_qualifier IN varchar2,
40 p_record_name IN varchar2,
41 p_input_1 IN varchar2,
42 p_input_2 IN varchar2,
43 p_input_3 IN varchar2,
44 p_input_4 IN varchar2,
45 p_input_5 IN varchar2,
46 p_input_6 IN varchar2,
47 p_input_7 IN varchar2,
48 p_input_8 IN varchar2,
49 p_input_9 IN varchar2,
50 p_input_10 IN varchar2,
51 p_input_11 IN varchar2,
52 p_input_12 IN varchar2,
53 p_input_13 IN varchar2,
54 p_input_14 IN varchar2,
55 p_input_15 IN varchar2,
56 p_input_16 IN varchar2,
57 p_input_17 IN varchar2,
58 p_input_18 IN varchar2,
59 p_input_19 IN varchar2,
60 p_input_20 IN varchar2,
61 p_input_21 IN varchar2,
62 p_input_22 IN varchar2,
63 p_input_23 IN varchar2,
64 p_input_24 IN varchar2,
65 p_input_25 IN varchar2,
66 p_input_26 IN varchar2,
67 p_input_27 IN varchar2,
68 p_input_28 IN varchar2,
69 p_input_29 IN varchar2,
70 p_input_30 IN varchar2,
71 p_input_31 IN varchar2,
72 p_input_32 IN varchar2,
73 p_input_33 IN varchar2,
74 p_input_34 IN varchar2,
75 p_input_35 IN varchar2,
76 p_input_36 IN varchar2,
77 p_input_37 IN varchar2,
78 p_input_38 IN varchar2,
79 p_input_39 IN varchar2,
80 p_input_40 IN varchar2,
81 p_validate IN varchar2,
82 p_exclude_from_output OUT nocopy varchar2,
83 sp_out_1 OUT nocopy varchar2,
84 sp_out_2 OUT nocopy varchar2,
85 sp_out_3 OUT nocopy varchar2,
86 sp_out_4 OUT nocopy varchar2,
87 sp_out_5 OUT nocopy varchar2,
88 ret_str_len OUT nocopy number,
89 p_error OUT nocopy boolean
90 ) RETURN VARCHAR2;
91
92 /*
93 --
94 -- This function formats Custom Employee Record for SQWL reporting
95 --
96 */
97
98 FUNCTION format_SQWL_CUSTOM_EMPLOYEE(
99 p_effective_date IN varchar2,
100 p_report_type IN varchar2,
101 p_format IN varchar2,
102 p_report_qualifier IN varchar2,
103 p_record_name IN varchar2,
104 p_input_1 IN varchar2,
105 p_input_2 IN varchar2,
106 p_input_3 IN varchar2,
107 p_input_4 IN varchar2,
108 p_input_5 IN varchar2,
109 p_input_6 IN varchar2,
110 p_input_7 IN varchar2,
111 p_input_8 IN varchar2,
112 p_input_9 IN varchar2,
113 p_input_10 IN varchar2,
114 p_input_11 IN varchar2,
115 p_input_12 IN varchar2,
116 p_input_13 IN varchar2,
117 p_input_14 IN varchar2,
118 p_input_15 IN varchar2,
119 p_input_16 IN varchar2,
120 p_input_17 IN varchar2,
121 p_input_18 IN varchar2,
122 p_input_19 IN varchar2,
123 p_input_20 IN varchar2,
124 p_input_21 IN varchar2,
125 p_input_22 IN varchar2,
126 p_input_23 IN varchar2,
127 p_input_24 IN varchar2,
128 p_input_25 IN varchar2,
129 p_input_26 IN varchar2,
130 p_input_27 IN varchar2,
131 p_input_28 IN varchar2,
132 p_input_29 IN varchar2,
133 p_input_30 IN varchar2,
134 p_input_31 IN varchar2,
135 p_input_32 IN varchar2,
136 p_input_33 IN varchar2,
137 p_input_34 IN varchar2,
138 p_input_35 IN varchar2,
139 p_input_36 IN varchar2,
140 p_input_37 IN varchar2,
141 p_input_38 IN varchar2,
142 p_input_39 IN varchar2,
143 p_input_40 IN varchar2,
144 p_validate IN varchar2,
145 p_exclude_from_output OUT nocopy varchar2,
146 sp_out_1 OUT nocopy varchar2,
147 sp_out_2 OUT nocopy varchar2,
148 sp_out_3 OUT nocopy varchar2,
149 sp_out_4 OUT nocopy varchar2,
150 sp_out_5 OUT nocopy varchar2,
151 ret_str_len OUT nocopy number,
152 p_error OUT nocopy boolean
153 ) RETURN VARCHAR2;
154
155 --
156 -- Formating Custom Employer Total record for SQWL reporting
157 --
158
159 --
160 -- Formatting CUSTOM_FILE_TOTAL_RECORD record for SQWL reporting
161 -- For Future Use
162
163 END pay_us_custom_sqwl_format_rec;