DBA Data[Home] [Help]

APPS.JAI_BOE_MIGRATION_PKG dependencies on JAI_CONSTANTS

Line 992: ,pv_tax_type => jai_constants.tax_type_customs

988: Fnd_File.put_line(Fnd_File.LOG,' **Start details_split for boe_detail_id:' ||pn_boe_detail_id || '--- **');
989: IF nvl(dedicate_dtl_rec.customs,0) > 0 THEN
990: ln_boe_tax_line_num := ln_boe_tax_line_num + 1;
991: insert_tax_wise_data(pn_tax_category_id => pn_tax_category_id
992: ,pv_tax_type => jai_constants.tax_type_customs
993: ,pn_boe_detail_id => pn_boe_detail_id
994: ,pn_boe_tax_line_num => ln_boe_tax_line_num
995: ,pn_tax_amount => dedicate_dtl_rec.customs
996: ,pn_tax_applied_amount => dedicate_dtl_rec.customs * nvl(pn_applied_percentage,0));

Line 1003: ,pv_tax_type => jai_constants.tax_type_boe_add_customs

999:
1000: IF nvl(dedicate_dtl_rec.additional_customs_duty,0) > 0 THEN
1001: ln_boe_tax_line_num := ln_boe_tax_line_num + 1;
1002: insert_tax_wise_data(pn_tax_category_id => pn_tax_category_id
1003: ,pv_tax_type => jai_constants.tax_type_boe_add_customs
1004: ,pn_boe_detail_id => pn_boe_detail_id
1005: ,pn_boe_tax_line_num => ln_boe_tax_line_num
1006: ,pn_tax_amount => dedicate_dtl_rec.additional_customs_duty
1007: ,pn_tax_applied_amount => dedicate_dtl_rec.additional_customs_duty * nvl(pn_applied_percentage,0));

Line 1014: ,pv_tax_type => jai_constants.tax_type_boe_surcharge_duty

1010:
1011: IF nvl(dedicate_dtl_rec.surcharge_duty,0) > 0 THEN
1012: ln_boe_tax_line_num := ln_boe_tax_line_num + 1;
1013: insert_tax_wise_data(pn_tax_category_id => pn_tax_category_id
1014: ,pv_tax_type => jai_constants.tax_type_boe_surcharge_duty
1015: ,pn_boe_detail_id => pn_boe_detail_id
1016: ,pn_boe_tax_line_num => ln_boe_tax_line_num
1017: ,pn_tax_amount => dedicate_dtl_rec.surcharge_duty
1018: ,pn_tax_applied_amount => dedicate_dtl_rec.surcharge_duty * nvl(pn_applied_percentage,0));

Line 1024: ,pv_tax_type => jai_constants.tax_type_cvd_edu_cess

1020:
1021: IF nvl(dedicate_dtl_rec.cvd_education_cess,0) > 0 THEN
1022: ln_boe_tax_line_num := ln_boe_tax_line_num + 1;
1023: insert_tax_wise_data(pn_tax_category_id => pn_tax_category_id
1024: ,pv_tax_type => jai_constants.tax_type_cvd_edu_cess
1025: ,pn_boe_detail_id => pn_boe_detail_id
1026: ,pn_boe_tax_line_num => ln_boe_tax_line_num
1027: ,pn_tax_amount => dedicate_dtl_rec.cvd_education_cess
1028: ,pn_tax_applied_amount => dedicate_dtl_rec.cvd_education_cess * nvl(pn_applied_percentage,0));

Line 1034: ,pv_tax_type => jai_constants.tax_type_customs_edu_cess

1030: END IF;
1031: IF nvl(dedicate_dtl_rec.customs_edu_cess,0) > 0 THEN
1032: ln_boe_tax_line_num := ln_boe_tax_line_num + 1;
1033: insert_tax_wise_data(pn_tax_category_id => pn_tax_category_id
1034: ,pv_tax_type => jai_constants.tax_type_customs_edu_cess
1035: ,pn_boe_detail_id => pn_boe_detail_id
1036: ,pn_boe_tax_line_num => ln_boe_tax_line_num
1037: ,pn_tax_amount => dedicate_dtl_rec.customs_edu_cess
1038: ,pn_tax_applied_amount => dedicate_dtl_rec.customs_edu_cess * nvl(pn_applied_percentage ,0));

Line 1043: ,pv_tax_type => jai_constants.tax_type_add_cvd

1039: END IF;
1040: IF nvl(dedicate_dtl_rec.additional_CVD,0) > 0 THEN
1041: ln_boe_tax_line_num := ln_boe_tax_line_num + 1;
1042: insert_tax_wise_data(pn_tax_category_id => pn_tax_category_id
1043: ,pv_tax_type => jai_constants.tax_type_add_cvd
1044: ,pn_boe_detail_id => pn_boe_detail_id
1045: ,pn_boe_tax_line_num => ln_boe_tax_line_num
1046: ,pn_tax_amount => dedicate_dtl_rec.additional_CVD
1047: ,pn_tax_applied_amount => dedicate_dtl_rec.additional_CVD * nvl(pn_applied_percentage ,0));

Line 1054: ,pv_tax_type => jai_constants.tax_type_sh_customs_edu_Cess

1050:
1051: IF nvl(dedicate_dtl_rec.customs_sh_education_cess,0) > 0 THEN
1052: ln_boe_tax_line_num := ln_boe_tax_line_num + 1;
1053: insert_tax_wise_data(pn_tax_category_id => pn_tax_category_id
1054: ,pv_tax_type => jai_constants.tax_type_sh_customs_edu_Cess
1055: ,pn_boe_detail_id => pn_boe_detail_id
1056: ,pn_boe_tax_line_num => ln_boe_tax_line_num
1057: ,pn_tax_amount => dedicate_dtl_rec.customs_sh_education_cess
1058: ,pn_tax_applied_amount => dedicate_dtl_rec.customs_sh_education_cess * nvl(pn_applied_percentage ,0));

Line 1065: ,pv_tax_type => jai_constants.tax_type_sh_cvd_edu_cess

1061:
1062: IF nvl(dedicate_dtl_rec.cvd_sh_edu_cess,0) > 0 THEN
1063: ln_boe_tax_line_num := ln_boe_tax_line_num + 1;
1064: insert_tax_wise_data(pn_tax_category_id => pn_tax_category_id
1065: ,pv_tax_type => jai_constants.tax_type_sh_cvd_edu_cess
1066: ,pn_boe_detail_id => pn_boe_detail_id
1067: ,pn_boe_tax_line_num => ln_boe_tax_line_num
1068: ,pn_tax_amount => dedicate_dtl_rec.cvd_sh_edu_cess
1069: ,pn_tax_applied_amount => dedicate_dtl_rec.cvd_sh_edu_cess * nvl(pn_applied_percentage,0));

Line 1262: AND rttv.regime_code = jai_constants.customs_regime

1258: jai_regime_tax_types_v rttv
1259: WHERE jitc.tax_category_id = jctl.tax_category_id
1260: AND jctl.tax_id = b.tax_id
1261: AND rttv.tax_type = b.tax_type
1262: AND rttv.regime_code = jai_constants.customs_regime
1263: AND jitc.tax_category_id = ln_tax_category_id
1264: GROUP BY jitc.tax_category_id, b.tax_type, rttv.regime_code;
1265:
1266: tax_category_rec tax_category_cur%ROWTYPE;

Line 1277: IF tax_category_rec.regime_code <> jai_constants.customs_regime THEN

1273: xv_valid_flag := 'Y';
1274:
1275: FOR tax_category_rec IN tax_category_cur(pn_tax_category_id) LOOP
1276: ln_cnt := ln_cnt + 1;
1277: IF tax_category_rec.regime_code <> jai_constants.customs_regime THEN
1278: xv_valid_flag := 'N';
1279: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||'has non customs tax_id ' ||tax_category_rec.tax_id || '** ');
1280: EXIT;
1281: END IF;