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: exempt_reason_code VARCHAR2(30),

Line 1862: p_tax IN zx_taxes_b.tax%TYPE,

1858: ------------------------------------------------------------------------------
1859:
1860: PROCEDURE validate_offset_tax (
1861: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
1862: p_tax IN zx_taxes_b.tax%TYPE,
1863: p_tax_determine_date IN DATE,
1864: p_tax_status_code IN zx_status_b.tax_status_code%TYPE,
1865: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
1866: p_tax_class IN zx_rates_b.tax_class%TYPE,

Line 1875: c_tax ZX_TAXES_B.TAX%TYPE,

1871:
1872: /* Bug#5417753- use cache structure
1873: CURSOR get_offset_info_csr
1874: (c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
1875: c_tax ZX_TAXES_B.TAX%TYPE,
1876: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1877: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1878: c_tax_determine_date ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE)
1879: IS