[Home] [Help]
2421: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
2422: fetch c_get_regime_id into ln_tcs_regime_id;
2423: close c_get_regime_id;
2424: /* Find out what is the current slab */
2425: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2426: (
2427: p_regime_id => ln_tcs_regime_id
2428: , p_organization_id => ln_inv_orgn_id
2429: , p_party_type => jai_constants.party_type_customer
2443: );
2444: end if;
2445: if ln_threshold_slab_id is not null then
2446: /* Threshold level is up. Surcharge needs to be defaulted , so find out the tax category based on the threshold slab */
2447: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
2448: (
2449: p_threshold_slab_id => ln_threshold_slab_id
2450: , p_org_id => v_org_id
2451: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2473: and jrctt.tax_id = jtc.tax_id
2474: and jtc.tax_type = jai_constants.tax_type_tcs;
2475: /*
2476: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
2477: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
2478: || into the ja_in_so_picking_tax_lines table
2479: */
2480: jai_rgm_thhold_proc_pkg.default_thhold_taxes
2481: (
2476: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
2477: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
2478: || into the ja_in_so_picking_tax_lines table
2479: */
2480: jai_rgm_thhold_proc_pkg.default_thhold_taxes
2481: (
2482: p_source_trx_id => ''
2483: , p_source_trx_line_id => v_customer_trx_line_id
2484: , p_source_event => jai_constants.bill_only_invoice
2846:
2847: 34. 28-Jun-2007 CSahoo for bug#6155839, File Version 120.16
2848: replaced RG Register Data Entry by jai_constants.je_category_rg_entry
2849: 35. 16-oCT-2007 CSahoo for bug#6498072, File Version 120.21
2850: Multipled p_quantity to the assesible value in the call to the procedure jai_rgm_thhold_proc_pkg.default_thhold_taxes
2851:
2852: 36. 18-OCT-2007 CSahoo for bug#6498072, File Version 120.22
2853: Added the cursor get_ar_tax_amount to get the total tax amount from JAI_AR_TRX_TAX_LINES table.
2854: Moved the code for Inserting into JAI_AR_TRX_LINES and updating the table JAI_AR_TRXS to the end in the procedure
5149: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
5150: fetch c_get_regime_id into ln_tcs_regime_id;
5151: close c_get_regime_id;
5152: /* Find out what is the current slab */
5153: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
5154: (
5155: p_regime_id => ln_tcs_regime_id
5156: , p_organization_id => ln_inv_orgn_id
5157: , p_party_type => jai_constants.party_type_customer
5171: );
5172: end if;
5173: if ln_threshold_slab_id is not null then
5174: /* Threshold level is up. Surcharge needs to be defaulted , so find out the tax category based on the threshold slab */
5175: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
5176: (
5177: p_threshold_slab_id => ln_threshold_slab_id
5178: , p_org_id => pr_new.org_id
5179: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
5201: and jrctt.tax_id = jtc.tax_id
5202: and jtc.tax_type = jai_constants.tax_type_tcs;
5203: /*
5204: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
5205: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
5206: || into the ja_in_so_picking_tax_lines table
5207: */
5208: jai_rgm_thhold_proc_pkg.default_thhold_taxes
5209: (
5204: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
5205: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
5206: || into the ja_in_so_picking_tax_lines table
5207: */
5208: jai_rgm_thhold_proc_pkg.default_thhold_taxes
5209: (
5210: p_source_trx_id => ''
5211: , p_source_trx_line_id => v_customer_trx_line_id
5212: , p_source_event => jai_constants.bill_only_invoice
6789: open gc_get_regime_id ( cp_regime_code => jai_constants.tcs_regime);
6790: fetch gc_get_regime_id into ln_tcs_regime_id;
6791: close gc_get_regime_id;
6792:
6793: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
6794: ( p_regime_id => ln_tcs_regime_id
6795: , p_organization_id => v_organization_id
6796: , p_party_type => jai_constants.party_type_customer
6797: , p_party_id => v_customer_id
6812: if ln_threshold_slab_id is not null then
6813: /**
6814: Threshold is high and slab is available. Hence get tax_category defined for the salb to default additional taxes
6815: */
6816: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
6817: (
6818: p_threshold_slab_id => ln_threshold_slab_id
6819: , p_org_id => v_org_id
6820: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id