[Home] [Help]
410: CURSOR Fetch_Sum_Cur( linelocid IN NUMBER ) IS
411: SELECT SUM( NVL( Tax_Amount, 0 ) )
412: FROM JAI_PO_TAXES
413: WHERE Line_Location_Id = linelocid -- For Blanket Rel Line Loc Id is passed in place of header id.
414: AND Tax_Type <> jai_constants.tax_type_tds ; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
415:
416: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.calculate_tax';
417: BEGIN
418:
547: A.precedence_10 P_10,
548: A.Tax_Id,
549: DECODE(aa.regime_code, 'VAT', 4
550: /* for bug 16013918 by anupgupt
551: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
552: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
553: */
554: , DECODE( UPPER( A.Tax_Type ),
555: 'EXCISE', 1,
548: A.Tax_Id,
549: DECODE(aa.regime_code, 'VAT', 4
550: /* for bug 16013918 by anupgupt
551: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
552: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
553: */
554: , DECODE( UPPER( A.Tax_Type ),
555: 'EXCISE', 1,
556: 'ADDL. EXCISE', 1,
555: 'EXCISE', 1,
556: 'ADDL. EXCISE', 1,
557: 'OTHER EXCISE', 1,
558: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
559: /*jai_constants.tax_type_exc_edu_cess, 1,
560: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740*/
561: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
562: ---------------------------------------------------
563: jai_constants.tax_type_exc_edu_cess, 6,
556: 'ADDL. EXCISE', 1,
557: 'OTHER EXCISE', 1,
558: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
559: /*jai_constants.tax_type_exc_edu_cess, 1,
560: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740*/
561: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
562: ---------------------------------------------------
563: jai_constants.tax_type_exc_edu_cess, 6,
564: jai_constants.tax_type_cvd_edu_cess , 6,
559: /*jai_constants.tax_type_exc_edu_cess, 1,
560: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740*/
561: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
562: ---------------------------------------------------
563: jai_constants.tax_type_exc_edu_cess, 6,
564: jai_constants.tax_type_cvd_edu_cess , 6,
565: jai_constants.tax_type_sh_exc_edu_cess, 6,
566: jai_constants.tax_type_sh_cvd_edu_cess, 6,
567: ---------------------------------------------------
560: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740*/
561: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
562: ---------------------------------------------------
563: jai_constants.tax_type_exc_edu_cess, 6,
564: jai_constants.tax_type_cvd_edu_cess , 6,
565: jai_constants.tax_type_sh_exc_edu_cess, 6,
566: jai_constants.tax_type_sh_cvd_edu_cess, 6,
567: ---------------------------------------------------
568: 'TDS', 2, 0)) tax_type_val,
561: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
562: ---------------------------------------------------
563: jai_constants.tax_type_exc_edu_cess, 6,
564: jai_constants.tax_type_cvd_edu_cess , 6,
565: jai_constants.tax_type_sh_exc_edu_cess, 6,
566: jai_constants.tax_type_sh_cvd_edu_cess, 6,
567: ---------------------------------------------------
568: 'TDS', 2, 0)) tax_type_val,
569: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
562: ---------------------------------------------------
563: jai_constants.tax_type_exc_edu_cess, 6,
564: jai_constants.tax_type_cvd_edu_cess , 6,
565: jai_constants.tax_type_sh_exc_edu_cess, 6,
566: jai_constants.tax_type_sh_cvd_edu_cess, 6,
567: ---------------------------------------------------
568: 'TDS', 2, 0)) tax_type_val,
569: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
570: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
599: A.precedence_10 P_10,
600: A.Tax_Id,
601: DECODE(aa.regime_code, 'VAT', 4
602: /* for bug 16013918 by anupgupt
603: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
604: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
605: */
606: , DECODE( UPPER( A.Tax_Type ),
607: 'EXCISE', 1,
600: A.Tax_Id,
601: DECODE(aa.regime_code, 'VAT', 4
602: /* for bug 16013918 by anupgupt
603: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
604: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
605: */
606: , DECODE( UPPER( A.Tax_Type ),
607: 'EXCISE', 1,
608: 'ADDL. EXCISE', 1,
607: 'EXCISE', 1,
608: 'ADDL. EXCISE', 1,
609: 'OTHER EXCISE', 1,
610: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
611: /*jai_constants.tax_type_exc_edu_cess, 1,
612: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740*/
613: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
614: ---------------------------------------------------
615: jai_constants.tax_type_exc_edu_cess, 6,
608: 'ADDL. EXCISE', 1,
609: 'OTHER EXCISE', 1,
610: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
611: /*jai_constants.tax_type_exc_edu_cess, 1,
612: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740*/
613: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
614: ---------------------------------------------------
615: jai_constants.tax_type_exc_edu_cess, 6,
616: jai_constants.tax_type_cvd_edu_cess , 6,
611: /*jai_constants.tax_type_exc_edu_cess, 1,
612: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740*/
613: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
614: ---------------------------------------------------
615: jai_constants.tax_type_exc_edu_cess, 6,
616: jai_constants.tax_type_cvd_edu_cess , 6,
617: jai_constants.tax_type_sh_exc_edu_cess, 6,
618: jai_constants.tax_type_sh_cvd_edu_cess, 6,
619: ---------------------------------------------------
612: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740*/
613: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
614: ---------------------------------------------------
615: jai_constants.tax_type_exc_edu_cess, 6,
616: jai_constants.tax_type_cvd_edu_cess , 6,
617: jai_constants.tax_type_sh_exc_edu_cess, 6,
618: jai_constants.tax_type_sh_cvd_edu_cess, 6,
619: ---------------------------------------------------
620: 'TDS', 2, 0)) tax_type_val,
613: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
614: ---------------------------------------------------
615: jai_constants.tax_type_exc_edu_cess, 6,
616: jai_constants.tax_type_cvd_edu_cess , 6,
617: jai_constants.tax_type_sh_exc_edu_cess, 6,
618: jai_constants.tax_type_sh_cvd_edu_cess, 6,
619: ---------------------------------------------------
620: 'TDS', 2, 0)) tax_type_val,
621: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
614: ---------------------------------------------------
615: jai_constants.tax_type_exc_edu_cess, 6,
616: jai_constants.tax_type_cvd_edu_cess , 6,
617: jai_constants.tax_type_sh_exc_edu_cess, 6,
618: jai_constants.tax_type_sh_cvd_edu_cess, 6,
619: ---------------------------------------------------
620: 'TDS', 2, 0)) tax_type_val,
621: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
622: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
641: A.Precedence_8 P_8, A.Precedence_9 P_9, A.precedence_10 P_10,
642: A.Tax_Id,
643: DECODE(aa.regime_code, 'VAT', 4
644: /* for bug 16013918 by anupgupt
645: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
646: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
647: */
648: , DECODE( UPPER( A.Tax_Type ),
649: 'EXCISE', 1,
642: A.Tax_Id,
643: DECODE(aa.regime_code, 'VAT', 4
644: /* for bug 16013918 by anupgupt
645: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
646: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
647: */
648: , DECODE( UPPER( A.Tax_Type ),
649: 'EXCISE', 1,
650: 'ADDL. EXCISE', 1,
652: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
653: /*'Excise_Education_cess', 1,*/
654: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
655: ---------------------------------------------------
656: jai_constants.tax_type_exc_edu_cess, 6,
657: jai_constants.tax_type_cvd_edu_cess , 6,
658: jai_constants.tax_type_sh_exc_edu_cess, 6,
659: jai_constants.tax_type_sh_cvd_edu_cess, 6,
660: ---------------------------------------------------
653: /*'Excise_Education_cess', 1,*/
654: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
655: ---------------------------------------------------
656: jai_constants.tax_type_exc_edu_cess, 6,
657: jai_constants.tax_type_cvd_edu_cess , 6,
658: jai_constants.tax_type_sh_exc_edu_cess, 6,
659: jai_constants.tax_type_sh_cvd_edu_cess, 6,
660: ---------------------------------------------------
661: 'TDS', 2, 0)) tax_type_val,
654: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
655: ---------------------------------------------------
656: jai_constants.tax_type_exc_edu_cess, 6,
657: jai_constants.tax_type_cvd_edu_cess , 6,
658: jai_constants.tax_type_sh_exc_edu_cess, 6,
659: jai_constants.tax_type_sh_cvd_edu_cess, 6,
660: ---------------------------------------------------
661: 'TDS', 2, 0)) tax_type_val,
662: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
655: ---------------------------------------------------
656: jai_constants.tax_type_exc_edu_cess, 6,
657: jai_constants.tax_type_cvd_edu_cess , 6,
658: jai_constants.tax_type_sh_exc_edu_cess, 6,
659: jai_constants.tax_type_sh_cvd_edu_cess, 6,
660: ---------------------------------------------------
661: 'TDS', 2, 0)) tax_type_val,
662: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
663: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
684: A.Precedence_8 P_8, A.Precedence_9 P_9, A.precedence_10 P_10,
685: A.Tax_Id,
686: DECODE(aa.regime_code, 'VAT', 4
687: /* for bug 16013918 by anupgupt
688: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
689: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
690: */
691: , DECODE( UPPER( A.Tax_Type ),
692: 'EXCISE', 1,
685: A.Tax_Id,
686: DECODE(aa.regime_code, 'VAT', 4
687: /* for bug 16013918 by anupgupt
688: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
689: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
690: */
691: , DECODE( UPPER( A.Tax_Type ),
692: 'EXCISE', 1,
693: 'ADDL. EXCISE', 1,
695: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
696: /*'Excise_Education_cess', 1,*/
697: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
698: ---------------------------------------------------
699: jai_constants.tax_type_exc_edu_cess, 6,
700: jai_constants.tax_type_cvd_edu_cess , 6,
701: jai_constants.tax_type_sh_exc_edu_cess, 6,
702: jai_constants.tax_type_sh_cvd_edu_cess, 6,
703: ---------------------------------------------------
696: /*'Excise_Education_cess', 1,*/
697: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
698: ---------------------------------------------------
699: jai_constants.tax_type_exc_edu_cess, 6,
700: jai_constants.tax_type_cvd_edu_cess , 6,
701: jai_constants.tax_type_sh_exc_edu_cess, 6,
702: jai_constants.tax_type_sh_cvd_edu_cess, 6,
703: ---------------------------------------------------
704: 'TDS', 2, 0)) tax_type_val,
697: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
698: ---------------------------------------------------
699: jai_constants.tax_type_exc_edu_cess, 6,
700: jai_constants.tax_type_cvd_edu_cess , 6,
701: jai_constants.tax_type_sh_exc_edu_cess, 6,
702: jai_constants.tax_type_sh_cvd_edu_cess, 6,
703: ---------------------------------------------------
704: 'TDS', 2, 0)) tax_type_val,
705: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
698: ---------------------------------------------------
699: jai_constants.tax_type_exc_edu_cess, 6,
700: jai_constants.tax_type_cvd_edu_cess , 6,
701: jai_constants.tax_type_sh_exc_edu_cess, 6,
702: jai_constants.tax_type_sh_cvd_edu_cess, 6,
703: ---------------------------------------------------
704: 'TDS', 2, 0)) tax_type_val,
705: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
706: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
2013: A.precedence_10 P_10,
2014: A.Tax_Id,
2015: DECODE(aa.regime_code, 'VAT', 4
2016: /* for bug 16013918 by anupgupt
2017: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
2018: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
2019: */
2020: , DECODE( UPPER( A.Tax_Type ),
2021: 'EXCISE', 1,
2014: A.Tax_Id,
2015: DECODE(aa.regime_code, 'VAT', 4
2016: /* for bug 16013918 by anupgupt
2017: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
2018: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
2019: */
2020: , DECODE( UPPER( A.Tax_Type ),
2021: 'EXCISE', 1,
2022: 'ADDL. EXCISE', 1,
2020: , DECODE( UPPER( A.Tax_Type ),
2021: 'EXCISE', 1,
2022: 'ADDL. EXCISE', 1,
2023: 'OTHER EXCISE', 1,
2024: jai_constants.tax_type_exc_edu_cess, 1,
2025: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740
2026: 'TDS', 2, 0)) tax_type_val,
2027: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2028: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2021: 'EXCISE', 1,
2022: 'ADDL. EXCISE', 1,
2023: 'OTHER EXCISE', 1,
2024: jai_constants.tax_type_exc_edu_cess, 1,
2025: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740
2026: 'TDS', 2, 0)) tax_type_val,
2027: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2028: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2029: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2061: DECODE(aa.regime_code, 'VAT', 4, DECODE( UPPER( A.Tax_Type ),
2062: 'EXCISE', 1,
2063: 'ADDL. EXCISE', 1,
2064: 'OTHER EXCISE', 1,
2065: jai_constants.tax_type_exc_edu_cess, 1,
2066: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740
2067:
2068: 'TDS', 2, 0)) tax_type_val,
2069: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2062: 'EXCISE', 1,
2063: 'ADDL. EXCISE', 1,
2064: 'OTHER EXCISE', 1,
2065: jai_constants.tax_type_exc_edu_cess, 1,
2066: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740
2067:
2068: 'TDS', 2, 0)) tax_type_val,
2069: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2070: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2088: A.Precedence_8 P_8, A.Precedence_9 P_9, A.precedence_10 P_10,
2089: A.Tax_Id,
2090: DECODE(aa.regime_code, 'VAT', 4
2091: /* for bug 16013918 by anupgupt
2092: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
2093: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
2094: */
2095: , DECODE( UPPER( A.Tax_Type ),
2096: 'EXCISE', 1,
2089: A.Tax_Id,
2090: DECODE(aa.regime_code, 'VAT', 4
2091: /* for bug 16013918 by anupgupt
2092: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
2093: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
2094: */
2095: , DECODE( UPPER( A.Tax_Type ),
2096: 'EXCISE', 1,
2097: 'ADDL. EXCISE', 1,
2282: , lv_third_party_flag;
2283: CLOSE get_rcv_line_for_retro;
2284:
2285: IF( lv_tax_type IN
2286: ( JAI_CONSTANTS.tax_type_customs
2287: , JAI_CONSTANTS.tax_type_customs_edu_cess
2288: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
2289: , JAI_CONSTANTS.tax_type_cvd
2290: , JAI_CONSTANTS.tax_type_cvd_edu_cess
2283: CLOSE get_rcv_line_for_retro;
2284:
2285: IF( lv_tax_type IN
2286: ( JAI_CONSTANTS.tax_type_customs
2287: , JAI_CONSTANTS.tax_type_customs_edu_cess
2288: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
2289: , JAI_CONSTANTS.tax_type_cvd
2290: , JAI_CONSTANTS.tax_type_cvd_edu_cess
2291: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess
2284:
2285: IF( lv_tax_type IN
2286: ( JAI_CONSTANTS.tax_type_customs
2287: , JAI_CONSTANTS.tax_type_customs_edu_cess
2288: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
2289: , JAI_CONSTANTS.tax_type_cvd
2290: , JAI_CONSTANTS.tax_type_cvd_edu_cess
2291: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess
2292: )
2285: IF( lv_tax_type IN
2286: ( JAI_CONSTANTS.tax_type_customs
2287: , JAI_CONSTANTS.tax_type_customs_edu_cess
2288: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
2289: , JAI_CONSTANTS.tax_type_cvd
2290: , JAI_CONSTANTS.tax_type_cvd_edu_cess
2291: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess
2292: )
2293: OR lv_third_party_flag = 'Y'
2286: ( JAI_CONSTANTS.tax_type_customs
2287: , JAI_CONSTANTS.tax_type_customs_edu_cess
2288: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
2289: , JAI_CONSTANTS.tax_type_cvd
2290: , JAI_CONSTANTS.tax_type_cvd_edu_cess
2291: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess
2292: )
2293: OR lv_third_party_flag = 'Y'
2294: )
2287: , JAI_CONSTANTS.tax_type_customs_edu_cess
2288: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
2289: , JAI_CONSTANTS.tax_type_cvd
2290: , JAI_CONSTANTS.tax_type_cvd_edu_cess
2291: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess
2292: )
2293: OR lv_third_party_flag = 'Y'
2294: )
2295: THEN
3636: b.adhoc_flag,
3637: b.inclusive_tax_flag, -- Add by Kevin Cheng for inclusive tax Dec 17, 2007
3638: DECODE( aa.regime_code, 'VAT', 4 ,
3639: /* for bug 16013918 by anupgupt
3640: jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3641: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3642: */
3643: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3644: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3637: b.inclusive_tax_flag, -- Add by Kevin Cheng for inclusive tax Dec 17, 2007
3638: DECODE( aa.regime_code, 'VAT', 4 ,
3639: /* for bug 16013918 by anupgupt
3640: jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3641: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3642: */
3643: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3644: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3645: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3644: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3645: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3646: /* added by ssawant for bug 5989740 */
3647: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
3648: /*JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1,*/ --,jai_constants.tax_type_cvd_edu_cess, 1,
3649: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3650: ---------------------------------------------------
3651: jai_constants.tax_type_exc_edu_cess, 6,
3652: jai_constants.tax_type_cvd_edu_cess , 6,
3647: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
3648: /*JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1,*/ --,jai_constants.tax_type_cvd_edu_cess, 1,
3649: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3650: ---------------------------------------------------
3651: jai_constants.tax_type_exc_edu_cess, 6,
3652: jai_constants.tax_type_cvd_edu_cess , 6,
3653: jai_constants.tax_type_sh_exc_edu_cess, 6,
3654: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3655: ---------------------------------------------------
3648: /*JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1,*/ --,jai_constants.tax_type_cvd_edu_cess, 1,
3649: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3650: ---------------------------------------------------
3651: jai_constants.tax_type_exc_edu_cess, 6,
3652: jai_constants.tax_type_cvd_edu_cess , 6,
3653: jai_constants.tax_type_sh_exc_edu_cess, 6,
3654: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3655: ---------------------------------------------------
3656: 'TDS', 2, 0
3649: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3650: ---------------------------------------------------
3651: jai_constants.tax_type_exc_edu_cess, 6,
3652: jai_constants.tax_type_cvd_edu_cess , 6,
3653: jai_constants.tax_type_sh_exc_edu_cess, 6,
3654: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3655: ---------------------------------------------------
3656: 'TDS', 2, 0
3657: )
3650: ---------------------------------------------------
3651: jai_constants.tax_type_exc_edu_cess, 6,
3652: jai_constants.tax_type_cvd_edu_cess , 6,
3653: jai_constants.tax_type_sh_exc_edu_cess, 6,
3654: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3655: ---------------------------------------------------
3656: 'TDS', 2, 0
3657: )
3658: ) tax_type_val
3680: A.precedence_10 P_10,
3681: A.Tax_Id,
3682: DECODE( aa.regime_code, 'VAT', 4 ,
3683: /* for bug 16013918 by anupgupt
3684: jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3685: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3686: */
3687: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3688: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3681: A.Tax_Id,
3682: DECODE( aa.regime_code, 'VAT', 4 ,
3683: /* for bug 16013918 by anupgupt
3684: jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3685: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3686: */
3687: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3688: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3689: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3688: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3689: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3690: /* added by ssawant for bug 5989740 */
3691: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
3692: /*JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1,*/ --jai_constants.tax_type_cvd_edu_cess, 1,
3693: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3694: ---------------------------------------------------
3695: jai_constants.tax_type_exc_edu_cess, 6,
3696: jai_constants.tax_type_cvd_edu_cess , 6,
3691: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
3692: /*JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1,*/ --jai_constants.tax_type_cvd_edu_cess, 1,
3693: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3694: ---------------------------------------------------
3695: jai_constants.tax_type_exc_edu_cess, 6,
3696: jai_constants.tax_type_cvd_edu_cess , 6,
3697: jai_constants.tax_type_sh_exc_edu_cess, 6,
3698: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3699: ---------------------------------------------------
3692: /*JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1,*/ --jai_constants.tax_type_cvd_edu_cess, 1,
3693: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3694: ---------------------------------------------------
3695: jai_constants.tax_type_exc_edu_cess, 6,
3696: jai_constants.tax_type_cvd_edu_cess , 6,
3697: jai_constants.tax_type_sh_exc_edu_cess, 6,
3698: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3699: ---------------------------------------------------
3700: 'TDS', 2, 0
3693: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3694: ---------------------------------------------------
3695: jai_constants.tax_type_exc_edu_cess, 6,
3696: jai_constants.tax_type_cvd_edu_cess , 6,
3697: jai_constants.tax_type_sh_exc_edu_cess, 6,
3698: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3699: ---------------------------------------------------
3700: 'TDS', 2, 0
3701: )
3694: ---------------------------------------------------
3695: jai_constants.tax_type_exc_edu_cess, 6,
3696: jai_constants.tax_type_cvd_edu_cess , 6,
3697: jai_constants.tax_type_sh_exc_edu_cess, 6,
3698: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3699: ---------------------------------------------------
3700: 'TDS', 2, 0
3701: )
3702: ) tax_type_val,
3728: CURSOR fetch_sum_cur( p_line_location_id IN NUMBER ) IS
3729: SELECT SUM( NVL( tax_amount, 0 ) )
3730: FROM JAI_PO_TAXES
3731: WHERE line_location_id = p_line_location_id -- For Blanket Rel Line Loc Id is passed in place of header id.
3732: AND tax_type <> jai_constants.tax_type_tds; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3733:
3734: CURSOR fetch_line_uom_code IS
3735: SELECT uom_code
3736: FROM po_lines_all plines, mtl_units_of_measure units
3761: A.precedence_10 P_10,
3762: A.Tax_Id,
3763: DECODE(aa.regime_code, 'VAT', 4
3764: /* for bug 16013918 by anupgupt
3765: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
3766: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
3767: */
3768: , DECODE( UPPER( A.Tax_Type ),
3769: 'EXCISE', 1,
3762: A.Tax_Id,
3763: DECODE(aa.regime_code, 'VAT', 4
3764: /* for bug 16013918 by anupgupt
3765: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
3766: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
3767: */
3768: , DECODE( UPPER( A.Tax_Type ),
3769: 'EXCISE', 1,
3770: 'ADDL. EXCISE', 1,
3770: 'ADDL. EXCISE', 1,
3771: 'OTHER EXCISE', 1,
3772: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
3773: /*'Excise_Education_cess', 1,
3774: jai_constants.tax_type_sh_exc_edu_cess,1,*/
3775: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3776: ---------------------------------------------------
3777: jai_constants.tax_type_exc_edu_cess, 6,
3778: jai_constants.tax_type_cvd_edu_cess , 6,
3773: /*'Excise_Education_cess', 1,
3774: jai_constants.tax_type_sh_exc_edu_cess,1,*/
3775: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3776: ---------------------------------------------------
3777: jai_constants.tax_type_exc_edu_cess, 6,
3778: jai_constants.tax_type_cvd_edu_cess , 6,
3779: jai_constants.tax_type_sh_exc_edu_cess, 6,
3780: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3781: ----------------------------------------------------
3774: jai_constants.tax_type_sh_exc_edu_cess,1,*/
3775: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3776: ---------------------------------------------------
3777: jai_constants.tax_type_exc_edu_cess, 6,
3778: jai_constants.tax_type_cvd_edu_cess , 6,
3779: jai_constants.tax_type_sh_exc_edu_cess, 6,
3780: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3781: ----------------------------------------------------
3782: 'TDS', 2,
3775: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3776: ---------------------------------------------------
3777: jai_constants.tax_type_exc_edu_cess, 6,
3778: jai_constants.tax_type_cvd_edu_cess , 6,
3779: jai_constants.tax_type_sh_exc_edu_cess, 6,
3780: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3781: ----------------------------------------------------
3782: 'TDS', 2,
3783: 0)) tax_type_val,
3776: ---------------------------------------------------
3777: jai_constants.tax_type_exc_edu_cess, 6,
3778: jai_constants.tax_type_cvd_edu_cess , 6,
3779: jai_constants.tax_type_sh_exc_edu_cess, 6,
3780: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3781: ----------------------------------------------------
3782: 'TDS', 2,
3783: 0)) tax_type_val,
3784: A.Tax_Rate tax_rate,
3824: a.currency curr,
3825: b.adhoc_flag,
3826: DECODE( aa.regime_code, 'VAT', 4 ,
3827: /* for bug 16013918 by anupgupt
3828: jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3829: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3830: */
3831: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3832: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3825: b.adhoc_flag,
3826: DECODE( aa.regime_code, 'VAT', 4 ,
3827: /* for bug 16013918 by anupgupt
3828: jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3829: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3830: */
3831: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3832: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3833: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3831: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3832: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3833: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3834: /* added by ssawant for bug 5989740 */
3835: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1, --,jai_constants.tax_type_cvd_edu_cess, 1,
3836: 'TDS', 2, 0
3837: )
3838: ) tax_type_val
3839: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
3860: A.precedence_10 P_10,
3861: A.Tax_Id,
3862: DECODE( aa.regime_code, 'VAT', 4 ,
3863: /* for bug 16013918 by anupgupt
3864: jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3865: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3866: */
3867: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3868: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3861: A.Tax_Id,
3862: DECODE( aa.regime_code, 'VAT', 4 ,
3863: /* for bug 16013918 by anupgupt
3864: jai_constants.cgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3865: jai_constants.sgst_regime, 7, --Added by Jia for GST Bug#10043656 on 2010/09/10
3866: */
3867: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3868: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3869: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3867: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3868: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3869: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3870: /* added by ssawant for bug 5989740 */
3871: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1, --jai_constants.tax_type_cvd_edu_cess, 1,
3872: 'TDS', 2, 0
3873: )
3874: ) tax_type_val,
3875: A.Tax_Rate tax_rate,
3908: A.precedence_10 P_10,
3909: A.Tax_Id,
3910: DECODE(aa.regime_code, 'VAT', 4
3911: /* for bug 16013918 by anupgupt
3912: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
3913: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
3914: */
3915: , DECODE( UPPER( A.Tax_Type ),
3916: 'EXCISE', 1,
3909: A.Tax_Id,
3910: DECODE(aa.regime_code, 'VAT', 4
3911: /* for bug 16013918 by anupgupt
3912: , jai_constants.cgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
3913: , jai_constants.sgst_regime, 7 --Added by Jia for GST Bug#10043656 on 2010/09/10
3914: */
3915: , DECODE( UPPER( A.Tax_Type ),
3916: 'EXCISE', 1,
3917: 'ADDL. EXCISE', 1,
3916: 'EXCISE', 1,
3917: 'ADDL. EXCISE', 1,
3918: 'OTHER EXCISE', 1,
3919: 'Excise_Education_cess', 1,
3920: jai_constants.tax_type_sh_exc_edu_cess,1,
3921: 'TDS', 2,
3922: 0)) tax_type_val,
3923: A.Tax_Rate tax_rate,
3924: A.Qty_Rate Qty_Rate,
4026: vamt := 0;
4027: max_iter := 15; -- Date 03/11/2006 Bug 5228046 added by SACSETHI
4028: v_curr := p_line_uom_code;
4029: v_line_uom_code := p_line_uom_code;
4030: v_debug := jai_constants.no;
4031:
4032: IF v_debug = 'Y' THEN
4033: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
4034: fnd_file.put_line(fnd_file.log,
5575: vamt := 0;
5576: max_iter := 15; -- Date 03/11/2006 Bug 5228046 added by SACSETHI
5577: v_curr := p_line_uom_code;
5578: v_line_uom_code := p_line_uom_code;
5579: v_debug := jai_constants.no;
5580:
5581: IF v_debug = 'Y' THEN
5582: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
5583: fnd_file.put_line(fnd_file.log,
7329: CURSOR Fetch_Tot_Sum_Cur( llid IN NUMBER ) IS
7330: SELECT SUM( NVL( Tax_Amount, 0 ) )
7331: FROM JAI_PO_TAXES
7332: WHERE Line_Location_Id = llid
7333: AND Tax_Type <> jai_constants.tax_type_tds; --'TDS';
7334:
7335: CURSOR Get_Assessable_Val_Cur IS
7336: SELECT Vendor_Id, Vendor_Site_Id, Currency_Code
7337: FROM Po_Headers_All
8364: * Added CVD and Customs Education Cess */
8365:
8366: IF upper(v_tax_type) IN ( 'CUSTOMS',
8367: 'CVD',
8368: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
8369: jai_constants.tax_type_customs_edu_cess,jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
8370: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess) /* added by ssawant for bug 5989740 */
8371: THEN
8372: v_vendor_id := NULL;
8365:
8366: IF upper(v_tax_type) IN ( 'CUSTOMS',
8367: 'CVD',
8368: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
8369: jai_constants.tax_type_customs_edu_cess,jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
8370: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess) /* added by ssawant for bug 5989740 */
8371: THEN
8372: v_vendor_id := NULL;
8373: ELSIF v_tax_type = 'TDS' THEN
8366: IF upper(v_tax_type) IN ( 'CUSTOMS',
8367: 'CVD',
8368: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
8369: jai_constants.tax_type_customs_edu_cess,jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
8370: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess) /* added by ssawant for bug 5989740 */
8371: THEN
8372: v_vendor_id := NULL;
8373: ELSIF v_tax_type = 'TDS' THEN
8374: v_vendor_id := v_vendor1_id;
8443: END IF;
8444:
8445: IF v_tax_type IN ( 'Customs',
8446: 'CVD',
8447: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
8448: jai_constants.tax_type_customs_edu_cess, jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
8449: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess /* added by ssawant for bug 5989740 */
8450: ) THEN
8451: v_vendor_id := NULL;
8444:
8445: IF v_tax_type IN ( 'Customs',
8446: 'CVD',
8447: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
8448: jai_constants.tax_type_customs_edu_cess, jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
8449: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess /* added by ssawant for bug 5989740 */
8450: ) THEN
8451: v_vendor_id := NULL;
8452: ELSIF v_tax_type = 'TDS' THEN
8445: IF v_tax_type IN ( 'Customs',
8446: 'CVD',
8447: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
8448: jai_constants.tax_type_customs_edu_cess, jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
8449: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess /* added by ssawant for bug 5989740 */
8450: ) THEN
8451: v_vendor_id := NULL;
8452: ELSIF v_tax_type = 'TDS' THEN
8453: v_vendor_id := v_vendor1_id;
8680: CURSOR Fetch_Sum_Cur IS
8681: SELECT SUM( NVL( Tax_Amount, 0 ) )
8682: FROM JAI_PO_TAXES
8683: WHERE Line_Location_Id = v_line_loc_id
8684: AND Tax_Type <> jai_constants.tax_type_tds; -- 'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
8685:
8686: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.ja_in_po_case2';
8687:
8688: --added by peng.zheng for bug 10043656, begins