417: (-l_set_id
418: ,p_selected_line_tbl(I).id1
419: ,0
420: ,sysdate
421: ,FND_GLOBAL.USER_ID
422: ,sysdate
423: ,FND_GLOBAL.USER_ID
424: ,FND_GLOBAL.LOGIN_ID
425: );
419: ,0
420: ,sysdate
421: ,FND_GLOBAL.USER_ID
422: ,sysdate
423: ,FND_GLOBAL.USER_ID
424: ,FND_GLOBAL.LOGIN_ID
425: );
426: END LOOP;
427:
420: ,sysdate
421: ,FND_GLOBAL.USER_ID
422: ,sysdate
423: ,FND_GLOBAL.USER_ID
424: ,FND_GLOBAL.LOGIN_ID
425: );
426: END LOOP;
427:
428: END IF;
503: LOOP
504: Update Oe_Rsv_Set_Details
505: SET Corrected_Qty = p_sch_line_tbl(I).corrected_qty,
506: Corrected_Qty2 = p_sch_line_tbl(I).corrected_qty2, -- INVCONV
507: last_update_login = FND_GLOBAL.LOGIN_ID,
508: last_updated_by = FND_GLOBAL.USER_ID,
509: last_update_date = sysdate
510: WHERE Reservation_set_id = l_set_id
511: AND Line_Id = p_sch_line_tbl(I).line_id;
504: Update Oe_Rsv_Set_Details
505: SET Corrected_Qty = p_sch_line_tbl(I).corrected_qty,
506: Corrected_Qty2 = p_sch_line_tbl(I).corrected_qty2, -- INVCONV
507: last_update_login = FND_GLOBAL.LOGIN_ID,
508: last_updated_by = FND_GLOBAL.USER_ID,
509: last_update_date = sysdate
510: WHERE Reservation_set_id = l_set_id
511: AND Line_Id = p_sch_line_tbl(I).line_id;
512: