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 1566: l_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE;

1562: l_rec_rate NUMBER;
1563: l_total_rec_rate NUMBER;
1564: l_tax_determine_date DATE;
1565: l_tax_date DATE;
1566: l_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE;
1567: l_tax ZX_TAXES_B.tax%TYPE;
1568: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1569: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1570: l_content_owner_id ZX_RATES_B.content_owner_id%TYPE; -- Added for Bug#14038095 --

Line 1570: l_content_owner_id ZX_RATES_B.content_owner_id%TYPE; -- Added for Bug#14038095 --

1566: l_rec_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE;
1567: l_tax ZX_TAXES_B.tax%TYPE;
1568: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1569: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1570: l_content_owner_id ZX_RATES_B.content_owner_id%TYPE; -- Added for Bug#14038095 --
1571: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1572: l_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE;
1573: l_def_rec_rate_code ZX_RATES_B.tax_rate_code%TYPE; -- Added for Bug#5395277 --
1574: l_tax_class ZX_RATES_B.tax_class%TYPE;

Line 1571: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;

1567: l_tax ZX_TAXES_B.tax%TYPE;
1568: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1569: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1570: l_content_owner_id ZX_RATES_B.content_owner_id%TYPE; -- Added for Bug#14038095 --
1571: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1572: l_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE;
1573: l_def_rec_rate_code ZX_RATES_B.tax_rate_code%TYPE; -- Added for Bug#5395277 --
1574: l_tax_class ZX_RATES_B.tax_class%TYPE;
1575: l_acct_source_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE;

Line 1572: l_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE;

1568: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
1569: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1570: l_content_owner_id ZX_RATES_B.content_owner_id%TYPE; -- Added for Bug#14038095 --
1571: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1572: l_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE;
1573: l_def_rec_rate_code ZX_RATES_B.tax_rate_code%TYPE; -- Added for Bug#5395277 --
1574: l_tax_class ZX_RATES_B.tax_class%TYPE;
1575: l_acct_source_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE;
1576: l_def_rec_settlement_code ZX_RATES_B.def_rec_settlement_option_code%TYPE;

Line 1573: l_def_rec_rate_code ZX_RATES_B.tax_rate_code%TYPE; -- Added for Bug#5395277 --

1569: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
1570: l_content_owner_id ZX_RATES_B.content_owner_id%TYPE; -- Added for Bug#14038095 --
1571: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1572: l_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE;
1573: l_def_rec_rate_code ZX_RATES_B.tax_rate_code%TYPE; -- Added for Bug#5395277 --
1574: l_tax_class ZX_RATES_B.tax_class%TYPE;
1575: l_acct_source_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE;
1576: l_def_rec_settlement_code ZX_RATES_B.def_rec_settlement_option_code%TYPE;
1577: l_def_rec_type_code ZX_RATES_B.recovery_type_code%TYPE;

Line 1574: l_tax_class ZX_RATES_B.tax_class%TYPE;

1570: l_content_owner_id ZX_RATES_B.content_owner_id%TYPE; -- Added for Bug#14038095 --
1571: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1572: l_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE;
1573: l_def_rec_rate_code ZX_RATES_B.tax_rate_code%TYPE; -- Added for Bug#5395277 --
1574: l_tax_class ZX_RATES_B.tax_class%TYPE;
1575: l_acct_source_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE;
1576: l_def_rec_settlement_code ZX_RATES_B.def_rec_settlement_option_code%TYPE;
1577: l_def_rec_type_code ZX_RATES_B.recovery_type_code%TYPE;
1578: l_zx_result_rec ZX_PROCESS_RESULTS%ROWTYPE;

Line 1575: l_acct_source_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE;

1571: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1572: l_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE;
1573: l_def_rec_rate_code ZX_RATES_B.tax_rate_code%TYPE; -- Added for Bug#5395277 --
1574: l_tax_class ZX_RATES_B.tax_class%TYPE;
1575: l_acct_source_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE;
1576: l_def_rec_settlement_code ZX_RATES_B.def_rec_settlement_option_code%TYPE;
1577: l_def_rec_type_code ZX_RATES_B.recovery_type_code%TYPE;
1578: l_zx_result_rec ZX_PROCESS_RESULTS%ROWTYPE;
1579: l_tbl_index BINARY_INTEGER;

Line 1576: l_def_rec_settlement_code ZX_RATES_B.def_rec_settlement_option_code%TYPE;

1572: l_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE;
1573: l_def_rec_rate_code ZX_RATES_B.tax_rate_code%TYPE; -- Added for Bug#5395277 --
1574: l_tax_class ZX_RATES_B.tax_class%TYPE;
1575: l_acct_source_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE;
1576: l_def_rec_settlement_code ZX_RATES_B.def_rec_settlement_option_code%TYPE;
1577: l_def_rec_type_code ZX_RATES_B.recovery_type_code%TYPE;
1578: l_zx_result_rec ZX_PROCESS_RESULTS%ROWTYPE;
1579: l_tbl_index BINARY_INTEGER;
1580: l_rec_rate_adhoc_flag VARCHAR2(1);

Line 1577: l_def_rec_type_code ZX_RATES_B.recovery_type_code%TYPE;

1573: l_def_rec_rate_code ZX_RATES_B.tax_rate_code%TYPE; -- Added for Bug#5395277 --
1574: l_tax_class ZX_RATES_B.tax_class%TYPE;
1575: l_acct_source_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE;
1576: l_def_rec_settlement_code ZX_RATES_B.def_rec_settlement_option_code%TYPE;
1577: l_def_rec_type_code ZX_RATES_B.recovery_type_code%TYPE;
1578: l_zx_result_rec ZX_PROCESS_RESULTS%ROWTYPE;
1579: l_tbl_index BINARY_INTEGER;
1580: l_rec_rate_adhoc_flag VARCHAR2(1);
1581:

Line 1608: -- c_recovery_type_code zx_rates_b.default_rec_type_code%TYPE,

1604: -- c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1605: -- c_tax ZX_STATUS_B.tax%TYPE,
1606: -- c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1607: -- c_tax_date DATE,
1608: -- c_recovery_type_code zx_rates_b.default_rec_type_code%TYPE,
1609: -- c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1610: -- SELECT default_rec_rate_code
1611: -- FROM ZX_SCO_RATES_B_V rate
1612: -- WHERE rate.effective_from <= c_tax_date

Line 1609: -- c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS

1605: -- c_tax ZX_STATUS_B.tax%TYPE,
1606: -- c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1607: -- c_tax_date DATE,
1608: -- c_recovery_type_code zx_rates_b.default_rec_type_code%TYPE,
1609: -- c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
1610: -- SELECT default_rec_rate_code
1611: -- FROM ZX_SCO_RATES_B_V rate
1612: -- WHERE rate.effective_from <= c_tax_date
1613: -- AND (rate.effective_to >= c_tax_date OR rate.effective_to IS NULL)

Line 1627: c_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE) IS

1623:
1624: -- Bug#5395227- replace above cursor
1625: --
1626: CURSOR get_rec_info_csr(
1627: c_tax_rate_id ZX_RATES_B.tax_rate_id%TYPE) IS
1628: SELECT recovery_rule_code,
1629: default_rec_rate_code,
1630: def_rec_settlement_option_code,
1631: default_rec_type_code

Line 1632: FROM ZX_RATES_B

1628: SELECT recovery_rule_code,
1629: default_rec_rate_code,
1630: def_rec_settlement_option_code,
1631: default_rec_type_code
1632: FROM ZX_RATES_B
1633: WHERE tax_rate_id = c_tax_rate_id;
1634:
1635: CURSOR get_rec_rate_csr(
1636: c_tax ZX_STATUS_B.tax%TYPE,

Line 1639: c_recovery_type_code ZX_RATES_B.recovery_type_code%TYPE,

1635: CURSOR get_rec_rate_csr(
1636: c_tax ZX_STATUS_B.tax%TYPE,
1637: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1638: c_tax_date DATE,
1639: c_recovery_type_code ZX_RATES_B.recovery_type_code%TYPE,
1640: c_tax_class ZX_RATES_B.tax_class%TYPE,
1641: c_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE) IS
1642: SELECT tax_rate_id,
1643: percentage_rate,

Line 1640: c_tax_class ZX_RATES_B.tax_class%TYPE,

1636: c_tax ZX_STATUS_B.tax%TYPE,
1637: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1638: c_tax_date DATE,
1639: c_recovery_type_code ZX_RATES_B.recovery_type_code%TYPE,
1640: c_tax_class ZX_RATES_B.tax_class%TYPE,
1641: c_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE) IS
1642: SELECT tax_rate_id,
1643: percentage_rate,
1644: allow_adhoc_tax_rate_flag

Line 1641: c_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE) IS

1637: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1638: c_tax_date DATE,
1639: c_recovery_type_code ZX_RATES_B.recovery_type_code%TYPE,
1640: c_tax_class ZX_RATES_B.tax_class%TYPE,
1641: c_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE) IS
1642: SELECT tax_rate_id,
1643: percentage_rate,
1644: allow_adhoc_tax_rate_flag
1645: FROM ZX_SCO_RATES_B_V

Line 1661: c_tax_class ZX_RATES_B.tax_class%TYPE,

1657: CURSOR get_def_rec_rate_from_type_csr(
1658: c_tax ZX_STATUS_B.tax%TYPE,
1659: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1660: c_tax_date DATE,
1661: c_tax_class ZX_RATES_B.tax_class%TYPE,
1662: c_recovery_type_code ZX_RATES_B.recovery_type_code%TYPE) IS
1663: SELECT rate.tax_rate_id,
1664: rate.tax_rate_code,
1665: rate.percentage_rate,

Line 1662: c_recovery_type_code ZX_RATES_B.recovery_type_code%TYPE) IS

1658: c_tax ZX_STATUS_B.tax%TYPE,
1659: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1660: c_tax_date DATE,
1661: c_tax_class ZX_RATES_B.tax_class%TYPE,
1662: c_recovery_type_code ZX_RATES_B.recovery_type_code%TYPE) IS
1663: SELECT rate.tax_rate_id,
1664: rate.tax_rate_code,
1665: rate.percentage_rate,
1666: rate.allow_adhoc_tax_rate_flag

Line 1712: c_tax ZX_RATES_B.tax%TYPE,

1708: AND internal_organization_id = c_internal_org_id;
1709:
1710: -- Added for Bug#14038095 --
1711: CURSOR get_adhoc_rec_rate_id_csr(
1712: c_tax ZX_RATES_B.tax%TYPE,
1713: c_tax_regime_code ZX_RATES_B.tax_regime_code%TYPE,
1714: c_content_owner_id ZX_RATES_B.content_owner_id%TYPE,
1715: c_tax_class ZX_RATES_B.tax_class%TYPE) IS
1716: SELECT tax_rate_id

Line 1713: c_tax_regime_code ZX_RATES_B.tax_regime_code%TYPE,

1709:
1710: -- Added for Bug#14038095 --
1711: CURSOR get_adhoc_rec_rate_id_csr(
1712: c_tax ZX_RATES_B.tax%TYPE,
1713: c_tax_regime_code ZX_RATES_B.tax_regime_code%TYPE,
1714: c_content_owner_id ZX_RATES_B.content_owner_id%TYPE,
1715: c_tax_class ZX_RATES_B.tax_class%TYPE) IS
1716: SELECT tax_rate_id
1717: FROM zx_rates_b

Line 1714: c_content_owner_id ZX_RATES_B.content_owner_id%TYPE,

1710: -- Added for Bug#14038095 --
1711: CURSOR get_adhoc_rec_rate_id_csr(
1712: c_tax ZX_RATES_B.tax%TYPE,
1713: c_tax_regime_code ZX_RATES_B.tax_regime_code%TYPE,
1714: c_content_owner_id ZX_RATES_B.content_owner_id%TYPE,
1715: c_tax_class ZX_RATES_B.tax_class%TYPE) IS
1716: SELECT tax_rate_id
1717: FROM zx_rates_b
1718: WHERE tax = c_tax

Line 1715: c_tax_class ZX_RATES_B.tax_class%TYPE) IS

1711: CURSOR get_adhoc_rec_rate_id_csr(
1712: c_tax ZX_RATES_B.tax%TYPE,
1713: c_tax_regime_code ZX_RATES_B.tax_regime_code%TYPE,
1714: c_content_owner_id ZX_RATES_B.content_owner_id%TYPE,
1715: c_tax_class ZX_RATES_B.tax_class%TYPE) IS
1716: SELECT tax_rate_id
1717: FROM zx_rates_b
1718: WHERE tax = c_tax
1719: AND tax_regime_code = c_tax_regime_code

Line 1717: FROM zx_rates_b

1713: c_tax_regime_code ZX_RATES_B.tax_regime_code%TYPE,
1714: c_content_owner_id ZX_RATES_B.content_owner_id%TYPE,
1715: c_tax_class ZX_RATES_B.tax_class%TYPE) IS
1716: SELECT tax_rate_id
1717: FROM zx_rates_b
1718: WHERE tax = c_tax
1719: AND tax_regime_code = c_tax_regime_code
1720: AND content_owner_id IN (c_content_owner_id,-99)
1721: AND tax_rate_code = 'AD_HOC_RECOVERY'

Line 2029: -- recovery rate code from zx_rates_b

2025:
2026: IF p_rec_nrec_dist_tbl(i).rec_rate_det_rule_flag = 'Y' THEN
2027:
2028: -- Bug#5395227- get recovery rule code and default
2029: -- recovery rate code from zx_rates_b
2030: --
2031: OPEN get_rec_info_csr(l_tax_rate_id);
2032: FETCH get_rec_info_csr INTO l_rec_rule_code,
2033: l_def_rec_rate_code,