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_TAXES_B

Line 6: p_tax IN ZX_TAXES_B.TAX%TYPE,

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,
10: p_tax_jurisdiction_code IN ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE,

Line 33: p_tax IN ZX_TAXES_B.TAX%TYPE,

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

Line 42: p_tax IN ZX_TAXES_B.TAX%TYPE,

38: p_error_buffer OUT NOCOPY VARCHAR2);
39:
40: PROCEDURE get_tax_id(
41: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
42: p_tax IN ZX_TAXES_B.TAX%TYPE,
43: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
44: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,
45: p_return_status OUT NOCOPY VARCHAR2,
46: p_error_buffer OUT NOCOPY VARCHAR2);

Line 44: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,

40: PROCEDURE get_tax_id(
41: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
42: p_tax IN ZX_TAXES_B.TAX%TYPE,
43: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
44: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,
45: p_return_status OUT NOCOPY VARCHAR2,
46: p_error_buffer OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE get_old_offset_tax_line_id(

Line 62: p_offset_tax IN ZX_TAXES_B.TAX%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,
64: p_return_status OUT NOCOPY VARCHAR2,
65: p_error_buffer OUT NOCOPY VARCHAR2);
66:

Line 92: l_offset_tax ZX_TAXES_B.TAX%TYPE;

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

Line 250: p_tax IN ZX_TAXES_B.TAX%TYPE,

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,
254: p_tax_jurisdiction_code IN ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE,

Line 270: c_tax ZX_TAXES_B.TAX%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)
274: IS

Line 497: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;

493: p_return_status OUT NOCOPY VARCHAR2,
494: p_error_buffer OUT NOCOPY VARCHAR2
495: )
496: IS
497: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;
498: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
499: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
500: BEGIN
501: IF (g_level_statement >= g_current_runtime_level) THEN

Line 498: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

494: p_error_buffer OUT NOCOPY VARCHAR2
495: )
496: IS
497: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;
498: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
499: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
500: BEGIN
501: IF (g_level_statement >= g_current_runtime_level) THEN
502: FND_LOG.STRING(g_level_statement,

Line 499: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;

495: )
496: IS
497: l_tax_id ZX_TAXES_B.TAX_ID%TYPE;
498: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
499: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
500: BEGIN
501: IF (g_level_statement >= g_current_runtime_level) THEN
502: FND_LOG.STRING(g_level_statement,
503: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.BEGIN',

Line 671: p_tax IN ZX_TAXES_B.TAX%TYPE,

667: -- tax regime code, tax and tax status code
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,

Line 725: -- This procedure gets tax id from zx_taxes based on

721: -- PRIVATE PROCEDURE
722: -- get_tax_id
723: --
724: -- DESCRIPTION
725: -- This procedure gets tax id from zx_taxes based on
726: -- tax regime code and tax
727: --
728: PROCEDURE get_tax_id(
729: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,

Line 730: p_tax IN ZX_TAXES_B.TAX%TYPE,

726: -- tax regime code and tax
727: --
728: PROCEDURE get_tax_id(
729: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
730: p_tax IN ZX_TAXES_B.TAX%TYPE,
731: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
732: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,
733: p_return_status OUT NOCOPY VARCHAR2,
734: p_error_buffer OUT NOCOPY VARCHAR2)

Line 732: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,

728: PROCEDURE get_tax_id(
729: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
730: p_tax IN ZX_TAXES_B.TAX%TYPE,
731: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
732: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,
733: p_return_status OUT NOCOPY VARCHAR2,
734: p_error_buffer OUT NOCOPY VARCHAR2)
735:
736: IS

Line 875: p_offset_tax IN ZX_TAXES_B.TAX%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,
877: p_return_status OUT NOCOPY VARCHAR2,
878: p_error_buffer OUT NOCOPY VARCHAR2)
879: IS