DBA Data[Home] [Help]

APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 77: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;

73: l_allow_adhoc_tax_rate_flag VARCHAR2(1);
74: l_adj_for_adhoc_amt_code ZX_RATES_B.ADJ_FOR_ADHOC_AMT_CODE%TYPE;
75:
76: l_tax_determine_date date;
77: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
78: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
79:
80: TYPE parameter_rec IS RECORD (
81: tax_id number,

Line 78: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

74: l_adj_for_adhoc_amt_code ZX_RATES_B.ADJ_FOR_ADHOC_AMT_CODE%TYPE;
75:
76: l_tax_determine_date date;
77: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
78: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
79:
80: TYPE parameter_rec IS RECORD (
81: tax_id number,
82: formula_code varchar(30),

Line 223: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).Taxable_Basis_Rule_Flag;

219:
220: l_tax_determine_date := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date;
221:
222: l_Taxable_Basis_Rule_Flag:=
223: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).Taxable_Basis_Rule_Flag;
224: l_def_formula:=
225: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).def_taxable_basis_formula;
226:
227: -- Do not re-determine tax_amt_included_flag if

Line 225: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).def_taxable_basis_formula;

221:
222: l_Taxable_Basis_Rule_Flag:=
223: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).Taxable_Basis_Rule_Flag;
224: l_def_formula:=
225: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).def_taxable_basis_formula;
226:
227: -- Do not re-determine tax_amt_included_flag if
228: -- bug 5391331: tax_amt_included_flag is overridden
229: -- bug 5391084: manual tax line

Line 290: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'P')

286: WHEN (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).recalc_required_flag <> 'Y' AND
287: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX') OR
288: (NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry, 'X') = 'TAX_AMOUNT') OR
289: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
290: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'P')
291: THEN
292:
293: -- RECALC_REQUIRED_FLAG will be populated by tax lines Determination
294: -- table handler when the user overrides one or more tax lines. (When the

Line 427: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R') OR

423: WHEN
424: (NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Freeze_Until_Overridden_Flag,'N') <> 'Y' OR
425: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).COPIED_FROM_OTHER_DOC_FLAG,'N') <> 'Y') OR
426: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
427: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R') OR
428: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX' AND
429: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag = 'Y' AND
430: -- bug fix 5525890
431: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry,'X') <> 'TAX_AMOUNT' )

Line 479: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

475: FETCH get_formula_code_from_rate_csr INTO l_formula_from_rate;
476: CLOSE get_formula_code_from_rate_csr;
477: */
478:
479: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
480: p_tax_rate_id => l_tax_rate_id,
481: p_tax_rate_rec => l_tax_rate_rec,
482: p_return_status => p_return_status,
483: p_error_buffer => p_error_buffer);

Line 515: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

511: FETCH get_formula_code_from_rate_csr INTO l_formula_from_rate;
512: CLOSE get_formula_code_from_rate_csr;
513: */
514:
515: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
516: p_tax_rate_id => l_tax_rate_id,
517: p_tax_rate_rec => l_tax_rate_rec,
518: p_return_status => p_return_status,
519: p_error_buffer => p_error_buffer);

Line 887: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

883: --
884: l_tax_rec := NULL;
885: l_compounding_tax_id := NULL;
886:
887: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
888: l_cpdg_tax_regime_code,
889: l_compounding_tax,
890: l_tax_determine_date,
891: l_tax_rec,

Line 1068: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'P' AND

1064:
1065: NULL;
1066:
1067: WHEN ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'APPLIED_FROM' AND
1068: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'P' AND
1069: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX'
1070: THEN
1071: -- Proration Scenarios:
1072: -- In the following cases, taxable basis is not calculated using taxable

Line 1195: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

1191: END IF;
1192: CLOSE getAdhocInfo;
1193: */
1194:
1195: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
1196: p_tax_rate_id => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id,
1197: p_tax_rate_rec => l_tax_rate_rec,
1198: p_return_status => p_return_status,
1199: p_error_buffer => p_error_buffer);

Line 1382: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1378: c_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE) IS
1379: SELECT inclusive_tax_flag
1380: FROM zx_party_tax_profile
1381: WHERE party_tax_profile_id = c_ptp_id;
1382: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1383:
1384: BEGIN
1385:
1386: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1428: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

1424: FETCH get_inclusive_flag_from_rate INTO l_inclusive_tax_flag;
1425: CLOSE get_inclusive_flag_from_rate;
1426: */
1427:
1428: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
1429: p_tax_rate_id => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1430: p_tax_line_index).tax_rate_id,
1431: p_tax_rate_rec => l_tax_rate_rec,
1432: p_return_status => p_return_status,

Line 1561: l_inclusive_tax_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

1557: END IF;
1558: ELSE
1559: -- Get Get tax inclusive flag from Tax
1560: --
1561: l_inclusive_tax_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1562: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1563: p_tax_line_index).tax_id).def_inclusive_tax_flag;
1564:
1565: IF l_inclusive_tax_flag IS NOT NULL THEN