[Home] [Help]
376: lv_process_message VARCHAR2(2000);
377: --=====================================================
378:
379: Cursor req_adhoc_tax_amt(taxid number) is
380: select A.tax_amount from JAI_PO_REQ_LINE_TAXES A, JAI_CMN_TAXES_ALL B
381: where A.tax_id = taxid
382: AND requisition_line_id in(select requisition_line_id
383: from po_req_distributions_all
384: where distribution_id in (select req_distribution_id
436: tax amount. fixed the issue by treating the adhoc tax if tax_rate_tab contains -99999
437:
438: 3 10-OCT-03 Vijay Shankar for Bug# 3190782, FileVersion: 616.2
439: Tax Calculation is not handled properly when P_TYPE='REQUISITION', which is made proper with this fix. Basically
440: assigning values to plsql tables is handled properly with common code by accessing JAI_PO_REQ_LINE_TAXES and
441: JAI_PO_TAXES through REF CURSOR. Code related to populating plsql tables during P_TYPE='REQUISITION'
442: is removed and aligned with PO code.
443:
444: 4. 12-OCT-05 Bug4210102. Added by LGOPALSA
621: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
622: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
623: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
624: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
625: FROM JAI_PO_REQ_LINE_TAXES A,
626: JAI_CMN_TAXES_ALL B,
627: jai_regime_tax_types_v aa
628: WHERE requisition_line_Id = p_line_id
629: AND A.Tax_Id = B.Tax_Id
2068: 'TDS', 2, 0)) tax_type_val,
2069: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2070: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2071: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2072: FROM JAI_PO_REQ_LINE_TAXES A,
2073: JAI_CMN_TAXES_ALL B,
2074: jai_regime_tax_types_v aa
2075: WHERE requisition_line_Id = p_line_id
2076: AND A.Tax_Id = B.Tax_Id
2683: */
2684: ELSE
2685: bsln_amt := p_price;
2686: END IF;
2687: UPDATE JAI_PO_REQ_LINE_TAXES
2688: SET Tax_Amount = nvl(tax_amt_tab(I),0),
2689: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2690: WHERE Requisition_Header_Id = p_header_id
2691: AND Requisition_Line_Id = p_line_id
2766: ELSE
2767: bsln_amt := p_price;
2768: END IF;
2769: v_tax_amt := v_tax_amt + nvl(tax_amt_tab(I),0);
2770: UPDATE JAI_PO_REQ_LINE_TAXES
2771: SET Tax_Amount = nvl(tax_amt_tab(I),0),
2772: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2773: WHERE Requisition_Line_Id = p_header_id
2774: AND Tax_Line_No = I;
3655: ---------------------------------------------------
3656: 'TDS', 2, 0
3657: )
3658: ) tax_type_val
3659: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
3660: WHERE requisition_line_id = p_line_id
3661: AND a.Tax_Id = b.Tax_Id
3662: AND aa.tax_type(+) = b.tax_type
3663: order by 1/*2*/;--Modified by Kevin Cheng for inclusive tax Dec 17, 2007
3835: 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,
3836: 'TDS', 2, 0
3837: )
3838: ) tax_type_val
3839: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
3840: WHERE requisition_line_id = p_line_id
3841: AND a.Tax_Id = b.Tax_Id
3842: AND aa.tax_type(+) = b.tax_type
3843: order by 2;
6316: --end, cbabu for Bug# 2659815
6317:
6318:
6319: --Bgowrava for Bug#5877782 Added standard Who columns
6320: UPDATE JAI_PO_REQ_LINE_TAXES
6321: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), nvl(rnd_factor(I),0) ),/*4281841*/
6322: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
6323: last_update_date = sysdate,
6324: last_updated_by = fnd_global.user_id,
6362: --ILIPROCUREMENT END
6363:
6364: --end, cbabu for Bug# 2659815
6365: --Bgowrava for Bug#5877782 Added standard Who columns
6366: UPDATE JAI_PO_REQ_LINE_TAXES
6367: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), rnd_factor(I) ),
6368: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
6369: last_update_date = sysdate,
6370: last_updated_by = fnd_global.user_id,