[Home] [Help]
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,
11: p_error_buffer OUT NOCOPY VARCHAR2);
12:
13:
13:
14: PROCEDURE update_det_tax_line(
15: i IN BINARY_INTEGER,
16: p_status_result_id IN ZX_LINES.STATUS_RESULT_ID%TYPE,
17: p_status_rec IN ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC);
18:
19: PROCEDURE rule_base_tax_status_detm(
20: p_structure_name IN VARCHAR2,
21: p_structure_index IN BINARY_INTEGER,
52: p_error_buffer OUT NOCOPY VARCHAR2)
53: IS
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;
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
65: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
66:
122: l_tax_status_code := NULL;
123:
124: l_tax_determine_date := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date;
125: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_id;
126: l_tax_rec := ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id);
127: l_tax_regime_code := l_tax_rec.tax_regime_code;
128: l_tax := l_tax_rec.tax;
129:
130: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code IS NULL THEN
173: IF l_tax_status_code IS NOT NULL THEN
174:
175: -- check valid tax status id and populate tax status cache
176: --
177: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(
178: l_tax,
179: l_tax_regime_code,
180: l_tax_status_code,
181: l_tax_determine_date,
186: IF (g_level_error >= g_current_runtime_level ) THEN
187: FND_LOG.STRING(g_level_error,
188: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
189: 'Incorrect return_status after calling '||
190: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()' );
191: FND_LOG.STRING(g_level_error,
192: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
193: 'No valid tax status id for the tax status code ' ||
194: 'returned from rule engine. Need to get default tax status.');
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,
289: p_error_buffer OUT NOCOPY VARCHAR2)
290:
291: IS
365: --
366: -- update the global status cache structure
367: --
368: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
369: l_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(
370: p_status_rec.tax,
371: p_status_rec.tax_regime_code,
372: p_status_rec.tax_status_code);
373: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_index) := p_status_rec;
369: l_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(
370: p_status_rec.tax,
371: p_status_rec.tax_regime_code,
372: p_status_rec.tax_status_code);
373: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_index) := p_status_rec;
374: END IF;
375:
376:
377: IF (g_level_procedure >= g_current_runtime_level ) THEN
507:
508: PROCEDURE update_det_tax_line(
509: i IN BINARY_INTEGER,
510: p_status_result_id IN ZX_LINES.STATUS_RESULT_ID%TYPE,
511: p_status_rec IN ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC)
512: IS
513: BEGIN
514: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
515: