APPS.ZX_TDS_UTILITIES_PKG dependencies on ZX_TAXES_B

Line 19: p_tax IN ZX_TAXES_B.TAX%TYPE,

15: -- status cache structure
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:

Line 71: p_tax IN ZX_TAXES_B.TAX%TYPE,

67: -- based on the hash index of Tax, Tax regime code and Tax status code if
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,

Line 365: p_tax IN zx_taxes_b.tax%TYPE,

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,
369: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 461: -- if tax does not exist in cache, get tax info from zx_taxes_b

457: END IF;
458: l_index := g_tax_rec_tbl.PRIOR(l_index);
459: END LOOP;
460:
461: -- if tax does not exist in cache, get tax info from zx_taxes_b
462: --
463: IF NOT l_in_cache_flg THEN
464: --
465: -- fetching tax_info from zx_taxes_b

Line 465: -- fetching tax_info from zx_taxes_b

461: -- if tax does not exist in cache, get tax info from zx_taxes_b
462: --
463: IF NOT l_in_cache_flg THEN
464: --
465: -- fetching tax_info from zx_taxes_b
466: --
467: OPEN get_tax_info_csr;
468: FETCH get_tax_info_csr INTO x_tax_rec;
469:

Line 529: p_tax IN zx_taxes_b.tax%TYPE,

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,
533: p_return_status OUT NOCOPY VARCHAR2,

Line 587: -- if tax does not exist in cache, get tax info from zx_taxes_b

583: END IF;
584: l_index := g_jur_info_tbl.NEXT(l_index);
585: END LOOP;
586:
587: -- if tax does not exist in cache, get tax info from zx_taxes_b
588: --
589: IF NOT l_in_cache_flg THEN
590: --
591: -- fetching tax_info from zx_taxes_b

Line 591: -- fetching tax_info from zx_taxes_b

587: -- if tax does not exist in cache, get tax info from zx_taxes_b
588: --
589: IF NOT l_in_cache_flg THEN
590: --
591: -- fetching tax_info from zx_taxes_b
592: --
593: OPEN get_jur_info_csr;
594: FETCH get_jur_info_csr INTO
595: x_jurisdiction_rec.tax_jurisdiction_code,

Line 697: FROM ZX_TAXES_B

693: zone_geography_type,
694: override_geography_type,
695: allow_rounding_override_flag,
696: tax_account_source_tax
697: FROM ZX_TAXES_B
698: WHERE tax_id = p_tax_id;
699:
700: BEGIN
701:

Line 1089: p_tax IN zx_taxes_b.tax%TYPE,

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,
1093: p_end_index IN BINARY_INTEGER,