2: /* $Header: zxditaxstsdtpkgb.pls 120.29.12010000.2 2008/09/11 18:22:14 appradha ship $ */
3:
4:
5: PROCEDURE get_def_tax_status_info(
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_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
9: p_status_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC,
10: p_return_status OUT NOCOPY VARCHAR2,
20: p_structure_name IN VARCHAR2,
21: p_structure_index IN BINARY_INTEGER,
22: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
23: p_status_result_id OUT NOCOPY ZX_LINES.STATUS_RESULT_ID%TYPE,
24: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
25: p_tax_status_code IN OUT NOCOPY ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
26: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
27: p_return_status OUT NOCOPY VARCHAR2,
28: p_error_buffer OUT NOCOPY VARCHAR2);
54:
55: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
56: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
57: l_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE;
58: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;
59: l_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
60: l_tax ZX_TAXES_B.TAX%TYPE;
61: l_status_result_id ZX_LINES.STATUS_RESULT_ID%TYPE;
62: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
56: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
57: l_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE;
58: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;
59: l_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
60: l_tax ZX_TAXES_B.TAX%TYPE;
61: l_status_result_id ZX_LINES.STATUS_RESULT_ID%TYPE;
62: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
63:
64: BEGIN
280: -- This procedure gets the default tax status code and
281: -- all information related to this status
282: --
283: PROCEDURE get_def_tax_status_info(
284: p_tax IN ZX_TAXES_B.TAX%TYPE,
285: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
286: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
287: p_status_rec OUT NOCOPY ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC,
288: p_return_status OUT NOCOPY VARCHAR2,
410: p_structure_name IN VARCHAR2,
411: p_structure_index IN BINARY_INTEGER,
412: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
413: p_status_result_id OUT NOCOPY ZX_LINES.STATUS_RESULT_ID%TYPE,
414: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
415: p_tax_status_code IN OUT NOCOPY ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
416: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
417: p_return_status OUT NOCOPY VARCHAR2,
418: p_error_buffer OUT NOCOPY VARCHAR2)