DBA Data[Home] [Help]

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 367: p_tax IN zx_taxes_b.tax%TYPE,

363: -- If tax does not exist, get the tax regime information from database
364: -------------------------------------------------------------------------
365: PROCEDURE get_tax_cache_info (
366: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
367: p_tax IN zx_taxes_b.tax%TYPE,
368: p_tax_determine_date IN DATE,
369: x_tax_rec OUT NOCOPY zx_tax_info_cache_rec,
370: p_return_status OUT NOCOPY VARCHAR2,
371: p_error_buffer OUT NOCOPY VARCHAR2) IS

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

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

Line 467: -- fetching tax_info from zx_taxes_b

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

Line 531: p_tax IN zx_taxes_b.tax%TYPE,

527: --
528: -------------------------------------------------------------------------
529: PROCEDURE get_jurisdiction_cache_info (
530: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
531: p_tax IN zx_taxes_b.tax%TYPE,
532: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
533: p_tax_determine_date IN DATE,
534: x_jurisdiction_rec OUT NOCOPY zx_jur_info_cache_rec_type,
535: 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,