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 252: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

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,
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,

Line 272: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

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)
274: IS
275:
276: SELECT tax_rate_id,

Line 672: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

668: --
669: PROCEDURE get_tax_status_id(
670: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
671: p_tax IN ZX_TAXES_B.TAX%TYPE,
672: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
673: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
674: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,
675: p_return_status OUT NOCOPY VARCHAR2,
676: p_error_buffer OUT NOCOPY VARCHAR2)

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

670: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
671: p_tax IN ZX_TAXES_B.TAX%TYPE,
672: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
673: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
674: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,
675: p_return_status OUT NOCOPY VARCHAR2,
676: p_error_buffer OUT NOCOPY VARCHAR2)
677:
678: IS

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