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,
12: p_offset_tax_rate_id OUT NOCOPY ZX_RATES_B.TAX_RATE_ID%TYPE,
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,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_error_buffer OUT NOCOPY VARCHAR2);
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,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_error_buffer OUT NOCOPY VARCHAR2);
39:
40: PROCEDURE get_tax_id(
59: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
60: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
61: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
62: p_offset_tax IN ZX_TAXES_B.TAX%TYPE,
63: p_offset_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
64: p_return_status OUT NOCOPY VARCHAR2,
65: p_error_buffer OUT NOCOPY VARCHAR2);
66:
67: g_current_runtime_level NUMBER;
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;
98:
244: PROCEDURE get_offset_info(
245: p_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
246: p_tax IN ZX_TAXES_B.TAX%TYPE,
247: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
248: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
249: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
250: p_tax_jurisdiction_code IN ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE,
251: p_tax_class IN ZX_RATES_B.TAX_CLASS%TYPE,
252: p_offset_tax_rate_id OUT NOCOPY ZX_RATES_B.TAX_RATE_ID%TYPE,
264: CURSOR get_offset_info_csr
265: (c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
266: c_tax ZX_TAXES_B.TAX%TYPE,
267: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
268: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
269: c_tax_determine_date ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE)
270: IS
271:
272: SELECT tax_rate_id,
663: --
664: PROCEDURE get_tax_status_id(
665: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
666: p_tax IN ZX_TAXES_B.TAX%TYPE,
667: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
668: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
669: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,
670: p_return_status OUT NOCOPY VARCHAR2,
671: p_error_buffer OUT NOCOPY VARCHAR2)
665: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
666: p_tax IN ZX_TAXES_B.TAX%TYPE,
667: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
668: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
669: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,
670: p_return_status OUT NOCOPY VARCHAR2,
671: p_error_buffer OUT NOCOPY VARCHAR2)
672:
673: IS
870: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
871: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
872: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
873: p_offset_tax IN ZX_TAXES_B.TAX%TYPE,
874: p_offset_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
875: p_return_status OUT NOCOPY VARCHAR2,
876: p_error_buffer OUT NOCOPY VARCHAR2)
877: IS
878: