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_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_RATES_B

Line 1460: l_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE;

1456: p_error_buffer OUT NOCOPY VARCHAR2) IS
1457:
1458: l_rec_rule_code VARCHAR2(30);
1459:
1460: l_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE;
1461:
1462: l_rec_type_code VARCHAR2(30);
1463: l_rec_rate_id NUMBER;
1464: l_tax_rate_id NUMBER;

Line 1475: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;

1471: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1472: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1473: l_rec_rate NUMBER;
1474: l_total_rec_rate NUMBER;
1475: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;
1476: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
1477: l_zx_result_rec zx_process_results%ROWTYPE;
1478: l_tbl_index BINARY_INTEGER;
1479: l_rec_rate_adhoc_flag VARCHAR2(1);

Line 1476: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;

1472: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1473: l_rec_rate NUMBER;
1474: l_total_rec_rate NUMBER;
1475: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;
1476: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
1477: l_zx_result_rec zx_process_results%ROWTYPE;
1478: l_tbl_index BINARY_INTEGER;
1479: l_rec_rate_adhoc_flag VARCHAR2(1);
1480: l_def_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE; -- Bug5395277

Line 1480: l_def_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE; -- Bug5395277

1476: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
1477: l_zx_result_rec zx_process_results%ROWTYPE;
1478: l_tbl_index BINARY_INTEGER;
1479: l_rec_rate_adhoc_flag VARCHAR2(1);
1480: l_def_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE; -- Bug5395277
1481: l_tax_class ZX_RATES_B.tax_class%TYPE;
1482: l_acct_source_tax_rate_id zx_rates_b.tax_rate_id%TYPE;
1483: l_def_rec_settlement_code zx_rates_b.def_rec_settlement_option_code%TYPE;
1484:

Line 1481: l_tax_class ZX_RATES_B.tax_class%TYPE;

1477: l_zx_result_rec zx_process_results%ROWTYPE;
1478: l_tbl_index BINARY_INTEGER;
1479: l_rec_rate_adhoc_flag VARCHAR2(1);
1480: l_def_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE; -- Bug5395277
1481: l_tax_class ZX_RATES_B.tax_class%TYPE;
1482: l_acct_source_tax_rate_id zx_rates_b.tax_rate_id%TYPE;
1483: l_def_rec_settlement_code zx_rates_b.def_rec_settlement_option_code%TYPE;
1484:
1485: /*** Bug#5395227

Line 1482: l_acct_source_tax_rate_id zx_rates_b.tax_rate_id%TYPE;

1478: l_tbl_index BINARY_INTEGER;
1479: l_rec_rate_adhoc_flag VARCHAR2(1);
1480: l_def_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE; -- Bug5395277
1481: l_tax_class ZX_RATES_B.tax_class%TYPE;
1482: l_acct_source_tax_rate_id zx_rates_b.tax_rate_id%TYPE;
1483: l_def_rec_settlement_code zx_rates_b.def_rec_settlement_option_code%TYPE;
1484:
1485: /*** Bug#5395227
1486: CURSOR get_rec_rule_code_csr(

Line 1483: l_def_rec_settlement_code zx_rates_b.def_rec_settlement_option_code%TYPE;

1479: l_rec_rate_adhoc_flag VARCHAR2(1);
1480: l_def_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE; -- Bug5395277
1481: l_tax_class ZX_RATES_B.tax_class%TYPE;
1482: l_acct_source_tax_rate_id zx_rates_b.tax_rate_id%TYPE;
1483: l_def_rec_settlement_code zx_rates_b.def_rec_settlement_option_code%TYPE;
1484:
1485: /*** Bug#5395227
1486: CURSOR get_rec_rule_code_csr(
1487: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,

Line 1509: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

1505:
1506: -- Bug#5395227- replace above cursor
1507: --
1508: CURSOR get_rec_info_csr(
1509: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
1510:
1511: SELECT recovery_rule_code,
1512: default_rec_rate_code,
1513: def_rec_settlement_option_code

Line 1514: FROM ZX_RATES_B

1510:
1511: SELECT recovery_rule_code,
1512: default_rec_rate_code,
1513: def_rec_settlement_option_code
1514: FROM ZX_RATES_B
1515: WHERE tax_rate_id = c_tax_rate_id;
1516:
1517:
1518: CURSOR get_rec_rate_csr(

Line 1522: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,

1518: CURSOR get_rec_rate_csr(
1519: c_tax ZX_STATUS_B.tax%TYPE,
1520: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1521: c_tax_date DATE,
1522: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1523: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE,
1524: c_tax_class zx_rates_b.tax_class%TYPE,
1525: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1526: SELECT tax_rate_id,

Line 1523: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE,

1519: c_tax ZX_STATUS_B.tax%TYPE,
1520: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1521: c_tax_date DATE,
1522: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1523: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE,
1524: c_tax_class zx_rates_b.tax_class%TYPE,
1525: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1526: SELECT tax_rate_id,
1527: percentage_rate,

Line 1524: c_tax_class zx_rates_b.tax_class%TYPE,

1520: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1521: c_tax_date DATE,
1522: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1523: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE,
1524: c_tax_class zx_rates_b.tax_class%TYPE,
1525: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1526: SELECT tax_rate_id,
1527: percentage_rate,
1528: allow_adhoc_tax_rate_flag

Line 1525: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS

1521: c_tax_date DATE,
1522: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1523: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE,
1524: c_tax_class zx_rates_b.tax_class%TYPE,
1525: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1526: SELECT tax_rate_id,
1527: percentage_rate,
1528: allow_adhoc_tax_rate_flag
1529: FROM ZX_SCO_RATES_B_V

Line 1547: c_tax_class zx_rates_b.tax_class%TYPE,

1543: CURSOR get_def_rec_rate_from_type_csr(
1544: c_tax ZX_STATUS_B.tax%TYPE,
1545: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1546: c_tax_date DATE,
1547: c_tax_class zx_rates_b.tax_class%TYPE,
1548: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE) IS
1549: SELECT rate.tax_rate_id,
1550: rate.tax_rate_code,
1551: rate.percentage_rate,

Line 1548: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE) IS

1544: c_tax ZX_STATUS_B.tax%TYPE,
1545: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1546: c_tax_date DATE,
1547: c_tax_class zx_rates_b.tax_class%TYPE,
1548: c_recovery_type_code zx_rates_b.recovery_type_code%TYPE) IS
1549: SELECT rate.tax_rate_id,
1550: rate.tax_rate_code,
1551: rate.percentage_rate,
1552: rate.allow_adhoc_tax_rate_flag

Line 1576: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,

1572: c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1573: c_tax ZX_STATUS_B.tax%TYPE,
1574: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1575: c_tax_date DATE,
1576: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1577: c_recovery_type_code zx_rates_b.default_rec_type_code%TYPE,
1578: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1579: SELECT default_rec_rate_code
1580: FROM ZX_SCO_RATES_B_V rate

Line 1577: c_recovery_type_code zx_rates_b.default_rec_type_code%TYPE,

1573: c_tax ZX_STATUS_B.tax%TYPE,
1574: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1575: c_tax_date DATE,
1576: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1577: c_recovery_type_code zx_rates_b.default_rec_type_code%TYPE,
1578: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1579: SELECT default_rec_rate_code
1580: FROM ZX_SCO_RATES_B_V rate
1581: WHERE rate.effective_from <= c_tax_date

Line 1578: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS

1574: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1575: c_tax_date DATE,
1576: -- c_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
1577: c_recovery_type_code zx_rates_b.default_rec_type_code%TYPE,
1578: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1579: SELECT default_rec_rate_code
1580: FROM ZX_SCO_RATES_B_V rate
1581: WHERE rate.effective_from <= c_tax_date
1582: AND (rate.effective_to >= c_tax_date OR rate.effective_to IS NULL)

Line 1849: -- recovery rate code from zx_rates_b

1845: ELSE
1846: IF p_rec_nrec_dist_tbl(i).rec_rate_det_rule_flag = 'Y' THEN
1847:
1848: -- Bug#5395227- get recovery rule code and default
1849: -- recovery rate code from zx_rates_b
1850: --
1851: OPEN get_rec_info_csr(l_tax_rate_id);
1852: FETCH get_rec_info_csr INTO l_rec_rule_code,
1853: l_def_rec_rate_code,