[Home] [Help]
32495: IF c4%ROWCOUNT > 0 THEN
32496: v_sql_stmt := 15.1;
32497: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32498: UPDATE msc_st_sales_orders
32499: SET ship_set_id = msc_st_set_id_s.NEXTVAL
32500: WHERE rowid = lb_rowid(j)
32501: AND ship_set_id is null;
32502:
32503: v_sql_stmt := 15.2;
32597: IF c5%ROWCOUNT > 0 THEN
32598: v_sql_stmt := 16.1;
32599: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32600: UPDATE msc_st_sales_orders
32601: SET arrival_set_id = msc_st_set_id_s.NEXTVAL
32602: WHERE rowid = lb_rowid(j)
32603: AND arrival_set_id is null;
32604:
32605: v_sql_stmt := 16.2;