[Home] [Help]
2125: OPEN Fetch_Sum_Cur( p_header_id );
2126: FETCH Fetch_Sum_Cur INTO v_tax_amt;
2127: CLOSE Fetch_Sum_Cur;
2128:
2129: UPDATE JAI_PO_LINE_LOCATIONS
2130: SET Tax_Amount = NVL( v_tax_amt, 0 ),
2131: Total_Amount = v_tax_amt + p_price
2132: WHERE Line_Location_Id = p_header_id
2133: AND Po_Line_Id = p_line_id;
2135: OPEN Fetch_Sum_Cur( p_line_loc_id );
2136: FETCH Fetch_Sum_Cur INTO v_tax_amt;
2137: CLOSE Fetch_Sum_Cur;
2138:
2139: UPDATE JAI_PO_LINE_LOCATIONS
2140: SET Tax_Amount = NVL( v_tax_amt, 0 ),
2141: Total_Amount = v_tax_amt + p_price
2142: WHERE Line_Location_Id = p_line_loc_id
2143: AND Po_Line_Id = p_line_id;
2446: ------------------------------ ------------------------------ ------------------------------ ------------------------------
2447:
2448: -- Get the Line Focus Id from the Sequence
2449:
2450: CURSOR Fetch_Focus_Id IS SELECT JAI_PO_LINE_LOCATIONS_S.NEXTVAL
2451: FROM Dual;
2452:
2453: ------------------------------ ------------------------------ ------------------------------ ------------------------------
2454:
2627:
2628: v_service_type_code :=jai_ar_rctla_trigger_pkg.get_service_type(v_vendor_id,v_vendor_site_id,'V');
2629:
2630:
2631: INSERT INTO JAI_PO_LINE_LOCATIONS( Line_Focus_Id, Line_Location_Id, Po_Line_Id, Po_Header_Id,
2632: Tax_Modified_Flag, Tax_Amount, Total_Amount,
2633: Creation_Date, Created_By, Last_Update_Date, Last_Updated_By,
2634: Last_Update_Login,Service_type_code )
2635: VALUES
2700: p_type IN VARCHAR2, -- Contains the type of document
2701: p_header_id IN NUMBER, -- Contains the header_id of the document
2702: P_line_id IN NUMBER, -- Contains the line_id of the document
2703: p_line_location_id IN NUMBER, -- Shipment line_id of the PO Document
2704: p_line_focus_id IN NUMBER, -- unique key of JAI_PO_LINE_LOCATIONS table
2705: p_line_quantity IN NUMBER, -- quantity given in the line
2706: p_base_value IN NUMBER, -- base value of the line i.e quantity * base price of item
2707: p_line_uom_code IN VARCHAR2, -- uom_code of the line item
2708: p_tax_amount IN OUT NOCOPY NUMBER, -- total tax amount that should be returned to the calling procedure
5047: --=====================================================
5048: END LOOP;
5049:
5050: --Bgowrava for Bug#5877782 Added standard Who columns
5051: UPDATE JAI_PO_LINE_LOCATIONS
5052: SET Tax_Amount = NVL( v_tax_amt, 0 ),
5053: Total_Amount = v_tax_amt + p_base_value ,
5054: last_update_date = sysdate,
5055: last_updated_by = fnd_global.user_id,
5154:
5155: v_line_id NUMBER;
5156:
5157: CURSOR Fetch_Focus_Id_Cur IS
5158: SELECT JAI_PO_LINE_LOCATIONS_S.nextval FROM Dual;
5159:
5160: -- Cursor definition for picking line_location_id from po_line_locations_all
5161:
5162: CURSOR Fetch_Line_Loc_Id_Cur IS
5160: -- Cursor definition for picking line_location_id from po_line_locations_all
5161:
5162: CURSOR Fetch_Line_Loc_Id_Cur IS
5163: SELECT jpll.Line_Location_Id
5164: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
5165: po_lines_all pla, po_headers_all pha
5166: WHERE pha.po_header_id = pla.po_header_id
5167: AND jpll.line_location_id = plla.line_location_id
5168: AND pha.po_header_id = plla.po_header_id
5179: WHERE pha.Po_Header_Id = p_from_hdr_id
5180: AND pla.line_num = p_line_num -- Vijay Shankar for Bug# 3466223
5181: AND pha.po_header_id =pla.po_header_id;
5182:
5183: -- Cursor definition for picking values from JAI_PO_LINE_LOCATIONS
5184: -- using line_location_id as where clause
5185: CURSOR Fetch_Ja_In_Po_Ln_Loc_Cur IS
5186: SELECT line_location_id, po_line_id, po_header_id, tax_modified_flag,
5187: tax_amount, total_amount, line_focus_id, creation_date,
5186: SELECT line_location_id, po_line_id, po_header_id, tax_modified_flag,
5187: tax_amount, total_amount, line_focus_id, creation_date,
5188: created_by, last_update_date, last_updated_by, last_update_login,
5189: tax_category_id -- cbabu for EnhancementBug# 2427465
5190: FROM JAI_PO_LINE_LOCATIONS
5191: WHERE Line_Location_Id = v_ln_loc_id;
5192:
5193: -- Cursor definition for picking values from JAI_PO_TAXES
5194: -- using line_location_id as where clause
5226: tax_category_id -- cbabu for EnhancementBug# 2427465
5227: FROM JAI_PO_TAXES
5228: WHERE Line_Location_Id = v_ln_loc_id;
5229:
5230: -- Cursor definition for picking values from JAI_PO_LINE_LOCATIONS
5231: -- using po_line_id as where clause
5232: CURSOR fetch_jain_line_cur IS
5233: SELECT line_location_id, po_line_id, po_header_id, tax_modified_flag,
5234: tax_amount, total_amount, line_focus_id, creation_date,
5233: SELECT line_location_id, po_line_id, po_header_id, tax_modified_flag,
5234: tax_amount, total_amount, line_focus_id, creation_date,
5235: created_by, last_update_date, last_updated_by, last_update_login,
5236: tax_category_id -- cbabu for EnhancementBug# 2427465
5237: FROM JAI_PO_LINE_LOCATIONS
5238: WHERE Po_Line_Id = v_line_id
5239: AND po_header_id = p_from_hdr_id
5240: AND ( line_location_id IS NULL
5241: OR line_location_id = 0 ); -- cbabu for EnhancementBug# 2427465
5345: FND_FILE.put_line( FND_FILE.log, 'v_seq_val->'||v_seq_val);
5346:
5347: FOR rec1 in Fetch_Jain_Line_Cur LOOP
5348:
5349: INSERT INTO JAI_PO_LINE_LOCATIONS (
5350: line_location_id, po_line_id, po_header_id,
5351: tax_modified_flag, tax_amount, total_amount,
5352: line_focus_id, creation_date, created_by,
5353: last_update_date, last_updated_by, last_update_login,
5402:
5403: OPEN Fetch_Ja_In_Po_Ln_Loc_Cur ;
5404: FETCH Fetch_Ja_In_Po_Ln_Loc_Cur INTO Fetch_Ja_In_Po_Ln_Loc_Rec;
5405:
5406: INSERT INTO JAI_PO_LINE_LOCATIONS (
5407: line_location_id, po_line_id, po_header_id,
5408: tax_modified_flag, tax_amount, total_amount, line_focus_id,
5409: creation_date, created_by, last_update_date, last_updated_by, last_update_login,
5410: tax_category_id,service_type_code -- cbabu for EnhancementBug# 2427465
5488: v_tax_amt NUMBER;
5489: dummy NUMBER;
5490: ln_vat_assess_value NUMBER;
5491:
5492: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
5493: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.copy_quot_taxes';
5494: ------------------------------>
5495:
5496: CURSOR tax_cur IS
5517: ORDER BY a.tax_line_no;
5518:
5519: CURSOR Fetch_Line_Focus_Id_Cur IS
5520: SELECT Line_Focus_Id
5521: FROM JAI_PO_LINE_LOCATIONS
5522: WHERE Po_Line_Id = p_po_line_id AND
5523: Line_Location_Id = p_line_loc_id;
5524:
5525: -- Start, added by Vijay Shankar for Bug# 3478460
5524:
5525: -- Start, added by Vijay Shankar for Bug# 3478460
5526: CURSOR c_line_tax_category_id_1(p_po_line_id IN NUMBER) IS
5527: SELECT tax_category_id
5528: FROM JAI_PO_LINE_LOCATIONS
5529: WHERE po_line_id = p_po_line_id
5530: AND line_location_id IS NULL;
5531:
5532: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
5530: AND line_location_id IS NULL;
5531:
5532: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
5533: SELECT tax_category_id
5534: FROM JAI_PO_LINE_LOCATIONS
5535: WHERE po_line_id = p_po_line_id
5536: AND line_location_id = p_line_location_id;
5537: -- End, 3478460
5538:
5582: are populated as in the Quotation, else Tax Amounts are populated to Zero, so that Recalculation
5583: of Taxes happen based upon precedences.
5584:
5585: 3 09/03/2004 Vijay Shankar for Bug# 3478460, FileVersion# 618.1
5586: Whenever the code doesn't fine a record for BPO Line in JAI_PO_LINE_LOCATIONS, then this procedure fails with either
5587: no_data_found or duplicate_records found. Fixed this by taking tax category from tax lines otherwise fetching from
5588: JAI_PO_LINE_LOCATIONS using the CURSORS c_line_tax_category_id_1 and c_line_tax_category_id_2
5589:
5590: 4. 17/mar-2005 Rchandan for bug#4245365 Version#115.2. base bug#4245089
5584:
5585: 3 09/03/2004 Vijay Shankar for Bug# 3478460, FileVersion# 618.1
5586: Whenever the code doesn't fine a record for BPO Line in JAI_PO_LINE_LOCATIONS, then this procedure fails with either
5587: no_data_found or duplicate_records found. Fixed this by taking tax category from tax lines otherwise fetching from
5588: JAI_PO_LINE_LOCATIONS using the CURSORS c_line_tax_category_id_1 and c_line_tax_category_id_2
5589:
5590: 4. 17/mar-2005 Rchandan for bug#4245365 Version#115.2. base bug#4245089
5591: Changes made to calculate VAT assessable value . This vat assessable is passed
5592: to the procedure that calculates the VAT related taxes
5685: CLOSE c_line_tax_category_id_2;
5686: END IF;
5687: end if;
5688:
5689: UPDATE JAI_PO_LINE_LOCATIONS
5690: SET tax_category_id = v_tax_category_id_holder
5691: WHERE line_focus_id = v_line_focus_id;
5692: -- End, 3478460
5693:
5695: -- Start, cbabu for EnhancementBug# 2427465
5696: BEGIN
5697: IF v_quot_line_loc_id = -999 THEN
5698: SELECT tax_category_id INTO v_tax_category_id_holder
5699: FROM JAI_PO_LINE_LOCATIONS
5700: WHERE po_line_id = p_frm_line_id
5701: AND (line_location_id IS NULL OR line_location_id = 0);
5702: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
5703: SELECT tax_category_id INTO v_tax_category_id_holder
5700: WHERE po_line_id = p_frm_line_id
5701: AND (line_location_id IS NULL OR line_location_id = 0);
5702: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
5703: SELECT tax_category_id INTO v_tax_category_id_holder
5704: FROM JAI_PO_LINE_LOCATIONS
5705: WHERE po_line_id = p_frm_line_id
5706: AND line_location_id = v_quot_line_loc_id;
5707: END IF;
5708:
5705: WHERE po_line_id = p_frm_line_id
5706: AND line_location_id = v_quot_line_loc_id;
5707: END IF;
5708:
5709: UPDATE JAI_PO_LINE_LOCATIONS
5710: SET tax_category_id = v_tax_category_id_holder
5711: WHERE line_focus_id = v_line_focus_id;
5712: EXCEPTION
5713: WHEN OTHERS THEN
5815: -- TYPE Uom IS TABLE OF CHAR(50) INDEX BY BINARY_INTEGER;
5816: TYPE Uom IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
5817: uom_tab uom;
5818:
5819: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
5820:
5821:
5822: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
5823:
5928:
5929: -- added by Vijay Shankar for Bug# 3487904
5930: CURSOR c_line_tax_category_id_1(p_po_line_id IN NUMBER) IS
5931: SELECT tax_category_id
5932: FROM JAI_PO_LINE_LOCATIONS
5933: WHERE po_line_id = p_po_line_id
5934: AND line_location_id IS NULL;
5935:
5936: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
5934: AND line_location_id IS NULL;
5935:
5936: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
5937: SELECT tax_category_id
5938: FROM JAI_PO_LINE_LOCATIONS
5939: WHERE po_line_id = p_po_line_id
5940: AND line_location_id = p_line_location_id;
5941: -- End, 3487904
5942:
6021: 5 20/10/2003 Vijay Shankar for Bug# 3205861, FileVersion# 616.3
6022: because UOM_CODE plsql table is defined as CHAR(50), all the values in plsql table is being padded with spaces.
6023:
6024: 6 05/03/2004 Vijay Shankar for Bug# 3487904, FileVersion# 618.1
6025: Whenever the code doesn't fine a record for BPO Line in JAI_PO_LINE_LOCATIONS, then this procedure fails with either
6026: no_data_found or duplicate_records found. Fixed this by taking tax category from tax lines otherwise fetching from
6027: JAI_PO_LINE_LOCATIONS using the CURSORS c_line_tax_category_id_1 and c_line_tax_category_id_2
6028:
6029: 7. 17/mar-2005 Rchandan for bug#4245365 Version#115.2. base bug#4245089
6023:
6024: 6 05/03/2004 Vijay Shankar for Bug# 3487904, FileVersion# 618.1
6025: Whenever the code doesn't fine a record for BPO Line in JAI_PO_LINE_LOCATIONS, then this procedure fails with either
6026: no_data_found or duplicate_records found. Fixed this by taking tax category from tax lines otherwise fetching from
6027: JAI_PO_LINE_LOCATIONS using the CURSORS c_line_tax_category_id_1 and c_line_tax_category_id_2
6028:
6029: 7. 17/mar-2005 Rchandan for bug#4245365 Version#115.2. base bug#4245089
6030: Changes made to calculate VAT assessable value . This vat assessable is passed
6031: to the procedure that calculates the VAT related taxes
6286: OPEN Fetch_Tot_Sum_Cur( v_line_loc_id );
6287: FETCH Fetch_Tot_Sum_Cur INTO v_tax_amt1;
6288: CLOSE Fetch_Tot_Sum_Cur;
6289:
6290: UPDATE JAI_PO_LINE_LOCATIONS
6291: SET Tax_Amount = v_tax_amt1,
6292: Total_Amount = NVL( v_qty * v_temp_price, 0 ) + v_tax_amt1 ,
6293: Last_Update_Date = p_last_cre_dt,
6294: Last_Updated_By = p_last_cre_by,
6465: CLOSE c_line_tax_category_id_2;
6466: END IF;
6467: end if;
6468:
6469: UPDATE JAI_PO_LINE_LOCATIONS
6470: SET tax_category_id = v_tax_category_id_holder
6471: WHERE line_focus_id = p_seq_val;
6472: -- End, 3487904
6473:
6475: -- Start, cbabu for EnhancementBug# 2427465
6476: BEGIN
6477: IF v_line_loc_id = -999 THEN
6478: SELECT tax_category_id INTO v_tax_category_id_holder
6479: FROM JAI_PO_LINE_LOCATIONS
6480: WHERE po_line_id = v_po_line_id
6481: AND (line_location_id IS NULL OR line_location_id = 0);
6482: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
6483: SELECT tax_category_id INTO v_tax_category_id_holder
6480: WHERE po_line_id = v_po_line_id
6481: AND (line_location_id IS NULL OR line_location_id = 0);
6482: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
6483: SELECT tax_category_id INTO v_tax_category_id_holder
6484: FROM JAI_PO_LINE_LOCATIONS
6485: WHERE po_line_id = v_po_line_id
6486: AND line_location_id = v_line_loc_id;
6487: END IF;
6488:
6485: WHERE po_line_id = v_po_line_id
6486: AND line_location_id = v_line_loc_id;
6487: END IF;
6488:
6489: UPDATE JAI_PO_LINE_LOCATIONS
6490: SET tax_category_id = v_tax_category_id_holder
6491: WHERE line_focus_id = p_seq_val;
6492: EXCEPTION
6493: WHEN OTHERS THEN
6674: v_curr_conv_factor NUMBER;
6675: v_assessable_value NUMBER;
6676: ln_vat_assess_value NUMBER; -- added, Harshita for bug #4245062
6677:
6678: v_tax_category_id JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
6679: v_tax_category_id_dflt JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
6680:
6681: CURSOR Fetch_UOMCode_Cur IS
6682: SELECT Uom_Code
6675: v_assessable_value NUMBER;
6676: ln_vat_assess_value NUMBER; -- added, Harshita for bug #4245062
6677:
6678: v_tax_category_id JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
6679: v_tax_category_id_dflt JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
6680:
6681: CURSOR Fetch_UOMCode_Cur IS
6682: SELECT Uom_Code
6683: FROM Mtl_Units_Of_Measure
6684: WHERE Unit_Of_Measure = v_uom_measure;
6685:
6686: CURSOR Fetch_Focus_Id_Cur IS
6687: SELECT Line_Focus_Id
6688: FROM JAI_PO_LINE_LOCATIONS
6689: WHERE Po_Line_Id = v_po_line_id
6690: AND Line_Location_Id IS NULL;
6691:
6692: CURSOR Fetch_Focus1_Id_Cur IS
6690: AND Line_Location_Id IS NULL;
6691:
6692: CURSOR Fetch_Focus1_Id_Cur IS
6693: SELECT Line_Focus_Id
6694: FROM JAI_PO_LINE_LOCATIONS
6695: WHERE Po_Line_Id = v_po_line_id
6696: AND Line_Location_Id = v_line_loc_id;
6697:
6698: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
6736:
6737: -- Start, added by Vijay Shankar for Bug# 3466223
6738: CURSOR c_line_tax_category_id_1(p_po_line_id IN NUMBER) IS
6739: SELECT tax_category_id
6740: FROM JAI_PO_LINE_LOCATIONS
6741: WHERE po_line_id = p_po_line_id
6742: AND line_location_id IS NULL;
6743:
6744: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
6742: AND line_location_id IS NULL;
6743:
6744: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
6745: SELECT tax_category_id
6746: FROM JAI_PO_LINE_LOCATIONS
6747: WHERE po_line_id = p_po_line_id
6748: AND line_location_id = p_line_location_id;
6749: -- End, Vijay Shankar for Bug# 3466223
6750: --Start,Added the following for forward porting to R12 kundan kumar
6994: CLOSE c_line_tax_category_id_2;
6995: END IF;
6996: END IF;
6997:
6998: UPDATE JAI_PO_LINE_LOCATIONS
6999: SET tax_category_id = v_tax_category_id_dflt
7000: WHERE line_focus_id = v_seq_val;
7001: -- End, Vijay Shankar for Bug# 3466223
7002:
7004: -- Start, cbabu for EnhancementBug# 2427465
7005: BEGIN
7006: IF v_frm_line_loc_id IS NOT NULL THEN
7007: SELECT tax_category_id INTO v_tax_category_id_dflt
7008: FROM JAI_PO_LINE_LOCATIONS
7009: WHERE line_location_id = v_frm_line_loc_id;
7010: ELSE
7011: SELECT tax_category_id INTO v_tax_category_id_dflt
7012: FROM JAI_PO_LINE_LOCATIONS
7008: FROM JAI_PO_LINE_LOCATIONS
7009: WHERE line_location_id = v_frm_line_loc_id;
7010: ELSE
7011: SELECT tax_category_id INTO v_tax_category_id_dflt
7012: FROM JAI_PO_LINE_LOCATIONS
7013: WHERE po_line_id = v_frm_po_line_id
7014: AND (line_location_id IS NULL OR line_location_id = 0);
7015: END IF;
7016:
7013: WHERE po_line_id = v_frm_po_line_id
7014: AND (line_location_id IS NULL OR line_location_id = 0);
7015: END IF;
7016:
7017: UPDATE JAI_PO_LINE_LOCATIONS
7018: SET tax_category_id = v_tax_category_id_dflt
7019: WHERE line_focus_id = v_seq_val;
7020:
7021: EXCEPTION
7042: OPEN Fetch_Sum_Cur( v_seq_val );
7043: FETCH Fetch_Sum_Cur INTO v_tax_amt;
7044: CLOSE Fetch_Sum_Cur;
7045:
7046: UPDATE JAI_PO_LINE_LOCATIONS
7047: SET Tax_Amount = NVL( v_tax_amt, 0 ),
7048: Total_Amount = NVL( ( v_qty * v_price ), 0 ) + Tax_Amount,
7049: Last_Updated_By = v_last_upd_by,
7050: Last_Update_Date = v_last_upd_dt,
7052: WHERE Line_Focus_id = v_seq_val;
7053:
7054: ELSE
7055:
7056: UPDATE JAI_PO_LINE_LOCATIONS
7057: SET Tax_Amount = NULL,
7058: Total_Amount = NULL,
7059: Last_Updated_By = v_last_upd_by,
7060: Last_Update_Date = v_last_upd_dt,
7144: WHERE Unit_Of_Measure = v_uom_measure;
7145:
7146: CURSOR Fetch_Focus_Id IS
7147: SELECT Line_Focus_Id
7148: FROM JAI_PO_LINE_LOCATIONS
7149: WHERE Po_Line_Id = v_po_line_id
7150: AND Po_Header_Id = v_po_hdr_id
7151: AND Line_Location_Id IS NULL;
7152:
7151: AND Line_Location_Id IS NULL;
7152:
7153: CURSOR Fetch_Focus1_Id IS
7154: SELECT Line_Focus_Id
7155: FROM JAI_PO_LINE_LOCATIONS
7156: WHERE Po_Line_Id = v_po_line_id
7157: AND Po_Header_Id = v_po_hdr_id
7158: AND Line_Location_Id = v_line_loc_id;
7159:
7205: DELETE Jai_Po_Taxes
7206: WHERE Po_Line_Id = v_po_line_id
7207: AND NVL( Line_Location_Id, 0 ) = NVL( v_line_loc_id, 0 ); /* Replaced -999 with 0 - Bug 6012541 */
7208:
7209: UPDATE Jai_Po_Line_Locations
7210: SET Tax_Amount = NULL,
7211: Total_Amount = NULL,
7212: Last_Updated_By = fnd_global.user_id,
7213: Last_Update_Date = sysdate,
7351: Last_Update_Login = v_last_upd_login
7352: WHERE Po_Line_Id = v_po_line_id
7353: AND Line_Location_Id = v_line_loc_id;
7354:
7355: UPDATE JAI_PO_LINE_LOCATIONS
7356: SET Tax_Amount = NULL,
7357: Total_Amount = NULL,
7358: Last_Updated_By = v_last_upd_by,
7359: Last_Update_Date = v_last_upd_dt,
7371: Last_Update_Login = v_last_upd_login
7372: WHERE Po_Line_Id = v_po_line_id
7373: AND Line_Location_Id IS NULL;
7374:
7375: UPDATE JAI_PO_LINE_LOCATIONS
7376: SET Tax_Amount = NULL,
7377: Total_Amount = NULL,
7378: Last_Updated_By = v_last_upd_by,
7379: Last_Update_Date = v_last_upd_dt,
7393: OPEN Fetch_Sum_Cur;
7394: FETCH Fetch_Sum_Cur INTO v_tax_amt;
7395: CLOSE Fetch_Sum_Cur;
7396:
7397: UPDATE JAI_PO_LINE_LOCATIONS
7398: SET Tax_Amount = nvl(v_tax_amt,0),
7399: Total_Amount = NVL( ( v_qty * v_price ), 0 ) + nvl(v_tax_amt,0),
7400: Last_Updated_By = v_last_upd_by,
7401: Last_Update_Date = v_last_upd_dt,