1: package body ZX_TDS_OFFSET_TAX_DETM_PKG as
2: /* $Header: zxdioffsettxpkgb.pls 120.47.12020000.2 2012/07/23 12:53:02 srajapar noship $ */
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,
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,
13: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,
14: p_return_status OUT NOCOPY VARCHAR2,
15: p_error_buffer OUT NOCOPY VARCHAR2);
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,
13: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,
14: p_return_status OUT NOCOPY VARCHAR2,
15: p_error_buffer OUT NOCOPY VARCHAR2);
16:
54:
55: PROCEDURE create_offset_tax_line(
56: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
57: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
58: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
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,
55: PROCEDURE create_offset_tax_line(
56: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
57: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
58: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
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,
84: p_return_status OUT NOCOPY VARCHAR2,
85: p_error_buffer OUT NOCOPY VARCHAR2)
86:
87: IS
88: l_tax_rate_id ZX_RATES_B.TAX_RATE_ID%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;
85: p_error_buffer OUT NOCOPY VARCHAR2)
86:
87: IS
88: l_tax_rate_id ZX_RATES_B.TAX_RATE_ID%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;
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:
99: BEGIN
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:
99: BEGIN
100: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
101:
242: -- PRIVATE PROCEDURE
243: -- get_offset_info
244: --
245: -- DESCRIPTION
246: -- This procedure gets offset tax info from ZX_RATES_B
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,
245: -- DESCRIPTION
246: -- This procedure gets offset tax info from ZX_RATES_B
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,
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,
256: p_offset_tax_rate_id OUT NOCOPY ZX_RATES_B.TAX_RATE_ID%TYPE,
257: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,
258: p_return_status OUT NOCOPY VARCHAR2,
259: p_error_buffer OUT NOCOPY VARCHAR2)
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,
256: p_offset_tax_rate_id OUT NOCOPY ZX_RATES_B.TAX_RATE_ID%TYPE,
257: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,
258: p_return_status OUT NOCOPY VARCHAR2,
259: p_error_buffer OUT NOCOPY VARCHAR2)
260:
258: p_return_status OUT NOCOPY VARCHAR2,
259: p_error_buffer OUT NOCOPY VARCHAR2)
260:
261: IS
262: --l_Rate_Type_Code ZX_RATES_B.Rate_Type_Code%TYPE;
263: --l_percentage_rate ZX_RATES_B.PERCENTAGE_RATE%TYPE;
264: --l_quantity_rate ZX_RATES_B.QUANTITY_RATE%TYPE;
265: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
266:
259: p_error_buffer OUT NOCOPY VARCHAR2)
260:
261: IS
262: --l_Rate_Type_Code ZX_RATES_B.Rate_Type_Code%TYPE;
263: --l_percentage_rate ZX_RATES_B.PERCENTAGE_RATE%TYPE;
264: --l_quantity_rate ZX_RATES_B.QUANTITY_RATE%TYPE;
265: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
266:
267: /* Bug#5417753- use cache structure
260:
261: IS
262: --l_Rate_Type_Code ZX_RATES_B.Rate_Type_Code%TYPE;
263: --l_percentage_rate ZX_RATES_B.PERCENTAGE_RATE%TYPE;
264: --l_quantity_rate ZX_RATES_B.QUANTITY_RATE%TYPE;
265: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
266:
267: /* Bug#5417753- use cache structure
268: CURSOR get_offset_info_csr
265: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
266:
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)
867:
868: PROCEDURE create_offset_tax_line(
869: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
870: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
871: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
872: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
873: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
874: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
875: p_offset_tax IN ZX_TAXES_B.TAX%TYPE,
868: PROCEDURE create_offset_tax_line(
869: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
870: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
871: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
872: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
873: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
874: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
875: p_offset_tax IN ZX_TAXES_B.TAX%TYPE,
876: p_offset_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,