[Home] [Help]
2211: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
2212: fetch c_get_regime_id into ln_tcs_regime_id;
2213: close c_get_regime_id;
2214: /* Find out what is the current slab */
2215: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2216: (
2217: p_regime_id => ln_tcs_regime_id
2218: , p_organization_id => ln_inv_orgn_id
2219: , p_party_type => jai_constants.party_type_customer
2233: );
2234: end if;
2235: if ln_threshold_slab_id is not null then
2236: /* Threshold level is up. Surcharge needs to be defaulted , so find out the tax category based on the threshold slab */
2237: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
2238: (
2239: p_threshold_slab_id => ln_threshold_slab_id
2240: , p_org_id => v_org_id
2241: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2263: and jrctt.tax_id = jtc.tax_id
2264: and jtc.tax_type = jai_constants.tax_type_tcs;
2265: /*
2266: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
2267: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
2268: || into the ja_in_so_picking_tax_lines table
2269: */
2270: jai_rgm_thhold_proc_pkg.default_thhold_taxes
2271: (
2266: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
2267: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
2268: || into the ja_in_so_picking_tax_lines table
2269: */
2270: jai_rgm_thhold_proc_pkg.default_thhold_taxes
2271: (
2272: p_source_trx_id => ''
2273: , p_source_trx_line_id => v_customer_trx_line_id
2274: , p_source_event => jai_constants.bill_only_invoice
2636:
2637: 34. 28-Jun-2007 CSahoo for bug#6155839, File Version 120.16
2638: replaced RG Register Data Entry by jai_constants.je_category_rg_entry
2639: 35. 16-oCT-2007 CSahoo for bug#6498072, File Version 120.21
2640: Multipled p_quantity to the assesible value in the call to the procedure jai_rgm_thhold_proc_pkg.default_thhold_taxes
2641:
2642: 36. 18-OCT-2007 CSahoo for bug#6498072, File Version 120.22
2643: Added the cursor get_ar_tax_amount to get the total tax amount from JAI_AR_TRX_TAX_LINES table.
2644: Moved the code for Inserting into JAI_AR_TRX_LINES and updating the table JAI_AR_TRXS to the end in the procedure
5336: open gc_get_regime_id ( cp_regime_code => jai_constants.tcs_regime);
5337: fetch gc_get_regime_id into ln_tcs_regime_id;
5338: close gc_get_regime_id;
5339:
5340: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
5341: ( p_regime_id => ln_tcs_regime_id
5342: , p_organization_id => v_organization_id
5343: , p_party_type => jai_constants.party_type_customer
5344: , p_party_id => v_customer_id
5359: if ln_threshold_slab_id is not null then
5360: /**
5361: Threshold is high and slab is available. Hence get tax_category defined for the salb to default additional taxes
5362: */
5363: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
5364: (
5365: p_threshold_slab_id => ln_threshold_slab_id
5366: , p_org_id => v_org_id
5367: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id