DBA Data[Home] [Help]

APPS.ZX_TDS_OFFSET_TAX_DETM_PKG dependencies on ZX_REGIMES_B

Line 7: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

3:
4: PROCEDURE get_offset_info(
5: p_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
6: p_tax IN ZX_TAXES_B.TAX%TYPE,
7: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
8: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
9: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
10: p_tax_jurisdiction_code IN ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE,
11: p_tax_class IN ZX_RATES_B.TAX_CLASS%TYPE,

Line 32: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

28: p_error_buffer OUT NOCOPY VARCHAR2);
29:
30:
31: PROCEDURE get_tax_status_id(
32: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
33: p_tax IN ZX_TAXES_B.TAX%TYPE,
34: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
35: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
36: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,

Line 41: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

37: p_return_status OUT NOCOPY VARCHAR2,
38: p_error_buffer OUT NOCOPY VARCHAR2);
39:
40: PROCEDURE get_tax_id(
41: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
42: p_tax IN ZX_TAXES_B.TAX%TYPE,
43: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
44: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,
45: p_return_status OUT NOCOPY VARCHAR2,

Line 93: l_offset_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;

89: l_offset_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE;
90: l_offset_tax_rate ZX_LINES.TAX_RATE%TYPE;
91: l_initial_tax_rate ZX_LINES.TAX_RATE%TYPE;
92: l_offset_tax ZX_TAXES_B.TAX%TYPE;
93: l_offset_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
94: l_offset_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE;
95: l_offset_tax_rate_code ZX_RATES_B.OFFSET_TAX_RATE_CODE%TYPE;
96: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
97: l_tax_class ZX_RATES_B.TAX_CLASS%TYPE;

Line 251: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

247: --
248: PROCEDURE get_offset_info(
249: p_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
250: p_tax IN ZX_TAXES_B.TAX%TYPE,
251: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
252: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
253: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
254: p_tax_jurisdiction_code IN ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE,
255: p_tax_class IN ZX_RATES_B.TAX_CLASS%TYPE,

Line 271: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

267: /* Bug#5417753- use cache structure
268: CURSOR get_offset_info_csr
269: (c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
270: c_tax ZX_TAXES_B.TAX%TYPE,
271: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
272: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
273: c_tax_determine_date ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE)
274: IS
275:

Line 670: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

666: -- This procedure gets tax status id from global cache structure based on
667: -- tax regime code, tax and tax status code
668: --
669: PROCEDURE get_tax_status_id(
670: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
671: p_tax IN ZX_TAXES_B.TAX%TYPE,
672: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
673: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
674: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,

Line 729: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

725: -- This procedure gets tax id from zx_taxes based on
726: -- tax regime code and tax
727: --
728: PROCEDURE get_tax_id(
729: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
730: p_tax IN ZX_TAXES_B.TAX%TYPE,
731: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
732: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,
733: p_return_status OUT NOCOPY VARCHAR2,