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