eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.JG_ZZ_VAT_SELECTION_PKG

Source


1 PACKAGE JG_ZZ_VAT_SELECTION_PKG AUTHID CURRENT_USER AS
2 /* $Header: jgzzvsps.pls 120.8.12020000.4 2013/02/28 11:16:26 sakekuma ship $ */
3 --
4 -----------------------------------------
5 --Public Variable Declarations
6 -----------------------------------------
7 --
8 
9 TYPE GLOBAL_VARIABLES_REC_TYPE IS RECORD
10 (
11 REPORTING_ENTITY_LEVEL    JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
12 LEDGER			  JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE,
13 BSV			  JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
14 VAT_REPORTING_ENTITY_ID   JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
15 MAPPING_VAT_REP_ENTITY_ID JG_ZZ_VAT_REP_ENTITIES.mapping_vat_rep_entity_id%TYPE,
16 TAX_PERIOD		  JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
17 SOURCE		          JG_ZZ_VAT_REP_STATUS.source%TYPE,
18 ACCTD_UNACCTD		  VARCHAR2(30),
19 LEGAL_ENTITY_ID           JG_ZZ_VAT_REP_ENTITIES.legal_entity_id%TYPE,
20 TAX_REGIME_CODE		  JG_ZZ_VAT_REP_ENTITIES.tax_regime_code%TYPE,
21 TAX_REGISTRATION_NUMBER   JG_ZZ_VAT_REP_ENTITIES.tax_registration_number%TYPE,
22 TAX_CALENDAR_NAME	  JG_ZZ_VAT_REP_ENTITIES.tax_calendar_name%TYPE,
23 TAX_INVOICE_DATE_LOW	  JG_ZZ_VAT_TRX_DETAILS.tax_invoice_date%TYPE,
24 TAX_INVOICE_DATE_HIGH     JG_ZZ_VAT_TRX_DETAILS.tax_invoice_date%TYPE,
25 DEBUG_FLAG		  VARCHAR2(1),
26 ERRBUF                     VARCHAR2(1000),
27 RETCODE                    NUMBER,
28 DRIVING_DATE_CODE          JG_ZZ_VAT_REP_ENTITIES.driving_date_code%TYPE,
29 GL_DATE_LOW                DATE,
30 GL_DATE_HIGH               DATE,
31 TRX_DATE_LOW               DATE,
32 TRX_DATE_HIGH              DATE,
33 GL_OR_TRX_DATE_FILTER      VARCHAR2(1),
34 LAST_REPORTED_PERIOD_FROM_11i JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
35 LAST_REP_PERIOD_START_DATE DATE,
36 LAST_REP_PERIOD_END_DATE DATE);
37 
38 -- Table type declaration of JG_ZZ_VAT_TRX_DETAILS columns.
39 
40 TYPE VAT_TRANSACTION_ID_TBL IS TABLE OF
41   JG_ZZ_VAT_TRX_DETAILS.VAT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
42 
43 TYPE REPORTING_STATUS_ID_TBL IS TABLE OF
44   JG_ZZ_VAT_TRX_DETAILS.REPORTING_STATUS_ID%TYPE INDEX BY BINARY_INTEGER;
45 
46 TYPE SELECTION_PROCESS_ID_TBL IS TABLE OF
47         JG_ZZ_VAT_TRX_DETAILS.SELECTION_PROCESS_ID%TYPE INDEX BY BINARY_INTEGER;
48 
49 TYPE REP_ENTITY_ID_TBL IS TABLE OF
50   JG_ZZ_VAT_TRX_DETAILS.REP_ENTITY_ID%TYPE INDEX BY BINARY_INTEGER;
51 
52 TYPE REP_CONTEXT_ENTITY_NAME_TBL IS TABLE OF
53   JG_ZZ_VAT_TRX_DETAILS.REP_CONTEXT_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;
54 
55 TYPE REP_CONTEXT_ENTITY_LOC_ID_TBL IS TABLE OF
56   JG_ZZ_VAT_TRX_DETAILS.REP_CONTEXT_ENTITY_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
57 
58 TYPE TAXPAYER_ID_TBL IS TABLE OF
59   JG_ZZ_VAT_TRX_DETAILS.TAXPAYER_ID%TYPE INDEX BY BINARY_INTEGER;
60 
61 TYPE ORG_INFORMATION2_TBL IS TABLE OF
62   JG_ZZ_VAT_TRX_DETAILS.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
63 
64 TYPE LEGAL_AUTHORITY_NAME_TBL IS TABLE OF
65   JG_ZZ_VAT_TRX_DETAILS.LEGAL_AUTHORITY_NAME%TYPE INDEX BY BINARY_INTEGER;
66 
67 TYPE LEGAL_AUTH_ADDRESS_LINE2_TBL IS TABLE OF
68   JG_ZZ_VAT_TRX_DETAILS.LEGAL_AUTH_ADDRESS_LINE2%TYPE INDEX BY BINARY_INTEGER;
69 
70 TYPE LEGAL_AUTH_ADDRESS_LINE3_TBL IS TABLE OF
71   JG_ZZ_VAT_TRX_DETAILS.LEGAL_AUTH_ADDRESS_LINE3%TYPE INDEX BY BINARY_INTEGER;
72 
73 TYPE LEGAL_AUTH_CITY_TBL IS TABLE OF
74   JG_ZZ_VAT_TRX_DETAILS.LEGAL_AUTH_CITY%TYPE INDEX BY BINARY_INTEGER;
75 
76 TYPE LEGAL_CONTACT_PARTY_NAME_TBL IS TABLE OF
77   JG_ZZ_VAT_TRX_DETAILS.LEGAL_CONTACT_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;
78 
79 TYPE ACTIVITY_CODE_TBL IS TABLE OF
80   JG_ZZ_VAT_TRX_DETAILS.ACTIVITY_CODE%TYPE INDEX BY BINARY_INTEGER;
81 
82 TYPE LEDGER_ID_TBL IS TABLE OF
83   JG_ZZ_VAT_TRX_DETAILS.LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
84 
85 TYPE LEDGER_NAME_TBL IS TABLE OF
86   JG_ZZ_VAT_TRX_DETAILS.LEDGER_NAME%TYPE INDEX BY BINARY_INTEGER;
87 
88 TYPE CHART_OF_ACCOUNTS_ID_TBL IS TABLE OF
89   JG_ZZ_VAT_TRX_DETAILS.CHART_OF_ACCOUNTS_ID%TYPE INDEX BY BINARY_INTEGER;
90 
91 TYPE EXTRACT_SOURCE_LEDGER_TBL IS TABLE OF
92   JG_ZZ_VAT_TRX_DETAILS.EXTRACT_SOURCE_LEDGER%TYPE INDEX BY BINARY_INTEGER;
93 
94 TYPE ESTABLISHMENT_ID_TBL IS TABLE OF
95   JG_ZZ_VAT_TRX_DETAILS.ESTABLISHMENT_ID%TYPE INDEX BY BINARY_INTEGER;
96 
97 TYPE INTERNAL_ORGANIZATION_ID_TBL IS TABLE OF
98   JG_ZZ_VAT_TRX_DETAILS.INTERNAL_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
99 
100 TYPE APPLICATION_ID_TBL IS TABLE OF
101   JG_ZZ_VAT_TRX_DETAILS.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
102 
103 TYPE ENTITY_CODE_TBL IS TABLE OF
104   JG_ZZ_VAT_TRX_DETAILS.ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
105 
106 TYPE EVENT_CLASS_CODE_TBL IS TABLE OF
107   JG_ZZ_VAT_TRX_DETAILS.EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
108 
109 TYPE TRX_ID_TBL IS TABLE OF
110   JG_ZZ_VAT_TRX_DETAILS.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
111 
112 TYPE TRX_NUMBER_TBL IS TABLE OF
113   JG_ZZ_VAT_TRX_DETAILS.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
114 
115 TYPE TRX_DESCRIPTION_TBL IS TABLE OF
116   JG_ZZ_VAT_TRX_DETAILS.TRX_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
117 
118 TYPE TRX_CURRENCY_CODE_TBL IS TABLE OF
119   JG_ZZ_VAT_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
120 
121 TYPE TRX_TYPE_ID_TBL IS TABLE OF
122   JG_ZZ_VAT_TRX_DETAILS.TRX_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
123 
124 TYPE TRX_TYPE_MNG_TBL IS TABLE OF
125   JG_ZZ_VAT_TRX_DETAILS.TRX_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
126 
127 TYPE TRX_LINE_ID_TBL IS TABLE OF
128   JG_ZZ_VAT_TRX_DETAILS.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
129 
130 TYPE TRX_LINE_NUMBER_TBL IS TABLE OF
131   JG_ZZ_VAT_TRX_DETAILS.TRX_LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
132 
133 TYPE TRX_LINE_DESCRIPTION_TBL IS TABLE OF
134   JG_ZZ_VAT_TRX_DETAILS.TRX_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
135 
136 TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
137      JG_ZZ_VAT_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
138 
139 TYPE TRX_LINE_TYPE_TBL IS TABLE OF
140   JG_ZZ_VAT_TRX_DETAILS.TRX_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
141 
142 TYPE TRX_LINE_CLASS_TBL IS TABLE OF
143   JG_ZZ_VAT_TRX_DETAILS.TRX_LINE_CLASS%TYPE INDEX BY BINARY_INTEGER;
144 
145 TYPE TRX_CLASS_MNG_TBL IS TABLE OF
146   JG_ZZ_VAT_TRX_DETAILS.TRX_CLASS_MNG%TYPE INDEX BY BINARY_INTEGER;
147 
148 TYPE TRX_DATE_TBL IS TABLE OF
149   JG_ZZ_VAT_TRX_DETAILS.TRX_DATE%TYPE INDEX BY BINARY_INTEGER;
150 
151 TYPE TRX_DUE_DATE_TBL IS TABLE OF
152   JG_ZZ_VAT_TRX_DETAILS.TRX_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
153 
154 TYPE TRX_COMMUNICATED_DATE_TBL IS TABLE OF
155   JG_ZZ_VAT_TRX_DETAILS.TRX_COMMUNICATED_DATE%TYPE INDEX BY BINARY_INTEGER;
156 
157 TYPE GL_DATE_TBL IS TABLE OF
158  JG_ZZ_VAT_TRX_DETAILS.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
159 
160 TYPE PRODUCT_ID_TBL IS TABLE OF
161   JG_ZZ_VAT_TRX_DETAILS.PRODUCT_ID%TYPE INDEX BY BINARY_INTEGER;
162 
163 TYPE FUNCTIONAL_CURRENCY_CODE_TBL IS TABLE OF
164   JG_ZZ_VAT_TRX_DETAILS.FUNCTIONAL_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165 
166 TYPE CURRENCY_CONVERSION_TYPE_TBL IS TABLE OF
167   JG_ZZ_VAT_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168 
169 TYPE CURRENCY_CONVERSION_DATE_TBL IS TABLE OF
170   JG_ZZ_VAT_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
171 
172 TYPE CURRENCY_CONVERSION_RATE_TBL IS TABLE OF
173   JG_ZZ_VAT_TRX_DETAILS.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
174 
175 TYPE TERRITORY_SHORT_NAME_TBL IS TABLE OF
176   JG_ZZ_VAT_TRX_DETAILS.TERRITORY_SHORT_NAME%TYPE INDEX BY BINARY_INTEGER;
177 
178 TYPE DOC_SEQ_ID_TBL IS TABLE OF
179   JG_ZZ_VAT_TRX_DETAILS.DOC_SEQ_ID%TYPE INDEX BY BINARY_INTEGER;
180 
181 TYPE DOC_SEQ_NAME_TBL IS TABLE OF
182   JG_ZZ_VAT_TRX_DETAILS.DOC_SEQ_NAME%TYPE INDEX BY BINARY_INTEGER;
183 
184 TYPE DOC_SEQ_VALUE_TBL IS TABLE OF
185   JG_ZZ_VAT_TRX_DETAILS.DOC_SEQ_VALUE%TYPE INDEX BY BINARY_INTEGER;
186 
187 TYPE TRX_LINE_AMT_TBL IS TABLE OF
188   JG_ZZ_VAT_TRX_DETAILS.TRX_LINE_AMT%TYPE INDEX BY BINARY_INTEGER;
189 
190 TYPE RECEIPT_CLASS_ID_TBL IS TABLE OF
191   JG_ZZ_VAT_TRX_DETAILS.RECEIPT_CLASS_ID%TYPE INDEX BY BINARY_INTEGER;
192 
193 TYPE APPLIED_FROM_APPL_ID_TBL IS TABLE OF
194   JG_ZZ_VAT_TRX_DETAILS.APPLIED_FROM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
195 
196 TYPE APPLIED_FROM_ENTITY_CODE_TBL IS TABLE OF
197   JG_ZZ_VAT_TRX_DETAILS.APPLIED_FROM_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
198 
199 TYPE APPLIED_FROM_EVENT_CLS_CD_TBL IS TABLE OF
200   JG_ZZ_VAT_TRX_DETAILS.APPLIED_FROM_EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
201 
202 TYPE APPLIED_FROM_TRX_ID_TBL IS TABLE OF
203   JG_ZZ_VAT_TRX_DETAILS.APPLIED_FROM_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
204 
205 TYPE APPLIED_FROM_LINE_ID_TBL IS TABLE OF
206   JG_ZZ_VAT_TRX_DETAILS.APPLIED_FROM_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
207 
208 TYPE APPLIED_FROM_TRX_NUMBER_TBL IS TABLE OF
209   JG_ZZ_VAT_TRX_DETAILS.APPLIED_FROM_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
210 
211 TYPE ADJUSTED_DOC_APPL_ID_TBL IS TABLE OF
212   JG_ZZ_VAT_TRX_DETAILS.ADJUSTED_DOC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
213 
214 TYPE ADJUSTED_DOC_ENTITY_CODE_TBL IS TABLE OF
215   JG_ZZ_VAT_TRX_DETAILS.ADJUSTED_DOC_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
216 
217 TYPE ADJUSTED_DOC_EVENT_CLS_CD_TBL IS TABLE OF
218   JG_ZZ_VAT_TRX_DETAILS.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
219 
220 TYPE ADJUSTED_DOC_TRX_ID_TBL IS TABLE OF
221   JG_ZZ_VAT_TRX_DETAILS.ADJUSTED_DOC_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
222 
223 TYPE ADJUSTED_DOC_NUMBER_TBL IS TABLE OF
224   JG_ZZ_VAT_TRX_DETAILS.ADJUSTED_DOC_NUMBER%TYPE INDEX BY BINARY_INTEGER;
225 
226 TYPE ADJUSTED_DOC_DATE_TBL IS TABLE OF
227   JG_ZZ_VAT_TRX_DETAILS.ADJUSTED_DOC_DATE%TYPE INDEX BY BINARY_INTEGER;
228 
229 TYPE APPLIED_TO_APPLICATION_ID_TBL IS TABLE OF
230   JG_ZZ_VAT_TRX_DETAILS.APPLIED_TO_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
231 
232 TYPE APPLIED_TO_ENTITY_CODE_TBL IS TABLE OF
233   JG_ZZ_VAT_TRX_DETAILS.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
234 
235 TYPE APPLIED_TO_EVENT_CLS_CODE_TBL IS TABLE OF
236   JG_ZZ_VAT_TRX_DETAILS.APPLIED_TO_EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
237 
238 TYPE APPLIED_TO_TRX_ID_TBL IS TABLE OF
239   JG_ZZ_VAT_TRX_DETAILS.APPLIED_TO_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
240 
241 TYPE APPLIED_TO_TRX_LINE_ID_TBL IS TABLE OF
242   JG_ZZ_VAT_TRX_DETAILS.APPLIED_TO_TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
243 
244 TYPE APPLIED_TO_TRX_NUMBER_TBL IS TABLE OF
245   JG_ZZ_VAT_TRX_DETAILS.APPLIED_TO_TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
246 
247 TYPE REF_DOC_APPLICATION_ID_TBL IS TABLE OF
248   JG_ZZ_VAT_TRX_DETAILS.REF_DOC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
249 
250 TYPE REF_DOC_ENTITY_CODE_TBL IS TABLE OF
251   JG_ZZ_VAT_TRX_DETAILS.REF_DOC_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
252 
253 TYPE REF_DOC_EVENT_CLASS_CODE_TBL IS TABLE OF
254   JG_ZZ_VAT_TRX_DETAILS.REF_DOC_EVENT_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
255 
256 TYPE REF_DOC_TRX_ID_TBL IS TABLE OF
257   JG_ZZ_VAT_TRX_DETAILS.REF_DOC_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
258 
259 TYPE REF_DOC_LINE_ID_TBL IS TABLE OF
260   JG_ZZ_VAT_TRX_DETAILS.REF_DOC_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
261 
262 TYPE MERCHANT_PARTY_DOC_NUM_TBL IS TABLE OF
263   JG_ZZ_VAT_TRX_DETAILS.MERCHANT_PARTY_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
264 
265 TYPE MERCHANT_PARTY_NAME_TBL IS TABLE OF
266   JG_ZZ_VAT_TRX_DETAILS.MERCHANT_PARTY_NAME%TYPE INDEX BY BINARY_INTEGER;
267 
268 TYPE MERCHANT_PARTY_REFERENCE_TBL IS TABLE OF
269   JG_ZZ_VAT_TRX_DETAILS.MERCHANT_PARTY_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
270 
271 TYPE MERCHANT_PARTY_TAX_REG_NUM_TBL IS TABLE OF
272   JG_ZZ_VAT_TRX_DETAILS.MERCHANT_PARTY_TAX_REG_NUMBER%TYPE INDEX BY BINARY_INTEGER;
273 
274 TYPE MERCHANT_PARTY_TAXPAYER_ID_TBL IS TABLE OF
275   JG_ZZ_VAT_TRX_DETAILS.MERCHANT_PARTY_TAXPAYER_ID%TYPE INDEX BY BINARY_INTEGER;
276 
277 TYPE START_EXPENSE_DATE_TBL IS TABLE OF
278   JG_ZZ_VAT_TRX_DETAILS.START_EXPENSE_DATE%TYPE INDEX BY BINARY_INTEGER;
279 
280 TYPE TAXABLE_LINE_SOURCE_TABLE_TBL IS TABLE OF
281   JG_ZZ_VAT_TRX_DETAILS.TAXABLE_LINE_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
282 
283 TYPE TAX_LINE_ID_TBL IS TABLE OF
284   JG_ZZ_VAT_TRX_DETAILS.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
285 
286 TYPE TAX_LINE_NUMBER_TBL IS TABLE OF
287   JG_ZZ_VAT_TRX_DETAILS.TAX_LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
288 
289 TYPE TAX_INVOICE_DATE_TBL IS TABLE OF
290   JG_ZZ_VAT_TRX_DETAILS.TAX_INVOICE_DATE%TYPE INDEX BY BINARY_INTEGER;
291 
292 TYPE TAXABLE_AMT_TBL IS TABLE OF
293   JG_ZZ_VAT_TRX_DETAILS.TAXABLE_AMT%TYPE INDEX BY BINARY_INTEGER;
294 
295 TYPE TAXABLE_AMT_FUNCL_CURR_TBL IS TABLE OF
296   JG_ZZ_VAT_TRX_DETAILS.TAXABLE_AMT_FUNCL_CURR%TYPE INDEX BY BINARY_INTEGER;
297 
298 TYPE TAX_AMT_TBL IS TABLE OF
299   JG_ZZ_VAT_TRX_DETAILS.TAX_AMT%TYPE INDEX BY BINARY_INTEGER;
300 
301 TYPE TAX_AMT_FUNCL_CURR_TBL IS TABLE OF
302   JG_ZZ_VAT_TRX_DETAILS.TAX_AMT_FUNCL_CURR%TYPE INDEX BY BINARY_INTEGER;
303 
304 TYPE REC_TAX_AMT_TAX_CURR_TBL IS TABLE OF
305   JG_ZZ_VAT_TRX_DETAILS.REC_TAX_AMT_TAX_CURR%TYPE INDEX BY BINARY_INTEGER;
306 
307 TYPE NREC_TAX_AMT_TAX_CURR_TBL IS TABLE OF
308   JG_ZZ_VAT_TRX_DETAILS.NREC_TAX_AMT_TAX_CURR%TYPE INDEX BY BINARY_INTEGER;
309 
310 TYPE TAXABLE_DISC_AMT_TBL IS TABLE OF
311   JG_ZZ_VAT_TRX_DETAILS.TAXABLE_DISC_AMT%TYPE INDEX BY BINARY_INTEGER;
312 
313 TYPE TAXABLE_DISC_AMT_FUN_CURR_TBL IS TABLE OF
314   JG_ZZ_VAT_TRX_DETAILS.TAXABLE_DISC_AMT_FUNCL_CURR%TYPE INDEX BY BINARY_INTEGER;
315 
316 TYPE TAX_DISC_AMT_TBL IS TABLE OF
317   JG_ZZ_VAT_TRX_DETAILS.TAX_DISC_AMT%TYPE INDEX BY BINARY_INTEGER;
318 
319 TYPE TAX_DISC_AMT_FUN_CURR_TBL IS TABLE OF
320   JG_ZZ_VAT_TRX_DETAILS.TAX_DISC_AMT_FUNCL_CURR%TYPE INDEX BY BINARY_INTEGER;
321 
325 TYPE TAX_RATE_CODE_TBL IS TABLE OF
322 TYPE TAX_RATE_ID_TBL IS TABLE OF
323   JG_ZZ_VAT_TRX_DETAILS.TAX_RATE_ID%TYPE INDEX BY BINARY_INTEGER;
324 
326   JG_ZZ_VAT_TRX_DETAILS.TAX_RATE_CODE%TYPE INDEX BY BINARY_INTEGER;
327 
328 TYPE TAX_RATE_TBL IS TABLE OF
329   JG_ZZ_VAT_TRX_DETAILS.TAX_RATE%TYPE INDEX BY BINARY_INTEGER;
330 
331 TYPE TAX_RATE_CODE_NAME_TBL IS TABLE OF
332   JG_ZZ_VAT_TRX_DETAILS.TAX_RATE_CODE_NAME%TYPE INDEX BY BINARY_INTEGER;
333 
334 TYPE TAX_RATE_CODE_DESCRIPTION_TBL IS TABLE OF
335   JG_ZZ_VAT_TRX_DETAILS.TAX_RATE_CODE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
336 
337 TYPE TAX_RATE_VAT_TRX_TYPE_CODE_TBL IS TABLE OF
338   JG_ZZ_VAT_TRX_DETAILS.TAX_RATE_VAT_TRX_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
339 
340 TYPE TAX_RATE_VAT_TRX_TYPE_DESC_TBL IS TABLE OF
341   JG_ZZ_VAT_TRX_DETAILS.TAX_RATE_VAT_TRX_TYPE_DESC%TYPE INDEX BY BINARY_INTEGER;
342 
343 TYPE TAX_RATE_VAT_TRX_TYPE_MNG_TBL IS TABLE OF
344   JG_ZZ_VAT_TRX_DETAILS.TAX_RATE_CODE_VAT_TRX_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
345 
346 TYPE TAX_RATE_REG_TYPE_CODE_TBL IS TABLE OF
347   JG_ZZ_VAT_TRX_DETAILS.TAX_RATE_REGISTER_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
348 
349 TYPE TAX_TYPE_CODE_TBL IS TABLE OF
350   JG_ZZ_VAT_TRX_DETAILS.TAX_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
351 
352 TYPE TAX_TYPE_MNG_TBL IS TABLE OF
353   JG_ZZ_VAT_TRX_DETAILS.TAX_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
354 
355 TYPE TAX_RECOVERY_RATE_TBL IS TABLE OF
356   JG_ZZ_VAT_TRX_DETAILS.TAX_RECOVERY_RATE%TYPE INDEX BY BINARY_INTEGER;
357 
358 TYPE TAX_REGIME_CODE_TBL IS TABLE OF
359   JG_ZZ_VAT_TRX_DETAILS.TAX_REGIME_CODE%TYPE INDEX BY BINARY_INTEGER;
360 
361 TYPE TAX_TBL IS TABLE OF
362   JG_ZZ_VAT_TRX_DETAILS.TAX%TYPE INDEX BY BINARY_INTEGER;
363 
364 TYPE TAX_JURISDICTION_CODE_TBL IS TABLE OF
365   JG_ZZ_VAT_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE INDEX BY BINARY_INTEGER;
366 
367 TYPE TAX_STATUS_ID_TBL IS TABLE OF
368   JG_ZZ_VAT_TRX_DETAILS.TAX_STATUS_ID%TYPE INDEX BY BINARY_INTEGER;
369 
370 TYPE TAX_STATUS_CODE_TBL IS TABLE OF
371   JG_ZZ_VAT_TRX_DETAILS.TAX_STATUS_CODE%TYPE INDEX BY BINARY_INTEGER;
372 
373 TYPE TAX_CURRENCY_CODE_TBL IS TABLE OF
374   JG_ZZ_VAT_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
375 
376 TYPE OFFSET_TAX_RATE_CODE_TBL IS TABLE OF
377   JG_ZZ_VAT_TRX_DETAILS.OFFSET_TAX_RATE_CODE%TYPE INDEX BY BINARY_INTEGER;
378 
379 TYPE BILLING_TP_NAME_TBL IS TABLE OF
380   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_NAME%TYPE INDEX BY BINARY_INTEGER;
381 
382 TYPE BILLING_TP_NUMBER_TBL IS TABLE OF
383   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_NUMBER%TYPE INDEX BY BINARY_INTEGER;
384 
385 TYPE BILLING_TP_TAX_REG_NUM_TBL IS TABLE OF
386   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_TAX_REG_NUM%TYPE INDEX BY BINARY_INTEGER;
387 
388 TYPE BILLING_TP_TAXPAYER_ID_TBL IS TABLE OF
389   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_TAXPAYER_ID%TYPE INDEX BY BINARY_INTEGER;
390 
391 TYPE BILLING_TP_PARTY_NUMBER_TBL IS TABLE OF
392   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_PARTY_NUMBER%TYPE INDEX BY BINARY_INTEGER;
393 
394 TYPE BILLING_TP_ID_TBL IS TABLE OF
395   JG_ZZ_VAT_TRX_DETAILS.BILLING_TRADING_PARTNER_ID%TYPE INDEX BY BINARY_INTEGER;
396 
397 TYPE BILLING_TP_TAX_REP_FLAG_TBL IS TABLE OF
398   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_TAX_REPORTING_FLAG%TYPE INDEX BY BINARY_INTEGER;
399 
400 TYPE BILLING_TP_SITE_ID_TBL IS TABLE OF
401   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
402 
403 TYPE BILLING_TP_ADDRESS_ID_TBL IS TABLE OF
404   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_ADDRESS_ID%TYPE INDEX BY BINARY_INTEGER;
405 
406 TYPE BILLING_TP_SITE_NAME_TBL IS TABLE OF
407   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_SITE_NAME%TYPE INDEX BY BINARY_INTEGER;
408 
409 TYPE BILLING_TP_SITE_TX_REG_NUM_TBL IS TABLE OF
410   JG_ZZ_VAT_TRX_DETAILS.BILLING_TP_SITE_TAX_REG_NUM%TYPE INDEX BY BINARY_INTEGER;
411 
412 TYPE SHIPPING_TP_NAME_TBL IS TABLE OF
413   JG_ZZ_VAT_TRX_DETAILS.SHIPPING_TP_NAME%TYPE INDEX BY BINARY_INTEGER;
414 
415 TYPE SHIPPING_TP_NUMBER_TBL IS TABLE OF
416   JG_ZZ_VAT_TRX_DETAILS.SHIPPING_TP_NUMBER%TYPE INDEX BY BINARY_INTEGER;
417 
418 TYPE SHIPPING_TP_TAX_REG_NUM_TBL IS TABLE OF
419   JG_ZZ_VAT_TRX_DETAILS.SHIPPING_TP_TAX_REG_NUM%TYPE INDEX BY BINARY_INTEGER;
420 
421 TYPE SHIPPING_TP_TAXPAYER_ID_TBL IS TABLE OF
422   JG_ZZ_VAT_TRX_DETAILS.SHIPPING_TP_TAXPAYER_ID%TYPE INDEX BY BINARY_INTEGER;
423 
424 TYPE SHIPPING_TP_ID_TBL IS TABLE OF
425   JG_ZZ_VAT_TRX_DETAILS.SHIPPING_TRADING_PARTNER_ID%TYPE INDEX BY BINARY_INTEGER;
426 
427 TYPE SHIPPING_TP_SITE_ID_TBL IS TABLE OF
428   JG_ZZ_VAT_TRX_DETAILS.SHIPPING_TP_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
429 
430 TYPE SHIPPING_TP_ADDRESS_ID_TBL IS TABLE OF
431   JG_ZZ_VAT_TRX_DETAILS.SHIPPING_TP_ADDRESS_ID%TYPE INDEX BY BINARY_INTEGER;
432 
433 TYPE SHIPPING_TP_SITE_NAME_TBL IS TABLE OF
434   JG_ZZ_VAT_TRX_DETAILS.SHIPPING_TP_SITE_NAME%TYPE INDEX BY BINARY_INTEGER;
435 
436 TYPE SHIPPING_TP_SITE_TX_RG_NUM_TBL IS TABLE OF
437   JG_ZZ_VAT_TRX_DETAILS.SHIPPING_TP_SITE_TAX_REG_NUM%TYPE INDEX BY BINARY_INTEGER;
438 
439 TYPE BILL_FROM_PARTY_ID_TBL IS TABLE OF			-- Bug 16386556
440   JG_ZZ_VAT_TRX_DETAILS.BILL_FROM_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
441 
442 TYPE BILL_FROM_PARTY_SITE_ID_TBL IS TABLE OF		-- Bug 16386556
443   JG_ZZ_VAT_TRX_DETAILS.BILL_FROM_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
444 
445 TYPE BANKING_TP_NAME_TBL IS TABLE OF
446   JG_ZZ_VAT_TRX_DETAILS.BANKING_TP_NAME%TYPE INDEX BY BINARY_INTEGER;
447 
448 TYPE BANKING_TP_TAXPAYER_ID_TBL IS TABLE OF
449   JG_ZZ_VAT_TRX_DETAILS.BANKING_TP_TAXPAYER_ID%TYPE INDEX BY BINARY_INTEGER;
450 
451 TYPE BANK_ACCOUNT_NAME_TBL IS TABLE OF
452   JG_ZZ_VAT_TRX_DETAILS.BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
453 
454 TYPE BANK_ACCOUNT_NUM_TBL IS TABLE OF
455   JG_ZZ_VAT_TRX_DETAILS.BANK_ACCOUNT_NUM%TYPE INDEX BY BINARY_INTEGER;
456 
460 TYPE BANK_BRANCH_ID_TBL IS TABLE OF
457 TYPE BANK_ACCOUNT_ID_TBL IS TABLE OF
458   JG_ZZ_VAT_TRX_DETAILS.BANK_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
459 
461   JG_ZZ_VAT_TRX_DETAILS.BANK_BRANCH_ID%TYPE INDEX BY BINARY_INTEGER;
462 
463 TYPE LEGAL_ENTITY_TAX_REG_NUM_TBL IS TABLE OF
464   JG_ZZ_VAT_TRX_DETAILS.LEGAL_ENTITY_TAX_REG_NUMBER%TYPE INDEX BY BINARY_INTEGER;
465 
466 TYPE HQ_ESTB_REG_NUMBER_TBL IS TABLE OF
467   JG_ZZ_VAT_TRX_DETAILS.HQ_ESTB_REG_NUMBER%TYPE INDEX BY BINARY_INTEGER;
468 
469 TYPE TAX_LINE_REGISTRATION_NUM_TBL IS TABLE OF
470   JG_ZZ_VAT_TRX_DETAILS.TAX_LINE_REGISTRATION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
471 
472 TYPE CANCELLED_DATE_TBL IS TABLE OF
473   JG_ZZ_VAT_TRX_DETAILS.CANCELLED_DATE%TYPE INDEX BY BINARY_INTEGER;
474 
475 TYPE CANCEL_FLAG_TBL IS TABLE OF
476   JG_ZZ_VAT_TRX_DETAILS.CANCEL_FLAG%TYPE INDEX BY BINARY_INTEGER;
477 
478 TYPE OFFSET_FLAG_TBL IS TABLE OF
479   JG_ZZ_VAT_TRX_DETAILS.OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
480 
481 TYPE POSTED_FLAG_TBL IS TABLE OF
482   JG_ZZ_VAT_TRX_DETAILS.POSTED_FLAG%TYPE INDEX BY BINARY_INTEGER;
483 
484 TYPE MRC_TAX_LINE_FLAG_TBL IS TABLE OF
485   JG_ZZ_VAT_TRX_DETAILS.MRC_TAX_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
486 
487 TYPE RECONCILIATION_FLAG_TBL IS TABLE OF
488   JG_ZZ_VAT_TRX_DETAILS.RECONCILIATION_FLAG%TYPE INDEX BY BINARY_INTEGER;
489 
490 TYPE TAX_RECOVERABLE_FLAG_TBL IS TABLE OF
491   JG_ZZ_VAT_TRX_DETAILS.TAX_RECOVERABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
492 
493 TYPE REVERSE_FLAG_TBL IS TABLE OF
494   JG_ZZ_VAT_TRX_DETAILS.REVERSE_FLAG%TYPE INDEX BY BINARY_INTEGER;
495 
496 TYPE CORRECTION_FLAG_TBL IS TABLE OF
497   JG_ZZ_VAT_TRX_DETAILS.CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
498 
499 TYPE AR_CASH_RECEIPT_REV_STAT_TBL IS TABLE OF
500   JG_ZZ_VAT_TRX_DETAILS.AR_CASH_RECEIPT_REVERSE_STATUS%TYPE INDEX BY BINARY_INTEGER;
501 
502 TYPE AR_CASH_RECEIPT_REV_DATE_TBL IS TABLE OF
503   JG_ZZ_VAT_TRX_DETAILS.AR_CASH_RECEIPT_REVERSE_DATE%TYPE INDEX BY BINARY_INTEGER;
504 
505 TYPE PAYABLES_INVOICE_SOURCE_TBL IS TABLE OF
506   JG_ZZ_VAT_TRX_DETAILS.PAYABLES_INVOICE_SOURCE%TYPE INDEX BY BINARY_INTEGER;
507 
508 TYPE ACCTD_AMOUNT_DR_TBL IS TABLE OF
509   JG_ZZ_VAT_TRX_DETAILS.ACCTD_AMOUNT_DR%TYPE INDEX BY BINARY_INTEGER;
510 
511 TYPE ACCTD_AMOUNT_CR_TBL IS TABLE OF
512   JG_ZZ_VAT_TRX_DETAILS.ACCTD_AMOUNT_CR%TYPE INDEX BY BINARY_INTEGER;
513 
514 TYPE REC_APPLICATION_STATUS_TBL IS TABLE OF
515   JG_ZZ_VAT_TRX_DETAILS.REC_APPLICATION_STATUS%TYPE INDEX BY BINARY_INTEGER;
516 
517 TYPE VAT_COUNTRY_CODE_TBL IS TABLE OF
518   JG_ZZ_VAT_TRX_DETAILS.VAT_COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
519 
520 TYPE INVOICE_IDENTIFIER_TBL IS TABLE OF
521   JG_ZZ_VAT_TRX_DETAILS.INVOICE_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
522 
523 TYPE ACCOUNT_CLASS_TBL IS TABLE OF
524   JG_ZZ_VAT_TRX_DETAILS.ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
525 
526 TYPE LATEST_REC_FLAG_TBL IS TABLE OF
527   JG_ZZ_VAT_TRX_DETAILS.LATEST_REC_FLAG%TYPE INDEX BY BINARY_INTEGER;
528 
529 TYPE JGZZ_FISCAL_CODE_TBL IS TABLE OF
530   JG_ZZ_VAT_TRX_DETAILS.JGZZ_FISCAL_CODE%TYPE INDEX BY BINARY_INTEGER;
531 
532 TYPE TAX_REFERENCE_TBL IS TABLE OF
533   JG_ZZ_VAT_TRX_DETAILS.TAX_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
534 
535 TYPE PT_LOCATION_TBL IS TABLE OF
536   JG_ZZ_VAT_TRX_DETAILS.PT_LOCATION%TYPE INDEX BY BINARY_INTEGER;
537 
538 TYPE INVOICE_REPORT_TYPE_TBL IS TABLE OF
539   JG_ZZ_VAT_TRX_DETAILS.INVOICE_REPORT_TYPE%TYPE INDEX BY BINARY_INTEGER;
540 
541 TYPE ES_CORRECTION_YEAR_TBL IS TABLE OF
542   JG_ZZ_VAT_TRX_DETAILS.ES_CORRECTION_YEAR%TYPE INDEX BY BINARY_INTEGER;
543 
544 TYPE ES_CORRECTION_PERIOD_TBL IS TABLE OF
545   JG_ZZ_VAT_TRX_DETAILS.ES_CORRECTION_PERIOD%TYPE INDEX BY BINARY_INTEGER;
546 
547 TYPE TRIANGULATION_TBL IS TABLE OF
548   JG_ZZ_VAT_TRX_DETAILS.TRIANGULATION%TYPE INDEX BY BINARY_INTEGER;
549 
550 TYPE DOCUMENT_SUB_TYPE_TBL IS TABLE OF
551   JG_ZZ_VAT_TRX_DETAILS.DOCUMENT_SUB_TYPE%TYPE INDEX BY BINARY_INTEGER;
552 
553 TYPE ASSESSABLE_VALUE_TBL IS TABLE OF
554   JG_ZZ_VAT_TRX_DETAILS.ASSESSABLE_VALUE%TYPE INDEX BY BINARY_INTEGER;
555 
556 TYPE PROPERTY_LOCATION_TBL IS TABLE OF
557   JG_ZZ_VAT_TRX_DETAILS.PROPERTY_LOCATION%TYPE INDEX BY BINARY_INTEGER;
558 
559 TYPE CHK_VAT_AMOUNT_PAID_TBL IS TABLE OF
560   JG_ZZ_VAT_TRX_DETAILS.CHK_VAT_AMOUNT_PAID%TYPE INDEX BY BINARY_INTEGER;
561 
562 TYPE IMPORT_DOCUMENT_NUMBER_TBL IS TABLE OF
563   JG_ZZ_VAT_TRX_DETAILS.IMPORT_DOCUMENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
564 
565 TYPE IMPORT_DOCUMENT_DATE_TBL IS TABLE OF
566   JG_ZZ_VAT_TRX_DETAILS.IMPORT_DOCUMENT_DATE%TYPE INDEX BY BINARY_INTEGER;
567 
568 TYPE PRL_NO_TBL IS TABLE OF
569   JG_ZZ_VAT_TRX_DETAILS.PRL_NO%TYPE INDEX BY BINARY_INTEGER;
570 
571 TYPE PROPERTY_RENTAL_TBL IS TABLE OF
572   JG_ZZ_VAT_TRX_DETAILS.PROPERTY_RENTAL%TYPE INDEX BY BINARY_INTEGER;
573 
574 TYPE RATES_REFERENCE_TBL IS TABLE OF
575   JG_ZZ_VAT_TRX_DETAILS.RATES_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
576 
577 TYPE STAIR_NUM_TBL IS TABLE OF
578   JG_ZZ_VAT_TRX_DETAILS.STAIR_NUM%TYPE INDEX BY BINARY_INTEGER;
579 
580 TYPE FLOOR_NUM_TBL IS TABLE OF
581   JG_ZZ_VAT_TRX_DETAILS.FLOOR_NUM%TYPE INDEX BY BINARY_INTEGER;
582 
583 TYPE DOOR_NUM_TBL IS TABLE OF
584   JG_ZZ_VAT_TRX_DETAILS.DOOR_NUM%TYPE INDEX BY BINARY_INTEGER;
585 
586 TYPE AMOUNT_APPLIED_TBL IS TABLE OF
587   JG_ZZ_VAT_TRX_DETAILS.AMOUNT_APPLIED%TYPE INDEX BY BINARY_INTEGER;
588 
589 TYPE ACTG_EVENT_TYPE_CODE_TBL  IS TABLE OF
590      JG_ZZ_VAT_TRX_DETAILS.ACTG_EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
591 
592 TYPE ACTG_EVENT_TYPE_MNG_TBL  IS TABLE OF
593      JG_ZZ_VAT_TRX_DETAILS.ACTG_EVENT_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
594 
595 TYPE ACTG_EVENT_NUMBER_TBL  IS TABLE OF
599      JG_ZZ_VAT_TRX_DETAILS.ACTG_EVENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
596      JG_ZZ_VAT_TRX_DETAILS.ACTG_EVENT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
597 
598 TYPE ACTG_EVENT_STATUS_FLAG_TBL  IS TABLE OF
600 
601 TYPE ACTG_EVENT_STATUS_MNG_TBL  IS TABLE OF
602      JG_ZZ_VAT_TRX_DETAILS.ACTG_EVENT_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
603 
604 TYPE ACTG_CATEGORY_CODE_TBL  IS TABLE OF
605      JG_ZZ_VAT_TRX_DETAILS.ACTG_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
606 
607 TYPE ACTG_CATEGORY_MNG_TBL  IS TABLE OF
608      JG_ZZ_VAT_TRX_DETAILS.ACTG_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
609 
610 TYPE ACCOUNTING_DATE_TBL  IS TABLE OF
611      JG_ZZ_VAT_TRX_DETAILS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
612 
613 TYPE GL_TRANSFER_FLAG_TBL  IS TABLE OF
614      JG_ZZ_VAT_TRX_DETAILS.GL_TRANSFER_FLAG%TYPE INDEX BY BINARY_INTEGER;
615 
616 TYPE ACTG_LINE_NUM_TBL  IS TABLE OF
617       JG_ZZ_VAT_TRX_DETAILS.ACTG_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
618 
619 TYPE ACTG_LINE_TYPE_CODE_TBL  IS TABLE OF
620      JG_ZZ_VAT_TRX_DETAILS.ACTG_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
621 
622 TYPE ACTG_LINE_TYPE_MNG_TBL  IS TABLE OF
623      JG_ZZ_VAT_TRX_DETAILS.ACTG_LINE_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
624 
625 TYPE ACTG_LINE_DESCRIPTION_TBL  IS TABLE OF
626      JG_ZZ_VAT_TRX_DETAILS.ACTG_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
627 
628 TYPE ACTG_STAT_AMT_TBL  IS TABLE OF
629      JG_ZZ_VAT_TRX_DETAILS.ACTG_STAT_AMT%TYPE INDEX BY BINARY_INTEGER;
630 
631 TYPE ACTG_PARTY_ID_TBL  IS TABLE OF
632      JG_ZZ_VAT_TRX_DETAILS.ACTG_PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
633 
634 TYPE ACTG_PARTY_SITE_ID_TBL  IS TABLE OF
635      JG_ZZ_VAT_TRX_DETAILS.ACTG_PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
636 
637 TYPE ACTG_PARTY_TYPE_TBL  IS TABLE OF
638      JG_ZZ_VAT_TRX_DETAILS.ACTG_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
639 
640 TYPE ACTG_EVENT_ID_TBL  IS TABLE OF
641      JG_ZZ_VAT_TRX_DETAILS.ACTG_EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
642 
643 TYPE ACTG_HEADER_ID_TBL  IS TABLE OF
644      JG_ZZ_VAT_TRX_DETAILS.ACTG_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
645 
646 TYPE ACTG_LINE_ID_TBL  IS TABLE OF
647      JG_ZZ_VAT_TRX_DETAILS.ACTG_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
648 
649 TYPE ACTG_SOURCE_ID_TBL  IS TABLE OF
650      JG_ZZ_VAT_TRX_DETAILS.ACTG_SOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
651 
652 TYPE ACTG_SOURCE_TABLE_TBL  IS TABLE OF
653      JG_ZZ_VAT_TRX_DETAILS.ACTG_SOURCE_TABLE%TYPE INDEX BY BINARY_INTEGER;
654 
655 TYPE ACTG_LINE_CCID_TBL  IS TABLE OF
656      JG_ZZ_VAT_TRX_DETAILS.ACTG_LINE_CCID%TYPE INDEX BY BINARY_INTEGER;
657 
658 TYPE ACCOUNT_FLEXFIELD_TBL  IS TABLE OF
659      JG_ZZ_VAT_TRX_DETAILS.ACCOUNT_FLEXFIELD%TYPE INDEX BY BINARY_INTEGER;
660 
661 TYPE ACCOUNT_DESCRIPTION_TBL  IS TABLE OF
662      JG_ZZ_VAT_TRX_DETAILS.ACCOUNT_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
663 
664 TYPE PERIOD_NAME_TBL  IS TABLE OF
665      JG_ZZ_VAT_TRX_DETAILS.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
666 
667 TYPE TRX_ARAP_BALANCING_SEG_TBL  IS TABLE OF
668      JG_ZZ_VAT_TRX_DETAILS.TRX_ARAP_BALANCING_SEGMENT%TYPE INDEX BY BINARY_INTEGER;
669 
670 TYPE TRX_ARAP_NATURAL_ACCOUNT_TBL  IS TABLE OF
671      JG_ZZ_VAT_TRX_DETAILS.TRX_ARAP_NATURAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
672 
673 TYPE TRX_TAXABLE_BALANCING_SEG_TBL  IS TABLE OF
674      JG_ZZ_VAT_TRX_DETAILS.TRX_TAXABLE_BALANCING_SEGMENT%TYPE INDEX BY BINARY_INTEGER;
675 
676 TYPE TRX_TAXABLE_NATURAL_ACCT_TBL  IS TABLE OF
677      JG_ZZ_VAT_TRX_DETAILS.TRX_TAXABLE_NATURAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
678 
679 TYPE TRX_TAX_BALANCING_SEG_TBL  IS TABLE OF
680      JG_ZZ_VAT_TRX_DETAILS.TRX_TAX_BALANCING_SEGMENT%TYPE INDEX BY BINARY_INTEGER;
681 
682 TYPE TRX_TAX_NATURAL_ACCOUNT_TBL  IS TABLE OF
683      JG_ZZ_VAT_TRX_DETAILS.TRX_TAX_NATURAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
684 
685 TYPE CREATED_BY_TBL  IS TABLE OF
686      JG_ZZ_VAT_TRX_DETAILS.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
687 
688 TYPE CREATION_DATE_TBL  IS TABLE OF
689      JG_ZZ_VAT_TRX_DETAILS.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
690 
691 TYPE LAST_UPDATED_BY_TBL  IS TABLE OF
692      JG_ZZ_VAT_TRX_DETAILS.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
693 
694 TYPE LAST_UPDATE_DATE_TBL  IS TABLE OF
695      JG_ZZ_VAT_TRX_DETAILS.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
696 
697 TYPE LAST_UPDATE_LOGIN_TBL  IS TABLE OF
698      JG_ZZ_VAT_TRX_DETAILS.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;
699 
700 TYPE REQUEST_ID_TBL IS TABLE OF
701   JG_ZZ_VAT_TRX_DETAILS.REQUEST_ID%TYPE INDEX BY BINARY_INTEGER;
702 
703 TYPE PROGRAM_APPLICATION_ID_TBL  IS TABLE OF
704      JG_ZZ_VAT_TRX_DETAILS.PROGRAM_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
705 
706 TYPE PROGRAM_ID_TBL  IS TABLE OF
707      JG_ZZ_VAT_TRX_DETAILS.PROGRAM_ID%TYPE INDEX BY BINARY_INTEGER;
708 
709 TYPE PROGRAM_LOGIN_ID_TBL  IS TABLE OF
710      JG_ZZ_VAT_TRX_DETAILS.PROGRAM_LOGIN_ID%TYPE INDEX BY BINARY_INTEGER;
711 
712 TYPE OBJECT_VERSION_NUMBER  IS TABLE OF
713      JG_ZZ_VAT_TRX_DETAILS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
714 
715 TYPE TAX_ORIGIN_TBL IS TABLE OF
716  JG_ZZ_VAT_TRX_DETAILS.TAX_ORIGIN%TYPE INDEX BY BINARY_INTEGER;
717 
718 TYPE TRX_CONTROL_ACTG_FLEXFIELD_TBL IS TABLE OF
719  JG_ZZ_VAT_TRX_DETAILS.TRX_CONTROL_ACCOUNT_FLEXFIELD%TYPE INDEX BY BINARY_INTEGER;
720 
721 
722 -- BUG 9765740 Spanish Modelo 349 ESL EPL Changes
723 
724 TYPE INTRA_EU_TRX_TYPE_CODE_TBL IS TABLE OF
725  JG_ZZ_VAT_TRX_DETAILS.INTRA_EU_TRX_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
726 
727 
728 TYPE REPORTING_CODE_TBL IS TABLE OF
729  JG_ZZ_VAT_TRX_DETAILS.REPORTING_CODE%TYPE INDEX BY BINARY_INTEGER;
730 
731 TYPE DEF_REC_SETTLEMENT_OP_CODE_TBL IS TABLE OF
735  JG_ZZ_VAT_TRX_DETAILS.TAXABLE_ITEM_SOURCE_ID%TYPE INDEX BY BINARY_INTEGER;
732  JG_ZZ_VAT_TRX_DETAILS.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE INDEX BY BINARY_INTEGER;
733 
734 TYPE TAXABLE_ITEM_SOURCE_ID_TBL IS TABLE OF
736 
737 -----------------------------------------
738 --Public Methods Declarations
739 -----------------------------------------
740 /*===========================================================================+
741  | PROCEDURE                                                                 |
742  |   Main                                                                    |
743  |                                                                           |
744  | DESCRIPTION                                                               |
745  |    This is the main procedure of the JG_ZZ_VAT_SELECTION_PKG, which       |
746  |    populates tax data into JG_ZZ_TRX_DETAILS tables                       |
747  |                                                                           |
748  | SCOPE - Public                                                            |
749  |                                                                           |
750  | NOTES                                                                     |
751  |                                                                           |
752  | MODIFICATION HISTORY                                                      |
753  |                                                                           |
754  +===========================================================================*/
755 
756  PROCEDURE main( errbuf                       OUT NOCOPY VARCHAR2,
757                  retcode                      OUT NOCOPY NUMBER,
758                  p_reporting_level            IN JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE,
759                  p_ledger                     IN JG_ZZ_VAT_REP_ENTITIES.ledger_id%TYPE ,
760                  p_chart_of_account           IN NUMBER,
761                  p_bsv                        IN JG_ZZ_VAT_REP_ENTITIES.balancing_segment_value%TYPE,
762                  p_vat_reporting_entity_id    IN JG_ZZ_VAT_REP_ENTITIES.vat_reporting_entity_id%TYPE,
763                  p_period                     IN JG_ZZ_VAT_REP_STATUS.tax_calendar_period%TYPE,
764                  p_source                     IN JG_ZZ_VAT_REP_STATUS.source%TYPE,
765                  p_acct_unacctd               IN VARCHAR2,
766 		 p_dummy                      IN VARCHAR2,
767                  p_entity_identifier          IN VARCHAR2,
768                  p_debug_flag                 IN VARCHAR2);
769 
770 
771 
772  PROCEDURE purge_tax_data(p_reporting_status_id IN NUMBER,
773 	x_return_status OUT NOCOPY VARCHAR2);
774 
775  FUNCTION purge_tax_data(p_reporting_status_id IN NUMBER) RETURN NUMBER;
776 
777 END JG_ZZ_VAT_SELECTION_PKG;