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 105: p_organization_type => jai_constants.orgn_type_io,/5694855/

101: ln_service_interim_account :=
102: jai_cmn_rgm_recording_pkg.get_account
103: (
104: p_regime_id => p_service_regime_id,
105: p_organization_type => jai_constants.orgn_type_io,/*5694855*/
106: p_organization_id => ln_organization_id,/*5694855*/
107: p_location_id => ln_location_id, /*5694855*/
108: p_tax_type => p_tax_type,
109: p_account_name => jai_constants.recovery_interim

Line 109: p_account_name => jai_constants.recovery_interim

105: p_organization_type => jai_constants.orgn_type_io,/*5694855*/
106: p_organization_id => ln_organization_id,/*5694855*/
107: p_location_id => ln_location_id, /*5694855*/
108: p_tax_type => p_tax_type,
109: p_account_name => jai_constants.recovery_interim
110: );
111:
112: return ln_service_interim_account;
113:

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

820: WHERE line_location_id = p_line_location_id -- 3096578
821: AND NVL(upper(tax_type), 'A') NOT IN
822: ('TDS',
823: 'CVD',
824: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
825: 'CUSTOMS',
826: jai_constants.tax_type_cvd_edu_cess,
827: jai_constants.tax_type_customs_edu_cess,
828: 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 826: jai_constants.tax_type_cvd_edu_cess,

822: ('TDS',
823: 'CVD',
824: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
825: 'CUSTOMS',
826: jai_constants.tax_type_cvd_edu_cess,
827: jai_constants.tax_type_customs_edu_cess,
828: 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
829: )
830: AND NVL(vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895

Line 827: jai_constants.tax_type_customs_edu_cess,

823: 'CVD',
824: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
825: 'CUSTOMS',
826: jai_constants.tax_type_cvd_edu_cess,
827: jai_constants.tax_type_customs_edu_cess,
828: 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
829: )
830: AND NVL(vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895
831: order by tax_line_no; -- added bug#3038566

Line 828: 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

824: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
825: 'CUSTOMS',
826: jai_constants.tax_type_cvd_edu_cess,
827: jai_constants.tax_type_customs_edu_cess,
828: 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
829: )
830: AND NVL(vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895
831: order by tax_line_no; -- added bug#3038566
832: -- AND tax_amount <> 0 ; -- commented by aparajita on 10/03/2003 for bug # 2841363

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

856: WHERE line_location_id = p_line_location_id -- 3096578
857: AND NVL(UPPER(jpt.tax_type), 'A')
858: NOT IN( 'TDS'
859: , 'CVD'
860: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
861: , 'CUSTOMS'
862: , jai_constants.tax_type_cvd_edu_cess
863: , jai_constants.tax_type_customs_edu_cess
864: , jai_constants.tax_type_sh_cvd_edu_cess

Line 862: , jai_constants.tax_type_cvd_edu_cess

858: NOT IN( 'TDS'
859: , 'CVD'
860: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
861: , 'CUSTOMS'
862: , jai_constants.tax_type_cvd_edu_cess
863: , jai_constants.tax_type_customs_edu_cess
864: , jai_constants.tax_type_sh_cvd_edu_cess
865: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
866: )

Line 863: , jai_constants.tax_type_customs_edu_cess

859: , 'CVD'
860: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
861: , 'CUSTOMS'
862: , jai_constants.tax_type_cvd_edu_cess
863: , jai_constants.tax_type_customs_edu_cess
864: , jai_constants.tax_type_sh_cvd_edu_cess
865: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
866: )
867: AND jcta.tax_id = jpt.tax_id

Line 864: , jai_constants.tax_type_sh_cvd_edu_cess

860: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
861: , 'CUSTOMS'
862: , jai_constants.tax_type_cvd_edu_cess
863: , jai_constants.tax_type_customs_edu_cess
864: , jai_constants.tax_type_sh_cvd_edu_cess
865: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
866: )
867: AND jcta.tax_id = jpt.tax_id
868: AND NVL(jpt.vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895

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

861: , 'CUSTOMS'
862: , jai_constants.tax_type_cvd_edu_cess
863: , jai_constants.tax_type_customs_edu_cess
864: , jai_constants.tax_type_sh_cvd_edu_cess
865: , jai_constants.tax_type_sh_customs_edu_cess --Added higher education cess by csahoo for bug#5989740
866: )
867: AND jcta.tax_id = jpt.tax_id
868: AND NVL(jpt.vendor_id, -1) = vend_id --Modified by kunkumar for bug 5593895
869: AND p_source <> 'PPA'

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

901: AND jrlc.doc_type IN ('STANDARD PO', 'RELEASE')
902: AND jrl.tax_id = jcta.tax_id
903: AND NVL(jrlc.vendor_id, -1) = vend_id
904: AND p_source = 'PPA'
905: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
906: , jai_constants.tax_type_cvd
907: , jai_constants.tax_type_add_cvd
908: , jai_constants.tax_type_customs
909: , jai_constants.tax_type_sh_customs_edu_cess

Line 906: , jai_constants.tax_type_cvd

902: AND jrl.tax_id = jcta.tax_id
903: AND NVL(jrlc.vendor_id, -1) = vend_id
904: AND p_source = 'PPA'
905: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
906: , jai_constants.tax_type_cvd
907: , jai_constants.tax_type_add_cvd
908: , jai_constants.tax_type_customs
909: , jai_constants.tax_type_sh_customs_edu_cess
910: , jai_constants.tax_type_customs_edu_cess

Line 907: , jai_constants.tax_type_add_cvd

903: AND NVL(jrlc.vendor_id, -1) = vend_id
904: AND p_source = 'PPA'
905: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
906: , jai_constants.tax_type_cvd
907: , jai_constants.tax_type_add_cvd
908: , jai_constants.tax_type_customs
909: , jai_constants.tax_type_sh_customs_edu_cess
910: , jai_constants.tax_type_customs_edu_cess
911: , jai_constants.tax_type_sh_cvd_edu_cess

Line 908: , jai_constants.tax_type_customs

904: AND p_source = 'PPA'
905: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
906: , jai_constants.tax_type_cvd
907: , jai_constants.tax_type_add_cvd
908: , jai_constants.tax_type_customs
909: , jai_constants.tax_type_sh_customs_edu_cess
910: , jai_constants.tax_type_customs_edu_cess
911: , jai_constants.tax_type_sh_cvd_edu_cess
912: , jai_constants.tax_type_cvd_edu_cess

Line 909: , jai_constants.tax_type_sh_customs_edu_cess

905: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
906: , jai_constants.tax_type_cvd
907: , jai_constants.tax_type_add_cvd
908: , jai_constants.tax_type_customs
909: , jai_constants.tax_type_sh_customs_edu_cess
910: , jai_constants.tax_type_customs_edu_cess
911: , jai_constants.tax_type_sh_cvd_edu_cess
912: , jai_constants.tax_type_cvd_edu_cess
913: )

Line 910: , jai_constants.tax_type_customs_edu_cess

906: , jai_constants.tax_type_cvd
907: , jai_constants.tax_type_add_cvd
908: , jai_constants.tax_type_customs
909: , jai_constants.tax_type_sh_customs_edu_cess
910: , jai_constants.tax_type_customs_edu_cess
911: , jai_constants.tax_type_sh_cvd_edu_cess
912: , jai_constants.tax_type_cvd_edu_cess
913: )
914: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416

Line 911: , jai_constants.tax_type_sh_cvd_edu_cess

907: , jai_constants.tax_type_add_cvd
908: , jai_constants.tax_type_customs
909: , jai_constants.tax_type_sh_customs_edu_cess
910: , jai_constants.tax_type_customs_edu_cess
911: , jai_constants.tax_type_sh_cvd_edu_cess
912: , jai_constants.tax_type_cvd_edu_cess
913: )
914: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
915: ---------------------------------------------------------------------

Line 912: , jai_constants.tax_type_cvd_edu_cess

908: , jai_constants.tax_type_customs
909: , jai_constants.tax_type_sh_customs_edu_cess
910: , jai_constants.tax_type_customs_edu_cess
911: , jai_constants.tax_type_sh_cvd_edu_cess
912: , jai_constants.tax_type_cvd_edu_cess
913: )
914: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
915: ---------------------------------------------------------------------
916: --Added by Qiong for reverse charge bug#16001407 start

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

1004: AND jrl.vendor_id = ven_id
1005: AND NVL(upper(jrl.tax_type),'TDS') NOT IN (
1006: 'TDS',
1007: 'CVD',
1008: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1009: 'CUSTOMS',
1010: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, -- added by ssawant for bug 5989740
1011: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess --added by ssawant for bug 5989740
1012: )

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

1006: 'TDS',
1007: 'CVD',
1008: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1009: 'CUSTOMS',
1010: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, -- added by ssawant for bug 5989740
1011: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess --added by ssawant for bug 5989740
1012: )
1013: order by tax_line_no -- added bug#3038566
1014: ;

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

1007: 'CVD',
1008: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1009: 'CUSTOMS',
1010: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, -- added by ssawant for bug 5989740
1011: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess --added by ssawant for bug 5989740
1012: )
1013: order by tax_line_no -- added bug#3038566
1014: ;
1015: */

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

1042: AND jcta.tax_id = jrl.tax_id --Added by Eric for Inclusive Tax
1043: AND NVL(upper(jrl.tax_type),'TDS')
1044: NOT IN ( 'TDS'
1045: , 'CVD'
1046: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1047: , 'CUSTOMS'
1048: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
1049: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
1050: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS

Line 1048: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS

1044: NOT IN ( 'TDS'
1045: , 'CVD'
1046: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1047: , 'CUSTOMS'
1048: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
1049: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
1050: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
1051: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
1052: )

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

1045: , 'CVD'
1046: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1047: , 'CUSTOMS'
1048: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
1049: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
1050: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
1051: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
1052: )
1053: --Added by Qiong for reverse charge bug#16001407 start

Line 1050: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS

1046: , jai_constants.tax_type_add_cvd -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1047: , 'CUSTOMS'
1048: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
1049: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
1050: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
1051: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
1052: )
1053: --Added by Qiong for reverse charge bug#16001407 start
1054: ---------------------------------------------------------------------

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

1047: , 'CUSTOMS'
1048: , JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS
1049: , jai_constants.tax_type_customs_edu_cess /* added by ssawant for bug 5989740 */
1050: , JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS
1051: , jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
1052: )
1053: --Added by Qiong for reverse charge bug#16001407 start
1054: ---------------------------------------------------------------------
1055: AND NVL(jcta.reverse_charge_flag,'N') = 'N'

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

1088: AND jcta.tax_id = jrl.tax_id --Added by Eric for Inclusive Tax
1089: AND NVL(upper(jrl.tax_type),'TDS') NOT IN
1090: ('TDS',
1091: 'CVD',
1092: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1093: 'CUSTOMS',
1094: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */
1095: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
1096: )

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

1090: ('TDS',
1091: 'CVD',
1092: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1093: 'CUSTOMS',
1094: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */
1095: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
1096: )
1097: AND p_source <> 'PPA'
1098: --Added by Qiong for reverse charge bug#16001407 start

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

1091: 'CVD',
1092: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
1093: 'CUSTOMS',
1094: JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,jai_constants.tax_type_customs_edu_cess, /* added by ssawant for bug 5989740 */
1095: JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,jai_constants.tax_type_cvd_edu_cess /* added by ssawant for bug 5989740 */
1096: )
1097: AND p_source <> 'PPA'
1098: --Added by Qiong for reverse charge bug#16001407 start
1099: ---------------------------------------------------------------------

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

1130: AND rt.shipment_line_id = rsl.shipment_line_id
1131: AND rt.transaction_id = tran_id
1132: AND jrlc.vendor_id = ven_id
1133: AND p_source = 'PPA'
1134: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
1135: , jai_constants.tax_type_cvd
1136: , jai_constants.tax_type_add_cvd
1137: , jai_constants.tax_type_customs
1138: , jai_constants.tax_type_sh_customs_edu_cess

Line 1135: , jai_constants.tax_type_cvd

1131: AND rt.transaction_id = tran_id
1132: AND jrlc.vendor_id = ven_id
1133: AND p_source = 'PPA'
1134: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
1135: , jai_constants.tax_type_cvd
1136: , jai_constants.tax_type_add_cvd
1137: , jai_constants.tax_type_customs
1138: , jai_constants.tax_type_sh_customs_edu_cess
1139: , jai_constants.tax_type_customs_edu_cess

Line 1136: , jai_constants.tax_type_add_cvd

1132: AND jrlc.vendor_id = ven_id
1133: AND p_source = 'PPA'
1134: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
1135: , jai_constants.tax_type_cvd
1136: , jai_constants.tax_type_add_cvd
1137: , jai_constants.tax_type_customs
1138: , jai_constants.tax_type_sh_customs_edu_cess
1139: , jai_constants.tax_type_customs_edu_cess
1140: , jai_constants.tax_type_sh_cvd_edu_cess

Line 1137: , jai_constants.tax_type_customs

1133: AND p_source = 'PPA'
1134: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
1135: , jai_constants.tax_type_cvd
1136: , jai_constants.tax_type_add_cvd
1137: , jai_constants.tax_type_customs
1138: , jai_constants.tax_type_sh_customs_edu_cess
1139: , jai_constants.tax_type_customs_edu_cess
1140: , jai_constants.tax_type_sh_cvd_edu_cess
1141: , jai_constants.tax_type_cvd_edu_cess

Line 1138: , jai_constants.tax_type_sh_customs_edu_cess

1134: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ( jai_constants.tax_type_tds
1135: , jai_constants.tax_type_cvd
1136: , jai_constants.tax_type_add_cvd
1137: , jai_constants.tax_type_customs
1138: , jai_constants.tax_type_sh_customs_edu_cess
1139: , jai_constants.tax_type_customs_edu_cess
1140: , jai_constants.tax_type_sh_cvd_edu_cess
1141: , jai_constants.tax_type_cvd_edu_cess
1142: )

Line 1139: , jai_constants.tax_type_customs_edu_cess

1135: , jai_constants.tax_type_cvd
1136: , jai_constants.tax_type_add_cvd
1137: , jai_constants.tax_type_customs
1138: , jai_constants.tax_type_sh_customs_edu_cess
1139: , jai_constants.tax_type_customs_edu_cess
1140: , jai_constants.tax_type_sh_cvd_edu_cess
1141: , jai_constants.tax_type_cvd_edu_cess
1142: )
1143: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416

Line 1140: , jai_constants.tax_type_sh_cvd_edu_cess

1136: , jai_constants.tax_type_add_cvd
1137: , jai_constants.tax_type_customs
1138: , jai_constants.tax_type_sh_customs_edu_cess
1139: , jai_constants.tax_type_customs_edu_cess
1140: , jai_constants.tax_type_sh_cvd_edu_cess
1141: , jai_constants.tax_type_cvd_edu_cess
1142: )
1143: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
1144: --Added by Qiong for reverse charge bug#16001407 start

Line 1141: , jai_constants.tax_type_cvd_edu_cess

1137: , jai_constants.tax_type_customs
1138: , jai_constants.tax_type_sh_customs_edu_cess
1139: , jai_constants.tax_type_customs_edu_cess
1140: , jai_constants.tax_type_sh_cvd_edu_cess
1141: , jai_constants.tax_type_cvd_edu_cess
1142: )
1143: AND NVL(jrl.third_party_flag, 'N') = 'N' -- Added by Jason Liu for bug#6936416
1144: --Added by Qiong for reverse charge bug#16001407 start
1145: ---------------------------------------------------------------------

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

1327: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
1328: select attribute_code tax_type
1329: from JAI_RGM_REGISTRATIONS
1330: where regime_id = cp_regime_id
1331: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
1332: and attribute_code = cp_tax_type;
1333:
1334:
1335: r_rcv_transactions c_rcv_transactions%rowtype;

Line 2098: Variable usage of jai_constants package.

2094: in this patch. So no pre - req.
2095:
2096: 115.6 4146708 Base Bug for Service + Cess Release.
2097:
2098: Variable usage of jai_constants package.
2099:
2100: Call to following,
2101: jai_general_pkg.is_item_an_expense
2102: jai_general_pkg.get_accounting_method

Line 2594: open c_jai_regimes(jai_constants.service_regime);

2590: );
2591:
2592: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag='||lv_accrue_on_receipt_flag);
2593:
2594: open c_jai_regimes(jai_constants.service_regime);
2595: fetch c_jai_regimes into r_jai_regimes;
2596: close c_jai_regimes;
2597:
2598: /* service End */

Line 2604: OPEN c_jai_regimes(jai_constants.vat_regime);

2600: /* Bug 5358788. Added by Lakshmi Gopalsami
2601: * Fetch VAT Regime id
2602: */
2603:
2604: OPEN c_jai_regimes(jai_constants.vat_regime);
2605: FETCH c_jai_regimes INTO r_vat_regimes;
2606: CLOSE c_jai_regimes;
2607:
2608: /* Bug 5401111. Added by Lakshmi Gopalsami

Line 2714: if i.modvat_flag = jai_constants.YES

2710: lv_tax_type := NULL;--added by eric for inclusive tax on 20-Dec,2007
2711:
2712: -- 5763527, Brathod
2713: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
2714: if i.modvat_flag = jai_constants.YES
2715: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0 then
2716:
2717: --recoverable tax
2718: lv_tax_type := 'RE'; --added by eric for inclusive tax on 20-dec,2007

Line 2780: p_organization_type => jai_constants.orgn_type_io,

2776: /*Added by qinglei on 16-Feb-2012 for bug#13561173 begin*/
2777: v_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account
2778: (
2779: p_regime_id => r_jai_regimes.regime_id,
2780: p_organization_type => jai_constants.orgn_type_io,
2781: p_organization_id => ln_ship_to_organization_id,
2782: p_location_id => ln_ship_to_location_id,
2783: p_tax_type => c_tax_rec.tax_type,
2784: p_account_name => jai_constants.recovery_interim

Line 2784: p_account_name => jai_constants.recovery_interim

2780: p_organization_type => jai_constants.orgn_type_io,
2781: p_organization_id => ln_ship_to_organization_id,
2782: p_location_id => ln_ship_to_location_id,
2783: p_tax_type => c_tax_rec.tax_type,
2784: p_account_name => jai_constants.recovery_interim
2785: );
2786: /*Added by qinglei on 16-Feb-2012 for bug#13561173 end*/
2787: fnd_file.put_line(FND_FILE.LOG,
2788: ' Regime type , CCID '

Line 2802: p_organization_type => jai_constants.orgn_type_io,

2798: Fnd_File.put_line(Fnd_File.LOG, 'lv_is_item_an_expense='||lv_is_item_an_expense);
2799: /* v_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account
2800: (
2801: p_regime_id => ln_vat_regime_id,
2802: p_organization_type => jai_constants.orgn_type_io,
2803: p_organization_id => ln_ship_to_organization_id ,
2804: p_location_id => ln_ship_to_location_id ,
2805: p_tax_type => c_tax_rec.tax_type,
2806: p_account_name => jai_constants.recovery --RECOVERY

Line 2806: p_account_name => jai_constants.recovery --RECOVERY

2802: p_organization_type => jai_constants.orgn_type_io,
2803: p_organization_id => ln_ship_to_organization_id ,
2804: p_location_id => ln_ship_to_location_id ,
2805: p_tax_type => c_tax_rec.tax_type,
2806: p_account_name => jai_constants.recovery --RECOVERY
2807: );*/ --commented by Bgowrava for Bug#9499146
2808: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id; --Added by Bgowrava for Bug#9499146
2809: ELSE
2810: /*v_dist_code_combination_id := c_tax_rec.tax_account_id;*/ --commented by Bgowrava for Bug#9499146

Line 2920: if i.modvat_flag = jai_constants.YES

2916: --added by Eric for inclusive tax on 20-dec-2007,end
2917:
2918: 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);
2919:
2920: if i.modvat_flag = jai_constants.YES
2921: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
2922: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
2923: then
2924: --

Line 2938: if i.modvat_flag = jai_constants.YES

2934: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
2935:
2936: end if;
2937: --start additions for bug#11936596
2938: if i.modvat_flag = jai_constants.YES
2939: then
2940: ln_inclurec_tax_amt := round ( nvl(v_tax_amount,0) * (c_tax_rec.mod_cr_percentage/100) , c_tax_rec.rounding_factor) ;
2941: end if;
2942: --end additions for bug#11936596

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

2967: elsif line = 2 then
2968:
2969: v_tax_amount := ln_nrec_tax_amt;
2970:
2971: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
2972: v_assets_tracking_flag := jai_constants.YES;
2973: end if;
2974:
2975: lv_modvat_flag := jai_constants.NO ;

Line 2972: v_assets_tracking_flag := jai_constants.YES;

2968:
2969: v_tax_amount := ln_nrec_tax_amt;
2970:
2971: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
2972: v_assets_tracking_flag := jai_constants.YES;
2973: end if;
2974:
2975: lv_modvat_flag := jai_constants.NO ;
2976:

Line 2975: lv_modvat_flag := jai_constants.NO ;

2971: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
2972: v_assets_tracking_flag := jai_constants.YES;
2973: end if;
2974:
2975: lv_modvat_flag := jai_constants.NO ;
2976:
2977: --
2978: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
2979: -- projects related columns so that PROJECTS can consider this line for Project Costing

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

3101: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
3102: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
3103:
3104:
3105: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
3106: v_assets_tracking_flag := jai_constants.YES;
3107: END IF;
3108:
3109: lv_modvat_flag := jai_constants.NO ;

Line 3106: v_assets_tracking_flag := jai_constants.YES;

3102: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
3103:
3104:
3105: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
3106: v_assets_tracking_flag := jai_constants.YES;
3107: END IF;
3108:
3109: lv_modvat_flag := jai_constants.NO ;
3110:

Line 3109: lv_modvat_flag := jai_constants.NO ;

3105: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
3106: v_assets_tracking_flag := jai_constants.YES;
3107: END IF;
3108:
3109: lv_modvat_flag := jai_constants.NO ;
3110:
3111: --
3112: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
3113: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 3147: lv_modvat_flag := jai_constants.NO ;

3143: ELSIF ( line = 2 )
3144: THEN
3145: v_tax_amount := ln_nrec_tax_amt ;
3146: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
3147: lv_modvat_flag := jai_constants.NO ;
3148: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
3149: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
3150: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id ;--13561173
3151: --recoverable part without project infor

Line 3366: IF i.modvat_flag = jai_constants.no OR line = 2 OR line = 4

3362: v_tax_variance_inv_cur := v_tax_amt_dist * (r_ap_dist.invoice_price_variance / r_ap_dist.amount);
3363: v_tax_variance_fun_cur := v_tax_variance_inv_cur * nvl(for_org_id_rec.exchange_rate, 1);
3364: END IF;
3365:
3366: IF i.modvat_flag = jai_constants.no OR line = 2 OR line = 4
3367: THEN
3368: v_assets_tracking_flag := r_ap_dist.assets_tracking_flag;
3369: lv_project_accounting_context := r_ap_dist.project_accounting_context;
3370: lv_pa_addition_flag := r_ap_dist.pa_addition_flag;

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

3373: v_dist_code_combination_id := Nvl(v_dist_code_combination_id,r_ap_dist.dist_code_combination_id);
3374:
3375: --Added by kunkumar for bug 5593895
3376: ln_base_amount := null ;
3377: if i.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
3378: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt(
3379: p_invoice_id => inv_id ,
3380: p_line_location_id => ln_po_line_location_id ,
3381: p_transaction_id => null ,

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

4120:
4121:
4122: -- added, kunkumar for 5593895
4123: ln_base_amount := null ;
4124: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
4125: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
4126: (
4127: p_invoice_id => inv_id ,
4128: p_line_location_id => null ,

Line 4147: if tax_lines1_rec.modvat_flag = jai_constants.YES

4143:
4144:
4145: -- 5763527, Brathod
4146: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
4147: if tax_lines1_rec.modvat_flag = jai_constants.YES
4148: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4149: then
4150:
4151:

Line 4329: if tax_lines1_rec.modvat_flag = jai_constants.YES

4325: --added by Eric for inclusive tax on 20-dec-2007,end
4326:
4327: 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);
4328:
4329: if tax_lines1_rec.modvat_flag = jai_constants.YES
4330: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
4331: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4332: then
4333: --

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

4365: elsif line = 2 then
4366:
4367: v_tax_amount := ln_nrec_tax_amt;
4368:
4369: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
4370: v_assets_tracking_flag := jai_constants.YES;
4371: end if;
4372:
4373: lv_modvat_flag := jai_constants.NO ;

Line 4370: v_assets_tracking_flag := jai_constants.YES;

4366:
4367: v_tax_amount := ln_nrec_tax_amt;
4368:
4369: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
4370: v_assets_tracking_flag := jai_constants.YES;
4371: end if;
4372:
4373: lv_modvat_flag := jai_constants.NO ;
4374:

Line 4373: lv_modvat_flag := jai_constants.NO ;

4369: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
4370: v_assets_tracking_flag := jai_constants.YES;
4371: end if;
4372:
4373: lv_modvat_flag := jai_constants.NO ;
4374:
4375: --
4376: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
4377: -- projects related columns so that PROJECTS can consider this line for Project Costing

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

4411: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
4412: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
4413:
4414:
4415: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4416: v_assets_tracking_flag := jai_constants.YES;
4417: END IF;
4418:
4419: lv_modvat_flag := jai_constants.NO ;

Line 4416: v_assets_tracking_flag := jai_constants.YES;

4412: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
4413:
4414:
4415: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4416: v_assets_tracking_flag := jai_constants.YES;
4417: END IF;
4418:
4419: lv_modvat_flag := jai_constants.NO ;
4420:

Line 4419: lv_modvat_flag := jai_constants.NO ;

4415: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
4416: v_assets_tracking_flag := jai_constants.YES;
4417: END IF;
4418:
4419: lv_modvat_flag := jai_constants.NO ;
4420:
4421: --
4422: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
4423: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 4457: lv_modvat_flag := jai_constants.NO ;

4453: ELSIF ( line = 2 )
4454: THEN
4455: v_tax_amount := ln_nrec_tax_amt ;
4456: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
4457: lv_modvat_flag := jai_constants.NO ;
4458: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
4459: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
4460:
4461: --recoverable part without project infor

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

5032: CLOSE c_tax_curr_prec ;
5033:
5034: -- added, kunkumar for bug 5593895
5035: ln_base_amount := null ;
5036: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
5037: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
5038: (
5039: p_invoice_id => inv_id ,
5040: p_line_location_id => null ,

Line 5058: if tax_lines1_rec.modvat_flag = jai_constants.YES

5054: lv_tax_type := NULL;--added by eric for inclusive tax on 20-Dec,2007
5055:
5056: -- 5763527, Brathod
5057: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
5058: if tax_lines1_rec.modvat_flag = jai_constants.YES
5059: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
5060: then
5061: --recoverable tax
5062: lv_tax_type := 'RE'; --added by eric for inclusive tax on 20-dec,2007

Line 5211: if tax_lines1_rec.modvat_flag = jai_constants.YES

5207:
5208:
5209: 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);
5210:
5211: if tax_lines1_rec.modvat_flag = jai_constants.YES
5212: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
5213: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
5214: then
5215: --

Line 5230: if tax_lines1_rec.modvat_flag = jai_constants.YES

5226:
5227: end if;
5228:
5229: --start additions for bug#11936596
5230: if tax_lines1_rec.modvat_flag = jai_constants.YES
5231: then
5232: ln_inclurec_tax_amt := round ( nvl(v_tax_amount,0) * (c_tax_rec.mod_cr_percentage/100) , c_tax_rec.rounding_factor) ;
5233: end if;
5234: --end additions for bug#11936596

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

5261: elsif line = 2 then
5262:
5263: v_tax_amount := ln_nrec_tax_amt;
5264:
5265: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
5266: v_assets_tracking_flag := jai_constants.YES;
5267: end if;
5268:
5269: lv_modvat_flag := jai_constants.NO ;

Line 5266: v_assets_tracking_flag := jai_constants.YES;

5262:
5263: v_tax_amount := ln_nrec_tax_amt;
5264:
5265: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
5266: v_assets_tracking_flag := jai_constants.YES;
5267: end if;
5268:
5269: lv_modvat_flag := jai_constants.NO ;
5270:

Line 5269: lv_modvat_flag := jai_constants.NO ;

5265: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
5266: v_assets_tracking_flag := jai_constants.YES;
5267: end if;
5268:
5269: lv_modvat_flag := jai_constants.NO ;
5270:
5271: --
5272: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
5273: -- projects related columns so that PROJECTS can consider this line for Project Costing

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

5309: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
5310: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
5311:
5312:
5313: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
5314: v_assets_tracking_flag := jai_constants.YES;
5315: END IF;
5316:
5317: lv_modvat_flag := jai_constants.NO ;

Line 5314: v_assets_tracking_flag := jai_constants.YES;

5310: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
5311:
5312:
5313: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
5314: v_assets_tracking_flag := jai_constants.YES;
5315: END IF;
5316:
5317: lv_modvat_flag := jai_constants.NO ;
5318:

Line 5317: lv_modvat_flag := jai_constants.NO ;

5313: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
5314: v_assets_tracking_flag := jai_constants.YES;
5315: END IF;
5316:
5317: lv_modvat_flag := jai_constants.NO ;
5318:
5319: --
5320: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
5321: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 5355: lv_modvat_flag := jai_constants.NO ;

5351: ELSIF ( line = 2 )
5352: THEN
5353: v_tax_amount := ln_nrec_tax_amt ;
5354: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
5355: lv_modvat_flag := jai_constants.NO ;
5356: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
5357: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
5358:
5359: --recoverable part without project infor

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

5959: CLOSE c_tax_curr_prec ;
5960:
5961: -- added, kunkumar for bug#5593895
5962: ln_base_amount := null ;
5963: if r_tax_lines_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
5964: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
5965: (
5966: p_invoice_id => inv_id ,
5967: p_line_location_id => null ,

Line 5983: if r_tax_lines_rec.modvat_flag = jai_constants.YES

5979:
5980: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.mod_cr_percentage = '||c_tax_rec.mod_cr_percentage);
5981: -- 5763527, Brathod
5982: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
5983: if r_tax_lines_rec.modvat_flag = jai_constants.YES
5984: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
5985: then
5986: /* recoverable tax */
5987: lv_tax_type := 'RE'; --added by eric for inclusive tax on 20-dec,2007

Line 6204: if r_tax_lines_rec.modvat_flag = jai_constants.YES

6200:
6201:
6202: 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);
6203:
6204: if r_tax_lines_rec.modvat_flag = jai_constants.YES
6205: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
6206: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
6207: then
6208: --

Line 6223: if r_tax_lines_rec.modvat_flag = jai_constants.YES

6219:
6220: lv_tax_type := 'PR'; --added by eric for inclusive tax on Jan 4,2008
6221: end if;
6222: --start additions for bug#11936596
6223: if r_tax_lines_rec.modvat_flag = jai_constants.YES
6224: then
6225: ln_inclurec_tax_amt := round ( nvl(v_tax_amount,0) * (c_tax_rec.mod_cr_percentage/100) , c_tax_rec.rounding_factor) ;
6226: end if;
6227: --end additions for bug#11936596

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

6253: elsif line = 2 then
6254:
6255: v_tax_amount := ln_nrec_tax_amt;
6256:
6257: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
6258: v_assets_tracking_flag := jai_constants.YES;
6259: end if;
6260:
6261: lv_modvat_flag := jai_constants.NO ;

Line 6258: v_assets_tracking_flag := jai_constants.YES;

6254:
6255: v_tax_amount := ln_nrec_tax_amt;
6256:
6257: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
6258: v_assets_tracking_flag := jai_constants.YES;
6259: end if;
6260:
6261: lv_modvat_flag := jai_constants.NO ;
6262:

Line 6261: lv_modvat_flag := jai_constants.NO ;

6257: if for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES then
6258: v_assets_tracking_flag := jai_constants.YES;
6259: end if;
6260:
6261: lv_modvat_flag := jai_constants.NO ;
6262:
6263: --
6264: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
6265: -- projects related columns so that PROJECTS can consider this line for Project Costing

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

6313: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
6314: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
6315:
6316:
6317: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
6318: v_assets_tracking_flag := jai_constants.YES;
6319: END IF;
6320:
6321: lv_modvat_flag := jai_constants.NO ;

Line 6318: v_assets_tracking_flag := jai_constants.YES;

6314: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
6315:
6316:
6317: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
6318: v_assets_tracking_flag := jai_constants.YES;
6319: END IF;
6320:
6321: lv_modvat_flag := jai_constants.NO ;
6322:

Line 6321: lv_modvat_flag := jai_constants.NO ;

6317: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
6318: v_assets_tracking_flag := jai_constants.YES;
6319: END IF;
6320:
6321: lv_modvat_flag := jai_constants.NO ;
6322:
6323: --
6324: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
6325: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 6361: lv_modvat_flag := jai_constants.NO ;

6357: THEN
6358: --non recoverable part
6359: v_tax_amount := ln_nrec_tax_amt ;
6360: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
6361: lv_modvat_flag := jai_constants.NO ;
6362: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
6363: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
6364:
6365: --recoverable part without project infor

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

7397: AND jrl.vendor_id = ven_id
7398: AND jcta.tax_id = jrl.tax_id --Added by Eric for Inclusive Tax
7399: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ('TDS',
7400: 'CVD',
7401: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
7402: 'CUSTOMS',
7403: jai_constants.tax_type_customs_edu_cess,
7404: jai_constants.tax_type_cvd_edu_cess)
7405: -- GROUP BY jrl.tax_id,jrl.currency,jrl.tax_type, jrl.modvat_flag -- commented bug#3038566

Line 7403: jai_constants.tax_type_customs_edu_cess,

7399: AND NVL(upper(jrl.tax_type),'TDS') NOT IN ('TDS',
7400: 'CVD',
7401: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
7402: 'CUSTOMS',
7403: jai_constants.tax_type_customs_edu_cess,
7404: jai_constants.tax_type_cvd_edu_cess)
7405: -- GROUP BY jrl.tax_id,jrl.currency,jrl.tax_type, jrl.modvat_flag -- commented bug#3038566
7406: order by tax_line_no -- added bug#3038566
7407: ;

Line 7404: jai_constants.tax_type_cvd_edu_cess)

7400: 'CVD',
7401: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
7402: 'CUSTOMS',
7403: jai_constants.tax_type_customs_edu_cess,
7404: jai_constants.tax_type_cvd_edu_cess)
7405: -- GROUP BY jrl.tax_id,jrl.currency,jrl.tax_type, jrl.modvat_flag -- commented bug#3038566
7406: order by tax_line_no -- added bug#3038566
7407: ;
7408:

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

7433: WHERE jpt.line_location_id = p_line_location_id -- 3096578
7434: AND jcta.tax_id = jpt.tax_id --Added by Eric for Inclusive Tax
7435: AND NVL(upper(jpt.tax_type), 'A') NOT IN ('TDS',
7436: 'CVD',
7437: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
7438: 'CUSTOMS',
7439: jai_constants.tax_type_customs_edu_cess,
7440: jai_constants.tax_type_cvd_edu_cess
7441: )

Line 7439: jai_constants.tax_type_customs_edu_cess,

7435: AND NVL(upper(jpt.tax_type), 'A') NOT IN ('TDS',
7436: 'CVD',
7437: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
7438: 'CUSTOMS',
7439: jai_constants.tax_type_customs_edu_cess,
7440: jai_constants.tax_type_cvd_edu_cess
7441: )
7442: AND NVL(jpt.vendor_id, 0) = vend_id
7443: AND cp_source <> 'ASBN'

Line 7440: jai_constants.tax_type_cvd_edu_cess

7436: 'CVD',
7437: jai_constants.tax_type_add_cvd , -- Date 31/10/2006 Bug 5228046 added by SACSETHI
7438: 'CUSTOMS',
7439: jai_constants.tax_type_customs_edu_cess,
7440: jai_constants.tax_type_cvd_edu_cess
7441: )
7442: AND NVL(jpt.vendor_id, 0) = vend_id
7443: AND cp_source <> 'ASBN'
7444: --ORDER BY tax_line_no; -- added bug#3038566 --pramasub FP | commented and order by is moved to end of the qry

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

7605: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
7606: select attribute_code tax_type
7607: from JAI_RGM_REGISTRATIONS
7608: where regime_id = cp_regime_id
7609: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
7610: and attribute_code = cp_tax_type;
7611:
7612: /*Added by kunkumar for bug#5593895*/
7613: Cursor c_tax_curr_prec(cp_tax_id jai_cmn_taxes_all.tax_id%type) is

Line 8160: Variable usage of jai_constants package.

8156: in this patch. So no pre - req.
8157:
8158: 115.3 4146708 Base Bug for Service + Cess Release.
8159:
8160: Variable usage of jai_constants package.
8161:
8162: Call to following,
8163: jai_general_pkg.is_item_an_expense
8164: jai_general_pkg.get_accounting_method

Line 8340: open c_jai_regimes(jai_constants.service_regime);

8336:
8337: lv_accrue_on_receipt_flag :=
8338: jai_rcv_trx_processing_pkg.get_accrue_on_receipt(p_po_distribution_id => po_dist_id);
8339:
8340: open c_jai_regimes(jai_constants.service_regime);
8341: fetch c_jai_regimes into r_jai_regimes;
8342: close c_jai_regimes;
8343:
8344: /* service End */

Line 8350: OPEN c_jai_regimes(jai_constants.vat_regime);

8346: /* Bug 5358788. Added by Lakshmi Gopalsami
8347: * Fetch VAT Regime id
8348: */
8349:
8350: OPEN c_jai_regimes(jai_constants.vat_regime);
8351: FETCH c_jai_regimes INTO r_vat_regimes;
8352: CLOSE c_jai_regimes;
8353:
8354: /* Bug 5401111. Added by Lakshmi Gopalsami

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

8406: r_vat_regime_tax_type := null;
8407:
8408: -- added, Kunkumar for Bug#5593895
8409: ln_base_amount := null ;
8410: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
8411: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
8412: (
8413: p_invoice_id => inv_id ,
8414: p_line_location_id => null ,

Line 8586: if tax_lines1_rec.modvat_flag = jai_constants.YES

8582: --added by Eric for inclusive tax on 20-dec-2007,end
8583:
8584: 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);
8585:
8586: if tax_lines1_rec.modvat_flag = jai_constants.YES
8587: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
8588: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
8589: then
8590: --

Line 8625: v_assets_tracking_flag := jai_constants.YES;

8621:
8622: elsif line = 2 then
8623:
8624: v_tax_amount := ln_nrec_tax_amt;
8625: v_assets_tracking_flag := jai_constants.YES;
8626: lv_modvat_flag := jai_constants.NO ;
8627:
8628: --
8629: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating

Line 8626: lv_modvat_flag := jai_constants.NO ;

8622: elsif line = 2 then
8623:
8624: v_tax_amount := ln_nrec_tax_amt;
8625: v_assets_tracking_flag := jai_constants.YES;
8626: lv_modvat_flag := jai_constants.NO ;
8627:
8628: --
8629: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
8630: -- projects related columns so that PROJECTS can consider this line for Project Costing

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

8666: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
8667: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
8668:
8669:
8670: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
8671: v_assets_tracking_flag := jai_constants.YES;
8672: END IF;
8673:
8674: lv_modvat_flag := jai_constants.NO ;

Line 8671: v_assets_tracking_flag := jai_constants.YES;

8667: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
8668:
8669:
8670: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
8671: v_assets_tracking_flag := jai_constants.YES;
8672: END IF;
8673:
8674: lv_modvat_flag := jai_constants.NO ;
8675:

Line 8674: lv_modvat_flag := jai_constants.NO ;

8670: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
8671: v_assets_tracking_flag := jai_constants.YES;
8672: END IF;
8673:
8674: lv_modvat_flag := jai_constants.NO ;
8675:
8676: --
8677: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
8678: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 8712: lv_modvat_flag := jai_constants.NO ;

8708: ELSIF ( line = 2 )
8709: THEN
8710: v_tax_amount := ln_nrec_tax_amt ;
8711: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
8712: lv_modvat_flag := jai_constants.NO ;
8713: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
8714: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
8715:
8716: --recoverable part without project infor

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

9256: r_vat_regime_tax_type := null;
9257:
9258: -- added, Kunkumar for bug#5593895
9259: ln_base_amount := null ;
9260: if tax_lines1_rec.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
9261: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
9262: (
9263: p_invoice_id => inv_id ,
9264: p_line_location_id => null ,

Line 9435: if tax_lines1_rec.modvat_flag = jai_constants.YES

9431:
9432:
9433: 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);
9434:
9435: if tax_lines1_rec.modvat_flag = jai_constants.YES
9436: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
9437: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
9438: then
9439: --

Line 9477: v_assets_tracking_flag := jai_constants.YES;

9473:
9474: elsif line = 2 then
9475:
9476: v_tax_amount := ln_nrec_tax_amt;
9477: v_assets_tracking_flag := jai_constants.YES;
9478: lv_modvat_flag := jai_constants.NO ;
9479: --
9480: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
9481: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 9478: lv_modvat_flag := jai_constants.NO ;

9474: elsif line = 2 then
9475:
9476: v_tax_amount := ln_nrec_tax_amt;
9477: v_assets_tracking_flag := jai_constants.YES;
9478: lv_modvat_flag := jai_constants.NO ;
9479: --
9480: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
9481: -- projects related columns so that PROJECTS can consider this line for Project Costing
9482: --

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

9520: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
9521: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
9522:
9523:
9524: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
9525: v_assets_tracking_flag := jai_constants.YES;
9526: END IF;
9527:
9528: lv_modvat_flag := jai_constants.NO ;

Line 9525: v_assets_tracking_flag := jai_constants.YES;

9521: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
9522:
9523:
9524: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
9525: v_assets_tracking_flag := jai_constants.YES;
9526: END IF;
9527:
9528: lv_modvat_flag := jai_constants.NO ;
9529:

Line 9528: lv_modvat_flag := jai_constants.NO ;

9524: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
9525: v_assets_tracking_flag := jai_constants.YES;
9526: END IF;
9527:
9528: lv_modvat_flag := jai_constants.NO ;
9529:
9530: --
9531: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
9532: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 9566: lv_modvat_flag := jai_constants.NO ;

9562: ELSIF ( line = 2 )
9563: THEN
9564: v_tax_amount := ln_nrec_tax_amt ;
9565: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
9566: lv_modvat_flag := jai_constants.NO ;
9567: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
9568: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
9569:
9570: --recoverable part without project infor

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

10156: CLOSE c_tax_curr_prec ;
10157:
10158: -- added, kunkumar for Bug#5593895
10159: ln_base_amount := null ;
10160: if i.tax_type IN ( jai_constants.tax_type_value_added, jai_constants.tax_type_cst ) then
10161: ln_base_amount := jai_ap_utils_pkg.fetch_tax_target_amt
10162: (
10163: p_invoice_id => inv_id ,
10164: p_line_location_id => cur_items_rec.line_location_id ,

Line 10296: if i.modvat_flag = jai_constants.YES

10292: --added by Eric for inclusive tax on 20-dec-2007,end
10293:
10294: 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);
10295:
10296: if i.modvat_flag = jai_constants.YES
10297: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
10298: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
10299: then
10300: --

Line 10338: v_assets_tracking_flag := jai_constants.YES;

10334:
10335: elsif line = 2 then
10336:
10337: v_tax_amount := ln_nrec_tax_amt;
10338: v_assets_tracking_flag := jai_constants.YES;
10339: lv_modvat_flag := jai_constants.NO ;
10340:
10341: --
10342: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating

Line 10339: lv_modvat_flag := jai_constants.NO ;

10335: elsif line = 2 then
10336:
10337: v_tax_amount := ln_nrec_tax_amt;
10338: v_assets_tracking_flag := jai_constants.YES;
10339: lv_modvat_flag := jai_constants.NO ;
10340:
10341: --
10342: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
10343: -- projects related columns so that PROJECTS can consider this line for Project Costing

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

10384: lv_ap_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
10385: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
10386:
10387:
10388: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
10389: v_assets_tracking_flag := jai_constants.YES;
10390: END IF;
10391:
10392: lv_modvat_flag := jai_constants.NO ;

Line 10389: v_assets_tracking_flag := jai_constants.YES;

10385: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
10386:
10387:
10388: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
10389: v_assets_tracking_flag := jai_constants.YES;
10390: END IF;
10391:
10392: lv_modvat_flag := jai_constants.NO ;
10393:

Line 10392: lv_modvat_flag := jai_constants.NO ;

10388: IF for_dist_insertion_rec.assets_tracking_flag = jai_constants.YES THEN
10389: v_assets_tracking_flag := jai_constants.YES;
10390: END IF;
10391:
10392: lv_modvat_flag := jai_constants.NO ;
10393:
10394: --
10395: -- This is a non recoverable line hence the tax amounts should be added into the project costs by populating
10396: -- projects related columns so that PROJECTS can consider this line for Project Costing

Line 10430: lv_modvat_flag := jai_constants.NO ;

10426: ELSIF ( line = 2 )
10427: THEN
10428: v_tax_amount := ln_nrec_tax_amt ;
10429: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
10430: lv_modvat_flag := jai_constants.NO ;
10431: lv_ap_line_to_inst_flag := 'N'; --added by eric for inclusive tax
10432: lv_tax_line_to_inst_flag := 'Y'; --added by eric for inclusive tax
10433:
10434: --recoverable part without project infor