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