eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_OFFSET_TAX_DETM_PKG dependencies on ZX_RATES_B

Line 5: p_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,

1: package body ZX_TDS_OFFSET_TAX_DETM_PKG as
2: /* $Header: zxdioffsettxpkgb.pls 120.43.12010000.2 2008/11/12 12:22:45 spasala ship $ */
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,

Line 11: p_tax_class IN ZX_RATES_B.TAX_CLASS%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);

Line 12: p_offset_tax_rate_id OUT NOCOPY ZX_RATES_B.TAX_RATE_ID%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);
16:

Line 58: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,

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,

Line 59: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%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,

Line 88: l_tax_rate_id ZX_RATES_B.TAX_RATE_ID%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;

Line 89: l_offset_tax_rate_id ZX_RATES_B.TAX_RATE_ID%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;

Line 95: l_offset_tax_rate_code ZX_RATES_B.OFFSET_TAX_RATE_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

Line 97: l_tax_class ZX_RATES_B.TAX_CLASS%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
100: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
101:

Line 242: -- This procedure gets offset tax info from ZX_RATES_B

238: -- PRIVATE PROCEDURE
239: -- get_offset_info
240: --
241: -- DESCRIPTION
242: -- This procedure gets offset tax info from ZX_RATES_B
243: --
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,

Line 245: p_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,

241: -- DESCRIPTION
242: -- This procedure gets offset tax info from ZX_RATES_B
243: --
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,

Line 251: p_tax_class IN ZX_RATES_B.TAX_CLASS%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,
253: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,
254: p_return_status OUT NOCOPY VARCHAR2,
255: p_error_buffer OUT NOCOPY VARCHAR2)

Line 252: p_offset_tax_rate_id OUT NOCOPY ZX_RATES_B.TAX_RATE_ID%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,
253: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,
254: p_return_status OUT NOCOPY VARCHAR2,
255: p_error_buffer OUT NOCOPY VARCHAR2)
256:

Line 258: --l_Rate_Type_Code ZX_RATES_B.Rate_Type_Code%TYPE;

254: p_return_status OUT NOCOPY VARCHAR2,
255: p_error_buffer OUT NOCOPY VARCHAR2)
256:
257: IS
258: --l_Rate_Type_Code ZX_RATES_B.Rate_Type_Code%TYPE;
259: --l_percentage_rate ZX_RATES_B.PERCENTAGE_RATE%TYPE;
260: --l_quantity_rate ZX_RATES_B.QUANTITY_RATE%TYPE;
261: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
262:

Line 259: --l_percentage_rate ZX_RATES_B.PERCENTAGE_RATE%TYPE;

255: p_error_buffer OUT NOCOPY VARCHAR2)
256:
257: IS
258: --l_Rate_Type_Code ZX_RATES_B.Rate_Type_Code%TYPE;
259: --l_percentage_rate ZX_RATES_B.PERCENTAGE_RATE%TYPE;
260: --l_quantity_rate ZX_RATES_B.QUANTITY_RATE%TYPE;
261: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
262:
263: /* Bug#5417753- use cache structure

Line 260: --l_quantity_rate ZX_RATES_B.QUANTITY_RATE%TYPE;

256:
257: IS
258: --l_Rate_Type_Code ZX_RATES_B.Rate_Type_Code%TYPE;
259: --l_percentage_rate ZX_RATES_B.PERCENTAGE_RATE%TYPE;
260: --l_quantity_rate ZX_RATES_B.QUANTITY_RATE%TYPE;
261: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
262:
263: /* Bug#5417753- use cache structure
264: CURSOR get_offset_info_csr

Line 265: (c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,

261: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
262:
263: /* Bug#5417753- use cache structure
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)

Line 869: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,

865:
866: PROCEDURE create_offset_tax_line(
867: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
868: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
869: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
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,

Line 870: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,

866: PROCEDURE create_offset_tax_line(
867: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
868: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
869: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
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,