[Home] [Help]
434: Fix:Added few conditions to the cursor c_jai_no_tds_trx_amt in procedure process_threshold_transition to calculate the correct taxable amount
435:
436: 62. 16-Nov-2012 amandali for bug 14709400
437: Description:TDS threhsold transition amount is calculated wrongly
438: Fix:Modified the cursor c_jai_ap_tds_thhold_taxes in procedure process_threshold_transition
439:
440: 63. 29-Nov-2012 amandali for Bug:15918300
441: Description:Wrong threshold transition amount when an invoice has both TDS and WCT taxes attached.
442: Fix: Added section type condition in cursor c_default_tax_id in procedure process_threshold_transition
1020: jatts.tax_rate tax_rate,
1021: jattt.tax_id tax_id,
1022: (jitc.tax_rate-(nvl(jitc.surcharge_rate,0) + nvl(jitc.cess_rate,0) + nvl(jitc.sh_cess_rate,0))) tax_rate_orig
1023: from jai_ap_tds_thhold_slabs jatts,
1024: jai_ap_tds_thhold_taxes jattt,
1025: jai_cmn_taxes_all jitc
1026: where jatts.threshold_slab_id = jattt.threshold_slab_id
1027: and jattt.tax_id = jitc.tax_id
1028: and jatts.threshold_slab_id = p_threshold_slab_id;
2772: p_process_message out nocopy varchar2
2773: )
2774: is
2775:
2776: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is
2777: select tax_id
2778: from jai_ap_tds_thhold_taxes
2779: where threshold_slab_id = p_threshold_slab_id
2780: and operating_unit_id = p_org_id;
2774: is
2775:
2776: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is
2777: select tax_id
2778: from jai_ap_tds_thhold_taxes
2779: where threshold_slab_id = p_threshold_slab_id
2780: and operating_unit_id = p_org_id;
2781:
2782: /* START, Added below cursors for Bgowrava for Bug#8254510*/
2945: /*Ebd-Bug 9562876*/
2946: lv_codepath jai_ap_tds_inv_taxes.codepath%type;
2947:
2948:
2949: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
2950: r_jai_ap_tds_thhold_grps c_jai_ap_tds_thhold_grps%rowtype;
2951: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
2952: ln_thhold_transition_tax_amt number;
2953: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
2985: ln_curr_prepay_amt number; --Added by Xiao Lv for Bug#8513550, related 11i bug#8439276
2986:
2987: begin
2988:
2989: open c_jai_ap_tds_thhold_taxes(p_threshold_slab_id, p_org_id);
2990: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
2991: close c_jai_ap_tds_thhold_taxes;
2992:
2993: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
2986:
2987: begin
2988:
2989: open c_jai_ap_tds_thhold_taxes(p_threshold_slab_id, p_org_id);
2990: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
2991: close c_jai_ap_tds_thhold_taxes;
2992:
2993: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
2994: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2987: begin
2988:
2989: open c_jai_ap_tds_thhold_taxes(p_threshold_slab_id, p_org_id);
2990: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
2991: close c_jai_ap_tds_thhold_taxes;
2992:
2993: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
2994: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2995: close c_jai_ap_tds_thhold_grps;
2993: open c_jai_ap_tds_thhold_grps(p_threshold_grp_id);
2994: fetch c_jai_ap_tds_thhold_grps into r_jai_ap_tds_thhold_grps;
2995: close c_jai_ap_tds_thhold_grps;
2996:
2997: open c_ja_in_tax_codes(r_jai_ap_tds_thhold_taxes.tax_id);
2998: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;
2999: close c_ja_in_tax_codes;
3000:
3001: -- Bug 5722028. Added by csahoo
3058: fetch c_jai_cancelled_amount into ln_cancelled_amount;
3059: close c_jai_cancelled_amount;
3060: --Added by Xiao for Bug#8485691, related 11i Bug#8439217, begin
3061: r_tax_id := null;
3062: /*Removed parameter r_jai_ap_tds_thhold_taxes.tax_id. Tax Rate for Threshold Transition must be fetched from the Invoice
3063: There is no need to fetch the Threshold Setup tax rate as Defaultation logic should have populated the same in default_tax_id*/
3064: open c_default_tax_id(c_rec_no_tds.invoice_id);
3065: fetch c_default_tax_id into r_tax_id;
3066: close c_default_tax_id;
3064: open c_default_tax_id(c_rec_no_tds.invoice_id);
3065: fetch c_default_tax_id into r_tax_id;
3066: close c_default_tax_id;
3067:
3068: open c_ja_in_tax_codes(nvl(r_tax_id, r_jai_ap_tds_thhold_taxes.tax_id));
3069: fetch c_ja_in_tax_codes into r_ja_in_tax_codes_inv;
3070: close c_ja_in_tax_codes;
3071:
3072: ln_thhold_total_inv_amt := ln_thhold_total_inv_amt + (r_jai_no_tds_trx_amt.amount - ln_cancelled_amount - ln_prepay_applied_amt - ln_curr_prepay_amt); --Added ln_curr_prepay_amt by xiao for Bug#8513550
3113: pn_threshold_hdr_id => ln_threshold_hdr_id , /*amandali for bug 11671779*/
3114: pn_taxable_amount => ln_taxable_amount , --Modified by Bgowrava for Bug#8459564
3115: /* No taxable amount in case of threshold transition invoice */
3116: pn_tax_amount => ln_thhold_transition_tax_amt ,
3117: pn_tax_id => r_jai_ap_tds_thhold_taxes.tax_id ,
3118: pd_accounting_date => p_accounting_date ,
3119: pv_tds_event => p_tds_event ,
3120: pn_threshold_grp_id => p_threshold_grp_id ,
3121: pv_tds_invoice_num => lv_tds_invoice_num ,
3225: pn_invoice_id => p_invoice_id ,
3226: pn_threshold_hdr_id => ln_threshold_hdr_id ,
3227: pn_taxable_amount => ln_sur_applicable_amt,
3228: pn_tax_amount => ln_thhold_total_sur_amt ,
3229: pn_tax_id => r_jai_ap_tds_thhold_taxes.tax_id ,
3230: pd_accounting_date => p_accounting_date ,
3231: pv_tds_event => 'SURCHARGE_CALCULATE' ,
3232: pn_threshold_grp_id => p_threshold_grp_id ,
3233: pv_tds_invoice_num => lv_tds_invoice_num ,
4689: IS
4690: SELECT b.tax_rate,
4691: b.from_amount,
4692: a.tax_id
4693: FROM jai_ap_tds_thhold_taxes a,
4694: jai_ap_tds_thhold_slabs b
4695: WHERE a.threshold_slab_id = b.threshold_slab_id
4696: AND a.operating_unit_id = p_org_id
4697: AND b.threshold_slab_id = p_threshold_slab_id;