1 PACKAGE AP_APXWTGNR_XMLP_PKG AS
2 /* $Header: APXWTGNRS.pls 120.0 2007/12/27 08:52:39 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_AWT_REPORT VARCHAR2(5):='AWT2' ;
14
15 P_FISCAL_YEAR NUMBER;
16
17 P_DATE_FROM DATE;
18
19 P_DATE_TO DATE;
20
21 P_TAX_AUTHORITY_ID NUMBER;
22
23 P_TAX_AUTH_SITE_ID NUMBER;
24
25 P_CHECKRUN_NAME VARCHAR2(50);
26
27 P_TAX_NAME VARCHAR2(15);
28
29 P_SUPPLIER_ID NUMBER;
30
31 P_SUPPLIER_FROM VARCHAR2(240);
32 P_SUPPLIER_FROM_V VARCHAR2(240);
33
34 P_SUPPLIER_TO VARCHAR2(240);
35 P_SUPPLIER_TO_V VARCHAR2(240);
36
37 P_SUPP_NUM_FROM VARCHAR2(30);
38 P_SUPP_NUM_FROM_V VARCHAR2(30);
39
40 P_SUPP_NUM_TO VARCHAR2(30);
41 P_SUPP_NUM_TO_V VARCHAR2(30);
42
43 P_REPORT_CURRENCY VARCHAR2(10) := 'FUNCTIONAL';
44 P_REPORT_CURRENCY_V VARCHAR2(30) ;
45
46 P_INVOICE_CLASSES VARCHAR2(32767);
47
48 P_POSTED_STATUS VARCHAR2(25);
49
50 P_CERT_EXPIRE_FROM DATE;
51
52 P_CERT_EXPIRE_TO DATE;
53
54 P_SUPPLIER_SURNAME VARCHAR2(100);
55
56 P_SUPPLIER_FIRST_NAME VARCHAR2(100);
57
58 P_SUPPLIER_BIRTHDATE VARCHAR2(100);
59
60 P_SUPPLIER_TOB VARCHAR2(100);
61
62 P_SUPPLIER_DOB VARCHAR2(100);
63
64 P_SUPPLIER_SEX VARCHAR2(100);
65
66 P_SUPPLIER_FCC VARCHAR2(100);
67
68 P_SUPPLIER_FCR VARCHAR2(100);
69
70 P_SUPPLIER_FIFC VARCHAR2(100);
71
72 P_TAX_AUTHORITY_NAME VARCHAR2(240) := '''No Tax Authority Info ''';
73
74 P_TAX_AUTHORITY_SITE_CODE VARCHAR2(100) := '''No Tax Authority Info ''';
75
76 P_TA_ADDRESS_LINE1 VARCHAR2(240) := '''No Tax Authority Info ''';
77
78 P_TA_ADDRESS_LINE2 VARCHAR2(240) := '''No Tax Authority Info ''';
79
80 P_TA_ADDRESS_LINE3 VARCHAR2(240) := '''No Tax Authority Info ''';
81
82 P_TA_CITY VARCHAR2(100) := '''No Tax Authority Info ''';
83
84 P_TA_STATE VARCHAR2(150) := '''No Tax Authority Info ''';
85
86 P_TA_ZIP VARCHAR2(100) := '''No Tax Authority Info ''';
87
88 P_TA_PROVINCE VARCHAR2(150) := '''No Tax Authority Info ''';
89
90 P_TA_COUNTRY VARCHAR2(100) := '''No Tax Authority Info ''';
91
92 P_TAX_AUTHORITY_TABLES VARCHAR2(1000);
93
94 P_TAX_AUTHORITY_JOINS VARCHAR2(1000);
95
96 P_SELECT_TAX_AUTHORITY VARCHAR2(1000);
97
98 P_RESTRICT_TO_CHECKRUN_NAME VARCHAR2(1000);
99
100 P_RESTRICT_TO_PAID_DISTS VARCHAR2(1000);
101
102 P_SELECTED_SUPPLIERS VARCHAR2(1000);
103
104 P_SYSTEM_ACCT_METHOD VARCHAR2(240);
105
106 P_GL_POSTED_STATUS VARCHAR2(1000);
107
108 P_CERT_EXPIRATION_RANGE VARCHAR2(1000);
109
110 P_RESTRICT_CERTIFICATES VARCHAR2(1000);
111
112 P_ORDER_BY VARCHAR2(1000);
113
114 P_TRACE_SWITCH VARCHAR2(1);
115
116 P_LOG_TO_PIPE VARCHAR2(1);
117
118 P_PIPE_SIZE NUMBER;
119
120 --P_DATE_FILTER NUMBER:= ' ';
121 P_DATE_FILTER VARCHAR2(500):= ' ';
122
123 P_TAX_NAME_FILTER VARCHAR2(100);
124
125 AP_WITHHOLDING_TEMPLATE_REPORT VARCHAR2(1);
126
127 C_NLS_YES VARCHAR2(80);
128
129 C_NLS_NO VARCHAR2(80);
130
131 C_NLS_ALL VARCHAR2(80);
132
133 C_NLS_NO_DATA_EXISTS VARCHAR2(240);
134
135 C_NLS_VOID VARCHAR2(80);
136
137 C_NLS_NA VARCHAR2(80);
138
139 C_NLS_END_OF_REPORT VARCHAR2(100);
140
141 C_REPORT_START_DATE DATE;
142
143 C_COMPANY_NAME_HEADER VARCHAR2(50);
144
145 C_BASE_CURRENCY_CODE VARCHAR2(15);
146
147 C_BASE_PRECISION NUMBER;
148
149 C_BASE_MIN_ACCT_UNIT NUMBER;
150
151 C_BASE_DESCRIPTION VARCHAR2(240);
152
153 C_CHART_OF_ACCOUNTS_ID NUMBER;
154
155 SANDRO_1995 NUMBER;
156
157 FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
158
159 FUNCTION CUSTOM_INIT RETURN BOOLEAN;
160
161 FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
162
163 FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
164
165 FUNCTION BEFOREREPORT RETURN BOOLEAN;
166
167 FUNCTION AFTERREPORT RETURN BOOLEAN;
168
169 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
170
171 FUNCTION CBASECURRENCYNAME RETURN VARCHAR2;
172
173 FUNCTION CREPORTTITLE RETURN VARCHAR2;
174
175 FUNCTION ACCEPT_PARAMETER(PARAMETER_NAME IN VARCHAR2) RETURN BOOLEAN;
176
177 FUNCTION BEFOREPFORM RETURN BOOLEAN;
178
179 FUNCTION CTAADDRESS(TA_CITY IN VARCHAR2
180 ,TA_STATE IN VARCHAR2
181 ,TA_ZIP IN VARCHAR2
182 ,TA_ADDRESS_LINE1 IN VARCHAR2
183 ,TA_ADDRESS_LINE2 IN VARCHAR2
184 ,TA_ADDRESS_LINE3 IN VARCHAR2) RETURN VARCHAR2;
185
186 FUNCTION CSITEADDRESS(SITE_CITY IN VARCHAR2
187 ,SITE_STATE IN VARCHAR2
188 ,SITE_ZIP IN VARCHAR2
189 ,SITE_ADDRESS_LINE1 IN VARCHAR2
190 ,SITE_ADDRESS_LINE2 IN VARCHAR2
191 ,SITE_ADDRESS_LINE3 IN VARCHAR2) RETURN VARCHAR2;
192
193 FUNCTION CINVOICECLASS(AWT_FLAG IN VARCHAR2
194 ,INVOICE_DATE IN DATE) RETURN VARCHAR2;
195
196 FUNCTION CACTUALCURRENCYNAME(INVOICE_CURRENCY_NAME IN VARCHAR2
197 ,C_BASE_CURRENCY_NAME IN VARCHAR2) RETURN VARCHAR2;
198
199 FUNCTION CINVOICEACTUALAMOUNT(INVOICE_AMOUNT IN NUMBER
200 ,INVOICE_CURRENCY_CODE IN VARCHAR2
201 ,INVOICE_BASE_AMOUNT IN NUMBER) RETURN NUMBER;
202
203 FUNCTION CINVOICEAMOUNTEXEMPT(INVOICE_ID IN NUMBER
204 ,INVOICE_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
205
206 FUNCTION CGLDISTPOSTEDSTATUS(ACCRUAL_POSTED_FLAG IN VARCHAR2
207 ,CASH_POSTED_FLAG IN VARCHAR2) RETURN VARCHAR2;
208
209 FUNCTION CACTUALAMOUNTSUBJECT(AMOUNT_SUBJECT_TO_TAX IN NUMBER
210 ,ACTUAL_CURRENCY_CODE IN VARCHAR2
211 ,INVOICE_CURRENCY_CODE IN VARCHAR2
212 ,INVOICE_EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
213
214 FUNCTION CACTUALTAXAMOUNT(TAX_AMOUNT IN NUMBER
215 ,ACTUAL_CURRENCY_CODE IN VARCHAR2
216 ,INVOICE_CURRENCY_CODE IN VARCHAR2
217 ,TAX_BASE_AMOUNT IN NUMBER) RETURN NUMBER;
218
219 FUNCTION CPAYMENTAMOUNT(INVOICE_ID_V IN NUMBER
220 ,BREAK_AWT_PAYMENT_ID IN NUMBER
221 ,ACTUAL_CURRENCY_CODE IN VARCHAR2
222 ,INVOICE_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
223
224 FUNCTION CDISCOUNTAMOUNT(INVOICE_ID_V IN NUMBER
225 ,BREAK_AWT_PAYMENT_ID IN NUMBER
226 ,INVOICE_CURRENCY_CODE IN VARCHAR2
227 ,INVOICE_EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
228
229 FUNCTION CLASTPAYMENTDATE(INVOICE_ID IN NUMBER
230 ,BREAK_AWT_PAYMENT_ID IN NUMBER) RETURN DATE;
231
232 FUNCTION CHECKINVOICECLASSES(C_INVOICE_CLASS IN VARCHAR2) RETURN BOOLEAN;
233
234 FUNCTION P_AWT_REPORTVALIDTRIGGER RETURN BOOLEAN;
235
236 FUNCTION P_FISCAL_YEARVALIDTRIGGER RETURN BOOLEAN;
237
238 FUNCTION P_DATE_FROMVALIDTRIGGER RETURN BOOLEAN;
239
240 FUNCTION P_DATE_TOVALIDTRIGGER RETURN BOOLEAN;
241
242 FUNCTION P_TAX_AUTH_SITE_IDVALIDTRIGGER RETURN BOOLEAN;
243
244 FUNCTION P_CHECKRUN_NAMEVALIDTRIGGER RETURN BOOLEAN;
245
246 FUNCTION P_TAX_NAMEVALIDTRIGGER RETURN BOOLEAN;
247
248 FUNCTION P_SUPPLIER_IDVALIDTRIGGER RETURN BOOLEAN;
249
250 FUNCTION P_SUPPLIER_FROMVALIDTRIGGER RETURN BOOLEAN;
251
252 FUNCTION P_SUPPLIER_TOVALIDTRIGGER RETURN BOOLEAN;
253
254 FUNCTION P_SUPP_NUM_FROMVALIDTRIGGER RETURN BOOLEAN;
255
256 FUNCTION P_SUPP_NUM_TOVALIDTRIGGER RETURN BOOLEAN;
257
258 FUNCTION P_REPORT_CURRENCYVALIDTRIGGER RETURN BOOLEAN;
259
260 FUNCTION P_INVOICE_CLASSESVALIDTRIGGER RETURN BOOLEAN;
261
262 FUNCTION P_POSTED_STATUSVALIDTRIGGER RETURN BOOLEAN;
263
264 FUNCTION P_CERT_EXPIRE_FROMVALIDTRIGGER RETURN BOOLEAN;
265
266 FUNCTION P_CERT_EXPIRE_TOVALIDTRIGGER RETURN BOOLEAN;
267
268 FUNCTION AFTERPFORM RETURN BOOLEAN;
269
270 FUNCTION FORDERBY RETURN VARCHAR2;
271
272 FUNCTION FRESTRICTCERTIFICATES RETURN VARCHAR2;
273
274 FUNCTION FCERTEXPIRATIONRANGE RETURN VARCHAR2;
275
276 FUNCTION FGLPOSTEDSTATUS RETURN VARCHAR2;
277
278 FUNCTION FSELECTEDSUPPLIERS RETURN VARCHAR2;
279
280 FUNCTION FRESTRICTTOPAIDDISTS RETURN VARCHAR2;
281
282 FUNCTION FRESTRICTTOCHECKRUNNAME RETURN VARCHAR2;
283
284 FUNCTION FSELECTTAXAUTHORITY RETURN VARCHAR2;
285
286 FUNCTION FTAXAUTHORITYJOINS RETURN VARCHAR2;
287
288 FUNCTION FTAXAUTHORITYTABLES RETURN VARCHAR2;
289
290 FUNCTION CAWTSETUP RETURN VARCHAR2;
291
292 FUNCTION CINVOICEFIRSTACCTDATE(INVOICE_ID IN NUMBER) RETURN DATE;
293
294 FUNCTION CLASTPAYMENTDOC(INVOICE_ID IN NUMBER
295 ,BREAK_AWT_PAYMENT_ID IN NUMBER) RETURN NUMBER;
296
297 FUNCTION LISTCERTTYPEF(LIST_CERT_TYPE IN VARCHAR2) RETURN VARCHAR2;
298
299 FUNCTION CMINDATEF(C_MIN_DATE IN date) RETURN DATE;
300
301 FUNCTION CMAXDATEF(C_MAX_DATE IN date) RETURN DATE;
302
303 FUNCTION CFISCALYEARF(C_MIN_DATE IN date
304 ,C_MAX_DATE IN date) RETURN NUMBER;
305
306 FUNCTION CORIGINALINVTOTAL(S1_PAYMENT_AMOUNT IN NUMBER
307 ,S1_DISCOUNT_AMOUNT IN NUMBER
308 ,S0_ACTUAL_TAX_AMOUNT IN NUMBER) RETURN NUMBER;
309
310 FUNCTION AP_WITHHOLDING_TEMPLATE_REPOR RETURN VARCHAR2;
311
312 FUNCTION C_NLS_YES_P RETURN VARCHAR2;
313
314 FUNCTION C_NLS_NO_P RETURN VARCHAR2;
315
316 FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
317
318 FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
319
320 FUNCTION C_NLS_VOID_P RETURN VARCHAR2;
321
322 FUNCTION C_NLS_NA_P RETURN VARCHAR2;
323
324 FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
325
326 FUNCTION C_REPORT_START_DATE_P RETURN DATE;
327
328 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
329
330 FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
331
332 FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
333
334 FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
335
336 FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
337
338 FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
339
340 FUNCTION SANDRO_1995_P RETURN NUMBER;
341
342 PROCEDURE AP_BEGIN_LOG(P_CALLING_MODULE IN VARCHAR2
343 ,P_MAX_SIZE IN NUMBER);
344
345 FUNCTION AP_PIPE_NAME RETURN VARCHAR2;
346
347 PROCEDURE AP_PIPE_NAME_23(P_PIPE_NAME OUT NOCOPY VARCHAR2);
348
349 FUNCTION AP_LOG_RETURN_CODE RETURN NUMBER;
350
351 PROCEDURE AP_BEGIN_BLOCK(P_MESSAGE_LOCATION IN VARCHAR2);
352
353 PROCEDURE AP_END_BLOCK(P_MESSAGE_LOCATION IN VARCHAR2);
354
355 PROCEDURE AP_INDENT;
356
357 PROCEDURE AP_OUTDENT;
358
359 PROCEDURE AP_LOG(P_MESSAGE IN VARCHAR2
360 ,P_MESSAGE_LOCATION IN VARCHAR2);
361
362 PROCEDURE AP_END_LOG;
363
364 PROCEDURE AP_DO_WITHHOLDING(P_INVOICE_ID IN NUMBER
365 ,P_AWT_DATE IN DATE
366 ,P_CALLING_MODULE IN VARCHAR2
367 ,P_AMOUNT IN NUMBER
368 ,P_PAYMENT_NUM IN NUMBER
369 ,P_CHECKRUN_NAME IN VARCHAR2
370 ,P_LAST_UPDATED_BY IN NUMBER
371 ,P_LAST_UPDATE_LOGIN IN NUMBER
372 ,P_PROGRAM_APPLICATION_ID IN NUMBER
373 ,P_PROGRAM_ID IN NUMBER
374 ,P_REQUEST_ID IN NUMBER
375 ,P_AWT_SUCCESS OUT NOCOPY VARCHAR2
376 ,P_INVOICE_PAYMENT_ID IN NUMBER);
377
378 PROCEDURE AP_WITHHOLD_AUTOSELECT(P_CHECKRUN_NAME IN VARCHAR2
382 ,P_PROGRAM_ID IN NUMBER
379 ,P_LAST_UPDATED_BY IN NUMBER
380 ,P_LAST_UPDATE_LOGIN IN NUMBER
381 ,P_PROGRAM_APPLICATION_ID IN NUMBER
383 ,P_REQUEST_ID IN NUMBER);
384
385 PROCEDURE AP_WITHHOLD_CONFIRM(P_CHECKRUN_NAME IN VARCHAR2
386 ,P_LAST_UPDATED_BY IN NUMBER
387 ,P_LAST_UPDATE_LOGIN IN NUMBER
388 ,P_PROGRAM_APPLICATION_ID IN NUMBER
389 ,P_PROGRAM_ID IN NUMBER
390 ,P_REQUEST_ID IN NUMBER);
391
392 PROCEDURE AP_WITHHOLD_CANCEL(P_CHECKRUN_NAME IN VARCHAR2
393 ,P_LAST_UPDATED_BY IN NUMBER
394 ,P_LAST_UPDATE_LOGIN IN NUMBER
395 ,P_PROGRAM_APPLICATION_ID IN NUMBER
396 ,P_PROGRAM_ID IN NUMBER
397 ,P_REQUEST_ID IN NUMBER);
398
399 PROCEDURE AP_UNDO_TEMP_WITHHOLDING(P_INVOICE_ID IN NUMBER
400 ,P_VENDOR_ID IN NUMBER
401 ,P_PAYMENT_NUM IN NUMBER
402 ,P_CHECKRUN_NAME IN VARCHAR2
403 ,P_UNDO_AWT_DATE IN DATE
404 ,P_CALLING_MODULE IN VARCHAR2
405 ,P_LAST_UPDATED_BY IN NUMBER
406 ,P_LAST_UPDATE_LOGIN IN NUMBER
407 ,P_PROGRAM_APPLICATION_ID IN NUMBER
408 ,P_PROGRAM_ID IN NUMBER
409 ,P_REQUEST_ID IN NUMBER
410 ,P_AWT_SUCCESS OUT NOCOPY VARCHAR2);
411
412 PROCEDURE AP_UNDO_WITHHOLDING(P_PARENT_ID IN NUMBER
413 ,P_CALLING_MODULE IN VARCHAR2
414 ,P_AWT_DATE IN DATE
415 ,P_NEW_INVOICE_PAYMENT_ID IN NUMBER
416 ,P_LAST_UPDATED_BY IN NUMBER
417 ,P_LAST_UPDATE_LOGIN IN NUMBER
418 ,P_PROGRAM_APPLICATION_ID IN NUMBER
419 ,P_PROGRAM_ID IN NUMBER
420 ,P_REQUEST_ID IN NUMBER
421 ,P_AWT_SUCCESS OUT NOCOPY VARCHAR2
422 ,P_DIST_LINE_NO IN NUMBER
423 ,P_NEW_INVOICE_ID IN NUMBER
424 ,P_NEW_DIST_LINE_NO IN NUMBER);
425
426 FUNCTION AP_GET_DISPLAYED_FIELD(LOOKUPTYPE IN VARCHAR2
427 ,LOOKUPCODE IN VARCHAR2) RETURN VARCHAR2;
428
429 FUNCTION AP_ROUND_CURRENCY(P_AMOUNT IN NUMBER
430 ,P_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER;
431
432 FUNCTION AP_ROUND_TAX(P_AMOUNT IN NUMBER
433 ,P_CURRENCY_CODE IN VARCHAR2
434 ,P_ROUND_RULE IN VARCHAR2
435 ,P_CALLING_SEQUENCE IN VARCHAR2) RETURN NUMBER;
436
437 FUNCTION AP_ROUND_PRECISION(P_AMOUNT IN NUMBER
438 ,P_MIN_UNIT IN NUMBER
439 ,P_PRECISION IN NUMBER) RETURN NUMBER;
440
441 FUNCTION GET_CURRENT_GL_DATE(P_DATE IN DATE) RETURN VARCHAR2;
442
443 PROCEDURE GET_OPEN_GL_DATE(P_DATE IN DATE
444 ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
445 ,P_GL_DATE OUT NOCOPY DATE);
446
447 PROCEDURE GET_ONLY_OPEN_GL_DATE(P_DATE IN DATE
448 ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
449 ,P_GL_DATE OUT NOCOPY DATE);
450
451 FUNCTION GET_EXCHANGE_RATE(P_FROM_CURRENCY_CODE IN VARCHAR2
452 ,P_TO_CURRENCY_CODE IN VARCHAR2
453 ,P_EXCHANGE_RATE_TYPE IN VARCHAR2
454 ,P_EXCHANGE_DATE IN DATE
455 ,P_CALLING_SEQUENCE IN VARCHAR2) RETURN NUMBER;
456
457 PROCEDURE SET_PROFILE(P_PROFILE_OPTION IN VARCHAR2
458 ,P_PROFILE_VALUE IN VARCHAR2);
459
460 PROCEDURE AP_GET_MESSAGE(P_ERR_TXT OUT NOCOPY VARCHAR2);
461 PROCEDURE SET_P_AWT_REPORT;
462
463 END AP_APXWTGNR_XMLP_PKG;
464