DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_RATES_B

Line 243: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

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

Line 257: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

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

Line 265: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

261: );
262:
263: PROCEDURE do_rounding(
264: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
265: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
266: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
267: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
268: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
269: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,

Line 395: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,

391: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
392: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
393: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
394: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
395: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
396: p_return_status OUT NOCOPY VARCHAR2,
397: p_error_buffer OUT NOCOPY VARCHAR2
398: );
399:

Line 445: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

441: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
442: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
443: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
444: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
445: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
446: p_return_status OUT NOCOPY VARCHAR2,
447: p_error_buffer OUT NOCOPY VARCHAR2
448: );
449:

Line 3485: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

3481: p_tax_min_acct_unit IN ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
3482: p_tax_precision IN ZX_TAXES_B.TAX_PRECISION%TYPE,
3483: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3484: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3485: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3486: p_rounded_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3487: p_return_status OUT NOCOPY VARCHAR2,
3488: p_error_buffer OUT NOCOPY VARCHAR2,
3489: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884

Line 3493: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;

3489: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL) --Bug7183884
3490:
3491: IS
3492: l_amt_tax_curr NUMBER;
3493: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
3494: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
3495:
3496: BEGIN
3497:

Line 3597: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

3593: p_convert_round_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
3594: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
3595: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
3596: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
3597: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
3598: p_rounded_amt_funcl_curr IN ZX_LINES.TAX_AMT_FUNCL_CURR%TYPE,
3599: p_return_status OUT NOCOPY VARCHAR2,
3600: p_error_buffer OUT NOCOPY VARCHAR2
3601: )

Line 3604: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;

3600: p_error_buffer OUT NOCOPY VARCHAR2
3601: )
3602: IS
3603: l_amt_funcl_curr NUMBER;
3604: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
3605: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
3606:
3607: BEGIN
3608: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4679: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

4675: --
4676:
4677: PROCEDURE do_rounding(
4678: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
4679: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
4680: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4681: p_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,
4682: p_orig_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
4683: p_orig_taxable_amt IN OUT NOCOPY ZX_LINES.TAXABLE_AMT%TYPE,

Line 5218: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,

5214: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,
5215: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
5216: c_tax ZX_TAXES_B.tax%TYPE,
5217: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
5218: c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
5219: c_tax_rate ZX_LINES.TAX_RATE%TYPE,
5220: c_tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
5221: c_tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
5222: c_taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,

Line 5470: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,

5466: p_tax_amt_tax_curr IN ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
5467: p_taxable_amt IN ZX_LINES.TAXABLE_AMT%TYPE,
5468: p_taxable_amt_tax_curr IN ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
5469: p_mrc_tax_line_flag IN zx_lines.mrc_tax_line_flag%TYPE,
5470: p_rate_type_code IN ZX_RATES_B.RATE_TYPE_CODE%TYPE,
5471: p_return_status OUT NOCOPY VARCHAR2,
5472: p_error_buffer OUT NOCOPY VARCHAR2
5473: )
5474: IS

Line 5745: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;

5741: l_sum_rnd_tax_amt NUMBER;
5742: l_sum_rnd_tax_curr NUMBER;
5743: l_sum_rnd_funcl_curr NUMBER;
5744: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
5745: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
5746:
5747: l_tax_line_id_tbl TAX_LINE_ID_TBL;
5748: l_manually_entered_flag_tbl MANUALLY_ENTERED_FLAG_TBL;
5749: l_tax_id_tbl TAX_ID_TBL;

Line 6548: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

6544: p_conv_rnd_taxable_amt_curr OUT NOCOPY ZX_LINES.TAXABLE_AMT_TAX_CURR%TYPE,
6545: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
6546: p_tax_calculation_formula IN ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
6547: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
6548: p_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
6549: p_return_status OUT NOCOPY VARCHAR2,
6550: p_error_buffer OUT NOCOPY VARCHAR2
6551: )
6552: IS