[Home] [Help]
2846: OPEN Fetch_Sum_Cur( p_header_id );
2847: FETCH Fetch_Sum_Cur INTO v_tax_amt;
2848: CLOSE Fetch_Sum_Cur;
2849:
2850: UPDATE JAI_PO_LINE_LOCATIONS
2851: SET Tax_Amount = NVL( v_tax_amt, 0 ),
2852: Total_Amount = v_tax_amt + p_price
2853: WHERE Line_Location_Id = p_header_id
2854: AND Po_Line_Id = p_line_id;
2856: OPEN Fetch_Sum_Cur( p_line_loc_id );
2857: FETCH Fetch_Sum_Cur INTO v_tax_amt;
2858: CLOSE Fetch_Sum_Cur;
2859:
2860: UPDATE JAI_PO_LINE_LOCATIONS
2861: SET Tax_Amount = NVL( v_tax_amt, 0 ),
2862: Total_Amount = v_tax_amt + p_price
2863: WHERE Line_Location_Id = p_line_loc_id
2864: AND Po_Line_Id = p_line_id;
3170: ------------------------------ ------------------------------ ------------------------------ ------------------------------
3171:
3172: -- Get the Line Focus Id from the Sequence
3173:
3174: CURSOR Fetch_Focus_Id IS SELECT JAI_PO_LINE_LOCATIONS_S.NEXTVAL
3175: FROM Dual;
3176:
3177: ------------------------------ ------------------------------ ------------------------------ ------------------------------
3178:
3380:
3381: v_service_type_code :=jai_ar_rctla_trigger_pkg.get_service_type(v_vendor_id,v_vendor_site_id,'V');
3382:
3383:
3384: INSERT INTO JAI_PO_LINE_LOCATIONS( Line_Focus_Id, Line_Location_Id, Po_Line_Id, Po_Header_Id,
3385: Tax_Modified_Flag, Tax_Amount, Total_Amount,
3386: Creation_Date, Created_By, Last_Update_Date, Last_Updated_By,
3387: Last_Update_Login,Service_type_code )
3388: VALUES
3457: p_type IN VARCHAR2, -- Contains the type of document
3458: p_header_id IN NUMBER, -- Contains the header_id of the document
3459: P_line_id IN NUMBER, -- Contains the line_id of the document
3460: p_line_location_id IN NUMBER, -- Shipment line_id of the PO Document
3461: p_line_focus_id IN NUMBER, -- unique key of JAI_PO_LINE_LOCATIONS table
3462: p_line_quantity IN NUMBER, -- quantity given in the line
3463: p_base_value IN NUMBER, -- base value of the line i.e quantity * base price of item
3464: p_line_uom_code IN VARCHAR2, -- uom_code of the line item
3465: p_tax_amount IN OUT NOCOPY NUMBER, -- total tax amount that should be returned to the calling procedure
6436: --=====================================================
6437: END LOOP;
6438:
6439: --Bgowrava for Bug#5877782 Added standard Who columns
6440: UPDATE JAI_PO_LINE_LOCATIONS
6441: SET Tax_Amount = NVL( v_tax_amt, 0 ),
6442: Total_Amount = v_tax_amt + p_base_value ,
6443: last_update_date = sysdate,
6444: last_updated_by = fnd_global.user_id,
6543:
6544: v_line_id NUMBER;
6545:
6546: CURSOR Fetch_Focus_Id_Cur IS
6547: SELECT JAI_PO_LINE_LOCATIONS_S.nextval FROM Dual;
6548:
6549: -- Cursor definition for picking line_location_id from po_line_locations_all
6550:
6551: CURSOR Fetch_Line_Loc_Id_Cur IS
6549: -- Cursor definition for picking line_location_id from po_line_locations_all
6550:
6551: CURSOR Fetch_Line_Loc_Id_Cur IS
6552: SELECT jpll.Line_Location_Id
6553: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
6554: po_lines_all pla, po_headers_all pha
6555: WHERE pha.po_header_id = pla.po_header_id
6556: AND jpll.line_location_id = plla.line_location_id
6557: AND pha.po_header_id = plla.po_header_id
6568: WHERE pha.Po_Header_Id = p_from_hdr_id
6569: AND pla.line_num = p_line_num -- Vijay Shankar for Bug# 3466223
6570: AND pha.po_header_id =pla.po_header_id;
6571:
6572: -- Cursor definition for picking values from JAI_PO_LINE_LOCATIONS
6573: -- using line_location_id as where clause
6574: CURSOR Fetch_Ja_In_Po_Ln_Loc_Cur IS
6575: SELECT line_location_id, po_line_id, po_header_id, tax_modified_flag,
6576: tax_amount, total_amount, line_focus_id, creation_date,
6575: SELECT line_location_id, po_line_id, po_header_id, tax_modified_flag,
6576: tax_amount, total_amount, line_focus_id, creation_date,
6577: created_by, last_update_date, last_updated_by, last_update_login,
6578: tax_category_id -- cbabu for EnhancementBug# 2427465
6579: FROM JAI_PO_LINE_LOCATIONS
6580: WHERE Line_Location_Id = v_ln_loc_id;
6581:
6582: -- Cursor definition for picking values from JAI_PO_TAXES
6583: -- using line_location_id as where clause
6615: tax_category_id -- cbabu for EnhancementBug# 2427465
6616: FROM JAI_PO_TAXES
6617: WHERE Line_Location_Id = v_ln_loc_id;
6618:
6619: -- Cursor definition for picking values from JAI_PO_LINE_LOCATIONS
6620: -- using po_line_id as where clause
6621: CURSOR fetch_jain_line_cur IS
6622: SELECT line_location_id, po_line_id, po_header_id, tax_modified_flag,
6623: tax_amount, total_amount, line_focus_id, creation_date,
6622: SELECT line_location_id, po_line_id, po_header_id, tax_modified_flag,
6623: tax_amount, total_amount, line_focus_id, creation_date,
6624: created_by, last_update_date, last_updated_by, last_update_login,
6625: tax_category_id -- cbabu for EnhancementBug# 2427465
6626: FROM JAI_PO_LINE_LOCATIONS
6627: WHERE Po_Line_Id = v_line_id
6628: AND po_header_id = p_from_hdr_id
6629: AND ( line_location_id IS NULL
6630: OR line_location_id = 0 ); -- cbabu for EnhancementBug# 2427465
6734: FND_FILE.put_line( FND_FILE.log, 'v_seq_val->'||v_seq_val);
6735:
6736: FOR rec1 in Fetch_Jain_Line_Cur LOOP
6737:
6738: INSERT INTO JAI_PO_LINE_LOCATIONS (
6739: line_location_id, po_line_id, po_header_id,
6740: tax_modified_flag, tax_amount, total_amount,
6741: line_focus_id, creation_date, created_by,
6742: last_update_date, last_updated_by, last_update_login,
6791:
6792: OPEN Fetch_Ja_In_Po_Ln_Loc_Cur ;
6793: FETCH Fetch_Ja_In_Po_Ln_Loc_Cur INTO Fetch_Ja_In_Po_Ln_Loc_Rec;
6794:
6795: INSERT INTO JAI_PO_LINE_LOCATIONS (
6796: line_location_id, po_line_id, po_header_id,
6797: tax_modified_flag, tax_amount, total_amount, line_focus_id,
6798: creation_date, created_by, last_update_date, last_updated_by, last_update_login,
6799: tax_category_id,service_type_code -- cbabu for EnhancementBug# 2427465
6880: /* for bug 16013918 by anupgupt
6881: ln_gst_assessable_value NUMBER; --Added by Jia for GST Bug#10043656 on 2010/09/10
6882: */
6883:
6884: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
6885: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.copy_quot_taxes';
6886: ------------------------------>
6887:
6888: CURSOR tax_cur IS
6909: ORDER BY a.tax_line_no;
6910:
6911: CURSOR Fetch_Line_Focus_Id_Cur IS
6912: SELECT Line_Focus_Id
6913: FROM JAI_PO_LINE_LOCATIONS
6914: WHERE Po_Line_Id = p_po_line_id AND
6915: Line_Location_Id = p_line_loc_id;
6916:
6917: -- Start, added by Vijay Shankar for Bug# 3478460
6916:
6917: -- Start, added by Vijay Shankar for Bug# 3478460
6918: CURSOR c_line_tax_category_id_1(p_po_line_id IN NUMBER) IS
6919: SELECT tax_category_id
6920: FROM JAI_PO_LINE_LOCATIONS
6921: WHERE po_line_id = p_po_line_id
6922: AND line_location_id IS NULL;
6923:
6924: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
6922: AND line_location_id IS NULL;
6923:
6924: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
6925: SELECT tax_category_id
6926: FROM JAI_PO_LINE_LOCATIONS
6927: WHERE po_line_id = p_po_line_id
6928: AND line_location_id = p_line_location_id;
6929: -- End, 3478460
6930:
6974: are populated as in the Quotation, else Tax Amounts are populated to Zero, so that Recalculation
6975: of Taxes happen based upon precedences.
6976:
6977: 3 09/03/2004 Vijay Shankar for Bug# 3478460, FileVersion# 618.1
6978: Whenever the code doesn't fine a record for BPO Line in JAI_PO_LINE_LOCATIONS, then this procedure fails with either
6979: no_data_found or duplicate_records found. Fixed this by taking tax category from tax lines otherwise fetching from
6980: JAI_PO_LINE_LOCATIONS using the CURSORS c_line_tax_category_id_1 and c_line_tax_category_id_2
6981:
6982: 4. 17/mar-2005 Rchandan for bug#4245365 Version#115.2. base bug#4245089
6976:
6977: 3 09/03/2004 Vijay Shankar for Bug# 3478460, FileVersion# 618.1
6978: Whenever the code doesn't fine a record for BPO Line in JAI_PO_LINE_LOCATIONS, then this procedure fails with either
6979: no_data_found or duplicate_records found. Fixed this by taking tax category from tax lines otherwise fetching from
6980: JAI_PO_LINE_LOCATIONS using the CURSORS c_line_tax_category_id_1 and c_line_tax_category_id_2
6981:
6982: 4. 17/mar-2005 Rchandan for bug#4245365 Version#115.2. base bug#4245089
6983: Changes made to calculate VAT assessable value . This vat assessable is passed
6984: to the procedure that calculates the VAT related taxes
7079: CLOSE c_line_tax_category_id_2;
7080: END IF;
7081: end if;
7082:
7083: UPDATE JAI_PO_LINE_LOCATIONS
7084: SET tax_category_id = v_tax_category_id_holder
7085: WHERE line_focus_id = v_line_focus_id;
7086: -- End, 3478460
7087:
7089: -- Start, cbabu for EnhancementBug# 2427465
7090: BEGIN
7091: IF v_quot_line_loc_id = -999 THEN
7092: SELECT tax_category_id INTO v_tax_category_id_holder
7093: FROM JAI_PO_LINE_LOCATIONS
7094: WHERE po_line_id = p_frm_line_id
7095: AND (line_location_id IS NULL OR line_location_id = 0);
7096: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
7097: SELECT tax_category_id INTO v_tax_category_id_holder
7094: WHERE po_line_id = p_frm_line_id
7095: AND (line_location_id IS NULL OR line_location_id = 0);
7096: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
7097: SELECT tax_category_id INTO v_tax_category_id_holder
7098: FROM JAI_PO_LINE_LOCATIONS
7099: WHERE po_line_id = p_frm_line_id
7100: AND line_location_id = v_quot_line_loc_id;
7101: END IF;
7102:
7099: WHERE po_line_id = p_frm_line_id
7100: AND line_location_id = v_quot_line_loc_id;
7101: END IF;
7102:
7103: UPDATE JAI_PO_LINE_LOCATIONS
7104: SET tax_category_id = v_tax_category_id_holder
7105: WHERE line_focus_id = v_line_focus_id;
7106: EXCEPTION
7107: WHEN OTHERS THEN
7230: -- TYPE Uom IS TABLE OF CHAR(50) INDEX BY BINARY_INTEGER;
7231: TYPE Uom IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
7232: uom_tab uom;
7233:
7234: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
7235:
7236:
7237: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
7238:
7344:
7345: -- added by Vijay Shankar for Bug# 3487904
7346: CURSOR c_line_tax_category_id_1(p_po_line_id IN NUMBER) IS
7347: SELECT tax_category_id
7348: FROM JAI_PO_LINE_LOCATIONS
7349: WHERE po_line_id = p_po_line_id
7350: AND line_location_id IS NULL;
7351:
7352: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
7350: AND line_location_id IS NULL;
7351:
7352: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
7353: SELECT tax_category_id
7354: FROM JAI_PO_LINE_LOCATIONS
7355: WHERE po_line_id = p_po_line_id
7356: AND line_location_id = p_line_location_id;
7357: -- End, 3487904
7358:
7437: 5 20/10/2003 Vijay Shankar for Bug# 3205861, FileVersion# 616.3
7438: because UOM_CODE plsql table is defined as CHAR(50), all the values in plsql table is being padded with spaces.
7439:
7440: 6 05/03/2004 Vijay Shankar for Bug# 3487904, FileVersion# 618.1
7441: Whenever the code doesn't fine a record for BPO Line in JAI_PO_LINE_LOCATIONS, then this procedure fails with either
7442: no_data_found or duplicate_records found. Fixed this by taking tax category from tax lines otherwise fetching from
7443: JAI_PO_LINE_LOCATIONS using the CURSORS c_line_tax_category_id_1 and c_line_tax_category_id_2
7444:
7445: 7. 17/mar-2005 Rchandan for bug#4245365 Version#115.2. base bug#4245089
7439:
7440: 6 05/03/2004 Vijay Shankar for Bug# 3487904, FileVersion# 618.1
7441: Whenever the code doesn't fine a record for BPO Line in JAI_PO_LINE_LOCATIONS, then this procedure fails with either
7442: no_data_found or duplicate_records found. Fixed this by taking tax category from tax lines otherwise fetching from
7443: JAI_PO_LINE_LOCATIONS using the CURSORS c_line_tax_category_id_1 and c_line_tax_category_id_2
7444:
7445: 7. 17/mar-2005 Rchandan for bug#4245365 Version#115.2. base bug#4245089
7446: Changes made to calculate VAT assessable value . This vat assessable is passed
7447: to the procedure that calculates the VAT related taxes
7733: OPEN Fetch_Tot_Sum_Cur( v_line_loc_id );
7734: FETCH Fetch_Tot_Sum_Cur INTO v_tax_amt1;
7735: CLOSE Fetch_Tot_Sum_Cur;
7736:
7737: UPDATE JAI_PO_LINE_LOCATIONS
7738: SET Tax_Amount = v_tax_amt1,
7739: Total_Amount = NVL( v_qty * v_temp_price, 0 ) + v_tax_amt1 ,
7740: Last_Update_Date = p_last_cre_dt,
7741: Last_Updated_By = p_last_cre_by,
7912: CLOSE c_line_tax_category_id_2;
7913: END IF;
7914: end if;
7915:
7916: UPDATE JAI_PO_LINE_LOCATIONS
7917: SET tax_category_id = v_tax_category_id_holder
7918: WHERE line_focus_id = p_seq_val;
7919: -- End, 3487904
7920:
7922: -- Start, cbabu for EnhancementBug# 2427465
7923: BEGIN
7924: IF v_line_loc_id = -999 THEN
7925: SELECT tax_category_id INTO v_tax_category_id_holder
7926: FROM JAI_PO_LINE_LOCATIONS
7927: WHERE po_line_id = v_po_line_id
7928: AND (line_location_id IS NULL OR line_location_id = 0);
7929: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
7930: SELECT tax_category_id INTO v_tax_category_id_holder
7927: WHERE po_line_id = v_po_line_id
7928: AND (line_location_id IS NULL OR line_location_id = 0);
7929: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
7930: SELECT tax_category_id INTO v_tax_category_id_holder
7931: FROM JAI_PO_LINE_LOCATIONS
7932: WHERE po_line_id = v_po_line_id
7933: AND line_location_id = v_line_loc_id;
7934: END IF;
7935:
7932: WHERE po_line_id = v_po_line_id
7933: AND line_location_id = v_line_loc_id;
7934: END IF;
7935:
7936: UPDATE JAI_PO_LINE_LOCATIONS
7937: SET tax_category_id = v_tax_category_id_holder
7938: WHERE line_focus_id = p_seq_val;
7939: EXCEPTION
7940: WHEN OTHERS THEN
8157: /* for bug 16013918 by anupgupt
8158: ln_gst_assessable_value NUMBER; --Added by Jia for GST Bug#10043656 on 2010/09/10
8159: */
8160:
8161: v_tax_category_id JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
8162: v_tax_category_id_dflt JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
8163:
8164: CURSOR Fetch_UOMCode_Cur IS
8165: SELECT Uom_Code
8158: ln_gst_assessable_value NUMBER; --Added by Jia for GST Bug#10043656 on 2010/09/10
8159: */
8160:
8161: v_tax_category_id JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
8162: v_tax_category_id_dflt JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
8163:
8164: CURSOR Fetch_UOMCode_Cur IS
8165: SELECT Uom_Code
8166: FROM Mtl_Units_Of_Measure
8167: WHERE Unit_Of_Measure = v_uom_measure;
8168:
8169: CURSOR Fetch_Focus_Id_Cur IS
8170: SELECT Line_Focus_Id
8171: FROM JAI_PO_LINE_LOCATIONS
8172: WHERE Po_Line_Id = v_po_line_id
8173: AND Line_Location_Id IS NULL;
8174:
8175: CURSOR Fetch_Focus1_Id_Cur IS
8173: AND Line_Location_Id IS NULL;
8174:
8175: CURSOR Fetch_Focus1_Id_Cur IS
8176: SELECT Line_Focus_Id
8177: FROM JAI_PO_LINE_LOCATIONS
8178: WHERE Po_Line_Id = v_po_line_id
8179: AND Line_Location_Id = v_line_loc_id;
8180:
8181: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
8219:
8220: -- Start, added by Vijay Shankar for Bug# 3466223
8221: CURSOR c_line_tax_category_id_1(p_po_line_id IN NUMBER) IS
8222: SELECT tax_category_id
8223: FROM JAI_PO_LINE_LOCATIONS
8224: WHERE po_line_id = p_po_line_id
8225: AND line_location_id IS NULL;
8226:
8227: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
8225: AND line_location_id IS NULL;
8226:
8227: CURSOR c_line_tax_category_id_2(p_po_line_id IN NUMBER, p_line_location_id IN NUMBER) IS
8228: SELECT tax_category_id
8229: FROM JAI_PO_LINE_LOCATIONS
8230: WHERE po_line_id = p_po_line_id
8231: AND line_location_id = p_line_location_id;
8232: -- End, Vijay Shankar for Bug# 3466223
8233: --Start,Added the following for forward porting to R12 kundan kumar
8504: CLOSE c_line_tax_category_id_2;
8505: END IF;
8506: END IF;
8507:
8508: UPDATE JAI_PO_LINE_LOCATIONS
8509: SET tax_category_id = v_tax_category_id_dflt
8510: WHERE line_focus_id = v_seq_val;
8511: -- End, Vijay Shankar for Bug# 3466223
8512:
8514: -- Start, cbabu for EnhancementBug# 2427465
8515: BEGIN
8516: IF v_frm_line_loc_id IS NOT NULL THEN
8517: SELECT tax_category_id INTO v_tax_category_id_dflt
8518: FROM JAI_PO_LINE_LOCATIONS
8519: WHERE line_location_id = v_frm_line_loc_id;
8520: ELSE
8521: SELECT tax_category_id INTO v_tax_category_id_dflt
8522: FROM JAI_PO_LINE_LOCATIONS
8518: FROM JAI_PO_LINE_LOCATIONS
8519: WHERE line_location_id = v_frm_line_loc_id;
8520: ELSE
8521: SELECT tax_category_id INTO v_tax_category_id_dflt
8522: FROM JAI_PO_LINE_LOCATIONS
8523: WHERE po_line_id = v_frm_po_line_id
8524: AND (line_location_id IS NULL OR line_location_id = 0);
8525: END IF;
8526:
8523: WHERE po_line_id = v_frm_po_line_id
8524: AND (line_location_id IS NULL OR line_location_id = 0);
8525: END IF;
8526:
8527: UPDATE JAI_PO_LINE_LOCATIONS
8528: SET tax_category_id = v_tax_category_id_dflt
8529: WHERE line_focus_id = v_seq_val;
8530:
8531: EXCEPTION
8556: OPEN Fetch_Sum_Cur( v_seq_val );
8557: FETCH Fetch_Sum_Cur INTO v_tax_amt;
8558: CLOSE Fetch_Sum_Cur;
8559:
8560: UPDATE JAI_PO_LINE_LOCATIONS
8561: SET Tax_Amount = NVL( v_tax_amt, 0 ),
8562: Total_Amount = NVL( ( v_qty * v_price ), 0 ) + Tax_Amount,
8563: Last_Updated_By = v_last_upd_by,
8564: Last_Update_Date = v_last_upd_dt,
8566: WHERE Line_Focus_id = v_seq_val;
8567:
8568: ELSE
8569:
8570: UPDATE JAI_PO_LINE_LOCATIONS
8571: SET Tax_Amount = NULL,
8572: Total_Amount = NULL,
8573: Last_Updated_By = v_last_upd_by,
8574: Last_Update_Date = v_last_upd_dt,
8664: WHERE Unit_Of_Measure = v_uom_measure;
8665:
8666: CURSOR Fetch_Focus_Id IS
8667: SELECT Line_Focus_Id
8668: FROM JAI_PO_LINE_LOCATIONS
8669: WHERE Po_Line_Id = v_po_line_id
8670: AND Po_Header_Id = v_po_hdr_id
8671: AND Line_Location_Id IS NULL;
8672:
8671: AND Line_Location_Id IS NULL;
8672:
8673: CURSOR Fetch_Focus1_Id IS
8674: SELECT Line_Focus_Id
8675: FROM JAI_PO_LINE_LOCATIONS
8676: WHERE Po_Line_Id = v_po_line_id
8677: AND Po_Header_Id = v_po_hdr_id
8678: AND Line_Location_Id = v_line_loc_id;
8679:
8755: DELETE Jai_Po_Taxes
8756: WHERE Po_Line_Id = v_po_line_id
8757: AND NVL( Line_Location_Id, 0 ) = NVL( v_line_loc_id, 0 ); /* Replaced -999 with 0 - Bug 6012541 */
8758:
8759: UPDATE Jai_Po_Line_Locations
8760: SET Tax_Amount = NULL,
8761: Total_Amount = NULL,
8762: Last_Updated_By = fnd_global.user_id,
8763: Last_Update_Date = sysdate,
8932: Last_Update_Login = v_last_upd_login
8933: WHERE Po_Line_Id = v_po_line_id
8934: AND Line_Location_Id = v_line_loc_id;
8935:
8936: UPDATE JAI_PO_LINE_LOCATIONS
8937: SET Tax_Amount = NULL,
8938: Total_Amount = NULL,
8939: Last_Updated_By = v_last_upd_by,
8940: Last_Update_Date = v_last_upd_dt,
8952: Last_Update_Login = v_last_upd_login
8953: WHERE Po_Line_Id = v_po_line_id
8954: AND Line_Location_Id IS NULL;
8955:
8956: UPDATE JAI_PO_LINE_LOCATIONS
8957: SET Tax_Amount = NULL,
8958: Total_Amount = NULL,
8959: Last_Updated_By = v_last_upd_by,
8960: Last_Update_Date = v_last_upd_dt,
8974: OPEN Fetch_Sum_Cur;
8975: FETCH Fetch_Sum_Cur INTO v_tax_amt;
8976: CLOSE Fetch_Sum_Cur;
8977:
8978: UPDATE JAI_PO_LINE_LOCATIONS
8979: SET Tax_Amount = nvl(v_tax_amt,0),
8980: Total_Amount = NVL( ( v_qty * v_price ), 0 ) + nvl(v_tax_amt,0),
8981: Last_Updated_By = v_last_upd_by,
8982: Last_Update_Date = v_last_upd_dt,