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_RATE_DETM_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 80: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

76: l_ptp_id NUMBER;
77: l_reg_party_type VARCHAR2(80);
78: l_numeric_result zx_process_results.numeric_result%TYPE;
79:
80: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
81: l_exemption_rec ZX_TCM_GET_EXEMPT_PKG.exemption_rec_type;
82: l_exception_rec ZX_TCM_GET_EXCEPT_PKG.exception_rec_type;
83: l_allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE;
84: l_allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE;

Line 284: zx_tds_utilities_pkg.get_tax_rate_info

280: l_tax_status_code :=
281: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_codE;
282: l_tax_rate_code :=
283: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code;
284: zx_tds_utilities_pkg.get_tax_rate_info
285: ( l_tax_regime_code,
286: l_tax,
287: l_tax_jurisdiction_code,
288: l_tax_status_code,

Line 349: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag <> 'R')

345:
346: WHEN
347: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'ADJUSTED' OR
348: (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
349: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag <> 'R')
350: ) AND
351: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX'
352: THEN
353: -- In case when the tax line is copied from Applied From (applied_amt_handling_flag on

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

420: ('TAX_STATUS', 'TAX_RATE_CODE') -- AND --bug 5237144
421: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
422: ) OR
423: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
424: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R'
425: ) OR
426: -- Bug 5176149: need to populate tax rate id and tax rate % for matched invoice
427: ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'REFERENCE'
428: ) OR

Line 464: l_status_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(

460:
461: -- select the tax rate rule flag from tax status cache
462: -- get the hash value using tax regime code, tax, tax status code
463:
464: l_status_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(
465: l_tax,
466: l_tax_regime_code,
467: l_tax_status_code);
468:

Line 490: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).rule_based_rate_flag;

486: RETURN;
487: ELSE
488:
489: l_tax_rate_rule_flag :=
490: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).rule_based_rate_flag;
491: l_effective_from :=
492: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from;
493: l_effective_to :=
494: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to;

Line 492: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from;

488:
489: l_tax_rate_rule_flag :=
490: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).rule_based_rate_flag;
491: l_effective_from :=
492: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from;
493: l_effective_to :=
494: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to;
495:
496: END IF; -- l_status_index is NULL

Line 494: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to;

490: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).rule_based_rate_flag;
491: l_effective_from :=
492: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from;
493: l_effective_to :=
494: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to;
495:
496: END IF; -- l_status_index is NULL
497:
498: IF l_tax_rate_rule_flag = 'Y' THEN

Line 613: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN

609:
610: END IF; --l_tax_rate_rec.tax_jurisdiction_code IS NOT NULL
611:
612:
613: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN
614: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;
615: END IF;
616:
617: IF l_tax_rate_code IS NOT NULL THEN

Line 614: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;

610: END IF; --l_tax_rate_rec.tax_jurisdiction_code IS NOT NULL
611:
612:
613: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl.EXISTS(l_tax_rate_id) THEN
614: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_tbl(l_tax_rate_id) := l_tax_rate_rec;
615: END IF;
616:
617: IF l_tax_rate_code IS NOT NULL THEN
618:

Line 1179: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

1175: THEN
1176:
1177: l_exemption_rec := NULL;
1178:
1179: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1180: l_tax_id).tax_exmpt_source_tax IS NOT NULL
1181: THEN
1182: IF (g_level_statement >= g_current_runtime_level ) THEN
1183: FND_LOG.STRING(g_level_statement,

Line 1186: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_exmpt_source_tax);

1182: IF (g_level_statement >= g_current_runtime_level ) THEN
1183: FND_LOG.STRING(g_level_statement,
1184: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1185: 'Current tax has a source tax: ' ||
1186: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_exmpt_source_tax);
1187:
1188: END IF;
1189:
1190: FOR i IN REVERSE NVL(l_exempt_info_tbl.FIRST, 0)..NVL(l_exempt_info_tbl.LAST, -1) LOOP

Line 1194: l_exempt_info_tbl(i).tax = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(

1190: FOR i IN REVERSE NVL(l_exempt_info_tbl.FIRST, 0)..NVL(l_exempt_info_tbl.LAST, -1) LOOP
1191:
1192:
1193: IF l_exempt_info_tbl(i).tax_regime_code = l_tax_regime_code AND
1194: l_exempt_info_tbl(i).tax = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1195: l_tax_id).tax_exmpt_source_tax
1196: THEN
1197:
1198: l_exemption_rec.exemption_id := l_exempt_info_tbl(i).exemption_id;

Line 1380: l_status_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(

1376: THEN
1377: -- check whether the tax rate is ad-hoc
1378:
1379: /* commented out for bug 3420310, the following check should have been done on the UI
1380: l_status_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(
1381: l_tax,
1382: l_tax_regime_code,
1383: l_tax_status_code);
1384:

Line 1405: -- ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;

1401: ELSE
1402: -- bug fix 3420310
1403: -- Allow_Adhoc_Tax_Rate_Flag moved to zx_rates_b table, g_tax_status_info_tbl changed accordingly
1404: -- l_adhoc_tax_rate_flg :=
1405: -- ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;
1406: l_adhoc_tax_rate_flg :=
1407: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;
1408:
1409: END IF; -- l_status_index is NULL

Line 1407: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;

1403: -- Allow_Adhoc_Tax_Rate_Flag moved to zx_rates_b table, g_tax_status_info_tbl changed accordingly
1404: -- l_adhoc_tax_rate_flg :=
1405: -- ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;
1406: l_adhoc_tax_rate_flg :=
1407: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;
1408:
1409: END IF; -- l_status_index is NULL
1410:
1411: -- If the tax code is not adhoc then the user cannot specify tax rate on

Line 1439: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from

1435: -- The tax was prorated based on reference document; validate that
1436: -- the tax rate is valid for the transaction date.
1437:
1438: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date >=
1439: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from
1440: and ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date <=
1441: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to
1442: THEN
1443: NULL;

Line 1441: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to

1437:
1438: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date >=
1439: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_from
1440: and ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date <=
1441: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).effective_to
1442: THEN
1443: NULL;
1444:
1445: else

Line 1574: l_offset_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;

1570: ORDER BY subscription_level_code; -- Bug#5395227
1571: */
1572:
1573: l_tax_rate_id NUMBER;
1574: l_offset_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1575: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1576: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1577: BEGIN
1578: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1575: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;

1571: */
1572:
1573: l_tax_rate_id NUMBER;
1574: l_offset_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1575: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1576: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1577: BEGIN
1578: IF (g_level_procedure >= g_current_runtime_level ) THEN
1579: FND_LOG.STRING(g_level_procedure,

Line 1576: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

1572:
1573: l_tax_rate_id NUMBER;
1574: l_offset_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1575: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1576: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1577: BEGIN
1578: IF (g_level_procedure >= g_current_runtime_level ) THEN
1579: FND_LOG.STRING(g_level_procedure,
1580: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.BEGIN',

Line 1586: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(

1582: END IF;
1583:
1584: x_return_status := FND_API.G_RET_STS_SUCCESS;
1585:
1586: ZX_TDS_UTILITIES_PKG.get_tax_cache_info(
1587: p_tax_regime_code,
1588: p_tax,
1589: p_tax_determine_date,
1590: l_offset_tax_rec,

Line 1598: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info');

1594: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1595: IF (g_level_error >= g_current_runtime_level ) THEN
1596: FND_LOG.STRING(g_level_error,
1597: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1598: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1599: FND_LOG.STRING(g_level_error,
1600: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1601: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1602: END IF;

Line 1606: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

1602: END IF;
1603: RETURN;
1604: END IF;
1605:
1606: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
1607: p_tax,
1608: p_tax_regime_code,
1609: p_tax_status_code,
1610: p_tax_determine_date,

Line 1619: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');

1615: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1616: IF (g_level_error >= g_current_runtime_level ) THEN
1617: FND_LOG.STRING(g_level_error,
1618: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1619: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
1620: FND_LOG.STRING(g_level_error,
1621: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1622: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1623: END IF;

Line 1647: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(

1643: END IF;
1644: CLOSE get_offset_info_csr;
1645: */
1646:
1647: ZX_TDS_UTILITIES_PKG.get_tax_rate_info(
1648: p_tax_regime_code,
1649: p_tax,
1650: p_tax_jurisdiction_code,
1651: p_tax_status_code,

Line 1666: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info');

1662: ELSE
1663: IF (g_level_error >= g_current_runtime_level ) THEN
1664: FND_LOG.STRING(g_level_error,
1665: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1666: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
1667: FND_LOG.STRING(g_level_error,
1668: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1669: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1670: END IF;