DBA Data[Home] [Help]

APPS.ZX_TDS_RATE_DETM_PKG dependencies on ZX_TAXES_B

Line 16: p_tax IN zx_taxes_b.tax%TYPE,

12: ------------------------------------------------------------------------------
13:
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,

Line 50: l_tax ZX_TAXES_B.tax%TYPE;

46:
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;

Line 92: tax_regime_code zx_taxes_b.tax_regime_code%TYPE,

88: l_tax_class zx_rates_b.tax_class%TYPE;
89: l_inventory_org_id NUMBER;
90:
91: TYPE exemption_info_type IS RECORD (
92: tax_regime_code zx_taxes_b.tax_regime_code%TYPE,
93: tax zx_taxes_b.tax%TYPE,
94: exemption_id NUMBER,
95: percent_exempt NUMBER,
96: discount_special_rate VARCHAR2(30)

Line 93: tax zx_taxes_b.tax%TYPE,

89: l_inventory_org_id NUMBER;
90:
91: TYPE exemption_info_type IS RECORD (
92: tax_regime_code zx_taxes_b.tax_regime_code%TYPE,
93: tax zx_taxes_b.tax%TYPE,
94: exemption_id NUMBER,
95: percent_exempt NUMBER,
96: discount_special_rate VARCHAR2(30)
97: );

Line 1542: p_tax IN zx_taxes_b.tax%TYPE,

1538: ------------------------------------------------------------------------------
1539:
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,

Line 1555: c_tax ZX_TAXES_B.TAX%TYPE,

1551:
1552: /* Bug#5417753- use cache structure
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