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 2381: l_tax_class zx_rates_b.tax_class%TYPE;

2377:
2378: l_jurisdictions_found VARCHAR2(1);
2379: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
2380: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
2381: l_tax_class zx_rates_b.tax_class%TYPE;
2382: l_temp_num NUMBER;
2383:
2384: -- Added for bug 10184087 --
2385: l_ref_doc_tax_applicable BOOLEAN;

Line 2406: CURSOR get_all_taxes_for_regime_cur(c_tax_class zx_rates_b.tax_class%TYPE) IS

2402: ORDER BY precedence_level;
2403:
2404: -- This cursor gets all the taxes for a regime
2405: --
2406: CURSOR get_all_taxes_for_regime_cur(c_tax_class zx_rates_b.tax_class%TYPE) IS
2407: SELECT tax_id,
2408: tax,
2409: tax_regime_code,
2410: tax_type_code,

Line 2534: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,

2530: Bug 4959835*/
2531:
2532: -- bug 4728374
2533: CURSOR check_product_family_group_csr(
2534: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2535: c_tax zx_rates_b.tax%TYPE,
2536: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2537: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2538: c_tax_class zx_rates_b.tax_class%TYPE) IS

Line 2535: c_tax zx_rates_b.tax%TYPE,

2531:
2532: -- bug 4728374
2533: CURSOR check_product_family_group_csr(
2534: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2535: c_tax zx_rates_b.tax%TYPE,
2536: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2537: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2538: c_tax_class zx_rates_b.tax_class%TYPE) IS
2539: SELECT 1

Line 2536: c_tax_status_code zx_rates_b.tax_status_code%TYPE,

2532: -- bug 4728374
2533: CURSOR check_product_family_group_csr(
2534: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2535: c_tax zx_rates_b.tax%TYPE,
2536: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2537: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2538: c_tax_class zx_rates_b.tax_class%TYPE) IS
2539: SELECT 1
2540: FROM ZX_SCO_RATES_B_V

Line 2537: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,

2533: CURSOR check_product_family_group_csr(
2534: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2535: c_tax zx_rates_b.tax%TYPE,
2536: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2537: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2538: c_tax_class zx_rates_b.tax_class%TYPE) IS
2539: SELECT 1
2540: FROM ZX_SCO_RATES_B_V
2541: WHERE effective_from <= p_tax_determine_date

Line 2538: c_tax_class zx_rates_b.tax_class%TYPE) IS

2534: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
2535: c_tax zx_rates_b.tax%TYPE,
2536: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
2537: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
2538: c_tax_class zx_rates_b.tax_class%TYPE) IS
2539: SELECT 1
2540: FROM ZX_SCO_RATES_B_V
2541: WHERE effective_from <= p_tax_determine_date
2542: AND (effective_to >= p_tax_determine_date OR effective_to IS NULL )

Line 6948: l_tax_class zx_rates_b.tax_class%TYPE;

6944:
6945: l_jurisdiction_id NUMBER;
6946: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6947:
6948: l_tax_class zx_rates_b.tax_class%TYPE;
6949: l_tmp_tax_apportionmt_ln_num NUMBER; -- Added for Bug 10184087
6950:
6951: BEGIN
6952:

Line 7606: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

7602: AND zxl.cancel_flag <> 'Y'
7603: AND zxl.mrc_tax_line_flag = 'N';
7604:
7605: CURSOR is_tax_migrated_in_ar_csr(
7606: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
7607: SELECT tax_regime_code,
7608: tax,
7609: tax_status_code,
7610: record_type_code,

Line 7613: FROM zx_rates_b

7609: tax_status_code,
7610: record_type_code,
7611: offset_tax_rate_code,
7612: tax_jurisdiction_code
7613: FROM zx_rates_b
7614: WHERE tax_rate_id = c_tax_rate_id
7615: AND active_flag = 'Y';
7616:
7617: CURSOR get_tax_info_f_ap_input

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

7614: WHERE tax_rate_id = c_tax_rate_id
7615: AND active_flag = 'Y';
7616:
7617: CURSOR get_tax_info_f_ap_input
7618: (c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
7619: SELECT tax_regime_code,
7620: tax,
7621: tax_status_code,
7622: tax_jurisdiction_code

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

7628: AND active_flag = 'Y'
7629: ORDER BY subscription_level_code;
7630:
7631: CURSOR get_tax_info_f_ap_null
7632: (c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
7633: SELECT tax_regime_code,
7634: tax,
7635: tax_status_code,
7636: tax_jurisdiction_code

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

7642: AND active_flag = 'Y'
7643: ORDER BY subscription_level_code;
7644:
7645: CURSOR get_tax_info_f_not_ap
7646: (c_tax_rate_code zx_rates_b.tax_rate_code%TYPE) IS
7647: SELECT tax_regime_code,
7648: tax,
7649: tax_status_code,
7650: tax_jurisdiction_code

Line 7670: l_record_type_code zx_rates_b.record_type_code%TYPE;

7666: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE;
7667: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7668: l_tax zx_taxes_b.tax%TYPE;
7669: l_tax_status_code zx_status_b.tax_status_code%TYPE;
7670: l_record_type_code zx_rates_b.record_type_code%TYPE;
7671: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
7672: l_tax_found_in_ap_flag VARCHAR2(1);
7673:
7674: l_tax_class zx_rates_b.tax_class%TYPE;

Line 7671: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;

7667: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
7668: l_tax zx_taxes_b.tax%TYPE;
7669: l_tax_status_code zx_status_b.tax_status_code%TYPE;
7670: l_record_type_code zx_rates_b.record_type_code%TYPE;
7671: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
7672: l_tax_found_in_ap_flag VARCHAR2(1);
7673:
7674: l_tax_class zx_rates_b.tax_class%TYPE;
7675: l_is_valid BOOLEAN;

Line 7674: l_tax_class zx_rates_b.tax_class%TYPE;

7670: l_record_type_code zx_rates_b.record_type_code%TYPE;
7671: l_offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE;
7672: l_tax_found_in_ap_flag VARCHAR2(1);
7673:
7674: l_tax_class zx_rates_b.tax_class%TYPE;
7675: l_is_valid BOOLEAN;
7676: l_count NUMBER;
7677:
7678: BEGIN

Line 8593: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,

8589: -- AND tc.org_id = c_internal_organization_id;
8590:
8591: CURSOR get_candidate_taxes_csr(
8592: c_condition_group_code zx_condition_groups_b.condition_group_code%TYPE,
8593: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8594: c_tax_class zx_rates_b.tax_class%TYPE,
8595: c_tax_determine_date DATE) IS
8596: SELECT tax_regime_code,
8597: tax,

Line 8594: c_tax_class zx_rates_b.tax_class%TYPE,

8590:
8591: CURSOR get_candidate_taxes_csr(
8592: c_condition_group_code zx_condition_groups_b.condition_group_code%TYPE,
8593: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8594: c_tax_class zx_rates_b.tax_class%TYPE,
8595: c_tax_determine_date DATE) IS
8596: SELECT tax_regime_code,
8597: tax,
8598: status_result,

Line 8684: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,

8680:
8681: -- To filter based on rate class
8682: --
8683: CURSOR check_tax_rate_class_csr(
8684: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8685: c_tax zx_rates_b.tax%TYPE,
8686: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8687: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8688: c_tax_class zx_rates_b.tax_class%TYPE,

Line 8685: c_tax zx_rates_b.tax%TYPE,

8681: -- To filter based on rate class
8682: --
8683: CURSOR check_tax_rate_class_csr(
8684: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8685: c_tax zx_rates_b.tax%TYPE,
8686: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8687: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8688: c_tax_class zx_rates_b.tax_class%TYPE,
8689: c_tax_determine_date DATE) IS

Line 8686: c_tax_status_code zx_rates_b.tax_status_code%TYPE,

8682: --
8683: CURSOR check_tax_rate_class_csr(
8684: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8685: c_tax zx_rates_b.tax%TYPE,
8686: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8687: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8688: c_tax_class zx_rates_b.tax_class%TYPE,
8689: c_tax_determine_date DATE) IS
8690: SELECT 1

Line 8687: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,

8683: CURSOR check_tax_rate_class_csr(
8684: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8685: c_tax zx_rates_b.tax%TYPE,
8686: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8687: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8688: c_tax_class zx_rates_b.tax_class%TYPE,
8689: c_tax_determine_date DATE) IS
8690: SELECT 1
8691: FROM ZX_SCO_RATES_B_V

Line 8688: c_tax_class zx_rates_b.tax_class%TYPE,

8684: c_tax_regime_code zx_rates_b.tax_regime_code%TYPE,
8685: c_tax zx_rates_b.tax%TYPE,
8686: c_tax_status_code zx_rates_b.tax_status_code%TYPE,
8687: c_tax_rate_code zx_rates_b.tax_rate_code%TYPE,
8688: c_tax_class zx_rates_b.tax_class%TYPE,
8689: c_tax_determine_date DATE) IS
8690: SELECT 1
8691: FROM ZX_SCO_RATES_B_V
8692: WHERE tax_regime_code = c_tax_regime_code

Line 8796: l_tax_class zx_rates_b.tax_class%TYPE;

8792: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
8793: l_error_buffer VARCHAR2(200);
8794: l_rownum BINARY_INTEGER;
8795: l_curr_rownum BINARY_INTEGER;
8796: l_tax_class zx_rates_b.tax_class%TYPE;
8797: l_temp_num NUMBER;
8798: l_jurisdictions_found VARCHAR2(1);
8799: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
8800: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;

Line 10206: l_tax_class zx_rates_b.tax_class%TYPE;

10202: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
10203: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
10204: l_error_buffer VARCHAR2(200);
10205:
10206: l_tax_class zx_rates_b.tax_class%TYPE;
10207:
10208:
10209: CURSOR get_key_columns_cur IS
10210: SELECT * FROM zx_lines