1 package ZX_TDS_TAX_ROUNDING_PKG AUTHID CURRENT_USER as
2 /* $Header: zxdiroundtaxpkgs.pls 120.25.12010000.3 2009/10/12 18:46:37 tsen ship $ */
3
4
5 TYPE currency_conversion_rec IS RECORD
6 (
7 min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8 precision ZX_TAXES_B.TAX_PRECISION%TYPE,
9 conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
10 derive_effective FND_CURRENCIES.DERIVE_EFFECTIVE%TYPE,
11 derive_type FND_CURRENCIES.DERIVE_TYPE%TYPE,
12 conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
13 currency_type VARCHAR2(30)
14 );
15
16
17 TYPE currency_conversion_tbl IS TABLE OF currency_conversion_rec
18 INDEX BY VARCHAR2(15);
19
20 TYPE tax_curr_conversion_rate_tbl IS TABLE OF NUMBER
21 INDEX BY BINARY_INTEGER;
22
23 TYPE hdr_grp_rec_type IS RECORD
24 (
25 application_id ZX_LINES.application_id%TYPE,
26 event_class_code ZX_LINES.event_class_code%TYPE,
27 entity_code ZX_LINES.entity_code%TYPE,
28 trx_id ZX_LINES.trx_id%TYPE,
29 tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
30 tax ZX_TAXES_B.tax%TYPE,
31 tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
32 tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
33 tax_rate ZX_LINES.TAX_RATE%TYPE,
34 tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
35 tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
36 taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
37 tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
38 tax_Amt_Included_Flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
39 compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
40 historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
41 self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
42 overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
43 manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
44 copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
45 associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
46 tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
47 mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
48 reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
49 applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
50 applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
51 applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
52 applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
53 applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
54 adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
55 adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
56 adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
57 adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
58 applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
59 applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
60 applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
61 applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
62 applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
63 tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
64 tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
65 tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
66 exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
67 exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
68 exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
69 exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
70 tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
71 tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
72 tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
73 exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
74 ledger_id ZX_LINES.LEDGER_ID%TYPE,
75 legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
76 establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
77 currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
78 currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
79 currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
80 record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE
81 );
82
83 TYPE header_rounding_info_rec IS RECORD
84 (
85 tax_line_id ZX_LINES.TAX_LINE_ID%TYPE,
86 tax_id ZX_LINES.TAX_ID%TYPE,
87 Rounding_Rule_Code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE,
88 min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
89 precision ZX_TAXES_B.TAX_PRECISION%TYPE,
90 sum_unrnd_tax_amt NUMBER,
91 sum_rnd_tax_amt NUMBER,
92 sum_rnd_tax_curr NUMBER,
93 sum_rnd_funcl_curr NUMBER,
94 max_unrnd_tax_amt NUMBER,
95 total_rec_in_grp NUMBER,
96 tax_curr_conv_rate ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
97 currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
98 rnd_tax_amt NUMBER,
99 rnd_tax_amt_tax_curr NUMBER,
100 rnd_tax_amt_funcl_curr NUMBER,
101 rnd_taxable_amt_tax_curr NUMBER,
102 rnd_taxable_amt_funcl_curr NUMBER,
103 tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
104 ledger_id ZX_LINES.LEDGER_ID%TYPE,
105 tax_rate ZX_LINES.TAX_RATE%TYPE,
106 mrc_tax_line_flag zx_lines.mrc_tax_line_flag%TYPE
107 );
108
109 TYPE hdr_rounding_info_tbl IS TABLE OF header_rounding_info_rec
110 INDEX BY BINARY_INTEGER;
111
112 TYPE header_rounding_curr_rec IS RECORD
113 (
114 tax_line_id ZX_LINES.TAX_LINE_ID%TYPE,
115 sum_unrnd_tax_amt NUMBER,
116 sum_rnd_curr NUMBER,
117 max_unrnd_tax_amt NUMBER,
118 total_rec_in_grp NUMBER,
119 currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
120 rnd_tax_amt_curr NUMBER,
121 rnd_taxable_amt_curr NUMBER,
122 tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
123 ledger_id ZX_LINES.LEDGER_ID%TYPE,
124 tax_rate ZX_LINES.TAX_RATE%TYPE
125 );
126
127 TYPE hdr_rounding_curr_tbl IS TABLE OF header_rounding_curr_rec
128 INDEX BY BINARY_INTEGER;
129
130 TYPE tax_line_id_tbl IS TABLE OF
131 ZX_LINES.tax_line_id%TYPE
132 INDEX BY BINARY_INTEGER;
133
134 TYPE manually_entered_flag_tbl IS TABLE OF
135 ZX_LINES.Manually_Entered_Flag%TYPE
136 INDEX BY BINARY_INTEGER;
137
138 TYPE tax_id_tbl IS TABLE OF
139 ZX_LINES.tax_id%TYPE
140 INDEX BY BINARY_INTEGER;
141
142 TYPE tax_regime_code_tbl IS TABLE OF
143 ZX_LINES.tax_regime_code%TYPE
144 INDEX BY BINARY_INTEGER;
145
146 TYPE tax_tbl IS TABLE OF
147 ZX_LINES.tax%TYPE
148 INDEX BY BINARY_INTEGER;
149
150 TYPE tax_status_code_tbl IS TABLE OF
151 ZX_LINES.tax_status_code%TYPE
152 INDEX BY BINARY_INTEGER;
153
154 TYPE tax_rate_code_tbl IS TABLE OF
155 ZX_LINES.tax_rate_code%TYPE
156 INDEX BY BINARY_INTEGER;
157
158 TYPE tax_rate_tbl IS TABLE OF
159 ZX_LINES.tax_rate%TYPE
160 INDEX BY BINARY_INTEGER;
161
162 TYPE tax_rate_id_tbl IS TABLE OF
163 ZX_LINES.tax_rate_id%TYPE
164 INDEX BY BINARY_INTEGER;
165
166 TYPE tax_jurisdiction_code_tbl IS TABLE OF
167 ZX_LINES.tax_jurisdiction_code%TYPE
168 INDEX BY BINARY_INTEGER;
169
170 TYPE taxable_basis_formula_tbl IS TABLE OF
171 ZX_LINES.taxable_basis_formula%TYPE
172 INDEX BY BINARY_INTEGER;
173
174 TYPE tax_calculation_formula_tbl IS TABLE OF
175 ZX_LINES.tax_calculation_formula%TYPE
176 INDEX BY BINARY_INTEGER;
177
178 TYPE tax_amt_included_flag_tbl IS TABLE OF
179 ZX_LINES.Tax_Amt_Included_Flag%TYPE
180 INDEX BY BINARY_INTEGER;
181
182 TYPE compounding_tax_flag_tbl IS TABLE OF
183 ZX_LINES.compounding_tax_flag%TYPE
184 INDEX BY BINARY_INTEGER;
185
186 TYPE historical_flag_tbl IS TABLE OF
187 ZX_LINES.historical_flag%TYPE
188 INDEX BY BINARY_INTEGER;
189
190 TYPE self_assessed_flag_tbl IS TABLE OF
191 ZX_LINES.self_assessed_flag%TYPE
192 INDEX BY BINARY_INTEGER;
193
194 TYPE overridden_flag_tbl IS TABLE OF
195 ZX_LINES.overridden_flag%TYPE
196 INDEX BY BINARY_INTEGER;
197
198 TYPE cop_from_other_doc_flag_tbl IS TABLE OF
199 ZX_LINES.copied_from_other_doc_flag%TYPE
200 INDEX BY BINARY_INTEGER;
201
202 TYPE assoc_child_frozen_flag_tbl IS TABLE OF
203 ZX_LINES.associated_child_frozen_flag%TYPE
204 INDEX BY BINARY_INTEGER;
205
206 TYPE tax_only_line_flag_tbl IS TABLE OF
207 ZX_LINES.tax_only_line_flag%TYPE
208 INDEX BY BINARY_INTEGER;
209
210 TYPE mrc_tax_line_flag_tbl IS TABLE OF
211 ZX_LINES.mrc_tax_line_flag%TYPE
212 INDEX BY BINARY_INTEGER;
213
214 TYPE reporting_only_flag_tbl IS TABLE OF
215 ZX_LINES.reporting_only_flag%TYPE
216 INDEX BY BINARY_INTEGER;
217
218 TYPE applied_from_applic_id_tbl IS TABLE OF
219 ZX_LINES.applied_from_application_id%TYPE
220 INDEX BY BINARY_INTEGER;
221
222 TYPE applied_from_evnt_cls_cd_tbl IS TABLE OF
223 ZX_LINES.applied_from_event_class_code%TYPE
224 INDEX BY BINARY_INTEGER;
225
226 TYPE applied_from_entity_code_tbl IS TABLE OF
227 ZX_LINES.applied_from_entity_code%TYPE
228 INDEX BY BINARY_INTEGER;
229
230 TYPE applied_from_trx_id_tbl IS TABLE OF
231 ZX_LINES.applied_from_trx_id%TYPE
232 INDEX BY BINARY_INTEGER;
233
234 TYPE applied_from_line_id_tbl IS TABLE OF
235 ZX_LINES.applied_from_line_id%TYPE
236 INDEX BY BINARY_INTEGER;
237
238 TYPE adjusted_doc_applic_id_tbl IS TABLE OF
239 ZX_LINES.adjusted_doc_application_id%TYPE
240 INDEX BY BINARY_INTEGER;
241
242 TYPE adjusted_doc_entity_code_tbl IS TABLE OF
243 ZX_LINES.adjusted_doc_entity_code%TYPE
244 INDEX BY BINARY_INTEGER;
245
246 TYPE adjusted_doc_evnt_cls_cd_tbl IS TABLE OF
247 ZX_LINES.adjusted_doc_event_class_code%TYPE
248 INDEX BY BINARY_INTEGER;
249
250 TYPE adjusted_doc_trx_id_tbl IS TABLE OF
251 ZX_LINES.adjusted_doc_trx_id%TYPE
252 INDEX BY BINARY_INTEGER;
253
254 TYPE applied_to_applic_id_tbl IS TABLE OF
255 ZX_LINES.applied_to_application_id%TYPE
256 INDEX BY BINARY_INTEGER;
257
258 TYPE applied_to_evnt_cls_cd_tbl IS TABLE OF
259 ZX_LINES.applied_to_event_class_code%TYPE
260 INDEX BY BINARY_INTEGER;
261
262 TYPE applied_to_entity_code_tbl IS TABLE OF
263 ZX_LINES.applied_to_entity_code%TYPE
264 INDEX BY BINARY_INTEGER;
265
266 TYPE applied_to_trx_id_tbl IS TABLE OF
267 ZX_LINES.applied_to_trx_id%TYPE
268 INDEX BY BINARY_INTEGER;
269
270 TYPE applied_to_line_id_tbl IS TABLE OF
271 ZX_LINES.applied_to_line_id%TYPE
272 INDEX BY BINARY_INTEGER;
273
274 TYPE tax_exemption_id_tbl IS TABLE OF
275 ZX_LINES.tax_exemption_id%TYPE
276 INDEX BY BINARY_INTEGER;
277
278 TYPE rate_before_exemption_tbl IS TABLE OF
279 ZX_LINES.tax_rate_before_exemption%TYPE
280 INDEX BY BINARY_INTEGER;
281
282 TYPE rate_name_before_exemption_tbl IS TABLE OF
283 ZX_LINES.tax_rate_name_before_exemption%TYPE
284 INDEX BY BINARY_INTEGER;
285
286 TYPE exempt_rate_modifier_tbl IS TABLE OF
287 ZX_LINES.exempt_rate_modifier%TYPE
288 INDEX BY BINARY_INTEGER;
289
290 TYPE exempt_certificate_num_tbl IS TABLE OF
291 ZX_LINES.exempt_certificate_number%TYPE
292 INDEX BY BINARY_INTEGER;
293
294 TYPE exempt_reason_tbl IS TABLE OF
295 ZX_LINES.exempt_reason%TYPE
296 INDEX BY BINARY_INTEGER;
297
298 TYPE exempt_reason_code_tbl IS TABLE OF
299 ZX_LINES.exempt_reason_code%TYPE
300 INDEX BY BINARY_INTEGER;
301
302 TYPE tax_exception_id_tbl IS TABLE OF
303 ZX_LINES.tax_exception_id%TYPE
304 INDEX BY BINARY_INTEGER;
305
306 TYPE rate_before_exception_tbl IS TABLE OF
307 ZX_LINES.tax_rate_before_exception%TYPE
308 INDEX BY BINARY_INTEGER;
309
310 TYPE rate_name_before_exception_tbl IS TABLE OF
311 ZX_LINES.tax_rate_name_before_exception%TYPE
312 INDEX BY BINARY_INTEGER;
313
314 TYPE exception_rate_tbl IS TABLE OF
315 ZX_LINES.exception_rate%TYPE
316 INDEX BY BINARY_INTEGER;
317
318 TYPE min_acct_unit_tbl IS TABLE OF
319 ZX_LINES.minimum_accountable_unit%TYPE
320 INDEX BY BINARY_INTEGER;
321
322 TYPE precision_tbl IS TABLE OF
323 ZX_LINES.precision%TYPE
324 INDEX BY BINARY_INTEGER;
325
326 TYPE trx_currency_code_tbl IS TABLE OF
327 ZX_LINES.trx_currency_code%TYPE
328 INDEX BY BINARY_INTEGER;
329
330 TYPE tax_currency_code_tbl IS TABLE OF
331 ZX_LINES.tax_currency_code%TYPE
332 INDEX BY BINARY_INTEGER;
333
334 TYPE tax_curr_conv_date_tbl IS TABLE OF
335 ZX_LINES.tax_currency_conversion_date%TYPE
336 INDEX BY BINARY_INTEGER;
337
338 TYPE tax_curr_conv_type_tbl IS TABLE OF
339 ZX_LINES.tax_currency_conversion_type%TYPE
340 INDEX BY BINARY_INTEGER;
341
342 TYPE tax_curr_conv_rate_tbl IS TABLE OF
343 ZX_LINES.tax_currency_conversion_rate%TYPE
344 INDEX BY BINARY_INTEGER;
345
346 TYPE tax_amt_tbl IS TABLE OF
347 ZX_LINES.tax_amt%TYPE
348 INDEX BY BINARY_INTEGER;
349
350 TYPE taxable_amt_tbl IS TABLE OF
351 ZX_LINES.taxable_amt%TYPE
352 INDEX BY BINARY_INTEGER;
353
354 TYPE cal_tax_amt_tbl IS TABLE OF
355 ZX_LINES.cal_tax_amt%TYPE
356 INDEX BY BINARY_INTEGER;
357
358 TYPE tax_amt_tax_curr_tbl IS TABLE OF
359 ZX_LINES.tax_amt_tax_curr%TYPE
360 INDEX BY BINARY_INTEGER;
361
362 TYPE taxable_amt_tax_curr_tbl IS TABLE OF
363 ZX_LINES.taxable_amt_tax_curr%TYPE
364 INDEX BY BINARY_INTEGER;
365
366 TYPE cal_tax_amt_tax_curr_tbl IS TABLE OF
367 ZX_LINES.cal_tax_amt_tax_curr%TYPE
368 INDEX BY BINARY_INTEGER;
369
370 TYPE rounding_rule_tbl IS TABLE OF
371 ZX_LINES.Rounding_Rule_Code%TYPE
372 INDEX BY BINARY_INTEGER;
373
374 TYPE unrounded_taxable_amt_tbl IS TABLE OF
375 ZX_LINES.unrounded_taxable_amt%TYPE
376 INDEX BY BINARY_INTEGER;
377
378 TYPE unrounded_tax_amt_tbl IS TABLE OF
379 ZX_LINES.unrounded_tax_amt%TYPE
380 INDEX BY BINARY_INTEGER;
381
382 TYPE currency_conversion_type_tbl IS TABLE OF
383 ZX_LINES.currency_conversion_type%TYPE
384 INDEX BY BINARY_INTEGER;
385
386 TYPE currency_conversion_rate_tbl IS TABLE OF
387 ZX_LINES.currency_conversion_rate%TYPE
388 INDEX BY BINARY_INTEGER;
389
390 TYPE currency_conversion_date_tbl IS TABLE OF
391 ZX_LINES.currency_conversion_date%TYPE
392 INDEX BY BINARY_INTEGER;
393
394 TYPE tax_amt_funcl_curr_tbl IS TABLE OF
395 ZX_LINES.tax_amt_funcl_curr%TYPE
396 INDEX BY BINARY_INTEGER;
397
398 TYPE taxable_amt_funcl_curr_tbl IS TABLE OF
399 ZX_LINES.taxable_amt_funcl_curr%TYPE
400 INDEX BY BINARY_INTEGER;
401
402 TYPE cal_tax_amt_funcl_curr_tbl IS TABLE OF
403 ZX_LINES.cal_tax_amt_funcl_curr%TYPE
404 INDEX BY BINARY_INTEGER;
405
406 TYPE rounding_level_tbl IS TABLE OF
407 ZX_LINES.Rounding_Level_Code%TYPE
408 INDEX BY BINARY_INTEGER;
409
410 TYPE ledger_id_tbl IS TABLE OF
411 ZX_LINES.ledger_id%TYPE
412 INDEX BY BINARY_INTEGER;
413
414 TYPE prd_total_tax_amt_tbl IS TABLE OF
415 ZX_LINES.prd_total_tax_amt%TYPE
416 INDEX BY BINARY_INTEGER;
417
418 TYPE prd_total_tax_amt_tax_curr_tbl IS TABLE OF
419 ZX_LINES.prd_total_tax_amt_tax_curr%TYPE
420 INDEX BY BINARY_INTEGER;
421
422 TYPE prd_total_tax_amt_fcl_curr_tbl IS TABLE OF
423 ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE
424 INDEX BY BINARY_INTEGER;
425
426 TYPE legal_entity_id_tbl IS TABLE OF
427 ZX_LINES.legal_entity_id%TYPE
428 INDEX BY BINARY_INTEGER;
429
430 TYPE establishment_id_tbl IS TABLE OF
431 ZX_LINES.establishment_id%TYPE
432 INDEX BY BINARY_INTEGER;
433
434 TYPE record_type_code_tbl IS TABLE OF
435 ZX_LINES.record_type_code%TYPE
436 INDEX BY BINARY_INTEGER;
437
438 TYPE tax_provider_id_tbl IS TABLE OF
439 ZX_LINES.tax_provider_id%TYPE
440 INDEX BY BINARY_INTEGER;
441
442 TYPE application_id_tbl IS TABLE OF
443 ZX_LINES.application_id%TYPE
444 INDEX BY BINARY_INTEGER;
445
446 TYPE INTERNAL_ORGANIZATION_ID_TBL IS TABLE OF
447 ZX_LINES.internal_organization_id%TYPE
448 INDEX BY BINARY_INTEGER;
449
450 TYPE event_class_code_tbl IS TABLE OF
451 ZX_LINES.event_class_code%TYPE
452 INDEX BY BINARY_INTEGER;
453
454 TYPE entity_code_tbl IS TABLE OF
455 ZX_LINES.entity_code%TYPE
456 INDEX BY BINARY_INTEGER;
457
458 TYPE trx_id_tbl IS TABLE OF
459 ZX_LINES.trx_id%TYPE
460 INDEX BY BINARY_INTEGER;
461
462 TYPE rounding_level_code_tbl IS TABLE OF
463 ZX_LINES.rounding_level_code%TYPE
464 INDEX BY BINARY_INTEGER;
465
466 g_currency_tbl currency_conversion_tbl;
467 g_tax_curr_conv_rate_tbl tax_curr_conversion_rate_tbl;
468 g_euro_code FND_CURRENCIES.CURRENCY_CODE%TYPE;
469
470 c_lines_per_commit CONSTANT NUMBER := ZX_TDS_CALC_SERVICES_PUB_PKG.G_LINES_PER_COMMIT;
471
472 FUNCTION round_tax(
473 p_amount IN NUMBER,
474 p_Rounding_Rule_Code IN ZX_TAXES_B.Rounding_Rule_Code%TYPE,
475 p_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
476 p_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
477 p_return_status OUT NOCOPY VARCHAR2,
478 p_error_buffer OUT NOCOPY VARCHAR2
479 ) RETURN NUMBER;
480
481 FUNCTION round_tax_funcl_curr(
482 p_unround_amt IN ZX_LINES.TAX_AMT%TYPE,
483 p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
484 p_return_status OUT NOCOPY VARCHAR2,
485 p_error_buffer OUT NOCOPY VARCHAR2
486 ) RETURN NUMBER;
487
488 PROCEDURE convert_to_currency(
489 p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
490 p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
491 p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
492 p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
493 p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
494 p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
495 p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
496 p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
497 p_return_status OUT NOCOPY VARCHAR2,
498 p_error_buffer OUT NOCOPY VARCHAR2,
499 p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL); --Bug7183884
500
501 PROCEDURE get_rounding_level_and_rule(
502 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
503 p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
504 p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
505 p_rnd_lvl_party_tax_prof_id
506 OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
507 p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,
508 p_return_status OUT NOCOPY VARCHAR2,
509 p_error_buffer OUT NOCOPY VARCHAR2
510 );
511
512 PROCEDURE get_rounding_rule(
513 p_trx_line_index IN BINARY_INTEGER,
514 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
515 p_tax_regime_code IN VARCHAR2,
516 p_tax IN VARCHAR2,
517 p_jurisdiction_code IN VARCHAR2,
518 p_tax_determine_date IN DATE,
519 p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
520 p_return_status OUT NOCOPY VARCHAR2,
521 p_error_buffer OUT NOCOPY VARCHAR2);
522
523 PROCEDURE perform_rounding(
524 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
525 p_return_status OUT NOCOPY VARCHAR2,
526 p_error_buffer OUT NOCOPY VARCHAR2
527 );
528
529
530 PROCEDURE convert_and_round_curr(
531 p_conversion_rate IN OUT NOCOPY NUMBER,
532 p_conversion_type IN VARCHAR2,
533 p_conversion_date IN DATE,
534 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
535 p_return_status OUT NOCOPY VARCHAR2,
536 p_error_buffer OUT NOCOPY VARCHAR2
537 );
538
539 PROCEDURE round_tax_amt_entered(
540 p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
541 p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
542 p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
543 p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
544 p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
545 p_trx_id IN ZX_LINES.TRX_ID%TYPE,
546 p_return_status OUT NOCOPY VARCHAR2,
547 p_error_buffer OUT NOCOPY VARCHAR2
548 );
549
550 end ZX_TDS_TAX_ROUNDING_PKG;
[Home] [Help]