[Home] [Help]
129: Bug 6363056 (Forward Port of 6031679)
130: -------------------------------------
131: When prepayment from the previous year is applied on to the Standard Invoice of the current year,
132: it results in 'Effective Tax Amount cannot be negative'.
133: This issue is fixed by Invoice ID of the latest document in jai_ap_tds_thhold_trxs when inserting records
134: for TDS Event 'PREPAYMENT APPLICATION'. Apart from this, the threshold group which belongs latest
135: GL Date in the Distribution is used.
136:
137: Bug 6972230 (Forward Port of 6742977)
261: group by tds_threshold_trx_id_apply;
262:
263: /*Start Additions by mmurtuza for bug 13620923*/
264: cursor c_chk_tds_deducted(cp_invoice_id number) is
265: select count(1) from jai_ap_tds_thhold_trxs
266: where invoice_id = cp_invoice_id
267: and tds_event = 'INVOICE VALIDATE';
268:
269: ln_cnt_thrshold number := 0;
534: * prepayment unapplication
535: */
536: invoice_id,
537: tax_id
538: from jai_ap_tds_thhold_trxs
539: where threshold_trx_id = p_threshold_trx_id;
540:
541:
542: r_get_total_prepayment_tax c_get_total_prepayment_tax%rowtype;
563: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
564: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
565: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
566: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
567: lv_slab_transition_tds_event jai_ap_tds_thhold_trxs.tds_event%type;
568: lv_ppu_tds_inv_num ap_invoices_all.invoice_num%type;
569: lv_ppu_tds_cm_num ap_invoices_all.invoice_num%type;
570: /*Bug 5751783 - End*/
571: -- Bug 6031679. Added by Lakshmi Gopalsami
736: set unapply_flag = 'Y'
737: where invoice_id = p_invoice_id
738: and invoice_distribution_id_prepay = p_parent_distribution_id;
739:
740: /*Bug 9132694 - Only one Unapplication entry would be created in jai_ap_tds_thhold_trxs for one unapplication*/
741:
742: /* Bug 5751783
743: * Call to procedure - get_tds_threshold_slab,
744: * Store the current Threshold slab and type
1185: FROM jai_ap_tds_inv_taxes
1186: WHERE invoice_id = p_pre_pay_inv_id
1187: AND invoice_distribution_id = p_invoice_distribution_id ;
1188:
1189: lv_si_thhold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
1190: lv_pp_thhold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
1191: /* Bug 5751783 - End*/
1192:
1193: lv_applicable_flag varchar2(1);
1186: WHERE invoice_id = p_pre_pay_inv_id
1187: AND invoice_distribution_id = p_invoice_distribution_id ;
1188:
1189: lv_si_thhold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
1190: lv_pp_thhold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
1191: /* Bug 5751783 - End*/
1192:
1193: lv_applicable_flag varchar2(1);
1194: lv_is_si_validated_flag varchar2(1);
1530: /*Fetch the taxable amount for which TDS is generated*/
1531: CURSOR c_taxable_amount(p_invoice_id NUMBER)
1532: IS
1533: SELECT nvl(sum(taxable_amount), 0)
1534: FROM jai_ap_tds_thhold_trxs
1535: WHERE invoice_id = p_invoice_id
1536: AND tds_event = 'INVOICE VALIDATE'
1537: group by invoice_id;
1538:
1924: FOR get_si_det IN (SELECT jattt.*,
1925: jatp.tds_prepayment_id tds_prepayment_id,
1926: jatp.application_amount tds_taxable_basis,
1927: jatp.invoice_distribution_id tax_dist
1928: FROM jai_ap_tds_thhold_trxs jattt,
1929: jai_ap_tds_prepayments jatp
1930: WHERE jattt.invoice_id = jatp.invoice_id
1931: AND jattt.tds_event = 'INVOICE VALIDATE'
1932: AND jatp.tds_applicable_flag ='Y'