[Home] [Help]
PACKAGE: APPS.ZX_TAX_TAXWARE_GEN_STUB
Source
1 PACKAGE ZX_TAX_TAXWARE_GEN_STUB AS
2 /* $Header: zxtxwgns.pls 120.0 2005/09/09 08:20:11 asengupt noship $ */
3
4 /*
5 TxAmtType NUMBER(17,5);
6 */
7 TxAmtType NUMBER;
8
9 LoRecValue NUMBER;
10 SecLoRecValue NUMBER;
11 CnRecValue NUMBER;
12 SecCnRecValue NUMBER;
13 /* following flag is used to indicate whether DB tables are to be loaded
14 into memory or NOT. Initialy value is TRUE, after loading value
15 will be FALSE. */
16 LoadTable_Flag BOOLEAN := TRUE;
17 /* Used to indicate Record type stored in temporary record variable used */
18 /* by CopyRec function.*/
19
20 /* Constants for values to be stored in above indicators */
21 SFCOUNTYVAL CONSTANT NUMBER := 1;
22 SFLOCALVAL CONSTANT NUMBER := 2;
23 STCOUNTYVAL CONSTANT NUMBER := 3;
24 STLOCALVAL CONSTANT NUMBER := 4;
25 POOCOUNTYVAL CONSTANT NUMBER := 5;
26 POOLOCALVAL CONSTANT NUMBER := 6;
27 POACOUNTYVAL CONSTANT NUMBER := 7;
28 POALOCALVAL CONSTANT NUMBER := 8;
29
30 /* Tax Program Selection Parameters - SELPARMTYP */
31 SELPARMTYP CHAR;
32 SELPRM_DEFLT_TAXES_ONLY CONSTANT CHAR := ' ';
33 SELPRM_JUR_ONLY CONSTANT CHAR := '1';
34 SELPRM_TAXES_ONLY CONSTANT CHAR := '2';
35 SELPRM_TAX_JUR CONSTANT CHAR := '3';
36 JUR_TAX_ONLY CONSTANT CHAR := 'N';
37
38 /* Tax Calculation Types - TYPECALC */
39 TYPECALC CHAR;
40 CALC_DEFLT_BY_GROSS CONSTANT CHAR := ' ';
41 CALC_BY_GROSS CONSTANT CHAR := 'G';
42 CALC_BY_E_CREDIT CONSTANT CHAR := 'E';
43 CALC_FROM_TAXES CONSTANT CHAR := 'T';
44
45
46 /* Sales/Use/Rental Indicator - TYPETAX */
47 TYPETAX CHAR;
48 IND_SALES CONSTANT CHAR := 'S';
49 IND_USE CONSTANT CHAR := 'U';
50 IND_SERV CONSTANT CHAR := 'V';
51 IND_CONUSE CONSTANT CHAR := 'C';
52 IND_RENTAL CONSTANT CHAR := 'R';
53
54 /* OptFiles (Optional Files) values - OPTFTYPE */
55 OPTFTYPE CHAR;
56 OPTF_NO_PROD CONSTANT CHAR := '1';
57 /* Don't use Product file */
58 OPTF_NO_ERR CONSTANT CHAR := '2';
59 /* Don't use error file */
60 OPTF_NO_ERR_NO_PROD CONSTANT CHAR := '3';
61 /* Don't use either file */
62
63 /* Completion Code Types - CCLEVEL */
64 CCLEVEL NUMBER;
65 TAXGENERAL CONSTANT NUMBER := 0;
66 TAXSTATE CONSTANT NUMBER := 1;
67 TAXCOUNTY CONSTANT NUMBER := 2;
68 TAXLOCAL CONSTANT NUMBER := 3;
69 TAXSECONDARY CONSTANT NUMBER := 4;
70
71 /* Levels of taxability - TAXLEVEL */
72 TAXLEVEL NUMBER;
73 FEDERAL CONSTANT NUMBER := 0;
74 STATE CONSTANT NUMBER := 1;
75 COUNTY CONSTANT NUMBER := 2;
76 SEC_COUNTY CONSTANT NUMBER := 3;
77 LOCAL CONSTANT NUMBER := 4;
78 SEC_LOCAL CONSTANT NUMBER := 5;
79
80 /* End Link Value */
81 OPENPARM CONSTANT CHAR(5) := 'OPEN ';
82 CLOSEPARM CONSTANT CHAR(5) := 'CLOSE';
83
84 /* Reason Codes */
85 REASON_APOFPO CONSTANT CHAR(2) := 'BM';
86
87 /* GENERAL COMPLETION CODE VALUE */
88
89 SUCCESSCC CONSTANT NUMBER := 0;
90 INVALIDZIP CONSTANT NUMBER := 1;
91 INVALIDST CONSTANT NUMBER := 3;
92 INVALIDGRS CONSTANT NUMBER := 4;
93 INVALIDTAXAMT CONSTANT NUMBER := 5;
94 GENINVZIPST CONSTANT NUMBER := 6;
95 TAXACCESSERR CONSTANT NUMBER := 8;
96 INVSELPARM CONSTANT NUMBER := 9;
97 /* Also returned by Jurisdiction */
98 INVCALCTYP CONSTANT NUMBER := 11;
99 PRDACCESSERR CONSTANT NUMBER := 12;
100 CONUSEFILEERR CONSTANT NUMBER := 13 ;
101 RATEISZERO CONSTANT NUMBER := 14;
102 INVALIDEXM CONSTANT NUMBER := 15;
103 INVALIDFRT CONSTANT NUMBER := 16;
104 NEGFIELDS CONSTANT NUMBER := 17;
105 INVALIDDTE CONSTANT NUMBER := 18;
106 CC_APOFPO CONSTANT NUMBER := 19;
107 AUDACCESSERR CONSTANT NUMBER := 25;
108 INVCALCERR CONSTANT NUMBER := 28;
109 CERRACCESSERR CONSTANT NUMBER := 29;
110 JERRACCESSERR CONSTANT NUMBER := 31;
111 INVJURERR CONSTANT NUMBER := 30;
112 INVJURPROC CONSTANT NUMBER := 32;
113 PRDINVALID4CU CONSTANT NUMBER := 39;
114 PRDINVALID4SERV CONSTANT NUMBER := 39;
115 CALC_E_ERROR CONSTANT NUMBER := 42;
116 EXEMPTLGRGROSS CONSTANT NUMBER := 43;
117 AMOUNTOVERFLOW CONSTANT NUMBER := 44;
118
119 /* ifdef SYSCTRL_USE_ST*/
120 NOSTEPPROC CONSTANT NUMBER := 51;
121 STEPNOCUSTERR CONSTANT NUMBER := 52;
122 STEPPARAMERR CONSTANT NUMBER := 54;
123 STEPMISCERR CONSTANT NUMBER := 55;
124 STEPSTATEERR CONSTANT NUMBER := 56;
125 /* endif */
126
127 /* ifdef _USE_PRODUCT */
128 PRODCDCONVNOTFOUND CONSTANT NUMBER := 71;
129 /* endif */
130
131 /* ifde_NEXPRO */
132 NOACCESSMERCH CONSTANT NUMBER := 82;
133 NOMERCHANTREC CONSTANT NUMBER := 83;
134 NOACCESSSTNEX CONSTANT NUMBER := 84;
135 NOACCESSLONEX CONSTANT NUMBER := 85;
136 NOMERCHANTID CONSTANT NUMBER := 86;
137 NOSTATENEXREC CONSTANT NUMBER := 93;
138 /* endif */
139
140 JURISERROR CONSTANT NUMBER := 95;
141
142 /* TAXCALC LOCATION COMPCODES */
143 TAXMAXTAX_NOT_FOUND CONSTANT NUMBER := 42;
144 NOTAXINDUSED CONSTANT NUMBER := 33;
145 INVZIPST CONSTANT NUMBER := 06;
146 INVCOUNTY CONSTANT NUMBER := 19;
147 CITYDEFAULT CONSTANT NUMBER := 20;
148 OVRRDECNTY CONSTANT NUMBER := 20;
149 INVTAXIND CONSTANT NUMBER := 21;
150 NOLOTAXFORZP CONSTANT NUMBER := 22;
151 NOCNTAXFORZP CONSTANT NUMBER := 23;
152 REAS_TAX_ADJ CONSTANT NUMBER := 28;
153 REAS_NITEM_INCOMPAT CONSTANT NUMBER := 29;
154 OVRRDERATE CONSTANT NUMBER := 30;
155 OVRRDEAMT CONSTANT NUMBER := 31;
156 STEPUSERATE CONSTANT NUMBER := 32;
157 NOTAXINDUSE CONSTANT NUMBER := 33;
158 PRODEXEMPT4CU CONSTANT NUMBER := 39;
159 PRODRATE CONSTANT NUMBER := 35;
160 PRD_MAX_TAX_ADJ CONSTANT NUMBER := 36;
161 PRD_NITEM_INCOMPAT_MAX CONSTANT NUMBER := 37;
162 MAX_TAX_ADJ CONSTANT NUMBER := 40;
163 NITEM_INCOMPAT_MAX CONSTANT NUMBER := 41;
164 PRDPOLICERATEHALF CONSTANT NUMBER := 43;
165 PRDPOLICERATETHIRD CONSTANT NUMBER := 43;
166 PRDPOLICERATEQUARTER CONSTANT NUMBER := 43;
167 DEFAULT_CURRDATE CONSTANT NUMBER := 45;
168 NO_USE_TAX CONSTANT NUMBER := 49;
169 NO_TAXES CONSTANT NUMBER := 50;
170 STATE_TAX_ONLY CONSTANT NUMBER := 51;
171 STATE_FED_SALES_ONLY CONSTANT NUMBER := 52;
172 STATE_FED_USE_ONLY CONSTANT NUMBER := 53;
173 CNLO_NO_TAXES CONSTANT NUMBER := 54;
174 CNLO_SALES_ONLY CONSTANT NUMBER := 55;
175 CNLO_USE_ONLY CONSTANT NUMBER := 56;
176 CNLO_TRANSIT_ONLY CONSTANT NUMBER := 57;
177 CNLO_NO_TRANSIT CONSTANT NUMBER := 58;
178 LO_NO_TAXES CONSTANT NUMBER := 59;
179 LO_STATE_ONLY CONSTANT NUMBER := 60;
180 CNLO_ADMIN_A CONSTANT NUMBER := 61;
181
182 E_ESTIMATE CONSTANT NUMBER := 72;
183 E_NO_EXEMPT_AMT CONSTANT NUMBER := 73;
184
185 /* if defined _NEXPRO */
186 /* NEXUSNOLOTAX CONSTANT NUMBER := 61;
187 to be deleted ??? */
188 NEXUSNOTAX CONSTANT NUMBER := 64;
189 /* endif */
190
191 PRDNOTOK4CU CONSTANT NUMBER := 38;
192 PRDNOTOK4SERV CONSTANT NUMBER := 38;
193
194 /* Extra Comnpletion Code */
195 CONUSETRANS CONSTANT NUMBER := 1;
196
197 /* Jurisdiction Return C*/
198
199 JURSUCCESS CONSTANT NUMBER := 0;
200 JURINVPOT CONSTANT NUMBER := 1;
201 JURINVSRVIN CONSTANT NUMBER := 2;
202 JURINVLINK CONSTANT NUMBER := 3;
203 JURERROR CONSTANT NUMBER := 99;
204
205 /* Jurisdiction Location Return Codes */
206
207 LOCCNTYDEF CONSTANT NUMBER := 1;
208 LOCINVSTATE CONSTANT NUMBER := 2;
209 LOCNOZIP CONSTANT NUMBER := 3;
210 LOCINVZIP CONSTANT NUMBER := 4;
211 LOCNOCITY CONSTANT NUMBER := 5;
212 LOCNOGEO CONSTANT NUMBER := 5;
213 LOCINVCNTY CONSTANT NUMBER := 6;
214 LOCINVCITY CONSTANT NUMBER := 7;
215 LOCCNTYDEFINVCITY CONSTANT NUMBER := 8;
216
217 /*if defined _NEXPRO*/
218 NOSTORZIPCALLNEX CONSTANT NUMBER := 9;
219 /*endif*/
220
221 MAXGROSSAMOUNT CONSTANT NUMBER := 99999999999.99;
222 MAXTAXAMOUNT CONSTANT NUMBER := 99999999.99;
223
224 /*if defined SYSCTRL_MSDOS*/
225 ALIGNSIZE CONSTANT NUMBER:= 1;
226 /*endif*/
227
228 /* Tax Type Constants - TaxType*/
229 TaxType CHAR;
230 SALESTAX CONSTANT CHAR :='S';
231 USETAX CONSTANT CHAR :='U';
232 RENTTAX CONSTANT CHAR :='R';
233 CONUSETAX CONSTANT CHAR :='C';
234 SERVTAX CONSTANT CHAR :='V';
235 NOTAX CONSTANT CHAR :='N';
236 DEFLT_NOTAX CONSTANT CHAR := ' ';
237
238 /* Jurisdiction POT constants - JurPOTType */
239 JurPOTType CHAR;
240 POT_DEST CONSTANT CHAR :='D';
241 POT_ORIG CONSTANT CHAR :='O';
242
243
244 /* Jurisdiction Location Type constants - JurLocType */
245 JurLocType CHAR;
246 JUR_IS_ST CONSTANT CHAR :='T';
247 JUR_IS_SF CONSTANT CHAR :='F';
248 JUR_IS_POA CONSTANT CHAR :='A';
249 JUR_IS_POO CONSTANT CHAR :='O';
250 JUR_IS_BT CONSTANT CHAR :='B';
251
252 TYPE TaxFlagsType is RECORD
253 (
254 Have_County BOOLEAN,
255 Have_Local BOOLEAN,
256 Have_Secondary_County BOOLEAN,
257 Have_Secondary_Local BOOLEAN,
258 Used_Override BOOLEAN,
259 Product_Exception BOOLEAN,
260 Alabama_Rental BOOLEAN,
261 CdaTaxOnTax BOOLEAN,
262 LoRnt_UseSales BOOLEAN,
263 CnRnt_UseSales BOOLEAN,
264 Exempt BOOLEAN,
265 APOFPO BOOLEAN,
266 MTATax BOOLEAN,
267 Product_Max BOOLEAN,
268 UsedProdLoTxRt BOOLEAN,
269
270 /* Override flags are set when the override amounts or rates are passed */
271 FedOverride BOOLEAN,
272 StOverride BOOLEAN,
273 CntyOverride BOOLEAN,
274 CityOverride BOOLEAN,
275 DistOverride BOOLEAN,
276 SecStOverride BOOLEAN,
277 SecCntyOverride BOOLEAN,
278 SecCityOverride BOOLEAN,
279 AllOverride BOOLEAN,
280
281 /* Special flags are set when either override flags are set */
282 /* or no tax indicators are passed */
283 FedSpecFlg BOOLEAN,
284 StSpecFlg BOOLEAN,
285 CntySpecFlg BOOLEAN,
286 CitySpecFlg BOOLEAN,
287 DistSpecFlg BOOLEAN,
288 SecStSpecFlg BOOLEAN,
289 SecCntySpecFlg BOOLEAN,
290 SecCitySpecFlg BOOLEAN,
291 AllSpecFlg BOOLEAN,
292 AllTaxCert BOOLEAN,
293 BasisPerc BOOLEAN,
294 HSTProv BOOLEAN
295 );
296
297 TYPE HaveTyp is RECORD
298 (
299 ShipTo BOOLEAN,
300 ShipFrom BOOLEAN,
301 POA BOOLEAN,
305 TYPE JurFlagsType is RECORD
302 POO BOOLEAN
303 );
304
306 (
307 HaveLocl HaveTyp,
308 HaveCnty HaveTyp
309 );
310
311 TYPE t_OraParm IS RECORD
312 (
313 OracleID NUMBER(15),
314 Oracle_Msg_Text VARCHAR2(512),
315 Oracle_Msg_Label VARCHAR2(12),
316 Taxware_Msg_Text VARCHAR2(256),
317 Reserved_Text_1 VARCHAR2(25),
318 Reserved_Text_2 VARCHAR2(25),
319 Reserved_Text_3 VARCHAR2(25),
320 Reserved_BOOL_1 BOOLEAN,
321 Reserved_BOOL_2 BOOLEAN,
322 Reserved_BOOL_3 BOOLEAN,
323 Reserved_CHAR_1 CHAR(2),
324 Reserved_CHAR_2 CHAR(2),
325 Reserved_CHAR_3 CHAR(2),
326 Reserved_NUM_1 NUMBER(15),
327 Reserved_NUM_2 NUMBER(15),
328 Reserved_BIGNUM_1 NUMBER,
329 Reserved_DATE_1 DATE
330 );
331
332
333 TYPE TaxParm is RECORD
334 (
335 Countrycode char(3),
336 StateCode char(2) ,
337 PriZip CHAR(5),
338 PriGeo CHAR(2),
339 PriZipExt VARCHAR2(4),
340 SecZip CHAR(5),
341 SecGeo CHAR(2),
342 SecZipExt VARCHAR2(4),
343 CntyCode CHAR(3),
344 CntyName VARCHAR2(26),
345 LoclName VARCHAR2(26),
346 SecCntyCode CHAR(3),
347 SecCntyName VARCHAR2(26),
348 SecCityName VARCHAR2(26),
349 ShortLoNameInd BOOLEAN,
350 JurLocTp CHAR(1),
351 GrossAmt NUMBER,
352 TaxAmt NUMBER,
353 FedExemptAmt NUMBER,
354 StExemptAmt NUMBER,
355 CntyExemptAmt NUMBER,
356 CityExemptAmt NUMBER,
357 DistExemptAmt NUMBER,
358 SecStExemptAmt NUMBER,
359 SecCnExemptAmt NUMBER,
360 SecLoExemptAmt NUMBER,
361 ContractAmt NUMBER,
362 InstallAmt NUMBER,
363 FrghtAmt NUMBER,
364 DiscountAmt NUMBER,
365 CalcType CHAR(1),
366 CreditInd BOOLEAN,
367 NumItems NUMBER(7),
368 ProdCode VARCHAR2(25),
369 RoundInd BOOLEAN,
370 GenInd BOOLEAN,
371 /* This field may get deleted */
372 BasisPerc NUMBER(6,5),
373 InvoiceSumInd BOOLEAN,
374 MovementCode CHAR(1),
375 StorageCode CHAR(1),
376 ProdCodeConv CHAR(1),
377 ProdCodeType CHAR(1),
378 FedSlsUse CHAR(1),
379 StaSlsUse CHAR(1),
380 CnSlsUse CHAR(1),
381 LoSlsUse CHAR(1),
382 SecStSlsUse CHAR(1),
383 SecCnSlsUse CHAR(1),
384 SecLoSlsUse CHAR(1),
385 DistSlsUse CHAR(1),
386 NoTaxInd BOOLEAN, /* Changed from char to boolean by vv */
387 NoFedTax BOOLEAN,
388 NoStaTax BOOLEAN,
389 NoCnTax BOOLEAN,
390 NoLoTax BOOLEAN,
391 NoSecCnTax BOOLEAN,
392 NoSecLoTax BOOLEAN,
393 NoSecStTax BOOLEAN,
394 NoDistTax BOOLEAN,
395
396 Exempt BOOLEAN,
397 FedExempt BOOLEAN,
398 StaExempt BOOLEAN,
399 CnExempt BOOLEAN,
400 LoExempt BOOLEAN,
401 SecStExempt BOOLEAN,
402 SecCnExempt BOOLEAN,
403 SecLoExempt BOOLEAN,
404 DistExempt BOOLEAN,
405 FedOvAmt NUMBER(14,2),
406 FedOvPer NUMBER(5,5),
407 StOvAmt NUMBER(14,2),
408 StOvPer NUMBER(5,5),
409 CnOvAmt NUMBER(14,2),
410 CnOvPer NUMBER(5,5),
411 LoOvAmt NUMBER(14,2),
412 LoOvPer NUMBER(5,5),
413 ScCnOvAmt NUMBER(14,2),
414 ScCnOvPer NUMBER(5,5),
415 ScLoOvAmt NUMBER(14,2),
416 ScLoOvPer NUMBER(5,5),
417 ScStOvAmt NUMBER(14,2),
418 ScStOvPer NUMBER(5,5),
419 DistOvAmt NUMBER(14,2),
420 DistOvPer NUMBER(5,5),
421 InvoiceDate DATE,
422 DropShipInd BOOLEAN,
423 EndInvoiceInd BOOLEAN,
424 CustNo VARCHAR2(20),
425 CustName VARCHAR2(20),
426 AFEWorkOrd VARCHAR2(26),
427 InvoiceNo VARCHAR2(20),
428 InvoiceLineNo NUMBER(5),
429 PartNumber VARCHAR2(20),
430 FiscalDate DATE,
431 DeliveryDate DATE,
432 InOutCityLimits CHAR(1),
433 FedReasonCode CHAR(2),
434 StReasonCode CHAR(2),
438 StTaxCertNo VARCHAR2(25),
435 CntyReasonCode CHAR(2),
436 CityReasonCode CHAR(2),
437 FedTaxCertNo VARCHAR2(25),
439 CnTaxCertNo VARCHAR2(25),
440 LoTaxCertNo VARCHAR2(25),
441 FromState CHAR(2),
442 CompanyID VARCHAR2(20),
443 DivCode VARCHAR2(20),
444 MiscInfo VARCHAR2(50),
445 LocnCode VARCHAR2(13),
446 CostCenter VARCHAR2(10),
447 CurrencyCd1 CHAR(3),
448 CurrencyCd2 CHAR(3),
449 CurrConvFact VARCHAR2(15),
450 UseNexproInd CHAR(1),
451 ExtraInd1 BOOLEAN,
452 ExtraInd2 BOOLEAN,
453 ExtraInd3 BOOLEAN,
454 AudFileType CHAR(1),
455 ReptInd BOOLEAN,
456 OptFiles CHAR(1),
457 GenCmplCd CHAR(2),
458 FedCmplCd CHAR(2),
459 StaCmplCd CHAR(2),
460 CnCmplCd CHAR(2),
461 LoCmplCd CHAR(2),
462 ScStCmplCd CHAR(2),
463 ScCnCmplCd CHAR(2),
464 ScLoCmplCd CHAR(2),
465 DistCmplCd CHAR(2),
466 ExtraCmplCd1 CHAR(2),
467 ExtraCmplCd2 CHAR(2),
468 ExtraCmplCd3 CHAR(2),
469 ExtraCmplCd4 CHAR(2),
470 FedTxAmt NUMBER,
471 StaTxAmt NUMBER,
472 CnTxAmt NUMBER,
473 LoTxAmt NUMBER,
474 ScCnTxAmt NUMBER,
475 ScLoTxAmt NUMBER,
476 ScStTxAmt NUMBER,
477 DistTxAmt NUMBER,
478 FedTxRate NUMBER(5,5),
479 StaTxRate NUMBER(5,5),
480 CnTxRate NUMBER(5,5),
481 LoTxRate NUMBER(5,5),
482 ScCnTxRate NUMBER(5,5),
483 ScLoTxRate NUMBER(5,5),
484 ScStTxRate NUMBER(5,5),
485 DistTxRate NUMBER(5,5),
486 FedBasisAmt NUMBER,
487 StBasisAmt NUMBER,
488 CntyBasisAmt NUMBER,
489 CityBasisAmt NUMBER,
490 ScStBasisAmt NUMBER,
491 ScCntyBasisAmt NUMBER,
492 ScCityBasisAmt NUMBER,
493 DistBasisAmt NUMBER,
494 JobNo VARCHAR2(10),
495 CritFlg CHAR(1),
496 UseStep CHAR(1),
497 StepProcFlg CHAR(1),
498 FedStatus CHAR(1),
499 StaStatus CHAR(1),
500 CnStatus CHAR(1),
501 LoStatus CHAR(1),
502 FedComment CHAR(1),
503 StComment CHAR(1),
504 CnComment CHAR(1),
505 LoComment CHAR(1),
506 /* Added fields for R3.0 link structure */
507 Volume VARCHAR2(15),
508 VolExp CHAR(3),
509 UOM VARCHAR2(15),
510 BillToCustName VARCHAR2(20),
511 BillToCustId VARCHAR2(20)
512 );
513
514
515
516
517 TYPE StepParm is RECORD
518 (
519 /* the following fields are input only */
520 FuncCode char,
521
522 CompanyID varchar2(20),
523 CustNo varchar2(20),
524 ProcFlag char,
525 StCode char(2),
526 CntyName varchar2(26),
527 CntyCode char(3),
528 LoclName varchar2(26) ,
529 ProdCode varchar2(25) ,
530 JobNo varchar2(10) ,
531
532 /* Possible other values used for STEPTEC key search */
533 LocnCode varchar2(13),
534 CostCenter varchar2(10),
535 AFEWorkOrd varchar2(26),
536 InvoiceDate DATE ,
537
538 /* For new functionality */
539 TaxType char,
540 CritFlg char,
541 LocAdmCity char,
542 LocAdmCnty char,
543 Tax010Flg char ,
544 SearchBy char ,
545 CreditInd BOOLEAN,
546
547 /* the following fields can be input or output */
548 FedReasCode char(2),
549 StReasCode char(2),
550 CntyReasCode char(2),
551 LoclReasCode char(2),
552
553 FedCertNo varchar2( 25),
554 StCertNo varchar2( 25),
555 CntyCertNo varchar2( 25),
556 LoclCertNo varchar2( 25),
557
558 BasisPerc NUMBER(6,5),
559
560 /* the following fields are output only */
561 ReasFedMaxAmt number(14,2),
562 ReasStMaxAmt number(14,2),
563 ReasSecStMaxAmt number(14,2),
564 ReasCntyMaxAmt number(14,2),
565 ReasCityMaxAmt number(14,2),
566 ReasSecCntyMaxAmt number(14,2),
567 ReasSecCityMaxAmt number(14,2),
568 ReasDistMaxAmt number(14,2),
569
570 ReasFedMaxRate number(5,5),
571 ReasStMaxRate number(5,5),
572 ReasSecStMaxRate number(5,5),
573 ReasCntyMaxRate number(5,5),
574 ReasCityMaxRate number(5,5),
578
575 ReasSecCntyMaxRate number(5,5),
576 ReasSecCityMaxRate number(5,5),
577 ReasDistMaxRate number(5,5),
579
580 ReasFedMaxCode char(2),
581 ReasStMaxCode char(2),
582 ReasSecStMaxCode char(2),
583 ReasCntyMaxCode char(2),
584 ReasCityMaxCode char(2),
585 ReasSecCntyMaxCode char(2),
586 ReasSecCityMaxCode char(2),
587 ReasDistMaxCode char(2),
588
589 FedStat char ,
590 StStat char ,
591 SecStStat char ,
592 CntyStat char ,
593 LoclStat char ,
594 SecCntyStat char ,
595 SecLoclStat char ,
596 DistStat char ,
597
598 FedComment char ,
599 StComment char ,
600 SecStComment char ,
601 CntyComment char ,
602 LoclComment char ,
603 SecCntyComment char ,
604 SecLoclComment char ,
605 DistComment char ,
606
607 FedRateInd char ,
608 StRateInd char ,
609 SecStRateInd char ,
610 CntyRateInd char ,
611 LoclRateInd char ,
612 SecCntyRateInd char ,
613 SecLoclRateInd char ,
614 DistRateInd char ,
615
616 FedRate number(5,5),
617 StRate number(5,5),
618 SecStRate number(5,5),
619 CntyRate number(5,5),
620 LoclRate number(5,5),
621 SecCntyRate number(5,5),
622 SecLoclRate number(5,5),
623 DistRate number(5,5)
624
625 );
626
627
628
629
630
631
632
633
634 TYPE Location is RECORD
635 (
636 Country char(3),
637 State CHAR(2),
638 Cnty CHAR(3),
639 City VARCHAR2(26),
640 Zip CHAR(5),
641 Geo CHAR(2),
642 ZipExt VARCHAR2(4)
643 );
644
645 TYPE JurParm is RECORD
646 (
647 ShipFr Location,
648 ShipTo Location,
649 POA Location,
650 POO Location,
651 BillTo Location,
652 POT CHAR(1),
653 ServInd CHAR(1),
654 InOutCiLimShTo CHAR(1),
655 InOutCiLimShFr CHAR(1),
656 InOutCiLimPOO CHAR(1),
657 InOutCiLimPOA CHAR(1),
658 InOutCiLimBiTo CHAR(1),
659 PlaceBusnShTo CHAR(1),
660 PlaceBusnShFr CHAR(1),
661 PlaceBusnPOO CHAR(1),
662 PlaceBusnPOA CHAR(1),
663 JurLocType CHAR(1),
664 JurState CHAR(2),
665 JurCity VARCHAR2(26),
666 JurZip CHAR(5),
667 JurGeo CHAR(2),
668 JurZipExt VARCHAR2(4),
669 TypState CHAR(1),
670 TypCnty CHAR(1),
671 TypCity CHAR(1),
672 TypDist CHAR(1),
673 SecCity VARCHAR2(26),
674 SecZip VARCHAR2(5),
675 SecGeo CHAR(2),
676 SecZipExt VARCHAR2(4),
677 SecCounty CHAR(3),
678 TypFed CHAR(1),
679 TypSecState CHAR(1),
680 TypSecCnty CHAR(1),
681 TypSecCity CHAR(1),
682 ReturnCode CHAR(2),
683 POOJurRC CHAR(2),
684 POAJurRC CHAR(2),
685 ShpToJurRC CHAR(2),
686 ShpFrJurRC CHAR(2),
687 BillToJurRC CHAR(2),
688 EndLink CHAR(8)
689 );
690
691 TYPE CntySeq is RECORD
692 (
693 State CHAR(2),
694 County CHAR(3),
695 CntyName VARCHAR2(26)
696 );
697
698 /* Runtime Information Records */
699 /* State Table */
700 TYPE States is RECORD
701 (
702 StateNum NUMBER(2),
703 StateAlp CHAR(2),
704 StateNam VARCHAR2(26)
705 );
706
707 TYPE ConUseRec is RECORD
708 (
709 StateCode NUMBER(2),
710 SalesOrUse CHAR(1),
711 StateInd CHAR(1),
712 CntyInd CHAR(1),
713 CityInd CHAR(1),
714 SecCntyInd CHAR(1),
715 SecCityInd CHAR(1),
716 CustVendInd char
717 );
718
719
720 TYPE DivisionCds is RECORD
721 (
722 code VARCHAR2(20),
723 name VARCHAR2(20)
724 );
725
726 TYPE ReasonCds is RECORD
727 (
728 ReasonCd CHAR(2),
729 ShortDesc VARCHAR2(10),
730 ReasonText VARCHAR2(70)
731 );
732
733 TYPE JurisCd is RECORD
734 (
735 StateCd CHAR(2),
736 JurIntrCde CHAR(2),
740 JurisCode CHAR(2)
737 JurCntyCde CHAR(2),
738 JurCityCde CHAR(2),
739 JurTrnsCde CHAR(2),
741 );
742
743
744 /* Jurisdiction Descriptions */
745 TYPE JurisCdDesc is RECORD
746 (
747 JurisCdType CHAR(2),
748 JurisCdNum CHAR(2),
749 JurisCdText VARCHAR2(1500)
750 );
751
752 /******************************* T A X I O . H*******/
753 /* AccessType*/
754 AccessType CHAR;
755 READFILE CONSTANT CHAR :='r';
756 WRITEFILE CONSTANT CHAR :='w';
757
758 /* ReadType */
759 ReadType NUMBER;
760 DIRREAD CONSTANT NUMBER := 0;
761 SEQREAD CONSTANT NUMBER := 1;
762
763 /* Transit indicator - TRANSTYPE */
764 TRANSTYPE CHAR;
765 TR_NO_TAX CONSTANT CHAR :='0';
766 TR_SALES_ONLY CONSTANT CHAR :='1';
767 TR_SALES_USE CONSTANT CHAR :='2';
768
769 /* Jurisdiction code types - JURISCT */
770 JURISCT NUMBER;
771 JURTYP_INTRA_INTER_STATE CONSTANT NUMBER := 0;
772 JURTYP_COUNTY CONSTANT NUMBER := 1;
773 JURTYP_CITY CONSTANT NUMBER := 2;
774 JURTYP_TRANSIT CONSTANT NUMBER := 3;
775 JURTYP_TAXING CONSTANT NUMBER := 4;
776
777 /* Error Handling Constants - ERRTYPE */
778 ERRTYPE NUMBER;
779 NoErr CONSTANT NUMBER := 0;
780 ParmErr CONSTANT NUMBER := 4;
781 DataErr CONSTANT NUMBER := 5;
782 LockErr CONSTANT NUMBER := 7;
783 UnLockErr CONSTANT NUMBER := 8;
784 UpdateErr CONSTANT NUMBER := 10;
785 SQLErr CONSTANT NUMBER := 11;
786 NegInputErr CONSTANT NUMBER := 12;
787 LargeAmtErr CONSTANT NUMBER := 13;
788 DataErr CONSTANT NUMBER := 14;
789
790
791
792 /* Constants for Parm Error Numbers */
793 INVREADTYPE CONSTANT NUMBER := 1;
794 INVRECTYPE CONSTANT NUMBER := 2;
795 MAX_PARMERROR CONSTANT NUMBER := 3;
796
797 /* Constants for Product parm record errors */
798 INVLDPRODPARMID CONSTANT NUMBER := 1;
799 INVLDPRODRANGESEL CONSTANT NUMBER := 2;
800 INVLDPRODRANGE CONSTANT NUMBER := 3;
801 INVLDPRODSTCODE CONSTANT NUMBER := 4;
802 INVLDPRODSTIND CONSTANT NUMBER := 5;
803
804 /* Constants for Data Error Numbers */
805 INVDATE CONSTANT NUMBER := 1;
806 INVSTCODE CONSTANT NUMBER := 2;
807 DUPLREC CONSTANT NUMBER := 3;
808 INVALIDDATA CONSTANT NUMBER := 4;
809 LREADERROR CONSTANT NUMBER := 5;
810 LWRITEERROR CONSTANT NUMBER := 6;
811 INVNEXCODE CONSTANT NUMBER := 7;
812 INVSTCONV CONSTANT NUMBER := 8;
813 MAX_DATAERROR CONSTANT NUMBER := 8;
814
815 /* I/O Operations */
816 READFUNC CONSTANT NUMBER := 1;
817 WRITEFUNC CONSTANT NUMBER := 2;
818 SQLFUNC CONSTANT NUMBER := 3;
819
820
821 /* Current/Prior Tax Rate Structure */
822
823 TYPE TaxInfo is RECORD
824 (
825 /*
826 * NOTE: KMIZUTA Changed the following line from Date to Date1
827 * Needs to be confirmed.
828 */
829 Date1 DATE,
830 SalesRat NUMBER(5,5),
831 UseRate NUMBER(5,5),
832 SpecRate NUMBER(5,5)
833 );
834
835
836 TYPE StateEntry is RECORD
837 (
838 StateCode NUMBER(2),
839 StateAlpha CHAR(2),
840 StateName VARCHAR2(26),
841 ValidState BOOLEAN,
842 CtyTxInd BOOLEAN,
843 LclTxInd BOOLEAN,
844 CtyTrInd CHAR(1),/*change by vv from b*/
845 LclTrInd CHAR(1),/*change by vv from b*/
846 MaxTax NUMBER(5,5),
847 JurCode CHAR(1),
848 AdminCd CHAR(1),
849 JurIntrCde CHAR(2),
850 JurCntyCde CHAR(2),
851 JurCityCde CHAR(2),
852 JurTrnsCde CHAR(2),
853 JurisCode CHAR(2),
854 ProcessInvZp BOOLEAN,
855 TaxByItem BOOLEAN,
856 TaxFreight BOOLEAN,
857 RentalCode CHAR(1)
858 );
859
860 /********************T A X V A L I D . H*************************/
861
862 /* State Code Limits */
863 MINSTCD CONSTANT CHAR(2) := '01';
864 MAXSTCD CONSTANT CHAR(2) := '99';
865 MAXSTINT CONSTANT NUMBER := 100;
866
867 /* Amount and Rate Constants */
868 RATEMULT CONSTANT NUMBER(6,5) := 0.00001;
869 AMTMULT CONSTANT NUMBER(6,5) := 0.01;
870 CONVMULT CONSTANT NUMBER(6,5) := 0.001;
871 AUDIT_TAX_AMT_MULT CONSTANT NUMBER(6,5) := 0.001;
872 NOAMT CONSTANT NUMBER(6,5) := 0.00;
876 /* EPSILON CONSTANT NUMBER(6,5) := 0.000005; */
873 NORATE CONSTANT NUMBER(6,5) := 0.00000;
874 ZEROAMT CONSTANT NUMBER(6,5) := 0.00;
875 ZERORATE CONSTANT NUMBER(6,5) := 0.00000;
877
878 /* APO/FPO Location Names */
879 APO CONSTANT CHAR(4) := 'APO ';
880 FPO CONSTANT CHAR(3) := 'FPO';
881
882
883 /* State Code Constants for States with Special Processing */
884 TheStates NUMBER;
885 ALABAMA CONSTANT NUMBER := 1;
886 ALASKA CONSTANT NUMBER := 2;
887 ARIZONA CONSTANT NUMBER := 3;
888 ARKANSAS CONSTANT NUMBER := 4;
889 CALIFORNIA CONSTANT NUMBER := 5;
890 CANADA CONSTANT NUMBER := 52;
891 COLORADO CONSTANT NUMBER := 6;
892 DELAWARE CONSTANT NUMBER := 8;
893 FLORIDA CONSTANT NUMBER := 10;
894 HAWAII CONSTANT NUMBER := 12;
895 ILLINOIS CONSTANT NUMBER := 14;
896 INTERNTL CONSTANT NUMBER := 53;
897 LOUISIANA CONSTANT NUMBER := 19;
898 MISSOURI CONSTANT NUMBER := 26;
899 NEW_YORK CONSTANT NUMBER := 33;
900 NORTH_DAKOTA CONSTANT NUMBER := 35;
901 TEXAS CONSTANT NUMBER := 44;
902 TENNESSEE CONSTANT NUMBER := 43;
903 UTAH CONSTANT NUMBER := 45;
904
905 /* Miscellaneous */
906 MAX_REASONS CONSTANT NUMBER := 48;
907
908 /* Tax Master File Record Indicators */
909 CNTYRECS CONSTANT CHAR := 'Y';
910 CITYRECS CONSTANT CHAR := 'Y';
911
912 /* TMRECTYPE */
913 TMRECTYPE CHAR;
914 STRECTYP CONSTANT CHAR := '1';
915 CNRECTYP CONSTANT CHAR := '2';
916 LORECTYP CONSTANT CHAR := '3' ;
917
918 /* File: TAXIODB.H */
919 TYPE TaxStKey IS RECORD
920 (
921 StateCd CHAR(2)
922 );
923
924 TYPE TaxCnKey IS RECORD
925 (
926 StateCd CHAR(2),
927 CntyCd CHAR(3)
928 );
929
930 TYPE TaxLoKey IS RECORD
931 (
932 StateCd CHAR(2),
933 ZipCode CHAR(5),
934 GeoCode CHAR(2)
935 );
936
937 TYPE TFTaxMst IS RECORD
938 (
939 AdminCd CHAR(1),
940 CurrentRates TaxInfo,
941 PriorRates TaxInfo
942 );
943
944 TYPE TSTaxMst IS RECORD
945 (
946 Key TaxStKey,
947 StateNm VARCHAR2(26),
948 CtyTxInd BOOLEAN,
949 LclTxInd BOOLEAN,
950 CtyTrInd CHAR(1),/*change by vv from b*/
951 LclTrInd CHAR(1),/*change by vv fr b */
952 CurrTax TaxInfo,
953 PriorTax TaxInfo,
954 MaxTax NUMBER(5,5),
955 JurCode CHAR(1),
956 AdminCd CHAR(1)
957 );
958
959 TYPE TCTaxMst IS RECORD
960 (
961 Key TaxCnKey ,
962 CntyName VARCHAR2(26),
963 CurrTax TaxInfo,
964 PriorTax TaxInfo,
965 AdminCd CHAR(1),
966 TaxCode VARCHAR2(10),
967 ExcpCode CHAR(1)
968 );
969
970 TYPE ZipExtRegTyp IS RECORD
971 (
972 First VARCHAR2(4),
973 Last VARCHAR2(4)
974 );
975
976 TYPE TLTaxMst IS RECORD
977 (
978 Key TaxLoKey ,
979 LocName VARCHAR2(26),
980 CntyCode CHAR(3),
981 Duplicates CHAR(1),
982 CurrTax TaxInfo,
983 PriorTax TaxInfo,
984 CtyTxInd BOOLEAN,
985 ZipExtReg ZipExtRegTyp,
986 AdminCd CHAR(1),
987 TaxCode VARCHAR2(10),
988 ExcpCode CHAR(1)
989 );
990
991 /* Product Records */
992 TYPE ProdFlgs IS RECORD
993 (
994 MaxTax BOOLEAN,
995 RecCity BOOLEAN,
996 RecCnty BOOLEAN,
997 TaxState CHAR(1),
998 TaxCity CHAR(1),
999 TaxCnty CHAR(1),
1000 TaxTran CHAR(1)
1001 );
1002
1003 TYPE PrdStKeyTyp IS RECORD
1004 (
1005 ProdCode CHAR(5),
1006 StateCd NUMBER(2)
1007 );
1008
1009 TYPE PrdCnKeyTyp IS RECORD
1010 (
1011 ProdCode CHAR(5),
1012 StateCd NUMBER(2),
1013 CntyCode CHAR(3)
1014 );
1015
1016 TYPE PrdLoKeyTyp IS RECORD
1017 (
1018 ProdCode CHAR(5),
1019 StateCd NUMBER(2),
1023 /* Union - ProdKey */
1020 CityName VARCHAR2(26)
1021 );
1022
1024 TYPE ProdKeyTyp IS RECORD
1025 (
1026 State PrdStKeyTyp,
1027 County PrdCnKeyTyp,
1028 Local PrdLoKeyTyp
1029 );
1030
1031 TYPE MaxTaxTyp IS RECORD
1032 (
1033 CurrAmt NUMBER(14,2),
1034 PriorAmt NUMBER(14,2),
1035 MaxCurr NUMBER(14,2),
1036 MaxPrior NUMBER(14,2),
1037 CurrRt1 NUMBER(5,5),
1038 PriorRt1 NUMBER(5,5),
1039 CurrRt2 NUMBER(5,5),
1040 PriorRt2 NUMBER(5,5),
1041 EffDate DATE,
1042 CurrCode CHAR(2),
1043 PriorCd CHAR(2)
1044 );
1045
1046 TYPE ProdData IS RECORD
1047 (
1048 CurrRat NUMBER(5,5),
1049 PriorRat NUMBER(5,5),
1050 EffDate DATE,
1051 MaxTax MaxTaxTyp,
1052 ProdDesc VARCHAR2(12)
1053 );
1054
1055 TYPE ProdRec IS RECORD
1056 (
1057 Key ProdKeyTyp,
1058 Data ProdData,
1059 Flags ProdFlgs
1060 );
1061
1062 TYPE ProdStPF IS RECORD
1063 (
1064 Key PrdStKeyTyp,
1065 Data ProdData,
1066 Flags ProdFlgs
1067 );
1068
1069 TYPE ProdCnPF IS RECORD
1070 (
1071 Key PrdCnKeyTyp,
1072 Data ProdData
1073 );
1074
1075 TYPE ProdLoPF IS RECORD
1076 (
1077 Key PrdLoKeyTyp,
1078 Data ProdData
1079 );
1080
1081 /* Product Conversion Records */
1082 TYPE prodcode_data is RECORD
1083 (
1084 CompanyId VARCHAR2(20),
1085 BusnLocn VARCHAR2(13),
1086 UserPrCode1 VARCHAR2(25),
1087 UserPrCode2 VARCHAR2(25),
1088 AvpPrCode VARCHAR2(9)
1089 );
1090
1091 /******************************N E X P R O ************************/
1092
1093 /* if defined _TOOLKIT || defined _NEXPRO */
1094 MAXNEXINT CONSTANT INT := 20;
1095 /* used for array of nexus data */
1096 /* endif */
1097
1098 /* if defined SYSCTRL_USE_STEP */
1099 StepInstalled BOOLEAN; /* Added by VV */
1100 /* End if */
1101
1102 /* Constants for key selection */
1103 COMPRFILE CONSTANT CHAR := 'c' ;
1104 STNEXFILE CONSTANT CHAR := 's' ;
1105 LONEXFILE CONSTANT CHAR := 'l' ;
1106
1107 /* Enumerated data types - MPRECTYPE */
1108 MPRECTYPE CHAR;
1109 MPRECTYP CONSTANT CHAR := '1' ;
1110 SNRECTYP CONSTANT CHAR := '2' ;
1111 LNRECTYP CONSTANT CHAR := '3' ;
1112
1113
1114 /* NETIODB.H */
1115 TYPE merchant_profileTyp IS RECORD
1116 (
1117 compmastind CHAR(1),
1118 merchantid VARCHAR2(20),
1119 blstatecode NUMBER(2),
1120 busnlocn VARCHAR2(13),
1121 costcenter VARCHAR2(10),
1122 division VARCHAR2(20),
1123 blzipcode CHAR(5),
1124 blgeocode CHAR(2),
1125 blcityname VARCHAR2(26),
1126 blcountycode CHAR(3),
1127 blcountyname VARCHAR2(26),
1128 servind CHAR(1),
1129 bleffectdate DATE,
1130 blexpdate DATE,
1131 usejuris CHAR(1),
1132 useaudit CHAR(1),
1133 taxall CHAR,
1134 usemastnexus CHAR(1),
1135 audname VARCHAR2(20),
1136 sfstate NUMBER(2),
1137 sfzip CHAR(5),
1138 sfgeo CHAR(2),
1139 sfcity VARCHAR2(26),
1140 sfcountycode CHAR(3),
1141 sfcountyname VARCHAR2(26),
1142 sfplacebusn CHAR(1),
1143 sfservind CHAR(1),
1144 /* char outside city */
1145 poostate NUMBER(2),
1146 poozip CHAR(5),
1147 poogeo CHAR(2),
1148 poocity VARCHAR2(26),
1149 poocntycode CHAR(3),
1150 poocntyname VARCHAR2(26),
1151 pooplacebusn CHAR(1),
1152 pooservind CHAR(1),
1153 poastate NUMBER(2),
1154 poazip CHAR(5),
1155 poageo CHAR(2),
1156 poacity VARCHAR2(26),
1157 poacntycode CHAR(3),
1158 poacntyname VARCHAR2(26),
1159 poaplacebusn CHAR(1),
1160 poaservind CHAR(1),
1161 useerrorfile CHAR(1),
1162 stepflag CHAR(1),
1163 stepexpflag CHAR(1),
1164 optflags1 VARCHAR2(50),
1165 optflags2 VARCHAR2(50),
1166 optflags3 VARCHAR2(50)
1167 );
1168
1169 /* State Nexus Record */
1170 TYPE stnexusTyp IS RECORD
1171 (
1172 merchantid VARCHAR2(20),
1173 state NUMBER(2),
1177
1174 busnlocn VARCHAR2(13),
1175 nexuscode CHAR(1)
1176 );
1178 /* Local Nexus File Structure */
1179 TYPE loclnexusTyp IS RECORD
1180 (
1181 merchantid VARCHAR2(20),
1182 state NUMBER(2),
1183 rectype CHAR(1),
1184 name VARCHAR2(26),
1185 busnlocn VARCHAR2(13)
1186 );
1187
1188 /*Product conversion table Record */
1189 TYPE userprod_data IS RECORD
1190 (
1191 merchantid VARCHAR2(20),
1192 busnlocn VARCHAR2(13),
1193 usercode1 VARCHAR2(25),
1194 usercode2 VARCHAR2(25),
1195 taxcode VARCHAR2(9)
1196 );
1197
1198 /* NETIOSEQ.H */
1199 /* Merchant Profile/State Nexus/ Local Nexus Records */
1200 /* For AVP's testing purposes only!! */
1201
1202 /* Union - RecInfo Struct - MP */
1203
1204 TYPE RecInfoMPTyp IS RECORD
1205 (
1206 blstatecode NUMBER(2),
1207 busnlocn VARCHAR2(13),
1208 costcenter VARCHAR2(10),
1209 division VARCHAR2(20),
1210 blzipcode CHAR(5),
1211 blgeocode CHAR(2),
1212 blcityname VARCHAR2(26),
1213 blcountycode CHAR(3),
1214 blcountyname VARCHAR2(26),
1215 servind CHAR(1),
1216 bleffectdate DATE,
1217 blexpdate DATE,
1218 usejuris CHAR(1),
1219 useaudit CHAR(1),
1220 taxall CHAR,
1221 usemastnexus CHAR(1),
1222 audname VARCHAR2(20),
1223 sfstate NUMBER(2),
1224 sfzip CHAR(5),
1225 sfgeo CHAR(2),
1226 sfcity VARCHAR2(26),
1227 sfcountycode CHAR(3),
1228 sfcountyname VARCHAR2(26),
1229 sfplacebusn CHAR(1),
1230 sfservind CHAR(1),
1231 poostate NUMBER(2),
1232 poozip CHAR(5),
1233 poogeo CHAR(2),
1234 poocity VARCHAR2(26),
1235 poocntycode CHAR(3),
1236 poocntyname VARCHAR2(26),
1237 pooplacebusn CHAR(1),
1238 pooservind CHAR(1),
1239 poastate NUMBER(2),
1240 poazip CHAR(5),
1241 poageo CHAR(2),
1242 poacity VARCHAR2(26),
1243 poacntycode CHAR(3),
1244 poacntyname VARCHAR2(26),
1245 poaplacebusn CHAR(1),
1246 poaservind CHAR(1),
1247 useerrorfile CHAR(1),
1248 stepflag CHAR(1),
1249 stepexpflag CHAR(1),
1250 optflags VARCHAR2(50)
1251 );
1252
1253 /* Union - RecInfo Struct - SN */
1254 TYPE RecInfoSNTyp IS RECORD
1255 (
1256 state NUMBER(2),
1257 /* if defined _NEXPRO */
1258 busnlocn VARCHAR2(13),
1259 nexuscode CHAR(1)
1260 /* endif */
1261 );
1262
1263 /* Union - RecInfo Struct - LN */
1264 TYPE RecInfoLNTyp IS RECORD
1265 (
1266 state NUMBER(2),
1267 rectype CHAR(1),
1268 name VARCHAR2(26),
1269 /*if defined _NEXPRO */
1270 busnlocn VARCHAR2(13)
1271 /* endif */
1272 );
1273
1274 TYPE NetMstCh IS RECORD
1275 (
1276 TransCode CHAR(1),
1277 /* if defined _NEXPRO */
1278 compmastind CHAR(1),
1279 /* endif */
1280 MerchantID VARCHAR2(20),
1281 RecType CHAR(1),
1282 /* Union - RecInfo */
1283 RecInfoMP RecInfoMPTyp,
1284 RecInfoSN RecInfoSNTyp,
1285 RecInfoLN RecInfoLNTyp
1286 );
1287
1288 /* start here if defined _NEXPRO */
1289 /* NexusCode Table and Local Admin Data Structures */
1290 /* For AVP's testing purposes only!! */
1291
1292 TYPE nexcodedata IS RECORD
1293 (
1294 NexusCode CHAR(1),
1295 NexusDesc CHAR(256)
1296 );
1297
1298 TYPE localadmndata IS RECORD
1299 (
1300 StateAlphaCode NUMBER(2),
1301 StateCode NUMBER(2),
1302 rectype CHAR(1),
1303 LocName VARCHAR2(26)
1304 );
1305
1306 /* Pointer Handling generic overloaded Procedures */
1307 PROCEDURE TAXSP_CopyRec( CnRec TCTaxMst, RecFlag CHAR);
1308 PROCEDURE TAXSP_CopyRec( LoRec TLTaxMst, RecFlag CHAR);
1309
1310 END ZX_TAX_TAXWARE_GEN_STUB;