104: offset_status_code zx_rates_b.offset_status_code%TYPE,
105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,
106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,
107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,
108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,
109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,
110: taxable_basis_formula_code zx_rates_b.taxable_basis_formula_code%TYPE,
111: adj_for_adhoc_amt_code zx_rates_b.adj_for_adhoc_amt_code%TYPE,
112: inclusive_tax_flag zx_rates_b.inclusive_tax_flag%TYPE,
117: INDEX BY BINARY_INTEGER;
118:
119:
120: TYPE zx_jur_info_cache_rec_type IS RECORD(
121: tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%type,
122: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%type,
123: effective_from zx_jurisdictions_b.effective_from%type,
124: effective_to zx_jurisdictions_b.effective_to%type,
125: tax_regime_code zx_jurisdictions_b.tax_regime_code%type,
118:
119:
120: TYPE zx_jur_info_cache_rec_type IS RECORD(
121: tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%type,
122: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%type,
123: effective_from zx_jurisdictions_b.effective_from%type,
124: effective_to zx_jurisdictions_b.effective_to%type,
125: tax_regime_code zx_jurisdictions_b.tax_regime_code%type,
126: tax zx_jurisdictions_b.tax%type
119:
120: TYPE zx_jur_info_cache_rec_type IS RECORD(
121: tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%type,
122: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%type,
123: effective_from zx_jurisdictions_b.effective_from%type,
124: effective_to zx_jurisdictions_b.effective_to%type,
125: tax_regime_code zx_jurisdictions_b.tax_regime_code%type,
126: tax zx_jurisdictions_b.tax%type
127: );
120: TYPE zx_jur_info_cache_rec_type IS RECORD(
121: tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%type,
122: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%type,
123: effective_from zx_jurisdictions_b.effective_from%type,
124: effective_to zx_jurisdictions_b.effective_to%type,
125: tax_regime_code zx_jurisdictions_b.tax_regime_code%type,
126: tax zx_jurisdictions_b.tax%type
127: );
128:
121: tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%type,
122: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%type,
123: effective_from zx_jurisdictions_b.effective_from%type,
124: effective_to zx_jurisdictions_b.effective_to%type,
125: tax_regime_code zx_jurisdictions_b.tax_regime_code%type,
126: tax zx_jurisdictions_b.tax%type
127: );
128:
129: TYPE zx_jur_info_cache IS TABLE OF zx_jur_info_cache_rec_type
122: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%type,
123: effective_from zx_jurisdictions_b.effective_from%type,
124: effective_to zx_jurisdictions_b.effective_to%type,
125: tax_regime_code zx_jurisdictions_b.tax_regime_code%type,
126: tax zx_jurisdictions_b.tax%type
127: );
128:
129: TYPE zx_jur_info_cache IS TABLE OF zx_jur_info_cache_rec_type
130: INDEX BY BINARY_INTEGER;
158:
159: PROCEDURE get_jurisdiction_cache_info (
160: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
161: p_tax IN zx_taxes_b.tax%TYPE,
162: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
163: p_tax_determine_date IN DATE,
164: x_jurisdiction_rec OUT NOCOPY zx_jur_info_cache_rec_type,
165: p_return_status OUT NOCOPY VARCHAR2,
166: p_error_buffer OUT NOCOPY VARCHAR2);
194:
195: PROCEDURE get_tax_rate_info (
196: p_tax_regime_code IN VARCHAR2,
197: p_tax IN VARCHAR2,
198: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
199: p_tax_status_code IN VARCHAR2,
200: p_tax_rate_code IN VARCHAR2,
201: p_tax_determine_date IN DATE,
202: p_tax_class IN VARCHAR2,