eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PO_TAX_PKG dependencies on JAI_CONSTANTS

Line 364: AND Tax_Type <> jai_constants.tax_type_tds ; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

360: CURSOR Fetch_Sum_Cur( linelocid IN NUMBER ) IS
361: SELECT SUM( NVL( Tax_Amount, 0 ) )
362: FROM JAI_PO_TAXES
363: WHERE Line_Location_Id = linelocid -- For Blanket Rel Line Loc Id is passed in place of header id.
364: AND Tax_Type <> jai_constants.tax_type_tds ; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
365:
366: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.calculate_tax';
367: BEGIN
368:

Line 487: /*jai_constants.tax_type_exc_edu_cess, 1,

483: 'EXCISE', 1,
484: 'ADDL. EXCISE', 1,
485: 'OTHER EXCISE', 1,
486: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
487: /*jai_constants.tax_type_exc_edu_cess, 1,
488: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740*/
489: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
490: ---------------------------------------------------
491: jai_constants.tax_type_exc_edu_cess, 6,

Line 488: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740*/

484: 'ADDL. EXCISE', 1,
485: 'OTHER EXCISE', 1,
486: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
487: /*jai_constants.tax_type_exc_edu_cess, 1,
488: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740*/
489: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
490: ---------------------------------------------------
491: jai_constants.tax_type_exc_edu_cess, 6,
492: jai_constants.tax_type_cvd_edu_cess , 6,

Line 491: jai_constants.tax_type_exc_edu_cess, 6,

487: /*jai_constants.tax_type_exc_edu_cess, 1,
488: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740*/
489: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
490: ---------------------------------------------------
491: jai_constants.tax_type_exc_edu_cess, 6,
492: jai_constants.tax_type_cvd_edu_cess , 6,
493: jai_constants.tax_type_sh_exc_edu_cess, 6,
494: jai_constants.tax_type_sh_cvd_edu_cess, 6,
495: ---------------------------------------------------

Line 492: jai_constants.tax_type_cvd_edu_cess , 6,

488: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740*/
489: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
490: ---------------------------------------------------
491: jai_constants.tax_type_exc_edu_cess, 6,
492: jai_constants.tax_type_cvd_edu_cess , 6,
493: jai_constants.tax_type_sh_exc_edu_cess, 6,
494: jai_constants.tax_type_sh_cvd_edu_cess, 6,
495: ---------------------------------------------------
496: 'TDS', 2, 0)) tax_type_val,

Line 493: jai_constants.tax_type_sh_exc_edu_cess, 6,

489: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
490: ---------------------------------------------------
491: jai_constants.tax_type_exc_edu_cess, 6,
492: jai_constants.tax_type_cvd_edu_cess , 6,
493: jai_constants.tax_type_sh_exc_edu_cess, 6,
494: jai_constants.tax_type_sh_cvd_edu_cess, 6,
495: ---------------------------------------------------
496: 'TDS', 2, 0)) tax_type_val,
497: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,

Line 494: jai_constants.tax_type_sh_cvd_edu_cess, 6,

490: ---------------------------------------------------
491: jai_constants.tax_type_exc_edu_cess, 6,
492: jai_constants.tax_type_cvd_edu_cess , 6,
493: jai_constants.tax_type_sh_exc_edu_cess, 6,
494: jai_constants.tax_type_sh_cvd_edu_cess, 6,
495: ---------------------------------------------------
496: 'TDS', 2, 0)) tax_type_val,
497: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
498: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,

Line 534: /*jai_constants.tax_type_exc_edu_cess, 1,

530: 'EXCISE', 1,
531: 'ADDL. EXCISE', 1,
532: 'OTHER EXCISE', 1,
533: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
534: /*jai_constants.tax_type_exc_edu_cess, 1,
535: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740*/
536: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
537: ---------------------------------------------------
538: jai_constants.tax_type_exc_edu_cess, 6,

Line 535: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740*/

531: 'ADDL. EXCISE', 1,
532: 'OTHER EXCISE', 1,
533: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
534: /*jai_constants.tax_type_exc_edu_cess, 1,
535: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740*/
536: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
537: ---------------------------------------------------
538: jai_constants.tax_type_exc_edu_cess, 6,
539: jai_constants.tax_type_cvd_edu_cess , 6,

Line 538: jai_constants.tax_type_exc_edu_cess, 6,

534: /*jai_constants.tax_type_exc_edu_cess, 1,
535: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740*/
536: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
537: ---------------------------------------------------
538: jai_constants.tax_type_exc_edu_cess, 6,
539: jai_constants.tax_type_cvd_edu_cess , 6,
540: jai_constants.tax_type_sh_exc_edu_cess, 6,
541: jai_constants.tax_type_sh_cvd_edu_cess, 6,
542: ---------------------------------------------------

Line 539: jai_constants.tax_type_cvd_edu_cess , 6,

535: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740*/
536: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
537: ---------------------------------------------------
538: jai_constants.tax_type_exc_edu_cess, 6,
539: jai_constants.tax_type_cvd_edu_cess , 6,
540: jai_constants.tax_type_sh_exc_edu_cess, 6,
541: jai_constants.tax_type_sh_cvd_edu_cess, 6,
542: ---------------------------------------------------
543: 'TDS', 2, 0)) tax_type_val,

Line 540: jai_constants.tax_type_sh_exc_edu_cess, 6,

536: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
537: ---------------------------------------------------
538: jai_constants.tax_type_exc_edu_cess, 6,
539: jai_constants.tax_type_cvd_edu_cess , 6,
540: jai_constants.tax_type_sh_exc_edu_cess, 6,
541: jai_constants.tax_type_sh_cvd_edu_cess, 6,
542: ---------------------------------------------------
543: 'TDS', 2, 0)) tax_type_val,
544: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,

Line 541: jai_constants.tax_type_sh_cvd_edu_cess, 6,

537: ---------------------------------------------------
538: jai_constants.tax_type_exc_edu_cess, 6,
539: jai_constants.tax_type_cvd_edu_cess , 6,
540: jai_constants.tax_type_sh_exc_edu_cess, 6,
541: jai_constants.tax_type_sh_cvd_edu_cess, 6,
542: ---------------------------------------------------
543: 'TDS', 2, 0)) tax_type_val,
544: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
545: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,

Line 574: jai_constants.tax_type_exc_edu_cess, 6,

570: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
571: /*'Excise_Education_cess', 1,*/
572: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
573: ---------------------------------------------------
574: jai_constants.tax_type_exc_edu_cess, 6,
575: jai_constants.tax_type_cvd_edu_cess , 6,
576: jai_constants.tax_type_sh_exc_edu_cess, 6,
577: jai_constants.tax_type_sh_cvd_edu_cess, 6,
578: ---------------------------------------------------

Line 575: jai_constants.tax_type_cvd_edu_cess , 6,

571: /*'Excise_Education_cess', 1,*/
572: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
573: ---------------------------------------------------
574: jai_constants.tax_type_exc_edu_cess, 6,
575: jai_constants.tax_type_cvd_edu_cess , 6,
576: jai_constants.tax_type_sh_exc_edu_cess, 6,
577: jai_constants.tax_type_sh_cvd_edu_cess, 6,
578: ---------------------------------------------------
579: 'TDS', 2, 0)) tax_type_val,

Line 576: jai_constants.tax_type_sh_exc_edu_cess, 6,

572: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
573: ---------------------------------------------------
574: jai_constants.tax_type_exc_edu_cess, 6,
575: jai_constants.tax_type_cvd_edu_cess , 6,
576: jai_constants.tax_type_sh_exc_edu_cess, 6,
577: jai_constants.tax_type_sh_cvd_edu_cess, 6,
578: ---------------------------------------------------
579: 'TDS', 2, 0)) tax_type_val,
580: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,

Line 577: jai_constants.tax_type_sh_cvd_edu_cess, 6,

573: ---------------------------------------------------
574: jai_constants.tax_type_exc_edu_cess, 6,
575: jai_constants.tax_type_cvd_edu_cess , 6,
576: jai_constants.tax_type_sh_exc_edu_cess, 6,
577: jai_constants.tax_type_sh_cvd_edu_cess, 6,
578: ---------------------------------------------------
579: 'TDS', 2, 0)) tax_type_val,
580: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
581: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,

Line 612: jai_constants.tax_type_exc_edu_cess, 6,

608: --Comment out by Kevin Cheng for inclusive tax Dec 18, 2007
609: /*'Excise_Education_cess', 1,*/
610: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
611: ---------------------------------------------------
612: jai_constants.tax_type_exc_edu_cess, 6,
613: jai_constants.tax_type_cvd_edu_cess , 6,
614: jai_constants.tax_type_sh_exc_edu_cess, 6,
615: jai_constants.tax_type_sh_cvd_edu_cess, 6,
616: ---------------------------------------------------

Line 613: jai_constants.tax_type_cvd_edu_cess , 6,

609: /*'Excise_Education_cess', 1,*/
610: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
611: ---------------------------------------------------
612: jai_constants.tax_type_exc_edu_cess, 6,
613: jai_constants.tax_type_cvd_edu_cess , 6,
614: jai_constants.tax_type_sh_exc_edu_cess, 6,
615: jai_constants.tax_type_sh_cvd_edu_cess, 6,
616: ---------------------------------------------------
617: 'TDS', 2, 0)) tax_type_val,

Line 614: jai_constants.tax_type_sh_exc_edu_cess, 6,

610: --Add by Kevin Cheng for inclusive tax Dec 18, 2007
611: ---------------------------------------------------
612: jai_constants.tax_type_exc_edu_cess, 6,
613: jai_constants.tax_type_cvd_edu_cess , 6,
614: jai_constants.tax_type_sh_exc_edu_cess, 6,
615: jai_constants.tax_type_sh_cvd_edu_cess, 6,
616: ---------------------------------------------------
617: 'TDS', 2, 0)) tax_type_val,
618: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,

Line 615: jai_constants.tax_type_sh_cvd_edu_cess, 6,

611: ---------------------------------------------------
612: jai_constants.tax_type_exc_edu_cess, 6,
613: jai_constants.tax_type_cvd_edu_cess , 6,
614: jai_constants.tax_type_sh_exc_edu_cess, 6,
615: jai_constants.tax_type_sh_cvd_edu_cess, 6,
616: ---------------------------------------------------
617: 'TDS', 2, 0)) tax_type_val,
618: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
619: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,

Line 1345: jai_constants.tax_type_exc_edu_cess, 1,

1341: DECODE(aa.regime_code, 'VAT', 4, DECODE( UPPER( A.Tax_Type ),
1342: 'EXCISE', 1,
1343: 'ADDL. EXCISE', 1,
1344: 'OTHER EXCISE', 1,
1345: jai_constants.tax_type_exc_edu_cess, 1,
1346: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740
1347: 'TDS', 2, 0)) tax_type_val,
1348: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1349: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,

Line 1346: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740

1342: 'EXCISE', 1,
1343: 'ADDL. EXCISE', 1,
1344: 'OTHER EXCISE', 1,
1345: jai_constants.tax_type_exc_edu_cess, 1,
1346: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno5989740
1347: 'TDS', 2, 0)) tax_type_val,
1348: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1349: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
1350: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag

Line 1386: jai_constants.tax_type_exc_edu_cess, 1,

1382: DECODE(aa.regime_code, 'VAT', 4, DECODE( UPPER( A.Tax_Type ),
1383: 'EXCISE', 1,
1384: 'ADDL. EXCISE', 1,
1385: 'OTHER EXCISE', 1,
1386: jai_constants.tax_type_exc_edu_cess, 1,
1387: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740
1388:
1389: 'TDS', 2, 0)) tax_type_val,
1390: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,

Line 1387: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740

1383: 'EXCISE', 1,
1384: 'ADDL. EXCISE', 1,
1385: 'OTHER EXCISE', 1,
1386: jai_constants.tax_type_exc_edu_cess, 1,
1387: jai_constants.tax_type_sh_exc_edu_cess, 1,--Added by kunkumar for bugno 5989740
1388:
1389: 'TDS', 2, 0)) tax_type_val,
1390: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1391: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,

Line 1593: ( JAI_CONSTANTS.tax_type_customs

1589: , lv_third_party_flag;
1590: CLOSE get_rcv_line_for_retro;
1591:
1592: IF( lv_tax_type IN
1593: ( JAI_CONSTANTS.tax_type_customs
1594: , JAI_CONSTANTS.tax_type_customs_edu_cess
1595: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
1596: , JAI_CONSTANTS.tax_type_cvd
1597: , JAI_CONSTANTS.tax_type_cvd_edu_cess

Line 1594: , JAI_CONSTANTS.tax_type_customs_edu_cess

1590: CLOSE get_rcv_line_for_retro;
1591:
1592: IF( lv_tax_type IN
1593: ( JAI_CONSTANTS.tax_type_customs
1594: , JAI_CONSTANTS.tax_type_customs_edu_cess
1595: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
1596: , JAI_CONSTANTS.tax_type_cvd
1597: , JAI_CONSTANTS.tax_type_cvd_edu_cess
1598: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess

Line 1595: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess

1591:
1592: IF( lv_tax_type IN
1593: ( JAI_CONSTANTS.tax_type_customs
1594: , JAI_CONSTANTS.tax_type_customs_edu_cess
1595: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
1596: , JAI_CONSTANTS.tax_type_cvd
1597: , JAI_CONSTANTS.tax_type_cvd_edu_cess
1598: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess
1599: )

Line 1596: , JAI_CONSTANTS.tax_type_cvd

1592: IF( lv_tax_type IN
1593: ( JAI_CONSTANTS.tax_type_customs
1594: , JAI_CONSTANTS.tax_type_customs_edu_cess
1595: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
1596: , JAI_CONSTANTS.tax_type_cvd
1597: , JAI_CONSTANTS.tax_type_cvd_edu_cess
1598: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess
1599: )
1600: OR lv_third_party_flag = 'Y'

Line 1597: , JAI_CONSTANTS.tax_type_cvd_edu_cess

1593: ( JAI_CONSTANTS.tax_type_customs
1594: , JAI_CONSTANTS.tax_type_customs_edu_cess
1595: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
1596: , JAI_CONSTANTS.tax_type_cvd
1597: , JAI_CONSTANTS.tax_type_cvd_edu_cess
1598: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess
1599: )
1600: OR lv_third_party_flag = 'Y'
1601: )

Line 1598: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess

1594: , JAI_CONSTANTS.tax_type_customs_edu_cess
1595: , JAI_CONSTANTS.tax_type_sh_customs_edu_Cess
1596: , JAI_CONSTANTS.tax_type_cvd
1597: , JAI_CONSTANTS.tax_type_cvd_edu_cess
1598: , JAI_CONSTANTS.tax_type_sh_cvd_edu_cess
1599: )
1600: OR lv_third_party_flag = 'Y'
1601: )
1602: THEN

Line 2880: /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,

2876: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
2877: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
2878: /* added by ssawant for bug 5989740 */
2879: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
2880: /*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,
2881: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2882: ---------------------------------------------------
2883: jai_constants.tax_type_exc_edu_cess, 6,
2884: jai_constants.tax_type_cvd_edu_cess , 6,

Line 2883: jai_constants.tax_type_exc_edu_cess, 6,

2879: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
2880: /*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,
2881: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2882: ---------------------------------------------------
2883: jai_constants.tax_type_exc_edu_cess, 6,
2884: jai_constants.tax_type_cvd_edu_cess , 6,
2885: jai_constants.tax_type_sh_exc_edu_cess, 6,
2886: jai_constants.tax_type_sh_cvd_edu_cess, 6,
2887: ---------------------------------------------------

Line 2884: jai_constants.tax_type_cvd_edu_cess , 6,

2880: /*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,
2881: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2882: ---------------------------------------------------
2883: jai_constants.tax_type_exc_edu_cess, 6,
2884: jai_constants.tax_type_cvd_edu_cess , 6,
2885: jai_constants.tax_type_sh_exc_edu_cess, 6,
2886: jai_constants.tax_type_sh_cvd_edu_cess, 6,
2887: ---------------------------------------------------
2888: 'TDS', 2, 0

Line 2885: jai_constants.tax_type_sh_exc_edu_cess, 6,

2881: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2882: ---------------------------------------------------
2883: jai_constants.tax_type_exc_edu_cess, 6,
2884: jai_constants.tax_type_cvd_edu_cess , 6,
2885: jai_constants.tax_type_sh_exc_edu_cess, 6,
2886: jai_constants.tax_type_sh_cvd_edu_cess, 6,
2887: ---------------------------------------------------
2888: 'TDS', 2, 0
2889: )

Line 2886: jai_constants.tax_type_sh_cvd_edu_cess, 6,

2882: ---------------------------------------------------
2883: jai_constants.tax_type_exc_edu_cess, 6,
2884: jai_constants.tax_type_cvd_edu_cess , 6,
2885: jai_constants.tax_type_sh_exc_edu_cess, 6,
2886: jai_constants.tax_type_sh_cvd_edu_cess, 6,
2887: ---------------------------------------------------
2888: 'TDS', 2, 0
2889: )
2890: ) tax_type_val

Line 2920: /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,

2916: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
2917: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
2918: /* added by ssawant for bug 5989740 */
2919: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
2920: /*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,
2921: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2922: ---------------------------------------------------
2923: jai_constants.tax_type_exc_edu_cess, 6,
2924: jai_constants.tax_type_cvd_edu_cess , 6,

Line 2923: jai_constants.tax_type_exc_edu_cess, 6,

2919: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
2920: /*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,
2921: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2922: ---------------------------------------------------
2923: jai_constants.tax_type_exc_edu_cess, 6,
2924: jai_constants.tax_type_cvd_edu_cess , 6,
2925: jai_constants.tax_type_sh_exc_edu_cess, 6,
2926: jai_constants.tax_type_sh_cvd_edu_cess, 6,
2927: ---------------------------------------------------

Line 2924: jai_constants.tax_type_cvd_edu_cess , 6,

2920: /*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,
2921: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2922: ---------------------------------------------------
2923: jai_constants.tax_type_exc_edu_cess, 6,
2924: jai_constants.tax_type_cvd_edu_cess , 6,
2925: jai_constants.tax_type_sh_exc_edu_cess, 6,
2926: jai_constants.tax_type_sh_cvd_edu_cess, 6,
2927: ---------------------------------------------------
2928: 'TDS', 2, 0

Line 2925: jai_constants.tax_type_sh_exc_edu_cess, 6,

2921: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2922: ---------------------------------------------------
2923: jai_constants.tax_type_exc_edu_cess, 6,
2924: jai_constants.tax_type_cvd_edu_cess , 6,
2925: jai_constants.tax_type_sh_exc_edu_cess, 6,
2926: jai_constants.tax_type_sh_cvd_edu_cess, 6,
2927: ---------------------------------------------------
2928: 'TDS', 2, 0
2929: )

Line 2926: jai_constants.tax_type_sh_cvd_edu_cess, 6,

2922: ---------------------------------------------------
2923: jai_constants.tax_type_exc_edu_cess, 6,
2924: jai_constants.tax_type_cvd_edu_cess , 6,
2925: jai_constants.tax_type_sh_exc_edu_cess, 6,
2926: jai_constants.tax_type_sh_cvd_edu_cess, 6,
2927: ---------------------------------------------------
2928: 'TDS', 2, 0
2929: )
2930: ) tax_type_val,

Line 2960: AND tax_type <> jai_constants.tax_type_tds; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

2956: CURSOR fetch_sum_cur( p_line_location_id IN NUMBER ) IS
2957: SELECT SUM( NVL( tax_amount, 0 ) )
2958: FROM JAI_PO_TAXES
2959: WHERE line_location_id = p_line_location_id -- For Blanket Rel Line Loc Id is passed in place of header id.
2960: AND tax_type <> jai_constants.tax_type_tds; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2961:
2962: CURSOR fetch_line_uom_code IS
2963: SELECT uom_code
2964: FROM po_lines_all plines, mtl_units_of_measure units

Line 2997: jai_constants.tax_type_sh_exc_edu_cess,1,*/

2993: 'ADDL. EXCISE', 1,
2994: 'OTHER EXCISE', 1,
2995: --Comment out by Kevin Cheng for inclusive tax Dec 17, 2007
2996: /*'Excise_Education_cess', 1,
2997: jai_constants.tax_type_sh_exc_edu_cess,1,*/
2998: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2999: ---------------------------------------------------
3000: jai_constants.tax_type_exc_edu_cess, 6,
3001: jai_constants.tax_type_cvd_edu_cess , 6,

Line 3000: jai_constants.tax_type_exc_edu_cess, 6,

2996: /*'Excise_Education_cess', 1,
2997: jai_constants.tax_type_sh_exc_edu_cess,1,*/
2998: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2999: ---------------------------------------------------
3000: jai_constants.tax_type_exc_edu_cess, 6,
3001: jai_constants.tax_type_cvd_edu_cess , 6,
3002: jai_constants.tax_type_sh_exc_edu_cess, 6,
3003: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3004: ----------------------------------------------------

Line 3001: jai_constants.tax_type_cvd_edu_cess , 6,

2997: jai_constants.tax_type_sh_exc_edu_cess,1,*/
2998: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2999: ---------------------------------------------------
3000: jai_constants.tax_type_exc_edu_cess, 6,
3001: jai_constants.tax_type_cvd_edu_cess , 6,
3002: jai_constants.tax_type_sh_exc_edu_cess, 6,
3003: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3004: ----------------------------------------------------
3005: 'TDS', 2,

Line 3002: jai_constants.tax_type_sh_exc_edu_cess, 6,

2998: --Add by Kevin Cheng for inclusive tax Dec 17, 2007
2999: ---------------------------------------------------
3000: jai_constants.tax_type_exc_edu_cess, 6,
3001: jai_constants.tax_type_cvd_edu_cess , 6,
3002: jai_constants.tax_type_sh_exc_edu_cess, 6,
3003: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3004: ----------------------------------------------------
3005: 'TDS', 2,
3006: 0)) tax_type_val,

Line 3003: jai_constants.tax_type_sh_cvd_edu_cess, 6,

2999: ---------------------------------------------------
3000: jai_constants.tax_type_exc_edu_cess, 6,
3001: jai_constants.tax_type_cvd_edu_cess , 6,
3002: jai_constants.tax_type_sh_exc_edu_cess, 6,
3003: jai_constants.tax_type_sh_cvd_edu_cess, 6,
3004: ----------------------------------------------------
3005: 'TDS', 2,
3006: 0)) tax_type_val,
3007: A.Tax_Rate tax_rate,

Line 3054: 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,

3050: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3051: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3052: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3053: /* added by ssawant for bug 5989740 */
3054: 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,
3055: 'TDS', 2, 0
3056: )
3057: ) tax_type_val
3058: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa

Line 3086: 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,

3082: DECODE( UPPER( A.Tax_Type ),'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, --'CVD', 1,
3083: --'ADDITIONAL_CVD',1, -- Added by Girish , w.r.t BUG#5143906
3084: --commented the CVD, ADDITIONAL_CVD and cvd_edu_cess for Bug#5219225 by Sanjikum
3085: /* added by ssawant for bug 5989740 */
3086: 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,
3087: 'TDS', 2, 0
3088: )
3089: ) tax_type_val,
3090: A.Tax_Rate tax_rate,

Line 3130: jai_constants.tax_type_sh_exc_edu_cess,1,

3126: 'EXCISE', 1,
3127: 'ADDL. EXCISE', 1,
3128: 'OTHER EXCISE', 1,
3129: 'Excise_Education_cess', 1,
3130: jai_constants.tax_type_sh_exc_edu_cess,1,
3131: 'TDS', 2,
3132: 0)) tax_type_val,
3133: A.Tax_Rate tax_rate,
3134: A.Qty_Rate Qty_Rate,

Line 3230: v_debug := jai_constants.no;

3226: vamt := 0;
3227: max_iter := 15; -- Date 03/11/2006 Bug 5228046 added by SACSETHI
3228: v_curr := p_line_uom_code;
3229: v_line_uom_code := p_line_uom_code;
3230: v_debug := jai_constants.no;
3231:
3232: IF v_debug = 'Y' THEN
3233: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
3234: fnd_file.put_line(fnd_file.log,

Line 4211: v_debug := jai_constants.no;

4207: vamt := 0;
4208: max_iter := 15; -- Date 03/11/2006 Bug 5228046 added by SACSETHI
4209: v_curr := p_line_uom_code;
4210: v_line_uom_code := p_line_uom_code;
4211: v_debug := jai_constants.no;
4212:
4213: IF v_debug = 'Y' THEN
4214: fnd_file.put_line(fnd_file.log, 'Entered into the procedure 2' );
4215: fnd_file.put_line(fnd_file.log,

Line 5917: AND Tax_Type <> jai_constants.tax_type_tds; --'TDS';

5913: CURSOR Fetch_Tot_Sum_Cur( llid IN NUMBER ) IS
5914: SELECT SUM( NVL( Tax_Amount, 0 ) )
5915: FROM JAI_PO_TAXES
5916: WHERE Line_Location_Id = llid
5917: AND Tax_Type <> jai_constants.tax_type_tds; --'TDS';
5918:
5919: CURSOR Get_Assessable_Val_Cur IS
5920: SELECT Vendor_Id, Vendor_Site_Id, Currency_Code
5921: FROM Po_Headers_All

Line 6858: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI

6854: * Added CVD and Customs Education Cess */
6855:
6856: IF upper(v_tax_type) IN ( 'CUSTOMS',
6857: 'CVD',
6858: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
6859: jai_constants.tax_type_customs_edu_cess,jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
6860: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess) /* added by ssawant for bug 5989740 */
6861: THEN
6862: v_vendor_id := NULL;

Line 6859: jai_constants.tax_type_customs_edu_cess,jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */

6855:
6856: IF upper(v_tax_type) IN ( 'CUSTOMS',
6857: 'CVD',
6858: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
6859: jai_constants.tax_type_customs_edu_cess,jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
6860: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess) /* added by ssawant for bug 5989740 */
6861: THEN
6862: v_vendor_id := NULL;
6863: ELSIF v_tax_type = 'TDS' THEN

Line 6860: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess) /* added by ssawant for bug 5989740 */

6856: IF upper(v_tax_type) IN ( 'CUSTOMS',
6857: 'CVD',
6858: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
6859: jai_constants.tax_type_customs_edu_cess,jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
6860: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess) /* added by ssawant for bug 5989740 */
6861: THEN
6862: v_vendor_id := NULL;
6863: ELSIF v_tax_type = 'TDS' THEN
6864: v_vendor_id := v_vendor1_id;

Line 6937: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI

6933: END IF;
6934:
6935: IF v_tax_type IN ( 'Customs',
6936: 'CVD',
6937: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
6938: jai_constants.tax_type_customs_edu_cess, jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
6939: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess /* added by ssawant for bug 5989740 */
6940: ) THEN
6941: v_vendor_id := NULL;

Line 6938: jai_constants.tax_type_customs_edu_cess, jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */

6934:
6935: IF v_tax_type IN ( 'Customs',
6936: 'CVD',
6937: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
6938: jai_constants.tax_type_customs_edu_cess, jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
6939: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess /* added by ssawant for bug 5989740 */
6940: ) THEN
6941: v_vendor_id := NULL;
6942: ELSIF v_tax_type = 'TDS' THEN

Line 6939: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess /* added by ssawant for bug 5989740 */

6935: IF v_tax_type IN ( 'Customs',
6936: 'CVD',
6937: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
6938: jai_constants.tax_type_customs_edu_cess, jai_constants.tax_type_sh_customs_edu_cess, /* added by ssawant for bug 5989740 */
6939: jai_constants.tax_type_cvd_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess /* added by ssawant for bug 5989740 */
6940: ) THEN
6941: v_vendor_id := NULL;
6942: ELSIF v_tax_type = 'TDS' THEN
6943: v_vendor_id := v_vendor1_id;

Line 7164: AND Tax_Type <> jai_constants.tax_type_tds; -- 'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

7160: CURSOR Fetch_Sum_Cur IS
7161: SELECT SUM( NVL( Tax_Amount, 0 ) )
7162: FROM JAI_PO_TAXES
7163: WHERE Line_Location_Id = v_line_loc_id
7164: AND Tax_Type <> jai_constants.tax_type_tds; -- 'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
7165:
7166: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.ja_in_po_case2';
7167:
7168: BEGIN