[Home] [Help]
2534: -- deleted supplementary invoice block by Aparajita on 03/11/2002 for bug # 2567799.
2535: -- supplemntary invoice not being used.
2536:
2537: v_apportn_factor_for_item_line :=
2538: jai_ap_utils_pkg.get_apportion_factor(inv_id, pn_invoice_line_number);
2539: -- bug#3752887
2540:
2541: /* service Start */
2542:
2668: --if i.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and i.vat_flag = 'Q' --Added IN clause for bug#13363329
2669: if i.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX','Excise','EXCISE_EDUCATION_CESS','EXCISE_SH_EDU_CESS') and i.vat_flag = 'Q' -- for bug 16195110 by anupgupt
2670: then
2671: --Changes by nprashar for bug # 13363329
2672: v_apportn_factor_for_adhoc:= jai_ap_utils_pkg.get_apportion_factor(inv_id, pn_invoice_line_number,'QUANTITY');
2673: v_tax_amount := i.tax_amount * v_apportn_factor_for_adhoc;
2674: -- end bug # 13024213
2675: --elsif i.tax_type not in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX')
2676: elsif i.tax_type not in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX','Excise','EXCISE_EDUCATION_CESS','EXCISE_SH_EDU_CESS') -- for bug 16195110 by anupgupt
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 ,
3382: p_parent_dist_id => r_ap_dist.invoice_distribution_id ,
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 ,
4129: p_transaction_id => rcv_tran_id ,
4244: --if tax_lines1_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and tax_lines1_rec.vat_flag = 'Q' --Added IN clause for bug 13363329
4245: if tax_lines1_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX','Excise','EXCISE_EDUCATION_CESS','EXCISE_SH_EDU_CESS') and tax_lines1_rec.vat_flag = 'Q' -- for bug 16195110 by anupgupt
4246: then
4247: --Changes by nprashar for bug # 13363329
4248: v_apportn_factor_for_adhoc:= jai_ap_utils_pkg.get_apportion_factor(inv_id, pn_invoice_line_number,'QUANTITY');
4249: v_tax_amount := tax_lines1_rec.tax_amount * v_apportn_factor_for_adhoc;
4250: -- end bug # 13024213
4251: --elsif r_tax_lines_rec.tax_type not in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX')
4252: elsif r_tax_lines_rec.tax_type not in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX','Excise','EXCISE_EDUCATION_CESS','EXCISE_SH_EDU_CESS') -- for bug 16195110 by anupgupt
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 ,
5041: p_transaction_id => rcv_tran_id ,
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 ,
5968: p_transaction_id => rcv_tran_id ,
6086: --if r_tax_lines_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and r_tax_lines_rec.vat_flag = 'Q' ---Added In clause for bug# 13363329
6087: if r_tax_lines_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX','Excise','EXCISE_EDUCATION_CESS','EXCISE_SH_EDU_CESS') and r_tax_lines_rec.vat_flag = 'Q' -- for bug 16195110 by anupgupt
6088: then
6089: --Changes by nprashar for bug # 13363329
6090: v_apportn_factor_for_adhoc:= jai_ap_utils_pkg.get_apportion_factor(inv_id, pn_invoice_line_number,'QUANTITY');
6091: v_tax_amount := r_tax_lines_rec.tax_amount * v_apportn_factor_for_adhoc;
6092: -- end bug # 13024213
6093: --elsif r_tax_lines_rec.tax_type not in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX')
6094: elsif r_tax_lines_rec.tax_type not in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX','Excise','EXCISE_EDUCATION_CESS','EXCISE_SH_EDU_CESS') -- for bug 16195110 by anupgupt
8304: CLOSE for_dist_insertion;
8305:
8306:
8307: v_apportn_factor_for_item_line :=
8308: jai_ap_utils_pkg.get_apportion_factor(inv_id, pn_invoice_line_number);
8309: -- bug#3752887
8310:
8311: /* service Start */
8312:
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 ,
8415: p_transaction_id => rcv_tran_id ,
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 ,
9265: p_transaction_id => rcv_tran_id ,
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 ,
10165: p_transaction_id => null ,