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

Line 1230: l_tax_class ZX_RATES_B.tax_class%TYPE;

1226: l_current_line_amt zx_lines.line_amt%TYPE;
1227: l_rownum BINARY_INTEGER;
1228: l_error_buffer VARCHAR2(200);
1229:
1230: l_tax_class ZX_RATES_B.tax_class%TYPE;
1231:
1232: -- bug fix 5525890
1233: l_tax_amt_included_flag_usr zx_lines.tax_amt_included_flag%TYPE;
1234: l_self_assessed_flag_usr zx_lines.self_assessed_flag%TYPE;

Line 2323: l_tax_class zx_rates_b.tax_class%TYPE;

2319:
2320: l_jurisdictions_found VARCHAR2(1);
2321: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
2322: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
2323: l_tax_class zx_rates_b.tax_class%TYPE;
2324: l_temp_num NUMBER;
2325:
2326: -- cursor to order the jurisdictions in the GT
2327: CURSOR c_get_jurisdiction_from_gt(

Line 2464: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,

2460: Bug 4959835*/
2461:
2462: -- bug 4728374
2463: CURSOR check_product_family_group_csr(
2464: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2465: c_tax zx_rates_b.tax%TYPE,
2466: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2467: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2468: c_tax_class zx_rates_b.tax_class%TYPE) IS

Line 2465: c_tax zx_rates_b.tax%TYPE,

2461:
2462: -- bug 4728374
2463: CURSOR check_product_family_group_csr(
2464: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2465: c_tax zx_rates_b.tax%TYPE,
2466: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2467: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2468: c_tax_class zx_rates_b.tax_class%TYPE) IS
2469: SELECT 1

Line 2466: c_tax_status_code zx_rates_b.tax_status_code%TYPE,

2462: -- bug 4728374
2463: CURSOR check_product_family_group_csr(
2464: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2465: c_tax zx_rates_b.tax%TYPE,
2466: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2467: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2468: c_tax_class zx_rates_b.tax_class%TYPE) IS
2469: SELECT 1
2470: FROM ZX_SCO_RATES_B_V

Line 2467: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,

2463: CURSOR check_product_family_group_csr(
2464: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2465: c_tax zx_rates_b.tax%TYPE,
2466: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2467: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2468: c_tax_class zx_rates_b.tax_class%TYPE) IS
2469: SELECT 1
2470: FROM ZX_SCO_RATES_B_V
2471: WHERE effective_from <= p_tax_determine_date

Line 2468: c_tax_class zx_rates_b.tax_class%TYPE) IS

2464: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2465: c_tax zx_rates_b.tax%TYPE,
2466: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2467: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2468: c_tax_class zx_rates_b.tax_class%TYPE) IS
2469: SELECT 1
2470: FROM ZX_SCO_RATES_B_V
2471: WHERE effective_from <= p_tax_determine_date
2472: AND (effective_to >= p_tax_determine_date OR effective_to IS NULL )

Line 6446: l_tax_class zx_rates_b.tax_class%TYPE;

6442:
6443: l_jurisdiction_id NUMBER;
6444: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6445:
6446: l_tax_class zx_rates_b.tax_class%TYPE;
6447:
6448: BEGIN
6449:
6450: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 7063: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

7059: AND zxl.cancel_flag <> 'Y'
7060: AND zxl.mrc_tax_line_flag = 'N';
7061:
7062: CURSOR is_tax_migrated_in_ar_csr(
7063: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
7064: SELECT tax_regime_code,
7065: tax,
7066: tax_status_code,
7067: record_type_code,

Line 7070: FROM zx_rates_b

7066: tax_status_code,
7067: record_type_code,
7068: offset_tax_rate_code,
7069: tax_jurisdiction_code
7070: FROM zx_rates_b
7071: WHERE tax_rate_id = c_tax_rate_id
7072: AND active_flag = 'Y';
7073:
7074: CURSOR get_tax_info_f_ap_input

Line 7075: (c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS

7071: WHERE tax_rate_id = c_tax_rate_id
7072: AND active_flag = 'Y';
7073:
7074: CURSOR get_tax_info_f_ap_input
7075: (c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
7076: SELECT tax_regime_code,
7077: tax,
7078: tax_status_code,
7079: tax_jurisdiction_code

Line 7089: (c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS

7085: AND active_flag = 'Y'
7086: ORDER BY subscription_level_code;
7087:
7088: CURSOR get_tax_info_f_ap_null
7089: (c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
7090: SELECT tax_regime_code,
7091: tax,
7092: tax_status_code,
7093: tax_jurisdiction_code

Line 7103: (c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS

7099: AND active_flag = 'Y'
7100: ORDER BY subscription_level_code;
7101:
7102: CURSOR get_tax_info_f_not_ap
7103: (c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
7104: SELECT tax_regime_code,
7105: tax,
7106: tax_status_code,
7107: tax_jurisdiction_code

Line 7127: l_record_type_code zx_rates_b.record_type_code%TYPE;

7123: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7124: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7125: l_tax zx_taxes_b.tax%TYPE;
7126: l_tax_status_code zx_status_b.tax_status_code%TYPE;
7127: l_record_type_code zx_rates_b.record_type_code%TYPE;
7128: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
7129: l_tax_found_in_ap_flag VARCHAR2(1);
7130:
7131: l_tax_class zx_rates_b.tax_class%TYPE;

Line 7128: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;

7124: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7125: l_tax zx_taxes_b.tax%TYPE;
7126: l_tax_status_code zx_status_b.tax_status_code%TYPE;
7127: l_record_type_code zx_rates_b.record_type_code%TYPE;
7128: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
7129: l_tax_found_in_ap_flag VARCHAR2(1);
7130:
7131: l_tax_class zx_rates_b.tax_class%TYPE;
7132: l_is_valid BOOLEAN;

Line 7131: l_tax_class zx_rates_b.tax_class%TYPE;

7127: l_record_type_code zx_rates_b.record_type_code%TYPE;
7128: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
7129: l_tax_found_in_ap_flag VARCHAR2(1);
7130:
7131: l_tax_class zx_rates_b.tax_class%TYPE;
7132: l_is_valid BOOLEAN;
7133:
7134: BEGIN
7135:

Line 7956: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,

7952: -- AND tc.org_id = c_internal_organization_id;
7953:
7954: CURSOR get_candidate_taxes_csr(
7955: c_condition_group_code zx_condition_groups_b.condition_group_code%TYPE,
7956: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
7957: c_tax_class zx_rates_b.tax_class%TYPE,
7958: c_tax_determine_date DATE) IS
7959: SELECT /*+ leading(PR) use_nl(RL) */
7960: rl.tax_regime_code,

Line 7957: c_tax_class zx_rates_b.tax_class%TYPE,

7953:
7954: CURSOR get_candidate_taxes_csr(
7955: c_condition_group_code zx_condition_groups_b.condition_group_code%TYPE,
7956: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
7957: c_tax_class zx_rates_b.tax_class%TYPE,
7958: c_tax_determine_date DATE) IS
7959: SELECT /*+ leading(PR) use_nl(RL) */
7960: rl.tax_regime_code,
7961: rl.tax,

Line 8022: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,

8018:
8019: -- To filter based on rate class
8020: --
8021: CURSOR check_tax_rate_class_csr(
8022: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8023: c_tax zx_rates_b.tax%TYPE,
8024: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8025: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8026: c_tax_class zx_rates_b.tax_class%TYPE,

Line 8023: c_tax zx_rates_b.tax%TYPE,

8019: -- To filter based on rate class
8020: --
8021: CURSOR check_tax_rate_class_csr(
8022: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8023: c_tax zx_rates_b.tax%TYPE,
8024: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8025: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8026: c_tax_class zx_rates_b.tax_class%TYPE,
8027: c_tax_determine_date DATE) IS

Line 8024: c_tax_status_code zx_rates_b.tax_status_code%TYPE,

8020: --
8021: CURSOR check_tax_rate_class_csr(
8022: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8023: c_tax zx_rates_b.tax%TYPE,
8024: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8025: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8026: c_tax_class zx_rates_b.tax_class%TYPE,
8027: c_tax_determine_date DATE) IS
8028: SELECT 1

Line 8025: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,

8021: CURSOR check_tax_rate_class_csr(
8022: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8023: c_tax zx_rates_b.tax%TYPE,
8024: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8025: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8026: c_tax_class zx_rates_b.tax_class%TYPE,
8027: c_tax_determine_date DATE) IS
8028: SELECT 1
8029: FROM ZX_SCO_RATES_B_V

Line 8026: c_tax_class zx_rates_b.tax_class%TYPE,

8022: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8023: c_tax zx_rates_b.tax%TYPE,
8024: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8025: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8026: c_tax_class zx_rates_b.tax_class%TYPE,
8027: c_tax_determine_date DATE) IS
8028: SELECT 1
8029: FROM ZX_SCO_RATES_B_V
8030: WHERE tax_regime_code = c_tax_regime_code

Line 8134: l_tax_class zx_rates_b.tax_class%TYPE;

8130: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8131: l_error_buffer VARCHAR2(200);
8132: l_rownum BINARY_INTEGER;
8133: l_curr_rownum BINARY_INTEGER;
8134: l_tax_class zx_rates_b.tax_class%TYPE;
8135: l_temp_num NUMBER;
8136: l_jurisdictions_found VARCHAR2(1);
8137: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
8138: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;

Line 9463: l_tax_class zx_rates_b.tax_class%TYPE;

9459: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
9460: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
9461: l_error_buffer VARCHAR2(200);
9462:
9463: l_tax_class zx_rates_b.tax_class%TYPE;
9464:
9465:
9466: CURSOR get_key_columns_cur IS
9467: SELECT * FROM zx_lines