1 PACKAGE PAY_GB_P11D_EDI_2008 AUTHID CURRENT_USER AS
2 /* $Header: pygbp11d08.pkh 120.3.12020000.1 2012/06/28 17:55:21 appldev ship $ */
3 function get_header(p_sender_id in varchar2,
4 p_transmission_date in varchar2,
5 p_test_transmission in varchar2,
6 p_unique_reference in varchar2,
7 p_tax_year in varchar2,
8 p_missing_val in out NoCopy number,
9 p_error_count in out NoCopy number,
10 p_error_msg1 out NoCopy varchar2,
11 p_error_msg2 out NoCopy varchar2,
12 p_error_msg3 out NoCopy varchar2,
13 p_error_msg4 out NoCopy varchar2,
14 p_error_msg5 out NoCopy varchar2,
15 p_error_msg6 out NoCopy varchar2,
16 p_edi_rec1 out NoCopy varchar2,
17 p_edi_rec2 out NoCopy varchar2,
18 p_edi_rec3 out NoCopy varchar2,
19 p_edi_rec4 out NoCopy varchar2,
20 p_edi_rec5 out NoCopy varchar2,
21 p_edi_rec6 out NoCopy varchar2) return number;
22
23 function get_employer(p_tax_office_name in varchar2,
24 p_tax_phone_no in varchar2,
25 p_employer_ref in varchar2,
26 p_employer_name in varchar2,
27 p_employer_addr in varchar2,
28 p_submitter_ref in varchar2,
29 p_message_date in varchar2,
30 p_tax_year in varchar2,
31 p_party in varchar2,
32 p_error_count in out NoCopy number,
33 p_error_msg1 out NoCopy varchar2,
34 p_error_msg2 out NoCopy varchar2,
35 p_error_msg3 out NoCopy varchar2,
36 p_error_msg4 out NoCopy varchar2,
37 p_error_msg5 out NoCopy varchar2,
38 p_error_msg6 out NoCopy varchar2,
39 p_error_msg7 out NoCopy varchar2,
40 p_error_msg8 out NoCopy varchar2,
41 p_error_msg9 out NoCopy varchar2,
42 p_edi_rec1 out NoCopy varchar2,
43 p_edi_rec2 out NoCopy varchar2,
44 p_edi_rec3 out NoCopy varchar2,
45 p_edi_rec4 out NoCopy varchar2,
46 p_edi_rec5 out NoCopy varchar2,
47 p_edi_rec6 out NoCopy varchar2,
48 p_edi_rec7 out NoCopy varchar2,
49 p_edi_rec8 out NoCopy varchar2,
50 p_edi_rec9 out NoCopy varchar2,
51 p_edi_rec10 out NoCopy varchar2,
52 p_edi_rec11 out NoCopy varchar2,
53 p_edi_rec12 out NoCopy varchar2) return number;
54
55 function get_employee(p_person_id in varchar2,
56 p_pact_id in varchar2,
57 p_error_count in out NoCopy number,
58 p_error_msg1 out NoCopy varchar2,
59 p_error_msg2 out NoCopy varchar2,
60 p_error_msg3 out NoCopy varchar2,
61 p_error_msg4 out NoCopy varchar2,
62 p_error_msg5 out NoCopy varchar2,
63 p_error_msg6 out NoCopy varchar2,
64 p_error_msg7 out NoCopy varchar2,
65 p_error_msg8 out NoCopy varchar2,
66 p_edi_rec1 out NoCopy varchar2,
67 p_edi_rec2 out NoCopy varchar2,
68 p_edi_rec3 out NoCopy varchar2,
69 p_edi_rec4 out NoCopy varchar2,
70 p_edi_rec5 out NoCopy varchar2,
71 p_edi_rec6 out NoCopy varchar2,
72 p_edi_rec7 out NoCopy varchar2,
73 p_edi_rec8 out NoCopy varchar2) return number;
74
75 function get_benefit(p_benefit_type in varchar2,
76 p_person_id in varchar2,
77 p_employer_ref in varchar2,
78 p_tax_year in varchar2,
79 p_benefit_count in varchar2,
80 p_pact_id in varchar2,
81 p_value1 in out NoCopy varchar2,
82 p_value2 in out NoCopy varchar2,
83 p_value3 in out NoCopy varchar2,
84 p_value4 in out NoCopy varchar2,
85 p_value5 in out NoCopy varchar2,
86 p_value6 in out NoCopy varchar2,
87 p_value7 in out NoCopy varchar2,
88 p_value8 in out NoCopy varchar2,
89 p_value9 in out NoCopy varchar2,
90 p_value10 in out NoCopy varchar2,
91 p_value11 in out NoCopy varchar2,
92 p_value12 in out NoCopy varchar2,
93 p_value13 in out NoCopy varchar2,
94 p_value14 in out NoCopy varchar2,
95 p_value15 in out NoCopy varchar2,
96 p_value16 in out NoCopy varchar2,
97 p_value17 in out NoCopy varchar2,
98 p_value18 in out NoCopy varchar2,
99 p_value19 in out NoCopy varchar2,
100 p_value20 in out NoCopy varchar2,
101 p_value21 in out NoCopy varchar2,
102 p_value22 in out NoCopy varchar2,
103 p_value23 in out NoCopy varchar2,
104 p_value24 in out NoCopy varchar2,
105 p_value25 in out NoCopy varchar2,
106 p_value26 in out NoCopy varchar2,
107 p_value27 in out NoCopy varchar2,
108 p_value28 in out NoCopy varchar2,
109 p_value29 in out NoCopy varchar2,
110 p_value30 in out NoCopy varchar2,
111 p_edi_rec1 out NoCopy varchar2,
112 p_edi_rec2 out NoCopy varchar2,
113 p_edi_rec3 out NoCopy varchar2,
114 p_edi_rec4 out NoCopy varchar2,
115 p_edi_rec5 out NoCopy varchar2,
116 p_edi_rec6 out NoCopy varchar2,
117 p_edi_rec7 out NoCopy varchar2,
118 p_edi_rec8 out NoCopy varchar2,
119 p_edi_rec9 out NoCopy varchar2,
120 p_edi_rec10 out NoCopy varchar2,
121 p_edi_rec11 out NoCopy varchar2,
122 p_edi_rec12 out NoCopy varchar2,
123 p_edi_rec13 out NoCopy varchar2,
124 p_edi_rec14 out NoCopy varchar2,
125 p_edi_rec15 out NoCopy varchar2,
126 p_edi_rec16 out NoCopy varchar2,
127 p_edi_rec17 out NoCopy varchar2,
128 p_edi_rec18 out NoCopy varchar2,
129 p_edi_rec19 out NoCopy varchar2,
130 p_edi_rec20 out NoCopy varchar2,
131 p_edi_rec21 out NoCopy varchar2,
132 p_edi_rec22 out NoCopy varchar2,
133 p_edi_rec23 out NoCopy varchar2,
134 p_edi_rec24 out NoCopy varchar2,
135 p_edi_rec25 out NoCopy varchar2,
136 p_edi_rec26 out NoCopy varchar2,
137 p_edi_rec27 out NoCopy varchar2,
138 p_edi_rec28 out NoCopy varchar2,
139 p_edi_rec29 out NoCopy varchar2,
140 p_edi_rec30 out NoCopy varchar2) return number;
141
142 function get_summary(p_benefit_type in varchar2,
143 p_tax_year in varchar2,
144 p_value1 in varchar2,
145 p_value2 in varchar2,
146 p_value3 in varchar2,
147 p_value4 in varchar2,
148 p_value5 in varchar2,
149 p_value6 in varchar2,
150 p_value7 in varchar2,
151 p_value8 in varchar2,
152 p_value9 in varchar2,
153 p_value10 in varchar2,
154 p_value11 in varchar2,
155 p_value12 in varchar2,
156 p_value13 in varchar2,
157 p_value14 in varchar2,
158 p_value15 in varchar2,
159 p_value16 in varchar2,
160 p_value17 in varchar2,
161 p_value18 in varchar2,
162 p_value19 in varchar2,
163 p_value20 in varchar2,
164 p_value21 in varchar2,
165 p_value22 in varchar2,
166 p_value23 in varchar2,
167 p_value24 in varchar2,
168 p_value25 in varchar2,
169 p_value26 in varchar2,
170 p_value27 in varchar2,
171 p_value28 in varchar2,
172 p_value29 in varchar2,
173 p_value30 in varchar2,
174 p_edi_rec1 out NoCopy varchar2,
175 p_edi_rec2 out NoCopy varchar2,
176 p_edi_rec3 out NoCopy varchar2,
177 p_edi_rec4 out NoCopy varchar2,
178 p_edi_rec5 out NoCopy varchar2,
179 p_edi_rec6 out NoCopy varchar2,
180 p_edi_rec7 out NoCopy varchar2,
181 p_edi_rec8 out NoCopy varchar2,
182 p_edi_rec9 out NoCopy varchar2,
183 p_edi_rec10 out NoCopy varchar2,
184 p_edi_rec11 out NoCopy varchar2,
185 p_edi_rec12 out NoCopy varchar2,
186 p_edi_rec13 out NoCopy varchar2,
187 p_edi_rec14 out NoCopy varchar2,
188 p_edi_rec15 out NoCopy varchar2,
189 p_edi_rec16 out NoCopy varchar2,
190 p_edi_rec17 out NoCopy varchar2,
191 p_edi_rec18 out NoCopy varchar2,
192 p_edi_rec19 out NoCopy varchar2,
193 p_edi_rec20 out NoCopy varchar2,
194 p_edi_rec21 out NoCopy varchar2,
195 p_edi_rec22 out NoCopy varchar2,
196 p_edi_rec23 out NoCopy varchar2,
197 p_edi_rec24 out NoCopy varchar2,
198 p_edi_rec25 out NoCopy varchar2,
199 p_edi_rec26 out NoCopy varchar2,
200 p_edi_rec27 out NoCopy varchar2,
201 p_edi_rec28 out NoCopy varchar2,
202 p_edi_rec29 out NoCopy varchar2,
203 p_edi_rec30 out NoCopy varchar2) return number;
204
205 function get_footer(p_record_count in varchar2,
206 p_error_count in varchar2,
207 p_missing_val in varchar2,
208 p_error_msg1 out NoCopy varchar2,
209 p_error_msg2 out NoCopy varchar2,
210 p_edi_rec1 out NoCopy varchar2,
211 p_edi_rec2 out NoCopy varchar2,
212 p_edi_rec3 out NoCopy varchar2) return number;
213
214 function count_occurrence(p_benefit_type in varchar2,
215 p_person_id in varchar2,
216 p_employer_ref in varchar2,
217 p_pact_id in varchar2) return number;
218
219 function check_occurrence(p_benefit_type in varchar2) return varchar2;
220
221 function get_benefit_name(p_benefit_type in varchar2) return varchar2;
222
223 function fetch_total_benefit(p_assact_id in number,
224 p_employer_ref in varchar2) return number;
225 END PAY_GB_P11D_EDI_2008;