[Home] [Help]
PACKAGE: APPS.ZX_TAX_PARTNER_PKG
Source
1 PACKAGE ZX_TAX_PARTNER_PKG AS
2 /* $Header: zxiftaxptnrpubs.pls 120.19.12010000.3 2008/11/17 20:26:41 tsen ship $ */
3 /* ======================================================================*
4 | Global Data Types |
5 * ======================================================================*/
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TAX_PARTNER_PKG';
8 G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9 LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10 LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11 LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12 LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13 LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14 LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15 G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TAX_PARTNER_PKG.';
16
17 /* ======================================================================*
18 | Global Structure Data Types |
19 * ======================================================================*/
20
21 TYPE NUMBER_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
22 TYPE VARCHAR2_1_tbl_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
23 TYPE VARCHAR2_2_tbl_type IS TABLE OF VARCHAR2(2) INDEX BY BINARY_INTEGER;
24 TYPE VARCHAR2_15_tbl_type IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
25 TYPE VARCHAR2_30_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
26 TYPE VARCHAR2_80_tbl_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
27 TYPE VARCHAR2_50_tbl_type IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
28 TYPE VARCHAR2_150_tbl_type IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
29 TYPE VARCHAR2_240_tbl_type IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
30 TYPE DATE_tbl_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
31
32
33 TYPE tax_currencies_rec_type IS RECORD (
34 TAX VARCHAR2(30),
35 TAX_CURRENCY_CODE VARCHAR2(15), -- Bug 5090593
36 TRX_LINE_CURRENCY_CODE VARCHAR2(15), -- Bug 5090593
37 EXCHANGE_RATE NUMBER,
38 TAX_CURRENCY_PRECISION NUMBER -- Bug 5288518
39 );
40
41 TYPE tax_currencies_tbl_type IS TABLE OF tax_currencies_rec_type
42 INDEX BY BINARY_INTEGER;
43
44 TYPE exemption_rec_type IS RECORD (
45 CONTENT_OWNER_ID NUMBER,
46 COUNTRY_CODE VARCHAR2(30),
47 LAST_IMPORT_DATETIME DATE
48 );
49
50 TYPE exemptions_tbl_type IS RECORD (
51 CONTENT_OWNER_ID Number_tbl_type,
52 EXEMPTION_CLASS_CODE VARCHAR2_30_TBL_TYPE,
53 COUNTRY_CODE VARCHAR2_30_TBL_TYPE,
54 TAX VARCHAR2_30_TBL_TYPE,
55 EXEMPT_CERTIFICATE_NUMBER VARCHAR2_80_TBL_TYPE,
56 EXEMPT_REASON_CODE VARCHAR2_240_TBL_TYPE,
57 EFFECTIVE_FROM DATE_TBL_TYPE,
58 EFFECTIVE_TO DATE_TBL_TYPE,
59 EXEMPT_RATE_MODIFIER NUMBER_TBL_TYPE,
60 PARTY_NUMBER VARCHAR2_30_tbl_type,
61 PARTY_FISCAL_CLASSIFICATION VARCHAR2_30_tbl_type,
62 PARTY_TAX_PROFILE_ID Number_tbl_type,
63 GEOGRAPHY_ID Number_tbl_type,
64 STATE VARCHAR2_30_TBL_TYPE,
65 COUNTY VARCHAR2_30_TBL_TYPE,
66 CITY VARCHAR2_30_TBL_TYPE
67 );
68
69 TYPE exmpt_messages_tbl_type IS RECORD (
70 INTERNAL_ORGANIZATION_ID NUMBER_TBL_TYPE,
71 EXEMPTION_CLASS_CODE VARCHAR2_30_TBL_TYPE,
72 COUNTRY_CODE VARCHAR2_30_TBL_TYPE,
73 TAX VARCHAR2_30_TBL_TYPE,
74 ERROR_MESSAGE_TYPE VARCHAR2_30_TBL_TYPE,
75 ERROR_MESSAGE_STRING VARCHAR2_240_TBL_TYPE
76 );
77
78
79 TYPE tax_lines_tbl_type IS RECORD (
80 TAX_LINE_ID NUMBER_tbl_type,
81 BUSINESS_GROUP_ID NUMBER_tbl_type,
82 INTERNAL_ORGANIZATION_ID NUMBER_tbl_type,
83 DOCUMENT_TYPE_ID NUMBER_tbl_type,
84 APPLICATION_ID NUMBER_tbl_type,
85 ENTITY_CODE VARCHAR2_30_tbl_type,
86 EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
87 EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
88 TRANSACTION_ID NUMBER_tbl_type,
89 TRANSACTION_LINE_ID NUMBER_tbl_type,
90 TRX_LEVEL_TYPE VARCHAR2_30_tbl_type,
91 TAX_LINE_NUMBER NUMBER_tbl_type,
92 COUNTRY_CODE VARCHAR2_30_tbl_type,
93 TAX VARCHAR2_30_tbl_type,
94 TAX_STATUS_CODE VARCHAR2_30_tbl_type,
95 TAX_RATE_CODE VARCHAR2_50_tbl_type,
96 RATE_TYPE_CODE VARCHAR2_30_tbl_type,
97 TAX_APPORTIONMENT_LINE_NUMBER NUMBER_tbl_type,
98 SITUS VARCHAR2_30_tbl_type,
99 TAX_JURISDICTION VARCHAR2_30_tbl_type,
100 TAX_CURRENCY_CODE VARCHAR2_15_tbl_type,
101 TAX_AMOUNT NUMBER_tbl_type,
102 UNROUNDED_TAX_AMOUNT NUMBER_tbl_type,
103 TAX_CURR_TAX_AMOUNT NUMBER_tbl_type,
104 TAX_RATE_PERCENTAGE NUMBER_tbl_type,
105 TAXABLE_AMOUNT NUMBER_tbl_type,
106 EXEMPT_AMT NUMBER_tbl_type,
107 EXEMPT_CERTIFICATE_NUMBER VARCHAR2_80_TBL_TYPE,
108 EXEMPT_RATE_MODIFIER NUMBER_tbl_type,
109 EXEMPT_REASON VARCHAR2_240_tbl_type,
110 SYNC_WITH_PRVDR_FLAG VARCHAR2_1_tbl_type,
111 TAX_ONLY_LINE_FLAG VARCHAR2_1_tbl_type,
112 INCLUSIVE_TAX_LINE_FLAG VARCHAR2_1_tbl_type,
113 LINE_AMT_INCLUDES_TAX_FLAG VARCHAR2_1_tbl_type,
114 USE_TAX_FLAG VARCHAR2_1_tbl_type,
115 USER_OVERRIDE_FLAG VARCHAR2_1_tbl_type,
116 LAST_MANUAL_ENTRY VARCHAR2_30_tbl_type,
117 MANUALLY_ENTERED_FLAG VARCHAR2_1_tbl_type,
118 REGISTRATION_PARTY_TYPE VARCHAR2_30_tbl_type, -- Bug 5288518
119 PARTY_TAX_REG_NUMBER VARCHAR2_30_tbl_type, -- Bug 5288518
120 THIRD_PARTY_TAX_REG_NUMBER VARCHAR2_30_tbl_type,
121 TAX_PROVIDER_ID NUMBER_tbl_type,
122 CANCEL_FLAG VARCHAR2_1_tbl_type,
123 DELETE_FLAG VARCHAR2_1_tbl_type,
124 THRESHOLD_INDICATOR_FLAG VARCHAR2_1_tbl_type,
125 TAX_PRECISION NUMBER_tbl_type,
126 MINIMUM_ACCOUNTABLE_UNIT NUMBER_tbl_type,
127 ROUNDING_RULE_CODE VARCHAR2_30_tbl_type,
128 STATE VARCHAR2_2_tbl_type,
129 COUNTY VARCHAR2_30_tbl_type,
130 CITY VARCHAR2_30_tbl_type,
131 TRX_LINE_NUMBER NUMBER_tbl_type,
132 TRX_NUMBER VARCHAR2_150_tbl_type,
133 LINE_AMT NUMBER_tbl_type,
134 TRX_DATE DATE_tbl_type,
135 UNIT_PRICE NUMBER_tbl_type,
136 TRX_LINE_QUANTITY NUMBER_tbl_type,
137 DOC_EVENT_STATUS VARCHAR2_30_tbl_type,
138 TAX_EVENT_CLASS_CODE VARCHAR2_30_tbl_type,
139 TAX_EVENT_TYPE_CODE VARCHAR2_30_tbl_type,
140 TAX_REGIME_ID NUMBER_tbl_type,
141 TAX_ID NUMBER_tbl_type,
142 TAX_STATUS_ID NUMBER_tbl_type,
143 TAX_RATE_ID NUMBER_tbl_type,
144 LEDGER_ID NUMBER_tbl_type,
145 LEGAL_ENTITY_ID NUMBER_tbl_type,
146 TAX_CURRENCY_CONVERSION_DATE DATE_tbl_type,
147 TAX_CURRENCY_CONVERSION_TYPE VARCHAR2_30_tbl_type,
148 TAX_CURRENCY_CONVERSION_RATE NUMBER_tbl_type,
149 TRX_CURRENCY_CODE VARCHAR2_30_tbl_type,
150 OFFSET_FLAG VARCHAR2_1_tbl_type,
151 PROCESS_FOR_RECOVERY_FLAG VARCHAR2_1_tbl_type,
152 TAX_JURISDICTION_ID NUMBER_tbl_type,
153 TAX_DATE DATE_tbl_type,
154 TAX_DETERMINE_DATE DATE_tbl_type,
155 TRX_LINE_DATE DATE_tbl_type,
156 TAX_TYPE_CODE VARCHAR2_30_tbl_type,
157 COMPOUNDING_TAX_FLAG VARCHAR2_1_tbl_type,
158 TAXABLE_AMT_TAX_CURR NUMBER_tbl_type,
159 TAX_APPORTIONMENT_FLAG VARCHAR2_1_tbl_type,
160 HISTORICAL_FLAG VARCHAR2_1_tbl_type,
161 PURGE_FLAG VARCHAR2_1_tbl_type,
162 REPORTING_ONLY_FLAG VARCHAR2_1_tbl_type,
163 FREEZE_UNTIL_OVERRIDDEN_FLAG VARCHAR2_1_tbl_type,
164 COPIED_FROM_OTHER_DOC_FLAG VARCHAR2_1_tbl_type,
165 MRC_TAX_LINE_FLAG VARCHAR2_1_tbl_type,
166 APPLIED_FROM_APPLICATION_ID NUMBER_tbl_type, -- Bug 5468010
167 APPLIED_FROM_ENTITY_CODE VARCHAR2_30_tbl_type, -- Bug 5468010
168 APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2_30_tbl_type, -- Bug 5468010
169 APPLIED_FROM_TRX_ID NUMBER_tbl_type, -- Bug 5468010
170 APPLIED_FROM_LINE_ID NUMBER_tbl_type, -- Bug 5468010
171 APPLIED_FROM_TRX_LEVEL_TYPE VARCHAR2_30_tbl_type, -- Bug 5468010
172 APPLIED_FROM_TRX_NUMBER VARCHAR2_150_tbl_type, -- Bug 5468010
173 ADJUSTED_DOC_APPLICATION_ID NUMBER_tbl_type, -- Bug 5468010
174 ADJUSTED_DOC_ENTITY_CODE VARCHAR2_30_tbl_type, -- Bug 5468010
175 ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2_30_tbl_type, -- Bug 5468010
176 ADJUSTED_DOC_TRX_ID NUMBER_tbl_type, -- Bug 5468010
177 ADJUSTED_DOC_LINE_ID NUMBER_tbl_type, -- Bug 5468010
178 ADJUSTED_DOC_TRX_LEVEL_TYPE VARCHAR2_30_tbl_type, -- Bug 5468010
179 ADJUSTED_DOC_NUMBER VARCHAR2_150_tbl_type, -- Bug 5468010
180 ADJUSTED_DOC_DATE DATE_tbl_type, -- Bug 5468010
181 ADJUSTED_DOC_TAX_LINE_ID NUMBER_tbl_type,
182 GLOBAL_ATTRIBUTE2 VARCHAR2_150_tbl_type, -- Bug 6831713
183 GLOBAL_ATTRIBUTE4 VARCHAR2_150_tbl_type, -- Bug 6831713
184 GLOBAL_ATTRIBUTE6 VARCHAR2_150_tbl_type, -- Bug 6831713
185 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2_150_tbl_type, -- Bug 6831713
186 TAX_EXEMPTION_ID NUMBER_tbl_type,
187 EXEMPT_REASON_CODE VARCHAR2_30_tbl_type
188 );
189
190 TYPE sync_tax_lines_rec_type IS RECORD (
191 INTERNAL_ORGANIZATION_ID NUMBER,
192 LEGAL_ENTITY_NUMBER VARCHAR2(30),
193 ESTABLISHMENT_NUMBER VARCHAR2(30), -- Bug 5139731
194 DOCUMENT_TYPE_ID NUMBER,
195 APPLICATION_ID NUMBER,
196 ENTITY_CODE VARCHAR2(30),
197 EVENT_CLASS_CODE VARCHAR2(30),
198 TRANSACTION_ID NUMBER,
199 TRANSACTION_LINE_ID NUMBER,
200 TRX_LEVEL_TYPE VARCHAR2(30),
201 COUNTRY_CODE VARCHAR2(30),
202 TAX VARCHAR2(30),
203 TAX_APPORTIONMENT_LINE_NUMBER NUMBER,
204 SITUS VARCHAR2(30),
205 TAX_RATE_PERCENTAGE NUMBER,
206 TAXABLE_AMOUNT NUMBER
207 );
208 TYPE output_sync_tax_lines_tbl_type IS TABLE OF sync_tax_lines_rec_type
209 INDEX BY BINARY_INTEGER;
210
211 TYPE trx_rec_type IS RECORD (
212 DOCUMENT_TYPE_ID NUMBER,
213 TRANSACTION_ID NUMBER,
214 DOCUMENT_LEVEL_ACTION VARCHAR2(30)
215 );
216
217 TYPE trx_tbl_type IS TABLE OF trx_rec_type
218 INDEX BY BINARY_INTEGER; -- Bug 5664259
219
220 TYPE messages_rec_type IS RECORD (
221 DOCUMENT_TYPE_ID NUMBER,
222 TRANSACTION_ID NUMBER,
223 TRANSACTION_LINE_ID NUMBER,
224 TRX_LEVEL_TYPE VARCHAR2(30),
225 COUNTRY_CODE VARCHAR2(30),
226 TAX VARCHAR2(30),
227 SITUS VARCHAR2(30),
228 ERROR_MESSAGE_TYPE VARCHAR2(30),
229 ERROR_MESSAGE_STRING VARCHAR2(240)
230 );
231
232 TYPE messages_tbl_type IS RECORD (
233 DOCUMENT_TYPE_ID Number_tbl_type,
234 TRANSACTION_ID Number_tbl_type,
235 TRANSACTION_LINE_ID Number_tbl_type,
236 EXEMPTION_CLASS_CODE VARCHAR2_30_TBL_TYPE,
237 TRX_LEVEL_TYPE VARCHAR2_30_TBL_TYPE,
238 COUNTRY_CODE VARCHAR2_30_TBL_TYPE,
239 TAX VARCHAR2_30_TBL_TYPE,
240 SITUS VARCHAR2_30_TBL_TYPE,
241 ERROR_MESSAGE_TYPE VARCHAR2_30_TBL_TYPE,
242 ERROR_MESSAGE_STRING VARCHAR2_240_TBL_TYPE
243 );
244
245 G_BUSINESS_FLOW VARCHAR2(30);
246 G_TAX_REGIME_CODE VARCHAR2(30);
247 G_EVENT_CLASS_REC ZX_API_PUB.event_class_rec_type;
248 END ZX_TAX_PARTNER_PKG;
249