DBA Data[Home] [Help]

APPS.ZX_TDS_UTILITIES_PKG dependencies on ZX_STATUS_B

Line 59: tax_status_id zx_status_b.tax_status_id%TYPE,

55: -- Tax Status information cache
56: TYPE zx_status_info_rec IS RECORD (
57: tax zx_taxes_b.tax%TYPE,
58: tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
59: tax_status_id zx_status_b.tax_status_id%TYPE,
60: tax_status_code zx_status_b.tax_status_code%TYPE,
61: tax_status_name zx_status_tl.tax_status_name%TYPE,
62: effective_from zx_status_b.effective_from%TYPE,
63: effective_to zx_status_b.effective_to%TYPE,

Line 60: tax_status_code zx_status_b.tax_status_code%TYPE,

56: TYPE zx_status_info_rec IS RECORD (
57: tax zx_taxes_b.tax%TYPE,
58: tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
59: tax_status_id zx_status_b.tax_status_id%TYPE,
60: tax_status_code zx_status_b.tax_status_code%TYPE,
61: tax_status_name zx_status_tl.tax_status_name%TYPE,
62: effective_from zx_status_b.effective_from%TYPE,
63: effective_to zx_status_b.effective_to%TYPE,
64: Default_Status_Flag zx_status_b.default_status_flag%TYPE,

Line 62: effective_from zx_status_b.effective_from%TYPE,

58: tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
59: tax_status_id zx_status_b.tax_status_id%TYPE,
60: tax_status_code zx_status_b.tax_status_code%TYPE,
61: tax_status_name zx_status_tl.tax_status_name%TYPE,
62: effective_from zx_status_b.effective_from%TYPE,
63: effective_to zx_status_b.effective_to%TYPE,
64: Default_Status_Flag zx_status_b.default_status_flag%TYPE,
65: default_flg_effective_from zx_status_b.default_flg_effective_from%TYPE,
66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,

Line 63: effective_to zx_status_b.effective_to%TYPE,

59: tax_status_id zx_status_b.tax_status_id%TYPE,
60: tax_status_code zx_status_b.tax_status_code%TYPE,
61: tax_status_name zx_status_tl.tax_status_name%TYPE,
62: effective_from zx_status_b.effective_from%TYPE,
63: effective_to zx_status_b.effective_to%TYPE,
64: Default_Status_Flag zx_status_b.default_status_flag%TYPE,
65: default_flg_effective_from zx_status_b.default_flg_effective_from%TYPE,
66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,
67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,

Line 64: Default_Status_Flag zx_status_b.default_status_flag%TYPE,

60: tax_status_code zx_status_b.tax_status_code%TYPE,
61: tax_status_name zx_status_tl.tax_status_name%TYPE,
62: effective_from zx_status_b.effective_from%TYPE,
63: effective_to zx_status_b.effective_to%TYPE,
64: Default_Status_Flag zx_status_b.default_status_flag%TYPE,
65: default_flg_effective_from zx_status_b.default_flg_effective_from%TYPE,
66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,
67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,
68: Rule_Based_Rate_Flag zx_status_b.rule_based_rate_flag%TYPE,

Line 65: default_flg_effective_from zx_status_b.default_flg_effective_from%TYPE,

61: tax_status_name zx_status_tl.tax_status_name%TYPE,
62: effective_from zx_status_b.effective_from%TYPE,
63: effective_to zx_status_b.effective_to%TYPE,
64: Default_Status_Flag zx_status_b.default_status_flag%TYPE,
65: default_flg_effective_from zx_status_b.default_flg_effective_from%TYPE,
66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,
67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,
68: Rule_Based_Rate_Flag zx_status_b.rule_based_rate_flag%TYPE,
69: Allow_Rate_Override_Flag zx_status_b.allow_rate_override_flag%TYPE,

Line 66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,

62: effective_from zx_status_b.effective_from%TYPE,
63: effective_to zx_status_b.effective_to%TYPE,
64: Default_Status_Flag zx_status_b.default_status_flag%TYPE,
65: default_flg_effective_from zx_status_b.default_flg_effective_from%TYPE,
66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,
67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,
68: Rule_Based_Rate_Flag zx_status_b.rule_based_rate_flag%TYPE,
69: Allow_Rate_Override_Flag zx_status_b.allow_rate_override_flag%TYPE,
70: Allow_Exemptions_Flag zx_status_b.allow_exemptions_flag%TYPE,

Line 67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,

63: effective_to zx_status_b.effective_to%TYPE,
64: Default_Status_Flag zx_status_b.default_status_flag%TYPE,
65: default_flg_effective_from zx_status_b.default_flg_effective_from%TYPE,
66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,
67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,
68: Rule_Based_Rate_Flag zx_status_b.rule_based_rate_flag%TYPE,
69: Allow_Rate_Override_Flag zx_status_b.allow_rate_override_flag%TYPE,
70: Allow_Exemptions_Flag zx_status_b.allow_exemptions_flag%TYPE,
71: Allow_Exceptions_Flag zx_status_b.allow_exceptions_flag%TYPE);

Line 68: Rule_Based_Rate_Flag zx_status_b.rule_based_rate_flag%TYPE,

64: Default_Status_Flag zx_status_b.default_status_flag%TYPE,
65: default_flg_effective_from zx_status_b.default_flg_effective_from%TYPE,
66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,
67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,
68: Rule_Based_Rate_Flag zx_status_b.rule_based_rate_flag%TYPE,
69: Allow_Rate_Override_Flag zx_status_b.allow_rate_override_flag%TYPE,
70: Allow_Exemptions_Flag zx_status_b.allow_exemptions_flag%TYPE,
71: Allow_Exceptions_Flag zx_status_b.allow_exceptions_flag%TYPE);
72:

Line 69: Allow_Rate_Override_Flag zx_status_b.allow_rate_override_flag%TYPE,

65: default_flg_effective_from zx_status_b.default_flg_effective_from%TYPE,
66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,
67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,
68: Rule_Based_Rate_Flag zx_status_b.rule_based_rate_flag%TYPE,
69: Allow_Rate_Override_Flag zx_status_b.allow_rate_override_flag%TYPE,
70: Allow_Exemptions_Flag zx_status_b.allow_exemptions_flag%TYPE,
71: Allow_Exceptions_Flag zx_status_b.allow_exceptions_flag%TYPE);
72:
73: TYPE zx_status_info_cache IS TABLE OF zx_status_info_rec

Line 70: Allow_Exemptions_Flag zx_status_b.allow_exemptions_flag%TYPE,

66: default_flg_effective_to zx_status_b.default_flg_effective_to%TYPE,
67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,
68: Rule_Based_Rate_Flag zx_status_b.rule_based_rate_flag%TYPE,
69: Allow_Rate_Override_Flag zx_status_b.allow_rate_override_flag%TYPE,
70: Allow_Exemptions_Flag zx_status_b.allow_exemptions_flag%TYPE,
71: Allow_Exceptions_Flag zx_status_b.allow_exceptions_flag%TYPE);
72:
73: TYPE zx_status_info_cache IS TABLE OF zx_status_info_rec
74: INDEX BY BINARY_INTEGER;

Line 71: Allow_Exceptions_Flag zx_status_b.allow_exceptions_flag%TYPE);

67: -- default_tax_rate_name zx_status_b.default_tax_rate_name%TYPE,
68: Rule_Based_Rate_Flag zx_status_b.rule_based_rate_flag%TYPE,
69: Allow_Rate_Override_Flag zx_status_b.allow_rate_override_flag%TYPE,
70: Allow_Exemptions_Flag zx_status_b.allow_exemptions_flag%TYPE,
71: Allow_Exceptions_Flag zx_status_b.allow_exceptions_flag%TYPE);
72:
73: TYPE zx_status_info_cache IS TABLE OF zx_status_info_rec
74: INDEX BY BINARY_INTEGER;
75:

Line 149: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE)

145:
146: FUNCTION get_tax_status_index(
147: p_tax IN ZX_TAXES_B.TAX%TYPE,
148: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
149: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE)
150: RETURN BINARY_INTEGER;
151:
152: PROCEDURE get_regime_cache_info (
153: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,

Line 179: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

175:
176: PROCEDURE get_tax_status_cache_info(
177: p_tax IN ZX_TAXES_B.TAX%TYPE,
178: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
179: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
180: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
181: p_status_rec OUT NOCOPY ZX_STATUS_INFO_REC,
182: p_return_status OUT NOCOPY VARCHAR2,
183: p_error_buffer OUT NOCOPY VARCHAR2);