[Home] [Help]
PACKAGE: APPS.ZX_GLOBAL_STRUCTURES_PKG
Source
1 PACKAGE ZX_GLOBAL_STRUCTURES_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxifgblparampkgs.pls 120.104.12020000.2 2012/07/23 12:56:15 srajapar noship $ */
3
4 /* ======================================================================*
5 | Global Structure Data Types |
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_20_tbl_type IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER;
14 TYPE VARCHAR2_30_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
15 TYPE VARCHAR2_40_tbl_type IS TABLE OF VARCHAR2(40) INDEX BY BINARY_INTEGER;
16 TYPE VARCHAR2_50_tbl_type IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
17 TYPE VARCHAR2_80_tbl_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
18 TYPE VARCHAR2_150_tbl_type IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
19 TYPE VARCHAR2_240_tbl_type IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
20 TYPE VARCHAR2_250_tbl_type IS TABLE OF VARCHAR2(250) INDEX BY BINARY_INTEGER;
21 --Bug 10384862 starts
22 TYPE VARCHAR2_300_tbl_type IS TABLE OF VARCHAR2(300) INDEX BY BINARY_INTEGER;
23 --Bug 10384862 ends
24 TYPE VARCHAR2_360_tbl_type IS TABLE OF VARCHAR2(360) INDEX BY BINARY_INTEGER;
25 TYPE VARCHAR2_2000_tbl_type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
26
27 -- The following record structure is used to cache information in zx_evnt_cls_mappings
28 -- The information in the structure is valid throughout the session.
29 TYPE ZX_EVENT_CLASS_RECTYPE is RECORD
30 (EVENT_CLASS_CODE zx_evnt_cls_mappings.EVENT_CLASS_CODE%type,
31 APPLICATION_ID zx_evnt_cls_mappings.APPLICATION_ID%type,
32 ENTITY_CODE zx_evnt_cls_mappings.ENTITY_CODE%type,
33 TAX_EVENT_CLASS_CODE zx_evnt_cls_mappings.TAX_EVENT_CLASS_CODE%type,
34 RECORD_FLAG zx_evnt_cls_mappings.RECORD_FLAG%type,
35 DET_FACTOR_TEMPL_CODE zx_evnt_cls_mappings.DET_FACTOR_TEMPL_CODE%type,
39 ROUNDING_LEVEL_HIER_3_CODE zx_evnt_cls_mappings.ROUNDING_LEVEL_HIER_3_CODE%type,
36 DEFAULT_ROUNDING_LEVEL_CODE zx_evnt_cls_mappings.DEFAULT_ROUNDING_LEVEL_CODE%type,
37 ROUNDING_LEVEL_HIER_1_CODE zx_evnt_cls_mappings.ROUNDING_LEVEL_HIER_1_CODE%type,
38 ROUNDING_LEVEL_HIER_2_CODE zx_evnt_cls_mappings.ROUNDING_LEVEL_HIER_2_CODE%type,
40 ROUNDING_LEVEL_HIER_4_CODE zx_evnt_cls_mappings.ROUNDING_LEVEL_HIER_4_CODE%type,
41 ALLOW_MANUAL_LIN_RECALC_FLAG zx_evnt_cls_mappings.ALLOW_MANUAL_LIN_RECALC_FLAG%type,
42 ALLOW_OVERRIDE_FLAG zx_evnt_cls_mappings.ALLOW_OVERRIDE_FLAG%type,
43 ALLOW_MANUAL_LINES_FLAG zx_evnt_cls_mappings.ALLOW_MANUAL_LINES_FLAG%type,
44 PERF_ADDNL_APPL_FOR_IMPRT_FLAG zx_evnt_cls_mappings.PERF_ADDNL_APPL_FOR_IMPRT_FLAG%type,
45 SHIP_TO_PARTY_TYPE zx_evnt_cls_mappings.SHIP_TO_PARTY_TYPE%type,
46 SHIP_FROM_PARTY_TYPE zx_evnt_cls_mappings.SHIP_FROM_PARTY_TYPE%type,
47 POA_PARTY_TYPE zx_evnt_cls_mappings.POA_PARTY_TYPE%type,
48 POO_PARTY_TYPE zx_evnt_cls_mappings.POO_PARTY_TYPE%type,
49 PAYING_PARTY_TYPE zx_evnt_cls_mappings.PAYING_PARTY_TYPE%type,
50 OWN_HQ_PARTY_TYPE zx_evnt_cls_mappings.OWN_HQ_PARTY_TYPE%type,
51 TRAD_HQ_PARTY_TYPE zx_evnt_cls_mappings.TRAD_HQ_PARTY_TYPE%type,
52 POI_PARTY_TYPE zx_evnt_cls_mappings.POI_PARTY_TYPE%type,
53 POD_PARTY_TYPE zx_evnt_cls_mappings.POD_PARTY_TYPE%type,
54 BILL_TO_PARTY_TYPE zx_evnt_cls_mappings.BILL_TO_PARTY_TYPE%type,
55 BILL_FROM_PARTY_TYPE zx_evnt_cls_mappings.BILL_FROM_PARTY_TYPE%type,
56 TTL_TRNS_PARTY_TYPE zx_evnt_cls_mappings.TTL_TRNS_PARTY_TYPE%type,
57 MERCHANT_PARTY_TYPE zx_evnt_cls_mappings.MERCHANT_PARTY_TYPE%type,
58 SHIP_TO_PTY_SITE_TYPE zx_evnt_cls_mappings.SHIP_TO_PTY_SITE_TYPE%type,
59 SHIP_FROM_PTY_SITE_TYPE zx_evnt_cls_mappings.SHIP_FROM_PTY_SITE_TYPE%type,
60 POA_PTY_SITE_TYPE zx_evnt_cls_mappings.POA_PTY_SITE_TYPE%type,
61 POO_PTY_SITE_TYPE zx_evnt_cls_mappings.POO_PTY_SITE_TYPE%type,
62 PAYING_PTY_SITE_TYPE zx_evnt_cls_mappings.PAYING_PTY_SITE_TYPE%type,
63 OWN_HQ_PTY_SITE_TYPE zx_evnt_cls_mappings.OWN_HQ_PTY_SITE_TYPE%type,
64 TRAD_HQ_PTY_SITE_TYPE zx_evnt_cls_mappings.TRAD_HQ_PTY_SITE_TYPE%type,
65 POI_PTY_SITE_TYPE zx_evnt_cls_mappings.POI_PTY_SITE_TYPE%type,
66 POD_PTY_SITE_TYPE zx_evnt_cls_mappings.POD_PTY_SITE_TYPE%type,
67 BILL_TO_PTY_SITE_TYPE zx_evnt_cls_mappings.BILL_TO_PTY_SITE_TYPE%type,
68 BILL_FROM_PTY_SITE_TYPE zx_evnt_cls_mappings.BILL_FROM_PTY_SITE_TYPE%type,
69 TTL_TRNS_PTY_SITE_TYPE zx_evnt_cls_mappings.TTL_TRNS_PTY_SITE_TYPE%type,
70 ENFORCE_TAX_FROM_ACCT_FLAG zx_evnt_cls_mappings.ENFORCE_TAX_FROM_ACCT_FLAG%type,
71 OFFSET_TAX_BASIS_CODE zx_evnt_cls_mappings.OFFSET_TAX_BASIS_CODE%type,
72 REFERENCE_APPLICATION_ID zx_evnt_cls_mappings.REFERENCE_APPLICATION_ID%type,
73 PROD_FAMILY_GRP_CODE zx_evnt_cls_mappings.PROD_FAMILY_GRP_CODE%type,
74 ALLOW_OFFSET_TAX_CALC_FLAG zx_evnt_cls_mappings.ALLOW_OFFSET_TAX_CALC_FLAG%type,
75 SELF_ASSESS_TAX_LINES_FLAG zx_evnt_cls_mappings.SELF_ASSESS_TAX_LINES_FLAG%type,
76 TAX_RECOVERY_FLAG zx_evnt_cls_mappings.TAX_RECOVERY_FLAG%type,
77 ALLOW_CANCEL_TAX_LINES_FLAG zx_evnt_cls_mappings.ALLOW_CANCEL_TAX_LINES_FLAG%type,
78 ALLOW_MAN_TAX_ONLY_LINES_FLAG zx_evnt_cls_mappings.ALLOW_MAN_TAX_ONLY_LINES_FLAG%type,
79 TAX_VARIANCE_CALC_FLAG zx_evnt_cls_mappings.TAX_VARIANCE_CALC_FLAG%type,
80 TAX_REPORTING_FLAG zx_evnt_cls_mappings.TAX_REPORTING_FLAG%type,
81 ENTER_OVRD_INCL_TAX_LINES_FLAG zx_evnt_cls_mappings.ENTER_OVRD_INCL_TAX_LINES_FLAG%type,
82 CTRL_EFF_OVRD_CALC_LINES_FLAG zx_evnt_cls_mappings.CTRL_EFF_OVRD_CALC_LINES_FLAG%type,
83 SUMMARIZATION_FLAG zx_evnt_cls_mappings.SUMMARIZATION_FLAG%type,
84 RETAIN_SUMM_TAX_LINE_ID_FLAG zx_evnt_cls_mappings.RETAIN_SUMM_TAX_LINE_ID_FLAG%type,
85 RECORD_FOR_PARTNERS_FLAG zx_evnt_cls_mappings.RECORD_FOR_PARTNERS_FLAG%type,
86 MANUAL_LINES_FOR_PARTNER_FLAG zx_evnt_cls_mappings.MANUAL_LINES_FOR_PARTNER_FLAG%type,
87 MAN_TAX_ONLY_LIN_FOR_PTNR_FLAG zx_evnt_cls_mappings.MAN_TAX_ONLY_LIN_FOR_PTNR_FLAG%type,
88 ALWAYS_USE_EBTAX_FOR_CALC_FLAG zx_evnt_cls_mappings.ALWAYS_USE_EBTAX_FOR_CALC_FLAG%type,
89 PROCESSING_PRECEDENCE zx_evnt_cls_mappings.PROCESSING_PRECEDENCE%type,
90 EVENT_CLASS_MAPPING_ID zx_evnt_cls_mappings.EVENT_CLASS_MAPPING_ID%type,
91 ENFORCE_TAX_FROM_REF_DOC_FLAG zx_evnt_cls_mappings.ENFORCE_TAX_FROM_REF_DOC_FLAG%type,
92 PROCESS_FOR_APPLICABILITY_FLAG zx_evnt_cls_mappings.PROCESS_FOR_APPLICABILITY_FLAG%type,
93 SUP_CUST_ACCT_TYPE_CODE zx_evnt_cls_mappings.SUP_CUST_ACCT_TYPE_CODE%type,
94 DISPLAY_TAX_CLASSIF_FLAG zx_evnt_cls_mappings.DISPLAY_TAX_CLASSIF_FLAG%type,
95 INTGRTN_DET_FACTORS_UI_FLAG zx_evnt_cls_mappings.INTGRTN_DET_FACTORS_UI_FLAG%type,
96 INTRCMP_TX_EVNT_CLS_CODE zx_evnt_cls_mappings.INTRCMP_TX_EVNT_CLS_CODE%type,
97 INTRCMP_SRC_ENTITY_CODE zx_evnt_cls_mappings.INTRCMP_SRC_ENTITY_CODE%type,
98 INTRCMP_SRC_EVNT_CLS_CODE zx_evnt_cls_mappings.INTRCMP_SRC_EVNT_CLS_CODE%type,
99 INTRCMP_SRC_APPLN_ID zx_evnt_cls_mappings.INTRCMP_SRC_APPLN_ID%type,
100 ALLOW_EXEMPTIONS_FLAG zx_evnt_cls_mappings.ALLOW_EXEMPTIONS_FLAG%TYPE,
101 ENABLE_MRC_FLAG zx_evnt_cls_mappings.ENABLE_MRC_FLAG%TYPE);
102
103 TYPE ZX_EVENT_CLASS_REC_TBLTYPE is TABLE of ZX_EVENT_CLASS_RECTYPE
104 index by binary_integer;
105
106 -- The following record structure is used to cache information in zx_evnt_typ_mappings
107 -- The information in the structure is valid throughout the session.
108
109 TYPE EVNT_TYP_MAP_RECTYPE is RECORD
110 (EVENT_CLASS_MAPPING_ID zx_evnt_typ_mappings.EVENT_CLASS_MAPPING_ID%type,
111 EVENT_TYPE_MAPPING_ID zx_evnt_typ_mappings.EVENT_TYPE_MAPPING_ID%type,
112 EVENT_CLASS_CODE zx_evnt_typ_mappings.EVENT_CLASS_CODE%type,
113 EVENT_TYPE_CODE zx_evnt_typ_mappings.EVENT_TYPE_CODE%type,
114 APPLICATION_ID zx_evnt_typ_mappings.APPLICATION_ID%type,
118 ENABLED_FLAG zx_evnt_typ_mappings.ENABLED_FLAG%type);
115 ENTITY_CODE zx_evnt_typ_mappings.ENTITY_CODE%type,
116 TAX_EVENT_CLASS_CODE zx_evnt_typ_mappings.TAX_EVENT_CLASS_CODE%type,
117 TAX_EVENT_TYPE_CODE zx_evnt_typ_mappings.TAX_EVENT_TYPE_CODE%type,
119
120 TYPE EVNT_TYP_MAP_TBLTYPE is table of EVNT_TYP_MAP_RECTYPE
121 index by BINARY_INTEGER;
122
123
124 TYPE TAX_EVENT_CLS_INFO_RECTYPE is RECORD
125 (TAX_EVENT_CLASS_CODE ZX_EVENT_CLASSES_B.TAX_EVENT_CLASS_CODE%type,
126 NORMAL_SIGN_FLAG ZX_EVENT_CLASSES_B.NORMAL_SIGN_FLAG%type,
127 ASC_INTRCMP_TX_EVNT_CLS_CODE ZX_EVENT_CLASSES_B.ASC_INTRCMP_TX_EVNT_CLS_CODE%type);
128
129 TYPE TAX_EVENT_CLS_INFO_TBLTYPE is TABLE of TAX_EVENT_CLS_INFO_RECTYPE
130 index by VARCHAR2(30);
131
132 TYPE trx_line_dist_rec_type IS RECORD
133 (
134 INTERNAL_ORGANIZATION_ID NUMBER_tbl_type ,
135 APPLICATION_ID NUMBER_tbl_type ,
136 ENTITY_CODE VARCHAR2_30_tbl_type ,
137 EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
138 EVENT_TYPE_CODE VARCHAR2_30_tbl_type ,
139 TRX_ID NUMBER_tbl_type ,
140 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
141 TRX_LINE_ID NUMBER_tbl_type ,
142 LINE_LEVEL_ACTION VARCHAR2_30_tbl_type ,
143 LINE_CLASS VARCHAR2_30_tbl_type ,
144 TRX_DATE DATE_tbl_type ,
145 TRX_DOC_REVISION VARCHAR2_150_tbl_type ,
146 LEDGER_ID NUMBER_tbl_type ,
147 TRX_CURRENCY_CODE VARCHAR2_15_tbl_type ,
148 CURRENCY_CONVERSION_DATE DATE_tbl_type ,
149 CURRENCY_CONVERSION_RATE NUMBER_tbl_type ,
150 CURRENCY_CONVERSION_TYPE VARCHAR2_30_tbl_type ,
151 MINIMUM_ACCOUNTABLE_UNIT NUMBER_tbl_type ,
152 PRECISION NUMBER_tbl_type ,
153 TRX_LINE_CURRENCY_CODE VARCHAR2_15_tbl_type ,
154 TRX_LINE_CURRENCY_CONV_DATE DATE_tbl_type ,
155 TRX_LINE_CURRENCY_CONV_RATE NUMBER_tbl_type ,
156 TRX_LINE_CURRENCY_CONV_TYPE VARCHAR2_30_tbl_type ,
157 TRX_LINE_MAU NUMBER_tbl_type ,
158 TRX_LINE_PRECISION NUMBER_tbl_type ,
159 TRX_SHIPPING_DATE DATE_tbl_type ,
160 TRX_RECEIPT_DATE DATE_tbl_type ,
161 LEGAL_ENTITY_ID NUMBER_tbl_type ,
162 ROUNDING_SHIP_TO_PARTY_ID NUMBER_tbl_type ,
163 ROUNDING_SHIP_FROM_PARTY_ID NUMBER_tbl_type ,
164 ROUNDING_BILL_TO_PARTY_ID NUMBER_tbl_type ,
165 ROUNDING_BILL_FROM_PARTY_ID NUMBER_tbl_type ,
166 RNDG_SHIP_TO_PARTY_SITE_ID NUMBER_tbl_type ,
167 RNDG_SHIP_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
168 RNDG_BILL_TO_PARTY_SITE_ID NUMBER_tbl_type ,
169 RNDG_BILL_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
170 ESTABLISHMENT_ID NUMBER_tbl_type ,
171 TRX_LINE_TYPE VARCHAR2_30_tbl_type ,
172 TRX_LINE_DATE DATE_tbl_type ,
173 TRX_BUSINESS_CATEGORY VARCHAR2_240_tbl_type ,
174 LINE_INTENDED_USE VARCHAR2_240_tbl_type ,
175 USER_DEFINED_FISC_CLASS VARCHAR2_30_tbl_type ,
176 LINE_AMT NUMBER_tbl_type ,
177 TRX_LINE_QUANTITY NUMBER_tbl_type ,
178 UNIT_PRICE NUMBER_tbl_type ,
179 EXEMPT_CERTIFICATE_NUMBER VARCHAR2_80_tbl_type ,
180 EXEMPT_REASON VARCHAR2_240_tbl_type ,
181 CASH_DISCOUNT NUMBER_tbl_type ,
182 VOLUME_DISCOUNT NUMBER_tbl_type ,
183 TRADING_DISCOUNT NUMBER_tbl_type ,
184 TRANSFER_CHARGE NUMBER_tbl_type ,
185 TRANSPORTATION_CHARGE NUMBER_tbl_type ,
186 INSURANCE_CHARGE NUMBER_tbl_type ,
187 OTHER_CHARGE NUMBER_tbl_type ,
188 PRODUCT_ID NUMBER_tbl_type ,
189 PRODUCT_FISC_CLASSIFICATION VARCHAR2_240_tbl_type ,
190 PRODUCT_ORG_ID NUMBER_tbl_type ,
191 UOM_CODE VARCHAR2_30_tbl_type ,
192 PRODUCT_TYPE VARCHAR2_240_tbl_type ,
193 --Bug 10384862 starts
194 PRODUCT_CODE VARCHAR2_300_tbl_type ,
195 --Bug 10384862 ends
196 PRODUCT_CATEGORY VARCHAR2_240_tbl_type ,
197 TRX_SIC_CODE VARCHAR2_150_tbl_type ,
198 FOB_POINT VARCHAR2_30_tbl_type ,
199 SHIP_TO_PARTY_ID NUMBER_tbl_type ,
200 SHIP_FROM_PARTY_ID NUMBER_tbl_type ,
201 POA_PARTY_ID NUMBER_tbl_type ,
202 POO_PARTY_ID NUMBER_tbl_type ,
203 BILL_TO_PARTY_ID NUMBER_tbl_type ,
204 BILL_FROM_PARTY_ID NUMBER_tbl_type ,
205 MERCHANT_PARTY_ID NUMBER_tbl_type ,
206 SHIP_TO_PARTY_SITE_ID NUMBER_tbl_type ,
207 SHIP_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
208 POA_PARTY_SITE_ID NUMBER_tbl_type ,
209 POO_PARTY_SITE_ID NUMBER_tbl_type ,
210 BILL_TO_PARTY_SITE_ID NUMBER_tbl_type ,
211 BILL_FROM_PARTY_SITE_ID NUMBER_tbl_type ,
212 SHIP_TO_LOCATION_ID NUMBER_tbl_type ,
213 SHIP_FROM_LOCATION_ID NUMBER_tbl_type ,
217 BILL_FROM_LOCATION_ID NUMBER_tbl_type ,
214 POA_LOCATION_ID NUMBER_tbl_type ,
215 POO_LOCATION_ID NUMBER_tbl_type ,
216 BILL_TO_LOCATION_ID NUMBER_tbl_type ,
218 ACCOUNT_CCID NUMBER_tbl_type ,
219 ACCOUNT_STRING VARCHAR2_2000_tbl_type ,
220 MERCHANT_PARTY_COUNTRY VARCHAR2_150_tbl_type ,
221 RECEIVABLES_TRX_TYPE_ID NUMBER_tbl_type ,
222 REF_DOC_APPLICATION_ID NUMBER_tbl_type ,
223 REF_DOC_ENTITY_CODE VARCHAR2_30_tbl_type ,
224 REF_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
225 REF_DOC_TRX_ID NUMBER_tbl_type ,
226 REF_DOC_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
227 REF_DOC_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
228 REF_DOC_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
229 REF_DOC_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
230 REF_DOC_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
231 REF_DOC_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
232 REF_DOC_LINE_ID NUMBER_tbl_type ,
233 REF_DOC_LIN_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
234 REF_DOC_LIN_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
235 REF_DOC_LIN_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
236 REF_DOC_LIN_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
237 REF_DOC_LIN_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
238 REF_DOC_LIN_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
239 REF_DOC_LINE_QUANTITY NUMBER_tbl_type ,
240 RELATED_DOC_APPLICATION_ID NUMBER_tbl_type ,
241 RELATED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type ,
242 RELATED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
243 RELATED_DOC_TRX_ID NUMBER_tbl_type ,
244 REL_DOC_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
245 REL_DOC_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
246 REL_DOC_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
247 REL_DOC_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
248 REL_DOC_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
249 REL_DOC_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
250 RELATED_DOC_NUMBER VARCHAR2_150_tbl_type ,
251 RELATED_DOC_DATE DATE_tbl_type ,
252 APPLIED_FROM_APPLICATION_ID NUMBER_tbl_type ,
253 APPLIED_FROM_ENTITY_CODE VARCHAR2_30_tbl_type ,
254 APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
255 APPLIED_FROM_TRX_ID NUMBER_tbl_type ,
256 APP_FROM_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
257 APP_FROM_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
258 APP_FROM_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
259 APP_FROM_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
260 APP_FROM_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
261 APP_FROM_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
262 APPLIED_FROM_LINE_ID NUMBER_tbl_type ,
263 APPLIED_FROM_TRX_NUMBER VARCHAR2_150_tbl_type ,
264 APP_FROM_LIN_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
265 APP_FROM_LIN_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
266 APP_FROM_LIN_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
267 APP_FROM_LIN_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
268 APP_FROM_LIN_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
269 APP_FROM_LIN_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
270 ADJUSTED_DOC_APPLICATION_ID NUMBER_tbl_type ,
271 ADJUSTED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type ,
272 ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
273 ADJUSTED_DOC_TRX_ID NUMBER_tbl_type ,
274 ADJ_DOC_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
275 ADJ_DOC_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
276 ADJ_DOC_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
277 ADJ_DOC_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
278 ADJ_DOC_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
279 ADJ_DOC_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
280 ADJUSTED_DOC_LINE_ID NUMBER_tbl_type ,
281 ADJ_DOC_LIN_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
282 ADJ_DOC_LIN_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
283 ADJ_DOC_LIN_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
284 ADJ_DOC_LIN_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
285 ADJ_DOC_LIN_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
286 ADJ_DOC_LIN_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
287 ADJUSTED_DOC_NUMBER VARCHAR2_150_tbl_type ,
288 ADJUSTED_DOC_DATE DATE_tbl_type ,
289 APPLIED_TO_APPLICATION_ID NUMBER_tbl_type ,
290 APPLIED_TO_ENTITY_CODE VARCHAR2_30_tbl_type ,
291 APPLIED_TO_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
292 APPLIED_TO_TRX_ID NUMBER_tbl_type ,
293 APP_TO_HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
294 APP_TO_HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
295 APP_TO_HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
296 APP_TO_HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
297 APP_TO_HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
298 APP_TO_HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
299 APPLIED_TO_TRX_LINE_ID NUMBER_tbl_type ,
300 APP_TO_LIN_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
301 APP_TO_LIN_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
302 APP_TO_LIN_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
303 APP_TO_LIN_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
304 APP_TO_LIN_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
305 APP_TO_LIN_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
306 TRX_ID_LEVEL2 NUMBER_tbl_type ,
310 TRX_ID_LEVEL6 NUMBER_tbl_type ,
307 TRX_ID_LEVEL3 NUMBER_tbl_type ,
308 TRX_ID_LEVEL4 NUMBER_tbl_type ,
309 TRX_ID_LEVEL5 NUMBER_tbl_type ,
311 HDR_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
312 HDR_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
313 HDR_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
314 HDR_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
315 HDR_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
316 HDR_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
317 LINE_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
318 LINE_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
319 LINE_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
320 LINE_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
321 LINE_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
322 LINE_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
323 TRX_NUMBER VARCHAR2_150_tbl_type ,
324 TRX_DESCRIPTION VARCHAR2_240_tbl_type ,
325 TRX_LINE_NUMBER NUMBER_tbl_type ,
326 TRX_LINE_DESCRIPTION VARCHAR2_240_tbl_type ,
327 PRODUCT_DESCRIPTION VARCHAR2_240_tbl_type ,
328 TRX_WAYBILL_NUMBER VARCHAR2_50_tbl_type ,
329 TRX_COMMUNICATED_DATE DATE_tbl_type ,
330 TRX_LINE_GL_DATE DATE_tbl_type ,
331 BATCH_SOURCE_ID NUMBER_tbl_type ,
332 BATCH_SOURCE_NAME VARCHAR2_150_tbl_type ,
333 DOC_SEQ_ID NUMBER_tbl_type ,
334 DOC_SEQ_NAME VARCHAR2_150_tbl_type ,
335 DOC_SEQ_VALUE VARCHAR2_240_tbl_type ,
336 TRX_DUE_DATE DATE_tbl_type ,
337 TRX_TYPE_DESCRIPTION VARCHAR2_240_tbl_type ,
338 MERCHANT_PARTY_NAME VARCHAR2_150_tbl_type ,
339 MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2_150_tbl_type ,
340 MERCHANT_PARTY_REFERENCE VARCHAR2_250_tbl_type ,
341 MERCHANT_PARTY_TAXPAYER_ID VARCHAR2_150_tbl_type ,
342 MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2_150_tbl_type ,
343 PAYING_PARTY_ID NUMBER_tbl_type ,
344 OWN_HQ_PARTY_ID NUMBER_tbl_type ,
345 TRADING_HQ_PARTY_ID NUMBER_tbl_type ,
346 POI_PARTY_ID NUMBER_tbl_type ,
347 POD_PARTY_ID NUMBER_tbl_type ,
348 TITLE_TRANSFER_PARTY_ID NUMBER_tbl_type ,
349 PAYING_PARTY_SITE_ID NUMBER_tbl_type ,
350 OWN_HQ_PARTY_SITE_ID NUMBER_tbl_type ,
351 TRADING_HQ_PARTY_SITE_ID NUMBER_tbl_type ,
352 POI_PARTY_SITE_ID NUMBER_tbl_type ,
353 POD_PARTY_SITE_ID NUMBER_tbl_type ,
354 TITLE_TRANSFER_PARTY_SITE_ID NUMBER_tbl_type ,
355 PAYING_LOCATION_ID NUMBER_tbl_type ,
356 OWN_HQ_LOCATION_ID NUMBER_tbl_type ,
357 TRADING_HQ_LOCATION_ID NUMBER_tbl_type ,
358 POC_LOCATION_ID NUMBER_tbl_type ,
359 POI_LOCATION_ID NUMBER_tbl_type ,
360 POD_LOCATION_ID NUMBER_tbl_type ,
361 TITLE_TRANSFER_LOCATION_ID NUMBER_tbl_type ,
362 ASSESSABLE_VALUE NUMBER_tbl_type ,
363 ASSET_FLAG VARCHAR2_1_tbl_type ,
364 ASSET_NUMBER VARCHAR2_150_tbl_type ,
365 ASSET_ACCUM_DEPRECIATION NUMBER_tbl_type ,
366 ASSET_TYPE VARCHAR2_150_tbl_type ,
367 ASSET_COST NUMBER_tbl_type ,
368 NUMERIC1 NUMBER_tbl_type ,
369 NUMERIC2 NUMBER_tbl_type ,
370 NUMERIC3 NUMBER_tbl_type ,
371 NUMERIC4 NUMBER_tbl_type ,
372 NUMERIC5 NUMBER_tbl_type ,
373 NUMERIC6 NUMBER_tbl_type ,
374 NUMERIC7 NUMBER_tbl_type ,
375 NUMERIC8 NUMBER_tbl_type ,
376 NUMERIC9 NUMBER_tbl_type ,
377 NUMERIC10 NUMBER_tbl_type ,
378 CHAR1 VARCHAR2_150_tbl_type ,
379 CHAR2 VARCHAR2_150_tbl_type ,
380 CHAR3 VARCHAR2_150_tbl_type ,
381 CHAR4 VARCHAR2_150_tbl_type ,
382 CHAR5 VARCHAR2_150_tbl_type ,
383 CHAR6 VARCHAR2_150_tbl_type ,
384 CHAR7 VARCHAR2_150_tbl_type ,
385 CHAR8 VARCHAR2_150_tbl_type ,
386 CHAR9 VARCHAR2_150_tbl_type ,
387 CHAR10 VARCHAR2_150_tbl_type ,
388 DATE1 DATE_tbl_type ,
389 DATE2 DATE_tbl_type ,
390 DATE3 DATE_tbl_type ,
391 DATE4 DATE_tbl_type ,
392 DATE5 DATE_tbl_type ,
393 DATE6 DATE_tbl_type ,
394 DATE7 DATE_tbl_type ,
395 DATE8 DATE_tbl_type ,
396 DATE9 DATE_tbl_type ,
397 DATE10 DATE_tbl_type ,
398 FIRST_PTY_ORG_ID NUMBER_tbl_type ,
399 TAX_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
403 RDNG_SHIP_FROM_PTY_TX_PROF_ID NUMBER_tbl_type ,
400 TAX_EVENT_TYPE_CODE VARCHAR2_30_tbl_type ,
401 DOC_EVENT_STATUS VARCHAR2_30_tbl_type ,
402 RDNG_SHIP_TO_PTY_TX_PROF_ID NUMBER_tbl_type ,
404 RDNG_BILL_TO_PTY_TX_PROF_ID NUMBER_tbl_type ,
405 RDNG_BILL_FROM_PTY_TX_PROF_ID NUMBER_tbl_type ,
406 RDNG_SHIP_TO_PTY_TX_P_ST_ID NUMBER_tbl_type ,
407 RDNG_SHIP_FROM_PTY_TX_P_ST_ID NUMBER_tbl_type ,
408 RDNG_BILL_TO_PTY_TX_P_ST_ID NUMBER_tbl_type ,
409 RDNG_BILL_FROM_PTY_TX_P_ST_ID NUMBER_tbl_type ,
410 SHIP_TO_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
411 SHIP_FROM_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
412 POA_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
413 POO_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
414 PAYING_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
415 OWN_HQ_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
416 TRADING_HQ_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
417 POI_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
418 POD_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
419 BILL_TO_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
420 BILL_FROM_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
421 TITLE_TRANS_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
422 SHIP_TO_SITE_TAX_PROF_ID NUMBER_tbl_type ,
423 SHIP_FROM_SITE_TAX_PROF_ID NUMBER_tbl_type ,
424 POA_SITE_TAX_PROF_ID NUMBER_tbl_type ,
425 POO_SITE_TAX_PROF_ID NUMBER_tbl_type ,
426 PAYING_SITE_TAX_PROF_ID NUMBER_tbl_type ,
427 OWN_HQ_SITE_TAX_PROF_ID NUMBER_tbl_type ,
428 TRADING_HQ_SITE_TAX_PROF_ID NUMBER_tbl_type ,
429 POI_SITE_TAX_PROF_ID NUMBER_tbl_type ,
430 POD_SITE_TAX_PROF_ID NUMBER_tbl_type ,
431 BILL_TO_SITE_TAX_PROF_ID NUMBER_tbl_type ,
432 BILL_FROM_SITE_TAX_PROF_ID NUMBER_tbl_type ,
433 TITLE_TRANS_SITE_TAX_PROF_ID NUMBER_tbl_type ,
434 MERCHANT_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
435 HQ_ESTB_PARTY_TAX_PROF_ID NUMBER_tbl_type ,
436 DOCUMENT_SUB_TYPE VARCHAR2_240_tbl_type ,
437 SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2_150_tbl_type ,
438 SUPPLIER_TAX_INVOICE_DATE DATE_tbl_type ,
439 SUPPLIER_EXCHANGE_RATE NUMBER_tbl_type ,
440 TAX_INVOICE_DATE DATE_tbl_type ,
441 TAX_INVOICE_NUMBER VARCHAR2_150_tbl_type ,
442 LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2_1_tbl_type ,
443 QUOTE_FLAG VARCHAR2_1_tbl_type ,
444 DEFAULT_TAXATION_COUNTRY VARCHAR2_2_tbl_type ,
445 HISTORICAL_FLAG VARCHAR2_1_tbl_type ,
446 INTERNAL_ORG_LOCATION_ID NUMBER_tbl_type ,
447 CTRL_HDR_TX_APPL_FLAG VARCHAR2_1_tbl_type ,
448 CTRL_TOTAL_HDR_TX_AMT NUMBER_tbl_type ,
449 CTRL_TOTAL_LINE_TX_AMT NUMBER_tbl_type ,
450 DIST_LEVEL_ACTION VARCHAR2_30_tbl_type ,
451 APPLIED_FROM_TAX_DIST_ID NUMBER_tbl_type ,
452 ADJUSTED_DOC_TAX_DIST_ID NUMBER_tbl_type ,
453 TASK_ID NUMBER_tbl_type ,
454 AWARD_ID NUMBER_tbl_type ,
455 PROJECT_ID NUMBER_tbl_type ,
456 EXPENDITURE_TYPE VARCHAR2_30_tbl_type ,
457 EXPENDITURE_ORGANIZATION_ID NUMBER_tbl_type ,
458 EXPENDITURE_ITEM_DATE DATE_tbl_type ,
459 TRX_LINE_DIST_AMT NUMBER_tbl_type ,
460 TRX_LINE_DIST_QUANTITY NUMBER_tbl_type ,
461 REF_DOC_CURR_CONV_RATE NUMBER_tbl_type ,
462 ITEM_DIST_NUMBER NUMBER_tbl_type ,
463 REF_DOC_DIST_ID NUMBER_tbl_type ,
464 TRX_LINE_DIST_TAX_AMT NUMBER_tbl_type ,
465 TRX_LINE_DIST_ID NUMBER_tbl_type ,
466 DIST_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
467 DIST_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
468 DIST_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
469 DIST_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
470 DIST_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
471 DIST_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
472 APPLIED_FROM_DIST_ID NUMBER_tbl_type ,
473 APP_FROM_DST_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
474 APP_FROM_DST_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
475 APP_FROM_DST_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
476 APP_FROM_DST_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
477 APP_FROM_DST_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
478 APP_FROM_DST_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
479 ADJUSTED_DOC_DIST_ID NUMBER_tbl_type ,
480 ADJ_DOC_DST_TRX_USER_KEY1 VARCHAR2_150_tbl_type ,
481 ADJ_DOC_DST_TRX_USER_KEY2 VARCHAR2_150_tbl_type ,
482 ADJ_DOC_DST_TRX_USER_KEY3 VARCHAR2_150_tbl_type ,
483 ADJ_DOC_DST_TRX_USER_KEY4 VARCHAR2_150_tbl_type ,
484 ADJ_DOC_DST_TRX_USER_KEY5 VARCHAR2_150_tbl_type ,
485 ADJ_DOC_DST_TRX_USER_KEY6 VARCHAR2_150_tbl_type ,
486 INPUT_TAX_CLASSIFICATION_CODE VARCHAR2_30_tbl_type ,
487 OUTPUT_TAX_CLASSIFICATION_CODE VARCHAR2_50_tbl_type ,
488 PORT_OF_ENTRY_CODE VARCHAR2_30_tbl_type ,
489 TAX_REPORTING_FLAG VARCHAR2_1_tbl_type ,
490 TAX_AMT_INCLUDED_FLAG VARCHAR2_1_tbl_type ,
491 COMPOUNDING_TAX_FLAG VARCHAR2_1_tbl_type ,
492 SHIP_THIRD_PTY_ACCT_SITE_ID NUMBER_tbl_type ,
496 PROVNL_TAX_DETERMINATION_DATE DATE_tbl_type ,
493 BILL_THIRD_PTY_ACCT_SITE_ID NUMBER_tbl_type ,
494 SHIP_TO_CUST_ACCT_SITE_USE_ID NUMBER_tbl_type ,
495 BILL_TO_CUST_ACCT_SITE_USE_ID NUMBER_tbl_type ,
497 SHIP_THIRD_PTY_ACCT_ID NUMBER_tbl_type ,
498 BILL_THIRD_PTY_ACCT_ID NUMBER_tbl_type ,
499 SOURCE_APPLICATION_ID NUMBER_tbl_type ,
500 SOURCE_ENTITY_CODE VARCHAR2_30_tbl_type ,
501 SOURCE_EVENT_CLASS_CODE VARCHAR2_30_tbl_type ,
502 SOURCE_TRX_ID NUMBER_tbl_type ,
503 SOURCE_LINE_ID NUMBER_tbl_type ,
504 SOURCE_TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
505 INSERT_UPDATE_FLAG VARCHAR2_1_tbl_type ,
506 APPLIED_TO_TRX_NUMBER VARCHAR2_150_tbl_type ,
507 START_EXPENSE_DATE DATE_tbl_type ,
508 TRX_BATCH_ID NUMBER_tbl_type ,
509 RECORD_TYPE_CODE VARCHAR2_30_tbl_type ,
510 REF_DOC_TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
511 APPLIED_FROM_TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
512 APPLIED_TO_TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
513 ADJUSTED_DOC_TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
514 DEFAULTING_ATTRIBUTE1 VARCHAR2_150_tbl_type ,
515 DEFAULTING_ATTRIBUTE2 VARCHAR2_150_tbl_type ,
516 DEFAULTING_ATTRIBUTE3 VARCHAR2_150_tbl_type ,
517 DEFAULTING_ATTRIBUTE4 VARCHAR2_150_tbl_type ,
518 DEFAULTING_ATTRIBUTE5 VARCHAR2_150_tbl_type ,
519 DEFAULTING_ATTRIBUTE6 VARCHAR2_150_tbl_type ,
520 DEFAULTING_ATTRIBUTE7 VARCHAR2_150_tbl_type ,
521 DEFAULTING_ATTRIBUTE8 VARCHAR2_150_tbl_type ,
522 DEFAULTING_ATTRIBUTE9 VARCHAR2_150_tbl_type ,
523 DEFAULTING_ATTRIBUTE10 VARCHAR2_150_tbl_type ,
524 TAX_PROCESSING_COMPLETED_FLAG VARCHAR2_1_tbl_type ,
525 APPLICATION_DOC_STATUS VARCHAR2_30_tbl_type ,
526 OVERRIDING_RECOVERY_RATE NUMBER_tbl_type ,
527 TAX_CALCULATION_DONE_FLAG VARCHAR2_1_tbl_type ,
528 SOURCE_TAX_LINE_ID NUMBER_tbl_type ,
529 REVERSED_APPLN_ID NUMBER_tbl_type ,
530 REVERSED_ENTITY_CODE VARCHAR2_30_tbl_type ,
531 REVERSED_EVNT_CLS_CODE VARCHAR2_30_tbl_type ,
532 REVERSED_TRX_ID NUMBER_tbl_type ,
533 REVERSED_TRX_LEVEL_TYPE VARCHAR2_30_tbl_type ,
534 REVERSED_TRX_LINE_ID NUMBER_tbl_type ,
535 EXEMPTION_CONTROL_FLAG VARCHAR2_1_tbl_type ,
536 EXEMPT_REASON_CODE VARCHAR2_30_tbl_type ,
537 INTERFACE_ENTITY_CODE VARCHAR2_30_tbl_type ,
538 INTERFACE_LINE_ID NUMBER_tbl_type ,
539 HISTORICAL_TAX_CODE_ID NUMBER_tbl_type ,
540 USER_UPD_DET_FACTORS_FLAG VARCHAR2_1_tbl_type ,
541 ICX_SESSION_ID NUMBER_tbl_type ,
542 HDR_SHIP_THIRD_PTY_ACCT_ST_ID NUMBER_tbl_type ,
543 HDR_BILL_THIRD_PTY_ACCT_ST_ID NUMBER_tbl_type ,
544 HDR_SHIP_TO_CST_ACCT_ST_USE_ID NUMBER_tbl_type ,
545 HDR_BILL_TO_CST_ACCT_ST_USE_ID NUMBER_tbl_type ,
546 HDR_SHIP_THIRD_PTY_ACCT_ID NUMBER_tbl_type ,
547 HDR_BILL_THIRD_PTY_ACCT_ID NUMBER_tbl_type ,
548 HDR_RECEIVABLES_TRX_TYPE_ID NUMBER_tbl_type ,
549 GLOBAL_ATTRIBUTE1 VARCHAR2_150_tbl_type ,
550 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2_150_tbl_type ,
551 TOTAL_INC_TAX_AMT NUMBER_tbl_type
552 );
553
554 TYPE tax_regime_rec_type IS RECORD (
555 TAX_REGIME_PRECEDENCE NUMBER,
556 TAX_REGIME_ID NUMBER,
557 TAX_PROVIDER_ID NUMBER,
558 PARENT_REGIME_ID NUMBER,
559 TAX_REGIME_CODE VARCHAR2(80),
560 PARENT_REGIME_CODE VARCHAR2(80),
561 COUNTRY_CODE VARCHAR2(80),
562 GEOGRAPHY_TYPE VARCHAR2(80),
563 GEOGRAPHY_ID NUMBER,
564 EFFECTIVE_FROM DATE,
565 EFFECTIVE_TO DATE,
566 PARTNER_PROCESSING_FLAG VARCHAR2(1),
567 SYNC_WITH_PROVIDER_FLAG VARCHAR2(1),
568 COUNTRY_OR_GROUP_CODE ZX_REGIMES_B.COUNTRY_OR_GROUP_CODE%type
569 );
570
571 TYPE tax_regime_tbl_type IS TABLE OF tax_regime_rec_type
572 INDEX BY BINARY_INTEGER;
573
574 -- Tax Partner specific global structure ----------
575 -- The following structure is introduced for Tax Partner Processing
576 -- Partner processing logic needs the list of tax regimes for every
577 -- transaction as a starting point. Since the tax_regimes_tbl structure
578 -- will be initialized for every transaction we copy that information into
579 -- the structure below so that this information is available to partner
580 -- API which will be called in the end in bulk.
581
582 TYPE ptnr_tax_regime_rec_type is RECORD (
583 application_id zx_lines_det_factors.application_id%TYPE,
584 event_class_code zx_lines_det_factors.event_class_code%TYPE,
585 entity_code zx_lines_det_factors.entity_code%TYPE,
586 trx_id zx_lines_det_factors.trx_id%TYPE,
587 event_id zx_lines_det_factors.event_id%TYPE,
588 event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
589 event_type_code zx_lines_det_factors.event_type_code%TYPE,
590 tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
591 tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
592 doc_status_code VARCHAR2(30),
596 prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
593 record_flag zx_evnt_cls_mappings.record_flag%TYPE,
594 quote_flag zx_trx_headers_gt.quote_flag%TYPE,
595 record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
597 first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
598 internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
599 legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
600 ledger_id zx_lines_det_factors.ledger_id%TYPE,
601 establishment_id zx_lines_det_factors.establishment_id%TYPE,
602 currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
603 process_for_applicability_flag VARCHAR2(1),
604 perf_addnl_appl_for_imprt_flag VARCHAR2(1),
605 ptnr_srvc_subscr_flag VARCHAR2(1),
606 effective_date DATE,
607 tax_regime_tbl tax_regime_tbl_type
608 );
609
610 TYPE ptnr_tax_regime_tbl_type IS TABLE OF ptnr_tax_regime_rec_type
611 INDEX BY BINARY_INTEGER;
612
613 ptnr_tax_regime_tbl ptnr_tax_regime_tbl_type;
614
615 --------------------------------------------------------
616
617
618 TYPE Regime_relation_rec_type is RECORD(
619 PARENT_REGIME_CODE ZX_REGIME_RELATIONS.PARENT_REGIME_CODE%type,
620 PARENT_REG_LEVEL ZX_REGIME_RELATIONS.PARENT_REG_LEVEL%type,
621 REGIME_CODE ZX_REGIME_RELATIONS.REGIME_CODE%type);
622
623 TYPE Regime_relation_tbl_type IS TABLE of Regime_relation_rec_type index by BINARY_INTEGER;
624
625 REGIME_RELATION_TBL Regime_relation_tbl_type;
626
627 TYPE territory_tbl_type is table of FND_TERRITORIES.TERRITORY_CODE%TYPE
628 INDEX by BINARY_INTEGER;
629
630 G_TERRITORY_TBL territory_tbl_type;
631
632
633 TYPE detail_tax_regime_rec_type IS RECORD (
634 TRX_LINE_INDEX BINARY_INTEGER,
635 TAX_REGIME_PRECEDENCE NUMBER,
636 TAX_REGIME_ID NUMBER
637 );
638
639 TYPE detail_tax_regime_tbl_type IS TABLE OF detail_tax_regime_rec_type
640 INDEX BY BINARY_INTEGER;
641
642 TYPE regimes_usages_rec_type is RECORD(
643 TAX_REGIME_ID NUMBER,
644 TAX_REGIME_CODE ZX_REGIMES_B.tax_Regime_code%TYPE,
645 FIRST_PTY_ORG_ID NUMBER,
646 REGIME_USAGE_ID NUMBER);
647
648 TYPE REGIMES_USAGES_TBL_TYPE is TABLE of regimes_usages_rec_type index by BINARY_INTEGER;
649 -- This structure is indexed by hash value of tax_regime_code and first party_org_id.
650 G_REGIMES_USAGES_TBL REGIMES_USAGES_TBL_TYPE;
651
652
653 TYPE trx_line_app_regime_rec_type IS RECORD (
654 EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
655 APPLICATION_ID NUMBER_tbl_type,
656 ENTITY_CODE VARCHAR2_30_tbl_type,
657 TRX_ID NUMBER_tbl_type,
658 TRX_LINE_ID NUMBER_tbl_type,
659 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type,
660 TAX_REGIME_CODE VARCHAR2_30_tbl_type,
661 TAX_REGIME_ID NUMBER_tbl_type,
662 TAX_PROVIDER_ID NUMBER_tbl_type,
663 ALLOW_TAX_CALCULATION_FLAG VARCHAR2_1_tbl_type
664 );
665
666 TYPE location_info_rec_type IS RECORD (
667 EVENT_CLASS_MAPPING_ID NUMBER_tbl_type,
668 TRX_ID NUMBER_tbl_type,
669 TRX_LINE_ID NUMBER_tbl_type,
670 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type,
671 LOCATION_TYPE VARCHAR2_30_tbl_type,
672 LOCATION_TABLE_NAME VARCHAR2_30_tbl_type,
673 LOCATION_ID NUMBER_tbl_type,
674 GEOGRAPHY_TYPE VARCHAR2_30_tbl_type,
675 GEOGRAPHY_VALUE VARCHAR2_360_tbl_type,
676 GEOGRAPHY_ID NUMBER_tbl_type
677 );
678
679 /* Bug fix 4222298 */
680 TYPE location_hash_tbl_type IS TABLE OF number index by binary_integer;
681
682 TYPE fc_country_def_val_rec_type is RECORD (
683 COUNTRY_CODE VARCHAR2(2),
684 FC_TYPE VARCHAR2(30),
685 FC_DEFAULT_VALUE VARCHAr2(240)
686 );
687
688 fc_country_def_val_rec fc_country_def_val_rec_type;
689
690 Type fc_country_def_val_tbl_type is table of fc_country_def_val_rec_type index by binary_integer;
691
692 -- Changed the name of the Record Type for Bug#13806759 --
693 TYPE item_fiscal_type_val_rec_type IS RECORD (
694 ORG_ID ZX_PRODUCT_OPTIONS_ALL.ORG_ID%TYPE,
695 FC_ITEM_ID MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
696 FC_TYPE VARCHAR2(30),
697 FC_DEFAULT_VALUE VARCHAR2(240)
698 );
699
700 TYPE item_fiscal_type_val_tbl_type IS TABLE OF item_fiscal_type_val_rec_type INDEX BY BINARY_INTEGER;
701
702
703 -- the structure below is used to cache geography types info
704 -- This structure is referenced in jurisdictions API (get_zone)
705
706 TYPE geography_type_info_rec_type is record
707 (ZONE_TYPE hz_geographies.geography_type%TYPE, --bug8251315
708 GEOGRAPHY_TYPE hz_geography_types_b.geography_type%TYPE,
709 GEOGRAPHY_USE hz_geography_types_b.GEOGRAPHY_USE%TYPE,
710 LIMITED_BY_GEOGRAPHY_ID hz_geography_types_b.LIMITED_BY_GEOGRAPHY_ID%TYPE);
711
712 TYPE geography_type_info_tbl_type is table of geography_type_info_rec_type index by BINARY_INTEGER;
713
714
715 -- the structure below is used in jurisdictions API to get geography types and uses for a given tax
716 -- and this structure is valid for the whole session. This structure is referenced in jurisdictions API
717
718 TYPE geography_use_info_rec_type is record
719 (
720 TAX_ID zx_taxes_b.tax_id%type,
721 GEOGRAPHY_TYPE_NUM number,
725 TYPE geography_use_info_tbl_type is table of geography_use_info_rec_type index by binary_integer;
722 GEOGRAPHY_TYPE hz_geography_types_b.geography_type%type,
723 GEOGRAPHY_USE hz_geography_types_b.geography_use%TYPE);
724
726
727 -- caching fix done for bug#8551677
728
729 TYPE condition_info_rec_type is record
730 (
731
732 condition_group_id ZX_CONDITION_GROUPS_B.condition_group_id%TYPE,
733 condition_group_code ZX_CONDITION_GROUPS_B.condition_group_code%TYPE,
734 more_than10 ZX_CONDITION_GROUPS_B.More_Than_Max_Cond_Flag%TYPE,
735 det_factor_class1 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
736 determining_factor_cq1 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
737 data_type1 ZX_CONDITIONS.Data_Type_Code%TYPE,
738 det_factor_code1 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
739 operator1 ZX_CONDITIONS.Operator_Code%TYPE,
740 numeric_value1 ZX_CONDITIONS.numeric_value%TYPE,
741 date_value1 ZX_CONDITIONS.date_value%TYPE,
742 alphanum_value1 ZX_CONDITIONS.alphanumeric_value%TYPE,
743 value_low1 ZX_CONDITIONS.value_low%TYPE,
744 value_high1 ZX_CONDITIONS.value_high%TYPE,
745 tax_parameter_code1 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
746 det_factor_class2 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
747 determining_factor_cq2 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
748 data_type2 ZX_CONDITIONS.Data_Type_Code%TYPE,
749 det_factor_code2 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
750 operator2 ZX_CONDITIONS.Operator_Code%TYPE,
751 numeric_value2 ZX_CONDITIONS.numeric_value%TYPE,
752 date_value2 ZX_CONDITIONS.date_value%TYPE,
753 alphanum_value2 ZX_CONDITIONS.alphanumeric_value%TYPE,
754 value_low2 ZX_CONDITIONS.value_low%TYPE,
755 value_high2 ZX_CONDITIONS.value_high%TYPE,
756 tax_parameter_code2 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
757 det_factor_class3 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
758 determining_factor_cq3 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
759 data_type3 ZX_CONDITIONS.Data_Type_Code%TYPE,
760 det_factor_code3 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
761 operator3 ZX_CONDITIONS.Operator_Code%TYPE,
762 numeric_value3 ZX_CONDITIONS.numeric_value%TYPE,
763 date_value3 ZX_CONDITIONS.date_value%TYPE,
764 alphanum_value3 ZX_CONDITIONS.alphanumeric_value%TYPE,
765 value_low3 ZX_CONDITIONS.value_low%TYPE,
766 value_high3 ZX_CONDITIONS.value_high%TYPE,
767 tax_parameter_code3 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
768 det_factor_class4 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
769 determining_factor_cq4 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
770 data_type4 ZX_CONDITIONS.Data_Type_Code%TYPE,
771 det_factor_code4 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
772 operator4 ZX_CONDITIONS.Operator_Code%TYPE,
773 numeric_value4 ZX_CONDITIONS.numeric_value%TYPE,
774 date_value4 ZX_CONDITIONS.date_value%TYPE,
775 alphanum_value4 ZX_CONDITIONS.alphanumeric_value%TYPE,
776 value_low4 ZX_CONDITIONS.value_low%TYPE,
777 value_high4 ZX_CONDITIONS.value_high%TYPE,
778 tax_parameter_code4 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
779 det_factor_class5 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
783 operator5 ZX_CONDITIONS.Operator_Code%TYPE,
780 determining_factor_cq5 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
781 data_type5 ZX_CONDITIONS.Data_Type_Code%TYPE,
782 det_factor_code5 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
784 numeric_value5 ZX_CONDITIONS.numeric_value%TYPE,
785 date_value5 ZX_CONDITIONS.date_value%TYPE,
786 alphanum_value5 ZX_CONDITIONS.alphanumeric_value%TYPE,
787 value_low5 ZX_CONDITIONS.value_low%TYPE,
788 value_high5 ZX_CONDITIONS.value_high%TYPE,
789 tax_parameter_code5 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
790 det_factor_class6 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
791 determining_factor_cq6 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
792 data_type6 ZX_CONDITIONS.Data_Type_Code%TYPE,
793 det_factor_code6 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
794 operator6 ZX_CONDITIONS.Operator_Code%TYPE,
795 numeric_value6 ZX_CONDITIONS.numeric_value%TYPE,
796 date_value6 ZX_CONDITIONS.date_value%TYPE,
797 alphanum_value6 ZX_CONDITIONS.alphanumeric_value%TYPE,
798 value_low6 ZX_CONDITIONS.value_low%TYPE,
799 value_high6 ZX_CONDITIONS.value_high%TYPE,
800 tax_parameter_code6 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
801 det_factor_class7 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
802 determining_factor_cq7 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
803 data_type7 ZX_CONDITIONS.Data_Type_Code%TYPE,
804 det_factor_code7 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
805 operator7 ZX_CONDITIONS.Operator_Code%TYPE,
806 numeric_value7 ZX_CONDITIONS.numeric_value%TYPE,
807 date_value7 ZX_CONDITIONS.date_value%TYPE,
808 alphanum_value7 ZX_CONDITIONS.alphanumeric_value%TYPE,
809 value_low7 ZX_CONDITIONS.value_low%TYPE,
810 value_high7 ZX_CONDITIONS.value_high%TYPE,
811 tax_parameter_code7 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
812 det_factor_class8 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
813 determining_factor_cq8 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
814 data_type8 ZX_CONDITIONS.Data_Type_Code%TYPE,
815 det_factor_code8 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
816 operator8 ZX_CONDITIONS.Operator_Code%TYPE,
817 numeric_value8 ZX_CONDITIONS.numeric_value%TYPE,
818 date_value8 ZX_CONDITIONS.date_value%TYPE,
819 alphanum_value8 ZX_CONDITIONS.alphanumeric_value%TYPE,
820 value_low8 ZX_CONDITIONS.value_low%TYPE,
821 value_high8 ZX_CONDITIONS.value_high%TYPE,
822 tax_parameter_code8 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
823 det_factor_class9 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
824 determining_factor_cq9 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
825 data_type9 ZX_CONDITIONS.Data_Type_Code%TYPE,
826 det_factor_code9 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
827 operator9 ZX_CONDITIONS.Operator_Code%TYPE,
828 numeric_value9 ZX_CONDITIONS.numeric_value%TYPE,
829 date_value9 ZX_CONDITIONS.date_value%TYPE,
830 alphanum_value9 ZX_CONDITIONS.alphanumeric_value%TYPE,
831 value_low9 ZX_CONDITIONS.value_low%TYPE,
832 value_high9 ZX_CONDITIONS.value_high%TYPE,
833 tax_parameter_code9 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
834 det_factor_class10 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Class_Code%TYPE,
835 determining_factor_cq10 ZX_DET_FACTOR_TEMPL_DTL.Determining_Factor_Cq_Code%TYPE,
836 data_type10 ZX_CONDITIONS.Data_Type_Code%TYPE,
837 det_factor_code10 ZX_DETERMINING_FACTORS_B.determining_factor_code%TYPE,
838 operator10 ZX_CONDITIONS.Operator_Code%TYPE,
839 numeric_value10 ZX_CONDITIONS.numeric_value%TYPE,
840 date_value10 ZX_CONDITIONS.date_value%TYPE,
841 alphanum_value10 ZX_CONDITIONS.alphanumeric_value%TYPE,
842 value_low10 ZX_CONDITIONS.value_low%TYPE,
843 value_high10 ZX_CONDITIONS.value_high%TYPE,
844 tax_parameter_code10 ZX_PARAMETERS_B.tax_parameter_code%TYPE,
845 chart_of_accounts_id ZX_CONDITION_GROUPS_B.CHART_OF_ACCOUNTS_ID%TYPE,
846 sob_id ZX_CONDITION_GROUPS_B.LEDGER_ID%TYPE,
847 result_id ZX_PROCESS_RESULTS.result_id%TYPE,
848 constraint_id ZX_CONDITION_GROUPS_B.constraint_id%TYPE
849 );
850
851 TYPE condition_info_tbl_type is table of condition_info_rec_type index by binary_integer;
852
853 TYPE rule_info_rec_type is record
854 (
855
856 tax_rule_id ZX_RULES_B.tax_rule_id%TYPE,
857 det_factor_templ_code ZX_CONDITION_GROUPS_B.det_factor_templ_code%TYPE,
858 tax_status_code ZX_PROCESS_RESULTS.tax_status_code%TYPE,
859 condition_info_rec_tbl condition_info_tbl_type
860 );
861
862 TYPE rule_info_tbl_type is table of rule_info_rec_type index by varchar2(100);
863
864 g_rule_info_tbl rule_info_tbl_type;
865
866 -- the structure below is used in jurisdictions get_zone API to get geo name
867 -- reference for a given location_id and this structure is value for the whole session.
868
869 TYPE geo_name_references_rec_type is record
870 (
871 LOCATION_ID hz_geo_name_references.location_id%TYPE,
872 REF_COUNT NUMBER
873 );
874
878 -- The structure is valid throughout the session. This structure is referenced in jurisdictions API
875 TYPE geo_name_references_tbl_type is table of geo_name_references_rec_type index by binary_integer;
876
877 -- The strucure below is used to cache location information for a location
879 -- This structure is indexed by location_id
880
881 TYPE rec_nrec_ccid_rec_type is record
882 (
883 interim_tax_ccid zx_accounts.interim_tax_ccid%type,
884 tax_account_ccid zx_accounts.tax_account_ccid%type,
885 non_rec_account_ccid zx_accounts.non_rec_account_ccid%type);
886
887 TYPE rec_nrec_ccid_tbl_type is table of rec_nrec_ccid_rec_type index by VARCHAR2(100);
888 rec_nrec_ccid_tbl rec_nrec_ccid_tbl_type;
889
890 TYPE loc_info_rec_type is record
891 (
892 LOCATION_ID hz_locations.location_id%type,
893 LOCATION_TABLE_NAME VARCHAR2(30),
894 COUNTRY_CODE hz_locations.country%type);
895
896 TYPE loc_info_tbl_type is table of loc_info_rec_type index by VARCHAR2(50);
897 Loc_info_tbl loc_info_tbl_type;
898
899 TYPE tax_calc_flag_tbl_type is table of VARCHAR2(10) index by VARCHAR2(10);
900
901 tax_calc_flag_tbl tax_calc_flag_tbl_type;
902
903 -- The strucure below is used to cache geography id and geography type information for a location
904 -- The structure is valid throughout the session. This structure is referenced in jurisdictions API
905 -- This structure is indexed by a hash value of to_char(location_id) + geography_type
906
907 TYPE loc_geography_info_rec_type is record
908 (
909 LOCATION_ID hz_locations.location_id%type,
910 GEOGRAPHY_TYPE hz_geographies.geography_type%type,
911 GEOGRAPHY_ID hz_geographies.geography_id%type,
912 GEOGRAPHY_CODE hz_geographies.geography_code%type,
913 GEOGRAPHY_NAME hz_geographies.geography_name%type,
914 GEOGRAPHY_USE hz_geographies.geography_use%type);
915
916 type loc_geography_info_tbl_type is table of loc_geography_info_rec_type index by binary_integer;
917 Loc_geography_info_tbl loc_geography_info_tbl_type;
918
919 -- The structure below is used to cache party type info. This structure is indexed by hash value of
920 -- party_type_code and is being referenced by jurisdictions API.
921
922 TYPE ZX_PARTY_TYPES_INFO_REC is record(
923 PARTY_TYPE_CODE zx_party_types.PARTY_TYPE_CODE%type,
924 PARTY_SOURCE_TABLE zx_party_types.PARTY_SOURCE_TABLE%type,
925 PARTY_SOURCE_COLUMN zx_party_types.PARTY_SOURCE_COLUMN%type,
926 APPLICABLE_TO_EVNT_CLS_FLAG zx_party_types.APPLICABLE_TO_EVNT_CLS_FLAG%type,
927 PARTY_SITE_TYPE zx_party_types.PARTY_SITE_TYPE%type,
928 LOCATION_SOURCE_TABLE zx_party_types.LOCATION_SOURCE_TABLE%type,
929 LOCATION_SOURCE_COLUMN zx_party_types.LOCATION_SOURCE_COLUMN%type);
930
931
932 TYPE ZX_PARTY_TYPES_CACHE_TBLTYPE is table of ZX_PARTY_TYPES_INFO_REC index by binary_integer;
933
934 ZX_PARTY_TYPES_CACHE ZX_PARTY_TYPES_CACHE_TBLTYPE;
935
936
937 Type intended_use_tbl_info_rectype is RECORD
938 (owner_table_code zx_fc_types_b.owner_table_code%type,
939 owner_id_num zx_fc_types_b.owner_id_num%type);
940
941
942 Type zx_product_options_rec_type is record(
943 APPLICATION_ID zx_product_options_all.APPLICATION_ID%type,
944 ORG_ID zx_product_options_all.ORG_ID%type,
945 TAX_METHOD_CODE zx_product_options_all.TAX_METHOD_CODE%type,
946 DEF_OPTION_HIER_1_CODE zx_product_options_all.DEF_OPTION_HIER_1_CODE%type,
947 DEF_OPTION_HIER_2_CODE zx_product_options_all.DEF_OPTION_HIER_2_CODE%type,
948 DEF_OPTION_HIER_3_CODE zx_product_options_all.DEF_OPTION_HIER_3_CODE%type,
949 DEF_OPTION_HIER_4_CODE zx_product_options_all.DEF_OPTION_HIER_4_CODE%type,
950 DEF_OPTION_HIER_5_CODE zx_product_options_all.DEF_OPTION_HIER_5_CODE%type,
951 DEF_OPTION_HIER_6_CODE zx_product_options_all.DEF_OPTION_HIER_6_CODE%type,
952 DEF_OPTION_HIER_7_CODE zx_product_options_all.DEF_OPTION_HIER_7_CODE%type,
953 TAX_CLASSIFICATION_CODE zx_product_options_all.TAX_CLASSIFICATION_CODE%type,
954 INCLUSIVE_TAX_USED_FLAG zx_product_options_all.INCLUSIVE_TAX_USED_FLAG%type,
955 TAX_USE_CUSTOMER_EXEMPT_FLAG zx_product_options_all.TAX_USE_CUSTOMER_EXEMPT_FLAG%type,
956 TAX_USE_PRODUCT_EXEMPT_FLAG zx_product_options_all.TAX_USE_PRODUCT_EXEMPT_FLAG%type,
957 TAX_USE_LOC_EXC_RATE_FLAG zx_product_options_all.TAX_USE_LOC_EXC_RATE_FLAG%type,
958 TAX_ALLOW_COMPOUND_FLAG zx_product_options_all.TAX_ALLOW_COMPOUND_FLAG%type,
959 USE_TAX_CLASSIFICATION_FLAG zx_product_options_all.USE_TAX_CLASSIFICATION_FLAG%type,
960 ALLOW_TAX_ROUNDING_OVRD_FLAG zx_product_options_all.ALLOW_TAX_ROUNDING_OVRD_FLAG%type,
961 HOME_COUNTRY_DEFAULT_FLAG zx_product_options_all.HOME_COUNTRY_DEFAULT_FLAG%type,
962 TAX_ROUNDING_RULE zx_product_options_all.TAX_ROUNDING_RULE%type,
963 TAX_PRECISION zx_product_options_all.TAX_PRECISION%type,
964 TAX_MINIMUM_ACCOUNTABLE_UNIT zx_product_options_all.TAX_MINIMUM_ACCOUNTABLE_UNIT%type,
965 TAX_CURRENCY_CODE zx_product_options_all.TAX_CURRENCY_CODE%type);
966
967 type zx_product_options_tbl_type is table of zx_product_options_rec_type index by binary_integer;
968
972 TYPE template_valid_info_rec is record(
969 -- This strucure is used to store information whether a template contains parameters
970 -- that are not passed by a specific Product Event Class. In that case, the template
971 -- will not be valid for that particular event class. This structure is used in Rule engine
973 DET_FACTOR_TEMPL_CODE ZX_DET_FACTOR_TEMPL_B.DET_FACTOR_TEMPL_CODE%TYPE,
974 EVENT_CLASS_MAPPING_ID ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE,
975 VALID BOOLEAN);
976 TYPE template_valid_info_tbl_type is table of template_valid_info_rec index by BINARY_INTEGER;
977
978 g_template_valid_info_tbl template_valid_info_tbl_type;
979
980 -- This structure caches the tax information assoicated with hz_cust_site_use table
981 -- it is referenced in zxccontrolb.pls/zxdiroundtaxpkgb.pls. The information in this structure is valid
982 -- throughout the session
983 Type cust_site_use_info_rec_type is RECORD
984 (SITE_USE_ID hz_cust_site_uses_all.site_use_id%TYPE,
985 TAX_REFERENCE hz_cust_site_uses_all.tax_reference%TYPE,
986 TAX_CODE hz_cust_site_uses_all.tax_code%TYPE,
987 TAX_ROUNDING_RULE hz_cust_site_uses_all.tax_rounding_rule%TYPE,
988 TAX_HEADER_LEVEL_FLAG hz_cust_site_uses_all.tax_header_level_flag%TYPE,
989 TAX_CLASSIFICATION hz_cust_site_uses_all.Tax_Classification%TYPE);
990
991 TYPE cust_site_use_info_tbl_type is TABLE of cust_site_use_info_rec_type index by BINARY_INTEGER;
992
993 -- This structure caches the tax information assoicated with hz_cust_accounts table
994 -- it is referenced in zxccontrolb.pls/zxdiroundtaxpkgb.pls. The information in this structure is valid
995 -- throughout the session
996
997 TYPE cust_acct_info_rec_type is RECORD
998 (CUST_ACCOUNT_ID hz_cust_accounts.cust_account_id%TYPE,
999 TAX_CODE hz_cust_accounts.tax_code%TYPE,
1000 TAX_ROUNDING_RULE hz_cust_accounts.tax_rounding_rule%TYPE,
1001 TAX_HEADER_LEVEL_FLAG hz_cust_accounts.tax_header_level_flag%TYPE);
1002
1003 TYPE cust_acct_info_tbl_type is TABLE of cust_acct_info_rec_type index by BINARY_INTEGER;
1004
1005 -- This structure caches the tax information assoicated with ap_supplier_sites table
1006 -- it is referenced in zxccontrolb.pls/zxdiroundtaxpkgb.pls. The information in this structure is valid
1007 -- throughout the session
1008
1009 TYPE supp_site_info_rec_type is RECORD
1010 (VENDOR_ID ap_suppliers.vendor_id%TYPE,
1011 VENDOR_SITE_ID ap_supplier_sites.vendor_site_id%type,
1012 TAX_ROUNDING_RULE VARCHAR2(10),
1013 TAX_ROUNDING_LEVEL VARCHAR2(10),
1014 Auto_Tax_Calc_Flag VARCHAR2(1),
1015 VAT_CODE ap_suppliers.VAT_Code%TYPE,
1016 VAT_REGISTRATION_NUM ap_suppliers.VAT_Registration_Num%TYPE,
1017 AMOUNT_INCLUDES_TAX_FLAG ap_suppliers.amount_includes_tax_flag%TYPE);
1018
1019 TYPE supp_site_info_tbl_type is TABLE of supp_site_info_rec_type index by BINARY_INTEGER;
1020
1021 -- This structures caches the Registration information associated with ZX_REGISTRATIONS table
1022 -- This table is referenced in zxccontrolb.pls and is indexed by combination of
1023 -- party_tax_profile_id, tax_regime_code, Tax and Jurisdiction. The value fetched
1024 -- using the key should be be checked for the tax Jurisdiction code
1025 -- and effectivity. The information in this structure is valid
1026 -- throughout the session
1027
1028 TYPE registration_info_tbl_type is table of ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC
1029 index by BINARY_INTEGER;
1030
1031 -- This structure caches the party_tax_profile related information and is valid
1032 -- throughout the session. This structure is indexed by party_tax_profile_id and
1033 -- is referenced in various APIs that need to access party tax profile information
1034 -- Also referenced in zxccontrolb.pls/zxdiroundtaxpkgb.pls
1035
1036 TYPE PARTY_TAX_PROF_INFO_REC_TYPE is record
1037 ( PARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE,
1038 PARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1039 PARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1040 SUPPLIER_FLAG zx_party_tax_profile.SUPPLIER_FLAG%TYPE,
1041 CUSTOMER_FLAG zx_party_tax_profile.CUSTOMER_FLAG%TYPE,
1042 SITE_FLAG zx_party_tax_profile.SITE_FLAG%TYPE,
1043 PROCESS_FOR_APPLICABILITY_FLAG zx_party_tax_profile.PROCESS_FOR_APPLICABILITY_FLAG%TYPE,
1044 ROUNDING_LEVEL_CODE zx_party_tax_profile.ROUNDING_LEVEL_CODE%TYPE,
1045 WITHHOLDING_START_DATE zx_party_tax_profile.WITHHOLDING_START_DATE%TYPE,
1046 ALLOW_AWT_FLAG zx_party_tax_profile.ALLOW_AWT_FLAG%TYPE,
1047 USE_LE_AS_SUBSCRIBER_FLAG zx_party_tax_profile.USE_LE_AS_SUBSCRIBER_FLAG%TYPE,
1048 LEGAL_ESTABLISHMENT_FLAG zx_party_tax_profile.LEGAL_ESTABLISHMENT_FLAG%TYPE,
1049 FIRST_PARTY_LE_FLAG zx_party_tax_profile.FIRST_PARTY_LE_FLAG%TYPE,
1050 REPORTING_AUTHORITY_FLAG zx_party_tax_profile.REPORTING_AUTHORITY_FLAG%TYPE,
1051 COLLECTING_AUTHORITY_FLAG zx_party_tax_profile.COLLECTING_AUTHORITY_FLAG%TYPE,
1052 PROVIDER_TYPE_CODE zx_party_tax_profile.PROVIDER_TYPE_CODE%TYPE,
1053 CREATE_AWT_DISTS_TYPE_CODE zx_party_tax_profile.CREATE_AWT_DISTS_TYPE_CODE%TYPE,
1054 CREATE_AWT_INVOICES_TYPE_CODE zx_party_tax_profile.CREATE_AWT_INVOICES_TYPE_CODE%TYPE,
1055 ALLOW_OFFSET_TAX_FLAG zx_party_tax_profile.ALLOW_OFFSET_TAX_FLAG%TYPE,
1056 EFFECTIVE_FROM_USE_LE zx_party_tax_profile.EFFECTIVE_FROM_USE_LE%TYPE,
1057 REP_REGISTRATION_NUMBER zx_party_tax_profile.REP_REGISTRATION_NUMBER%TYPE,
1058 ROUNDING_RULE_CODE zx_party_tax_profile.ROUNDING_RULE_CODE%TYPE);
1059
1060
1061 TYPE PARTY_TAX_PROF_INFO_TBL_TYPE is table of PARTY_TAX_PROF_INFO_REC_TYPE
1062 index by BINARY_INTEGER;
1063
1067
1064 -- The following record structure is used to retrieve the party_tax_profile_id
1065 -- given the party_id and party_type_code. This structure is indexed by a hash
1066 -- value of party_type_code||party_id
1068 TYPE PARTY_TAX_PROF_ID_INFO_REC is record
1069 (pARTY_ID zx_party_tax_profile.PARTY_ID%TYPE,
1070 pARTY_TYPE_CODE zx_party_tax_profile.PARTY_TYPE_CODE%TYPE,
1071 pARTY_TAX_PROFILE_ID zx_party_tax_profile.PARTY_TAX_PROFILE_ID%TYPE);
1072
1073 TYPE PARTY_TAX_PROF_ID_INFO_TBLTYPE is table of PARTY_TAX_PROF_ID_INFO_REC
1074 index by BINARY_INTEGER;
1075
1076
1077 -- The follwing structure caches the Tax Classification Code information along with
1078 -- matching records in zx_rates_b. This structure is useful in batch processing when
1079 -- the backward compatible 11i approach (STCC regime determination template) is used.
1080 -- This structure should be valid throughout the batch process.
1081
1082 TYPE TAX_CLASSIF_INFO_RECTYPE is record
1083 (TAX_CLASSIFICATION_CODE zx_id_tcc_mapping_all.tax_classification_code%type,
1084 SOURCE_TABLE VARCHAR2(15),
1085 TAX_REGIME_CODE zx_rates_b.tax_regime_code%type,
1086 TAX zx_rates_b.tax%type,
1087 TAX_STATUS_CODE zx_rates_b.tax_status_code%type,
1088 TAX_RATE_CODE zx_rates_b.tax_rate_Code%type,
1089 TAX_CLASS zx_rates_b.tax_class%type,
1090 EFFECTIVE_FROM date,
1091 EFFECTIVE_TO date,
1092 ENABLED_FLAG VARCHAR2(1),
1093 CONTENT_OWNER_ID NUMBER);
1094
1095 TYPE TAX_CLASSIF_INFO_TBLTYPE is table of TAX_CLASSIF_INFO_RECTYPE
1096 index by BINARY_INTEGER;
1097
1098 -- The following record type/table is used to cache the values of account string
1099 -- for a given CCID so that if the CCID is same on two transactions/lines the
1100 -- ccid to string conversion is done only once. the information in this structure is
1101 -- valid throughout the session.
1102
1103 TYPE CCID_ACCT_STRING_INFO_RECTYPE is record
1104 (CCID NUMBER,
1105 ACCOUNT_STRING VARCHAR2(2000),
1106 CHART_OF_ACCOUNTS_ID NUMBER);
1107
1108 TYPE CCID_ACCT_STRING_INFO_TBLTYPE is table of CCID_ACCT_STRING_INFO_RECTYPE
1109 index by binary_integer;
1110
1111 -- Adding a global record structure to be used for Partner Tax Calculation.
1112 -- Exemption information on the partner calculated tax lines
1113 -- will be populated based on thid record structure.
1114
1115 TYPE PTNR_EXEMPTION_REC_TYPE IS RECORD(
1116 trx_id NUMBER,
1117 trx_line_id NUMBER,
1118 tax VARCHAR2(30),
1119 tax_regime_code VARCHAR2(30),
1120 tax_provider_id NUMBER,
1121 tax_exemption_id NUMBER(15),
1122 st_exempt_reason_code VARCHAR2(30),
1123 co_exempt_reason_code VARCHAR2(30),
1124 ci_exempt_reason_code VARCHAR2(30),
1125 di_exempt_reason_code VARCHAR2(30),
1126 st_exempt_reason VARCHAR2(240),
1127 co_exempt_reason VARCHAR2(240),
1128 ci_exempt_reason VARCHAR2(240),
1129 di_exempt_reason VARCHAR2(240),
1130 exempt_certificate_number VARCHAR2(80)
1131 );
1132
1133 TYPE PTNR_EXEMPTION_TBL_TYPE IS TABLE OF PTNR_EXEMPTION_REC_TYPE
1134 INDEX BY VARCHAR2(4000);
1135 ptnr_exemption_tbl PTNR_EXEMPTION_TBL_TYPE;
1136
1137 --bug#8251315
1138 TYPE hz_zone_rec_type is record
1139 (
1140 location_id NUMBER,
1141 location_type VARCHAR2(30),
1142 zone_id NUMBER,
1143 zone_type VARCHAR2(30),
1144 zone_name VARCHAR2(360),
1145 zone_code VARCHAR2(30),
1146 trx_date DATE,
1147 indx_value VARCHAR2(4000),
1148 value NUMBER
1149 );
1150
1151 TYPE hz_zone_tbl_type is table of hz_zone_rec_type index by varchar2(4000);
1152 g_hz_zone_tbl hz_zone_tbl_type;
1153
1154 -- Latin Tax specific global structure ----------
1155 -- The following structure is introduced for Latin Tax Processing
1156
1157 TYPE lte_trx_rec_type is RECORD (
1158 application_id zx_lines_det_factors.application_id%TYPE,
1159 event_class_code zx_lines_det_factors.event_class_code%TYPE,
1160 entity_code zx_lines_det_factors.entity_code%TYPE,
1161 trx_id zx_lines_det_factors.trx_id%TYPE,
1162 event_id zx_lines_det_factors.event_id%TYPE,
1163 event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
1164 event_type_code zx_lines_det_factors.event_type_code%TYPE,
1165 tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
1166 tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
1167 doc_status_code VARCHAR2(30),
1168 record_flag zx_evnt_cls_mappings.record_flag%TYPE,
1169 quote_flag zx_trx_headers_gt.quote_flag%TYPE,
1170 record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
1171 prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
1172 first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
1173 internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
1174 legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
1175 ledger_id zx_lines_det_factors.ledger_id%TYPE,
1176 establishment_id zx_lines_det_factors.establishment_id%TYPE,
1177 currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
1178 process_for_applicability_flag VARCHAR2(1),
1179 perf_addnl_appl_for_imprt_flag VARCHAR2(1),
1180 effective_date DATE
1184 INDEX BY BINARY_INTEGER;
1181 );
1182
1183 TYPE lte_trx_tbl_type IS TABLE OF lte_trx_rec_type
1185
1186 lte_trx_tbl lte_trx_tbl_type;
1187
1188 --------------------------------------------------------
1189
1190
1191 /* ===========================================================*
1192 | Global Structure Variables |
1193 * ==========================================================*/
1194
1195 trx_line_dist_tbl trx_line_dist_rec_type;
1196 detail_tax_regime_tbl detail_tax_regime_tbl_type;
1197 tax_regime_tbl tax_regime_tbl_type;
1198 trx_line_app_regime_tbl trx_line_app_regime_rec_type;
1199 location_info_tbl location_info_rec_type;
1200 tax_classif_info_tbl tax_classif_info_tbltype;
1201 /* bug fix 4222298 */
1202 location_hash_tbl location_hash_tbl_type;
1203 FC_COUNTRY_DEF_VAL_TBL fc_country_def_val_tbl_type;
1204 /* bug fix 13806759 */
1205 -- PlSql Table for Product Type Caching --
1206 ITEM_PRODUCT_TYPE_VAL_TBL item_fiscal_type_val_tbl_type;
1207 -- PlSql table for Intended Use Caching --
1208 ITEM_INTENDED_USE_VAL_TBL item_fiscal_type_val_tbl_type;
1209 g_event_class_rec zx_api_pub.event_class_rec_type;
1210 g_intended_use_owner_tbl_info intended_use_tbl_info_rectype;
1211 g_zx_proudct_options_tbl zx_product_options_tbl_type;
1212 g_cust_site_use_info_tbl cust_site_use_info_tbl_type;
1213 g_cust_acct_info_tbl cust_acct_info_tbl_type;
1214 g_geography_type_info_tbl geography_type_info_tbl_type;
1215 g_registration_info_tbl registration_info_tbl_type;
1216 g_party_tax_prof_info_tbl party_tax_prof_info_tbl_type;
1217 g_supp_site_info_tbl supp_site_info_tbl_type;
1218 g_ccid_acct_string_info_tbl ccid_acct_string_info_tbltype;
1219 g_party_tax_prof_id_info_tbl party_tax_prof_id_info_tbltype;
1220 g_zx_event_class_rec_tbl zx_event_class_rec_tbltype;
1221 g_zx_evnt_typ_map_tbl evnt_typ_map_tbltype;
1222 g_zx_evnt_cls_typs_tbl VARCHAR2_30_tbl_type;
1223 g_zx_tax_evnt_cls_tbl tax_event_cls_info_tbltype;
1224
1225 /* ===========================================================*
1226 | Global Variables |
1227 * ==========================================================*/
1228 g_credit_memo_exists_flg VARCHAR2(1);
1229 g_ptnr_srvc_subscr_flag VARCHAR2(1);
1230 g_update_event_process_flag VARCHAR2(1);
1231 g_bulk_process_flag VARCHAR2(1);
1232 g_inventory_installed_flag VARCHAR2(1);
1233
1234 /* ==========================================================*
1235 | Public procedures |
1236 * =================+=======================================*/
1237
1238 PROCEDURE init_tax_regime_tbl ;
1239 PROCEDURE init_detail_tax_regime_tbl;
1240 PROCEDURE init_trx_line_dist_tbl(l_trx_line_index IN NUMBER);
1241 PROCEDURE init_trx_line_app_regime_tbl;
1242 PROCEDURE init_trx_headers_gt;
1243 PROCEDURE init_trx_lines_gt;
1244 PROCEDURE delete_trx_line_dist_tbl;
1245 PROCEDURE get_product_options_info(p_application_id IN NUMBER,
1246 p_org_id IN NUMBER,
1247 x_product_options_rec OUT NOCOPY zx_product_options_rec_type,
1248 x_return_status OUT NOCOPY VARCHAR2);
1249
1250 PROCEDURE get_regimes_usages_info(p_tax_regime_code IN VARCHAR2,
1251 p_first_pty_org_id IN NUMBER,
1252 x_regime_usage_id OUT NOCOPY NUMBER,
1253 x_return_status OUT NOCOPY VARCHAR2);
1254
1255 -- overloadded API for bug 8969799
1256 --
1257 PROCEDURE get_product_options_info(
1258 p_application_id IN NUMBER,
1259 p_org_id IN NUMBER,
1260 p_event_class_mapping_id IN zx_lines_det_factors.EVENT_CLASS_MAPPING_ID%TYPE,
1261 x_product_options_rec OUT NOCOPY zx_product_options_rec_type,
1262 x_return_status OUT NOCOPY VARCHAR2);
1263
1264 END ZX_GLOBAL_STRUCTURES_PKG;