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_AP_MATCH_TAX_PKG dependencies on JAI_CONSTANTS

Line 95: p_organization_type => jai_constants.orgn_type_io,/5694855/

91: ln_service_interim_account :=
92: jai_cmn_rgm_recording_pkg.get_account
93: (
94: p_regime_id => p_service_regime_id,
95: p_organization_type => jai_constants.orgn_type_io,/*5694855*/
96: p_organization_id => ln_organization_id,/*5694855*/
97: p_location_id => ln_location_id, /*5694855*/
98: p_tax_type => p_tax_type,
99: p_account_name => jai_constants.recovery_interim

Line 99: p_account_name => jai_constants.recovery_interim

95: p_organization_type => jai_constants.orgn_type_io,/*5694855*/
96: p_organization_id => ln_organization_id,/*5694855*/
97: p_location_id => ln_location_id, /*5694855*/
98: p_tax_type => p_tax_type,
99: p_account_name => jai_constants.recovery_interim
100: );
101:
102: return ln_service_interim_account;
103:

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

578: WHERE line_location_id = p_line_location_id -- 3096578
579: AND NVL(upper(tax_type), 'A') NOT IN
580: ('TDS',
581: 'CVD',
582: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
583: 'CUSTOMS',
584: jai_constants.tax_type_cvd_edu_cess,
585: jai_constants.tax_type_customs_edu_cess,
586: jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740

Line 584: jai_constants.tax_type_cvd_edu_cess,

580: ('TDS',
581: 'CVD',
582: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
583: 'CUSTOMS',
584: jai_constants.tax_type_cvd_edu_cess,
585: jai_constants.tax_type_customs_edu_cess,
586: jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
587: )
588: AND NVL(vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895

Line 585: jai_constants.tax_type_customs_edu_cess,

581: 'CVD',
582: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
583: 'CUSTOMS',
584: jai_constants.tax_type_cvd_edu_cess,
585: jai_constants.tax_type_customs_edu_cess,
586: jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
587: )
588: AND NVL(vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895
589: order by tax_line_no; -- added bug#3038566

Line 586: jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740

582: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
583: 'CUSTOMS',
584: jai_constants.tax_type_cvd_edu_cess,
585: jai_constants.tax_type_customs_edu_cess,
586: jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
587: )
588: AND NVL(vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895
589: order by tax_line_no; -- added bug#3038566
590: -- AND tax_amount <> 0 ; -- commented by aparajita on 10/03/2003 for bug # 2841363

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

612: WHERE line_location_id = p_line_location_id -- 3096578
613: AND NVL(UPPER(jpt.tax_type), 'A')
614: NOT IN( 'TDS'
615: , 'CVD'
616: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
617: , 'CUSTOMS'
618: , jai_constants.tax_type_cvd_edu_cess
619: , jai_constants.tax_type_customs_edu_cess
620: , jai_constants.tax_type_sh_cvd_edu_cess

Line 618: , jai_constants.tax_type_cvd_edu_cess

614: NOT IN( 'TDS'
615: , 'CVD'
616: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
617: , 'CUSTOMS'
618: , jai_constants.tax_type_cvd_edu_cess
619: , jai_constants.tax_type_customs_edu_cess
620: , jai_constants.tax_type_sh_cvd_edu_cess
621: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
622: )

Line 619: , jai_constants.tax_type_customs_edu_cess

615: , 'CVD'
616: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
617: , 'CUSTOMS'
618: , jai_constants.tax_type_cvd_edu_cess
619: , jai_constants.tax_type_customs_edu_cess
620: , jai_constants.tax_type_sh_cvd_edu_cess
621: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
622: )
623: AND jcta.tax_id = jpt.tax_id

Line 620: , jai_constants.tax_type_sh_cvd_edu_cess

616: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
617: , 'CUSTOMS'
618: , jai_constants.tax_type_cvd_edu_cess
619: , jai_constants.tax_type_customs_edu_cess
620: , jai_constants.tax_type_sh_cvd_edu_cess
621: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
622: )
623: AND jcta.tax_id = jpt.tax_id
624: AND NVL(jpt.vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895

Line 621: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740

617: , 'CUSTOMS'
618: , jai_constants.tax_type_cvd_edu_cess
619: , jai_constants.tax_type_customs_edu_cess
620: , jai_constants.tax_type_sh_cvd_edu_cess
621: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
622: )
623: AND jcta.tax_id = jpt.tax_id
624: AND NVL(jpt.vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895
625: AND p_source <> 'PPA'

Line 654: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds

650: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')
651: AND jrl.tax_id = jcta.tax_id
652: AND NVL(jrlc.vendor_id, -1) = vend_id
653: AND p_source = 'PPA'
654: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
655: , jai_constants.tax_type_cvd
656: , jai_constants.tax_type_add_cvd
657: , jai_constants.tax_type_customs
658: , jai_constants.tax_type_sh_customs_edu_cess

Line 655: , jai_constants.tax_type_cvd

651: AND jrl.tax_id = jcta.tax_id
652: AND NVL(jrlc.vendor_id, -1) = vend_id
653: AND p_source = 'PPA'
654: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
655: , jai_constants.tax_type_cvd
656: , jai_constants.tax_type_add_cvd
657: , jai_constants.tax_type_customs
658: , jai_constants.tax_type_sh_customs_edu_cess
659: , jai_constants.tax_type_customs_edu_cess

Line 656: , jai_constants.tax_type_add_cvd

652: AND NVL(jrlc.vendor_id, -1) = vend_id
653: AND p_source = 'PPA'
654: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
655: , jai_constants.tax_type_cvd
656: , jai_constants.tax_type_add_cvd
657: , jai_constants.tax_type_customs
658: , jai_constants.tax_type_sh_customs_edu_cess
659: , jai_constants.tax_type_customs_edu_cess
660: , jai_constants.tax_type_sh_cvd_edu_cess

Line 657: , jai_constants.tax_type_customs

653: AND p_source = 'PPA'
654: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
655: , jai_constants.tax_type_cvd
656: , jai_constants.tax_type_add_cvd
657: , jai_constants.tax_type_customs
658: , jai_constants.tax_type_sh_customs_edu_cess
659: , jai_constants.tax_type_customs_edu_cess
660: , jai_constants.tax_type_sh_cvd_edu_cess
661: , jai_constants.tax_type_cvd_edu_cess

Line 658: , jai_constants.tax_type_sh_customs_edu_cess

654: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
655: , jai_constants.tax_type_cvd
656: , jai_constants.tax_type_add_cvd
657: , jai_constants.tax_type_customs
658: , jai_constants.tax_type_sh_customs_edu_cess
659: , jai_constants.tax_type_customs_edu_cess
660: , jai_constants.tax_type_sh_cvd_edu_cess
661: , jai_constants.tax_type_cvd_edu_cess
662: )

Line 659: , jai_constants.tax_type_customs_edu_cess

655: , jai_constants.tax_type_cvd
656: , jai_constants.tax_type_add_cvd
657: , jai_constants.tax_type_customs
658: , jai_constants.tax_type_sh_customs_edu_cess
659: , jai_constants.tax_type_customs_edu_cess
660: , jai_constants.tax_type_sh_cvd_edu_cess
661: , jai_constants.tax_type_cvd_edu_cess
662: )
663: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416

Line 660: , jai_constants.tax_type_sh_cvd_edu_cess

656: , jai_constants.tax_type_add_cvd
657: , jai_constants.tax_type_customs
658: , jai_constants.tax_type_sh_customs_edu_cess
659: , jai_constants.tax_type_customs_edu_cess
660: , jai_constants.tax_type_sh_cvd_edu_cess
661: , jai_constants.tax_type_cvd_edu_cess
662: )
663: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
664: ---------------------------------------------------------------------

Line 661: , jai_constants.tax_type_cvd_edu_cess

657: , jai_constants.tax_type_customs
658: , jai_constants.tax_type_sh_customs_edu_cess
659: , jai_constants.tax_type_customs_edu_cess
660: , jai_constants.tax_type_sh_cvd_edu_cess
661: , jai_constants.tax_type_cvd_edu_cess
662: )
663: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
664: ---------------------------------------------------------------------
665: ORDER BY tax_line_no; -- added bug#3038566

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

740: AND jrl.vendor_id = ven_id
741: AND NVL(upper(jrl.tax_type),'TDS') NOT IN (
742: 'TDS',
743: 'CVD',
744: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
745: 'CUSTOMS',
746: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, -- added by ssawant for bug 5989740
747: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess --added by ssawant for bug 5989740
748: )

Line 746: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, -- added by ssawant for bug 5989740

742: 'TDS',
743: 'CVD',
744: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
745: 'CUSTOMS',
746: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, -- added by ssawant for bug 5989740
747: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess --added by ssawant for bug 5989740
748: )
749: order by tax_line_no -- added bug#3038566
750: ;

Line 747: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess --added by ssawant for bug 5989740

743: 'CVD',
744: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
745: 'CUSTOMS',
746: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, -- added by ssawant for bug 5989740
747: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess --added by ssawant for bug 5989740
748: )
749: order by tax_line_no -- added bug#3038566
750: ;
751: */

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

775: AND jcta.tax_id = jrl.tax_id --Added by Eric for Inclusive Tax
776: AND NVL(upper(jrl.tax_type),'TDS')
777: NOT IN ( 'TDS'
778: , 'CVD'
779: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
780: , 'CUSTOMS'
781: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
782: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
783: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS

Line 781: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS

777: NOT IN ( 'TDS'
778: , 'CVD'
779: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
780: , 'CUSTOMS'
781: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
782: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
783: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
784: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
785: )

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

778: , 'CVD'
779: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
780: , 'CUSTOMS'
781: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
782: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
783: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
784: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
785: )
786: order by tax_line_no; -- added

Line 783: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS

779: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
780: , 'CUSTOMS'
781: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
782: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
783: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
784: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
785: )
786: order by tax_line_no; -- added
787:

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

780: , 'CUSTOMS'
781: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
782: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
783: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
784: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
785: )
786: order by tax_line_no; -- added
787:
788:

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

814: AND jcta.tax_id = jrl.tax_id --Added by Eric for Inclusive Tax
815: AND NVL(upper(jrl.tax_type),'TDS') NOT IN
816: ('TDS',
817: 'CVD',
818: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
819: 'CUSTOMS',
820: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */
821: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
822: )

Line 820: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */

816: ('TDS',
817: 'CVD',
818: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
819: 'CUSTOMS',
820: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */
821: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
822: )
823: AND p_source <> 'PPA'
824:

Line 821: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */

817: 'CVD',
818: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
819: 'CUSTOMS',
820: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */
821: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
822: )
823: AND p_source <> 'PPA'
824:
825: UNION

Line 854: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds

850: AND rt.shipment_line_id = rsl.shipment_line_id
851: AND rt.transaction_id = tran_id
852: AND jrlc.vendor_id = ven_id
853: AND p_source = 'PPA'
854: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
855: , jai_constants.tax_type_cvd
856: , jai_constants.tax_type_add_cvd
857: , jai_constants.tax_type_customs
858: , jai_constants.tax_type_sh_customs_edu_cess

Line 855: , jai_constants.tax_type_cvd

851: AND rt.transaction_id = tran_id
852: AND jrlc.vendor_id = ven_id
853: AND p_source = 'PPA'
854: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
855: , jai_constants.tax_type_cvd
856: , jai_constants.tax_type_add_cvd
857: , jai_constants.tax_type_customs
858: , jai_constants.tax_type_sh_customs_edu_cess
859: , jai_constants.tax_type_customs_edu_cess

Line 856: , jai_constants.tax_type_add_cvd

852: AND jrlc.vendor_id = ven_id
853: AND p_source = 'PPA'
854: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
855: , jai_constants.tax_type_cvd
856: , jai_constants.tax_type_add_cvd
857: , jai_constants.tax_type_customs
858: , jai_constants.tax_type_sh_customs_edu_cess
859: , jai_constants.tax_type_customs_edu_cess
860: , jai_constants.tax_type_sh_cvd_edu_cess

Line 857: , jai_constants.tax_type_customs

853: AND p_source = 'PPA'
854: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
855: , jai_constants.tax_type_cvd
856: , jai_constants.tax_type_add_cvd
857: , jai_constants.tax_type_customs
858: , jai_constants.tax_type_sh_customs_edu_cess
859: , jai_constants.tax_type_customs_edu_cess
860: , jai_constants.tax_type_sh_cvd_edu_cess
861: , jai_constants.tax_type_cvd_edu_cess

Line 858: , jai_constants.tax_type_sh_customs_edu_cess

854: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
855: , jai_constants.tax_type_cvd
856: , jai_constants.tax_type_add_cvd
857: , jai_constants.tax_type_customs
858: , jai_constants.tax_type_sh_customs_edu_cess
859: , jai_constants.tax_type_customs_edu_cess
860: , jai_constants.tax_type_sh_cvd_edu_cess
861: , jai_constants.tax_type_cvd_edu_cess
862: )

Line 859: , jai_constants.tax_type_customs_edu_cess

855: , jai_constants.tax_type_cvd
856: , jai_constants.tax_type_add_cvd
857: , jai_constants.tax_type_customs
858: , jai_constants.tax_type_sh_customs_edu_cess
859: , jai_constants.tax_type_customs_edu_cess
860: , jai_constants.tax_type_sh_cvd_edu_cess
861: , jai_constants.tax_type_cvd_edu_cess
862: )
863: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416

Line 860: , jai_constants.tax_type_sh_cvd_edu_cess

856: , jai_constants.tax_type_add_cvd
857: , jai_constants.tax_type_customs
858: , jai_constants.tax_type_sh_customs_edu_cess
859: , jai_constants.tax_type_customs_edu_cess
860: , jai_constants.tax_type_sh_cvd_edu_cess
861: , jai_constants.tax_type_cvd_edu_cess
862: )
863: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
864: -- GROUP BY jrl.tax_id,jrl.currency,jrl.tax_type, jrl.modvat_flag; commented by bug#3038566

Line 861: , jai_constants.tax_type_cvd_edu_cess

857: , jai_constants.tax_type_customs
858: , jai_constants.tax_type_sh_customs_edu_cess
859: , jai_constants.tax_type_customs_edu_cess
860: , jai_constants.tax_type_sh_cvd_edu_cess
861: , jai_constants.tax_type_cvd_edu_cess
862: )
863: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
864: -- GROUP BY jrl.tax_id,jrl.currency,jrl.tax_type, jrl.modvat_flag; commented by bug#3038566
865: order by tax_line_no; -- added bug#3038566

Line 1014: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */

1010: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
1011: select attribute_code tax_type
1012: from JAI_RGM_REGISTRATIONS
1013: where regime_id = cp_regime_id
1014: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
1015: and attribute_code = cp_tax_type;
1016:
1017:
1018: r_rcv_transactions c_rcv_transactions%rowtype;

Line 1758: Variable usage of jai_constants package.

1754: in this patch. So no pre - req.
1755:
1756: 115.6 4146708 Base Bug for Service + Cess Release.
1757:
1758: Variable usage of jai_constants package.
1759:
1760: Call to following,
1761: jai_general_pkg.is_item_an_expense
1762: jai_general_pkg.get_accounting_method

Line 1959: open c_jai_regimes(jai_constants.service_regime);

1955: );
1956:
1957: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag='||lv_accrue_on_receipt_flag);
1958:
1959: open c_jai_regimes(jai_constants.service_regime);
1960: fetch c_jai_regimes into r_jai_regimes;
1961: close c_jai_regimes;
1962:
1963: /* service End */

Line 1969: OPEN c_jai_regimes(jai_constants.vat_regime);

1965: /* Bug 5358788. Added by Lakshmi Gopalsami
1966: * Fetch VAT Regime id
1967: */
1968:
1969: OPEN c_jai_regimes(jai_constants.vat_regime);
1970: FETCH c_jai_regimes INTO r_vat_regimes;
1971: CLOSE c_jai_regimes;
1972:
1973: /* Bug 5401111. Added by Lakshmi Gopalsami

Line 2025: if i.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then

2021: -- end bug # 2775043
2022:
2023: --Added by kunkumar for bug 5593895
2024: ln_base_amount := null ;
2025: if i.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
2026: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt(
2027: p_invoice_id => inv_id ,
2028: p_line_location_id => from_po_distributions_rec.line_location_id ,
2029: p_transaction_id => null ,

Line 2079: if i.modvat_flag = jai_constants.YES

2075: lv_tax_type := NULL;--added by eric for inclusive tax on 20-Dec,2007
2076:
2077: -- 5763527, Brathod
2078: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
2079: if i.modvat_flag = jai_constants.YES
2080: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0 then
2081:
2082: --recoverable tax
2083: lv_tax_type := 'RE'; --added by eric for inclusive tax on 20-dec,2007

Line 2154: p_organization_type => jai_constants.orgn_type_io,

2150: Fnd_File.put_line(Fnd_File.LOG, 'lv_is_item_an_expense='||lv_is_item_an_expense);
2151: v_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account
2152: (
2153: p_regime_id => ln_vat_regime_id,
2154: p_organization_type => jai_constants.orgn_type_io,
2155: p_organization_id => ln_ship_to_organization_id ,
2156: p_location_id => ln_ship_to_location_id ,
2157: p_tax_type => c_tax_rec.tax_type,
2158: p_account_name => jai_constants.recovery /*RECOVERY*/

Line 2158: p_account_name => jai_constants.recovery /RECOVERY/

2154: p_organization_type => jai_constants.orgn_type_io,
2155: p_organization_id => ln_ship_to_organization_id ,
2156: p_location_id => ln_ship_to_location_id ,
2157: p_tax_type => c_tax_rec.tax_type,
2158: p_account_name => jai_constants.recovery /*RECOVERY*/
2159: );
2160: ELSE
2161: v_dist_code_combination_id := c_tax_rec.tax_account_id;
2162: fnd_file.put_line(FND_FILE.LOG,

Line 2264: if i.modvat_flag = jai_constants.YES

2260: --added by Eric for inclusive tax on 20-dec-2007,end
2261:
2262: Fnd_File.put_line(Fnd_File.LOG, 'i.modvat_flag ='||i.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
2263:
2264: if i.modvat_flag = jai_constants.YES
2265: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
2266: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
2267: then
2268: --

Line 2307: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then

2303: elsif line = 2 then
2304:
2305: v_tax_amount := ln_nrec_tax_amt;
2306:
2307: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
2308: v_assets_tracking_flag := jai_constants.YES;
2309: end if;
2310:
2311: lv_modvat_flag := jai_constants.NO ;

Line 2308: v_assets_tracking_flag := jai_constants.YES;

2304:
2305: v_tax_amount := ln_nrec_tax_amt;
2306:
2307: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
2308: v_assets_tracking_flag := jai_constants.YES;
2309: end if;
2310:
2311: lv_modvat_flag := jai_constants.NO ;
2312:

Line 2311: lv_modvat_flag := jai_constants.NO ;

2307: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
2308: v_assets_tracking_flag := jai_constants.YES;
2309: end if;
2310:
2311: lv_modvat_flag := jai_constants.NO ;
2312:
2313: --
2314: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
2315: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 2441: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

2437: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
2438: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
2439:
2440:
2441: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
2442: v_assets_tracking_flag := jai_constants.YES;
2443: END IF;
2444:
2445: lv_modvat_flag := jai_constants.NO ;

Line 2442: v_assets_tracking_flag := jai_constants.YES;

2438: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
2439:
2440:
2441: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
2442: v_assets_tracking_flag := jai_constants.YES;
2443: END IF;
2444:
2445: lv_modvat_flag := jai_constants.NO ;
2446:

Line 2445: lv_modvat_flag := jai_constants.NO ;

2441: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
2442: v_assets_tracking_flag := jai_constants.YES;
2443: END IF;
2444:
2445: lv_modvat_flag := jai_constants.NO ;
2446:
2447: --
2448: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
2449: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 2483: lv_modvat_flag := jai_constants.NO ;

2479: ELSIF ( line = 2 )
2480: THEN
2481: v_tax_amount := ln_nrec_tax_amt ;
2482: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
2483: lv_modvat_flag := jai_constants.NO ;
2484: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
2485: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
2486:
2487: --recoverable part without project infor

Line 3024: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then

3020:
3021:
3022: -- added, kunkumar for 5593895
3023: ln_base_amount := null ;
3024: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
3025: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
3026: (
3027: p_invoice_id => inv_id ,
3028: p_line_location_id => null ,

Line 3047: if tax_lines1_rec.modvat_flag = jai_constants.YES

3043:
3044:
3045: -- 5763527, Brathod
3046: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
3047: if tax_lines1_rec.modvat_flag = jai_constants.YES
3048: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
3049: then
3050:
3051:

Line 3204: if tax_lines1_rec.modvat_flag = jai_constants.YES

3200: --added by Eric for inclusive tax on 20-dec-2007,end
3201:
3202: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
3203:
3204: if tax_lines1_rec.modvat_flag = jai_constants.YES
3205: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
3206: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
3207: then
3208: --

Line 3243: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then

3239: elsif line = 2 then
3240:
3241: v_tax_amount := ln_nrec_tax_amt;
3242:
3243: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
3244: v_assets_tracking_flag := jai_constants.YES;
3245: end if;
3246:
3247: lv_modvat_flag := jai_constants.NO ;

Line 3244: v_assets_tracking_flag := jai_constants.YES;

3240:
3241: v_tax_amount := ln_nrec_tax_amt;
3242:
3243: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
3244: v_assets_tracking_flag := jai_constants.YES;
3245: end if;
3246:
3247: lv_modvat_flag := jai_constants.NO ;
3248:

Line 3247: lv_modvat_flag := jai_constants.NO ;

3243: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
3244: v_assets_tracking_flag := jai_constants.YES;
3245: end if;
3246:
3247: lv_modvat_flag := jai_constants.NO ;
3248:
3249: --
3250: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
3251: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 3289: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

3285: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
3286: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
3287:
3288:
3289: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
3290: v_assets_tracking_flag := jai_constants.YES;
3291: END IF;
3292:
3293: lv_modvat_flag := jai_constants.NO ;

Line 3290: v_assets_tracking_flag := jai_constants.YES;

3286: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
3287:
3288:
3289: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
3290: v_assets_tracking_flag := jai_constants.YES;
3291: END IF;
3292:
3293: lv_modvat_flag := jai_constants.NO ;
3294:

Line 3293: lv_modvat_flag := jai_constants.NO ;

3289: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
3290: v_assets_tracking_flag := jai_constants.YES;
3291: END IF;
3292:
3293: lv_modvat_flag := jai_constants.NO ;
3294:
3295: --
3296: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
3297: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 3331: lv_modvat_flag := jai_constants.NO ;

3327: ELSIF ( line = 2 )
3328: THEN
3329: v_tax_amount := ln_nrec_tax_amt ;
3330: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
3331: lv_modvat_flag := jai_constants.NO ;
3332: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
3333: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
3334:
3335: --recoverable part without project infor

Line 3888: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then

3884: FETCH c_tax INTO c_tax_rec;
3885: CLOSE c_tax;
3886: -- added, kunkumar for bug 5593895
3887: ln_base_amount := null ;
3888: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
3889: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
3890: (
3891: p_invoice_id => inv_id ,
3892: p_line_location_id => null ,

Line 3910: if tax_lines1_rec.modvat_flag = jai_constants.YES

3906: lv_tax_type := NULL;--added by eric for inclusive tax on 20-Dec,2007
3907:
3908: -- 5763527, Brathod
3909: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
3910: if tax_lines1_rec.modvat_flag = jai_constants.YES
3911: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
3912: then
3913: --recoverable tax
3914: lv_tax_type := 'RE'; --added by eric for inclusive tax on 20-dec,2007

Line 4063: if tax_lines1_rec.modvat_flag = jai_constants.YES

4059:
4060:
4061: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
4062:
4063: if tax_lines1_rec.modvat_flag = jai_constants.YES
4064: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4065: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
4066: then
4067: --

Line 4106: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then

4102: elsif line = 2 then
4103:
4104: v_tax_amount := ln_nrec_tax_amt;
4105:
4106: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
4107: v_assets_tracking_flag := jai_constants.YES;
4108: end if;
4109:
4110: lv_modvat_flag := jai_constants.NO ;

Line 4107: v_assets_tracking_flag := jai_constants.YES;

4103:
4104: v_tax_amount := ln_nrec_tax_amt;
4105:
4106: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
4107: v_assets_tracking_flag := jai_constants.YES;
4108: end if;
4109:
4110: lv_modvat_flag := jai_constants.NO ;
4111:

Line 4110: lv_modvat_flag := jai_constants.NO ;

4106: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
4107: v_assets_tracking_flag := jai_constants.YES;
4108: end if;
4109:
4110: lv_modvat_flag := jai_constants.NO ;
4111:
4112: --
4113: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
4114: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 4154: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

4150: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
4151: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
4152:
4153:
4154: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4155: v_assets_tracking_flag := jai_constants.YES;
4156: END IF;
4157:
4158: lv_modvat_flag := jai_constants.NO ;

Line 4155: v_assets_tracking_flag := jai_constants.YES;

4151: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
4152:
4153:
4154: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4155: v_assets_tracking_flag := jai_constants.YES;
4156: END IF;
4157:
4158: lv_modvat_flag := jai_constants.NO ;
4159:

Line 4158: lv_modvat_flag := jai_constants.NO ;

4154: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4155: v_assets_tracking_flag := jai_constants.YES;
4156: END IF;
4157:
4158: lv_modvat_flag := jai_constants.NO ;
4159:
4160: --
4161: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
4162: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 4196: lv_modvat_flag := jai_constants.NO ;

4192: ELSIF ( line = 2 )
4193: THEN
4194: v_tax_amount := ln_nrec_tax_amt ;
4195: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
4196: lv_modvat_flag := jai_constants.NO ;
4197: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
4198: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
4199:
4200: --recoverable part without project infor

Line 4784: if r_tax_lines_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then

4780: FETCH c_tax INTO c_tax_rec;
4781: CLOSE c_tax;
4782: -- added, kunkumar for bug#5593895
4783: ln_base_amount := null ;
4784: if r_tax_lines_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
4785: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
4786: (
4787: p_invoice_id => inv_id ,
4788: p_line_location_id => null ,

Line 4804: if r_tax_lines_rec.modvat_flag = jai_constants.YES

4800:
4801: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.mod_cr_percentage = '||c_tax_rec.mod_cr_percentage);
4802: -- 5763527, Brathod
4803: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
4804: if r_tax_lines_rec.modvat_flag = jai_constants.YES
4805: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4806: then
4807: /* recoverable tax */
4808: lv_tax_type := 'RE'; --added by eric for inclusive tax on 20-dec,2007

Line 4982: if r_tax_lines_rec.modvat_flag = jai_constants.YES

4978:
4979:
4980: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.modvat_flag ='||r_tax_lines_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
4981:
4982: if r_tax_lines_rec.modvat_flag = jai_constants.YES
4983: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4984: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
4985: then
4986: --

Line 5027: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then

5023: elsif line = 2 then
5024:
5025: v_tax_amount := ln_nrec_tax_amt;
5026:
5027: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
5028: v_assets_tracking_flag := jai_constants.YES;
5029: end if;
5030:
5031: lv_modvat_flag := jai_constants.NO ;

Line 5028: v_assets_tracking_flag := jai_constants.YES;

5024:
5025: v_tax_amount := ln_nrec_tax_amt;
5026:
5027: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
5028: v_assets_tracking_flag := jai_constants.YES;
5029: end if;
5030:
5031: lv_modvat_flag := jai_constants.NO ;
5032:

Line 5031: lv_modvat_flag := jai_constants.NO ;

5027: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
5028: v_assets_tracking_flag := jai_constants.YES;
5029: end if;
5030:
5031: lv_modvat_flag := jai_constants.NO ;
5032:
5033: --
5034: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
5035: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 5087: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

5083: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
5084: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
5085:
5086:
5087: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
5088: v_assets_tracking_flag := jai_constants.YES;
5089: END IF;
5090:
5091: lv_modvat_flag := jai_constants.NO ;

Line 5088: v_assets_tracking_flag := jai_constants.YES;

5084: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
5085:
5086:
5087: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
5088: v_assets_tracking_flag := jai_constants.YES;
5089: END IF;
5090:
5091: lv_modvat_flag := jai_constants.NO ;
5092:

Line 5091: lv_modvat_flag := jai_constants.NO ;

5087: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
5088: v_assets_tracking_flag := jai_constants.YES;
5089: END IF;
5090:
5091: lv_modvat_flag := jai_constants.NO ;
5092:
5093: --
5094: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
5095: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 5131: lv_modvat_flag := jai_constants.NO ;

5127: THEN
5128: --non recoverable part
5129: v_tax_amount := ln_nrec_tax_amt ;
5130: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
5131: lv_modvat_flag := jai_constants.NO ;
5132: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
5133: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
5134:
5135: --recoverable part without project infor

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

5846: AND jrl.vendor_id = ven_id
5847: AND jcta.tax_id = jrl.tax_id --Added by Eric for Inclusive Tax
5848: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ('TDS',
5849: 'CVD',
5850: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
5851: 'CUSTOMS',
5852: jai_constants.tax_type_customs_edu_cess,
5853: jai_constants.tax_type_cvd_edu_cess)
5854: -- GROUP BY jrl.tax_id,jrl.currency,jrl.tax_type, jrl.modvat_flag -- commented bug#3038566

Line 5852: jai_constants.tax_type_customs_edu_cess,

5848: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ('TDS',
5849: 'CVD',
5850: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
5851: 'CUSTOMS',
5852: jai_constants.tax_type_customs_edu_cess,
5853: jai_constants.tax_type_cvd_edu_cess)
5854: -- GROUP BY jrl.tax_id,jrl.currency,jrl.tax_type, jrl.modvat_flag -- commented bug#3038566
5855: order by tax_line_no -- added bug#3038566
5856: ;

Line 5853: jai_constants.tax_type_cvd_edu_cess)

5849: 'CVD',
5850: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
5851: 'CUSTOMS',
5852: jai_constants.tax_type_customs_edu_cess,
5853: jai_constants.tax_type_cvd_edu_cess)
5854: -- GROUP BY jrl.tax_id,jrl.currency,jrl.tax_type, jrl.modvat_flag -- commented bug#3038566
5855: order by tax_line_no -- added bug#3038566
5856: ;
5857:

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

5882: WHERE jpt.line_location_id = p_line_location_id -- 3096578
5883: AND jcta.tax_id = jpt.tax_id --Added by Eric for Inclusive Tax
5884: AND NVL(upper(jpt.tax_type), 'A') NOT IN ('TDS',
5885: 'CVD',
5886: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
5887: 'CUSTOMS',
5888: jai_constants.tax_type_customs_edu_cess,
5889: jai_constants.tax_type_cvd_edu_cess
5890: )

Line 5888: jai_constants.tax_type_customs_edu_cess,

5884: AND NVL(upper(jpt.tax_type), 'A') NOT IN ('TDS',
5885: 'CVD',
5886: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
5887: 'CUSTOMS',
5888: jai_constants.tax_type_customs_edu_cess,
5889: jai_constants.tax_type_cvd_edu_cess
5890: )
5891: AND NVL(jpt.vendor_id, 0) = vend_id
5892: AND cp_source <> 'ASBN'

Line 5889: jai_constants.tax_type_cvd_edu_cess

5885: 'CVD',
5886: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
5887: 'CUSTOMS',
5888: jai_constants.tax_type_customs_edu_cess,
5889: jai_constants.tax_type_cvd_edu_cess
5890: )
5891: AND NVL(jpt.vendor_id, 0) = vend_id
5892: AND cp_source <> 'ASBN'
5893: --ORDER BY tax_line_no; -- added bug#3038566 --pramasub FP | commented and order by is moved to end of the qry

Line 6058: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */

6054: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
6055: select attribute_code tax_type
6056: from JAI_RGM_REGISTRATIONS
6057: where regime_id = cp_regime_id
6058: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
6059: and attribute_code = cp_tax_type;
6060:
6061: /*Added by kunkumar for bug#5593895*/
6062: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is

Line 6606: Variable usage of jai_constants package.

6602: in this patch. So no pre - req.
6603:
6604: 115.3 4146708 Base Bug for Service + Cess Release.
6605:
6606: Variable usage of jai_constants package.
6607:
6608: Call to following,
6609: jai_general_pkg.is_item_an_expense
6610: jai_general_pkg.get_accounting_method

Line 6786: open c_jai_regimes(jai_constants.service_regime);

6782:
6783: lv_accrue_on_receipt_flag :=
6784: jai_rcv_trx_processing_pkg.get_accrue_on_receipt(p_po_distribution_id => po_dist_id);
6785:
6786: open c_jai_regimes(jai_constants.service_regime);
6787: fetch c_jai_regimes into r_jai_regimes;
6788: close c_jai_regimes;
6789:
6790: /* service End */

Line 6796: OPEN c_jai_regimes(jai_constants.vat_regime);

6792: /* Bug 5358788. Added by Lakshmi Gopalsami
6793: * Fetch VAT Regime id
6794: */
6795:
6796: OPEN c_jai_regimes(jai_constants.vat_regime);
6797: FETCH c_jai_regimes INTO r_vat_regimes;
6798: CLOSE c_jai_regimes;
6799:
6800: /* Bug 5401111. Added by Lakshmi Gopalsami

Line 6856: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then

6852: r_vat_regime_tax_type := null;
6853:
6854: -- added, Kunkumar for Bug#5593895
6855: ln_base_amount := null ;
6856: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
6857: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
6858: (
6859: p_invoice_id => inv_id ,
6860: p_line_location_id => null ,

Line 7026: if tax_lines1_rec.modvat_flag = jai_constants.YES

7022: --added by Eric for inclusive tax on 20-dec-2007,end
7023:
7024: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
7025:
7026: if tax_lines1_rec.modvat_flag = jai_constants.YES
7027: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
7028: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
7029: then
7030: --

Line 7065: v_assets_tracking_flag := jai_constants.YES;

7061:
7062: elsif line = 2 then
7063:
7064: v_tax_amount := ln_nrec_tax_amt;
7065: v_assets_tracking_flag := jai_constants.YES;
7066: lv_modvat_flag := jai_constants.NO ;
7067:
7068: --
7069: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating

Line 7066: lv_modvat_flag := jai_constants.NO ;

7062: elsif line = 2 then
7063:
7064: v_tax_amount := ln_nrec_tax_amt;
7065: v_assets_tracking_flag := jai_constants.YES;
7066: lv_modvat_flag := jai_constants.NO ;
7067:
7068: --
7069: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
7070: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 7110: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

7106: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
7107: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
7108:
7109:
7110: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
7111: v_assets_tracking_flag := jai_constants.YES;
7112: END IF;
7113:
7114: lv_modvat_flag := jai_constants.NO ;

Line 7111: v_assets_tracking_flag := jai_constants.YES;

7107: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
7108:
7109:
7110: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
7111: v_assets_tracking_flag := jai_constants.YES;
7112: END IF;
7113:
7114: lv_modvat_flag := jai_constants.NO ;
7115:

Line 7114: lv_modvat_flag := jai_constants.NO ;

7110: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
7111: v_assets_tracking_flag := jai_constants.YES;
7112: END IF;
7113:
7114: lv_modvat_flag := jai_constants.NO ;
7115:
7116: --
7117: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
7118: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 7152: lv_modvat_flag := jai_constants.NO ;

7148: ELSIF ( line = 2 )
7149: THEN
7150: v_tax_amount := ln_nrec_tax_amt ;
7151: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
7152: lv_modvat_flag := jai_constants.NO ;
7153: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
7154: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
7155:
7156: --recoverable part without project infor

Line 7688: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then

7684: r_vat_regime_tax_type := null;
7685:
7686: -- added, Kunkumar for bug#5593895
7687: ln_base_amount := null ;
7688: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
7689: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
7690: (
7691: p_invoice_id => inv_id ,
7692: p_line_location_id => null ,

Line 7858: if tax_lines1_rec.modvat_flag = jai_constants.YES

7854:
7855:
7856: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
7857:
7858: if tax_lines1_rec.modvat_flag = jai_constants.YES
7859: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
7860: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
7861: then
7862: --

Line 7899: v_assets_tracking_flag := jai_constants.YES;

7895:
7896: elsif line = 2 then
7897:
7898: v_tax_amount := ln_nrec_tax_amt;
7899: v_assets_tracking_flag := jai_constants.YES;
7900: lv_modvat_flag := jai_constants.NO ;
7901: --
7902: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
7903: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 7900: lv_modvat_flag := jai_constants.NO ;

7896: elsif line = 2 then
7897:
7898: v_tax_amount := ln_nrec_tax_amt;
7899: v_assets_tracking_flag := jai_constants.YES;
7900: lv_modvat_flag := jai_constants.NO ;
7901: --
7902: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
7903: -- projects related columns so that PROJECTS can consider this line for Project Costing
7904: --

Line 7946: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

7942: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
7943: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
7944:
7945:
7946: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
7947: v_assets_tracking_flag := jai_constants.YES;
7948: END IF;
7949:
7950: lv_modvat_flag := jai_constants.NO ;

Line 7947: v_assets_tracking_flag := jai_constants.YES;

7943: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
7944:
7945:
7946: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
7947: v_assets_tracking_flag := jai_constants.YES;
7948: END IF;
7949:
7950: lv_modvat_flag := jai_constants.NO ;
7951:

Line 7950: lv_modvat_flag := jai_constants.NO ;

7946: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
7947: v_assets_tracking_flag := jai_constants.YES;
7948: END IF;
7949:
7950: lv_modvat_flag := jai_constants.NO ;
7951:
7952: --
7953: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
7954: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 7988: lv_modvat_flag := jai_constants.NO ;

7984: ELSIF ( line = 2 )
7985: THEN
7986: v_tax_amount := ln_nrec_tax_amt ;
7987: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
7988: lv_modvat_flag := jai_constants.NO ;
7989: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
7990: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
7991:
7992: --recoverable part without project infor

Line 8571: if i.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then

8567: CLOSE c_tax;
8568:
8569: -- added, kunkumar for Bug#5593895
8570: ln_base_amount := null ;
8571: if i.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
8572: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
8573: (
8574: p_invoice_id => inv_id ,
8575: p_line_location_id => cur_items_rec.line_location_id ,

Line 8707: if i.modvat_flag = jai_constants.YES

8703: --added by Eric for inclusive tax on 20-dec-2007,end
8704:
8705: Fnd_File.put_line(Fnd_File.LOG, 'i.modvat_flag ='||i.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
8706:
8707: if i.modvat_flag = jai_constants.YES
8708: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
8709: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
8710: then
8711: --

Line 8748: v_assets_tracking_flag := jai_constants.YES;

8744:
8745: elsif line = 2 then
8746:
8747: v_tax_amount := ln_nrec_tax_amt;
8748: v_assets_tracking_flag := jai_constants.YES;
8749: lv_modvat_flag := jai_constants.NO ;
8750:
8751: --
8752: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating

Line 8749: lv_modvat_flag := jai_constants.NO ;

8745: elsif line = 2 then
8746:
8747: v_tax_amount := ln_nrec_tax_amt;
8748: v_assets_tracking_flag := jai_constants.YES;
8749: lv_modvat_flag := jai_constants.NO ;
8750:
8751: --
8752: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
8753: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 8798: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN

8794: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
8795: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
8796:
8797:
8798: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
8799: v_assets_tracking_flag := jai_constants.YES;
8800: END IF;
8801:
8802: lv_modvat_flag := jai_constants.NO ;

Line 8799: v_assets_tracking_flag := jai_constants.YES;

8795: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
8796:
8797:
8798: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
8799: v_assets_tracking_flag := jai_constants.YES;
8800: END IF;
8801:
8802: lv_modvat_flag := jai_constants.NO ;
8803:

Line 8802: lv_modvat_flag := jai_constants.NO ;

8798: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
8799: v_assets_tracking_flag := jai_constants.YES;
8800: END IF;
8801:
8802: lv_modvat_flag := jai_constants.NO ;
8803:
8804: --
8805: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
8806: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 8840: lv_modvat_flag := jai_constants.NO ;

8836: ELSIF ( line = 2 )
8837: THEN
8838: v_tax_amount := ln_nrec_tax_amt ;
8839: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
8840: lv_modvat_flag := jai_constants.NO ;
8841: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
8842: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
8843:
8844: --recoverable part without project infor