[Home] [Help]
102: -- p_set_of_books_id => v_gl_set_of_bks_id) = FALSE THEN
103: -- RETURN;
104: -- END IF;
105:
106: DELETE FROM JAI_PO_LINE_LOCATIONS
107: WHERE Line_Location_Id = v_po_line_loc_id;
108:
109: DELETE FROM JAI_PO_TAXES
110: WHERE Line_Location_Id = v_po_line_loc_id;
233: ORDER BY a.tax_line_no;
234:
235: CURSOR Fetch_Line_Focus_Id_Cur IS
236: SELECT Line_Focus_Id
237: FROM JAI_PO_LINE_LOCATIONS
238: WHERE Po_Line_Id = v_po_line_id
239: AND Line_Location_Id = v_line_loc_id;
240:
241: CURSOR Fetch_UOMCode_Cur( v_temp_uom IN VARCHAR2 ) IS
244: WHERE Unit_Of_Measure = v_temp_uom;
245:
246: CURSOR Fetch_Count_Cur IS
247: SELECT COUNT(Line_Location_Id)
248: FROM JAI_PO_LINE_LOCATIONS
249: WHERE Po_Header_Id = v_quot_from_hdr_id;
250:
251: -- Vijay Shankar for Bug# 3184418
252: v_tax_modified_flag CHAR(1);
251: -- Vijay Shankar for Bug# 3184418
252: v_tax_modified_flag CHAR(1);
253: CURSOR c_tax_modified_flag(p_line_location_id IN NUMBER) IS
254: SELECT tax_modified_flag
255: FROM JAI_PO_LINE_LOCATIONS
256: WHERE line_location_id = p_line_location_id;
257:
258: v_hook_value VARCHAR2(10);
259: BEGIN
821: line_location_id = v_line_loc_id AND
822: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */
823:
824: cur_rec_get_total REC_CALC_TOTAL_TAX%ROWTYPE;
825: l_total_tax_amount JAI_PO_LINE_LOCATIONS.TAX_AMOUNT%TYPE;
826:
827: -- END of bug 3037284
828:
829: CURSOR check_rfq_quot_cur
868: IS
869: SELECT
870: NVL( Tax_Modified_Flag, 'N' )
871: FROM
872: JAI_PO_LINE_LOCATIONS
873: WHERE
874: Po_Line_Id = v_po_line_id AND
875: Line_Location_Id = v_line_loc_id;
876:
902: IS
903: SELECT
904: nvl(1,0)
905: FROM
906: JAI_PO_LINE_LOCATIONS
907: WHERE
908: po_line_id = v_po_line_id AND
909: Line_Location_Id = v_line_loc_id;
910:
981: ------------------------------------------------------------------------------------------
982: 1. 14/08/2003 Aiyer , Bug #3037284 ,File version 616.1
983: Changed the triggering condition to fire when cancel_flag is 'Y'.
984: In case of full cancellation of a Purchase order line (no receipt done),
985: the lines from JAI_PO_TAXES and JAI_PO_LINE_LOCATIONS are deleted.
986: In case of partial cancellation of purchase order line, apportion the tax amount
987: in the ratio of quantity_received to original line quantity i.e quantity_received/quantity
988: in table JAI_PO_TAXES.
989: Calculate the tax_amount in the table JAI_PO_LINE_LOCATIONS as a sum of all records
985: the lines from JAI_PO_TAXES and JAI_PO_LINE_LOCATIONS are deleted.
986: In case of partial cancellation of purchase order line, apportion the tax amount
987: in the ratio of quantity_received to original line quantity i.e quantity_received/quantity
988: in table JAI_PO_TAXES.
989: Calculate the tax_amount in the table JAI_PO_LINE_LOCATIONS as a sum of all records
990: in the table JAI_PO_TAXES for that line_locations_id excluding 'TDS'
991: type of taxes.
992: The total amount in JAI_PO_LINE_LOCATIONS is calculated as
993: (po_line_locations_all.quantity_received * po_line_locations_all.price_override)
988: in table JAI_PO_TAXES.
989: Calculate the tax_amount in the table JAI_PO_LINE_LOCATIONS as a sum of all records
990: in the table JAI_PO_TAXES for that line_locations_id excluding 'TDS'
991: type of taxes.
992: The total amount in JAI_PO_LINE_LOCATIONS is calculated as
993: (po_line_locations_all.quantity_received * po_line_locations_all.price_override)
994: +
995: sum of all taxes from JAI_PO_TAXES for that line_location_id .
996:
1301: IF nvl(pr_old.cancel_flag,'N') <> 'Y' AND nvl(pr_new.cancel_flag,'N') = 'Y' THEN
1302: IF nvl(v_quantity_cancelled,-9999) = nvl(v_qty,0) THEN
1303: /*
1304: Indicating that the entire line has been cancelled and no receipt has been made for ths line,
1305: then delete the line and associated taxes from JAI_PO_LINE_LOCATIONS
1306: and JAI_PO_TAXES and return .
1307: */
1308: DELETE
1309: JAI_PO_TAXES
1312: po_line_id = v_po_line_id AND
1313: po_header_id = v_po_hdr_id;
1314:
1315: DELETE
1316: JAI_PO_LINE_LOCATIONS
1317: WHERE
1318: po_line_id = v_po_line_id AND
1319: po_header_id = v_po_hdr_id AND
1320: line_location_id = v_line_loc_id;
1322: ELSIF nvl(v_quantity_cancelled,-9999) < nvl(v_qty,0) THEN
1323: /*
1324: Indicating that a partial receipt has been made for the line and then the line has been cancelled.
1325: In such a case the cancelled quantity would be lesser than the quantity in table po_line_locations_all.
1326: Now in this scenario update the line and the associated apportioned taxes in the table JAI_PO_LINE_LOCATIONS
1327: and JAI_PO_TAXES
1328: */
1329:
1330: /*
1359: FETCH rec_calc_total_tax INTO l_total_tax_amount;
1360: CLOSE rec_calc_total_tax;
1361:
1362: UPDATE
1363: JAI_PO_LINE_LOCATIONS
1364: SET
1365: tax_amount = l_total_tax_amount ,
1366: total_amount = nvl(pr_new.quantity_received * pr_new.price_override, 0) + nvl(l_total_tax_amount,0)
1367: WHERE
1628: DELETE FROM JAI_PO_TAXES
1629: WHERE Po_Line_Id = v_po_line_id
1630: AND NVL( Line_Location_Id, - 999 ) = NVL( v_line_loc_id, -999 );
1631:
1632: DELETE FROM JAI_PO_LINE_LOCATIONS
1633: WHERE Po_Line_Id = v_po_line_id
1634: AND NVL( Line_Location_Id, - 999 ) = NVL( v_line_loc_id, -999 );
1635:
1636: x := v_line_loc_id;
1739: ELSE
1740: v_tot_amt := v_tax_amt + ( v_qty * v_price );
1741: END IF;
1742:
1743: UPDATE JAI_PO_LINE_LOCATIONS
1744: SET Tax_Amount = v_tax_amt,
1745: Total_Amount = v_tot_amt,
1746: Last_Updated_By = v_last_upd_by,
1747: Last_Update_Date = v_last_upd_dt,