1 PACKAGE ZX_EXTRACT_PKG AS
2 /* $Header: zxriextractwpkgs.pls 120.20.12010000.3 2008/11/12 12:43:41 spasala ship $ */
3 --
4 -----------------------------------------
5 --Public Variable Declarations
6 -----------------------------------------
7 --
8 -----------------------------------------
9 --Public Methods Declarations
10 -----------------------------------------
11 /*===========================================================================+
12 | PROCEDURE |
13 | populate_tax_data |
14 | |
15 | DESCRIPTION |
16 | This is the main procedure of the ZX_EXTRACT_PKG, which populates |
17 | tax data into tax extract interface tables |
18 | |
19 | SCOPE - Public |
20 | |
21 | NOTES |
22 | |
23 | MODIFICATION HISTORY |
24 | |
25 +===========================================================================*/
26
27
28 TYPE TRL_GLOBAL_VARIABLES_REC_TYPE IS RECORD
29 (
30 REPORTING_LEVEL VARCHAR2(30),
31 REPORTING_CONTEXT VARCHAR2(30),
32 -- apai LEGAL_ENTITY_LEVEL VARCHAR2(30),
33 LEGAL_ENTITY_ID NUMBER, -- apai COMPANY_NAME
34 SUMMARY_LEVEL VARCHAR2(30),
35 LEDGER_ID NUMBER,
36 REPORTING_LEDGER_ID NUMBER,
37 REGISTER_TYPE VARCHAR2(30),
38 PRODUCT VARCHAR2(30),
39 MATRIX_REPORT VARCHAR2(30),
40 DETAIL_LEVEL VARCHAR2(30), --
41 CURRENCY_CODE_LOW VARCHAR2(30),
42 CURRENCY_CODE_HIGH VARCHAR2(30),
43 INCLUDE_AP_STD_TRX_CLASS VARCHAR2(1),
44 INCLUDE_AP_DM_TRX_CLASS VARCHAR2(1),
45 INCLUDE_AP_CM_TRX_CLASS VARCHAR2(1),
46 INCLUDE_AP_PREP_TRX_CLASS VARCHAR2(1),
47 INCLUDE_AP_MIX_TRX_CLASS VARCHAR2(1),
48 INCLUDE_AP_EXP_TRX_CLASS VARCHAR2(1),
49 INCLUDE_AP_INT_TRX_CLASS VARCHAR2(1),
50 INCLUDE_AR_INV_TRX_CLASS VARCHAR2(1),
51 INCLUDE_AR_APPL_TRX_CLASS VARCHAR2(1),
52 INCLUDE_AR_ADJ_TRX_CLASS VARCHAR2(30),
53 INCLUDE_AR_MISC_TRX_CLASS VARCHAR2(1),
54 INCLUDE_AR_BR_TRX_CLASS VARCHAR2(1),
55 INCLUDE_GL_MANUAL_LINES VARCHAR2(30),
56 THIRD_PARTY_REP_LEVEL VARCHAR2(30), --
57 FIRST_PARTY_TAX_REG_NUM VARCHAR2(30),
58 TRX_NUMBER_LOW VARCHAR2(30),
59 TRX_NUMBER_HIGH VARCHAR2(30),
60 EXTRACT_REPORT_LINE_NUMBER NUMBER,
61 AR_TRX_PRINTING_STATUS VARCHAR2(30),
62 AR_EXEMPTION_STATUS VARCHAR2(30),
63 GL_DATE_LOW DATE,
64 GL_DATE_HIGH DATE,
65 TRX_DATE_LOW DATE,
66 TRX_DATE_HIGH DATE,
67 GL_PERIOD_NAME_LOW VARCHAR2(15),
68 GL_PERIOD_NAME_HIGH VARCHAR2(15),
69 TRX_DATE_PERIOD_NAME_LOW VARCHAR2(15),
70 TRX_DATE_PERIOD_NAME_HIGH VARCHAR2(15),
71 TAX_JURISDICTION_CODE VARCHAR(30),
72 TAX_REGIME_CODE VARCHAR2(30),
73 TAX VARCHAR2(30),
74 TAX_STATUS_CODE VARCHAR2(30),
75 --TAX_RATE_CODE VARCHAR2(30),
76 TAX_RATE_CODE_LOW VARCHAR2(30),
77 TAX_RATE_CODE_HIGH VARCHAR2(30),
78 --TAX_TYPE_CODE VARCHAR2(30),
79 TAX_TYPE_CODE_LOW VARCHAR2(30),
80 TAX_TYPE_CODE_HIGH VARCHAR2(30),
81 DOCUMENT_SUB_TYPE VARCHAR2(30),
82 TRX_BUSINESS_CATEGORY VARCHAR2(30),
83 TAX_INVOICE_DATE_LOW VARCHAR2(30),
84 TAX_INVOICE_DATE_HIGH VARCHAR2(30),
85 POSTING_STATUS VARCHAR2(30),
86 EXTRACT_ACCTED_TAX_LINES VARCHAR2(30),
87 INCLUDE_ACCOUNTING_SEGMENTS VARCHAR2(1),
88 BALANCING_SEGMENT_LOW VARCHAR2(30),
89 BALANCING_SEGMENT_HIGH VARCHAR2(30),
90 INCLUDE_DISCOUNTS VARCHAR2(1),
91 EXTRACT_STARTING_LINE_NUM NUMBER,
92 REQUEST_ID NUMBER,
93 REPORT_NAME VARCHAR2(30),
94 VAT_TRANSACTION_TYPE_CODE VARCHAR2(30),
95 INCLUDE_FULLY_NR_TAX_FLAG VARCHAR2(30),
96 MUNICIPAL_TAX_TYPE_CODE_LOW VARCHAR2(30),
97 MUNICIPAL_TAX_TYPE_CODE_HIGH VARCHAR2(30),
98 PROV_TAX_TYPE_CODE_LOW VARCHAR2(30),
99 PROV_TAX_TYPE_CODE_HIGH VARCHAR2(30),
100 EXCISE_TAX_TYPE_CODE_LOW VARCHAR2(30),
101 EXCISE_TAX_TYPE_CODE_HIGH VARCHAR2(30),
102 NON_TAXABLE_TAX_TYPE_CODE VARCHAR2(30),
103 PER_TAX_TYPE_CODE_LOW VARCHAR2(30),
104 PER_TAX_TYPE_CODE_HIGH VARCHAR2(30),
105 FED_PER_TAX_TYPE_CODE_LOW VARCHAR2(30),
106 FED_PER_TAX_TYPE_CODE_HIGH VARCHAR2(30),
107 VAT_TAX_TYPE_CODE VARCHAR2(30),
108 EXCISE_TAX VARCHAR2(30),
109 VAT_ADDITIONAL_TAX VARCHAR2(30),
110 VAT_NON_TAXABLE_TAX VARCHAR2(30),
111 VAT_NOT_TAX VARCHAR2(30),
112 VAT_PERCEPTION_TAX VARCHAR2(30),
113 VAT_TAX VARCHAR2(30),
114 INC_SELF_WD_TAX VARCHAR2(30),
115 EXCLUDING_TRX_LETTER VARCHAR2(30),
116 TRX_LETTER_LOW VARCHAR2(30),
117 TRX_LETTER_HIGH VARCHAR2(30),
118 INCLUDE_REFERENCED_SOURCE VARCHAR2(30),
119 PARTY_NAME VARCHAR2(30),
120 BATCH_NAME VARCHAR2(30),
121 BATCH_DATE_LOW DATE,
122 BATCH_DATE_HIGH DATE,
123 BATCH_SOURCE_ID VARCHAR2(30),
124 ADJUSTED_DOC_FROM VARCHAR2(30),
125 ADJUSTED_DOC_TO VARCHAR2(30),
126 STANDARD_VAT_TAX_RATE VARCHAR2(30),
127 MUNICIPAL_TAX VARCHAR2(30),
128 PROVINCIAL_TAX VARCHAR2(30),
129 TAX_ACCOUNT_LOW VARCHAR2(300),
130 TAX_ACCOUNT_HIGH VARCHAR2(300),
131 TAXABLE_ACCOUNT_LOW VARCHAR2(30),
132 TAXABLE_ACCOUNT_HIGH VARCHAR2(30),
133 EXP_CERT_DATE_FROM DATE,
134 EXP_CERT_DATE_TO DATE,
135 EXP_METHOD VARCHAR2(30),
136 PRINT_COMPANY_INFO VARCHAR2(30),
137 ORDER_BY VARCHAR2(80), --
138 CHART_OF_ACCOUNTS_ID NUMBER,
139 GDF_GL_JE_LINES_CATEGORY VARCHAR2(30),
140 GDF_GL_JE_LINES_ATT3 VARCHAR2(30),
141 GDF_GL_JE_LINES_ATT3_IS_NULL VARCHAR2(30),
142 REPRINT VARCHAR2(1),
143 ERRBUF VARCHAR2(30),
144 RETCODE VARCHAR2(30),
145 ACCOUNTING_STATUS VARCHAR2(30),
146 REPORTED_STATUS VARCHAR2(30),
147 LEDGER_NAME VARCHAR2(30),
148 FUNC_CURRENCY_CODE VARCHAR2(15),
149 GL_OR_TRX_DATE_FILTER varchar2(1)); --Bug 5396444
150
151 --New Extract Declaration -- Skorrapa
152 -- Table type declaration of ZX_REP_TRX_DETAIL_T columns.
153
154 TYPE REQUEST_ID_TBL IS TABLE OF
155 ZX_REP_TRX_DETAIL_T.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
156
157 TYPE REP_CONTEXT_ID_TBL IS TABLE OF
158 ZX_REP_TRX_DETAIL_T.REP_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;
159
160 TYPE DETAIL_TAX_LINE_ID_TBL IS TABLE OF
161 ZX_REP_TRX_DETAIL_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
162
163 TYPE EXTRACT_LINE_ID_TBL IS TABLE OF
164 ZX_REP_TRX_DETAIL_T.EXTRACT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
165
166 TYPE EXTRACT_REPORT_LINE_NUMBER_TBL IS TABLE OF
167 ZX_REP_TRX_DETAIL_T.EXTRACT_REPORT_LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
168
169 TYPE LEDGER_ID_TBL IS TABLE OF
170 ZX_REP_TRX_DETAIL_T.LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
171
172 TYPE LEDGER_NAME_TBL IS TABLE OF
173 ZX_REP_TRX_DETAIL_T.LEDGER_NAME%TYPE INDEX BY BINARY_INTEGER;
174
175 TYPE CHART_OF_ACCOUNTS_ID_TBL IS TABLE OF
176 ZX_REP_TRX_DETAIL_T.CHART_OF_ACCOUNTS_ID%TYPE INDEX BY BINARY_INTEGER;
177
178 TYPE EXTRACT_SOURCE_LEDGER_TBL IS TABLE OF
179 ZX_REP_TRX_DETAIL_T.EXTRACT_SOURCE_LEDGER%TYPE INDEX BY BINARY_INTEGER;
180
181 TYPE EVENT_CLASS_CODE_TBL IS TABLE OF
182 ZX_REP_TRX_DETAIL_T.EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
183
184 TYPE DOC_EVENT_STATUS_TBL IS TABLE OF
185 ZX_REP_TRX_DETAIL_T.DOC_EVENT_STATUS%TYPE INDEX BY BINARY_INTEGER;
186
187 TYPE APPLICATION_DOC_STATUS_TBL IS TABLE OF
188 ZX_REP_TRX_DETAIL_T.APPLICATION_DOC_STATUS%TYPE INDEX BY BINARY_INTEGER;
189
190 TYPE ESTABLISHMENT_ID_TBL IS TABLE OF
191 ZX_REP_TRX_DETAIL_T.ESTABLISHMENT_ID%TYPE INDEX BY BINARY_INTEGER;
192
193 TYPE APPLICATION_ID_TBL IS TABLE OF
194 ZX_REP_TRX_DETAIL_T.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
195
196 TYPE INTERNAL_ORGANIZATION_ID_TBL IS TABLE OF
197 ZX_REP_TRX_DETAIL_T.INTERNAL_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
198
199 TYPE TRX_ID_TBL IS TABLE OF
200 ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
201
202 TYPE TRX_NUMBER_TBL IS TABLE OF
203 ZX_REP_TRX_DETAIL_T.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
204
205 TYPE TRX_DESCRIPTION_TBL IS TABLE OF
206 ZX_REP_TRX_DETAIL_T.TRX_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
207
208 TYPE TRX_CURRENCY_CODE_TBL IS TABLE OF
209 ZX_REP_TRX_DETAIL_T.TRX_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
210
211 TYPE TRX_LINE_ID_TBL IS TABLE OF
212 ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
213
214 TYPE TRX_LINE_NUMBER_TBL IS TABLE OF
215 ZX_REP_TRX_DETAIL_T.TRX_LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
216
217 TYPE TRX_LINE_DESCRIPTION_TBL IS TABLE OF
218 ZX_REP_TRX_DETAIL_T.TRX_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
219
220 TYPE TRX_LINE_TYPE_TBL IS TABLE OF
221 ZX_REP_TRX_DETAIL_T.TRX_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
222
223 TYPE TRX_DATE_TBL IS TABLE OF
224 ZX_REP_TRX_DETAIL_T.TRX_DATE%TYPE INDEX BY BINARY_INTEGER;
225
226 TYPE DEPOSIT_DATE_TBL IS TABLE OF
227 ZX_REP_TRX_DETAIL_T.DEPOSIT_DATE%TYPE INDEX BY BINARY_INTEGER;
228
229 TYPE TRX_DUE_DATE_TBL IS TABLE OF
230 ZX_REP_TRX_DETAIL_T.TRX_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
231
232 TYPE TRX_SHIPPING_DATE_TBL IS TABLE OF
233 ZX_REP_TRX_DETAIL_T.TRX_SHIPPING_DATE%TYPE INDEX BY BINARY_INTEGER;
234
235 TYPE TRX_COMMUNICATED_DATE_TBL IS TABLE OF
236 ZX_REP_TRX_DETAIL_T.TRX_COMMUNICATED_DATE%TYPE INDEX BY BINARY_INTEGER;
237
238 TYPE TRX_TYPE_DESCRIPTION_TBL IS TABLE OF
239 ZX_REP_TRX_DETAIL_T.TRX_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
240
241 TYPE TRX_TYPE_ID_TBL IS TABLE OF
242 ZX_REP_TRX_DETAIL_T.TRX_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
243
244 TYPE TRX_BATCH_SOURCE_NAME_TBL IS TABLE OF
245 ZX_REP_TRX_DETAIL_T.TRX_BATCH_SOURCE_NAME%TYPE INDEX BY BINARY_INTEGER;
246
247 TYPE TRX_SIC_CODE_TBL IS TABLE OF
248 ZX_REP_TRX_DETAIL_T.TRX_SIC_CODE%TYPE INDEX BY BINARY_INTEGER;
249
250 TYPE FOB_POINT_TBL IS TABLE OF
251 ZX_REP_TRX_DETAIL_T.FOB_POINT%TYPE INDEX BY BINARY_INTEGER;
252
253 TYPE TRX_WAYBILL_NUMBER_TBL IS TABLE OF
254 ZX_REP_TRX_DETAIL_T.TRX_WAYBILL_NUMBER%TYPE INDEX BY BINARY_INTEGER;
255
256 TYPE TRX_LINE_CLASS_TBL IS TABLE OF
257 ZX_REP_TRX_DETAIL_T.TRX_LINE_CLASS%TYPE INDEX BY BINARY_INTEGER;
258
259 TYPE PRODUCT_ID_TBL IS TABLE OF
260 ZX_REP_TRX_DETAIL_T.PRODUCT_ID%TYPE INDEX BY BINARY_INTEGER;
261
262 TYPE PRODUCT_DESCRIPTION_TBL IS TABLE OF
263 ZX_REP_TRX_DETAIL_T.PRODUCT_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
264
265 TYPE FUNCTIONAL_CURRENCY_CODE_TBL IS TABLE OF
266 ZX_REP_TRX_DETAIL_T.FUNCTIONAL_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
267
268 TYPE CURRENCY_CONVERSION_TYPE_TBL IS TABLE OF
269 ZX_REP_TRX_DETAIL_T.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
270
271 TYPE CURRENCY_CONVERSION_DATE_TBL IS TABLE OF
272 ZX_REP_TRX_DETAIL_T.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
273
274 TYPE CURRENCY_CONVERSION_RATE_TBL IS TABLE OF
275 ZX_REP_TRX_DETAIL_T.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
276
277 TYPE PRECISION_TBL IS TABLE OF
278 ZX_REP_TRX_DETAIL_T.PRECISION%TYPE INDEX BY BINARY_INTEGER;
279
280 TYPE MINIMUM_ACCOUNTABLE_UNIT_TBL IS TABLE OF
281 ZX_REP_TRX_DETAIL_T.MINIMUM_ACCOUNTABLE_UNIT%TYPE INDEX BY BINARY_INTEGER;
282
283 TYPE GDF_FND_CURRENCIES_ATT1_TBL IS TABLE OF
284 ZX_REP_TRX_DETAIL_T.GDF_FND_CURRENCIES_ATT1%TYPE INDEX BY BINARY_INTEGER;
285
286 TYPE CURRENCY_CODE_DESC_TBL IS TABLE OF
287 ZX_REP_TRX_DETAIL_T.CURRENCY_CODE_DESC%TYPE INDEX BY BINARY_INTEGER;
288
289 TYPE TERRITORY_SHORT_NAME_TBL IS TABLE OF
290 ZX_REP_TRX_DETAIL_T.TERRITORY_SHORT_NAME%TYPE INDEX BY BINARY_INTEGER;
291
292 TYPE DOC_SEQ_ID_TBL IS TABLE OF
293 ZX_REP_TRX_DETAIL_T.DOC_SEQ_ID%TYPE INDEX BY BINARY_INTEGER;
294
295 TYPE DOC_SEQ_NAME_TBL IS TABLE OF
296 ZX_REP_TRX_DETAIL_T.DOC_SEQ_NAME%TYPE INDEX BY BINARY_INTEGER;
297
298 TYPE DOC_SEQ_VALUE_TBL IS TABLE OF
299 ZX_REP_TRX_DETAIL_T.DOC_SEQ_VALUE%TYPE INDEX BY BINARY_INTEGER;
300
301 TYPE TRX_LINE_QUANTITY_TBL IS TABLE OF
302 ZX_REP_TRX_DETAIL_T.TRX_LINE_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
303
304 TYPE TRX_LINE_AMT_TBL IS TABLE OF
305 ZX_REP_TRX_DETAIL_T.TRX_LINE_AMT%TYPE INDEX BY BINARY_INTEGER;
306
307 TYPE UOM_CODE_TBL IS TABLE OF
308 ZX_REP_TRX_DETAIL_T.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
309
310 TYPE RECEIPT_CLASS_ID_TBL IS TABLE OF
311 ZX_REP_TRX_DETAIL_T.RECEIPT_CLASS_ID%TYPE INDEX BY BINARY_INTEGER;
312
313 TYPE BATCH_SOURCE_ID_TBL IS TABLE OF
314 ZX_REP_TRX_DETAIL_T.TRX_BATCH_SOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
315
316 TYPE TRX_BATCH_SOURCE_DATE_TBL IS TABLE OF
317 ZX_REP_TRX_DETAIL_T.TRX_BATCH_SOURCE_DATE%TYPE INDEX BY BINARY_INTEGER;
318
319 TYPE RELATED_DOC_APPLICATION_ID_TBL IS TABLE OF
320 ZX_REP_TRX_DETAIL_T.RELATED_DOC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
321
322 TYPE RELATED_DOC_ENTITY_CODE_TBL IS TABLE OF
323 ZX_REP_TRX_DETAIL_T.RELATED_DOC_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
324
325 TYPE RELATED_DOC_EVENT_CLS_CODE_TBL IS TABLE OF
326 ZX_REP_TRX_DETAIL_T.RELATED_DOC_EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
327
328 TYPE RELATED_DOC_TRX_ID_TBL IS TABLE OF
329 ZX_REP_TRX_DETAIL_T.RELATED_DOC_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
330
331 TYPE RELATED_DOC_NUMBER_TBL IS TABLE OF
332 ZX_REP_TRX_DETAIL_T.RELATED_DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
333
334 TYPE RELATED_DOC_DATE_TBL IS TABLE OF
335 ZX_REP_TRX_DETAIL_T.RELATED_DOC_DATE%TYPE INDEX BY BINARY_INTEGER;
336
340 TYPE APPLIED_FROM_LINE_ID_TBL IS TABLE OF
337 TYPE APPLIED_FROM_APPL_ID_TBL IS TABLE OF
338 ZX_REP_TRX_DETAIL_T.APPLIED_FROM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
339
341 ZX_REP_TRX_DETAIL_T.APPLIED_FROM_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
342
343 TYPE APPLIED_FROM_ENTITY_CODE_TBL IS TABLE OF
344 ZX_REP_TRX_DETAIL_T.APPLIED_FROM_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
345
346 TYPE APPLIED_FROM_TRX_ID_TBL IS TABLE OF
347 ZX_REP_TRX_DETAIL_T.APPLIED_FROM_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
348
349 TYPE APPLIED_FROM_EVENT_CLS_CD_TBL IS TABLE OF
350 ZX_REP_TRX_DETAIL_T.APPLIED_FROM_EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
351
352 TYPE APPLIED_FROM_TRX_NUMBER_TBL IS TABLE OF
353 ZX_REP_TRX_DETAIL_T.APPLIED_FROM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
354
355 TYPE TRX_APPLIED_FROM_CLASS_MNG_TBL IS TABLE OF
356 ZX_REP_TRX_DETAIL_T.TRX_APPLIED_FROM_CLASS_MNG%TYPE INDEX BY BINARY_INTEGER;
357
358 TYPE ADJUSTED_DOC_APPL_ID_TBL IS TABLE OF
359 ZX_REP_TRX_DETAIL_T.ADJUSTED_DOC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
360
361 TYPE ADJUSTED_DOC_ENTITY_CODE_TBL IS TABLE OF
362 ZX_REP_TRX_DETAIL_T.ADJUSTED_DOC_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
363
364 TYPE ADJUSTED_DOC_EVENT_CLS_CD_TBL IS TABLE OF
365 ZX_REP_TRX_DETAIL_T.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
366
367 TYPE ADJUSTED_DOC_TRX_ID_TBL IS TABLE OF
368 ZX_REP_TRX_DETAIL_T.ADJUSTED_DOC_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
369
370 TYPE ADJUSTED_DOC_NUMBER_TBL IS TABLE OF
371 ZX_REP_TRX_DETAIL_T.ADJUSTED_DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
372
373 TYPE ADJUSTED_DOC_DATE_TBL IS TABLE OF
374 ZX_REP_TRX_DETAIL_T.ADJUSTED_DOC_DATE%TYPE INDEX BY BINARY_INTEGER;
375
376 TYPE APPLIED_TO_APPLICATION_ID_TBL IS TABLE OF
377 ZX_REP_TRX_DETAIL_T.APPLIED_TO_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
378
379 TYPE APPLIED_TO_TRX_ID_TBL IS TABLE OF
380 ZX_REP_TRX_DETAIL_T.APPLIED_TO_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
381
382 TYPE APPLIED_TO_TRX_LINE_ID_TBL IS TABLE OF
383 ZX_REP_TRX_DETAIL_T.APPLIED_TO_TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
384
385 TYPE APPLIED_TO_ENTITY_CODE_TBL IS TABLE OF
386 ZX_REP_TRX_DETAIL_T.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
387
388 TYPE APPLIED_TO_EVENT_CLS_CODE_TBL IS TABLE OF
389 ZX_REP_TRX_DETAIL_T.APPLIED_TO_EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
390
391 TYPE APPLIED_TO_TRX_NUMBER_TBL IS TABLE OF
392 ZX_REP_TRX_DETAIL_T.APPLIED_TO_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
393
394 TYPE TRX_APPLIED_TO_CLASS_MNG_TBL IS TABLE OF
395 ZX_REP_TRX_DETAIL_T.TRX_APPLIED_TO_CLASS_MNG%TYPE INDEX BY BINARY_INTEGER;
396
397 TYPE REF_DOC_APPLICATION_ID_TBL IS TABLE OF
398 ZX_REP_TRX_DETAIL_T.REF_DOC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
399
400 TYPE REF_DOC_ENTITY_CODE_TBL IS TABLE OF
401 ZX_REP_TRX_DETAIL_T.REF_DOC_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
402
403 TYPE REF_DOC_EVENT_CLASS_CODE_TBL IS TABLE OF
404 ZX_REP_TRX_DETAIL_T.REF_DOC_EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
405
406 TYPE REF_DOC_TRX_ID_TBL IS TABLE OF
407 ZX_REP_TRX_DETAIL_T.REF_DOC_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
408 TYPE REF_DOC_LINE_ID_TBL IS TABLE OF
409 ZX_REP_TRX_DETAIL_T.REF_DOC_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
410
411 TYPE REF_DOC_LINE_QUANTITY_TBL IS TABLE OF
412 ZX_REP_TRX_DETAIL_T.REF_DOC_LINE_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
413
414 TYPE MERCHANT_PARTY_DOC_NUM_TBL IS TABLE OF
415 ZX_REP_TRX_DETAIL_T.MERCHANT_PARTY_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
416
417 TYPE MERCHANT_PARTY_NAME_TBL IS TABLE OF
418 ZX_REP_TRX_DETAIL_T.MERCHANT_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;
419
420 TYPE MERCHANT_PARTY_REFERENCE_TBL IS TABLE OF
421 ZX_REP_TRX_DETAIL_T.MERCHANT_PARTY_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
422
423 TYPE MERCHANT_PARTY_TAX_REG_NUM_TBL IS TABLE OF
424 ZX_REP_TRX_DETAIL_T.MERCHANT_PARTY_TAX_REG_NUMBER%TYPE INDEX BY BINARY_INTEGER;
425
426 TYPE MERCHANT_PARTY_TAXPAYER_ID_TBL IS TABLE OF
427 ZX_REP_TRX_DETAIL_T.MERCHANT_PARTY_TAXPAYER_ID%TYPE INDEX BY BINARY_INTEGER;
428
429 TYPE COUNTRY_OF_SUPPLY_TBL IS TABLE OF
430 ZX_REP_TRX_DETAIL_T.COUNTRY_OF_SUPPLY%TYPE INDEX BY BINARY_INTEGER;
431
432 TYPE START_EXPENSE_DATE_TBL IS TABLE OF
433 ZX_REP_TRX_DETAIL_T.START_EXPENSE_DATE%TYPE INDEX BY BINARY_INTEGER;
434
435 TYPE DEFAULT_TAXATION_COUNTRY_TBL IS TABLE OF
436 ZX_REP_TRX_DETAIL_T.DEFAULT_TAXATION_COUNTRY%TYPE INDEX BY BINARY_INTEGER;
437
438 TYPE TRX_CLASS_MNG_TBL IS TABLE OF
439 ZX_REP_TRX_DETAIL_T.TRX_CLASS_MNG%TYPE INDEX BY BINARY_INTEGER;
440
441 TYPE TRX_TYPE_MNG_TBL IS TABLE OF
442 ZX_REP_TRX_DETAIL_T.TRX_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
443
444 TYPE TAX_APPLIED_TBL IS TABLE OF
445 ZX_REP_TRX_DETAIL_T.TAX_APPLIED%TYPE INDEX BY BINARY_INTEGER;
446
447 TYPE TAX_RATE_CODE_REG_TYPE_MNG_TBL IS TABLE OF
448 ZX_REP_TRX_DETAIL_T.TAX_RATE_CODE_REG_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
449
450 TYPE TAX_EXEMPT_REASON_MNG_TBL IS TABLE OF
451 ZX_REP_TRX_DETAIL_T.TAX_EXEMPT_REASON_MNG%TYPE INDEX BY BINARY_INTEGER;
452
453 TYPE TAX_EXCEPTION_REASON_MNG_TBL IS TABLE OF
454 ZX_REP_TRX_DETAIL_T.TAX_EXCEPTION_REASON_MNG%TYPE INDEX BY BINARY_INTEGER;
455
456 TYPE TRX_QUANTITY_UOM_MNG_TBL IS TABLE OF
457 ZX_REP_TRX_DETAIL_T.TRX_QUANTITY_UOM_MNG%TYPE INDEX BY BINARY_INTEGER;
458
459 TYPE TAX_RATE_VAT_TRX_TYPE_MNG_TBL IS TABLE OF
463 ZX_REP_TRX_DETAIL_T.DOCUMENT_SUB_TYPE%TYPE INDEX BY BINARY_INTEGER;
460 ZX_REP_TRX_DETAIL_T.TAX_RATE_CODE_VAT_TRX_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
461
462 TYPE DOCUMENT_SUB_TYPE_TBL IS TABLE OF
464
465 TYPE SUPPLIER_TAX_INVOICE_NUM_TBL IS TABLE OF
466 ZX_REP_TRX_DETAIL_T.SUPPLIER_TAX_INVOICE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
467
468 TYPE SUPPLIER_TAX_INVOICE_DATE_TBL IS TABLE OF
469 ZX_REP_TRX_DETAIL_T.SUPPLIER_TAX_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
470
471 TYPE SUPPLIER_EXCHANGE_RATE_TBL IS TABLE OF
472 ZX_REP_TRX_DETAIL_T.SUPPLIER_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
473
474 TYPE TAX_INVOICE_DATE_TBL IS TABLE OF
475 ZX_REP_TRX_DETAIL_T.TAX_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
476
477 TYPE TAX_INVOICE_NUMBER_TBL IS TABLE OF
478 ZX_REP_TRX_DETAIL_T.TAX_INVOICE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
479
480 TYPE LINE_INTENDED_USE_TBL IS TABLE OF
481 ZX_REP_TRX_DETAIL_T.LINE_INTENDED_USE%TYPE INDEX BY BINARY_INTEGER;
482
483 TYPE PROD_FISC_CLASSIFICATION_TBL IS TABLE OF
484 ZX_REP_TRX_DETAIL_T.PRODUCT_FISC_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
485
486 TYPE PRODUCT_CATEGORY_TBL IS TABLE OF
487 ZX_REP_TRX_DETAIL_T.PRODUCT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
488
489 TYPE USER_DEFINED_FISC_CLASS_TBL IS TABLE OF
490 ZX_REP_TRX_DETAIL_T.USER_DEFINED_FISC_CLASS%TYPE INDEX BY BINARY_INTEGER;
491
492 TYPE TRX_BUSINESS_CATEGORY_TBL IS TABLE OF
493 ZX_REP_TRX_DETAIL_T.TRX_BUSINESS_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
494
495 TYPE ASSESSABLE_VALUE_TBL IS TABLE OF
496 ZX_REP_TRX_DETAIL_T.ASSESSABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
497
498 TYPE PORT_OF_ENTRY_CODE_TBL IS TABLE OF
499 ZX_REP_TRX_DETAIL_T.PORT_OF_ENTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
500
501 TYPE TAXABLE_LINE_ITEM_FLEXLD_TBL IS TABLE OF
502 ZX_REP_TRX_DETAIL_T.TAXABLE_LINE_ITEM_FLEXFIELD%TYPE INDEX BY BINARY_INTEGER;
503
504 TYPE TAXABLE_LINE_SOURCE_TABLE_TBL IS TABLE OF
505 ZX_REP_TRX_DETAIL_T.TAXABLE_LINE_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
506
507 TYPE TAXABLE_LINE_TOTAL_AMOUNT_TBL IS TABLE OF
508 ZX_REP_TRX_DETAIL_T.TAXABLE_LINE_TOTAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
509
510 TYPE TAX_LINE_ID_TBL IS TABLE OF
511 ZX_REP_TRX_DETAIL_T.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
512
513 TYPE TAX_LINE_NUMBER_TBL IS TABLE OF
514 ZX_REP_TRX_DETAIL_T.TAX_LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
515
516 TYPE TAX_AMT_TBL IS TABLE OF
517 ZX_REP_TRX_DETAIL_T.TAX_AMT%TYPE INDEX BY BINARY_INTEGER;
518
519 TYPE TAX_AMT_FUNCL_CURR_TBL IS TABLE OF
520 ZX_REP_TRX_DETAIL_T.TAX_AMT_FUNCL_CURR%TYPE INDEX BY BINARY_INTEGER;
521
522 TYPE TAXABLE_AMT_TBL IS TABLE OF
523 ZX_REP_TRX_DETAIL_T.TAXABLE_AMT%TYPE INDEX BY BINARY_INTEGER;
524
525 TYPE TAXABLE_AMT_FUNCL_CURR_TBL IS TABLE OF
526 ZX_REP_TRX_DETAIL_T.TAXABLE_AMT_FUNCL_CURR%TYPE INDEX BY BINARY_INTEGER;
527
528 TYPE TAXABLE_DISC_AMT_TBL IS TABLE OF
529 ZX_REP_TRX_DETAIL_T.TAXABLE_DISC_AMT%TYPE INDEX BY BINARY_INTEGER;
530
531 TYPE TAXABLE_DISC_AMT_FUN_CURR_TBL IS TABLE OF
532 ZX_REP_TRX_DETAIL_T.TAXABLE_DISC_AMT_FUNCL_CURR%TYPE INDEX BY BINARY_INTEGER;
533
534 TYPE TAX_DISC_AMT_TBL IS TABLE OF
535 ZX_REP_TRX_DETAIL_T.TAX_DISC_AMT%TYPE INDEX BY BINARY_INTEGER;
536
537 TYPE TAX_DISC_AMT_FUN_CURR_TBL IS TABLE OF
538 ZX_REP_TRX_DETAIL_T.TAX_DISC_AMT_FUNCL_CURR%TYPE INDEX BY BINARY_INTEGER;
539
540 TYPE TAX_RATE_CODE_TBL IS TABLE OF
541 ZX_REP_TRX_DETAIL_T.TAX_RATE_CODE%TYPE INDEX BY BINARY_INTEGER;
542
543 TYPE TAX_RATE_TBL IS TABLE OF
544 ZX_REP_TRX_DETAIL_T.TAX_RATE%TYPE INDEX BY BINARY_INTEGER;
545
546 TYPE TAX_RATE_VAT_TRX_TYPE_CODE_TBL IS TABLE OF
547 ZX_REP_TRX_DETAIL_T.TAX_RATE_VAT_TRX_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
548
549 TYPE TAX_RATE_VAT_TRX_TYPE_DESC_TBL IS TABLE OF
550 ZX_REP_TRX_DETAIL_T.TAX_RATE_VAT_TRX_TYPE_DESC%TYPE INDEX BY BINARY_INTEGER;
551
552 TYPE TAX_TYPE_CODE_TBL IS TABLE OF
553 ZX_REP_TRX_DETAIL_T.TAX_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
554
555 TYPE TAX_TYPE_MNG_TBL IS TABLE OF
556 ZX_REP_TRX_DETAIL_T.TAX_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
557
558 TYPE TAX_STATUS_ID_TBL IS TABLE OF
559 ZX_REP_TRX_DETAIL_T.TAX_STATUS_ID%TYPE INDEX BY BINARY_INTEGER;
560
561 TYPE TAX_RATE_CODE_NAME_TBL IS TABLE OF
562 ZX_REP_TRX_DETAIL_T.TAX_RATE_CODE_NAME%TYPE INDEX BY BINARY_INTEGER;
563
564 TYPE TAX_RATE_CODE_DESCRIPTION_TBL IS TABLE OF
565 ZX_REP_TRX_DETAIL_T.TAX_RATE_CODE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
566
567 TYPE TAX_RATE_ID_TBL IS TABLE OF
568 ZX_REP_TRX_DETAIL_T.TAX_RATE_ID%TYPE INDEX BY BINARY_INTEGER;
569
570 TYPE TAX_RATE_REG_TYPE_CODE_TBL IS TABLE OF
571 ZX_REP_TRX_DETAIL_T.TAX_RATE_REGISTER_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
572
573 TYPE DEF_REC_SETTLEMENT_OPT_CD_TBL IS TABLE OF
574 ZX_REP_TRX_DETAIL_T.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
575
576 TYPE OFFSET_TAX_RATE_CODE_TBL IS TABLE OF
577 ZX_REP_TRX_DETAIL_T.OFFSET_TAX_RATE_CODE%TYPE INDEX BY BINARY_INTEGER;
578
579 TYPE EXEMPT_CERTIFICATE_NUMBER_TBL IS TABLE OF
580 ZX_REP_TRX_DETAIL_T.EXEMPT_CERTIFICATE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
581
582 TYPE EXEMPT_REASON_CODE_TBL IS TABLE OF
583 ZX_REP_TRX_DETAIL_T.EXEMPT_REASON_CODE%TYPE INDEX BY BINARY_INTEGER;
584
585 TYPE TAX_EXCEPTION_REASON_CODE_TBL IS TABLE OF
586 ZX_REP_TRX_DETAIL_T.TAX_EXCEPTION_REASON_CODE%TYPE INDEX BY BINARY_INTEGER;
590
587
588 TYPE TAX_EXEMPTION_ID_TBL IS TABLE OF
589 ZX_REP_TRX_DETAIL_T.TAX_EXEMPTION_ID%TYPE INDEX BY BINARY_INTEGER;
591 TYPE TAX_EXCEPTION_ID_TBL IS TABLE OF
592 ZX_REP_TRX_DETAIL_T.TAX_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;
593
594 TYPE TAX_RECOVERY_RATE_TBL IS TABLE OF
595 ZX_REP_TRX_DETAIL_T.TAX_RECOVERY_RATE%TYPE INDEX BY BINARY_INTEGER;
596
597 TYPE TAX_REGIME_CODE_TBL IS TABLE OF
598 ZX_REP_TRX_DETAIL_T.TAX_REGIME_CODE%TYPE INDEX BY BINARY_INTEGER;
599
600 TYPE TAX_TBL IS TABLE OF
601 ZX_REP_TRX_DETAIL_T.TAX%TYPE INDEX BY BINARY_INTEGER;
602
603 TYPE TAX_JURISDICTION_CODE_TBL IS TABLE OF
604 ZX_REP_TRX_DETAIL_T.TAX_JURISDICTION_CODE%TYPE INDEX BY BINARY_INTEGER;
605
606 TYPE TAX_STATUS_CODE_TBL IS TABLE OF
607 ZX_REP_TRX_DETAIL_T.TAX_STATUS_CODE%TYPE INDEX BY BINARY_INTEGER;
608
609 TYPE TAX_CURRENCY_CODE_TBL IS TABLE OF
610 ZX_REP_TRX_DETAIL_T.TAX_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
611
612 TYPE EXCEPTION_RATE_TBL IS TABLE OF
613 ZX_REP_TRX_DETAIL_T.EXCEPTION_RATE%TYPE INDEX BY BINARY_INTEGER;
614
615 TYPE EXEMPT_RATE_MODIFIER_TBL IS TABLE OF
616 ZX_REP_TRX_DETAIL_T.EXEMPT_RATE_MODIFIER%TYPE INDEX BY BINARY_INTEGER;
617
618 TYPE TAX_DATE_TBL IS TABLE OF
619 ZX_REP_TRX_DETAIL_T.TAX_DATE%TYPE INDEX BY BINARY_INTEGER;
620
621 TYPE TAX_DETERMINE_DATE_TBL IS TABLE OF
622 ZX_REP_TRX_DETAIL_T.TAX_DETERMINE_DATE%TYPE INDEX BY BINARY_INTEGER;
623
624 TYPE TAX_APPORTIONMENT_LINE_NUM_TBL IS TABLE OF
625 ZX_REP_TRX_DETAIL_T.TAX_APPORTIONMENT_LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
626
627 TYPE TAX_AMT_TAX_CURR_TBL IS TABLE OF
628 ZX_REP_TRX_DETAIL_T.TAX_AMT_TAX_CURR%TYPE INDEX BY BINARY_INTEGER;
629
630 TYPE TAXABLE_AMT_TAX_CURR_TBL IS TABLE OF
631 ZX_REP_TRX_DETAIL_T.TAXABLE_AMT_TAX_CURR%TYPE INDEX BY BINARY_INTEGER;
632
633 TYPE ORIG_TAXABLE_AMT_TBL IS TABLE OF
634 ZX_REP_TRX_DETAIL_T.ORIG_TAXABLE_AMT%TYPE INDEX BY BINARY_INTEGER;
635
636 TYPE ORIG_TAXABLE_AMT_TAX_CURR_TBL IS TABLE OF
637 ZX_REP_TRX_DETAIL_T.ORIG_TAXABLE_AMT_TAX_CURR%TYPE INDEX BY BINARY_INTEGER;
638
639 TYPE ORIG_TAX_AMT_TBL IS TABLE OF
640 ZX_REP_TRX_DETAIL_T.ORIG_TAX_AMT%TYPE INDEX BY BINARY_INTEGER;
641
642 TYPE ORIG_TAX_AMT_TAX_CURR_TBL IS TABLE OF
643 ZX_REP_TRX_DETAIL_T.ORIG_TAX_AMT_TAX_CURR%TYPE INDEX BY BINARY_INTEGER;
644
645 TYPE ORIG_REC_NREC_TAX_AMT_TBL IS TABLE OF
646 ZX_REP_TRX_DETAIL_T.ORIG_REC_NREC_TAX_AMT%TYPE INDEX BY BINARY_INTEGER;
647
648 TYPE REC_TAX_AMT_TAX_CURR_TBL IS TABLE OF
649 ZX_REP_TRX_DETAIL_T.REC_TAX_AMT_TAX_CURR%TYPE INDEX BY BINARY_INTEGER;
650
651 TYPE NREC_TAX_AMT_TAX_CURR_TBL IS TABLE OF
652 ZX_REP_TRX_DETAIL_T.NREC_TAX_AMT_TAX_CURR%TYPE INDEX BY BINARY_INTEGER;
653
654 TYPE TAX_LINE_USER_CATEGORY_TBL IS TABLE OF
655 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
656
657 TYPE TAX_LINE_USER_ATTRIBUTE1_TBL IS TABLE OF
658 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
659
660 TYPE TAX_LINE_USER_ATTRIBUTE2_TBL IS TABLE OF
661 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
662
663 TYPE TAX_LINE_USER_ATTRIBUTE3_TBL IS TABLE OF
664 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
665
666 TYPE TAX_LINE_USER_ATTRIBUTE4_TBL IS TABLE OF
667 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
668
669 TYPE TAX_LINE_USER_ATTRIBUTE5_TBL IS TABLE OF
670 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
671
672 TYPE TAX_LINE_USER_ATTRIBUTE6_TBL IS TABLE OF
673 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
674
675 TYPE TAX_LINE_USER_ATTRIBUTE7_TBL IS TABLE OF
676 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
677
678 TYPE TAX_LINE_USER_ATTRIBUTE8_TBL IS TABLE OF
679 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
680
681 TYPE TAX_LINE_USER_ATTRIBUTE9_TBL IS TABLE OF
682 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
683
684 TYPE TAX_LINE_USER_ATTRIBUTE10_TBL IS TABLE OF
685 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE10%TYPE INDEX BY BINARY_INTEGER;
686
687 TYPE TAX_LINE_USER_ATTRIBUTE11_TBL IS TABLE OF
688 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE11%TYPE INDEX BY BINARY_INTEGER;
689
690 TYPE TAX_LINE_USER_ATTRIBUTE12_TBL IS TABLE OF
691 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE12%TYPE INDEX BY BINARY_INTEGER;
692
693 TYPE TAX_LINE_USER_ATTRIBUTE13_TBL IS TABLE OF
694 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE13%TYPE INDEX BY BINARY_INTEGER;
695
696 TYPE TAX_LINE_USER_ATTRIBUTE14_TBL IS TABLE OF
697 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE14%TYPE INDEX BY BINARY_INTEGER;
698
699 TYPE TAX_LINE_USER_ATTRIBUTE15_TBL IS TABLE OF
700 ZX_REP_TRX_DETAIL_T.TAX_LINE_USER_ATTRIBUTE15%TYPE INDEX BY BINARY_INTEGER;
701
702 TYPE RECOVERY_TYPE_CODE_TBL IS TABLE OF
703 ZX_REP_TRX_DETAIL_T.RECOVERY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
704
705 TYPE RECOVERY_RATE_CODE_TBL IS TABLE OF
706 ZX_REP_TRX_DETAIL_T.RECOVERY_RATE_CODE%TYPE INDEX BY BINARY_INTEGER;
707
708 TYPE BILLING_TP_NUMBER_TBL IS TABLE OF
709 ZX_REP_TRX_DETAIL_T.BILLING_TP_NUMBER%TYPE INDEX BY BINARY_INTEGER;
710
711 TYPE BILLING_TP_TAX_REG_NUM_TBL IS TABLE OF
712 ZX_REP_TRX_DETAIL_T.BILLING_TP_TAX_REG_NUM%TYPE INDEX BY BINARY_INTEGER;
716
713
714 TYPE BILLING_TP_TAXPAYER_ID_TBL IS TABLE OF
715 ZX_REP_TRX_DETAIL_T.BILLING_TP_TAXPAYER_ID%TYPE INDEX BY BINARY_INTEGER;
717 TYPE BILLING_TP_SITE_NAME_ALT_TBL IS TABLE OF
718 ZX_REP_TRX_DETAIL_T.BILLING_TP_SITE_NAME_ALT%TYPE INDEX BY BINARY_INTEGER;
719
720 TYPE BILLING_TP_NAME_TBL IS TABLE OF
721 ZX_REP_TRX_DETAIL_T.BILLING_TP_NAME%TYPE INDEX BY BINARY_INTEGER;
722
723 TYPE BILLING_TP_NAME_ALT_TBL IS TABLE OF
724 ZX_REP_TRX_DETAIL_T.BILLING_TP_NAME_ALT%TYPE INDEX BY BINARY_INTEGER;
725
726 TYPE BILLING_TP_SIC_CODE_TBL IS TABLE OF
727 ZX_REP_TRX_DETAIL_T.BILLING_TP_SIC_CODE%TYPE INDEX BY BINARY_INTEGER;
728
729 TYPE BILLING_TP_CITY_TBL IS TABLE OF
730 ZX_REP_TRX_DETAIL_T.BILLING_TP_CITY%TYPE INDEX BY BINARY_INTEGER;
731
732 TYPE BILLING_TP_COUNTY_TBL IS TABLE OF
733 ZX_REP_TRX_DETAIL_T.BILLING_TP_COUNTY%TYPE INDEX BY BINARY_INTEGER;
734
735 TYPE BILLING_TP_STATE_TBL IS TABLE OF
736 ZX_REP_TRX_DETAIL_T.BILLING_TP_STATE%TYPE INDEX BY BINARY_INTEGER;
737
738 TYPE BILLING_TP_PROVINCE_TBL IS TABLE OF
739 ZX_REP_TRX_DETAIL_T.BILLING_TP_PROVINCE%TYPE INDEX BY BINARY_INTEGER;
740
741 TYPE BILLING_TP_ADDRESS1_TBL IS TABLE OF
742 ZX_REP_TRX_DETAIL_T.BILLING_TP_ADDRESS1%TYPE INDEX BY BINARY_INTEGER;
743
744 TYPE BILLING_TP_ADDRESS2_TBL IS TABLE OF
745 ZX_REP_TRX_DETAIL_T.BILLING_TP_ADDRESS2%TYPE INDEX BY BINARY_INTEGER;
746
747 TYPE BILLING_TP_ADDRESS3_TBL IS TABLE OF
748 ZX_REP_TRX_DETAIL_T.BILLING_TP_ADDRESS3%TYPE INDEX BY BINARY_INTEGER;
749
750 TYPE BILLING_TP_ADDR_LINES_ALT_TBL IS TABLE OF
751 ZX_REP_TRX_DETAIL_T.BILLING_TP_ADDRESS_LINES_ALT%TYPE INDEX BY BINARY_INTEGER;
752
753 TYPE BILLING_TP_COUNTRY_TBL IS TABLE OF
754 ZX_REP_TRX_DETAIL_T.BILLING_TP_COUNTRY%TYPE INDEX BY BINARY_INTEGER;
755
756 TYPE BILLING_TP_POSTAL_CODE_TBL IS TABLE OF
757 ZX_REP_TRX_DETAIL_T.BILLING_TP_POSTAL_CODE%TYPE INDEX BY BINARY_INTEGER;
758
759 TYPE SHIPPING_TP_NUMBER_TBL IS TABLE OF
760 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_NUMBER%TYPE INDEX BY BINARY_INTEGER;
761
762 TYPE SHIPPING_TP_TAX_REG_NUM_TBL IS TABLE OF
763 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_TAX_REG_NUM%TYPE INDEX BY BINARY_INTEGER;
764
765 TYPE SHIPPING_TP_TAXPAYER_ID_TBL IS TABLE OF
766 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_TAXPAYER_ID%TYPE INDEX BY BINARY_INTEGER;
767
768 TYPE SHIPPING_TP_NAME_TBL IS TABLE OF
769 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_NAME%TYPE INDEX BY BINARY_INTEGER;
770
771 TYPE SHIPPING_TP_NAME_ALT_TBL IS TABLE OF
772 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_NAME_ALT%TYPE INDEX BY BINARY_INTEGER;
773
774 TYPE SHIPPING_TP_SIC_CODE_TBL IS TABLE OF
775 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_SIC_CODE%TYPE INDEX BY BINARY_INTEGER;
776
777 TYPE SHIPPING_TP_CITY_TBL IS TABLE OF
778 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_CITY%TYPE INDEX BY BINARY_INTEGER;
779
780 TYPE SHIPPING_TP_COUNTY_TBL IS TABLE OF
781 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_COUNTY%TYPE INDEX BY BINARY_INTEGER;
782
783 TYPE SHIPPING_TP_STATE_TBL IS TABLE OF
784 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_STATE%TYPE INDEX BY BINARY_INTEGER;
785
786 TYPE SHIPPING_TP_PROVINCE_TBL IS TABLE OF
787 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_PROVINCE%TYPE INDEX BY BINARY_INTEGER;
788
789 TYPE SHIPPING_TP_ADDRESS1_TBL IS TABLE OF
790 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_ADDRESS1%TYPE INDEX BY BINARY_INTEGER;
791
792 TYPE SHIPPING_TP_ADDRESS2_TBL IS TABLE OF
793 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_ADDRESS2%TYPE INDEX BY BINARY_INTEGER;
794
795 TYPE SHIPPING_TP_ADDRESS3_TBL IS TABLE OF
796 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_ADDRESS3%TYPE INDEX BY BINARY_INTEGER;
797
798 TYPE SHIPPING_TP_ADDR_LINES_ALT_TBL IS TABLE OF
799 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_ADDRESS_LINES_ALT%TYPE INDEX BY BINARY_INTEGER;
800
801 TYPE SHIPPING_TP_COUNTRY_TBL IS TABLE OF
802 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_COUNTRY%TYPE INDEX BY BINARY_INTEGER;
803
804 TYPE SHIPPING_TP_POSTAL_CODE_TBL IS TABLE OF
805 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_POSTAL_CODE%TYPE INDEX BY BINARY_INTEGER;
806
807 TYPE BILLING_TP_PARTY_NUMBER_TBL IS TABLE OF
808 ZX_REP_TRX_DETAIL_T.BILLING_TP_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
809
810 TYPE BANK_ACCOUNT_NAME_TBL IS TABLE OF
811 ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
812
813 TYPE BANK_ACCOUNT_NUM_TBL IS TABLE OF
814 ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_NUM%TYPE INDEX BY BINARY_INTEGER;
815
816 TYPE BILLING_TP_ID_TBL IS TABLE OF
817 ZX_REP_TRX_DETAIL_T.BILLING_TRADING_PARTNER_ID%TYPE INDEX BY BINARY_INTEGER;
818
819 TYPE BILLING_TP_SITE_ID_TBL IS TABLE OF
820 ZX_REP_TRX_DETAIL_T.BILLING_TP_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
821
822 TYPE BILLING_TP_ADDRESS_ID_TBL IS TABLE OF
823 ZX_REP_TRX_DETAIL_T.BILLING_TP_ADDRESS_ID%TYPE INDEX BY BINARY_INTEGER;
824
825 TYPE BILLING_TP_TAX_REP_FLAG_TBL IS TABLE OF
826 ZX_REP_TRX_DETAIL_T.BILLING_TP_TAX_REPORTING_FLAG%TYPE INDEX BY BINARY_INTEGER;
827
828 TYPE SHIPPING_TP_ID_TBL IS TABLE OF
829 ZX_REP_TRX_DETAIL_T.SHIPPING_TRADING_PARTNER_ID%TYPE INDEX BY BINARY_INTEGER;
830
831 TYPE SHIPPING_TP_SITE_ID_TBL IS TABLE OF
832 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
833
834 TYPE SHIPPING_TP_ADDRESS_ID_TBL IS TABLE OF
835 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_ADDRESS_ID%TYPE INDEX BY BINARY_INTEGER;
836
837 TYPE BANKING_TP_NAME_TBL IS TABLE OF
838 ZX_REP_TRX_DETAIL_T.BANKING_TP_NAME%TYPE INDEX BY BINARY_INTEGER;
839
843 TYPE BANK_BRANCH_ID_TBL IS TABLE OF
840 TYPE BANK_ACCOUNT_ID_TBL IS TABLE OF
841 ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
842
844 ZX_REP_TRX_DETAIL_T.BANK_BRANCH_ID%TYPE INDEX BY BINARY_INTEGER;
845
846 TYPE BANKING_TP_TAXPAYER_ID_TBL IS TABLE OF
847 ZX_REP_TRX_DETAIL_T.BANKING_TP_TAXPAYER_ID%TYPE INDEX BY BINARY_INTEGER;
848
849 TYPE BILLING_TP_SITE_NAME_TBL IS TABLE OF
850 ZX_REP_TRX_DETAIL_T.BILLING_TP_SITE_NAME%TYPE INDEX BY BINARY_INTEGER;
851
852 TYPE BILLING_TP_SITE_TX_REG_NUM_TBL IS TABLE OF
853 ZX_REP_TRX_DETAIL_T.BILLING_TP_SITE_TAX_REG_NUM%TYPE INDEX BY BINARY_INTEGER;
854
855 TYPE SHIPPING_TP_SITE_NAME_TBL IS TABLE OF
856 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_SITE_NAME%TYPE INDEX BY BINARY_INTEGER;
857
858 TYPE SHIPPING_TP_SITE_TX_RG_NUM_TBL IS TABLE OF
859 ZX_REP_TRX_DETAIL_T.SHIPPING_TP_SITE_TAX_REG_NUM%TYPE INDEX BY BINARY_INTEGER;
860
861 TYPE OFFICE_SITE_FLAG_TBL IS TABLE OF
862 ZX_REP_TRX_DETAIL_T.OFFICE_SITE_FLAG%TYPE INDEX BY BINARY_INTEGER;
863
864 TYPE SHIP_TO_LOCATION_ID_TBL IS TABLE OF
865 ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
866
867 TYPE SHIP_FROM_LOCATION_ID_TBL IS TABLE OF
868 ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
869
870 TYPE BILL_TO_LOCATION_ID_TBL IS TABLE OF
871 ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
872
873 TYPE BILL_FROM_LOCATION_ID_TBL IS TABLE OF
874 ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
875
876 TYPE SHIP_TO_PARTY_TAX_PROF_ID_TBL IS TABLE OF
877 ZX_REP_TRX_DETAIL_T.SHIP_TO_PARTY_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
878
879 TYPE SHIP_FROM_PTY_TAX_PROF_ID_TBL IS TABLE OF
880 ZX_REP_TRX_DETAIL_T.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
881
882 TYPE BILL_TO_PARTY_TAX_PROF_ID_TBL IS TABLE OF
883 ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
884
885 TYPE BILL_FROM_PTY_TAX_PROF_ID_TBL IS TABLE OF
886 ZX_REP_TRX_DETAIL_T.BILL_FROM_PARTY_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
887
888 TYPE OWN_HQ_PARTY_TAX_PROF_ID_TBL IS TABLE OF
889 ZX_REP_TRX_DETAIL_T.OWN_HQ_PARTY_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
890
891 TYPE SHIP_TO_SITE_TAX_PROF_ID_TBL IS TABLE OF
892 ZX_REP_TRX_DETAIL_T.SHIP_TO_SITE_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
893
894 TYPE BILL_TO_SITE_TAX_PROF_ID_TBL IS TABLE OF
895 ZX_REP_TRX_DETAIL_T.BILL_TO_SITE_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
896
897 TYPE SHIP_FROM_SITE_TAX_PROF_ID_TBL IS TABLE OF
898 ZX_REP_TRX_DETAIL_T.SHIP_FROM_SITE_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
899
900 TYPE BILL_FROM_SITE_TAX_PROF_ID_TBL IS TABLE OF
901 ZX_REP_TRX_DETAIL_T.BILL_FROM_SITE_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
902
903 TYPE OWN_HQ_PARTY_SITE_PROF_ID_TBL IS TABLE OF
904 ZX_REP_TRX_DETAIL_T.OWN_HQ_PARTY_SITE_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
905
906 TYPE SHIP_TO_PARTY_ID_TBL IS TABLE OF
907 ZX_REP_TRX_DETAIL_T.SHIP_TO_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
908
909 TYPE SHIP_FROM_PARTY_ID_TBL IS TABLE OF
910 ZX_REP_TRX_DETAIL_T.SHIP_FROM_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
911
912 TYPE BILL_TO_PARTY_ID_TBL IS TABLE OF
913 ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
914
915 TYPE BILL_FROM_PARTY_ID_TBL IS TABLE OF
916 ZX_REP_TRX_DETAIL_T.BILL_FROM_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
917
918 TYPE OWN_HQ_PARTY_ID_TBL IS TABLE OF
919 ZX_REP_TRX_DETAIL_T.OWN_HQ_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
920
921 TYPE SHIP_TO_PARTY_SITE_ID_TBL IS TABLE OF
922 ZX_REP_TRX_DETAIL_T.SHIP_TO_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
923
924 TYPE SHIP_FROM_PARTY_SITE_ID_TBL IS TABLE OF
925 ZX_REP_TRX_DETAIL_T.SHIP_FROM_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
926
927 TYPE BILL_TO_PARTY_SITE_ID_TBL IS TABLE OF
928 ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
929
930 TYPE BILL_FROM_PARTY_SITE_ID_TBL IS TABLE OF
931 ZX_REP_TRX_DETAIL_T.BILL_FROM_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
932
933 TYPE REGISTRATION_STATUS_CODE_TBL IS TABLE OF
934 ZX_REP_TRX_DETAIL_T.REGISTRATION_STATUS_CODE%TYPE INDEX BY BINARY_INTEGER;
935
936 --TYPE REGISTRATION_NUMBER_TBL IS TABLE OF
937 -- ZX_REP_TRX_DETAIL_T.REGISTRATION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
938
939 --TYPE REPORTING_TYPE_CODE_TBL IS TABLE OF
940 -- ZX_REP_TRX_DETAIL_T.REPORTING_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
941
942 TYPE REG_PARTY_TAX_PROF_ID_TBL IS TABLE OF
943 ZX_REP_TRX_DETAIL_T.REG_PARTY_TAX_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
944
945 TYPE REG_PARTY_TAX_SITE_PROF_ID_TBL IS TABLE OF
946 ZX_REP_TRX_DETAIL_T.REG_PARTY_TAX_SITE_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
947
948 TYPE POS_TAX_PARTY_PROF_ID_TBL IS TABLE OF
949 ZX_REP_TRX_DETAIL_T.POS_TAX_PARTY_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
950
951 TYPE POS_TAX_PARTY_SITE_PROF_ID_TBL IS TABLE OF
952 ZX_REP_TRX_DETAIL_T.POS_TAX_PARTY_SITE_PROF_ID%TYPE INDEX BY BINARY_INTEGER;
953
954 TYPE LEGAL_ENTITY_TAX_REG_NUM_TBL IS TABLE OF
955 ZX_REP_TRX_DETAIL_T.LEGAL_ENTITY_TAX_REG_NUMBER%TYPE INDEX BY BINARY_INTEGER;
956
957 TYPE HQ_ESTB_REG_NUMBER_TBL IS TABLE OF
958 ZX_REP_TRX_DETAIL_T.HQ_ESTB_REG_NUMBER%TYPE INDEX BY BINARY_INTEGER;
959
960 TYPE TAX_LINE_REGISTRATION_NUM_TBL IS TABLE OF
961 ZX_REP_TRX_DETAIL_T.TAX_LINE_REGISTRATION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
962
966 --TYPE BALANCING_SEGMENT_VALUE_TBL IS TABLE OF
963 TYPE REGISTRATION_PARTY_TYPE_TBL IS TABLE OF
964 ZX_REP_TRX_DETAIL_T.REGISTRATION_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
965
967 -- ZX_REP_TRX_DETAIL_T.BALANCING_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
968
969 --TYPE BALANCING_SEGMENT_DESC_TBL IS TABLE OF
970 -- ZX_REP_TRX_DETAIL_T.BALANCING_SEGMENT_DESC%TYPE INDEX BY BINARY_INTEGER;
971
972 TYPE CANCELLED_DATE_TBL IS TABLE OF
973 ZX_REP_TRX_DETAIL_T.CANCELLED_DATE%TYPE INDEX BY BINARY_INTEGER;
974
975 TYPE HISTORICAL_FLAG_TBL IS TABLE OF
976 ZX_REP_TRX_DETAIL_T.HISTORICAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
977
978 TYPE CANCEL_FLAG_TBL IS TABLE OF
979 ZX_REP_TRX_DETAIL_T.CANCEL_FLAG%TYPE INDEX BY BINARY_INTEGER;
980
981 TYPE SELF_ASSESSED_FLAG_TBL IS TABLE OF
982 ZX_REP_TRX_DETAIL_T.SELF_ASSESSED_FLAG%TYPE INDEX BY BINARY_INTEGER;
983
984 TYPE REPORTING_ONLY_FLAG_TBL IS TABLE OF
985 ZX_REP_TRX_DETAIL_T.REPORTING_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER;
986
987 TYPE TAX_ONLY_FLAG_TBL IS TABLE OF
988 ZX_REP_TRX_DETAIL_T.TAX_ONLY_FLAG%TYPE INDEX BY BINARY_INTEGER;
989
990 TYPE OFFSET_FLAG_TBL IS TABLE OF
991 ZX_REP_TRX_DETAIL_T.OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
992
993 TYPE POSTED_FLAG_TBL IS TABLE OF
994 ZX_REP_TRX_DETAIL_T.POSTED_FLAG%TYPE INDEX BY BINARY_INTEGER;
995
996 TYPE MRC_TAX_LINE_FLAG_TBL IS TABLE OF
997 ZX_REP_TRX_DETAIL_T.MRC_TAX_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
998
999 TYPE SMALL_BUSINESS_FLAG_TBL IS TABLE OF
1000 ZX_REP_TRX_DETAIL_T.SMALL_BUSINESS_FLAG%TYPE INDEX BY BINARY_INTEGER;
1001
1002
1003 TYPE RECONCILIATION_FLAG_TBL IS TABLE OF
1004 ZX_REP_TRX_DETAIL_T.RECONCILIATION_FLAG%TYPE INDEX BY BINARY_INTEGER;
1005
1006
1007 TYPE TAX_RECOVERABLE_FLAG_TBL IS TABLE OF
1008 ZX_REP_TRX_DETAIL_T.TAX_RECOVERABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1009
1010
1011 TYPE REVERSE_FLAG_TBL IS TABLE OF
1012 ZX_REP_TRX_DETAIL_T.REVERSE_FLAG%TYPE INDEX BY BINARY_INTEGER;
1013
1014 TYPE AR_CASH_RECEIPT_REV_STAT_TBL IS TABLE OF
1015 ZX_REP_TRX_DETAIL_T.AR_CASH_RECEIPT_REVERSE_STATUS%TYPE INDEX BY BINARY_INTEGER;
1016
1017 TYPE AR_CASH_RECEIPT_REV_DATE_TBL IS TABLE OF
1018 ZX_REP_TRX_DETAIL_T.AR_CASH_RECEIPT_REVERSE_DATE%TYPE INDEX BY BINARY_INTEGER;
1019
1020 TYPE TAXABLE_ITEM_SOURCE_ID_TBL IS TABLE OF
1021 ZX_REP_TRX_DETAIL_T.TAXABLE_ITEM_SOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1022
1023
1024 TYPE BR_REF_CUSTOMER_TRX_ID_TBL IS TABLE OF
1025 ZX_REP_TRX_DETAIL_T.BR_REF_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
1026
1027 TYPE AMOUNT_APPLIED_TBL IS TABLE OF
1028 ZX_REP_TRX_DETAIL_T.AMOUNT_APPLIED%TYPE INDEX BY BINARY_INTEGER;
1029
1030
1031 TYPE TAX_AMT_INCLUDED_FLAG_TBL IS TABLE OF
1032 ZX_REP_TRX_DETAIL_T.TAX_AMT_INCLUDED_FLAG%TYPE INDEX BY BINARY_INTEGER;
1033
1034 TYPE BILLING_TRADING_PARTNER_ID_TBL IS TABLE OF
1035 ZX_REP_TRX_DETAIL_T.BILLING_TRADING_PARTNER_ID%TYPE INDEX BY BINARY_INTEGER;
1036
1037 TYPE GDF_PARTY_SITES_BILL_ATT8_TBL IS TABLE OF
1038 ZX_REP_TRX_DETAIL_T.GDF_PARTY_SITES_BILL_ATT8%TYPE INDEX BY BINARY_INTEGER;
1039
1040
1041 TYPE GDF_RA_CUST_BILL_ATT10_TBL IS TABLE OF
1042 ZX_REP_TRX_DETAIL_T.GDF_RA_CUST_BILL_ATT10%TYPE INDEX BY BINARY_INTEGER;
1043
1044 TYPE GDF_RA_CUST_BILL_ATT12_TBL IS TABLE OF
1045 ZX_REP_TRX_DETAIL_T.GDF_RA_CUST_BILL_ATT12%TYPE INDEX BY BINARY_INTEGER;
1046
1047 TYPE GDF_RA_ADDRESSES_BILL_ATT8_TBL IS TABLE OF
1048 ZX_REP_TRX_DETAIL_T.GDF_RA_ADDRESSES_BILL_ATT8%TYPE INDEX BY BINARY_INTEGER;
1049
1050 TYPE GDF_RA_ADDRESSES_BILL_ATT9_TBL IS TABLE OF
1051 ZX_REP_TRX_DETAIL_T.GDF_RA_ADDRESSES_BILL_ATT9%TYPE INDEX BY BINARY_INTEGER;
1052
1053 TYPE GDF_PARTY_SITES_SHIP_ATT8_TBL IS TABLE OF
1054 ZX_REP_TRX_DETAIL_T.GDF_PARTY_SITES_SHIP_ATT8%TYPE INDEX BY BINARY_INTEGER;
1055
1056
1057 TYPE GDF_RA_CUST_SHIP_ATT10_TBL IS TABLE OF
1058 ZX_REP_TRX_DETAIL_T.GDF_RA_CUST_SHIP_ATT10%TYPE INDEX BY BINARY_INTEGER;
1059
1060 TYPE GDF_RA_CUST_SHIP_ATT12_TBL IS TABLE OF
1061 ZX_REP_TRX_DETAIL_T.GDF_RA_CUST_SHIP_ATT12%TYPE INDEX BY BINARY_INTEGER;
1062
1063 TYPE GDF_RA_ADDRESSES_SHIP_ATT8_TBL IS TABLE OF
1064 ZX_REP_TRX_DETAIL_T.GDF_RA_ADDRESSES_SHIP_ATT8%TYPE INDEX BY BINARY_INTEGER;
1065
1066 TYPE GDF_RA_ADDRESSES_SHIP_ATT9_TBL IS TABLE OF
1067 ZX_REP_TRX_DETAIL_T.GDF_RA_ADDRESSES_SHIP_ATT9%TYPE INDEX BY BINARY_INTEGER;
1068
1069 TYPE GDF_PO_VENDOR_SITE_ATT17_TBL IS TABLE OF
1070 ZX_REP_TRX_DETAIL_T.GDF_PO_VENDOR_SITE_ATT17%TYPE INDEX BY BINARY_INTEGER;
1071
1072 TYPE EVENT_CLASS_MAPPING_ID_TBL IS TABLE OF
1073 ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;
1074
1075 TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
1076 ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
1077
1078 TYPE PLACE_OF_SUPPLY_TYPE_CODE_TBL IS TABLE OF
1079 ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1080
1081 TYPE POA_LOCATION_ID_TBL IS TABLE OF
1082 ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1083
1084 TYPE POO_LOCATION_ID_TBL IS TABLE OF
1085 ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
1086
1087 TYPE DEF_PLACE_OF_SUP_TYPE_CODE_TBL IS TABLE OF
1088 ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1089
1090 TYPE TAX_PROVIDER_ID_TBL IS TABLE OF
1094 ZX_REP_TRX_DETAIL_T.AR_CASH_RECEIPT_REVERSE_DATE%TYPE INDEX BY BINARY_INTEGER;
1091 ZX_REP_TRX_DETAIL_T.TAX_PROVIDER_ID%TYPE INDEX BY BINARY_INTEGER;
1092
1093 TYPE AR_CASH_RCPT_RVRS_DATE_TBL IS TABLE OF
1095
1096 TYPE AR_CASH_RCPT_RVRS_STATUS_TBL IS TABLE OF
1097 ZX_REP_TRX_DETAIL_T.AR_CASH_RECEIPT_REVERSE_STATUS%TYPE INDEX BY BINARY_INTEGER;
1098
1099 TYPE ACCTD_AMOUNT_CR_TBL IS TABLE OF
1100 ZX_REP_TRX_DETAIL_T.ACCTD_AMOUNT_CR%TYPE INDEX BY BINARY_INTEGER;
1101
1102 TYPE ACCTD_AMOUNT_DR_TBL IS TABLE OF
1103 ZX_REP_TRX_DETAIL_T.ACCTD_AMOUNT_DR%TYPE INDEX BY BINARY_INTEGER;
1104
1105 TYPE REC_APPLICATION_STATUS_TBL IS TABLE OF
1106 ZX_REP_TRX_DETAIL_T.REC_APPLICATION_STATUS%TYPE INDEX BY BINARY_INTEGER;
1107
1108 TYPE SUB_LEDGER_INV_IDENTIFIER_TBL IS TABLE OF
1109 ZX_REP_TRX_DETAIL_T.SUB_LEDGER_INVOICE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
1110
1111 TYPE ACCOUNT_CLASS_TBL IS TABLE OF
1112 ZX_REP_TRX_DETAIL_T.ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
1113
1114 TYPE LATEST_REC_FLAG_TBL IS TABLE OF
1115 ZX_REP_TRX_DETAIL_T.LATEST_REC_FLAG%TYPE INDEX BY BINARY_INTEGER;
1116
1117 TYPE ENTITY_CODE_TBL IS TABLE OF
1118 ZX_REP_TRX_DETAIL_T.ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
1119
1120 TYPE GL_DATE_TBL IS TABLE OF
1121 ZX_REP_TRX_DETAIL_T.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
1122
1123 TYPE UNIT_PRICE_TBL IS TABLE OF
1124 ZX_REP_TRX_DETAIL_T.UNIT_PRICE%TYPE INDEX BY BINARY_INTEGER;
1125
1126 --
1127 -- Table type varibale declaration for accounting table ZX_REP_ACTG_EXT_T
1128 --
1129
1130 TYPE ACTG_EXT_LINE_ID_TBL IS TABLE OF
1131 ZX_REP_ACTG_EXT_T. ACTG_EXT_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1132
1133 --TYPE DETAIL_TAX_LINE_ID_TBL IS TABLE OF
1134 -- ZX_REP_ACTG_EXT_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
1135
1136 TYPE ACTG_EVENT_TYPE_CODE_TBL IS TABLE OF
1137 ZX_REP_ACTG_EXT_T.ACTG_EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1138
1139 TYPE ACTG_EVENT_TYPE_MNG_TBL IS TABLE OF
1140 ZX_REP_ACTG_EXT_T.ACTG_EVENT_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
1141
1142 TYPE ACTG_EVENT_NUMBER_TBL IS TABLE OF
1143 ZX_REP_ACTG_EXT_T.ACTG_EVENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1144
1145 TYPE ACTG_EVENT_STATUS_FLAG_TBL IS TABLE OF
1146 ZX_REP_ACTG_EXT_T.ACTG_EVENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
1147
1148 TYPE ACTG_EVENT_STATUS_MNG_TBL IS TABLE OF
1149 ZX_REP_ACTG_EXT_T.ACTG_EVENT_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
1150
1151 TYPE ACTG_CATEGORY_CODE_TBL IS TABLE OF
1152 ZX_REP_ACTG_EXT_T.ACTG_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
1153
1154 TYPE ACTG_CATEGORY_MNG_TBL IS TABLE OF
1155 ZX_REP_ACTG_EXT_T.ACTG_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
1156
1157 TYPE ACCOUNTING_DATE_TBL IS TABLE OF
1158 ZX_REP_ACTG_EXT_T.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1159
1160 TYPE GL_TRANSFER_FLAG_TBL IS TABLE OF
1161 ZX_REP_ACTG_EXT_T.GL_TRANSFER_FLAG%TYPE INDEX BY BINARY_INTEGER;
1162
1163 TYPE GL_TRANSFER_RUN_ID_TBL IS TABLE OF
1164 ZX_REP_ACTG_EXT_T.GL_TRANSFER_RUN_ID%TYPE INDEX BY BINARY_INTEGER;
1165
1166 TYPE ACTG_HEADER_DESCRIPTION_TBL IS TABLE OF
1167 ZX_REP_ACTG_EXT_T.ACTG_HEADER_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
1168
1169 TYPE ACTG_LINE_NUM_TBL IS TABLE OF
1170 ZX_REP_ACTG_EXT_T.ACTG_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
1171
1172 TYPE ACTG_LINE_TYPE_CODE_TBL IS TABLE OF
1173 ZX_REP_ACTG_EXT_T.ACTG_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1174
1175 TYPE ACTG_LINE_TYPE_MNG_TBL IS TABLE OF
1176 ZX_REP_ACTG_EXT_T.ACTG_LINE_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
1177
1178 TYPE ACTG_LINE_DESCRIPTION_TBL IS TABLE OF
1179 ZX_REP_ACTG_EXT_T.ACTG_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
1180
1184 TYPE ACTG_ERROR_CODE_TBL IS TABLE OF
1181 TYPE ACTG_STAT_AMT_TBL IS TABLE OF
1182 ZX_REP_ACTG_EXT_T.ACTG_STAT_AMT%TYPE INDEX BY BINARY_INTEGER;
1183
1185 ZX_REP_ACTG_EXT_T.ACTG_ERROR_CODE%TYPE INDEX BY BINARY_INTEGER;
1186
1187 TYPE GL_TRANSFER_CODE_TBL IS TABLE OF
1188 ZX_REP_ACTG_EXT_T.GL_TRANSFER_CODE%TYPE INDEX BY BINARY_INTEGER;
1189
1190 TYPE ACTG_DOC_SEQUENCE_ID_TBL IS TABLE OF
1191 ZX_REP_ACTG_EXT_T.ACTG_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
1192
1193 TYPE ACTG_DOC_SEQUENCE_NAME_TBL IS TABLE OF
1194 ZX_REP_ACTG_EXT_T.ACTG_DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
1195
1196 TYPE ACTG_DOC_SEQUENCE_VALUE_TBL IS TABLE OF
1197 ZX_REP_ACTG_EXT_T.ACTG_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
1198
1199 TYPE ACTG_PARTY_ID_TBL IS TABLE OF
1200 ZX_REP_ACTG_EXT_T.ACTG_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
1201
1202 TYPE ACTG_PARTY_SITE_ID_TBL IS TABLE OF
1203 ZX_REP_ACTG_EXT_T.ACTG_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
1204
1205 TYPE ACTG_PARTY_TYPE_TBL IS TABLE OF
1206 ZX_REP_ACTG_EXT_T.ACTG_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
1207
1208 TYPE ACTG_EVENT_ID_TBL IS TABLE OF
1209 ZX_REP_ACTG_EXT_T.ACTG_EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
1210
1211 TYPE ACTG_HEADER_ID_TBL IS TABLE OF
1212 ZX_REP_ACTG_EXT_T.ACTG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1213
1214 TYPE ACTG_SOURCE_ID_TBL IS TABLE OF
1215 ZX_REP_ACTG_EXT_T.ACTG_SOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
1216
1217 TYPE ACTG_SOURCE_TABLE_TBL IS TABLE OF
1218 ZX_REP_ACTG_EXT_T.ACTG_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
1219
1220 TYPE ACTG_LINE_CCID_TBL IS TABLE OF
1221 ZX_REP_ACTG_EXT_T.ACTG_LINE_CCID%TYPE INDEX BY BINARY_INTEGER;
1222
1223 TYPE ACCOUNT_FLEXFIELD_TBL IS TABLE OF
1224 ZX_REP_ACTG_EXT_T.ACCOUNT_FLEXFIELD%TYPE INDEX BY BINARY_INTEGER;
1225
1226 TYPE ACCOUNT_DESCRIPTION_TBL IS TABLE OF
1227 ZX_REP_ACTG_EXT_T.ACCOUNT_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
1228
1229 TYPE PERIOD_NAME_TBL IS TABLE OF
1230 ZX_REP_ACTG_EXT_T.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
1231
1232 TYPE BALANCING_SEGMENT_VALUE_TBL IS TABLE OF
1233 ZX_REP_ACTG_EXT_T.BALANCING_SEGMENT_VALUE%TYPE INDEX BY BINARY_INTEGER;
1234
1235 TYPE TRX_ARAP_BALANCING_SEG_TBL IS TABLE OF
1236 ZX_REP_ACTG_EXT_T.TRX_ARAP_BALANCING_SEGMENT%TYPE INDEX BY BINARY_INTEGER;
1237
1238 TYPE TRX_ARAP_NATURAL_ACCOUNT_TBL IS TABLE OF
1239 ZX_REP_ACTG_EXT_T.TRX_ARAP_NATURAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
1240
1241 TYPE TRX_TAXABLE_BALANCING_SEG_TBL IS TABLE OF
1242 ZX_REP_ACTG_EXT_T.TRX_TAXABLE_BALANCING_SEGMENT%TYPE INDEX BY BINARY_INTEGER;
1243
1244 TYPE TRX_TAXABLE_BALSEG_DESC_TBL IS TABLE OF
1245 ZX_REP_ACTG_EXT_T.TRX_TAXABLE_BALSEG_DESC%TYPE INDEX BY BINARY_INTEGER;
1246
1247 TYPE TRX_TAXABLE_NATURAL_ACCT_TBL IS TABLE OF
1248 ZX_REP_ACTG_EXT_T.TRX_TAXABLE_NATURAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
1249
1250 TYPE TRX_TAX_BALANCING_SEG_TBL IS TABLE OF
1251 ZX_REP_ACTG_EXT_T.TRX_TAX_BALANCING_SEGMENT%TYPE INDEX BY BINARY_INTEGER;
1252
1253 TYPE TRX_TAX_NATURAL_ACCOUNT_TBL IS TABLE OF
1254 ZX_REP_ACTG_EXT_T.TRX_TAX_NATURAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
1255
1256 TYPE TRX_CONTROL_ACCT_FLEXFLD_TBL IS TABLE OF
1257 ZX_REP_ACTG_EXT_T.TRX_CONTROL_ACCOUNT_FLEXFIELD%TYPE INDEX BY BINARY_INTEGER;
1258
1259 TYPE POSTED_DATE_TBL IS TABLE OF
1260 ZX_REP_TRX_DETAIL_T.POSTED_DATE%TYPE INDEX BY BINARY_INTEGER;
1261
1262 TYPE CREATED_BY_TBL IS TABLE OF
1263 ZX_REP_ACTG_EXT_T.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
1264
1265 TYPE CREATION_DATE_TBL IS TABLE OF
1266 ZX_REP_ACTG_EXT_T.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
1267
1268 TYPE LAST_UPDATED_BY_TBL IS TABLE OF
1269 ZX_REP_ACTG_EXT_T.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
1270
1271 TYPE LAST_UPDATE_DATE_TBL IS TABLE OF
1272 ZX_REP_ACTG_EXT_T.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
1273
1274 TYPE LAST_UPDATE_LOGIN_TBL IS TABLE OF
1275 ZX_REP_ACTG_EXT_T.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
1276
1277 --TYPE REQUEST_ID_TBL IS TABLE OF
1278 -- ZX_REP_ACTG_EXT_T.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
1279
1280 TYPE PROGRAM_APPLICATION_ID_TBL IS TABLE OF
1281 ZX_REP_ACTG_EXT_T.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
1282
1283 TYPE PROGRAM_ID_TBL IS TABLE OF
1284 ZX_REP_ACTG_EXT_T.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
1285
1286 TYPE PROGRAM_LOGIN_ID_TBL IS TABLE OF
1287 ZX_REP_ACTG_EXT_T.PROGRAM_LOGIN_ID%TYPE INDEX BY BINARY_INTEGER;
1288
1289
1290
1291 TYPE rep_context_id_rectype IS RECORD(
1292 REP_CONTEXT_ID NUMBER,
1293 LEGAL_ENTITY_ID NUMBER,
1294 INTERNAL_ORGANIZATION_ID NUMBER);
1295
1296 type rep_context_id_tabtype is table of rep_context_id_rectype
1297 index by binary_integer;
1298
1299 rep_context_id_tab rep_context_id_tabtype;
1300
1301 --New Extract Declaration End -- Skorrapa
1302
1303
1304 PROCEDURE populate_tax_data (
1305 P_REPORTING_LEVEL IN VARCHAR2 DEFAULT NULL,
1306 P_REPORTING_CONTEXT IN VARCHAR2 DEFAULT NULL,
1307 -- apai P_LEGAL_ENTITY_LEVEL IN VARCHAR2 DEFAULT NULL,
1308 P_LEGAL_ENTITY_ID IN NUMBER DEFAULT NULL, -- apai COMPANY_NAME
1312 P_PRODUCT IN VARCHAR2 DEFAULT NULL,
1309 P_SUMMARY_LEVEL IN VARCHAR2 DEFAULT NULL,
1310 P_LEDGER_ID IN NUMBER DEFAULT NULL,
1311 P_REGISTER_TYPE IN VARCHAR2 DEFAULT NULL,
1313 P_MATRIX_REPORT IN VARCHAR2 DEFAULT NULL,
1314 P_DETAIL_LEVEL IN VARCHAR2 DEFAULT NULL,
1315 P_CURRENCY_CODE_LOW IN VARCHAR2 DEFAULT NULL,
1316 P_CURRENCY_CODE_HIGH IN VARCHAR2 DEFAULT NULL,
1317 P_INCLUDE_AP_STD_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1318 P_INCLUDE_AP_DM_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1319 P_INCLUDE_AP_CM_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1320 P_INCLUDE_AP_PREP_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1321 P_INCLUDE_AP_MIX_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1322 P_INCLUDE_AP_EXP_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1323 P_INCLUDE_AP_INT_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1324 P_INCLUDE_AR_INV_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1325 P_INCLUDE_AR_APPL_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1326 P_INCLUDE_AR_ADJ_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1327 P_INCLUDE_AR_MISC_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1328 P_INCLUDE_AR_BR_TRX_CLASS IN VARCHAR2 DEFAULT NULL,
1329 P_INCLUDE_GL_MANUAL_LINES IN VARCHAR2 DEFAULT NULL,
1330 P_THIRD_PARTY_REP_LEVEL IN VARCHAR2 DEFAULT NULL,
1331 P_FIRST_PARTY_TAX_REG_NUM IN VARCHAR2 DEFAULT NULL,
1332 P_TRX_NUMBER_LOW IN VARCHAR2 DEFAULT NULL,
1333 P_TRX_NUMBER_HIGH IN VARCHAR2 DEFAULT NULL,
1334 P_EXTRACT_REPORT_LINE_NUMBER IN NUMBER DEFAULT 1,
1335 P_AR_TRX_PRINTING_STATUS IN VARCHAR2 DEFAULT NULL,
1336 P_AR_EXEMPTION_STATUS IN VARCHAR2 DEFAULT NULL,
1337 P_GL_DATE_LOW IN DATE DEFAULT NULL,
1338 P_GL_DATE_HIGH IN DATE DEFAULT NULL,
1339 P_TRX_DATE_LOW IN DATE DEFAULT NULL,
1340 P_TRX_DATE_HIGH IN DATE DEFAULT NULL,
1341 P_GL_PERIOD_NAME_LOW IN VARCHAR2 DEFAULT NULL,
1342 P_GL_PERIOD_NAME_HIGH IN VARCHAR2 DEFAULT NULL,
1343 P_TRX_DATE_PERIOD_NAME_LOW IN VARCHAR2 DEFAULT NULL,
1344 P_TRX_DATE_PERIOD_NAME_HIGH IN VARCHAR2 DEFAULT NULL,
1345 P_TAX_JURISDICTION_CODE IN VARCHAR DEFAULT NULL,
1346 P_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL,
1347 P_TAX IN VARCHAR2 DEFAULT NULL,
1348 P_TAX_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
1349 P_TAX_RATE_CODE_LOW IN VARCHAR2 DEFAULT NULL,
1350 P_TAX_RATE_CODE_HIGH IN VARCHAR2 DEFAULT NULL,
1351 P_TAX_TYPE_CODE_LOW IN VARCHAR2 DEFAULT NULL,
1352 P_TAX_TYPE_CODE_HIGH IN VARCHAR2 DEFAULT NULL,
1353 P_DOCUMENT_SUB_TYPE IN VARCHAR2 DEFAULT NULL,
1354 P_TRX_BUSINESS_CATEGORY IN VARCHAR2 DEFAULT NULL,
1355 P_TAX_INVOICE_DATE_LOW IN VARCHAR2 DEFAULT NULL,
1356 P_TAX_INVOICE_DATE_HIGH IN VARCHAR2 DEFAULT NULL,
1357 P_POSTING_STATUS IN VARCHAR2 DEFAULT NULL,
1358 P_EXTRACT_ACCTED_TAX_LINES IN VARCHAR2 DEFAULT NULL,
1359 P_INCLUDE_ACCOUNTING_SEGMENTS IN VARCHAR2 DEFAULT NULL,
1360 P_BALANCING_SEGMENT_LOW IN VARCHAR2 DEFAULT NULL,
1361 P_BALANCING_SEGMENT_HIGH IN VARCHAR2 DEFAULT NULL,
1362 P_INCLUDE_DISCOUNTS IN VARCHAR2 DEFAULT NULL,
1363 P_EXTRACT_STARTING_LINE_NUM IN NUMBER DEFAULT NULL,
1364 P_REQUEST_ID IN NUMBER DEFAULT NULL,
1365 P_REPORT_NAME IN VARCHAR2 DEFAULT NULL,
1366 P_VAT_TRANSACTION_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
1367 P_INCLUDE_FULLY_NR_TAX_FLAG IN VARCHAR2 DEFAULT NULL,
1368 P_MUNICIPAL_TAX_TYPE_CODE_LOW IN VARCHAR2 DEFAULT NULL,
1369 P_MUNICIPAL_TAX_TYPE_CODE_HIGH IN VARCHAR2 DEFAULT NULL,
1370 P_PROV_TAX_TYPE_CODE_LOW IN VARCHAR2 DEFAULT NULL,
1371 P_PROV_TAX_TYPE_CODE_HIGH IN VARCHAR2 DEFAULT NULL,
1372 P_EXCISE_TAX_TYPE_CODE_LOW IN VARCHAR2 DEFAULT NULL,
1373 P_EXCISE_TAX_TYPE_CODE_HIGH IN VARCHAR2 DEFAULT NULL,
1374 P_NON_TAXABLE_TAX_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
1375 P_PER_TAX_TYPE_CODE_LOW IN VARCHAR2 DEFAULT NULL,
1376 P_PER_TAX_TYPE_CODE_HIGH IN VARCHAR2 DEFAULT NULL,
1377 P_FED_PER_TAX_TYPE_CODE_LOW IN VARCHAR2 DEFAULT NULL,
1378 P_FED_PER_TAX_TYPE_CODE_HIGH IN VARCHAR2 DEFAULT NULL,
1379 P_VAT_TAX_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
1380 P_EXCISE_TAX IN VARCHAR2 DEFAULT NULL,
1381 P_VAT_ADDITIONAL_TAX IN VARCHAR2 DEFAULT NULL,
1382 P_VAT_NON_TAXABLE_TAX IN VARCHAR2 DEFAULT NULL,
1383 P_VAT_NOT_TAX IN VARCHAR2 DEFAULT NULL,
1384 P_VAT_PERCEPTION_TAX IN VARCHAR2 DEFAULT NULL,
1385 P_VAT_TAX IN VARCHAR2 DEFAULT NULL,
1386 P_INC_SELF_WD_TAX IN VARCHAR2 DEFAULT NULL,
1387 P_EXCLUDING_TRX_LETTER IN VARCHAR2 DEFAULT NULL,
1388 P_TRX_LETTER_LOW IN VARCHAR2 DEFAULT NULL,
1389 P_TRX_LETTER_HIGH IN VARCHAR2 DEFAULT NULL,
1390 P_INCLUDE_REFERENCED_SOURCE IN VARCHAR2 DEFAULT NULL,
1391 P_PARTY_NAME IN VARCHAR2 DEFAULT NULL,
1392 P_BATCH_NAME IN VARCHAR2 DEFAULT NULL,
1393 P_BATCH_DATE_LOW IN DATE DEFAULT NULL,
1394 P_BATCH_DATE_HIGH IN DATE DEFAULT NULL,
1395 P_BATCH_SOURCE_ID IN VARCHAR2 DEFAULT NULL,
1396 P_ADJUSTED_DOC_FROM IN VARCHAR2 DEFAULT NULL,
1397 P_ADJUSTED_DOC_TO IN VARCHAR2 DEFAULT NULL,
1398 P_STANDARD_VAT_TAX_RATE IN VARCHAR2 DEFAULT NULL,
1399 P_MUNICIPAL_TAX IN VARCHAR2 DEFAULT NULL,
1400 P_PROVINCIAL_TAX IN VARCHAR2 DEFAULT NULL,
1401 P_TAX_ACCOUNT_LOW IN VARCHAR2 DEFAULT NULL,
1402 P_TAX_ACCOUNT_HIGH IN VARCHAR2 DEFAULT NULL,
1403 P_EXP_CERT_DATE_FROM IN DATE DEFAULT NULL,
1404 P_EXP_CERT_DATE_TO IN DATE DEFAULT NULL,
1405 P_EXP_METHOD IN VARCHAR2 DEFAULT NULL,
1406 P_PRINT_COMPANY_INFO IN VARCHAR2 DEFAULT NULL,
1407 P_ORDER_BY IN VARCHAR2 DEFAULT NULL,
1408 P_CHART_OF_ACCOUNTS_ID IN NUMBER DEFAULT NULL,
1409 P_REPRINT IN VARCHAR2 DEFAULT NULL,
1410 P_ERRBUF IN OUT NOCOPY VARCHAR2 ,
1411 P_RETCODE IN OUT NOCOPY VARCHAR2 ,
1412 P_ACCOUNTING_STATUS IN VARCHAR2 DEFAULT NULL,
1413 P_REPORTED_STATUS IN VARCHAR2 DEFAULT NULL,
1414 P_TAXABLE_ACCOUNT_LOW IN VARCHAR2 DEFAULT NULL,
1415 P_TAXABLE_ACCOUNT_HIGH IN VARCHAR2 DEFAULT NULL,
1416 P_GL_OR_TRX_DATE_FILTER IN VARCHAR2 DEFAULT 'N'); --Bug 5396444
1417
1418 --procedure build_matrix_tbl( p_sql in varchar2);
1419
1420 procedure set_retcode(p_retcode in number);
1421
1422 procedure append_errbuf(p_msg in varchar2);
1423
1424 procedure purge(p_request_id in number,
1425 p_rows_deleted out NOCOPY number);
1426
1427 procedure purge(p_request_id in number);
1428
1429 --EMEA : Changes for EMEA/Updation of Legal_Reporting_Status on the zx_lines
1430
1431 PROCEDURE zx_upd_legal_reporting_status(
1432 p_api_version IN NUMBER,
1433 p_init_msg_list IN VARCHAR2,
1434 p_commit IN VARCHAR2,
1435 p_validation_level IN VARCHAR2,
1436 p_application_id_tbl IN application_id_tbl,
1437 p_entity_code_tbl IN entity_code_tbl,
1438 p_event_class_code_tbl IN event_class_code_tbl,
1439 p_trx_id_tbl IN trx_id_tbl,
1440 p_trx_line_id_tbl IN trx_line_id_tbl,
1441 p_INTERNAL_ORGANIZATION_ID_tbl IN INTERNAL_ORGANIZATION_ID_TBL,
1442 p_TAX_LINE_ID_tbl IN TAX_LINE_ID_TBL,
1443 p_legal_reporting_status_val IN zx_lines.LEGAL_REPORTING_STATUS%type,
1444 x_return_status OUT NOCOPY VARCHAR2,
1445 x_msg_count OUT NOCOPY NUMBER,
1446 x_msg_data OUT NOCOPY VARCHAR2
1447 );
1448 --end EMEA
1449
1450 /* apai
1451 function get_rep_context_id( p_org_id in number,
1452 p_legal in varchar2,
1453 p_legal_id in number,
1454 p_request_id in number)
1455 return number ;
1456 */
1457
1458 function get_rep_context_id( p_legal_id in number,
1459 p_request_id in number)
1460 return number ;
1461
1462 function use_matrix_flag( p_report_id in varchar2,
1463 p_attribute_set in varchar2,
1464 p_product in varchar2 default NULL)
1465 return varchar2;
1466
1467 --function build_union_clause_code(p_request_id in number)
1468 -- return varchar2;
1469
1470 function purge(p_request_id in number) return number;
1471
1472 END ZX_EXTRACT_PKG;