DBA Data[Home] [Help]

APPS.JMF_GTA_TRX_UTIL dependencies on ZX_REGISTRATIONS

Line 2465: l_tp_registration_number zx_registrations.registration_number%TYPE;

2461: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
2462: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
2463: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
2464: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
2465: l_tp_registration_number zx_registrations.registration_number%TYPE;
2466: l_fp_reg_number_count NUMBER;
2467: l_amount zx_lines.taxable_amt%TYPE;
2468: l_currency_code VARCHAR2(30);
2469: l_error_string VARCHAR2(500);

Line 2802: l_tax_registration_number zx_registrations.registration_number%TYPE;

2798: l_tax zx_lines.tax%TYPE;
2799: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2800: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
2801: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
2802: l_tax_registration_number zx_registrations.registration_number%TYPE;
2803: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;
2804: l_reg_tax zx_registrations.tax%TYPE;
2805: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;
2806:

Line 2803: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;

2799: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2800: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
2801: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
2802: l_tax_registration_number zx_registrations.registration_number%TYPE;
2803: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;
2804: l_reg_tax zx_registrations.tax%TYPE;
2805: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;
2806:
2807: l_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;

Line 2804: l_reg_tax zx_registrations.tax%TYPE;

2800: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
2801: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
2802: l_tax_registration_number zx_registrations.registration_number%TYPE;
2803: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;
2804: l_reg_tax zx_registrations.tax%TYPE;
2805: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;
2806:
2807: l_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2808: l_party_site_id hz_cust_acct_sites_all.party_site_id%TYPE;

Line 2805: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;

2801: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
2802: l_tax_registration_number zx_registrations.registration_number%TYPE;
2803: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;
2804: l_reg_tax zx_registrations.tax%TYPE;
2805: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;
2806:
2807: l_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2808: l_party_site_id hz_cust_acct_sites_all.party_site_id%TYPE;
2809:

Line 2813: l_tp_registration_number zx_registrations.registration_number%TYPE;

2809:
2810: l_tax_registration_count NUMBER;
2811: l_tax_profile_status NUMBER;
2812:
2813: l_tp_registration_number zx_registrations.registration_number%TYPE;
2814: l_tp_registration_number_a zx_registrations.registration_number%TYPE;
2815: l_tp_registration_number_b zx_registrations.registration_number%TYPE;
2816: l_tp_registration_number_c zx_registrations.registration_number%TYPE;
2817:

Line 2814: l_tp_registration_number_a zx_registrations.registration_number%TYPE;

2810: l_tax_registration_count NUMBER;
2811: l_tax_profile_status NUMBER;
2812:
2813: l_tp_registration_number zx_registrations.registration_number%TYPE;
2814: l_tp_registration_number_a zx_registrations.registration_number%TYPE;
2815: l_tp_registration_number_b zx_registrations.registration_number%TYPE;
2816: l_tp_registration_number_c zx_registrations.registration_number%TYPE;
2817:
2818: l_return_status VARCHAR2(200);

Line 2815: l_tp_registration_number_b zx_registrations.registration_number%TYPE;

2811: l_tax_profile_status NUMBER;
2812:
2813: l_tp_registration_number zx_registrations.registration_number%TYPE;
2814: l_tp_registration_number_a zx_registrations.registration_number%TYPE;
2815: l_tp_registration_number_b zx_registrations.registration_number%TYPE;
2816: l_tp_registration_number_c zx_registrations.registration_number%TYPE;
2817:
2818: l_return_status VARCHAR2(200);
2819: l_msg_count NUMBER;

Line 2816: l_tp_registration_number_c zx_registrations.registration_number%TYPE;

2812:
2813: l_tp_registration_number zx_registrations.registration_number%TYPE;
2814: l_tp_registration_number_a zx_registrations.registration_number%TYPE;
2815: l_tp_registration_number_b zx_registrations.registration_number%TYPE;
2816: l_tp_registration_number_c zx_registrations.registration_number%TYPE;
2817:
2818: l_return_status VARCHAR2(200);
2819: l_msg_count NUMBER;
2820: l_msg_data VARCHAR2(2000);

Line 2843: zx_registrations reg

2839: ,l_reg_tax_regime_code
2840: ,l_reg_tax
2841: ,l_reg_tax_jursidiction_code
2842: FROM
2843: zx_registrations reg
2844: WHERE reg.party_tax_profile_id =p_party_tax_profile_id
2845: AND (reg.tax is NULL or reg.tax = p_tax)
2846: AND reg.tax_regime_code = p_tax_regime_code -- tax_regime_code is not null
2847: AND (reg.tax_jurisdiction_code is NULL or reg.tax_jurisdiction_code = p_tax_jurisdiction_code)

Line 3181: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;

3177: l_tax_type_code zx_lines.tax_type_code%TYPE;
3178: l_tax_rate NUMBER;
3179: l_gt_currency_code fnd_currencies.currency_code%TYPE;
3180: l_tax_line_id zx_lines.tax_line_id%TYPE;
3181: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;
3182: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
3183:
3184:
3185: CURSOR c_tax_type_code