DBA Data[Home] [Help]

APPS.ZX_TDS_OFFSET_TAX_DETM_PKG dependencies on ZX_STATUS_B

Line 8: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

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,

Line 34: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%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);

Line 36: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,

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(

Line 63: p_offset_status_code IN ZX_STATUS_B.TAX_STATUS_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,
64: p_return_status OUT NOCOPY VARCHAR2,
65: p_error_buffer OUT NOCOPY VARCHAR2);
66:
67: g_current_runtime_level NUMBER;

Line 94: l_offset_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%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;
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:

Line 248: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

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,

Line 268: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%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,

Line 667: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

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)

Line 669: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,

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

Line 874: p_offset_status_code IN ZX_STATUS_B.TAX_STATUS_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,
875: p_return_status OUT NOCOPY VARCHAR2,
876: p_error_buffer OUT NOCOPY VARCHAR2)
877: IS
878: