[Home] [Help]
16: --
17:
18: FUNCTION get_tax_status_index(
19: p_tax IN ZX_TAXES_B.TAX%TYPE,
20: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
21: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE)
22: RETURN BINARY_INTEGER IS
23:
24: l_tbl_index BINARY_INTEGER;
68: -- exists, if not, obtain the Tax status information from the database
69: --
70: PROCEDURE get_tax_status_cache_info(
71: p_tax IN ZX_TAXES_B.TAX%TYPE,
72: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
73: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
74: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
75: p_status_rec OUT NOCOPY ZX_STATUS_INFO_REC,
76: p_return_status OUT NOCOPY VARCHAR2,
80: l_index BINARY_INTEGER;
81:
82: CURSOR get_status_info_csr
83: (c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
84: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
85: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
86: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
87: IS
88: SELECT tax_status_id,
81:
82: CURSOR get_status_info_csr
83: (c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
84: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
85: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
86: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
87: IS
88: SELECT tax_status_id,
89: tax_status_code,
223: -- structure based on tax regime code, if regime exists in it.
224: -- If regime does not exist, get tax regime information from the database
225: --------------------------------------------------------------------------
226: PROCEDURE get_regime_cache_info (
227: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
228: p_tax_determine_date IN DATE,
229: p_tax_regime_rec OUT NOCOPY zx_global_structures_pkg.tax_regime_rec_type,
230: p_return_status OUT NOCOPY VARCHAR2,
231: p_error_buffer OUT NOCOPY VARCHAR2) IS
240: geography_id,
241: effective_from,
242: effective_to,
243: country_or_group_code
244: FROM ZX_REGIMES_B_V
245: WHERE tax_regime_code = p_tax_regime_code
246: AND (( effective_from <= p_tax_determine_date) AND
247: ( effective_to >= p_tax_determine_date OR effective_to IS NULL));
248:
360: -- based on tax regime code and tax, if tax exists in it.
361: -- If tax does not exist, get the tax information from database
362: -------------------------------------------------------------------------
363: PROCEDURE get_tax_cache_info (
364: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
365: p_tax IN zx_taxes_b.tax%TYPE,
366: p_tax_determine_date IN DATE,
367: x_tax_rec OUT NOCOPY zx_tax_info_cache_rec,
368: p_return_status OUT NOCOPY VARCHAR2,
524: -- based on tax regime code ,tax and tax jurisdiction code, if tax exists in it.
525: --
526: -------------------------------------------------------------------------
527: PROCEDURE get_jurisdiction_cache_info (
528: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
529: p_tax IN zx_taxes_b.tax%TYPE,
530: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
531: p_tax_determine_date IN DATE,
532: x_jurisdiction_rec OUT NOCOPY zx_jur_info_cache_rec_type,
1084: -- l_begin_index
1085: -- OUT NOCOPY x_return_status
1086: --
1087: FUNCTION get_tax_index (
1088: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
1089: p_tax IN zx_taxes_b.tax%TYPE,
1090: p_trx_line_id IN NUMBER,
1091: p_trx_level_type IN VARCHAR2,
1092: p_begin_index IN BINARY_INTEGER,