DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 3494: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;

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:
3498: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 3508: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN

3504: END IF;
3505:
3506: p_return_status := FND_API.G_RET_STS_SUCCESS;
3507:
3508: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN
3509: l_rate_type_code :=
3510: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;
3511: ELSE
3512: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

Line 3510: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;

3506: p_return_status := FND_API.G_RET_STS_SUCCESS;
3507:
3508: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN
3509: l_rate_type_code :=
3510: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;
3511: ELSE
3512: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
3513: p_tax_rate_id => p_tax_rate_id,
3514: p_tax_rate_rec => l_tax_rate_rec,

Line 3512: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

3508: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN
3509: l_rate_type_code :=
3510: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;
3511: ELSE
3512: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
3513: p_tax_rate_id => p_tax_rate_id,
3514: p_tax_rate_rec => l_tax_rate_rec,
3515: p_return_status => p_return_status,
3516: p_error_buffer => p_error_buffer);

Line 3605: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;

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
3609: FND_LOG.STRING(g_level_statement,

Line 3618: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN

3614: END IF;
3615:
3616: p_return_status := FND_API.G_RET_STS_SUCCESS;
3617:
3618: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN
3619: l_rate_type_code :=
3620: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;
3621: ELSE
3622: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

Line 3620: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;

3616: p_return_status := FND_API.G_RET_STS_SUCCESS;
3617:
3618: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN
3619: l_rate_type_code :=
3620: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;
3621: ELSE
3622: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
3623: p_tax_rate_id => p_tax_rate_id,
3624: p_tax_rate_rec => l_tax_rate_rec,

Line 3622: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

3618: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(p_tax_rate_id) THEN
3619: l_rate_type_code :=
3620: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(p_tax_rate_id).rate_type_code;
3621: ELSE
3622: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
3623: p_tax_rate_id => p_tax_rate_id,
3624: p_tax_rate_rec => l_tax_rate_rec,
3625: p_return_status => p_return_status,
3626: p_error_buffer => p_error_buffer);

Line 3915: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;

3911: p_error_buffer OUT NOCOPY VARCHAR2
3912: )
3913: IS
3914: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;
3915: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
3916:
3917: BEGIN
3918:
3919: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 3932: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(p_tax_id) THEN

3928:
3929: --
3930: -- Bug#5410271- populate cache structure if not exist
3931: --
3932: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(p_tax_id) THEN
3933: ZX_TDS_UTILITIES_PKG.populate_tax_cache(
3934: p_tax_id,
3935: p_return_status,
3936: p_error_buffer);

Line 3933: ZX_TDS_UTILITIES_PKG.populate_tax_cache(

3929: --
3930: -- Bug#5410271- populate cache structure if not exist
3931: --
3932: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.EXISTS(p_tax_id) THEN
3933: ZX_TDS_UTILITIES_PKG.populate_tax_cache(
3934: p_tax_id,
3935: p_return_status,
3936: p_error_buffer);
3937:

Line 3949: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id);

3945: RETURN;
3946: END IF;
3947: END IF;
3948:
3949: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id);
3950: p_tax_precision := l_tax_rec.tax_precision;
3951: p_tax_min_acct_unit := l_tax_rec.minimum_accountable_unit;
3952: p_tax_currency_code := l_tax_rec.tax_currency_code;
3953: p_tax_currency_conversion_type := l_tax_rec.exchange_rate_type;

Line 4278: l_tax_precision := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(j).tax_precision;

4274: l_rnd_sum_unrnd_tx_curr := round(g_hdr_rounding_info_tbl(i).sum_unrnd_tax_amt *
4275: g_hdr_rounding_info_tbl(i).tax_curr_conv_rate,20);
4276: j := g_hdr_rounding_info_tbl(i).tax_id;
4277:
4278: l_tax_precision := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(j).tax_precision;
4279: l_tax_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(j).minimum_accountable_unit;
4280:
4281: l_rnd_sum_unrnd_tx_curr := round_tax(
4282: l_rnd_sum_unrnd_tx_curr,

Line 4279: l_tax_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(j).minimum_accountable_unit;

4275: g_hdr_rounding_info_tbl(i).tax_curr_conv_rate,20);
4276: j := g_hdr_rounding_info_tbl(i).tax_id;
4277:
4278: l_tax_precision := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(j).tax_precision;
4279: l_tax_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(j).minimum_accountable_unit;
4280:
4281: l_rnd_sum_unrnd_tx_curr := round_tax(
4282: l_rnd_sum_unrnd_tx_curr,
4283: g_hdr_rounding_info_tbl(i).Rounding_Rule_Code,

Line 5744: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;

5740: l_sum_unrnd_tax_amt NUMBER;
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;

Line 6408: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id_tbl(i)) THEN

6404: IF (l_tax_amt_tax_curr_tbl(i) IS NULL OR
6405: l_taxable_amt_tax_curr_tbl(i) IS NULL ) THEN
6406: -- get l_rate_type_code
6407:
6408: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id_tbl(i)) THEN
6409:
6410: l_rate_type_code :=
6411: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id_tbl(i)).rate_type_code;
6412: ELSE

Line 6411: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id_tbl(i)).rate_type_code;

6407:
6408: IF ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id_tbl(i)) THEN
6409:
6410: l_rate_type_code :=
6411: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id_tbl(i)).rate_type_code;
6412: ELSE
6413: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
6414: p_tax_rate_id => l_tax_rate_id_tbl(i),
6415: p_tax_rate_rec => l_tax_rate_rec,

Line 6413: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

6409:
6410: l_rate_type_code :=
6411: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id_tbl(i)).rate_type_code;
6412: ELSE
6413: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
6414: p_tax_rate_id => l_tax_rate_id_tbl(i),
6415: p_tax_rate_rec => l_tax_rate_rec,
6416: p_return_status => p_return_status,
6417: p_error_buffer => p_error_buffer);

Line 8355: IF ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(p_ledger_id) THEN

8351:
8352: --
8353: -- get functional currency info
8354: --
8355: IF ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(p_ledger_id) THEN
8356: --
8357: -- functional currency info can be obtained from the cache structure
8358: --
8359: p_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).currency_code;

Line 8359: p_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).currency_code;

8355: IF ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl.EXISTS(p_ledger_id) THEN
8356: --
8357: -- functional currency info can be obtained from the cache structure
8358: --
8359: p_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).currency_code;
8360: p_funcl_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).minimum_accountable_unit;
8361: p_funcl_precision := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).precision;
8362: ELSE
8363: --

Line 8360: p_funcl_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).minimum_accountable_unit;

8356: --
8357: -- functional currency info can be obtained from the cache structure
8358: --
8359: p_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).currency_code;
8360: p_funcl_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).minimum_accountable_unit;
8361: p_funcl_precision := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).precision;
8362: ELSE
8363: --
8364: -- functional currency info does not exist in cache structure

Line 8361: p_funcl_precision := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).precision;

8357: -- functional currency info can be obtained from the cache structure
8358: --
8359: p_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).currency_code;
8360: p_funcl_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).minimum_accountable_unit;
8361: p_funcl_precision := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).precision;
8362: ELSE
8363: --
8364: -- functional currency info does not exist in cache structure
8365: -- need to obtain from the database

Line 8367: ZX_TDS_UTILITIES_PKG.populate_currency_cache

8363: --
8364: -- functional currency info does not exist in cache structure
8365: -- need to obtain from the database
8366: --
8367: ZX_TDS_UTILITIES_PKG.populate_currency_cache
8368: (p_ledger_id,
8369: p_return_status,
8370: p_error_buffer );
8371:

Line 8380: p_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).currency_code;

8376: --
8377: RETURN;
8378: END IF;
8379:
8380: p_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).currency_code;
8381: p_funcl_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).minimum_accountable_unit;
8382: p_funcl_precision := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).precision;
8383:
8384: END IF;

Line 8381: p_funcl_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).minimum_accountable_unit;

8377: RETURN;
8378: END IF;
8379:
8380: p_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).currency_code;
8381: p_funcl_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).minimum_accountable_unit;
8382: p_funcl_precision := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).precision;
8383:
8384: END IF;
8385:

Line 8382: p_funcl_precision := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).precision;

8378: END IF;
8379:
8380: p_funcl_currency_code := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).currency_code;
8381: p_funcl_min_acct_unit := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).minimum_accountable_unit;
8382: p_funcl_precision := ZX_TDS_UTILITIES_PKG.g_currency_rec_tbl(p_ledger_id).precision;
8383:
8384: END IF;
8385:
8386: IF (g_level_procedure >= g_current_runtime_level ) THEN