1 PACKAGE AP_APXT7CMT_XMLP_PKG AS
2 /* $Header: APXT7CMTS.pls 120.0 2007/12/27 08:34:57 vjaganat noship $ */
3 P_DEBUG_SWITCH VARCHAR2(1);
4
5 P_CONC_REQUEST_ID NUMBER := 0;
6
7 P_MIN_PRECISION NUMBER;
8
9 P_FLEXDATA VARCHAR2(600);
10
11 P_SET_OF_BOOKS_ID NUMBER;
12
13 P_TRACE_SWITCH VARCHAR2(1);
14
15 P_START_YEAR_DATE DATE;
16
17 P_END_YEAR_DATE DATE;
18
19 P_TAX_ENTITY_ID NUMBER;
20
21 P_ADDRESS_CHOICE VARCHAR2(30);
22
23 P_NAME_CONTROL VARCHAR2(4);
24
25 P_LAST_FILING_YN VARCHAR2(1);
26
27 P_TEST_YN VARCHAR2(1);
28
29 P_OUTPUT_TYPE VARCHAR2(32767);
30
31 P_TCC VARCHAR2(5);
32
33 P_FOREIGN_PAYER_YN VARCHAR2(1);
34
35 P_QUERY_DRIVER VARCHAR2(3);
36
37 P_FILE_INDICATOR VARCHAR2(1);
38
39 P_REPLACEMENT_ALPHA_CHARACTER VARCHAR2(2);
40
41 P_TELEPHONE_NUMBER NUMBER;
42
43 P_CONTACT_NAME VARCHAR2(40);
44
45 P_ELECTRONIC_FILE_NAME VARCHAR2(15);
46
47 P_FEDERAL_REPORTING_LIMIT NUMBER;
48
49 P_ORIGINAL_FILE VARCHAR2(3);
50
51 P_CONTACT_EMAIL VARCHAR2(35);
52
53 C_RECORD_SEQUENCE NUMBER;
54
55 C_NLS_YES VARCHAR2(80);
56
57 C_NLS_NO VARCHAR2(80);
58
59 C_NLS_ALL VARCHAR2(80);
60
61 C_NLS_NO_DATA_EXISTS VARCHAR2(240);
62
63 C_NLS_VOID VARCHAR2(80);
64
65 C_NLS_NA VARCHAR2(80);
66
67 C_NLS_END_OF_REPORT VARCHAR2(100);
68
69 C_REPORT_START_DATE DATE;
70
71 C_BASE_CURRENCY_CODE VARCHAR2(15);
72
73 C_BASE_PRECISION NUMBER;
74
75 C_BASE_MIN_ACCT_UNIT NUMBER;
76
77 C_BASE_DESCRIPTION VARCHAR2(240);
78
79 C_CHART_OF_ACCOUNTS_ID NUMBER;
80
81 APPLICATIONS_TEMPLATE_REPORT VARCHAR2(1);
82
83 C_COMBINED_FLAG VARCHAR2(1);
84
85 C_FIRST_NAME VARCHAR2(240);
86
87 C_ADDRESS VARCHAR2(1000);
88
89 C_DATA_EXISTS VARCHAR2(1) := 'N';
90
91 C_TRANSMITTER_NAME VARCHAR2(80);
92
93 C_TRANSMITTER_ADDRESS VARCHAR2(40);
94
95 C_TRANSMITTER_CSZ VARCHAR2(40);
96
97 C_SECOND_NAME VARCHAR2(40);
98
99 C_TRANSFER_FLAG VARCHAR2(1);
100
101 C_EIN VARCHAR2(9);
102
103 C_PAYMENT_YEAR VARCHAR2(4);
104
105 C_TIN VARCHAR2(20);
106
107 C_AMOUNT_INDICATOR VARCHAR2(13);
108
109 C_ERROR_VENDOR VARCHAR2(240);
110
111 C_ERROR_REASON VARCHAR2(67);
112
113 C_SPACE VARCHAR2(1);
114
115 C_DOUBLE_SPACE VARCHAR2(2);
116
117 C_NUMBER_OF_B_RECS NUMBER;
118
119 C_PRIOR_YEAR_DATA VARCHAR2(1);
120
121 C_CITY VARCHAR2(40);
122
123 C_STATE VARCHAR2(150);
124
125 C_ZIP VARCHAR2(9);
126
127 C_INDICATOR_STATUS VARCHAR2(1);
128
129 FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
130
131 FUNCTION CUSTOM_INIT RETURN BOOLEAN;
132
133 FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
134
135 FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
136
137 FUNCTION BEFOREREPORT RETURN BOOLEAN;
138
139 FUNCTION AFTERREPORT RETURN BOOLEAN;
140
141 FUNCTION GET_COMBINED_FLAG RETURN BOOLEAN;
142
143 FUNCTION GET_TIN RETURN BOOLEAN;
144
145 FUNCTION DELETE_AP_1099_TAPE_DATA RETURN BOOLEAN;
146
147 FUNCTION INSERT_AP_1099_TAPE_DATA RETURN BOOLEAN;
148
149 FUNCTION PERFORM_STATE_TESTS RETURN BOOLEAN;
150
151 FUNCTION C_ERROR_DUMMYFORMULA(ERROR_TEXT IN VARCHAR2
152 ,VENDOR_NAME IN VARCHAR2) RETURN VARCHAR2;
153
154 FUNCTION CLEAR_REGION_TOTALS RETURN BOOLEAN;
155
156 FUNCTION UPDATE_STATE_TOTALS RETURN BOOLEAN;
157
158 FUNCTION GET_TRANSMITTER_INFO RETURN BOOLEAN;
159
160 FUNCTION GET_FIRST_NAME RETURN BOOLEAN;
161
162 FUNCTION GET_ADDRESS RETURN BOOLEAN;
163
164 FUNCTION TYPE_SEL RETURN BOOLEAN;
165
166 FUNCTION C_LAST_FILING_FLAGFORMULA RETURN VARCHAR2;
167
168 FUNCTION C_TEST_INDICATORFORMULA RETURN VARCHAR2;
169
170 FUNCTION C_MTFIFORMULA RETURN VARCHAR2;
171
172 FUNCTION C_FOREIGN_PAYER_FLAGFORMULA RETURN VARCHAR2;
173
174 FUNCTION C_A_RECORDFORMULA(C_LAST_FILING_FLAG IN VARCHAR2
175 ,C_FOREIGN_PAYER_FLAG IN VARCHAR2) RETURN VARCHAR2;
176
177 FUNCTION C_B_RECORDFORMULA(PAYEE_NAME_CONTROL IN VARCHAR2
178 ,TIN_TYPE IN VARCHAR2
179 ,EIN IN VARCHAR2
180 ,VENDOR_ID IN NUMBER
181 ,MISC1 IN NUMBER
182 ,MISC2 IN NUMBER
183 ,MISC3 IN NUMBER
184 ,MISC4 IN NUMBER
185 ,MISC5 IN NUMBER
186 ,MISC6 IN NUMBER
187 ,MISC7 IN NUMBER
188 ,MISC8 IN NUMBER
189 ,MISC10 IN NUMBER
190 ,MISC13 IN NUMBER
191 ,MISC14 IN NUMBER
192 ,MISC15A IN NUMBER
193 ,MISC15B IN NUMBER
194 ,FOREIGN_PAYEE_FLAG IN VARCHAR2
195 ,TAX_REPORTING_NAME IN VARCHAR2
196 ,VENDOR_NAME IN VARCHAR2
197 ,VENDOR_LINE IN VARCHAR2
198 ,VENDOR_CITY IN VARCHAR2
199 ,VENDOR_STATE IN VARCHAR2
200 ,VENDOR_ZIP IN VARCHAR2
201 ,REGION_CODE IN VARCHAR2
202 ,MISC9 IN NUMBER) RETURN VARCHAR2;
203
204 FUNCTION C_C_RECORDFORMULA(C_NUM_OF_PAYEES IN NUMBER
205 ,C_TOTAL1 IN NUMBER
206 ,C_TOTAL2 IN NUMBER
207 ,C_TOTAL3 IN NUMBER
208 ,C_TOTAL4 IN NUMBER
209 ,C_TOTAL5 IN NUMBER
210 ,C_TOTAL6 IN NUMBER
211 ,C_TOTAL7 IN NUMBER
212 ,C_TOTAL8 IN NUMBER
213 ,C_TOTAL10 IN NUMBER
214 ,C_TOTAL13 IN NUMBER
215 ,C_TOTAL14 IN NUMBER
216 ,C_TOTAL15A IN NUMBER
217 ,C_TOTAL15B IN NUMBER) RETURN VARCHAR2;
218
219 FUNCTION C_F_RECORDFORMULA(C_NUM_OF_PAYEES IN NUMBER
220 ,C_NUM_OF_K_RECORDS IN NUMBER) RETURN VARCHAR2;
221
222 FUNCTION C_T_RECORDFORMULA(C_TEST_INDICATOR IN VARCHAR2
223 ,C_FOREIGN_PAYER_FLAG IN VARCHAR2
224 ,C_NUM_OF_PAYEES IN NUMBER
225 ,C_MTFI IN VARCHAR2) RETURN VARCHAR2;
226
227 FUNCTION C_K_RECORDFORMULA(NUM_OF_PAYEES IN NUMBER
228 ,CONTROL_TOTAL1 IN NUMBER
229 ,CONTROL_TOTAL2 IN NUMBER
230 ,CONTROL_TOTAL3 IN NUMBER
231 ,CONTROL_TOTAL5 IN NUMBER
232 ,CONTROL_TOTAL6 IN NUMBER
233 ,CONTROL_TOTAL7 IN NUMBER
234 ,CONTROL_TOTAL8 IN NUMBER
235 ,CONTROL_TOTAL10 IN NUMBER
236 ,CONTROL_TOTAL13 IN NUMBER
237 ,CONTROL_TOTAL14 IN NUMBER
238 ,CONTROL_TOTAL15A IN NUMBER
239 ,CONTROL_TOTAL15B IN NUMBER
240 ,K_REGION_CODE IN VARCHAR2) RETURN VARCHAR2;
241
242 FUNCTION CF_NEGATIVE_MISCFORMULA(MISC2 IN NUMBER
243 ,MISC3 IN NUMBER
244 ,MISC4 IN NUMBER
245 ,MISC5 IN NUMBER
246 ,MISC6 IN NUMBER
247 ,MISC7 IN NUMBER
248 ,MISC8 IN NUMBER
249 ,MISC9 IN NUMBER
250 ,MISC10 IN NUMBER
251 ,MISC13 IN NUMBER
252 ,MISC14 IN NUMBER
253 ,MISC15A IN NUMBER
254 ,MISC15B IN NUMBER
255 ,ERROR_TEXT IN VARCHAR2
256 ,VENDOR_NAME IN VARCHAR2) RETURN CHAR;
257
258 FUNCTION PERFORM_FEDERAL_LIMIT_UPDATES RETURN BOOLEAN;
259
260 FUNCTION C_NLS_YES_P RETURN VARCHAR2;
261
262 FUNCTION C_NLS_NO_P RETURN VARCHAR2;
263
264 FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
265
266 FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
267
268 FUNCTION C_NLS_VOID_P RETURN VARCHAR2;
269
270 FUNCTION C_NLS_NA_P RETURN VARCHAR2;
271
272 FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
273
274 FUNCTION C_REPORT_START_DATE_P RETURN DATE;
275
276 FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
277
278 FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
279
280 FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
281
282 FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
283
284 FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
285
286 FUNCTION APPLICATIONS_TEMPLATE_REPORT_P RETURN VARCHAR2;
287
288 FUNCTION C_COMBINED_FLAG_P RETURN VARCHAR2;
289
290 FUNCTION C_FIRST_NAME_P RETURN VARCHAR2;
291
292 FUNCTION C_ADDRESS_P RETURN VARCHAR2;
293
294 FUNCTION C_DATA_EXISTS_P RETURN VARCHAR2;
295
296 FUNCTION C_TRANSMITTER_NAME_P RETURN VARCHAR2;
297
298 FUNCTION C_TRANSMITTER_ADDRESS_P RETURN VARCHAR2;
299
300 FUNCTION C_TRANSMITTER_CSZ_P RETURN VARCHAR2;
301
302 FUNCTION C_SECOND_NAME_P RETURN VARCHAR2;
303
307
304 FUNCTION C_TRANSFER_FLAG_P RETURN VARCHAR2;
305
306 FUNCTION C_EIN_P RETURN VARCHAR2;
308 FUNCTION C_PAYMENT_YEAR_P RETURN VARCHAR2;
309
310 FUNCTION C_TIN_P RETURN VARCHAR2;
311
312 FUNCTION C_AMOUNT_INDICATOR_P RETURN VARCHAR2;
313
314 FUNCTION C_ERROR_VENDOR_P RETURN VARCHAR2;
315
316 FUNCTION C_ERROR_REASON_P RETURN VARCHAR2;
317
318 FUNCTION C_SPACE_P RETURN VARCHAR2;
319
320 FUNCTION C_DOUBLE_SPACE_P RETURN VARCHAR2;
321
322 FUNCTION C_NUMBER_OF_B_RECS_P RETURN NUMBER;
323
324 FUNCTION C_PRIOR_YEAR_DATA_P RETURN VARCHAR2;
325
326 FUNCTION C_CITY_P RETURN VARCHAR2;
327
328 FUNCTION C_STATE_P RETURN VARCHAR2;
329
330 FUNCTION C_ZIP_P RETURN VARCHAR2;
331
332 FUNCTION C_INDICATOR_STATUS_P RETURN VARCHAR2;
333
334 END AP_APXT7CMT_XMLP_PKG;
335