431: (-l_set_id
432: ,p_selected_line_tbl(I).id1
433: ,0
434: ,sysdate
435: ,FND_GLOBAL.USER_ID
436: ,sysdate
437: ,FND_GLOBAL.USER_ID
438: ,FND_GLOBAL.LOGIN_ID
439: ,I --10241113
433: ,0
434: ,sysdate
435: ,FND_GLOBAL.USER_ID
436: ,sysdate
437: ,FND_GLOBAL.USER_ID
438: ,FND_GLOBAL.LOGIN_ID
439: ,I --10241113
440: );
441: END LOOP;
434: ,sysdate
435: ,FND_GLOBAL.USER_ID
436: ,sysdate
437: ,FND_GLOBAL.USER_ID
438: ,FND_GLOBAL.LOGIN_ID
439: ,I --10241113
440: );
441: END LOOP;
442:
518: LOOP
519: Update Oe_Rsv_Set_Details
520: SET Corrected_Qty = p_sch_line_tbl(I).corrected_qty,
521: Corrected_Qty2 = p_sch_line_tbl(I).corrected_qty2, -- INVCONV
522: last_update_login = FND_GLOBAL.LOGIN_ID,
523: last_updated_by = FND_GLOBAL.USER_ID,
524: last_update_date = sysdate
525: WHERE Reservation_set_id = l_set_id
526: AND Line_Id = p_sch_line_tbl(I).line_id;
519: Update Oe_Rsv_Set_Details
520: SET Corrected_Qty = p_sch_line_tbl(I).corrected_qty,
521: Corrected_Qty2 = p_sch_line_tbl(I).corrected_qty2, -- INVCONV
522: last_update_login = FND_GLOBAL.LOGIN_ID,
523: last_updated_by = FND_GLOBAL.USER_ID,
524: last_update_date = sysdate
525: WHERE Reservation_set_id = l_set_id
526: AND Line_Id = p_sch_line_tbl(I).line_id;
527: