eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 73: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;

69: l_enforce_compounding_flag ZX_FORMULA_DETAILS.ENFORCE_COMPOUNDING_FLAG%TYPE;
70: l_allow_adhoc_tax_rate_flag VARCHAR2(1);
71: l_adj_for_adhoc_amt_code ZX_RATES_B.ADJ_FOR_ADHOC_AMT_CODE%TYPE;
72: l_tax_determine_date DATE;
73: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
74: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
75:
76: TYPE parameter_rec IS RECORD (
77: tax_id NUMBER,

Line 74: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;

70: l_allow_adhoc_tax_rate_flag VARCHAR2(1);
71: l_adj_for_adhoc_amt_code ZX_RATES_B.ADJ_FOR_ADHOC_AMT_CODE%TYPE;
72: l_tax_determine_date DATE;
73: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
74: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
75:
76: TYPE parameter_rec IS RECORD (
77: tax_id NUMBER,
78: formula_code VARCHAR(30),

Line 227: l_taxable_basis_rule_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).Taxable_Basis_Rule_Flag;

223: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id;
224: l_tax_rate_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id;
225: l_tax_date := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date;
226: l_tax_determine_date := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date;
227: l_taxable_basis_rule_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).Taxable_Basis_Rule_Flag;
228: l_def_formula := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).def_taxable_basis_formula;
229:
230: -- Do not re-determine tax_amt_included_flag if
231: -- bug 5391331: tax_amt_included_flag is overridden

Line 228: l_def_formula := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).def_taxable_basis_formula;

224: l_tax_rate_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id;
225: l_tax_date := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date;
226: l_tax_determine_date := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date;
227: l_taxable_basis_rule_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).Taxable_Basis_Rule_Flag;
228: l_def_formula := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).def_taxable_basis_formula;
229:
230: -- Do not re-determine tax_amt_included_flag if
231: -- bug 5391331: tax_amt_included_flag is overridden
232: -- bug 5391084: manual tax line

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

291: OR
292: (NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry, 'X') = 'TAX_AMOUNT')
293: OR
294: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
295: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'P')
296: THEN
297:
298: IF (g_level_statement >= g_current_runtime_level ) THEN
299: FND_LOG.STRING(g_level_statement,

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

474: WHEN (NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Freeze_Until_Overridden_Flag,'N') <> 'Y' OR
475: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).COPIED_FROM_OTHER_DOC_FLAG,'N') <> 'Y')
476: OR
477: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
478: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R')
479: OR
480: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX' AND
481: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag = 'Y' AND
482: -- Bug fix 5525890

Line 534: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

530: --OPEN get_formula_code_from_rate_csr(l_tax_rate_id);
531: --FETCH get_formula_code_from_rate_csr INTO l_formula_from_rate;
532: --CLOSE get_formula_code_from_rate_csr;
533:
534: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
535: p_tax_rate_id => l_tax_rate_id,
536: p_tax_rate_rec => l_tax_rate_rec,
537: p_return_status => p_return_status,
538: p_error_buffer => p_error_buffer);

Line 572: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

568: --OPEN get_formula_code_from_rate_csr(l_tax_rate_id);
569: --FETCH get_formula_code_from_rate_csr INTO l_formula_from_rate;
570: --CLOSE get_formula_code_from_rate_csr;
571:
572: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
573: p_tax_rate_id => l_tax_rate_id,
574: p_tax_rate_rec => l_tax_rate_rec,
575: p_return_status => p_return_status,
576: p_error_buffer => p_error_buffer);

Line 921: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

917: --
918: l_tax_rec := NULL;
919: l_compounding_tax_id := NULL;
920:
921: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
922: l_cpdg_tax_regime_code,
923: l_compounding_tax,
924: l_tax_determine_date,
925: l_tax_rec,

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

1231: NULL;
1232:
1233: -- 6
1234: WHEN ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'APPLIED_FROM' AND
1235: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'P' AND
1236: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX'
1237: THEN
1238: -- Proration Scenarios:
1239: -- In the following cases, taxable basis is not calculated using taxable

Line 1400: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

1396: -- RETURN;
1397: --END IF;
1398: --CLOSE getAdhocInfo;
1399:
1400: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
1401: p_tax_rate_id => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_id,
1402: p_tax_rate_rec => l_tax_rate_rec,
1403: p_return_status => p_return_status,
1404: p_error_buffer => p_error_buffer);

Line 1610: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1606: SELECT inclusive_tax_flag
1607: FROM zx_party_tax_profile
1608: WHERE party_tax_profile_id = c_ptp_id;
1609:
1610: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1611:
1612: BEGIN
1613:
1614: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1636: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

1632: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1633: -- p_tax_line_index).tax_amt_included_flag := 'Y';
1634: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_structure_index) = 200
1635: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_structure_index) = 'EXPENSE REPORTS' THEN
1636: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
1637: p_tax_rate_id => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1638: p_tax_line_index).tax_rate_id,
1639: p_tax_rate_rec => l_tax_rate_rec,
1640: p_return_status => p_return_status,

Line 1661: IF NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

1657: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.populate_inclusive_tax_flag',
1658: 'Get Inclusive_tax_flag from Tax Rate: ' || l_inclusive_tax_flag);
1659: END IF;
1660: ELSE
1661: IF NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1662: p_tax_line_index).tax_id).def_inclusive_tax_flag, 'X') <> 'N' THEN
1663: l_inclusive_tax_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1664: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1665: p_tax_line_index).tax_id).def_inclusive_tax_flag;

Line 1663: l_inclusive_tax_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

1659: END IF;
1660: ELSE
1661: IF NVL(ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1662: p_tax_line_index).tax_id).def_inclusive_tax_flag, 'X') <> 'N' THEN
1663: l_inclusive_tax_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1664: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1665: p_tax_line_index).tax_id).def_inclusive_tax_flag;
1666: ELSE
1667: l_inclusive_tax_flag := 'Y';

Line 1715: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (

1711: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_id);
1712: -- FETCH get_inclusive_flag_from_rate INTO l_inclusive_tax_flag;
1713: -- CLOSE get_inclusive_flag_from_rate;
1714:
1715: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
1716: p_tax_rate_id => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1717: p_tax_line_index).tax_rate_id,
1718: p_tax_rate_rec => l_tax_rate_rec,
1719: p_return_status => p_return_status,

Line 1860: l_inclusive_tax_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

1856: END IF;
1857: ELSE
1858: -- Get Get tax inclusive flag from Tax
1859: --
1860: l_inclusive_tax_flag := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1861: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1862: p_tax_line_index).tax_id).def_inclusive_tax_flag;
1863:
1864: IF l_inclusive_tax_flag IS NOT NULL THEN