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_STATUS_B

Line 799: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;

795: l_tax ZX_TAXES_B.tax%TYPE;
796: l_tax_id NUMBER;
797: l_tax_apportionment_line_num NUMBER;
798: l_index NUMBER;
799: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
800: l_rec_nrec_tax_dist_number NUMBER;
801:
802: CURSOR get_tax_recovery_info_cur(
803: c_tax_id zx_taxes_b.tax_id%TYPE) IS

Line 1568: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;

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 --
1571: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1572: l_tax_rate_code ZX_RATES_B.tax_rate_code%TYPE;

Line 1569: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;

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 --
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 --

Line 1584: -- c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,

1580: l_rec_rate_adhoc_flag VARCHAR2(1);
1581:
1582: -- Commented for Bug#5395227
1583: -- CURSOR get_rec_rule_code_csr(
1584: -- c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1585: -- c_tax ZX_STATUS_B.tax%TYPE,
1586: -- c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1587: -- c_tax_rate_code VARCHAR2,
1588: -- c_tax_date DATE) IS

Line 1585: -- c_tax ZX_STATUS_B.tax%TYPE,

1581:
1582: -- Commented for Bug#5395227
1583: -- CURSOR get_rec_rule_code_csr(
1584: -- c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1585: -- c_tax ZX_STATUS_B.tax%TYPE,
1586: -- c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1587: -- c_tax_rate_code VARCHAR2,
1588: -- c_tax_date DATE) IS
1589: -- SELECT recovery_rule_code

Line 1586: -- c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,

1582: -- Commented for Bug#5395227
1583: -- CURSOR get_rec_rule_code_csr(
1584: -- c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,
1585: -- c_tax ZX_STATUS_B.tax%TYPE,
1586: -- c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,
1587: -- c_tax_rate_code VARCHAR2,
1588: -- c_tax_date DATE) IS
1589: -- SELECT recovery_rule_code
1590: -- FROM ZX_SCO_RATES_B_V

Line 1604: -- c_tax_status_code ZX_STATUS_B.tax_status_code%TYPE,

1600: -- ORDER BY subscription_level_code;
1601:
1602: -- Commented for Bug#5395227 - use get_rec_info_csr
1603: -- CURSOR get_def_rec_rate_from_rate_csr(
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,

Line 1605: -- c_tax ZX_STATUS_B.tax%TYPE,

1601:
1602: -- Commented for Bug#5395227 - use get_rec_info_csr
1603: -- CURSOR get_def_rec_rate_from_rate_csr(
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

Line 1606: -- c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,

1602: -- Commented for Bug#5395227 - use get_rec_info_csr
1603: -- CURSOR get_def_rec_rate_from_rate_csr(
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

Line 1636: c_tax ZX_STATUS_B.tax%TYPE,

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,
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,

Line 1637: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,

1633: WHERE tax_rate_id = c_tax_rate_id;
1634:
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

Line 1658: c_tax ZX_STATUS_B.tax%TYPE,

1654: AND (effective_to >= c_tax_date OR effective_to IS NULL)
1655: ORDER BY tax_class NULLS LAST, subscription_level_code;
1656:
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

Line 1659: c_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE,

1655: ORDER BY tax_class NULLS LAST, subscription_level_code;
1656:
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,

Line 5646: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;

5642:
5643: -- Added these variables for Bug#14038095 --
5644: l_tax ZX_TAXES_B.tax%TYPE;
5645: l_tax_id NUMBER;
5646: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
5647:
5648: BEGIN
5649:
5650: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;