[Home] [Help]
332: lv_process_message VARCHAR2(2000);
333: --=====================================================
334:
335: Cursor req_adhoc_tax_amt(taxid number) is
336: select A.tax_amount from JAI_PO_REQ_LINE_TAXES A, JAI_CMN_TAXES_ALL B
337: where A.tax_id = taxid
338: AND requisition_line_id in(select requisition_line_id
339: from po_req_distributions_all
340: where distribution_id in (select req_distribution_id
386: tax amount. fixed the issue by treating the adhoc tax if tax_rate_tab contains -99999
387:
388: 3 10-OCT-03 Vijay Shankar for Bug# 3190782, FileVersion: 616.2
389: Tax Calculation is not handled properly when P_TYPE='REQUISITION', which is made proper with this fix. Basically
390: assigning values to plsql tables is handled properly with common code by accessing JAI_PO_REQ_LINE_TAXES and
391: JAI_PO_TAXES through REF CURSOR. Code related to populating plsql tables during P_TYPE='REQUISITION'
392: is removed and aligned with PO code.
393:
394: 4. 12-OCT-05 Bug4210102. Added by LGOPALSA
544: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
545: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
546: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
547: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
548: FROM JAI_PO_REQ_LINE_TAXES A,
549: JAI_CMN_TAXES_ALL B,
550: jai_regime_tax_types_v aa
551: WHERE requisition_line_Id = p_line_id
552: AND A.Tax_Id = B.Tax_Id
1389: 'TDS', 2, 0)) tax_type_val,
1390: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1391: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
1392: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1393: FROM JAI_PO_REQ_LINE_TAXES A,
1394: JAI_CMN_TAXES_ALL B,
1395: jai_regime_tax_types_v aa
1396: WHERE requisition_line_Id = p_line_id
1397: AND A.Tax_Id = B.Tax_Id
1978: bsln_amt := p_vat_assess_value;
1979: ELSE
1980: bsln_amt := p_price;
1981: END IF;
1982: UPDATE JAI_PO_REQ_LINE_TAXES
1983: SET Tax_Amount = nvl(tax_amt_tab(I),0),
1984: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
1985: WHERE Requisition_Header_Id = p_header_id
1986: AND Requisition_Line_Id = p_line_id
2049: ELSE
2050: bsln_amt := p_price;
2051: END IF;
2052: v_tax_amt := v_tax_amt + nvl(tax_amt_tab(I),0);
2053: UPDATE JAI_PO_REQ_LINE_TAXES
2054: SET Tax_Amount = nvl(tax_amt_tab(I),0),
2055: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2056: WHERE Requisition_Line_Id = p_header_id
2057: AND Tax_Line_No = I;
2887: ---------------------------------------------------
2888: 'TDS', 2, 0
2889: )
2890: ) tax_type_val
2891: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
2892: WHERE requisition_line_id = p_line_id
2893: AND a.Tax_Id = b.Tax_Id
2894: AND aa.tax_type(+) = b.tax_type
2895: order by 1/*2*/;--Modified by Kevin Cheng for inclusive tax Dec 17, 2007
3054: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1, --,jai_constants.tax_type_cvd_edu_cess, 1,
3055: 'TDS', 2, 0
3056: )
3057: ) tax_type_val
3058: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
3059: WHERE requisition_line_id = p_line_id
3060: AND a.Tax_Id = b.Tax_Id
3061: AND aa.tax_type(+) = b.tax_type
3062: order by 2;
4927: --end, cbabu for Bug# 2659815
4928:
4929:
4930: --Bgowrava for Bug#5877782 Added standard Who columns
4931: UPDATE JAI_PO_REQ_LINE_TAXES
4932: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), nvl(rnd_factor(I),0) ),/*4281841*/
4933: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
4934: last_update_date = sysdate,
4935: last_updated_by = fnd_global.user_id,
4973: --ILIPROCUREMENT END
4974:
4975: --end, cbabu for Bug# 2659815
4976: --Bgowrava for Bug#5877782 Added standard Who columns
4977: UPDATE JAI_PO_REQ_LINE_TAXES
4978: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), rnd_factor(I) ),
4979: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
4980: last_update_date = sysdate,
4981: last_updated_by = fnd_global.user_id,