[Home] [Help]
PACKAGE: APPS.ZX_TEST_API
Source
1 PACKAGE ZX_TEST_API AUTHID CURRENT_USER AS
2 /* $Header: zxitestapispvts.pls 120.15 2006/03/10 02:04:27 appradha ship $ */
3
4 /* ======================================================================*
5 | 'Table' Data Type Definitions |
6 * ======================================================================*/
7
8 TYPE NUMBER_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
9 TYPE DATE_tbl_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
10 TYPE VARCHAR2_1_tbl_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
11 TYPE VARCHAR2_2_tbl_type IS TABLE OF VARCHAR2(2) INDEX BY BINARY_INTEGER;
12 TYPE VARCHAR2_15_tbl_type IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
13 TYPE VARCHAR2_30_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
14 TYPE VARCHAR2_40_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
15 TYPE VARCHAR2_50_tbl_type IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
16 TYPE VARCHAR2_80_tbl_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
17 TYPE VARCHAR2_150_tbl_type IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
18 TYPE VARCHAR2_240_tbl_type IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
19 TYPE VARCHAR2_250_tbl_type IS TABLE OF VARCHAR2(250) INDEX BY BINARY_INTEGER;
20 TYPE VARCHAR2_2000_tbl_type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
21 TYPE surr_trx_id_type_tbl_type IS TABLE OF NUMBER INDEX BY VARCHAR2(1000);
22 TYPE surr_trx_line_id_tbl_type IS TABLE OF NUMBER INDEX BY VARCHAR2(1000);
23 TYPE surr_trx_dist_id_tbl_type IS TABLE OF NUMBER INDEX BY VARCHAR2(1000);
24 TYPE user_keys_segments_tbl_type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
25
26
27 /* ===========================================================*
28 | 'Record' Data Type Definitions |
29 * ===========================================================*/
30
31 TYPE party_rec_type IS RECORD
32 (
33 SHIP_TO_PARTY_TYPE VARCHAR2(30) ,
34 SHIP_FROM_PARTY_TYPE VARCHAR2(30) ,
35 POA_PARTY_TYPE VARCHAR2(30) ,
36 POO_PARTY_TYPE VARCHAR2(30) ,
37 PAYING_PARTY_TYPE VARCHAR2(30) ,
38 OWN_HQ_PARTY_TYPE VARCHAR2(30) ,
39 TRAD_HQ_PARTY_TYPE VARCHAR2(30) ,
40 POI_PARTY_TYPE VARCHAR2(30) ,
41 POD_PARTY_TYPE VARCHAR2(30) ,
42 BILL_TO_PARTY_TYPE VARCHAR2(30) ,
43 BILL_FROM_PARTY_TYPE VARCHAR2(30) ,
44 TTL_TRNS_PARTY_TYPE VARCHAR2(30) ,
45 MERCHANT_PARTY_TYPE VARCHAR2(30) ,
46 THIRD_PARTY_TYPE VARCHAR2(30) ,
47 SHIP_TO_PTY_SITE_TYPE VARCHAR2(30) ,
48 SHIP_FROM_PTY_SITE_TYPE VARCHAR2(30) ,
49 POA_PTY_SITE_TYPE VARCHAR2(30) ,
50 POO_PTY_SITE_TYPE VARCHAR2(30) ,
51 PAYING_PTY_SITE_TYPE VARCHAR2(30) ,
52 OWN_HQ_PTY_SITE_TYPE VARCHAR2(30) ,
53 TRAD_HQ_PTY_SITE_TYPE VARCHAR2(30) ,
54 POI_PTY_SITE_TYPE VARCHAR2(30) ,
55 POD_PTY_SITE_TYPE VARCHAR2(30) ,
56 BILL_TO_PTY_SITE_TYPE VARCHAR2(30) ,
57 BILL_FROM_PTY_SITE_TYPE VARCHAR2(30) ,
58 TTL_TRNS_PTY_SITE_TYPE VARCHAR2(30) ,
59 PROD_FAMILY_GRP_CODE VARCHAR2(30));
60
61
62 /* ======================================================================*
63 | 'Record of Tables' Data Type Definitions |
64 * ======================================================================*/
65
66 TYPE suite_rec_tbl_type IS RECORD (
67 ROW_ID NUMBER_tbl_type ,
68 ROW_SUITE VARCHAR2_30_tbl_type ,
69 ROW_CASE VARCHAR2_30_tbl_type ,
70 ROW_API VARCHAR2_80_tbl_type ,
71 ROW_SERVICE VARCHAR2_80_tbl_type ,
72 ROW_STRUCTURE VARCHAR2_80_tbl_type ,
73 INTERNAL_ORGANIZATION_ID NUMBER_tbl_type ,
74 INTERNAL_ORG_LOCATION_ID NUMBER_tbl_type ,
75 FIRST_PARTY_ORG_ID NUMBER_tbl_type ,
76 APPLICATION_ID NUMBER_tbl_type ,
77 ENTITY_CODE VARCHAR2_30_tbl_type ,
78 EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
79 TAX_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
80 DOC_EVENT_STATUS VARCHAR2_30_tbl_type ,
81 TAX_HOLD_RELEASED_CODE VARCHAR2_30_tbl_type ,
82 EVENT_TYPE_CODE VARCHAR2_30_tbl_type ,
83 TRX_ID NUMBER_tbl_type ,
84 OVERRIDE_LEVEL VARCHAR2_30_tbl_type ,
85 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
86 TRX_LINE_ID NUMBER_tbl_type ,
87 TRX_WAYBILL_NUMBER VARCHAR2_50_tbl_type ,
88 TRX_LINE_DESCRIPTION VARCHAR2_240_tbl_type ,
89 PRODUCT_DESCRIPTION VARCHAR2_240_tbl_type ,
90 TAX_LINE_ID NUMBER_tbl_type ,
91 APPLIED_FROM_DIST_ID NUMBER_tbl_type ,
92 FIRST_PTY_ORG_ID NUMBER_tbl_type ,
93 SUMMARY_TAX_LINE_ID NUMBER_tbl_type ,
94 INVOICE_PRICE_VARIANCE NUMBER_tbl_type ,
95 RDNG_SHIP_TO_PTY_TX_PROF_ID NUMBER_tbl_type ,
96 RDNG_SHIP_FROM_PTY_TX_PROF_ID NUMBER_tbl_type ,
97 RDNG_BILL_TO_PTY_TX_PROF_ID NUMBER_tbl_type ,
98 RDNG_BILL_FROM_PTY_TX_PROF_ID NUMBER_tbl_type ,
99 RDNG_SHIP_TO_PTY_TX_P_ST_ID NUMBER_tbl_type ,
100 RDNG_SHIP_FROM_PTY_TX_P_ST_ID NUMBER_tbl_type ,
101 RDNG_BILL_TO_PTY_TX_P_ST_ID NUMBER_tbl_type ,
102 RDNG_BILL_FROM_PTY_TX_P_ST_ID NUMBER_tbl_type ,
103 LINE_LEVEL_ACTION VARCHAR2_30_tbl_type ,
104 TAX_CLASSIFICATION_CODE VARCHAR2_80_tbl_type ,
105 TRX_DATE DATE_tbl_type ,
106 TRX_DOC_REVISION VARCHAR2_150_tbl_type ,
107 LEDGER_ID NUMBER_tbl_type ,
108 TAX_RATE_ID NUMBER_tbl_type ,
109 TRX_CURRENCY_CODE VARCHAR2_15_tbl_type ,
110 CURRENCY_CONVERSION_DATE DATE_tbl_type ,
111 CURRENCY_CONVERSION_RATE NUMBER_tbl_type ,
112 CURRENCY_CONVERSION_TYPE VARCHAR2_30_tbl_type ,
113 MINIMUM_ACCOUNTABLE_UNIT NUMBER_tbl_type ,
114 PRECISION NUMBER_tbl_type ,
115 TRX_SHIPPING_DATE DATE_tbl_type ,
116 TRX_RECEIPT_DATE DATE_tbl_type ,
117 LEGAL_ENTITY_ID NUMBER_tbl_type ,
118 REVERSING_APPLN_ID NUMBER_tbl_type ,
119 ROUNDING_SHIP_TO_PARTY_ID NUMBER_tbl_type ,
120 ROUNDING_SHIP_FROM_PARTY_ID NUMBER_tbl_type ,
121 ROUNDING_BILL_TO_PARTY_ID NUMBER_tbl_type ,
122 ROUNDING_BILL_FROM_PARTY_ID NUMBER_tbl_type ,
123 RNDG_SHIP_TO_PARTY_SITE_ID NUMBER_tbl_type ,
124 RNDG_SHIP_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
125 RNDG_BILL_TO_PARTY_SITE_ID NUMBER_tbl_type ,
126 RNDG_BILL_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
127 ESTABLISHMENT_ID NUMBER_tbl_type ,
128 TAX_EXEMPTION_ID NUMBER_tbl_type ,
129 REC_NREC_TAX_DIST_ID NUMBER_tbl_type ,
130 TAX_APPORTIONMENT_LINE_NUMBER NUMBER_tbl_type ,
131 EXEMPTION_RATE NUMBER_tbl_type ,
132 TOTAL_NREC_TAX_AMT NUMBER_tbl_type ,
133 TOTAL_REC_TAX_AMT NUMBER_tbl_type ,
134 REC_TAX_AMT NUMBER_tbl_type ,
135 NREC_TAX_AMT NUMBER_tbl_type ,
136 MERCHANT_PARTY_DOCUMENT_NUMBER NUMBER_tbl_type ,
137 TRX_LINE_TYPE VARCHAR2_30_tbl_type ,
138 TAX_REGISTRATION_NUMBER VARCHAR2_50_tbl_type ,
139 CTRL_TOTAL_HDR_TX_AMT NUMBER_tbl_type ,
140 EXEMPT_REASON_CODE VARCHAR2_30_tbl_type ,
141 TAX_HOLD_CODE VARCHAR2_30_tbl_type ,
142 TAX_AMT_FUNCL_CURR NUMBER_tbl_type ,
143 TOTAL_REC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type ,
144 TOTAL_NREC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type ,
145 TAXABLE_AMT_FUNCL_CURR NUMBER_tbl_type ,
146 REC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type ,
147 NREC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type ,
148 TRX_LINE_DATE DATE_tbl_type ,
149 TRX_BUSINESS_CATEGORY VARCHAR2_240_tbl_type ,
150 LINE_INTENDED_USE VARCHAR2_240_tbl_type ,
151 USER_DEFINED_FISC_CLASS VARCHAR2_30_tbl_type ,
152 TAX_LINE_NUMBER NUMBER_tbl_type ,
153 TAX_CODE VARCHAR2_30_tbl_type ,
154 TAX_INCLUSION_FLAG VARCHAR2_1_tbl_type ,
155 TAX_AMT_INCLUDED_FLAG VARCHAR2_1_tbl_type ,
156 SELF_ASSESSED_FLAG VARCHAR2_1_tbl_type ,
157 QUOTE_FLAG VARCHAR2_1_tbl_type ,
158 HISTORICAL_FLAG VARCHAR2_1_tbl_type ,
159 MANUALLY_ENTERED_FLAG VARCHAR2_1_tbl_type ,
160 LINE_AMT NUMBER_tbl_type ,
161 TRX_LINE_QUANTITY NUMBER_tbl_type ,
162 UNIT_PRICE NUMBER_tbl_type ,
163 EXEMPT_CERTIFICATE_NUMBER VARCHAR2_30_tbl_type ,
164 EXEMPT_REASON VARCHAR2_240_tbl_type ,
165 DEFAULT_TAXATION_COUNTRY VARCHAR2_2_tbl_type ,
166 CASH_DISCOUNT NUMBER_tbl_type ,
167 VOLUME_DISCOUNT NUMBER_tbl_type ,
168 TRADING_DISCOUNT NUMBER_tbl_type ,
169 TRANSFER_CHARGE NUMBER_tbl_type ,
170 TRANSPORTATION_CHARGE NUMBER_tbl_type ,
171 INSURANCE_CHARGE NUMBER_tbl_type ,
172 OTHER_CHARGE NUMBER_tbl_type ,
173 PRODUCT_ID NUMBER_tbl_type ,
174 PRODUCT_FISC_CLASSIFICATION VARCHAR2_240_tbl_type ,
175 PRODUCT_ORG_ID NUMBER_tbl_type ,
176 UOM_CODE VARCHAR2_30_tbl_type ,
177 PRODUCT_TYPE VARCHAR2_30_tbl_type ,
178 PRODUCT_CODE VARCHAR2_40_tbl_type ,
179 PRODUCT_CATEGORY VARCHAR2_240_tbl_type ,
180 TRX_SIC_CODE VARCHAR2_150_tbl_type ,
181 FOB_POINT VARCHAR2_30_tbl_type ,
182 SHIP_TO_PARTY_ID NUMBER_tbl_type ,
183 SHIP_FROM_PARTY_ID NUMBER_tbl_type ,
184 POA_PARTY_ID NUMBER_tbl_type ,
185 POO_PARTY_ID NUMBER_tbl_type ,
186 BILL_TO_PARTY_ID NUMBER_tbl_type ,
187 BILL_FROM_PARTY_ID NUMBER_tbl_type ,
188 MERCHANT_PARTY_ID NUMBER_tbl_type ,
189 SHIP_TO_PARTY_SITE_ID NUMBER_tbl_type ,
190 SHIP_TO_SITE_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
191 SHIP_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
192 POA_PARTY_SITE_ID NUMBER_tbl_type ,
193 POO_PARTY_SITE_ID NUMBER_tbl_type ,
194 BILL_TO_PARTY_SITE_ID NUMBER_tbl_type ,
195 BILL_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
196 SHIP_TO_LOCATION_ID NUMBER_tbl_type ,
197 SHIP_FROM_LOCATION_ID NUMBER_tbl_type ,
198 POA_LOCATION_ID NUMBER_tbl_type ,
199 POO_LOCATION_ID NUMBER_tbl_type ,
200 BILL_TO_LOCATION_ID NUMBER_tbl_type ,
201 BILL_FROM_LOCATION_ID NUMBER_tbl_type ,
202 ACCOUNT_CCID NUMBER_tbl_type ,
203 REVERSING_TAX_LINE_ID NUMBER_tbl_type ,
204 ACCOUNT_STRING VARCHAR2_2000_tbl_type ,
205 MERCHANT_PARTY_COUNTRY VARCHAR2_150_tbl_type ,
206 RECEIVABLES_TRX_TYPE_ID NUMBER_tbl_type ,
207 REF_DOC_APPLICATION_ID NUMBER_tbl_type ,
208 REF_DOC_ENTITY_CODE VARCHAR2_30_tbl_type ,
209 REF_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
210 REF_DOC_TRX_ID NUMBER_tbl_type ,
211 REF_DOC_LINE_ID NUMBER_tbl_type ,
212 REF_DOC_LINE_QUANTITY NUMBER_tbl_type ,
213 RELATED_DOC_APPLICATION_ID NUMBER_tbl_type ,
214 RELATED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type ,
215 RELATED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
216 RELATED_DOC_TRX_ID NUMBER_tbl_type ,
217 RELATED_DOC_NUMBER VARCHAR2_150_tbl_type ,
218 RELATED_DOC_DATE DATE_tbl_type ,
219 APPLIED_FROM_APPLICATION_ID NUMBER_tbl_type ,
220 APPLIED_FROM_ENTITY_CODE VARCHAR2_30_tbl_type ,
221 APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
222 APPLIED_FROM_TRX_ID NUMBER_tbl_type ,
223 APPLIED_FROM_LINE_ID NUMBER_tbl_type ,
224 ADJUSTED_DOC_APPLICATION_ID NUMBER_tbl_type ,
225 ADJUSTED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type ,
226 ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
227 ADJUSTED_DOC_TRX_ID NUMBER_tbl_type ,
228 ADJUSTED_DOC_LINE_ID NUMBER_tbl_type ,
229 ADJUSTED_DOC_NUMBER VARCHAR2_150_tbl_type ,
230 ASSESSABLE_VALUE NUMBER_tbl_type ,
231 ADJUSTED_DOC_DATE DATE_tbl_type ,
232 APPLIED_TO_APPLICATION_ID NUMBER_tbl_type ,
233 APPLIED_TO_ENTITY_CODE VARCHAR2_30_tbl_type ,
234 APPLIED_TO_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
235 APPLIED_TO_TRX_ID NUMBER_tbl_type ,
236 APPLIED_TO_TRX_LINE_ID NUMBER_tbl_type ,
237 TRX_LINE_NUMBER NUMBER_tbl_type ,
238 TRX_NUMBER VARCHAR2_150_tbl_type ,
239 TRX_DESCRIPTION VARCHAR2_240_tbl_type ,
240 TRX_COMMUNICATED_DATE DATE_tbl_type ,
241 TRX_LINE_GL_DATE DATE_tbl_type ,
242 BATCH_SOURCE_ID NUMBER_tbl_type ,
243 BATCH_SOURCE_NAME VARCHAR2_150_tbl_type ,
244 DOC_SEQ_ID NUMBER_tbl_type ,
245 DOC_SEQ_NAME VARCHAR2_150_tbl_type ,
246 DOC_SEQ_VALUE VARCHAR2_150_tbl_type ,
247 TRX_DUE_DATE DATE_tbl_type ,
248 TRX_TYPE_DESCRIPTION VARCHAR2_240_tbl_type ,
249 VALIDATION_CHECK_FLAG VARCHAR2_1_tbl_type ,
250 MERCHANT_PARTY_NAME VARCHAR2_150_tbl_type ,
251 MERCHANT_PARTY_REFERENCE VARCHAR2_250_tbl_type ,
252 MERCHANT_PARTY_TAXPAYER_ID VARCHAR2_150_tbl_type ,
253 MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2_150_tbl_type ,
254 DOCUMENT_SUB_TYPE VARCHAR2_240_tbl_type ,
255 SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2_150_tbl_type ,
256 SUPPLIER_TAX_INVOICE_DATE DATE_tbl_type ,
257 SUPPLIER_EXCHANGE_RATE NUMBER_tbl_type ,
258 EXCHANGE_RATE_VARIANCE NUMBER_tbl_type ,
259 BASE_INVOICE_PRICE_VARIANCE NUMBER_tbl_type ,
260 TAX_INVOICE_DATE DATE_tbl_type ,
261 TAX_INVOICE_NUMBER VARCHAR2_150_tbl_type ,
262 SUMMARY_TAX_LINE_NUMBER NUMBER_tbl_type ,
263 TAX_REGIME_CODE VARCHAR2_30_tbl_type ,
264 TAX_JURISDICTION_ID NUMBER_tbl_type ,
265 TAX VARCHAR2_30_tbl_type ,
266 TAX_STATUS_CODE VARCHAR2_150_tbl_type ,
267 RECOVERY_TYPE_CODE VARCHAR2_30_tbl_type ,
268 RECOVERY_RATE_CODE VARCHAR2_30_tbl_type ,
269 TAX_RATE_CODE VARCHAR2_150_tbl_type ,
270 RECOVERABLE_FLAG VARCHAR2_1_tbl_type ,
271 FREEZE_FLAG VARCHAR2_1_tbl_type ,
272 POSTING_FLAG VARCHAR2_1_tbl_type ,
273 TAX_RATE NUMBER_tbl_type ,
274 TAX_AMT NUMBER_tbl_type ,
275 REC_NREC_TAX_AMT NUMBER_tbl_type ,
276 TAXABLE_AMT NUMBER_tbl_type ,
277 REC_NREC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type ,
278 REC_NREC_CCID NUMBER_tbl_type ,
279 REVERSING_ENTITY_CODE VARCHAR2_30_tbl_type ,
280 REVERSING_EVNT_CLS_CODE VARCHAR2_30_tbl_type ,
281 REVERSING_TRX_ID NUMBER_tbl_type ,
282 REVERSING_TRX_LINE_DIST_ID NUMBER_tbl_type ,
283 REVERSING_TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
284 REVERSING_TRX_LINE_ID NUMBER_tbl_type ,
285 REVERSED_APPLN_ID NUMBER_tbl_type ,
286 REVERSED_ENTITY_CODE VARCHAR2_30_tbl_type ,
287 REVERSED_EVNT_CLS_CODE VARCHAR2_30_tbl_type ,
288 REVERSED_TRX_ID NUMBER_tbl_type ,
289 REVERSED_TRX_LEVEL_TYPE NUMBER_tbl_type ,
290 REVERSED_TRX_LINE_ID NUMBER_tbl_type ,
291 REVERSED_TRX_LINE_DIST_ID NUMBER_tbl_type ,
292 REVERSE_FLAG VARCHAR2_1_tbl_type ,
293 CANCEL_FLAG VARCHAR2_1_tbl_type ,
294 TRX_LINE_DIST_ID NUMBER_tbl_type ,
295 REVERSED_TAX_DIST_ID NUMBER_tbl_type ,
296 DIST_LEVEL_ACTION VARCHAR2_30_tbl_type ,
297 TRX_LINE_DIST_DATE DATE_tbl_type ,
298 ITEM_DIST_NUMBER NUMBER_tbl_type ,
299 DIST_INTENDED_USE VARCHAR2_240_tbl_type ,
300 TASK_ID NUMBER_tbl_type ,
301 AWARD_ID NUMBER_tbl_type ,
302 PROJECT_ID NUMBER_tbl_type ,
303 EXPENDITURE_TYPE VARCHAR2_30_tbl_type ,
304 EXPENDITURE_ORGANIZATION_ID NUMBER_tbl_type ,
305 EXPENDITURE_ITEM_DATE DATE_tbl_type ,
306 TRX_LINE_DIST_AMT NUMBER_tbl_type ,
307 TRX_LINE_DIST_QUANTITY NUMBER_tbl_type ,
308 REF_DOC_DIST_ID NUMBER_tbl_type ,
309 REF_DOC_CURR_CONV_RATE NUMBER_tbl_type ,
310 TAX_DIST_ID NUMBER_tbl_type ,
311 LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2_1_tbl_type ,
312 OWN_HQ_PARTY_ID NUMBER_tbl_type ,
313 TAX_EVENT_TYPE_CODE VARCHAR2_80_tbl_type ,
314 LINE_CLASS VARCHAR2_30_tbl_type ,
315 TRX_ID_LEVEL2 VARCHAR2_150_tbl_type ,
316 TRX_ID_LEVEL3 VARCHAR2_150_tbl_type ,
317 TRX_ID_LEVEL4 VARCHAR2_150_tbl_type ,
318 TRX_ID_LEVEL5 VARCHAR2_150_tbl_type ,
319 TRX_ID_LEVEL6 VARCHAR2_150_tbl_type ,
320 PAYING_PARTY_ID NUMBER_TBL_TYPE ,
321 TRADING_HQ_PARTY_ID NUMBER_TBL_TYPE ,
322 POI_PARTY_ID NUMBER_TBL_TYPE ,
323 POD_PARTY_ID NUMBER_TBL_TYPE ,
324 TITLE_TRANSFER_PARTY_ID NUMBER_TBL_TYPE ,
325 PAYING_PARTY_SITE_ID NUMBER_TBL_TYPE ,
326 OWN_HQ_PARTY_SITE_ID NUMBER_TBL_TYPE ,
327 TRADING_HQ_PARTY_SITE_ID NUMBER_TBL_TYPE ,
328 POI_PARTY_SITE_ID NUMBER_TBL_TYPE ,
329 POD_PARTY_SITE_ID NUMBER_TBL_TYPE ,
330 TITLE_TRANSFER_PARTY_SITE_ID NUMBER_TBL_TYPE ,
331 PAYING_LOCATION_ID NUMBER_TBL_TYPE ,
332 OWN_HQ_LOCATION_ID NUMBER_TBL_TYPE ,
333 TRADING_HQ_LOCATION_ID NUMBER_TBL_TYPE ,
334 POC_LOCATION_ID NUMBER_TBL_TYPE ,
335 POI_LOCATION_ID NUMBER_TBL_TYPE ,
336 POD_LOCATION_ID NUMBER_TBL_TYPE ,
337 TITLE_TRANSFER_LOCATION_ID NUMBER_TBL_TYPE ,
338 ASSET_FLAG VARCHAR2_1_TBL_TYPE ,
339 ASSET_NUMBER VARCHAR2_150_TBL_TYPE ,
340 ASSET_ACCUM_DEPRECIATION NUMBER_TBL_TYPE ,
341 ASSET_TYPE VARCHAR2_150_TBL_TYPE ,
342 ASSET_COST NUMBER_TBL_TYPE ,
343 SHIP_TO_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
344 SHIP_FROM_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
345 POA_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
346 POO_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
347 PAYING_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
348 OWN_HQ_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
349 TRADING_HQ_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
350 POI_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
351 POD_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
352 BILL_TO_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
353 BILL_FROM_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
354 TITLE_TRANS_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
355 SHIP_TO_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
356 SHIP_FROM_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
357 POA_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
358 POO_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
359 PAYING_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
360 OWN_HQ_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
361 TRADING_HQ_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
362 POI_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
363 POD_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
364 BILL_TO_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
365 BILL_FROM_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
366 TITLE_TRANS_SITE_TAX_PROF_ID NUMBER_TBL_TYPE ,
367 MERCHANT_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
368 HQ_ESTB_PARTY_TAX_PROF_ID NUMBER_TBL_TYPE ,
369 CTRL_HDR_TX_APPL_FLAG VARCHAR2_1_TBL_TYPE ,
370 CTRL_TOTAL_LINE_TX_AMT NUMBER_TBL_TYPE ,
371 TAX_JURISDICTION_CODE VARCHAR2_30_TBL_TYPE ,
372 TAX_PROVIDER_ID NUMBER_TBL_TYPE ,
373 TAX_EXCEPTION_ID NUMBER_TBL_TYPE ,
374 TAX_LINE_ALLOCATION_FLAG VARCHAR2_1_TBL_TYPE ,
375 REVERSED_TAX_LINE_ID NUMBER_TBL_TYPE ,
376 APPLIED_FROM_TAX_DIST_ID NUMBER_TBL_TYPE ,
377 ADJUSTED_DOC_TAX_DIST_ID NUMBER_TBL_TYPE ,
378 TRX_LINE_DIST_TAX_AMT NUMBER_TBL_TYPE ,
379 ADJUSTED_DOC_DIST_ID NUMBER_TBL_TYPE ,
380 APPLIED_TO_DOC_CURR_CONV_RATE NUMBER_TBL_TYPE ,
381 TAX_VARIANCE_CALC_FLAG VARCHAR2_1_TBL_TYPE ,
382 PORT_OF_ENTRY_CODE VARCHAR2_30_TBL_TYPE ,
383 SHIP_THIRD_PTY_ACCT_ID NUMBER_TBL_TYPE ,
384 BILL_THIRD_PTY_ACCT_ID NUMBER_TBL_TYPE ,
385 SHIP_THIRD_PTY_ACCT_SITE_ID NUMBER_TBL_TYPE ,
386 BILL_THIRD_PTY_ACCT_SITE_ID NUMBER_TBL_TYPE ,
387 BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER_TBL_TYPE ,
388 SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER_TBL_TYPE ,
389 --BUG 4477978. Added Source Columns
390 SOURCE_APPLICATION_ID NUMBER_TBL_TYPE ,
391 SOURCE_ENTITY_CODE VARCHAR2_30_TBL_TYPE ,
392 SOURCE_EVENT_CLASS_CODE VARCHAR2_30_TBL_TYPE ,
393 SOURCE_TRX_ID NUMBER_TBL_TYPE ,
394 SOURCE_LINE_ID NUMBER_TBL_TYPE ,
395 SOURCE_TRX_LEVEL_TYPE VARCHAR2_30_TBL_TYPE ,
396 SOURCE_TAX_LINE_ID NUMBER_TBL_TYPE);
397
398 TYPE zx_lines_rec_tbl_type IS RECORD (
399 TAX_LINE_ID NUMBER_tbl_type,
400 INTERNAL_ORGANIZATION_ID NUMBER_tbl_type,
401 APPLICATION_ID NUMBER_tbl_type,
402 ENTITY_CODE VARCHAR2_30_tbl_type,
403 EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
404 EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
405 LINE_LEVEL_ACTION VARCHAR2_30_tbl_type,
406 DOC_EVENT_STATUS VARCHAR2_30_tbl_type,
407 LINE_EVENT_STATUS VARCHAR2_30_tbl_type,
408 TAX_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
409 TAX_EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
410 TRX_ID NUMBER_tbl_type,
411 TRX_LINE_ID NUMBER_tbl_type,
412 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type,
413 TRX_LINE_NUMBER NUMBER_tbl_type,
414 TAX_LINE_NUMBER NUMBER_tbl_type,
415 CONTENT_OWNER_ID NUMBER_tbl_type,
416 TAX_REGIME_ID NUMBER_tbl_type,
417 TAX_REGIME_CODE VARCHAR2_30_tbl_type,
418 TAX_ID NUMBER_tbl_type,
419 TAX VARCHAR2_30_tbl_type,
420 TAX_STATUS_ID NUMBER_tbl_type,
421 TAX_STATUS_CODE VARCHAR2_30_tbl_type,
422 TAX_RATE_ID NUMBER_tbl_type,
423 TAX_RATE_CODE VARCHAR2_30_tbl_type,
424 TAX_RATE NUMBER_tbl_type,
425 TAX_APPORTIONMENT_LINE_NUMBER NUMBER_tbl_type,
426 TRX_ID_LEVEL2 NUMBER_tbl_type,
427 TRX_ID_LEVEL3 NUMBER_tbl_type,
428 TRX_ID_LEVEL4 NUMBER_tbl_type,
429 TRX_ID_LEVEL5 NUMBER_tbl_type,
430 TRX_ID_LEVEL6 NUMBER_tbl_type,
431 TRX_USER_KEY_LEVEL1 VARCHAR2_150_tbl_type,
432 TRX_USER_KEY_LEVEL2 VARCHAR2_150_tbl_type,
433 TRX_USER_KEY_LEVEL3 VARCHAR2_150_tbl_type,
434 TRX_USER_KEY_LEVEL4 VARCHAR2_150_tbl_type,
435 TRX_USER_KEY_LEVEL5 VARCHAR2_150_tbl_type,
436 TRX_USER_KEY_LEVEL6 VARCHAR2_150_tbl_type,
437 LEDGER_ID NUMBER_tbl_type,
438 ESTABLISHMENT_ID NUMBER_tbl_type,
439 LEGAL_ENTITY_ID NUMBER_tbl_type,
440 HQ_ESTB_REG_NUMBER VARCHAR2_30_tbl_type,
441 HQ_ESTB_PARTY_TAX_PROF_ID NUMBER_tbl_type,
442 TRX_DOC_REVISION VARCHAR2_150_tbl_type,
443 CURRENCY_CONVERSION_DATE DATE_tbl_type,
444 CURRENCY_CONVERSION_TYPE VARCHAR2_30_tbl_type,
445 CURRENCY_CONVERSION_RATE NUMBER_tbl_type,
446 TAX_CURRENCY_CONVERSION_DATE DATE_tbl_type,
447 TAX_CURRENCY_CONVERSION_TYPE VARCHAR2_30_tbl_type,
448 TAX_CURRENCY_CONVERSION_RATE NUMBER_tbl_type,
449 TRX_CURRENCY_CODE VARCHAR2_15_tbl_type,
450 MINIMUM_ACCOUNTABLE_UNIT NUMBER_tbl_type,
451 PRECISION NUMBER_tbl_type,
452 TRX_NUMBER VARCHAR2_150_tbl_type,
453 TRX_DESCRIPTION VARCHAR2_240_tbl_type,
454 DOC_SEQ_ID NUMBER_tbl_type,
455 DOC_SEQ_NAME VARCHAR2_150_tbl_type,
456 DOC_SEQ_VALUE NUMBER_tbl_type,
457 TRX_DATE DATE_tbl_type,
458 RECEIVABLES_TRX_TYPE_ID NUMBER_tbl_type,
459 TRX_TYPE_DESCRIPTION VARCHAR2_240_tbl_type,
460 TRX_LINE_TYPE VARCHAR2_30_tbl_type,
461 TRX_DUE_DATE DATE_tbl_type,
462 TRX_SHIPPING_DATE DATE_tbl_type,
463 TRX_RECEIPT_DATE DATE_tbl_type,
464 TRX_COMMUNICATED_DATE DATE_tbl_type,
465 BATCH_SOURCE_NAME VARCHAR2_150_tbl_type,
466 BATCH_SOURCE_ID NUMBER_tbl_type,
467 TRX_SIC_CODE VARCHAR2_150_tbl_type,
468 FOB_POINT VARCHAR2_30_tbl_type,
469 TRX_LINE_DESCRIPTION VARCHAR2_240_tbl_type,
470 TRX_WAYBILL_NUMBER VARCHAR2_50_tbl_type,
471 PRODUCT_ID NUMBER_tbl_type,
472 PRODUCT_TYPE VARCHAR2_30_tbl_type,
473 PRODUCT_DESCRIPTION VARCHAR2_240_tbl_type,
474 PRODUCT_ORG_ID NUMBER_tbl_type,
475 PRODUCT_CATEGORY VARCHAR2_240_tbl_type,
476 UOM_CODE VARCHAR2_30_tbl_type,
477 PRODUCT_CODE VARCHAR2_30_tbl_type,
478 PRODUCT_FISC_CLASSIFICATION VARCHAR2_240_tbl_type,
479 USER_DEFINED_FISC_CLASS VARCHAR2_30_tbl_type,
480 LINE_INTENDED_USE VARCHAR2_240_tbl_type,
481 UNIT_PRICE NUMBER_tbl_type,
482 LINE_AMT NUMBER_tbl_type,
483 TRX_LINE_QUANTITY NUMBER_tbl_type,
484 CASH_DISCOUNT NUMBER_tbl_type,
485 VOLUME_DISCOUNT NUMBER_tbl_type,
486 TRADING_DISCOUNT NUMBER_tbl_type,
487 TRANSFER_CHARGE NUMBER_tbl_type,
488 TRANSPORTATION_CHARGE NUMBER_tbl_type,
489 INSURANCE_CHARGE NUMBER_tbl_type,
490 OTHER_CHARGE NUMBER_tbl_type,
491 TAX_BASE_MODIFIER_RATE NUMBER_tbl_type,
492 ASSESSABLE_VALUE NUMBER_tbl_type,
493 ASSET_NUMBER VARCHAR2_150_tbl_type,
494 ASSET_TYPE VARCHAR2_150_tbl_type,
495 ASSET_COST NUMBER_tbl_type,
496 ASSET_FLAG VARCHAR2_1_tbl_type,
497 ASSET_ACCUM_DEPRECIATION NUMBER_tbl_type,
498 REF_DOC_APPLICATION_ID NUMBER_tbl_type,
499 REF_DOC_ENTITY_CODE VARCHAR2_30_tbl_type,
500 REF_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
501 REF_DOC_EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
502 REF_DOC_TRX_ID NUMBER_tbl_type,
503 REF_DOC_LINE_ID NUMBER_tbl_type,
504 REF_DOC_LINE_QUANTITY NUMBER_tbl_type,
505 OTHER_DOC_LINE_AMT NUMBER_tbl_type,
506 OTHER_DOC_LINE_TAX_AMT NUMBER_tbl_type,
507 OTHER_DOC_LINE_TAXABLE_AMT NUMBER_tbl_type,
508 UNROUNDED_TAXABLE_AMT NUMBER_tbl_type,
509 RELATED_DOC_APPLICATION_ID NUMBER_tbl_type,
510 RELATED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type,
511 RELATED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
512 RELATED_DOC_EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
513 RELATED_DOC_TRX_ID NUMBER_tbl_type,
514 RELATED_DOC_NUMBER VARCHAR2_150_tbl_type,
515 RELATED_DOC_DATE DATE_tbl_type,
516 APPLIED_FROM_APPLICATION_ID NUMBER_tbl_type,
517 APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
518 APPLIED_FROM_ENTITY_CODE VARCHAR2_30_tbl_type,
519 APPLIED_FROM_TRX_ID NUMBER_tbl_type,
520 APPLIED_FROM_LINE_ID NUMBER_tbl_type,
521 APPLIED_FROM_TRX_NUMBER VARCHAR2_150_tbl_type,
522 ADJUSTED_DOC_APPLICATION_ID NUMBER_tbl_type,
523 ADJUSTED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type,
524 ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
525 ADJUSTED_DOC_TRX_ID NUMBER_tbl_type,
526 ADJUSTED_DOC_LINE_ID NUMBER_tbl_type,
527 ADJUSTED_DOC_NUMBER VARCHAR2_150_tbl_type,
528 ADJUSTED_DOC_DATE DATE_tbl_type,
529 APPLIED_TO_APPLICATION_ID NUMBER_tbl_type,
530 APPLIED_TO_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
531 APPLIED_TO_ENTITY_CODE VARCHAR2_30_tbl_type,
532 APPLIED_TO_TRX_ID NUMBER_tbl_type,
533 APPLIED_TO_TRX_LINE_ID NUMBER_tbl_type,
534 SUMMARY_TAX_LINE_ID NUMBER_tbl_type,
535 OFFSET_LINK_TO_TAX_LINE_ID NUMBER_tbl_type,
536 OFFSET_FLAG VARCHAR2_1_tbl_type,
537 PROCESS_FOR_RECOVERY_FLAG VARCHAR2_1_tbl_type,
538 TAX_JURISDICTION_ID NUMBER_tbl_type,
539 TAX_JURISDICTION_CODE VARCHAR2_240_tbl_type,
540 PLACE_OF_SUPPLY NUMBER_tbl_type,
541 PLACE_OF_SUPPLY_TYPE VARCHAR2_30_tbl_type,
542 PLACE_OF_SUPPLY_RESULT_ID NUMBER_tbl_type,
543 TAX_DATE_RULE_ID NUMBER_tbl_type,
544 TAX_DATE DATE_tbl_type,
545 TAX_DETERMINE_DATE DATE_tbl_type,
546 TAX_POINT_DATE DATE_tbl_type,
547 TRX_LINE_DATE DATE_tbl_type,
548 TAX_TYPE_CODE VARCHAR2_30_tbl_type,
549 TAX_CODE VARCHAR2_30_tbl_type,
550 TAX_REGISTRATION_ID NUMBER_tbl_type,
551 TAX_REGISTRATION_NUMBER VARCHAR2_50_tbl_type,
552 REGISTRATION_PARTY_TYPE VARCHAR2_30_tbl_type,
553 ROUNDING_LEVEL VARCHAR2_30_tbl_type,
554 ROUNDING_RULE VARCHAR2_30_tbl_type,
555 ROUNDING_LVL_PARTY_TAX_PROF_ID NUMBER_tbl_type,
556 ROUNDING_LVL_PARTY_TYPE VARCHAR2_30_tbl_type,
557 COMPOUNDING_TAX_FLAG VARCHAR2_1_tbl_type,
558 TRX_BUSINESS_CATEGORY VARCHAR2_240_tbl_type,
559 ORIG_TAX_STATUS_ID NUMBER_tbl_type,
560 ORIG_TAX_STATUS_CODE VARCHAR2_30_tbl_type,
561 ORIG_TAX_RATE_ID NUMBER_tbl_type,
562 ORIG_TAX_RATE_CODE VARCHAR2_30_tbl_type,
563 ORIG_TAX_RATE NUMBER_tbl_type,
564 TAX_CURRENCY_CODE VARCHAR2_15_tbl_type,
565 TAX_AMT NUMBER_tbl_type,
566 TAX_AMT_TAX_CURR NUMBER_tbl_type,
567 TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
568 TAXABLE_AMT NUMBER_tbl_type,
569 TAXABLE_AMT_TAX_CURR NUMBER_tbl_type,
570 TAXABLE_AMT_FUNCL_CURR NUMBER_tbl_type,
571 ORIG_TAXABLE_AMT NUMBER_tbl_type,
572 ORIG_TAXABLE_AMT_TAX_CURR NUMBER_tbl_type,
573 ORIG_TAXABLE_AMT_FUNCL_CURR NUMBER_tbl_type,
574 CAL_TAX_AMT NUMBER_tbl_type,
575 CAL_TAX_AMT_TAX_CURR NUMBER_tbl_type,
576 CAL_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
577 ORIG_TAX_AMT NUMBER_tbl_type,
578 ORIG_TAX_AMT_TAX_CURR NUMBER_tbl_type,
579 ORIG_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
580 REC_TAX_AMT NUMBER_tbl_type,
581 REC_TAX_AMT_TAX_CURR NUMBER_tbl_type,
582 REC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
583 NREC_TAX_AMT NUMBER_tbl_type,
584 NREC_TAX_AMT_TAX_CURR NUMBER_tbl_type,
585 NREC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
586 TAX_EXEMPTION_ID NUMBER_tbl_type,
587 EXEMPTION_RATE NUMBER_tbl_type,
588 EXEMPT_RATE_NAME VARCHAR2_150_tbl_type,
589 EXEMPT_RATE_MODIFIER NUMBER_tbl_type,
590 EXEMPT_CERTIFICATE_NUMBER VARCHAR2_80_tbl_type,
591 EXEMPT_REASON VARCHAR2_240_tbl_type,
592 EXEMPT_REASON_CODE VARCHAR2_30_tbl_type,
593 TAX_EXCEPTION_ID NUMBER_tbl_type,
594 EXCEPTION_RATE NUMBER_tbl_type,
595 EXCEPTION_RATE_NAME VARCHAR2_150_tbl_type,
596 EXCEPTION_RATE_MODIFIER NUMBER_tbl_type,
597 TAX_APPORTIONMENT_FLAG VARCHAR2_1_tbl_type,
598 HISTORICAL_FLAG VARCHAR2_1_tbl_type,
599 DEFAULT_TAXATION_COUNTRY VARCHAR2_2_tbl_type,
600 TAXABLE_BASIS_FORMULA VARCHAR2_30_tbl_type,
601 TAX_CALCULATION_FORMULA VARCHAR2_30_tbl_type,
602 TRX_LINE_GL_DATE DATE_tbl_type,
603 CANCEL_FLAG VARCHAR2_1_tbl_type,
604 PURGE_FLAG VARCHAR2_1_tbl_type,
605 DELETE_FLAG VARCHAR2_1_tbl_type,
606 TAX_AMT_INCLUDED_FLAG VARCHAR2_1_tbl_type,
607 LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2_1_tbl_type,
608 SELF_ASSESSED_FLAG VARCHAR2_1_tbl_type,
609 OVERRIDDEN_FLAG VARCHAR2_1_tbl_type,
610 MANUALLY_ENTERED_FLAG VARCHAR2_1_tbl_type,
611 REPORTING_ONLY_FLAG VARCHAR2_1_tbl_type,
612 FREEZE_UNTIL_OVERRIDDEN_FLAG VARCHAR2_1_tbl_type,
613 COPIED_FROM_REF_DOC_FLAG VARCHAR2_1_tbl_type,
614 RECALC_REQUIRED_FLAG VARCHAR2_1_tbl_type,
615 SETTLEMENT_FLAG VARCHAR2_1_tbl_type,
616 ITEM_DIST_CHANGED_FLAG VARCHAR2_1_tbl_type,
617 ASSOCIATED_CHILD_FROZEN_FLAG VARCHAR2_1_tbl_type,
618 TAX_ONLY_LINE_FLAG VARCHAR2_1_tbl_type,
619 LAST_MANUAL_ENTRY VARCHAR2_30_tbl_type,
620 TAX_PROVIDER_ID NUMBER_tbl_type,
621 RECORD_TYPE VARCHAR2_30_tbl_type,
622 REPORTING_PERIOD_ID NUMBER_tbl_type,
623 ACCOUNT_CCID NUMBER_tbl_type,
624 ACCOUNT_STRING VARCHAR2_2000_tbl_type,
625 LEGAL_MESSAGE_APPL_2 NUMBER_tbl_type,
626 LEGAL_MESSAGE_STATUS NUMBER_tbl_type,
627 LEGAL_MESSAGE_RATE NUMBER_tbl_type,
628 LEGAL_MESSAGE_BASIS NUMBER_tbl_type,
629 LEGAL_MESSAGE_CALC NUMBER_tbl_type,
630 LEGAL_MESSAGE_THRESHOLD NUMBER_tbl_type,
631 LEGAL_MESSAGE_POS NUMBER_tbl_type,
632 LEGAL_MESSAGE_TRN NUMBER_tbl_type,
633 LEGAL_MESSAGE_EXMPT NUMBER_tbl_type,
634 LEGAL_MESSAGE_EXCPT NUMBER_tbl_type,
635 MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2_150_tbl_type,
636 MERCHANT_PARTY_TAX_PROF_ID NUMBER_tbl_type,
637 MERCHANT_PARTY_NAME VARCHAR2_150_tbl_type,
638 MERCHANT_PARTY_REFERENCE VARCHAR2_250_tbl_type,
639 MERCHANT_PARTY_TAXPAYER_ID VARCHAR2_80_tbl_type,
640 MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2_150_tbl_type,
641 MERCHANT_PARTY_COUNTRY VARCHAR2_150_tbl_type,
642 SHIP_TO_LOCATION_ID NUMBER_tbl_type,
643 SHIP_FROM_LOCATION_ID NUMBER_tbl_type,
644 POA_LOCATION_ID NUMBER_tbl_type,
645 POO_LOCATION_ID NUMBER_tbl_type,
646 PAYING_LOCATION_ID NUMBER_tbl_type,
647 OWN_HQ_LOCATION_ID NUMBER_tbl_type,
648 TRADING_HQ_LOCATION_ID NUMBER_tbl_type,
649 POC_LOCATION_ID NUMBER_tbl_type,
650 POI_LOCATION_ID NUMBER_tbl_type,
651 POD_LOCATION_ID NUMBER_tbl_type,
652 BILL_TO_LOCATION_ID NUMBER_tbl_type,
653 BILL_FROM_LOCATION_ID NUMBER_tbl_type,
654 TITLE_TRANSFER_LOCATION_ID NUMBER_tbl_type,
655 SHIP_TO_PARTY_TAX_PROF_ID NUMBER_tbl_type,
656 SHIP_FROM_PARTY_TAX_PROF_ID NUMBER_tbl_type,
657 POO_PARTY_TAX_PROF_ID NUMBER_tbl_type,
658 POA_PARTY_TAX_PROF_ID NUMBER_tbl_type,
659 PAYING_PARTY_TAX_PROF_ID NUMBER_tbl_type,
660 OWN_HQ_PARTY_TAX_PROF_ID NUMBER_tbl_type,
661 TRADING_HQ_PARTY_TAX_PROF_ID NUMBER_tbl_type,
662 POI_PARTY_TAX_PROF_ID NUMBER_tbl_type,
663 POD_PARTY_TAX_PROF_ID NUMBER_tbl_type,
664 BILL_TO_PARTY_TAX_PROF_ID NUMBER_tbl_type,
665 BILL_FROM_PARTY_TAX_PROF_ID NUMBER_tbl_type,
666 TITLE_TRANS_PARTY_TAX_PROF_ID NUMBER_tbl_type,
667 SHIP_TO_SITE_TAX_PROF_ID NUMBER_tbl_type,
668 SHIP_FROM_SITE_TAX_PROF_ID NUMBER_tbl_type,
669 POO_SITE_TAX_PROF_ID NUMBER_tbl_type,
670 POA_SITE_TAX_PROF_ID NUMBER_tbl_type,
671 PAYING_SITE_TAX_PROF_ID NUMBER_tbl_type,
672 OWN_HQ_SITE_TAX_PROF_ID NUMBER_tbl_type,
673 TRADING_HQ_SITE_TAX_PROF_ID NUMBER_tbl_type,
674 POI_SITE_TAX_PROF_ID NUMBER_tbl_type,
675 POD_SITE_TAX_PROF_ID NUMBER_tbl_type,
676 BILL_TO_SITE_TAX_PROF_ID NUMBER_tbl_type,
677 BILL_FROM_SITE_TAX_PROF_ID NUMBER_tbl_type,
678 TITLE_TRANS_SITE_TAX_PROF_ID NUMBER_tbl_type,
679 TAX_REGIME_TEMPLATE_ID NUMBER_tbl_type,
680 TAX_APPLICABILITY_RESULT_ID NUMBER_tbl_type,
681 DIRECT_RATE_RESULT_ID NUMBER_tbl_type,
682 STATUS_RESULT_ID NUMBER_tbl_type,
683 RATE_RESULT_ID NUMBER_tbl_type,
684 BASIS_RESULT_ID NUMBER_tbl_type,
685 THRESH_RESULT_ID NUMBER_tbl_type,
686 CALC_RESULT_ID NUMBER_tbl_type,
687 TAX_REG_NUM_DET_RESULT_ID NUMBER_tbl_type,
688 EVAL_EXMPT_RESULT_ID NUMBER_tbl_type,
689 EVAL_EXCPT_RESULT_ID NUMBER_tbl_type,
690 DOCUMENT_SUB_TYPE VARCHAR2_240_tbl_type,
691 SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2_150_tbl_type,
692 SUPPLIER_TAX_INVOICE_DATE DATE_tbl_type,
693 SUPPLIER_EXCHANGE_RATE NUMBER_tbl_type,
694 TAX_INVOICE_DATE DATE_tbl_type,
695 TAX_INVOICE_NUMBER VARCHAR2_150_tbl_type,
696 ENFORCE_FROM_NATURAL_ACCT_FLAG VARCHAR2_1_tbl_type,
697 TAX_HOLD_CODE VARCHAR2_30_tbl_type,
698 TAX_HOLD_RELEASED_CODE VARCHAR2_30_tbl_type,
699 INTERNAL_ORG_LOCATION_ID NUMBER_tbl_type,
700 ATTRIBUTE_CATEGORY VARCHAR2_150_tbl_type,
701 ATTRIBUTE1 VARCHAR2_150_tbl_type,
702 ATTRIBUTE2 VARCHAR2_150_tbl_type,
703 ATTRIBUTE3 VARCHAR2_150_tbl_type,
704 ATTRIBUTE4 VARCHAR2_150_tbl_type,
705 ATTRIBUTE5 VARCHAR2_150_tbl_type,
706 ATTRIBUTE6 VARCHAR2_150_tbl_type,
707 ATTRIBUTE7 VARCHAR2_150_tbl_type,
708 ATTRIBUTE8 VARCHAR2_150_tbl_type,
709 ATTRIBUTE9 VARCHAR2_150_tbl_type,
710 ATTRIBUTE10 VARCHAR2_150_tbl_type,
711 ATTRIBUTE11 VARCHAR2_150_tbl_type,
712 ATTRIBUTE12 VARCHAR2_150_tbl_type,
713 ATTRIBUTE13 VARCHAR2_150_tbl_type,
714 ATTRIBUTE14 VARCHAR2_150_tbl_type,
715 ATTRIBUTE15 VARCHAR2_150_tbl_type,
716 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2_150_tbl_type,
717 GLOBAL_ATTRIBUTE1 VARCHAR2_150_tbl_type,
718 GLOBAL_ATTRIBUTE2 VARCHAR2_150_tbl_type,
719 GLOBAL_ATTRIBUTE3 VARCHAR2_150_tbl_type,
720 GLOBAL_ATTRIBUTE4 VARCHAR2_150_tbl_type,
721 GLOBAL_ATTRIBUTE5 VARCHAR2_150_tbl_type,
722 GLOBAL_ATTRIBUTE6 VARCHAR2_150_tbl_type,
723 GLOBAL_ATTRIBUTE7 VARCHAR2_150_tbl_type,
724 GLOBAL_ATTRIBUTE8 VARCHAR2_150_tbl_type,
725 GLOBAL_ATTRIBUTE9 VARCHAR2_150_tbl_type,
726 GLOBAL_ATTRIBUTE10 VARCHAR2_150_tbl_type,
727 GLOBAL_ATTRIBUTE11 VARCHAR2_150_tbl_type,
728 GLOBAL_ATTRIBUTE12 VARCHAR2_150_tbl_type,
729 GLOBAL_ATTRIBUTE13 VARCHAR2_150_tbl_type,
730 GLOBAL_ATTRIBUTE14 VARCHAR2_150_tbl_type,
731 GLOBAL_ATTRIBUTE15 VARCHAR2_150_tbl_type,
732 NUMERIC1 NUMBER_tbl_type,
733 NUMERIC2 NUMBER_tbl_type,
734 NUMERIC3 NUMBER_tbl_type,
735 NUMERIC4 NUMBER_tbl_type,
736 NUMERIC5 NUMBER_tbl_type,
737 NUMERIC6 NUMBER_tbl_type,
738 NUMERIC7 NUMBER_tbl_type,
739 NUMERIC8 NUMBER_tbl_type,
740 NUMERIC9 NUMBER_tbl_type,
741 NUMERIC10 NUMBER_tbl_type,
742 CHAR1 VARCHAR2_150_tbl_type,
743 CHAR2 VARCHAR2_150_tbl_type,
744 CHAR3 VARCHAR2_150_tbl_type,
745 CHAR4 VARCHAR2_150_tbl_type,
746 CHAR5 VARCHAR2_150_tbl_type,
747 CHAR6 VARCHAR2_150_tbl_type,
748 CHAR7 VARCHAR2_150_tbl_type,
749 CHAR8 VARCHAR2_150_tbl_type,
750 CHAR9 VARCHAR2_150_tbl_type,
751 CHAR10 VARCHAR2_150_tbl_type,
752 DATE1 DATE_tbl_type,
753 DATE2 DATE_tbl_type,
754 DATE3 DATE_tbl_type,
755 DATE4 DATE_tbl_type,
756 DATE5 DATE_tbl_type,
757 DATE6 DATE_tbl_type,
758 DATE7 DATE_tbl_type,
759 DATE8 DATE_tbl_type,
760 DATE9 DATE_tbl_type,
761 DATE10 DATE_tbl_type,
762 CREATED_BY NUMBER_tbl_type,
763 CREATION_DATE DATE_tbl_type,
764 LAST_UPDATED_BY NUMBER_tbl_type,
765 LAST_UPDATE_DATE DATE_tbl_type,
766 LAST_UPDATE_LOGIN NUMBER_tbl_type,
767 SUBSCRIBER_ID NUMBER_tbl_type,
768 LEGAL_ENTITY_TAX_REG_NUMBER NUMBER_tbl_type,
769 UNROUNDED_TAX_AMT NUMBER_tbl_type,
770 PRD_TOTAL_TAX_AMT NUMBER_tbl_type,
771 PRD_TOTAL_TAX_AMT_TAX_CURR NUMBER_tbl_type,
772 PRD_TOTAL_TAX_AMT_FUNCL_CURR NUMBER_tbl_type);
773
774 TYPE zx_lines_summary_rec_tbl_type IS RECORD (
775 SUMMARY_TAX_LINE_ID NUMBER_tbl_type,
776 INTERNAL_ORGANIZATION_ID NUMBER_tbl_type,
777 APPLICATION_ID NUMBER_tbl_type,
778 ENTITY_CODE VARCHAR2_30_tbl_type,
779 EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
780 TAX_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
781 TRX_ID NUMBER_tbl_type,
782 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type,
783 TRX_NUMBER VARCHAR2_150_tbl_type,
784 APPLIED_FROM_APPLICATION_ID NUMBER_tbl_type,
785 APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
786 APPLIED_FROM_ENTITY_CODE VARCHAR2_30_tbl_type,
787 APPLIED_FROM_TRX_NUMBER VARCHAR2_150_tbl_type,
788 APPLIED_FROM_TRX_ID NUMBER_tbl_type,
789 ADJUSTED_DOC_APPLICATION_ID NUMBER_tbl_type,
790 ADJUSTED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type,
791 ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
792 ADJUSTED_DOC_TRX_ID NUMBER_tbl_type,
793 ADJUSTED_DOC_NUMBER VARCHAR2_150_tbl_type,
794 SUMMARY_TAX_LINE_NUMBER NUMBER_tbl_type,
795 CONTENT_OWNER_ID NUMBER_tbl_type,
796 TAX_REGIME_ID NUMBER_tbl_type,
797 TAX_REGIME_CODE VARCHAR2_30_tbl_type,
798 TAX_ID NUMBER_tbl_type,
799 TAX VARCHAR2_30_tbl_type,
800 TAX_STATUS_ID NUMBER_tbl_type,
801 TAX_STATUS_CODE VARCHAR2_30_tbl_type,
802 TAX_RATE_ID NUMBER_tbl_type,
803 TAX_RATE_CODE VARCHAR2_30_tbl_type,
804 TAX_RATE NUMBER_tbl_type,
805 TAX_AMT NUMBER_tbl_type,
806 TAX_AMT_TAX_CURR NUMBER_tbl_type,
807 TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
808 TAX_JURISDICTION_ID NUMBER_tbl_type,
809 TAX_JURISDICTION_CODE VARCHAR2_240_tbl_type,
810 ORIG_TAX_STATUS_ID NUMBER_tbl_type,
811 ORIG_TAX_STATUS_CODE VARCHAR2_30_tbl_type,
812 ORIG_TAX_RATE_ID NUMBER_tbl_type,
813 ORIG_TAX_RATE_CODE VARCHAR2_30_tbl_type,
814 ORIG_TAX_RATE NUMBER_tbl_type,
815 ORIG_TAX_AMT NUMBER_tbl_type,
816 ORIG_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
817 TOTAL_REC_TAX_AMT NUMBER_tbl_type,
818 TOTAL_REC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
819 TOTAL_NREC_TAX_AMT NUMBER_tbl_type,
820 TOTAL_NREC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
821 LEDGER_ID NUMBER_tbl_type,
822 LEGAL_ENTITY_ID NUMBER_tbl_type,
823 ESTABLISHMENT_ID NUMBER_tbl_type,
824 CURRENCY_CONVERSION_DATE DATE_tbl_type,
825 CURRENCY_CONVERSION_TYPE VARCHAR2_30_tbl_type,
826 CURRENCY_CONVERSION_RATE NUMBER_tbl_type,
827 SUMMARIZATION_TEMPLATE_ID NUMBER_tbl_type,
828 TAXABLE_BASIS_FORMULA VARCHAR2_30_tbl_type,
829 TAX_CALCULATION_FORMULA VARCHAR2_30_tbl_type,
830 HISTORICAL_FLAG VARCHAR2_1_tbl_type,
831 CANCEL_FLAG VARCHAR2_1_tbl_type,
832 PURGE_FLAG VARCHAR2_1_tbl_type,
833 DELETE_FLAG VARCHAR2_1_tbl_type,
834 TAX_AMT_INCLUDED_FLAG VARCHAR2_1_tbl_type,
835 COMPOUNDING_TAX_FLAG VARCHAR2_1_tbl_type,
836 SELF_ASSESSED_FLAG VARCHAR2_1_tbl_type,
837 OVERRIDDEN_FLAG VARCHAR2_1_tbl_type,
838 REPORTING_ONLY_FLAG VARCHAR2_1_tbl_type,
839 ASSOCIATED_CHILD_FROZEN_FLAG VARCHAR2_1_tbl_type,
840 COPIED_FROM_REF_DOC_FLAG VARCHAR2_1_tbl_type,
841 MANUALLY_ENTERED_FLAG VARCHAR2_1_tbl_type,
842 LAST_MANUAL_ENTRY VARCHAR2_30_tbl_type,
843 RECORD_TYPE VARCHAR2_30_tbl_type,
844 TAX_PROVIDER_ID NUMBER_tbl_type,
845 TAX_ONLY_LINE_FLAG VARCHAR2_1_tbl_type,
846 CREATED_BY NUMBER_tbl_type,
847 CREATION_DATE DATE_tbl_type,
848 LAST_UPDATED_BY NUMBER_tbl_type,
849 LAST_UPDATE_DATE DATE_tbl_type,
850 LAST_UPDATE_LOGIN NUMBER_tbl_type,
851 ATTRIBUTE_CATEGORY VARCHAR2_150_tbl_type,
852 ATTRIBUTE1 VARCHAR2_150_tbl_type,
853 ATTRIBUTE2 VARCHAR2_150_tbl_type,
854 ATTRIBUTE3 VARCHAR2_150_tbl_type,
855 ATTRIBUTE4 VARCHAR2_150_tbl_type,
856 ATTRIBUTE5 VARCHAR2_150_tbl_type,
857 ATTRIBUTE6 VARCHAR2_150_tbl_type,
858 ATTRIBUTE7 VARCHAR2_150_tbl_type,
859 ATTRIBUTE8 VARCHAR2_150_tbl_type,
860 ATTRIBUTE9 VARCHAR2_150_tbl_type,
861 ATTRIBUTE10 VARCHAR2_150_tbl_type,
862 ATTRIBUTE11 VARCHAR2_150_tbl_type,
863 ATTRIBUTE12 VARCHAR2_150_tbl_type,
864 ATTRIBUTE13 VARCHAR2_150_tbl_type,
865 ATTRIBUTE14 VARCHAR2_150_tbl_type,
866 ATTRIBUTE15 VARCHAR2_150_tbl_type,
867 SUBSCRIBER_ID NUMBER_tbl_type);
868
869 TYPE zx_rec_nrec_dist_rec_tbl_type IS RECORD (
870 SUMMARY_TAX_LINE_ID NUMBER_tbl_type,
871 INTERNAL_ORGANIZATION_ID NUMBER_tbl_type,
872 APPLICATION_ID NUMBER_tbl_type,
873 ENTITY_CODE VARCHAR2_30_tbl_type,
874 EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
875 EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
876 TAX_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
877 TRX_ID NUMBER_tbl_type,
878 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type,
879 TRX_NUMBER VARCHAR2_150_tbl_type,
880 TRX_LINE_NUMBER NUMBER_tbl_type,
881 APPLIED_FROM_APPLICATION_ID NUMBER_tbl_type,
882 APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
883 APPLIED_FROM_ENTITY_CODE VARCHAR2_30_tbl_type,
884 APPLIED_FROM_TRX_NUMBER VARCHAR2_150_tbl_type,
885 APPLIED_FROM_TRX_ID NUMBER_tbl_type,
886 ADJUSTED_DOC_APPLICATION_ID NUMBER_tbl_type,
887 ADJUSTED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type,
888 ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
889 ADJUSTED_DOC_TRX_ID NUMBER_tbl_type,
890 ADJUSTED_DOC_NUMBER VARCHAR2_150_tbl_type,
891 SUMMARY_TAX_LINE_NUMBER NUMBER_tbl_type,
892 CONTENT_OWNER_ID NUMBER_tbl_type,
893 TAX_REGIME_ID NUMBER_tbl_type,
894 TAX_REGIME_CODE VARCHAR2_30_tbl_type,
895 TAX_ID NUMBER_tbl_type,
896 TAX_LINE_ID NUMBER_tbl_type,
897 TAX VARCHAR2_30_tbl_type,
898 TAX_STATUS_ID NUMBER_tbl_type,
899 TAX_STATUS_CODE VARCHAR2_30_tbl_type,
900 TAX_RATE_ID NUMBER_tbl_type,
901 TAX_RATE_CODE VARCHAR2_30_tbl_type,
902 TAX_RATE NUMBER_tbl_type,
903 TAX_AMT NUMBER_tbl_type,
904 TAXABLE_AMT NUMBER_tbl_type,
905 TAXABLE_AMT_FUNCL_CURR NUMBER_tbl_type,
906 TAX_AMT_TAX_CURR NUMBER_tbl_type,
907 TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
908 TAX_JURISDICTION_ID NUMBER_tbl_type,
909 TAX_JURISDICTION_CODE VARCHAR2_240_tbl_type,
910 ORIG_TAX_STATUS_ID NUMBER_tbl_type,
911 ORIG_TAX_STATUS_CODE VARCHAR2_30_tbl_type,
912 ORIG_TAX_RATE_ID NUMBER_tbl_type,
913 ORIG_TAX_RATE_CODE VARCHAR2_30_tbl_type,
914 ORIG_TAX_RATE NUMBER_tbl_type,
915 ORIG_TAX_AMT NUMBER_tbl_type,
916 ORIG_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
917 TOTAL_REC_TAX_AMT NUMBER_tbl_type,
918 TOTAL_REC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
919 TOTAL_NREC_TAX_AMT NUMBER_tbl_type,
920 TOTAL_NREC_TAX_AMT_FUNCL_CURR NUMBER_tbl_type,
921 LEDGER_ID NUMBER_tbl_type,
922 LEGAL_ENTITY_ID NUMBER_tbl_type,
923 ESTABLISHMENT_ID NUMBER_tbl_type,
924 CURRENCY_CONVERSION_DATE DATE_tbl_type,
925 CURRENCY_CONVERSION_TYPE VARCHAR2_30_tbl_type,
926 CURRENCY_CONVERSION_RATE NUMBER_tbl_type,
927 SUMMARIZATION_TEMPLATE_ID NUMBER_tbl_type,
928 TAXABLE_BASIS_FORMULA VARCHAR2_30_tbl_type,
929 TAX_CALCULATION_FORMULA VARCHAR2_30_tbl_type,
930 HISTORICAL_FLAG VARCHAR2_1_tbl_type,
931 CANCEL_FLAG VARCHAR2_1_tbl_type,
932 PURGE_FLAG VARCHAR2_1_tbl_type,
933 DELETE_FLAG VARCHAR2_1_tbl_type,
934 TAX_AMT_INCLUDED_FLAG VARCHAR2_1_tbl_type,
935 COMPOUNDING_TAX_FLAG VARCHAR2_1_tbl_type,
936 SELF_ASSESSED_FLAG VARCHAR2_1_tbl_type,
937 OVERRIDDEN_FLAG VARCHAR2_1_tbl_type,
938 REPORTING_ONLY_FLAG VARCHAR2_1_tbl_type,
939 ASSOCIATED_CHILD_FROZEN_FLAG VARCHAR2_1_tbl_type,
940 COPIED_FROM_REF_DOC_FLAG VARCHAR2_1_tbl_type,
941 MANUALLY_ENTERED_FLAG VARCHAR2_1_tbl_type,
942 LAST_MANUAL_ENTRY VARCHAR2_30_tbl_type,
943 RECORD_TYPE VARCHAR2_30_tbl_type,
944 TAX_PROVIDER_ID NUMBER_tbl_type,
945 TAX_ONLY_LINE_FLAG VARCHAR2_1_tbl_type,
946 CREATED_BY NUMBER_tbl_type,
947 CREATION_DATE DATE_tbl_type,
948 LAST_UPDATED_BY NUMBER_tbl_type,
949 LAST_UPDATE_DATE DATE_tbl_type,
950 LAST_UPDATE_LOGIN NUMBER_tbl_type,
951 ATTRIBUTE_CATEGORY VARCHAR2_150_tbl_type,
952 ATTRIBUTE1 VARCHAR2_150_tbl_type,
953 ATTRIBUTE2 VARCHAR2_150_tbl_type,
954 ATTRIBUTE3 VARCHAR2_150_tbl_type,
955 ATTRIBUTE4 VARCHAR2_150_tbl_type,
956 ATTRIBUTE5 VARCHAR2_150_tbl_type,
957 ATTRIBUTE6 VARCHAR2_150_tbl_type,
958 ATTRIBUTE7 VARCHAR2_150_tbl_type,
959 ATTRIBUTE8 VARCHAR2_150_tbl_type,
960 ATTRIBUTE9 VARCHAR2_150_tbl_type,
961 ATTRIBUTE10 VARCHAR2_150_tbl_type,
962 ATTRIBUTE11 VARCHAR2_150_tbl_type,
963 ATTRIBUTE12 VARCHAR2_150_tbl_type,
964 ATTRIBUTE13 VARCHAR2_150_tbl_type,
965 ATTRIBUTE14 VARCHAR2_150_tbl_type,
966 ATTRIBUTE15 VARCHAR2_150_tbl_type,
967 SUBSCRIBER_ID NUMBER_tbl_type);
968
969
970 TYPE zx_trx_headers_rec_tbl_type IS RECORD (
971 INTERNAL_ORGANIZATION_ID NUMBER_tbl_type,
972 INTERNAL_ORG_LOCATION_ID NUMBER_tbl_type,
973 APPLICATION_ID NUMBER_tbl_type,
974 ENTITY_CODE VARCHAR2_30_tbl_type,
975 EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
976 EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
977 TRX_ID NUMBER_tbl_type,
978 HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
979 HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
980 HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
981 HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
982 HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
983 HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
984 TRX_DATE DATE_tbl_type,
985 TRX_DOC_REVISION VARCHAR2_150_tbl_type,
986 LEDGER_ID NUMBER_tbl_type,
987 TRX_CURRENCY_CODE VARCHAR2_15_tbl_type,
988 CURRENCY_CONVERSION_DATE DATE_tbl_type,
989 CURRENCY_CONVERSION_RATE NUMBER_tbl_type,
990 CURRENCY_CONVERSION_TYPE VARCHAR2_30_tbl_type,
991 MINIMUM_ACCOUNTABLE_UNIT NUMBER_tbl_type,
992 PRECISION NUMBER_tbl_type,
993 LEGAL_ENTITY_ID NUMBER_tbl_type,
994 ROUNDING_SHIP_TO_PARTY_ID NUMBER_tbl_type,
995 ROUNDING_SHIP_FROM_PARTY_ID NUMBER_tbl_type,
996 ROUNDING_BILL_TO_PARTY_ID NUMBER_tbl_type,
997 ROUNDING_BILL_FROM_PARTY_ID NUMBER_tbl_type,
998 RNDG_SHIP_TO_PARTY_SITE_ID NUMBER_tbl_type,
999 RNDG_SHIP_FROM_PARTY_SITE_ID NUMBER_tbl_type,
1000 RNDG_BILL_TO_PARTY_SITE_ID NUMBER_tbl_type,
1001 RNDG_BILL_FROM_PARTY_SITE_ID NUMBER_tbl_type,
1002 ESTABLISHMENT_ID NUMBER_tbl_type,
1003 RECEIVABLES_TRX_TYPE_ID NUMBER_tbl_type,
1004 RELATED_DOC_APPLICATION_ID NUMBER_tbl_type,
1005 RELATED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type,
1006 RELATED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
1007 RELATED_DOC_TRX_ID NUMBER_tbl_type,
1008 REL_DOC_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1009 REL_DOC_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1010 REL_DOC_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1011 REL_DOC_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1012 REL_DOC_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1013 REL_DOC_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1014 RELATED_DOC_NUMBER VARCHAR2_150_tbl_type,
1015 RELATED_DOC_DATE DATE_tbl_type,
1016 DEFAULT_TAXATION_COUNTRY VARCHAR2_2_tbl_type,
1017 QUOTE_FLAG VARCHAR2_1_tbl_type,
1018 VALIDATION_CHECK_FLAG VARCHAR2_1_tbl_type,
1019 CTRL_TOTAL_HDR_TX_AMT NUMBER_tbl_type,
1020 TRX_NUMBER VARCHAR2_150_tbl_type,
1021 TRX_DESCRIPTION VARCHAR2_240_tbl_type,
1022 TRX_COMMUNICATED_DATE DATE_tbl_type,
1023 BATCH_SOURCE_ID NUMBER_tbl_type,
1024 BATCH_SOURCE_NAME VARCHAR2_150_tbl_type,
1025 DOC_SEQ_ID NUMBER_tbl_type,
1026 DOC_SEQ_NAME VARCHAR2_150_tbl_type,
1027 DOC_SEQ_VALUE VARCHAR2_150_tbl_type,
1028 TRX_DUE_DATE DATE_tbl_type,
1029 TRX_TYPE_DESCRIPTION VARCHAR2_240_tbl_type,
1030 DOCUMENT_SUB_TYPE VARCHAR2_240_tbl_type,
1031 SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2_150_tbl_type,
1032 SUPPLIER_TAX_INVOICE_DATE DATE_tbl_type,
1033 SUPPLIER_EXCHANGE_RATE NUMBER_tbl_type,
1034 TAX_INVOICE_DATE DATE_tbl_type,
1035 TAX_INVOICE_NUMBER VARCHAR2_150_tbl_type,
1036 SUBSCRIBER_ID NUMBER_tbl_type,
1037 TAX_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
1038 TAX_EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
1039 DOC_EVENT_STATUS VARCHAR2_30_tbl_type,
1040 RDNG_SHIP_TO_PTY_TX_PROF_ID NUMBER_tbl_type,
1041 RDNG_SHIP_FROM_PTY_TX_PROF_ID NUMBER_tbl_type,
1042 RDNG_BILL_TO_PTY_TX_PROF_ID NUMBER_tbl_type,
1043 RDNG_BILL_FROM_PTY_TX_PROF_ID NUMBER_tbl_type,
1044 RDNG_SHIP_TO_PTY_TX_P_ST_ID NUMBER_tbl_type,
1045 RDNG_SHIP_FROM_PTY_TX_P_ST_ID NUMBER_tbl_type,
1046 RDNG_BILL_TO_PTY_TX_P_ST_ID NUMBER_tbl_type,
1047 RDNG_BILL_FROM_PTY_TX_P_ST_ID NUMBER_tbl_type,
1048 PORT_OF_ENTRY_CODE VARCHAR2_30_TBL_TYPE);
1049
1050 TYPE zx_trx_lines_rec_tbl_type IS RECORD(
1051 APPLICATION_ID NUMBER_tbl_type ,
1052 ENTITY_CODE VARCHAR2_30_tbl_type ,
1053 EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
1054 TRX_ID NUMBER_tbl_type ,
1055 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
1056 TRX_LINE_ID NUMBER_tbl_type ,
1057 LINE_LEVEL_ACTION VARCHAR2_30_tbl_type ,
1058 TRX_SHIPPING_DATE DATE_tbl_type ,
1059 TRX_RECEIPT_DATE DATE_tbl_type ,
1060 TRX_LINE_TYPE VARCHAR2_30_tbl_type ,
1061 TRX_LINE_DATE DATE_tbl_type ,
1062 TRX_BUSINESS_CATEGORY VARCHAR2_240_tbl_type ,
1063 LINE_INTENDED_USE VARCHAR2_240_tbl_type ,
1064 USER_DEFINED_FISC_CLASS VARCHAR2_30_tbl_type ,
1065 LINE_AMT NUMBER_tbl_type ,
1066 TRX_LINE_QUANTITY NUMBER_tbl_type ,
1067 UNIT_PRICE NUMBER_tbl_type ,
1068 EXEMPT_CERTIFICATE_NUMBER VARCHAR2_30_tbl_type ,
1069 EXEMPT_REASON VARCHAR2_240_tbl_type,
1070 CASH_DISCOUNT NUMBER_tbl_type ,
1071 VOLUME_DISCOUNT NUMBER_tbl_type ,
1072 TRADING_DISCOUNT NUMBER_tbl_type ,
1073 TRANSFER_CHARGE NUMBER_tbl_type ,
1074 TRANSPORTATION_CHARGE NUMBER_tbl_type ,
1075 INSURANCE_CHARGE NUMBER_tbl_type ,
1076 OTHER_CHARGE NUMBER_tbl_type ,
1077 PRODUCT_ID NUMBER_tbl_type ,
1078 PRODUCT_FISC_CLASSIFICATION VARCHAR2_240_tbl_type ,
1079 PRODUCT_ORG_ID NUMBER_tbl_type ,
1080 UOM_CODE VARCHAR2_30_tbl_type ,
1081 PRODUCT_TYPE VARCHAR2_30_tbl_type ,
1082 PRODUCT_CODE VARCHAR2_30_tbl_type ,
1083 PRODUCT_CATEGORY VARCHAR2_240_tbl_type ,
1084 TRX_SIC_CODE VARCHAR2_150_tbl_type,
1085 FOB_POINT VARCHAR2_30_tbl_type ,
1086 SHIP_TO_PARTY_ID NUMBER_tbl_type ,
1087 SHIP_FROM_PARTY_ID NUMBER_tbl_type ,
1088 POA_PARTY_ID NUMBER_tbl_type ,
1089 POO_PARTY_ID NUMBER_tbl_type ,
1090 BILL_TO_PARTY_ID NUMBER_tbl_type ,
1091 BILL_FROM_PARTY_ID NUMBER_tbl_type ,
1092 MERCHANT_PARTY_ID NUMBER_tbl_type ,
1093 SHIP_TO_PARTY_SITE_ID NUMBER_tbl_type ,
1094 SHIP_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
1095 POA_PARTY_SITE_ID NUMBER_tbl_type ,
1096 POO_PARTY_SITE_ID NUMBER_tbl_type ,
1097 BILL_TO_PARTY_SITE_ID NUMBER_tbl_type ,
1098 BILL_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
1099 SHIP_TO_LOCATION_ID NUMBER_tbl_type ,
1100 SHIP_FROM_LOCATION_ID NUMBER_tbl_type ,
1101 POA_LOCATION_ID NUMBER_tbl_type ,
1102 POO_LOCATION_ID NUMBER_tbl_type ,
1103 BILL_TO_LOCATION_ID NUMBER_tbl_type ,
1104 BILL_FROM_LOCATION_ID NUMBER_tbl_type ,
1105 ACCOUNT_CCID NUMBER_tbl_type ,
1106 ACCOUNT_STRING VARCHAR2_2000_tbl_type,
1107 MERCHANT_PARTY_COUNTRY VARCHAR2_150_tbl_type,
1108 REF_DOC_APPLICATION_ID NUMBER_tbl_type ,
1109 REF_DOC_ENTITY_CODE VARCHAR2_30_tbl_type ,
1110 REF_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
1111 REF_DOC_TRX_ID NUMBER_tbl_type ,
1112 REF_DOC_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1113 REF_DOC_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1114 REF_DOC_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1115 REF_DOC_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1116 REF_DOC_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1117 REF_DOC_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1118 REF_DOC_LINE_ID NUMBER_tbl_type ,
1119 REF_DOC_LIN_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1120 REF_DOC_LIN_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1121 REF_DOC_LIN_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1122 REF_DOC_LIN_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1123 REF_DOC_LIN_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1124 REF_DOC_LIN_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1125 REF_DOC_LINE_QUANTITY NUMBER_tbl_type ,
1126 APPLIED_FROM_APPLICATION_ID NUMBER_tbl_type ,
1127 APPLIED_FROM_ENTITY_CODE VARCHAR2_30_tbl_type ,
1128 APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
1129 APPLIED_FROM_TRX_ID NUMBER_tbl_type ,
1130 APP_FROM_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1131 APP_FROM_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1132 APP_FROM_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1133 APP_FROM_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1134 APP_FROM_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1135 APP_FROM_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1136 APPLIED_FROM_LINE_ID NUMBER_tbl_type ,
1137 APP_FROM_LIN_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1138 APP_FROM_LIN_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1139 APP_FROM_LIN_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1140 APP_FROM_LIN_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1141 APP_FROM_LIN_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1142 APP_FROM_LIN_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1143 ADJUSTED_DOC_APPLICATION_ID NUMBER_tbl_type ,
1144 ADJUSTED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type ,
1145 ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
1146 ADJUSTED_DOC_TRX_ID NUMBER_tbl_type ,
1147 ADJ_DOC_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1148 ADJ_DOC_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1149 ADJ_DOC_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1150 ADJ_DOC_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1151 ADJ_DOC_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1152 ADJ_DOC_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1153 ADJUSTED_DOC_LINE_ID NUMBER_tbl_type ,
1154 ADJ_DOC_LIN_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1155 ADJ_DOC_LIN_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1156 ADJ_DOC_LIN_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1157 ADJ_DOC_LIN_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1158 ADJ_DOC_LIN_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1159 ADJ_DOC_LIN_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1160 ADJUSTED_DOC_NUMBER VARCHAR2_150_tbl_type,
1161 ADJUSTED_DOC_DATE DATE_tbl_type ,
1162 APPLIED_TO_APPLICATION_ID NUMBER_tbl_type ,
1163 APPLIED_TO_ENTITY_CODE VARCHAR2_30_tbl_type ,
1164 APPLIED_TO_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
1165 APPLIED_TO_TRX_ID NUMBER_tbl_type ,
1166 APP_TO_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1167 APP_TO_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1168 APP_TO_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1169 APP_TO_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1170 APP_TO_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1171 APP_TO_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1172 APPLIED_TO_TRX_LINE_ID NUMBER_tbl_type ,
1173 APP_TO_LIN_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1174 APP_TO_LIN_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1175 APP_TO_LIN_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1176 APP_TO_LIN_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1177 APP_TO_LIN_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1178 APP_TO_LIN_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1179 TRX_ID_LEVEL2 NUMBER_tbl_type ,
1180 TRX_ID_LEVEL3 NUMBER_tbl_type ,
1181 TRX_ID_LEVEL4 NUMBER_tbl_type ,
1182 TRX_ID_LEVEL5 NUMBER_tbl_type ,
1183 TRX_ID_LEVEL6 NUMBER_tbl_type ,
1184 HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1185 HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1186 HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1187 HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1188 HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1189 HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1190 LINE_TRX_USER_KEY1 VARCHAR2_150_tbl_type,
1191 LINE_TRX_USER_KEY2 VARCHAR2_150_tbl_type,
1192 LINE_TRX_USER_KEY3 VARCHAR2_150_tbl_type,
1193 LINE_TRX_USER_KEY4 VARCHAR2_150_tbl_type,
1194 LINE_TRX_USER_KEY5 VARCHAR2_150_tbl_type,
1195 LINE_TRX_USER_KEY6 VARCHAR2_150_tbl_type,
1196 TRX_LINE_NUMBER NUMBER_tbl_type ,
1197 TRX_LINE_DESCRIPTION VARCHAR2_240_tbl_type,
1198 PRODUCT_DESCRIPTION VARCHAR2_240_tbl_type,
1199 TRX_WAYBILL_NUMBER VARCHAR2_50_tbl_type ,
1200 TRX_LINE_GL_DATE DATE_tbl_type ,
1201 MERCHANT_PARTY_NAME VARCHAR2_150_tbl_type,
1202 MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2_150_tbl_type,
1203 MERCHANT_PARTY_REFERENCE VARCHAR2_250_tbl_type,
1204 MERCHANT_PARTY_TAXPAYER_ID VARCHAR2_150_tbl_type,
1205 MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2_150_tbl_type,
1206 PAYING_PARTY_ID NUMBER_tbl_type ,
1207 OWN_HQ_PARTY_ID NUMBER_tbl_type ,
1208 TRADING_HQ_PARTY_ID NUMBER_tbl_type ,
1209 POI_PARTY_ID NUMBER_tbl_type ,
1210 POD_PARTY_ID NUMBER_tbl_type ,
1211 TITLE_TRANSFER_PARTY_ID NUMBER_tbl_type ,
1212 PAYING_PARTY_SITE_ID NUMBER_tbl_type ,
1213 OWN_HQ_PARTY_SITE_ID NUMBER_tbl_type ,
1214 TRADING_HQ_PARTY_SITE_ID NUMBER_tbl_type ,
1215 POI_PARTY_SITE_ID NUMBER_tbl_type ,
1216 POD_PARTY_SITE_ID NUMBER_tbl_type ,
1217 TITLE_TRANSFER_PARTY_SITE_ID NUMBER_tbl_type ,
1218 PAYING_LOCATION_ID NUMBER_tbl_type ,
1219 OWN_HQ_LOCATION_ID NUMBER_tbl_type ,
1220 TRADING_HQ_LOCATION_ID NUMBER_tbl_type ,
1221 POC_LOCATION_ID NUMBER_tbl_type ,
1222 POI_LOCATION_ID NUMBER_tbl_type ,
1223 POD_LOCATION_ID NUMBER_tbl_type ,
1224 TITLE_TRANSFER_LOCATION_ID NUMBER_tbl_type ,
1225 ASSESSABLE_VALUE NUMBER_tbl_type ,
1226 ASSET_FLAG VARCHAR2_1_tbl_type ,
1227 ASSET_NUMBER VARCHAR2_150_tbl_type,
1228 ASSET_ACCUM_DEPRECIATION NUMBER_tbl_type ,
1229 ASSET_TYPE VARCHAR2_150_tbl_type,
1230 ASSET_COST NUMBER_tbl_type ,
1231 NUMERIC1 NUMBER_tbl_type ,
1232 NUMERIC2 NUMBER_tbl_type ,
1233 NUMERIC3 NUMBER_tbl_type ,
1234 NUMERIC4 NUMBER_tbl_type ,
1235 NUMERIC5 NUMBER_tbl_type ,
1236 NUMERIC6 NUMBER_tbl_type ,
1237 NUMERIC7 NUMBER_tbl_type ,
1238 NUMERIC8 NUMBER_tbl_type ,
1239 NUMERIC9 NUMBER_tbl_type ,
1240 NUMERIC10 NUMBER_tbl_type ,
1241 CHAR1 VARCHAR2_150_tbl_type,
1242 CHAR2 VARCHAR2_150_tbl_type,
1243 CHAR3 VARCHAR2_150_tbl_type,
1244 CHAR4 VARCHAR2_150_tbl_type,
1245 CHAR5 VARCHAR2_150_tbl_type,
1246 CHAR6 VARCHAR2_150_tbl_type,
1247 CHAR7 VARCHAR2_150_tbl_type,
1248 CHAR8 VARCHAR2_150_tbl_type,
1249 CHAR9 VARCHAR2_150_tbl_type,
1250 CHAR10 VARCHAR2_150_tbl_type,
1251 DATE1 DATE_tbl_type ,
1252 DATE2 DATE_tbl_type ,
1253 DATE3 DATE_tbl_type ,
1254 DATE4 DATE_tbl_type ,
1255 DATE5 DATE_tbl_type ,
1256 DATE6 DATE_tbl_type ,
1257 DATE7 DATE_tbl_type ,
1258 DATE8 DATE_tbl_type ,
1259 DATE9 DATE_tbl_type ,
1260 DATE10 DATE_tbl_type ,
1261 SHIP_TO_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1262 SHIP_FROM_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1263 POA_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1264 POO_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1265 PAYING_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1266 OWN_HQ_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1267 TRADING_HQ_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1268 POI_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1269 POD_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1270 BILL_TO_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1271 BILL_FROM_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1272 TITLE_TRANS_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1273 SHIP_TO_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1274 SHIP_FROM_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1275 POA_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1276 POO_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1277 PAYING_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1278 OWN_HQ_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1279 TRADING_HQ_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1280 POI_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1281 POD_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1282 BILL_TO_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1283 BILL_FROM_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1284 TITLE_TRANS_SITE_TAX_PROF_ID NUMBER_tbl_type ,
1285 MERCHANT_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
1286 LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2_1_tbl_type ,
1287 HISTORICAL_FLAG VARCHAR2_1_tbl_type ,
1288 TAX_CLASSIFICATION_CODE VARCHAR2_80_tbl_type ,
1289 CTRL_HDR_TX_APPL_FLAG VARCHAR2_1_tbl_type ,
1290 CTRL_TOTAL_LINE_TX_AMT NUMBER_tbl_type);
1291
1292 TYPE zx_dist_lines_rec_tbl_type IS RECORD(
1293 APPLICATION_ID NUMBER_tbl_type ,
1294 ENTITY_CODE VARCHAR2_30_tbl_type ,
1295 EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
1296 EVENT_TYPE_CODE VARCHAR2_30_tbl_type ,
1297 TRX_ID NUMBER_tbl_type ,
1298 HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
1299 HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
1300 HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
1301 HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
1302 HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
1303 HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
1304 TRX_LINE_ID NUMBER_tbl_type ,
1305 LINE_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
1306 LINE_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
1307 LINE_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
1308 LINE_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
1309 LINE_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
1310 LINE_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
1311 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
1312 TRX_LINE_DIST_ID NUMBER_tbl_type ,
1313 DIST_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
1314 DIST_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
1315 DIST_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
1316 DIST_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
1317 DIST_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
1318 DIST_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
1319 DIST_LEVEL_ACTION VARCHAR2_30_tbl_type ,
1320 TRX_LINE_DIST_DATE DATE_tbl_type ,
1321 ITEM_DIST_NUMBER NUMBER_tbl_type ,
1322 DIST_INTENDED_USE VARCHAR2_240_tbl_type ,
1323 TAX_INCLUSION_FLAG VARCHAR2_1_tbl_type ,
1324 TAX_CODE VARCHAR2_30_tbl_type ,
1325 TASK_ID NUMBER_tbl_type ,
1326 AWARD_ID NUMBER_tbl_type ,
1327 PROJECT_ID NUMBER_tbl_type ,
1328 EXPENDITURE_TYPE VARCHAR2_30_tbl_type ,
1329 EXPENDITURE_ORGANIZATION_ID NUMBER_tbl_type ,
1330 EXPENDITURE_ITEM_DATE DATE_tbl_type ,
1331 TRX_LINE_DIST_AMT NUMBER_tbl_type ,
1332 TRX_LINE_DIST_QUANTITY NUMBER_tbl_type ,
1333 TRX_LINE_QUANTITY NUMBER_tbl_type ,
1334 ACCOUNT_CCID NUMBER_tbl_type ,
1335 ACCOUNT_STRING VARCHAR2_2000_tbl_type,
1336 REF_DOC_APPLICATION_ID NUMBER_tbl_type ,
1337 REF_DOC_ENTITY_CODE VARCHAR2_30_tbl_type ,
1338 REF_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
1339 REF_DOC_TRX_ID NUMBER_tbl_type ,
1340 REF_DOC_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
1341 REF_DOC_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
1342 REF_DOC_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
1343 REF_DOC_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
1344 REF_DOC_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
1345 REF_DOC_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
1346 REF_DOC_LINE_ID NUMBER_tbl_type ,
1347 REF_DOC_LIN_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
1348 REF_DOC_LIN_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
1349 REF_DOC_LIN_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
1350 REF_DOC_LIN_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
1351 REF_DOC_LIN_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
1352 REF_DOC_LIN_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
1353 REF_DOC_DIST_ID NUMBER_tbl_type ,
1354 REF_DOC_DIST_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
1355 REF_DOC_DIST_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
1356 REF_DOC_DIST_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
1357 REF_DOC_DIST_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
1358 REF_DOC_DIST_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
1359 REF_DOC_DIST_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
1360 REF_DOC_CURR_CONV_RATE NUMBER_tbl_type ,
1361 NUMERIC1 NUMBER_tbl_type ,
1362 NUMERIC2 NUMBER_tbl_type ,
1363 NUMERIC3 NUMBER_tbl_type ,
1364 NUMERIC4 NUMBER_tbl_type ,
1365 NUMERIC5 NUMBER_tbl_type ,
1366 CHAR1 VARCHAR2_150_tbl_type ,
1367 CHAR2 VARCHAR2_150_tbl_type ,
1368 CHAR3 VARCHAR2_150_tbl_type ,
1369 CHAR4 VARCHAR2_150_tbl_type ,
1370 CHAR5 VARCHAR2_150_tbl_type ,
1371 DATE1 DATE_tbl_type ,
1372 DATE2 DATE_tbl_type ,
1373 DATE3 DATE_tbl_type ,
1374 DATE4 DATE_tbl_type ,
1375 DATE5 DATE_tbl_type ,
1376 TRX_LINE_DIST_TAX_AMT NUMBER_tbl_type ,
1377 HISTORICAL_FLAG VARCHAR2_1_tbl_type);
1378
1379
1380 /* ======================================================================*
1381 | Global Variables |
1382 * ======================================================================*/
1383
1384 g_clean_up_flag VARCHAR2(1);
1385 g_log_destination VARCHAR2(30); --SPOOL,LOGFILE,LOGV
1386 g_trx_date DATE;
1387 g_adj_doc_date DATE;
1388 g_rel_doc_date DATE;
1389 g_line_max_size BINARY_INTEGER;
1390 g_file UTL_FILE.FILE_TYPE;
1391 g_initial_file_reading_flag VARCHAR2(1);
1392 g_line_buffer LONG;
1393 g_next_line_buffer LONG;
1394 g_next_line_return_status VARCHAR2(2000);
1395 g_separator VARCHAR2(1);
1396 g_start_string NUMBER;
1397 g_end_string NUMBER;
1398 g_counter NUMBER;
1399 g_position_last_separator NUMBER;
1400 g_last_portion_prev_string VARCHAR2(2000);
1401 g_string_segment VARCHAR2(2000);
1402 g_line_segment_string VARCHAR2(2000);
1403 g_retrieve_another_segment VARCHAR2(1);
1404 g_line_segment_counter NUMBER;
1405 g_element_in_segment_count NUMBER;
1406 g_file_curr_line_counter NUMBER;
1407 g_current_datafile_section VARCHAR2(80); --Values, INPUT_DATA,OUTPUT_DATA.
1408 g_api_version NUMBER;
1409 g_log_variable LONG; -- Used to store the log.
1410 g_header_cache_counter NUMBER;
1411 g_line_cache_counter NUMBER;
1412 g_dist_cache_counter NUMBER;
1413
1414
1415 ----------------------------------
1416 -- Global Variables of Record Type
1417 ----------------------------------
1418 g_party_rec party_rec_type;
1419 g_transaction_rec zx_api_pub.transaction_rec_type;
1420 g_transaction_line_rec zx_api_pub.transaction_line_rec_type;
1421 g_sync_trx_rec zx_api_pub.sync_trx_rec_type;
1422
1423 -------------------------------------------------
1424 -- Global Variables of Table Type
1425 -------------------------------------------------
1426 g_surr_trx_id_tbl surr_trx_id_type_tbl_type;
1427 g_surr_trx_line_id_tbl surr_trx_line_id_tbl_type;
1428 g_surr_trx_dist_id_tbl surr_trx_dist_id_tbl_type;
1429 g_suite_rec_tbl suite_rec_tbl_type;
1430 g_trx_headers_cache_rec_tbl zx_trx_headers_rec_tbl_type;
1431 g_trx_lines_cache_rec_tbl zx_trx_lines_rec_tbl_type;
1432 g_dist_lines_cache_rec_tbl zx_dist_lines_rec_tbl_type;
1433 g_sync_trx_lines_tbl zx_api_pub.sync_trx_lines_tbl_type%type;
1434
1435
1436 /* =======================================================================*
1437 | PROCEDURE write_message: Write output depending of the value given in |
1438 | g_log_destination |
1439 * =======================================================================*/
1440 PROCEDURE write_message(p_message IN VARCHAR2);
1441
1442 /*===========================================================================*
1443 | PROCEDURE get_log: Retrieves the log stored in global_variable |
1444 *============================================================================*/
1445 PROCEDURE get_log ( x_log OUT NOCOPY LONG );
1446
1447
1448 /* ======================================================================*
1449 | PROCEDURE Initialize_file : Open the file for reading. |
1450 * ======================================================================*/
1451 PROCEDURE initialize_file
1452 (
1453 p_file_dir IN VARCHAR2,
1454 p_file_name IN VARCHAR2,
1455 x_return_status OUT NOCOPY VARCHAR2
1456 );
1457
1458 /* ======================================================================*
1459 | PROCEDURE close_file : Close the current file for reading. |
1460 * ======================================================================*/
1461 PROCEDURE close_file
1462 (
1463 x_return_status OUT NOCOPY VARCHAR2
1464 );
1465
1466 /* ============================================================================*
1467 | PROCEDURE retrieve_another_segment:Retrieve next segment(1000 chrs)from line|
1468 * ===========================================================================*/
1469 PROCEDURE retrieve_another_segment
1470 (
1471 x_return_status OUT NOCOPY VARCHAR2
1472 );
1473
1474 /* ======================================================================*
1475 | PROCEDURE read_line : Reads a line from the file and puts it on buffer|
1476 * ======================================================================*/
1477 PROCEDURE read_line
1478 (
1479 x_line_suite OUT NOCOPY VARCHAR2,
1480 x_line_case OUT NOCOPY VARCHAR2,
1481 x_line_api OUT NOCOPY VARCHAR2,
1482 x_line_task OUT NOCOPY VARCHAR2,
1483 x_line_structure OUT NOCOPY VARCHAR2,
1484 x_line_counter OUT NOCOPY NUMBER,
1485 x_line_is_end_of_case OUT NOCOPY VARCHAR2,
1486 x_current_datafile_section OUT NOCOPY VARCHAR2,
1487 x_return_status OUT NOCOPY VARCHAR2
1488 ) ;
1489
1490 /* ============================================================================*
1491 | PROCEDURE get_next_element_in_row : From the line in buffer retrieves next |
1492 | element |
1493 * ===========================================================================*/
1494 PROCEDURE get_next_element_in_row
1495 (
1496 x_element OUT NOCOPY VARCHAR2 ,
1497 x_return_status OUT NOCOPY VARCHAR2
1498 ) ;
1499
1500 /* ============================================================================*
1501 | PROCEDURE surrogate_key: Populate the surrogate keys |
1502 * ===========================================================================*/
1503 PROCEDURE surrogate_key
1504 (
1505 p_surrogate_key IN VARCHAR2,
1506 x_real_value OUT NOCOPY NUMBER,
1507 p_type IN VARCHAR2
1508 );
1509
1510 /* ============================================================================*
1511 | PROCEDURE check_surrogate_key : Checks the existence of surrogate key |
1512 * ===========================================================================*/
1513 PROCEDURE check_surrogate_key
1514 (
1515 p_key IN VARCHAR2,
1516 x_value OUT NOCOPY NUMBER,
1517 p_type IN VARCHAR2
1518 );
1519
1520 /* ============================================================================*
1521 | PROCEDURE break_user_key_into_segments:Break in segments string for UserKeys|
1522 * ===========================================================================*/
1523 PROCEDURE break_user_key_into_segments
1524 (
1525 p_string IN VARCHAR2,
1526 p_separator IN VARCHAR2,
1527 x_number_of_segments OUT NOCOPY NUMBER,
1528 x_user_key_tbl OUT NOCOPY user_keys_segments_tbl_type
1529 ) ;
1530
1531 /* ===========================================================================*
1532 | PROCEDURE get_user_key_id: Retrieve the ID for the User Keys |
1533 * ===========================================================================*/
1534 PROCEDURE get_user_key_id
1535 (
1536 p_user_key_string IN VARCHAR2,
1537 p_user_key_type IN VARCHAR2,
1538 x_user_key_id OUT NOCOPY NUMBER
1539 ) ;
1540
1541 /* ======================================================================*
1542 | PROCEDURE put_data_in_party_rec : Put party_rec data in the a record |
1543 * ======================================================================*/
1544 PROCEDURE put_data_in_party_rec
1545 (
1546 p_header_row IN NUMBER
1547 );
1548
1549
1550 /* ============================================================================*
1551 | PROCEDURE insert_data_trx_headers_gt:Inserts row in ZX_TRANSACTION_HEADERS_GT
1552 * ===========================================================================*/
1553 PROCEDURE insert_data_trx_headers_gt
1554 (
1555 p_row_id IN NUMBER
1556 );
1557
1558 /* ============================================================================*
1559 | PROCEDURE insert_data_trx_lines_gt :Inserts a row in ZX_TRANSACTION_LINES_GT|
1560 * ===========================================================================*/
1561 PROCEDURE insert_data_trx_lines_gt
1562 (
1563 p_header_row IN NUMBER,
1564 p_starting_line_row IN NUMBER,
1565 p_ending_line_row IN NUMBER
1566 );
1567
1568 /* ============================================================================*
1569 | PROCEDURE insert_data_mrc_gt :Inserts a row in ZX_MRC_GT |
1570 * ===========================================================================*/
1571 PROCEDURE insert_data_mrc_gt
1572 (
1573 p_header_row IN NUMBER
1574 );
1575
1576
1577 /* ============================================================================*
1578 | PROCEDURE insert_transaction_rec : Populate the row in transaction_rec |
1579 * ===========================================================================*/
1580 PROCEDURE insert_transaction_rec
1581 (
1582 p_transaction_rec IN OUT NOCOPY zx_api_pub.transaction_rec_type
1583 );
1584
1585 /* ============================================================================*
1586 | PROCEDURE insert_row_transaction_rec : Populate the row in transaction_rec |
1587 * ============================================================================*/
1588
1589 PROCEDURE insert_row_transaction_rec (
1590 p_transaction_rec IN OUT NOCOPY zx_api_pub.transaction_rec_type,
1591 p_initial_row IN NUMBER
1592 );
1593
1594
1595 /* ============================================================================*
1596 | PROCEDURE insert_import_sum_tax_lines_gt:Populate the row in transaction_rec|
1597 * ===========================================================================*/
1598 PROCEDURE insert_import_sum_tax_lines_gt
1599 (
1600 p_starting_row_tax_lines IN NUMBER,
1601 p_ending_row_tax_lines IN NUMBER
1602 );
1603
1604 /* ====================================================================*
1605 | PROCEDURE insert_trx_tax_link_gt:Insert a row in ZX_TRX_TAX_LINK_GT |
1606 * ====================================================================*/
1607 PROCEDURE insert_trx_tax_link_gt
1608 (
1609 p_sta_row_imp_tax_link IN NUMBER,
1610 p_end_row_imp_tax_link IN NUMBER
1611 );
1612
1613
1614 /* ===========================================================================*
1615 | PROCEDURE insert_reverse_trx_lines_gt:Insert row in ZX_REVERSE_TRX_LINES_GT|
1616 * ===========================================================================*/
1617 PROCEDURE insert_reverse_trx_lines_gt;
1618
1619 /* ============================================================================*
1620 | PROCEDURE insert_reverse_dist_lines_gt:Insert row in ZX_REVERSE_TRX_LINES_GT|
1621 * ===========================================================================*/
1622 PROCEDURE insert_reverse_dist_lines_gt;
1623
1624 /* ============================================================================*
1625 | PROCEDURE insert_itm_distributions_gt:Insert row in ZX_ITM_DISTRIBUTIONS_GT |
1626 * ===========================================================================*/
1627 PROCEDURE insert_itm_distributions_gt
1628 (
1629 p_header_row IN NUMBER,
1630 p_sta_row_item_dist IN NUMBER,
1631 p_end_row_item_dist IN NUMBER
1632 );
1633
1634 /* ========================================================================*
1635 | PROCEDURE Insert rows into ZX_TAX_DIST_ID_GT from zx_rec_nrec_dist |
1636 * ========================================================================*/
1637 PROCEDURE insert_rows_tax_dist_id_gt(p_trx_id IN NUMBER);
1638
1639
1640 /* =========================================================================*
1641 | PROCEDURE insert_sync_trx_rec: Insert the row in the sync trx record |
1642 * =========================================================================*/
1643 PROCEDURE insert_sync_trx_rec
1644 (
1645 p_header_row IN NUMBER,
1646 x_sync_trx_rec OUT NOCOPY zx_api_pub.sync_trx_rec_type
1647 );
1648
1649 /* =========================================================================*
1650 | PROCEDURE insert_sync_trx_lines_tbl:Insert a row in sync_trx_lines_tbl |
1651 * =========================================================================*/
1652 PROCEDURE insert_sync_trx_lines_tbl
1653 (
1654 p_header_row IN NUMBER,
1655 p_starting_row_sync_trx_lines IN NUMBER,
1656 p_ending_row_sync_trx_lines IN NUMBER,
1657 x_sync_trx_lines_tbl OUT NOCOPY zx_api_pub.sync_trx_lines_tbl_type%type
1658 );
1659
1660
1661 /* ===========================================================================*
1662 | PROCEDURE insert_transaction_line_rec: Populate the transaction_line_rec |
1663 * ===========================================================================*/
1664 PROCEDURE insert_transaction_line_rec
1665 (
1666 p_transaction_line_rec IN OUT NOCOPY zx_api_pub.transaction_line_rec_type,
1667 p_row_trx_line IN NUMBER
1668 );
1669
1670 /* ======================================================================*
1671 | PROCEDURE delete_table : Initialize a row of record of tables |
1672 | |
1673 * ======================================================================*/
1674 PROCEDURE delete_table ;
1675
1676 /* ======================================================================*
1677 | PROCEDURE initialize_row : Initialize a row of record of tables |
1678 | |
1679 * ======================================================================*/
1680 PROCEDURE Initialize_row
1681 (
1682 p_record_counter IN NUMBER
1683 );
1684
1685
1686 /* ======================================================================*
1687 | PROCEDURE put_line_in_suite_rec_tbl : Read a line from flat file and |
1688 | puts it in a record variable |
1689 * ======================================================================*/
1690 PROCEDURE put_line_in_suite_rec_tbl
1691 (
1692 x_suite_number OUT NOCOPY VARCHAR2,
1693 x_case_number OUT NOCOPY VARCHAR2,
1694 x_api_name OUT NOCOPY VARCHAR2,
1695 x_api_service OUT NOCOPY VARCHAR2,
1696 x_api_structure OUT NOCOPY VARCHAR2,
1697 p_header_row IN NUMBER,
1698 p_record_counter IN NUMBER
1699 );
1700
1701
1702 /* ============================================================================*
1703 | PROCEDURE call_api : Logic to Call the APIs |
1704 * ===========================================================================*/
1705 PROCEDURE call_api
1706 (
1707 p_api_service IN VARCHAR,
1708 p_suite_number IN VARCHAR,
1709 p_case_number IN VARCHAR,
1710 p_transaction_id IN NUMBER
1711 );
1712
1713 /* ============================================================================*
1714 | PROCEDURE insert_into_gts : Logic to Insert in the Global Temporary Tables |
1715 * ===========================================================================*/
1716 PROCEDURE insert_into_gts
1717 (
1718 p_suite_number IN VARCHAR2,
1719 p_case_number IN VARCHAR2,
1720 p_service IN VARCHAR2,
1721 p_structure IN VARCHAR2,
1722 p_header_row_id IN NUMBER,
1723 p_starting_row_id IN NUMBER,
1724 p_ending_row_id IN NUMBER,
1725 p_prev_trx_id IN NUMBER
1726 );
1727
1728
1729 /* ======================================================================*
1730 | PROCEDURE Get_Tax_Event_Type : Get Tax Event Type |
1731 * ======================================================================*/
1732 FUNCTION Get_Tax_Event_Type
1733 (
1734 p_appln_id IN NUMBER,
1735 p_entity_code IN VARCHAR2,
1736 p_evnt_cls_code IN VARCHAR2,
1737 p_evnt_typ_code IN VARCHAR2
1738 ) RETURN VARCHAR2;
1739
1740
1741 /* ===================================================================*
1742 | FUNCTION RETRIEVE_NTH_ELEMENT: Retrieves a element from a string |
1743 * ===================================================================*/
1744 FUNCTION GET_NTH_ELEMENT
1745 (
1746 p_element_number IN NUMBER,
1747 p_string IN VARCHAR2,
1748 p_separator IN VARCHAR2
1749 ) RETURN VARCHAR2;
1750
1751
1752 /* =======================================================================*
1753 | PROCEDURE Populate_Report_Table : Populates the Report Table to display|
1754 | the results of the Suite. |
1755 * =======================================================================*/
1756 PROCEDURE Populate_Report_Table
1757 (
1758 p_suite IN VARCHAR2,
1759 p_case IN VARCHAR2,
1760 p_service IN VARCHAR2,
1761 p_transaction_id IN NUMBER,
1762 p_error_flag IN VARCHAR2,
1763 p_error_message IN VARCHAR2
1764 );
1765
1766 /* ===========================================================================*
1767 | PROCEDURE populate_trx_header_cache : Caches the Transaction Header Info |
1768 | from a row in g_suite_rec_tbl |
1769 * ===========================================================================*/
1770 PROCEDURE populate_trx_header_cache
1771 (
1772 p_header_row_id IN NUMBER
1773 );
1774
1775 /* =======================================================================*
1776 | PROCEDURE populate_trx_lines_cache : Caches the Transaction Lines Info |
1777 | from a row in g_suite_rec_tbl |
1778 * =======================================================================*/
1779 PROCEDURE populate_trx_lines_cache
1780 (
1781 p_header_row_id IN NUMBER,
1782 p_line_row_id IN NUMBER
1783 );
1784
1785 /* ===========================================================================*
1786 | PROCEDURE populate_dist_lines_cache : Caches the Distribution Lines Info |
1787 | from a row in g_suite_rec_tbl |
1788 * ===========================================================================*/
1789 PROCEDURE populate_dist_lines_cache
1790 (
1791 p_dist_row_id IN NUMBER
1792 );
1793
1794 /* ============================================================================*
1795 | PROCEDURE update_trx_header_cache : Update the Cache Transaction Header Info|
1796 | from a row in g_suite_rec_tbl |
1797 * ===========================================================================*/
1798 PROCEDURE update_trx_header_cache
1799 (
1800 p_header_row_id IN NUMBER
1801 );
1802
1803 /* =======================================================================*
1804 | PROCEDURE update_trx_lines_cache : Update the Cache Lines Info |
1805 | from a row in g_suite_rec_tbl |
1806 * =======================================================================*/
1807 PROCEDURE update_trx_lines_cache
1808 (
1809 p_header_row_id IN NUMBER,
1810 p_line_row_id IN NUMBER
1811 );
1812
1813 /* =======================================================================*
1814 | PROCEDURE update_dist_lines_cache : Update the Cache Dist Lines Info |
1815 | from a row in g_suite_rec_tbl |
1816 * =======================================================================*/
1817 PROCEDURE update_dist_lines_cache
1818 (
1819 p_dist_row_id IN NUMBER
1820 );
1821
1822 /* ============================================================================*
1823 | PROCEDURE merge_with_dist_lines_cache : Merges Dist Lines for current Case |
1824 | when RE-DISTRIBUTE. Merges the |
1825 | actual given lines plus the lines |
1826 | not given but existing in the cache |
1827 | Lines taken from Cache will be |
1828 | marked as NO-ACTION. |
1829 * ============================================================================*/
1830
1831 PROCEDURE merge_with_dist_lines_cache
1832 (
1833 p_suite IN VARCHAR2,
1834 p_case IN VARCHAR2
1835 );
1836
1837 /* =========================================================================*
1838 | PROCEDURE insert_tax_dist_id_gt :Retrieves TAX_DIST_ID depending on |
1839 | what STRUCTURE is being passed when |
1840 | calling using service |
1841 | FREEZE_DISTRIBUTIONS |
1842 | The Structures are: |
1843 | STRUCTURE_TAX_LINE_KEY |
1844 | STRUCTURE_ITEM_DISTRIBUTION_KEY |
1845 | STRUCTURE_TRANSACTION_LINE_KEY |
1846 | Also Pupulates ZX_TAX_DIST_ID_GT |
1847 * =========================================================================*/
1848 PROCEDURE insert_tax_dist_id_gt
1849 (
1850 p_suite IN VARCHAR2,
1851 p_case IN VARCHAR2,
1852 p_structure IN VARCHAR2
1853 );
1854
1855 /* ============================================================================*
1856 | PROCEDURE perform_data_caching : Calls all the procedures needed for Caching|
1857 | depending on the Scenario Executed |
1858 * ===========================================================================*/
1859 PROCEDURE perform_data_caching
1860 (
1861 p_suite_number IN VARCHAR2,
1862 p_case_number IN VARCHAR2,
1863 p_service IN VARCHAR2,
1864 p_structure IN VARCHAR2,
1865 p_header_row_id IN NUMBER,
1866 p_starting_row_id IN NUMBER,
1867 p_ending_row_id IN NUMBER,
1868 p_prev_trx_id IN NUMBER
1869 );
1870
1871
1872 /*============================================================================*
1873 | PROCEDURE get_start_end_rows_structure: Retrieves the initial and ending |
1874 | rows of a Structure in g_suite_rec_tbl |
1875 *============================================================================*/
1876 PROCEDURE get_start_end_rows_structure
1877 (
1878 p_suite IN VARCHAR2,
1879 p_case IN VARCHAR2,
1880 p_structure IN VARCHAR2,
1881 x_start_row OUT NOCOPY NUMBER,
1882 x_end_row OUT NOCOPY NUMBER
1883 );
1884
1885
1886 /*============================================================================*
1887 | PROCEDURE get_zx_errors_gt: Retrieves the errors stored in ZX_ERRORS_GT |
1888 *============================================================================*/
1889 PROCEDURE get_zx_errors_gt
1890 (
1891 x_message OUT NOCOPY VARCHAR2
1892 );
1893
1894
1895
1896 /*============================================================================*
1897 | MAIN PROCEDURE test_api : Main procedure to call the testing of eTax APIs |
1898 *============================================================================*/
1899 PROCEDURE test_api
1900 (
1901 p_file IN VARCHAR2,
1902 p_directory IN VARCHAR2,
1903 x_log OUT NOCOPY LONG
1904 );
1905
1906 END ZX_TEST_API;