DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_RATES_B

Line 247: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

243: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
244: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
245: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
246: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
247: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
248: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
249: p_return_status OUT NOCOPY VARCHAR2,
250: p_error_buffer OUT NOCOPY VARCHAR2,
251: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL);--Bug7183884

Line 261: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

257: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
258: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
259: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
260: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
261: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
262: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
263: p_return_status OUT NOCOPY VARCHAR2,
264: p_error_buffer OUT NOCOPY VARCHAR2
265: );

Line 269: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

265: );
266:
267: PROCEDURE do_rounding(
268: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
269: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
270: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
271: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
272: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
273: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,

Line 403: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,

399: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
400: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
401: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
402: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
403: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
404: p_return_status OUT NOCOPY VARCHAR2,
405: p_error_buffer OUT NOCOPY VARCHAR2
406: );
407:

Line 453: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

449: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
450: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
451: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
452: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
453: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
454: p_return_status OUT NOCOPY VARCHAR2,
455: p_error_buffer OUT NOCOPY VARCHAR2
456: );
457:

Line 3493: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

3489: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3490: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3491: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3492: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3493: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3494: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3495: p_return_status OUT NOCOPY VARCHAR2,
3496: p_error_buffer OUT NOCOPY VARCHAR2,
3497: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884

Line 3501: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;

3497: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3498:
3499: IS
3500: l_amt_tax_curr NUMBER;
3501: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
3502: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
3503:
3504: BEGIN
3505:

Line 3604: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

3600: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3601: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3602: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3603: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3604: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3605: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3606: p_return_status OUT NOCOPY VARCHAR2,
3607: p_error_buffer OUT NOCOPY VARCHAR2
3608: )

Line 3611: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;

3607: p_error_buffer OUT NOCOPY VARCHAR2
3608: )
3609: IS
3610: l_amt_funcl_curr NUMBER;
3611: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
3612: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
3613:
3614: BEGIN
3615: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4748: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

4744: --
4745:
4746: PROCEDURE do_rounding(
4747: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4748: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
4749: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4750: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4751: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4752: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,

Line 5384: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,

5380: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
5381: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5382: c_tax ZX_TAXES_B.tax%TYPE,
5383: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
5384: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
5385: c_tax_rate ZX_LINES.TAX_RATE%TYPE,
5386: c_tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
5387: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5388: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,

Line 5636: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,

5632: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5633: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5634: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5635: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5636: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5637: p_return_status OUT NOCOPY VARCHAR2,
5638: p_error_buffer OUT NOCOPY VARCHAR2
5639: )
5640: IS

Line 5988: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;

5984: l_sum_rnd_tax_amt NUMBER;
5985: l_sum_rnd_tax_curr NUMBER;
5986: l_sum_rnd_funcl_curr NUMBER;
5987: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
5988: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
5989:
5990: l_tax_line_id_tbl TAX_LINE_ID_TBL;
5991: l_internal_organization_id_tbl INTERNAL_ORGANIZATION_ID_TBL;
5992: l_manually_entered_flag_tbl MANUALLY_ENTERED_FLAG_TBL;

Line 6807: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

6803: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6804: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6805: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6806: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6807: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6808: p_return_status OUT NOCOPY VARCHAR2,
6809: p_error_buffer OUT NOCOPY VARCHAR2
6810: )
6811: IS