DBA Data[Home] [Help]

APPS.ZX_TDS_RATE_DETM_PKG dependencies on ZX_STATUS_B

Line 18: p_tax_status_code IN zx_status_b.tax_status_code%TYPE,

14: PROCEDURE validate_offset_tax (
15: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
16: p_tax IN zx_taxes_b.tax%TYPE,
17: p_tax_determine_date IN DATE,
18: p_tax_status_code IN zx_status_b.tax_status_code%TYPE,
19: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
20: p_tax_class IN zx_rates_b.tax_class%TYPE,
21: p_tax_rate_code IN zx_rates_b.tax_rate_code%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2,

Line 51: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;

47: l_tax_id NUMBER;
48: l_def_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
49: l_Tax_Rate_Rule_Flag varchar2(1);
50: l_tax ZX_TAXES_B.tax%TYPE;
51: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
52: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
53: l_tax_rate NUMBER;
54: l_tax_rate_id INTEGER;
55: l_def_tax_rate_id INTEGER;

Line 52: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;

48: l_def_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
49: l_Tax_Rate_Rule_Flag varchar2(1);
50: l_tax ZX_TAXES_B.tax%TYPE;
51: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
52: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
53: l_tax_rate NUMBER;
54: l_tax_rate_id INTEGER;
55: l_def_tax_rate_id INTEGER;
56: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;

Line 1544: p_tax_status_code IN zx_status_b.tax_status_code%TYPE,

1540: PROCEDURE validate_offset_tax (
1541: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
1542: p_tax IN zx_taxes_b.tax%TYPE,
1543: p_tax_determine_date IN DATE,
1544: p_tax_status_code IN zx_status_b.tax_status_code%TYPE,
1545: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
1546: p_tax_class IN zx_rates_b.tax_class%TYPE,
1547: p_tax_rate_code IN zx_rates_b.tax_rate_code%TYPE,
1548: x_return_status OUT NOCOPY VARCHAR2,

Line 1557: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

1553: CURSOR get_offset_info_csr
1554: (c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
1555: c_tax ZX_TAXES_B.TAX%TYPE,
1556: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1557: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1558: c_tax_determine_date ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE)
1559: IS
1560: SELECT tax_rate_id
1561: FROM ZX_SCO_RATES_B_V -- Bug#5395227