APPS.OE_DROP_SHIP_PVT dependencies on SO_LINE_DETAILS

Line 172: FROM so_line_details

168: v_detail_id NUMBER := -1;
169:
170: CURSOR details IS
171: SELECT line_detail_id
172: FROM so_line_details
173: WHERE line_id = p_line_id;
174:
175: L_API_Name Constant Varchar2(30) := 'GET_DROP_SHIP_PVT';
176: L_API_Version Constant Number := 1.0;

Line 204: UPDATE so_line_details

200: End;
201:
202: Begin
203:
204: UPDATE so_line_details
205: SET quantity = v_schedule_qty,
206: revision = NULL,
207: lot_number = NULL,
208: subinventory = NULL,

Line 221: DELETE FROM so_line_details

217: End;
218:
219: Begin
220:
221: DELETE FROM so_line_details
222: WHERE line_id = p_line_id
223: AND line_detail_id <> v_detail_id;
224: Exception
225: When no_data_found then null;