DBA Data[Home] [Help]

APPS.ZX_TDS_UTILITIES_PKG dependencies on ZX_JURISDICTIONS_B

Line 108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,

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,

Line 121: tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%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,

Line 122: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%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

Line 123: effective_from zx_jurisdictions_b.effective_from%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: );

Line 124: effective_to zx_jurisdictions_b.effective_to%type,

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:

Line 125: tax_regime_code zx_jurisdictions_b.tax_regime_code%type,

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

Line 126: tax zx_jurisdictions_b.tax%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;

Line 162: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,

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

Line 198: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,

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,