[Home] [Help]
2134: b. If yes, check the current threshold slab
2135: c. If threshold up (not null threshold_slab_id) then derrive the tax_category_id attached
2136: in the threshold setup for the slab
2137: d. Based on the tax category (p_threshold_tax_cat_id) defaul the additional taxes by calling
2138: JAI_RGM_THHOLD_PROC_PKG.DEFAULT_THHOLD_TAXES
2139: e. Added the call to jai_ar_tcs_rep_pkg.wsh_interim_accounting to do the interim accounting for TCS type of taxes.
2140:
2141: 28. 16/Apr/2007 Bgowrava for forward porting bug#5989740 11i Bug#5907436 - File version
2142: ENH : HANDLING SECONDARY AND HIGHER EDUCATION CESS
2164: When comparing the register balance, the amount in INR is not compared. Instead the amount in the Fc is compared.
2165: This has been corrected by multiplying the v_tot_excise_amt with the currency conversion factor.
2166:
2167: 31. 16/10/2007 CSahoo for bug#6498072, File Version 120.8
2168: Modified the p_assessable_value parameter during call to JAI_RGM_THHOLD_PROC_PKG.DEFAULT_THHOLD_TAXES
2169: p_assessable_value => nvl(v_assessable_value * v_shipped_quantity, 0)
2170: Moved cursor uom_code to the start of the loop to fetch v_order_quantity_uom
2171:
2172: 32. 16/10/2008 CSahoo for bug#5189432, File Version 120.9.12010000.2
2781: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
2782: fetch c_get_regime_id into ln_tcs_regime_id;
2783: close c_get_regime_id;
2784: /* Find out what is the current slab */
2785: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Get threshold_slab_id. Before calling JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');*/ --commented by bgowrava for bug#5631784
2786: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2787: (
2788: p_regime_id => ln_tcs_regime_id
2789: , p_organization_id => v_organization_id
2782: fetch c_get_regime_id into ln_tcs_regime_id;
2783: close c_get_regime_id;
2784: /* Find out what is the current slab */
2785: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Get threshold_slab_id. Before calling JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');*/ --commented by bgowrava for bug#5631784
2786: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2787: (
2788: p_regime_id => ln_tcs_regime_id
2789: , p_organization_id => v_organization_id
2790: , p_party_type => jai_constants.party_type_customer
2794: , p_threshold_slab_id => ln_threshold_slab_id
2795: , p_process_flag => lv_process_flag
2796: , p_process_message => lv_process_message
2797: );
2798: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Process Result for JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');
2799: jai_cmn_debug_contexts_pkg.print (ln_reg_id,
2800: 'lv_process_flag =' ||lv_process_flag||chr(10)
2801: ||'lv_process_message =' ||lv_process_message
2802: ); */ --commented by bgowrava for bug#5631784
2810: end if;
2811:
2812: if ln_threshold_slab_id is not null then
2813: /* Threshold level is up. Surcharge needs to be defaulted , so find out the tax category based on the threshold slab */
2814: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
2815: (
2816: p_threshold_slab_id => ln_threshold_slab_id
2817: , p_org_id => v_org_id
2818: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2819: , p_process_flag => lv_process_flag
2820: , p_process_message => lv_process_message
2821: );
2822:
2823: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Process Result for JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
2824: jai_cmn_debug_contexts_pkg.print (ln_reg_id
2825: ,'lv_process_flag =' ||lv_process_flag||chr(10)
2826: ||'lv_process_message =' ||lv_process_message
2827: ); */ --commented by bgowrava for bug#5631784
2851: and jtc.tax_type = jai_constants.tax_type_tcs;
2852:
2853: /*
2854: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
2855: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
2856: || into the JAI_OM_WSH_LINE_TAXES table
2857: */
2858:
2859: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling JAI_RGM_THHOLD_PROC_PKG.DEFAULT_THHOLD_TAXES');*/ --commented by bgowrava for bug#5631784
2855: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
2856: || into the JAI_OM_WSH_LINE_TAXES table
2857: */
2858:
2859: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling JAI_RGM_THHOLD_PROC_PKG.DEFAULT_THHOLD_TAXES');*/ --commented by bgowrava for bug#5631784
2860:
2861: -- ln_vat_assessable_value := nvl(ln_vat_assessable_value * v_shipped_quantity / v_quantity, 0); /* By mmurtuza for bug 13793843 */
2862: /*Commented above by mmurtuza for bug 16396199 and added it before checking for TCS taxes, as VAT assessable value should be proportioned for all tax types*/
2863:
2860:
2861: -- ln_vat_assessable_value := nvl(ln_vat_assessable_value * v_shipped_quantity / v_quantity, 0); /* By mmurtuza for bug 13793843 */
2862: /*Commented above by mmurtuza for bug 16396199 and added it before checking for TCS taxes, as VAT assessable value should be proportioned for all tax types*/
2863:
2864: jai_rgm_thhold_proc_pkg.default_thhold_taxes
2865: (
2866: p_source_trx_id => ''
2867: , p_source_trx_line_id => v_delivery_detail_id
2868: , p_source_event => jai_constants.source_ttype_delivery
2881: , p_process_flag => lv_process_flag
2882: , p_process_message => lv_process_message
2883: );
2884:
2885: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Process Result for JAI_RGM_THHOLD_PROC_PKG.DEFAULT_THHOLD_TAXES');
2886: jai_cmn_debug_contexts_pkg.print (ln_reg_id
2887: ,'lv_process_flag =' ||lv_process_flag||chr(10)
2888: ||'lv_process_message =' ||lv_process_message
2889: ); */ --commented by bgowrava for bug#5631784