[Home] [Help]
179: -- additions by sriram - starts here Bug # 2977200
180:
181: CURSOR c_reqn_line_id(p_reqn_line_id Number) is
182: SELECT 1
183: FROM JAI_PO_REQ_LINE_TAXES
184: WHERE requisition_line_id = p_reqn_line_id;
185:
186: v_reqn_ctr Number :=0;
187:
230: the tax table will be useful to identify whether the tax is a defaulted or a manual tax.
231:
232: 2. 26/05/2003 sriram - Bug # 2977200
233:
234: A check has been added to ensure that the insert into JAI_PO_REQ_LINE_TAXES
235: should happen only when the requisition line id
236: does not exist in the JAI_PO_REQ_LINE_TAXES table.
237: This check has been added at 2 places , before insert into JAI_PO_REQ_LINE_TAXES
238:
232: 2. 26/05/2003 sriram - Bug # 2977200
233:
234: A check has been added to ensure that the insert into JAI_PO_REQ_LINE_TAXES
235: should happen only when the requisition line id
236: does not exist in the JAI_PO_REQ_LINE_TAXES table.
237: This check has been added at 2 places , before insert into JAI_PO_REQ_LINE_TAXES
238:
239: 3 21/10/2003 Vijay Shankar for Bug# 3207886, FileVersion# 616.2
240: Taxes are not getting defaulted from ITEM_CLASS and TAX_CATEGORY setup if Supplier information is not provided
233:
234: A check has been added to ensure that the insert into JAI_PO_REQ_LINE_TAXES
235: should happen only when the requisition line id
236: does not exist in the JAI_PO_REQ_LINE_TAXES table.
237: This check has been added at 2 places , before insert into JAI_PO_REQ_LINE_TAXES
238:
239: 3 21/10/2003 Vijay Shankar for Bug# 3207886, FileVersion# 616.2
240: Taxes are not getting defaulted from ITEM_CLASS and TAX_CATEGORY setup if Supplier information is not provided
241: requisition line. The issue occured because jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts the Inventory
709: v_po_line_id := Rec.Po_Line_Id;
710:
711:
712: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
713: INSERT INTO JAI_PO_REQ_LINE_TAXES(
714: requisition_line_id, requisition_header_id, tax_line_no,
715: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
716: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
717: tax_id, tax_rate, qty_rate, uom, tax_amount, tax_target_amount,
762: v_po_line_id := Rec.Po_Line_Id;
763:
764:
765: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
766: INSERT INTO JAI_PO_REQ_LINE_TAXES(
767: requisition_line_id, requisition_header_id, tax_line_no,
768: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
769: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
770: tax_id, tax_rate, qty_rate, uom, tax_amount, tax_target_amount,
879: END IF;
880:
881: SELECT SUM(TAX_AMOUNT)
882: INTO v_tax_amount
883: FROM JAI_PO_REQ_LINE_TAXES
884: WHERE Requisition_Header_Id = v_requisition_header_id
885: AND Requisition_Line_Id = v_requisition_line_id
886: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS' ;Ramananda for removal of SQL LITERALs */
887: v_total_amount := v_line_amount + v_tax_amount;
1059: Precedence_6, Precedence_7, Precedence_8, Precedence_9, Precedence_10,
1060: Tax_Id, Currency, Tax_Rate, Qty_Rate, UOM, Tax_Amount, Tax_Type, Modvat_Flag,
1061: Vendor_Id, Tax_Target_Amount,
1062: tax_category_id -- cbabu for EnhancementBug# 2427465
1063: FROM JAI_PO_REQ_LINE_TAXES
1064: WHERE requisition_line_id = rqlineid
1065: ORDER BY Tax_Line_No;
1066:
1067: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS
2003:
2004: CURSOR c_reqn_line_id(p_reqn_line_id Number) is
2005: SELECT 1
2006: --FROM ja_in_reqn_tax_lines
2007: FROM JAI_PO_REQ_LINE_TAXES
2008: WHERE requisition_line_id = p_reqn_line_id;
2009:
2010: v_unit_price NUMBER;
2011:
2313:
2314:
2315: --IF DELETING THEN
2316: IF pv_action = jai_constants.deleting THEN
2317: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2318: WHERE requisition_line_id = pr_old.requisition_line_id ;
2319:
2320: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines
2321: WHERE requisition_line_id = pr_old.requisition_line_id;
2324:
2325: --ELSIF UPDATING AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2326: ELSIF pv_action = jai_constants.updating
2327: AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2328: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2329: WHERE requisition_line_id = pr_old.requisition_line_id ;
2330:
2331: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines
2332: WHERE requisition_line_id = pr_old.requisition_line_id;
2463: NVL( pr_old.suggested_vendor_location, 'X' ) <> NVL( pr_new.suggested_vendor_location, 'X' )
2464: )
2465: ) Then --pramasub end FP
2466:
2467: Delete From JAI_PO_REQ_LINE_TAXES
2468: Where Requisition_Line_Id = v_line_id;
2469: -- IF nvl(lv_enable_gst_flag,'N') = 'N' THEN--Added by Xiao Lv for bug 10043656
2470: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES( v_dest_org_id, v_vendor_id, /*rchandan for bug# replaced NVL(v_org_id,0) with v_dest_org_id*/ --pramasub FP
2471: v_site_id, v_inventory_item_id, v_header_id,
2507: WHERE Requisition_Line_Id = v_line_id
2508: AND Requisition_Header_Id = v_header_id;*/ --pramasub commented for FP
2509: --pramasub FP start 115.10
2510: ELSIF v_tax_flag = 'N' THEN /*5852041*/
2511: Delete From JAI_PO_REQ_LINE_TAXES --Ja_In_Reqn_Tax_Lines pramasub FP
2512: Where Requisition_Line_Id = v_line_id;
2513: IF v_blanket_hdr IS NOT NULL AND v_blanket_line IS NOT NULL THEN
2514: --Ja_In_Locate_Line( v_blanket_hdr, v_blanket_line, v_quantity, v_po_line_id, v_line_location_id );
2515: jai_po_cmn_pkg.locate_source_line( v_blanket_hdr, v_blanket_line, v_quantity, v_po_line_id,
2519: close c_reqn_line_id;
2520:
2521: if nvl(v_reqn_ctr,0) = 0 then
2522: FOR rec IN cur_bpa_tax_lines(v_po_line_id, v_line_location_id) LOOP
2523: INSERT INTO JAI_PO_REQ_LINE_TAXES(requisition_line_id, requisition_header_id, tax_line_no,
2524: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
2525: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
2526: tax_id, tax_rate, qty_rate, uom, tax_amount, tax_target_amount,
2527: tax_type, modvat_flag, vendor_id, currency,
2622: END IF;
2623: END IF;
2624: --pramasub FP end
2625: ELSIF v_tax_flag = 'Y' Then
2626: Update JAI_PO_REQ_LINE_TAXES
2627: Set Tax_Amount = 0
2628: WHERE Requisition_Header_Id = v_header_id
2629: AND Requisition_Line_Id = v_line_id
2630: --AND Tax_Rate is Not Null;
2631: AND nvl(Tax_Rate,0) <> 0 and nvl(qty_rate,0) <> 0; /*5852041*/ --pramasub FP 115.10
2632: /*5852041*/ --pramasub FP 115.12
2633: IF ( NVL( pr_old.CURRENCY_CODE, 'INR' ) <> NVL( pr_new.CURRENCY_CODE,'INR' ) ) THEN
2634:
2635: UPDATE JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2636: SET currency = nvl(pr_new.CURRENCY_CODE,'INR')
2637: WHERE requisition_header_id = v_header_id
2638: AND requisition_line_id = v_line_id;
2639:
2636: SET currency = nvl(pr_new.CURRENCY_CODE,'INR')
2637: WHERE requisition_header_id = v_header_id
2638: AND requisition_line_id = v_line_id;
2639:
2640: UPDATE JAI_PO_REQ_LINE_TAXES jrtl --ja_in_reqn_tax_lines jrtl
2641: SET tax_amount = tax_amount * DECODE(nvl(pr_new.CURRENCY_CODE,'INR'),
2642: 'INR',jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, pr_old.CURRENCY_CODE,
2643: pr_old.rate_date, pr_old.rate_type, pr_old.rate ),conv_rate)
2644: WHERE requisition_header_id = v_header_id
3160:
3161:
3162: IF v_tax_flag = 'N' THEN
3163:
3164: Delete From JAI_PO_REQ_LINE_TAXES
3165: Where Requisition_Line_Id = v_line_id;
3166:
3167: --lv_enable_gst_flag := JAI_GST_GENERAL_PKG.IS_GST_ENABLED;--Added by Xiao Lv for bug 10043656
3168: --IF nvl(lv_enable_gst_flag,'N') = 'N' THEN
3206: WHERE Requisition_Line_Id = v_line_id
3207: AND Requisition_Header_Id = v_header_id;
3208:
3209: ELSIF v_tax_flag = 'Y' THEN
3210: Update JAI_PO_REQ_LINE_TAXES
3211: Set Tax_Amount = 0
3212: WHERE Requisition_Header_Id = v_header_id
3213: AND Requisition_Line_Id = v_line_id
3214: AND Currency = NVL( v_currency, v_hdr_curr )