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_RATE_DETM_PKG dependencies on ZX_RATES_B

Line 20: p_tax_class IN zx_rates_b.tax_class%TYPE,

16: p_tax IN zx_taxes_b.tax%TYPE,
17: p_tax_determine_date IN DATE,
18: p_tax_status_code IN zx_status_b.tax_status_code%TYPE,
19: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
20: p_tax_class IN zx_rates_b.tax_class%TYPE,
21: p_tax_rate_code IN zx_rates_b.tax_rate_code%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_error_buffer OUT NOCOPY VARCHAR2
24: );

Line 21: p_tax_rate_code IN zx_rates_b.tax_rate_code%TYPE,

17: p_tax_determine_date IN DATE,
18: p_tax_status_code IN zx_status_b.tax_status_code%TYPE,
19: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
20: p_tax_class IN zx_rates_b.tax_class%TYPE,
21: p_tax_rate_code IN zx_rates_b.tax_rate_code%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_error_buffer OUT NOCOPY VARCHAR2
24: );
25:

Line 48: l_def_tax_rate_code zx_rates_b.tax_rate_code%TYPE;

44: p_error_buffer OUT NOCOPY VARCHAR2)
45: IS
46:
47: l_tax_id NUMBER;
48: l_def_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
49: l_Tax_Rate_Rule_Flag varchar2(1);
50: l_tax ZX_TAXES_B.tax%TYPE;
51: l_tax_status_code ZX_STATUS_B.tax_status_code%TYPE;
52: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;

Line 56: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;

52: l_tax_regime_code ZX_STATUS_B.tax_regime_code%TYPE;
53: l_tax_rate NUMBER;
54: l_tax_rate_id INTEGER;
55: l_def_tax_rate_id INTEGER;
56: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;
57: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
58: l_Rate_Type_Code zx_rates_b.Rate_Type_Code%TYPE;
59: l_def_rate_type zx_rates_b.Rate_Type_Code%TYPE;
60: l_percentage_rate zx_rates_b.percentage_rate%TYPE;

Line 58: l_Rate_Type_Code zx_rates_b.Rate_Type_Code%TYPE;

54: l_tax_rate_id INTEGER;
55: l_def_tax_rate_id INTEGER;
56: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;
57: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
58: l_Rate_Type_Code zx_rates_b.Rate_Type_Code%TYPE;
59: l_def_rate_type zx_rates_b.Rate_Type_Code%TYPE;
60: l_percentage_rate zx_rates_b.percentage_rate%TYPE;
61: l_def_percentage_rate zx_rates_b.percentage_rate%TYPE;
62: l_quantity_rate zx_rates_b.quantity_rate%TYPE;

Line 59: l_def_rate_type zx_rates_b.Rate_Type_Code%TYPE;

55: l_def_tax_rate_id INTEGER;
56: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;
57: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
58: l_Rate_Type_Code zx_rates_b.Rate_Type_Code%TYPE;
59: l_def_rate_type zx_rates_b.Rate_Type_Code%TYPE;
60: l_percentage_rate zx_rates_b.percentage_rate%TYPE;
61: l_def_percentage_rate zx_rates_b.percentage_rate%TYPE;
62: l_quantity_rate zx_rates_b.quantity_rate%TYPE;
63: l_def_quantity_rate zx_rates_b.quantity_rate%TYPE;

Line 60: l_percentage_rate zx_rates_b.percentage_rate%TYPE;

56: l_tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE;
57: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
58: l_Rate_Type_Code zx_rates_b.Rate_Type_Code%TYPE;
59: l_def_rate_type zx_rates_b.Rate_Type_Code%TYPE;
60: l_percentage_rate zx_rates_b.percentage_rate%TYPE;
61: l_def_percentage_rate zx_rates_b.percentage_rate%TYPE;
62: l_quantity_rate zx_rates_b.quantity_rate%TYPE;
63: l_def_quantity_rate zx_rates_b.quantity_rate%TYPE;
64: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;

Line 61: l_def_percentage_rate zx_rates_b.percentage_rate%TYPE;

57: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
58: l_Rate_Type_Code zx_rates_b.Rate_Type_Code%TYPE;
59: l_def_rate_type zx_rates_b.Rate_Type_Code%TYPE;
60: l_percentage_rate zx_rates_b.percentage_rate%TYPE;
61: l_def_percentage_rate zx_rates_b.percentage_rate%TYPE;
62: l_quantity_rate zx_rates_b.quantity_rate%TYPE;
63: l_def_quantity_rate zx_rates_b.quantity_rate%TYPE;
64: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
65: l_tax_date date;

Line 62: l_quantity_rate zx_rates_b.quantity_rate%TYPE;

58: l_Rate_Type_Code zx_rates_b.Rate_Type_Code%TYPE;
59: l_def_rate_type zx_rates_b.Rate_Type_Code%TYPE;
60: l_percentage_rate zx_rates_b.percentage_rate%TYPE;
61: l_def_percentage_rate zx_rates_b.percentage_rate%TYPE;
62: l_quantity_rate zx_rates_b.quantity_rate%TYPE;
63: l_def_quantity_rate zx_rates_b.quantity_rate%TYPE;
64: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
65: l_tax_date date;
66: l_zx_result_rec zx_process_results%ROWTYPE;

Line 63: l_def_quantity_rate zx_rates_b.quantity_rate%TYPE;

59: l_def_rate_type zx_rates_b.Rate_Type_Code%TYPE;
60: l_percentage_rate zx_rates_b.percentage_rate%TYPE;
61: l_def_percentage_rate zx_rates_b.percentage_rate%TYPE;
62: l_quantity_rate zx_rates_b.quantity_rate%TYPE;
63: l_def_quantity_rate zx_rates_b.quantity_rate%TYPE;
64: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
65: l_tax_date date;
66: l_zx_result_rec zx_process_results%ROWTYPE;
67: l_status_index NUMBER;

Line 64: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;

60: l_percentage_rate zx_rates_b.percentage_rate%TYPE;
61: l_def_percentage_rate zx_rates_b.percentage_rate%TYPE;
62: l_quantity_rate zx_rates_b.quantity_rate%TYPE;
63: l_def_quantity_rate zx_rates_b.quantity_rate%TYPE;
64: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
65: l_tax_date date;
66: l_zx_result_rec zx_process_results%ROWTYPE;
67: l_status_index NUMBER;
68: l_effective_from DATE;

Line 71: l_uom_code zx_rates_b.uom_code%TYPE;

67: l_status_index NUMBER;
68: l_effective_from DATE;
69: l_effective_to DATE;
70: l_adhoc_tax_rate_flg VARCHAR2(1);
71: l_uom_code zx_rates_b.uom_code%TYPE;
72: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
73: l_offset_status_code zx_rates_b.offset_status_code%TYPE;
74: l_offset_tax zx_rates_b.offset_tax%TYPE;
75: l_offset_tax_appl VARCHAR2(1);

Line 72: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;

68: l_effective_from DATE;
69: l_effective_to DATE;
70: l_adhoc_tax_rate_flg VARCHAR2(1);
71: l_uom_code zx_rates_b.uom_code%TYPE;
72: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
73: l_offset_status_code zx_rates_b.offset_status_code%TYPE;
74: l_offset_tax zx_rates_b.offset_tax%TYPE;
75: l_offset_tax_appl VARCHAR2(1);
76: l_ptp_id NUMBER;

Line 73: l_offset_status_code zx_rates_b.offset_status_code%TYPE;

69: l_effective_to DATE;
70: l_adhoc_tax_rate_flg VARCHAR2(1);
71: l_uom_code zx_rates_b.uom_code%TYPE;
72: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
73: l_offset_status_code zx_rates_b.offset_status_code%TYPE;
74: l_offset_tax zx_rates_b.offset_tax%TYPE;
75: l_offset_tax_appl VARCHAR2(1);
76: l_ptp_id NUMBER;
77: l_reg_party_type VARCHAR2(80);

Line 74: l_offset_tax zx_rates_b.offset_tax%TYPE;

70: l_adhoc_tax_rate_flg VARCHAR2(1);
71: l_uom_code zx_rates_b.uom_code%TYPE;
72: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
73: l_offset_status_code zx_rates_b.offset_status_code%TYPE;
74: l_offset_tax zx_rates_b.offset_tax%TYPE;
75: l_offset_tax_appl VARCHAR2(1);
76: l_ptp_id NUMBER;
77: l_reg_party_type VARCHAR2(80);
78: l_numeric_result zx_process_results.numeric_result%TYPE;

Line 83: l_allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE;

79:
80: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
81: l_exemption_rec ZX_TCM_GET_EXEMPT_PKG.exemption_rec_type;
82: l_exception_rec ZX_TCM_GET_EXCEPT_PKG.exception_rec_type;
83: l_allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE;
84: l_allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE;
85:
86: l_multiple_jurisdictions_flag VARCHAR2(1);
87:

Line 84: l_allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE;

80: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
81: l_exemption_rec ZX_TCM_GET_EXEMPT_PKG.exemption_rec_type;
82: l_exception_rec ZX_TCM_GET_EXCEPT_PKG.exception_rec_type;
83: l_allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE;
84: l_allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE;
85:
86: l_multiple_jurisdictions_flag VARCHAR2(1);
87:
88: l_tax_class zx_rates_b.tax_class%TYPE;

Line 88: l_tax_class zx_rates_b.tax_class%TYPE;

84: l_allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE;
85:
86: l_multiple_jurisdictions_flag VARCHAR2(1);
87:
88: l_tax_class zx_rates_b.tax_class%TYPE;
89: l_inventory_org_id NUMBER;
90:
91: TYPE exemption_info_type IS RECORD (
92: tax_regime_code zx_taxes_b.tax_regime_code%TYPE,

Line 719: -- rate_code found from the zx_rates_b table, but no

715:
716: END IF; -- l_tax_rate_code is NOT NULL
717:
718: IF l_tax_rate IS NULL THEN
719: -- rate_code found from the zx_rates_b table, but no
720: -- rate associated with the rate_code
721: p_return_status:= FND_API.G_RET_STS_ERROR; -- error
722: p_error_buffer := 'Error: No tax rate found';
723: IF (g_level_error >= g_current_runtime_level ) THEN

Line 1403: -- Allow_Adhoc_Tax_Rate_Flag moved to zx_rates_b table, g_tax_status_info_tbl changed accordingly

1399: -- Set appropriate message and return
1400: RETURN;
1401: ELSE
1402: -- bug fix 3420310
1403: -- Allow_Adhoc_Tax_Rate_Flag moved to zx_rates_b table, g_tax_status_info_tbl changed accordingly
1404: -- l_adhoc_tax_rate_flg :=
1405: -- ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;
1406: l_adhoc_tax_rate_flg :=
1407: ZX_TDS_UTILITIES_PKG.g_tax_status_info_tbl(l_status_index).Allow_Adhoc_Tax_Rate_Flag;

Line 1494: p_Rate_Type_Code in zx_rates_b.Rate_Type_Code%TYPE) IS

1490: p_tax_line_index in number,
1491: p_tax_rate_code in zx_lines.tax_rate_code%TYPE,
1492: p_tax_rate in zx_lines.tax_rate%TYPE,
1493: p_tax_rate_id in number,
1494: p_Rate_Type_Code in zx_rates_b.Rate_Type_Code%TYPE) IS
1495:
1496: begin
1497:
1498: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1546: p_tax_class IN zx_rates_b.tax_class%TYPE,

1542: p_tax IN zx_taxes_b.tax%TYPE,
1543: p_tax_determine_date IN DATE,
1544: p_tax_status_code IN zx_status_b.tax_status_code%TYPE,
1545: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
1546: p_tax_class IN zx_rates_b.tax_class%TYPE,
1547: p_tax_rate_code IN zx_rates_b.tax_rate_code%TYPE,
1548: x_return_status OUT NOCOPY VARCHAR2,
1549: x_error_buffer OUT NOCOPY VARCHAR2
1550: ) IS

Line 1547: p_tax_rate_code IN zx_rates_b.tax_rate_code%TYPE,

1543: p_tax_determine_date IN DATE,
1544: p_tax_status_code IN zx_status_b.tax_status_code%TYPE,
1545: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
1546: p_tax_class IN zx_rates_b.tax_class%TYPE,
1547: p_tax_rate_code IN zx_rates_b.tax_rate_code%TYPE,
1548: x_return_status OUT NOCOPY VARCHAR2,
1549: x_error_buffer OUT NOCOPY VARCHAR2
1550: ) IS
1551:

Line 1554: (c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,

1550: ) IS
1551:
1552: /* Bug#5417753- use cache structure
1553: CURSOR get_offset_info_csr
1554: (c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
1555: c_tax ZX_TAXES_B.TAX%TYPE,
1556: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
1557: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
1558: c_tax_determine_date ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE)